VLCC Historical AIS + Multiple CSV Uploads

‍

We have new improvements that allow you to do studies on our curated AIS historical data.  These historical AIS data are some of the most important for trading as they are a major component of arb values.  

We have also made it possible to upload multiple CSV files. This means that you can run the most advanced studies on SQL/Python automatically on any CSV data.

‍

‍

Today we ask Darling to provide a simple study to determine the daily number of VLCCs in ballast heading to Singapore with a 10d SMA calculation.

‍

Ask Darling

‍

‍ “Plot the daily sum of the number of VLCCs in ballast heading to Singapore. Only consider vessels over 10 kts speed. Use the data for the last 7 months, run a 10d SMA on the study as well.”

‍

VLCC Ballast Traffic to Singapore (Jan-Jul 2025)

‍

• Peak: May 3 = 53 vessels | 10d SMA peaked 47.4 on May 5
• Range: 23-53 daily | Avg speed: 12.6 kts (10.1-17.4 range)
• Low: Feb 9 = 23 vessels | 10d SMA bottomed 28.7 on Feb 10
• Trend: Early May surge = significant anomaly → sustained high traffic period

Analysis of VLCC Traffic to Singapore

‍

The analysis examined daily counts of Very Large Crude Carriers (VLCCs) in ballast heading to Singapore over the last 7 months (January 1 - July 22, 2025), filtering for vessels traveling over 10 knots speed.

‍

SQL Query Results

‍

The SQL query successfully filtered the data according to the specified criteria:

• Date Range: Covered 203 unique days from January 1, 2025, to July 22, 2025
• Vessel Type: Correctly identified VLCC vessels using vessel sub-sub-type classification
• Ballast Status: Filtered for vessels in ballast condition only
• Speed: Included only vessels traveling over 10 knots (range: 10.1-17.4 knots, average ~12.55 knots)
• Destination: Focused on Singapore with 4,886 out of 5,366 records showing "SINGAPORE; SINGAPORE; SOUTH-EASTERN ASIA; ASIA" as destination

The raw dataset contained 5,366 records with vessel counts ranging from 1-6 vessels per specific group combination, totaling 605 vessel observations across all records.

‍

‍

Python Analysis and 10-Day SMA

‍

The Python code performed crucial data processing:

1. Daily Aggregation: Summed vessel counts by date to create true daily totals
2. Complete Timeline: Filled gaps with zero counts for days with no qualifying vessel traffic
3. 10-Day SMA Calculation: Applied rolling average to smooth daily fluctuations and identify trends

‍

Key Traffic Patterns

‍

The analysis revealed significant variations in VLCC traffic:

• Peak Activity: May 3, 2025 recorded the highest daily count with 53 vessels
• Sustained High Period: The 10-day SMA peaked at 47.4 vessels on May 5, 2025, indicating early May as a period of exceptionally high traffic
• Lowest Activity: February 9, 2025 saw only 23 vessels, contributing to the minimum 10-day SMA of 28.7 vessels on February 10, 2025
• Trend Correlation: The moderate correlation (0.45) between daily counts and 10-day SMA reflects expected smoothing effects while maintaining trend visibility

The early May 2025 surge represents a notable anomaly in the traffic pattern, suggesting potential market dynamics or operational factors driving increased VLCC movements to Singapore during that period.