PREVIEW / futures_30min / 2025-01-17
file: by_date/futures_30min/2025/2025-01-17.parquet size: 92 KB rows: 3,157
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2025-01-17 00:00:00 | ES | Futures | 6138.71 | 6140.24 | 6138.19 | 6140.24 | 1378.0 |
| 2025-01-17 00:30:00 | ES | Futures | 6140.5 | 6141.78 | 6137.17 | 6139.22 | 2468.0 |
| 2025-01-17 01:00:00 | ES | Futures | 6139.22 | 6139.22 | 6136.14 | 6137.68 | 2061.0 |
| 2025-01-17 01:30:00 | ES | Futures | 6137.68 | 6140.5 | 6135.63 | 6137.17 | 1835.0 |
| 2025-01-17 02:00:00 | ES | Futures | 6137.42 | 6137.94 | 6133.06 | 6133.83 | 3167.0 |
| 2025-01-17 02:30:00 | ES | Futures | 6133.83 | 6137.42 | 6129.48 | 6136.4 | 3134.0 |
| 2025-01-17 03:00:00 | ES | Futures | 6136.14 | 6139.99 | 6135.63 | 6137.94 | 5253.0 |
| 2025-01-17 03:30:00 | ES | Futures | 6137.94 | 6144.6 | 6137.94 | 6143.32 | 3988.0 |
| 2025-01-17 04:00:00 | ES | Futures | 6143.32 | 6152.04 | 6142.29 | 6150.5 | 7855.0 |
| 2025-01-17 04:30:00 | ES | Futures | 6150.75 | 6150.75 | 6146.65 | 6148.19 | 4318.0 |
| 2025-01-17 05:00:00 | ES | Futures | 6148.19 | 6151.52 | 6145.11 | 6147.93 | 3633.0 |
| 2025-01-17 05:30:00 | ES | Futures | 6147.93 | 6149.22 | 6145.11 | 6147.68 | 4234.0 |
| 2025-01-17 06:00:00 | ES | Futures | 6147.68 | 6151.78 | 6147.68 | 6151.01 | 3036.0 |
| 2025-01-17 06:30:00 | ES | Futures | 6151.01 | 6153.83 | 6145.63 | 6146.91 | 6774.0 |
| 2025-01-17 07:00:00 | ES | Futures | 6146.91 | 6152.04 | 6142.81 | 6150.24 | 7603.0 |
| 2025-01-17 07:30:00 | ES | Futures | 6150.5 | 6151.52 | 6145.37 | 6149.73 | 6139.0 |
| 2025-01-17 08:00:00 | ES | Futures | 6149.73 | 6166.65 | 6149.47 | 6164.6 | 22131.0 |
| 2025-01-17 08:30:00 | ES | Futures | 6164.6 | 6174.85 | 6164.6 | 6172.55 | 43252.0 |
| 2025-01-17 09:00:00 | ES | Futures | 6172.55 | 6189.47 | 6172.29 | 6180.49 | 79782.0 |
| 2025-01-17 09:30:00 | ES | Futures | 6180.49 | 6184.08 | 6166.14 | 6174.09 | 192578.0 |
| 2025-01-17 10:00:00 | ES | Futures | 6173.83 | 6186.9 | 6171.27 | 6181.26 | 119896.0 |
| 2025-01-17 10:30:00 | ES | Futures | 6181.26 | 6193.57 | 6179.21 | 6193.06 | 88854.0 |
| 2025-01-17 11:00:00 | ES | Futures | 6193.06 | 6203.31 | 6188.96 | 6199.47 | 76982.0 |
| 2025-01-17 11:30:00 | ES | Futures | 6199.72 | 6201.77 | 6192.54 | 6194.85 | 61203.0 |
| 2025-01-17 12:00:00 | ES | Futures | 6194.6 | 6202.54 | 6189.72 | 6201.77 | 48677.0 |
| 2025-01-17 12:30:00 | ES | Futures | 6201.77 | 6203.31 | 6197.16 | 6201.0 | 38780.0 |
| 2025-01-17 13:00:00 | ES | Futures | 6201.0 | 6205.88 | 6197.42 | 6202.54 | 41500.0 |
| 2025-01-17 13:30:00 | ES | Futures | 6202.8 | 6203.57 | 6193.83 | 6197.93 | 54602.0 |
| 2025-01-17 14:00:00 | ES | Futures | 6197.93 | 6199.72 | 6192.29 | 6196.39 | 48465.0 |
| 2025-01-17 14:30:00 | ES | Futures | 6196.39 | 6198.95 | 6191.52 | 6193.83 | 39210.0 |
| 2025-01-17 15:00:00 | ES | Futures | 6193.83 | 6196.39 | 6186.39 | 6192.54 | 63475.0 |
| 2025-01-17 15:30:00 | ES | Futures | 6192.54 | 6197.67 | 6184.85 | 6186.9 | 159176.0 |
| 2025-01-17 16:00:00 | ES | Futures | 6187.16 | 6187.93 | 6182.8 | 6184.85 | 43379.0 |
| 2025-01-17 16:30:00 | ES | Futures | 6184.85 | 6186.9 | 6183.57 | 6186.39 | 5601.0 |
| 2025-01-17 00:00:00 | NQ | Futures | 21915.13 | 21925.68 | 21913.84 | 21924.91 | 945.0 |
| 2025-01-17 00:30:00 | NQ | Futures | 21924.65 | 21935.97 | 21915.9 | 21924.65 | 1625.0 |
| 2025-01-17 01:00:00 | NQ | Futures | 21923.88 | 21924.91 | 21910.75 | 21918.22 | 1171.0 |
| 2025-01-17 01:30:00 | NQ | Futures | 21919.25 | 21931.34 | 21902.52 | 21914.36 | 1570.0 |
| 2025-01-17 02:00:00 | NQ | Futures | 21914.36 | 21918.73 | 21892.74 | 21897.63 | 2159.0 |
| 2025-01-17 02:30:00 | NQ | Futures | 21897.11 | 21906.12 | 21876.27 | 21901.23 | 2154.0 |
| 2025-01-17 03:00:00 | NQ | Futures | 21900.97 | 21915.9 | 21897.11 | 21912.3 | 2515.0 |
| 2025-01-17 03:30:00 | NQ | Futures | 21911.53 | 21947.81 | 21909.98 | 21940.86 | 2779.0 |
| 2025-01-17 04:00:00 | NQ | Futures | 21940.86 | 21984.35 | 21935.2 | 21979.47 | 4885.0 |
| 2025-01-17 04:30:00 | NQ | Futures | 21979.21 | 21980.24 | 21961.45 | 21970.46 | 2297.0 |
| 2025-01-17 05:00:00 | NQ | Futures | 21970.97 | 21981.27 | 21950.9 | 21962.99 | 2895.0 |
| 2025-01-17 05:30:00 | NQ | Futures | 21962.22 | 21971.23 | 21952.7 | 21961.19 | 2292.0 |
| 2025-01-17 06:00:00 | NQ | Futures | 21961.45 | 21982.04 | 21961.45 | 21976.12 | 1987.0 |
| 2025-01-17 06:30:00 | NQ | Futures | 21976.63 | 21990.02 | 21947.04 | 21955.53 | 3672.0 |
| 2025-01-17 07:00:00 | NQ | Futures | 21955.27 | 21979.47 | 21932.89 | 21975.6 | 4933.0 |
| 2025-01-17 07:30:00 | NQ | Futures | 21975.6 | 21980.75 | 21955.27 | 21972.26 | 2973.0 |
> showing 50 of 3,157 rows — these rows as CSV