PREVIEW / futures_30min / 2025-06-27
file: by_date/futures_30min/2025/2025-06-27.parquet size: 90 KB rows: 3,095
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-06-27 00:00:00 | ES | Futures | 6248.51 | 6248.76 | 6246.49 | 6247.5 | 1381.0 |
| 2025-06-27 00:30:00 | ES | Futures | 6247.5 | 6248.76 | 6246.49 | 6246.49 | 1173.0 |
| 2025-06-27 01:00:00 | ES | Futures | 6246.49 | 6249.26 | 6246.24 | 6248.0 | 1572.0 |
| 2025-06-27 01:30:00 | ES | Futures | 6248.0 | 6252.54 | 6248.0 | 6250.77 | 2359.0 |
| 2025-06-27 02:00:00 | ES | Futures | 6250.77 | 6255.56 | 6250.02 | 6254.55 | 4763.0 |
| 2025-06-27 02:30:00 | ES | Futures | 6254.55 | 6260.6 | 6254.55 | 6257.57 | 6643.0 |
| 2025-06-27 03:00:00 | ES | Futures | 6257.32 | 6261.6 | 6255.06 | 6259.84 | 5064.0 |
| 2025-06-27 03:30:00 | ES | Futures | 6259.59 | 6259.59 | 6255.06 | 6256.57 | 4317.0 |
| 2025-06-27 04:00:00 | ES | Futures | 6256.82 | 6259.09 | 6254.55 | 6255.31 | 5390.0 |
| 2025-06-27 04:30:00 | ES | Futures | 6255.31 | 6258.83 | 6255.06 | 6258.58 | 3337.0 |
| 2025-06-27 05:00:00 | ES | Futures | 6258.58 | 6259.09 | 6254.3 | 6256.57 | 3237.0 |
| 2025-06-27 05:30:00 | ES | Futures | 6256.57 | 6257.07 | 6253.8 | 6257.07 | 4835.0 |
| 2025-06-27 06:00:00 | ES | Futures | 6257.07 | 6257.57 | 6253.8 | 6254.8 | 4083.0 |
| 2025-06-27 06:30:00 | ES | Futures | 6255.06 | 6256.57 | 6254.55 | 6256.32 | 2617.0 |
| 2025-06-27 07:00:00 | ES | Futures | 6256.06 | 6261.35 | 6255.81 | 6260.09 | 5380.0 |
| 2025-06-27 07:30:00 | ES | Futures | 6260.09 | 6265.38 | 6259.84 | 6264.88 | 6057.0 |
| 2025-06-27 08:00:00 | ES | Futures | 6265.13 | 6267.4 | 6259.34 | 6262.61 | 11145.0 |
| 2025-06-27 08:30:00 | ES | Futures | 6262.61 | 6262.86 | 6255.06 | 6256.06 | 17564.0 |
| 2025-06-27 09:00:00 | ES | Futures | 6255.81 | 6256.57 | 6250.52 | 6250.52 | 18294.0 |
| 2025-06-27 09:30:00 | ES | Futures | 6250.77 | 6268.15 | 6248.51 | 6264.88 | 87142.0 |
| 2025-06-27 10:00:00 | ES | Futures | 6265.13 | 6276.72 | 6265.13 | 6270.67 | 101305.0 |
| 2025-06-27 10:30:00 | ES | Futures | 6270.67 | 6277.47 | 6267.4 | 6269.41 | 75608.0 |
| 2025-06-27 11:00:00 | ES | Futures | 6269.41 | 6275.21 | 6267.4 | 6274.7 | 43882.0 |
| 2025-06-27 11:30:00 | ES | Futures | 6274.95 | 6282.76 | 6274.45 | 6280.75 | 49065.0 |
| 2025-06-27 12:00:00 | ES | Futures | 6280.75 | 6285.28 | 6278.48 | 6285.03 | 43327.0 |
| 2025-06-27 12:30:00 | ES | Futures | 6285.03 | 6285.78 | 6277.98 | 6281.5 | 44242.0 |
| 2025-06-27 13:00:00 | ES | Futures | 6281.25 | 6281.5 | 6274.2 | 6275.71 | 38980.0 |
| 2025-06-27 13:30:00 | ES | Futures | 6275.71 | 6277.47 | 6253.8 | 6263.12 | 113381.0 |
| 2025-06-27 14:00:00 | ES | Futures | 6263.12 | 6265.38 | 6244.48 | 6244.48 | 83476.0 |
| 2025-06-27 14:30:00 | ES | Futures | 6244.73 | 6247.5 | 6229.62 | 6233.65 | 122160.0 |
| 2025-06-27 15:00:00 | ES | Futures | 6233.65 | 6249.26 | 6231.63 | 6245.74 | 75185.0 |
| 2025-06-27 15:30:00 | ES | Futures | 6245.99 | 6273.44 | 6245.99 | 6269.92 | 184735.0 |
| 2025-06-27 16:00:00 | ES | Futures | 6270.17 | 6270.17 | 6263.37 | 6264.63 | 54953.0 |
| 2025-06-27 16:30:00 | ES | Futures | 6264.63 | 6268.15 | 6264.38 | 6267.4 | 12127.0 |
| 2025-06-27 00:00:00 | NQ | Futures | 22891.15 | 22892.67 | 22884.34 | 22890.14 | 672.0 |
| 2025-06-27 00:30:00 | NQ | Futures | 22888.88 | 22896.2 | 22885.6 | 22886.11 | 652.0 |
| 2025-06-27 01:00:00 | NQ | Futures | 22885.86 | 22898.97 | 22885.35 | 22894.68 | 920.0 |
| 2025-06-27 01:30:00 | NQ | Futures | 22894.93 | 22915.87 | 22894.93 | 22906.54 | 1861.0 |
| 2025-06-27 02:00:00 | NQ | Futures | 22907.54 | 22927.97 | 22904.77 | 22923.18 | 2125.0 |
| 2025-06-27 02:30:00 | NQ | Futures | 22923.68 | 22945.62 | 22923.18 | 22933.27 | 2881.0 |
| 2025-06-27 03:00:00 | NQ | Futures | 22933.01 | 22958.23 | 22922.17 | 22949.41 | 3618.0 |
| 2025-06-27 03:30:00 | NQ | Futures | 22950.16 | 22950.41 | 22924.69 | 22933.27 | 2521.0 |
| 2025-06-27 04:00:00 | NQ | Futures | 22934.02 | 22946.38 | 22921.41 | 22931.25 | 3068.0 |
| 2025-06-27 04:30:00 | NQ | Futures | 22931.25 | 22948.65 | 22929.99 | 22945.37 | 1614.0 |
| 2025-06-27 05:00:00 | NQ | Futures | 22946.38 | 22948.4 | 22927.72 | 22936.04 | 1562.0 |
| 2025-06-27 05:30:00 | NQ | Futures | 22935.54 | 22943.1 | 22929.48 | 22943.1 | 1611.0 |
| 2025-06-27 06:00:00 | NQ | Futures | 22943.1 | 22947.14 | 22923.43 | 22930.74 | 2099.0 |
| 2025-06-27 06:30:00 | NQ | Futures | 22930.49 | 22935.03 | 22925.95 | 22932.76 | 1212.0 |
| 2025-06-27 07:00:00 | NQ | Futures | 22932.76 | 22963.78 | 22930.74 | 22957.73 | 3521.0 |
| 2025-06-27 07:30:00 | NQ | Futures | 22958.23 | 22978.41 | 22955.96 | 22977.4 | 2998.0 |
> showing 50 of 3,095 rows — these rows as CSV