PREVIEW / futures_30min / 2024-05-17
file: by_date/futures_30min/2024/2024-05-17.parquet size: 92 KB rows: 3,188
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-17 00:00:00 | ES | Futures | 5644.17 | 5644.96 | 5643.37 | 5644.96 | 997.0 |
| 2024-05-17 00:30:00 | ES | Futures | 5644.96 | 5646.02 | 5644.96 | 5645.76 | 1111.0 |
| 2024-05-17 01:00:00 | ES | Futures | 5645.76 | 5646.82 | 5644.7 | 5644.7 | 1480.0 |
| 2024-05-17 01:30:00 | ES | Futures | 5644.7 | 5646.82 | 5644.43 | 5646.29 | 2129.0 |
| 2024-05-17 02:00:00 | ES | Futures | 5646.55 | 5648.68 | 5646.29 | 5648.68 | 3207.0 |
| 2024-05-17 02:30:00 | ES | Futures | 5648.41 | 5649.74 | 5646.55 | 5646.82 | 3659.0 |
| 2024-05-17 03:00:00 | ES | Futures | 5646.82 | 5648.94 | 5644.96 | 5646.55 | 6625.0 |
| 2024-05-17 03:30:00 | ES | Futures | 5646.55 | 5647.62 | 5644.7 | 5645.23 | 4443.0 |
| 2024-05-17 04:00:00 | ES | Futures | 5645.23 | 5645.76 | 5638.59 | 5638.86 | 9077.0 |
| 2024-05-17 04:30:00 | ES | Futures | 5639.13 | 5641.51 | 5638.33 | 5640.98 | 4652.0 |
| 2024-05-17 05:00:00 | ES | Futures | 5641.25 | 5645.49 | 5640.98 | 5644.96 | 5186.0 |
| 2024-05-17 05:30:00 | ES | Futures | 5644.7 | 5647.08 | 5643.37 | 5644.17 | 6254.0 |
| 2024-05-17 06:00:00 | ES | Futures | 5644.43 | 5645.49 | 5641.78 | 5644.7 | 4564.0 |
| 2024-05-17 06:30:00 | ES | Futures | 5644.7 | 5646.29 | 5642.84 | 5646.29 | 3838.0 |
| 2024-05-17 07:00:00 | ES | Futures | 5646.29 | 5647.88 | 5643.64 | 5647.62 | 5409.0 |
| 2024-05-17 07:30:00 | ES | Futures | 5647.62 | 5649.74 | 5646.55 | 5647.62 | 6074.0 |
| 2024-05-17 08:00:00 | ES | Futures | 5647.35 | 5650.27 | 5646.02 | 5649.21 | 9076.0 |
| 2024-05-17 08:30:00 | ES | Futures | 5649.47 | 5651.86 | 5648.94 | 5651.59 | 13264.0 |
| 2024-05-17 09:00:00 | ES | Futures | 5651.59 | 5651.86 | 5642.31 | 5646.29 | 26214.0 |
| 2024-05-17 09:30:00 | ES | Futures | 5646.29 | 5650.27 | 5640.98 | 5645.49 | 107268.0 |
| 2024-05-17 10:00:00 | ES | Futures | 5645.49 | 5650.0 | 5641.25 | 5650.0 | 67204.0 |
| 2024-05-17 10:30:00 | ES | Futures | 5650.0 | 5651.33 | 5647.88 | 5649.47 | 52414.0 |
| 2024-05-17 11:00:00 | ES | Futures | 5649.21 | 5649.47 | 5641.51 | 5645.49 | 58176.0 |
| 2024-05-17 11:30:00 | ES | Futures | 5645.76 | 5646.82 | 5640.19 | 5646.29 | 48050.0 |
| 2024-05-17 12:00:00 | ES | Futures | 5646.29 | 5648.68 | 5642.31 | 5643.37 | 38458.0 |
| 2024-05-17 12:30:00 | ES | Futures | 5643.37 | 5646.55 | 5637.8 | 5646.02 | 46292.0 |
| 2024-05-17 13:00:00 | ES | Futures | 5646.02 | 5647.35 | 5642.84 | 5645.23 | 33571.0 |
| 2024-05-17 13:30:00 | ES | Futures | 5645.23 | 5647.08 | 5642.84 | 5645.23 | 31014.0 |
| 2024-05-17 14:00:00 | ES | Futures | 5645.49 | 5645.49 | 5630.37 | 5636.47 | 87806.0 |
| 2024-05-17 14:30:00 | ES | Futures | 5636.47 | 5647.88 | 5636.21 | 5646.29 | 63510.0 |
| 2024-05-17 15:00:00 | ES | Futures | 5646.55 | 5651.86 | 5644.17 | 5651.06 | 59416.0 |
| 2024-05-17 15:30:00 | ES | Futures | 5651.06 | 5654.78 | 5646.02 | 5653.72 | 112281.0 |
| 2024-05-17 16:00:00 | ES | Futures | 5653.45 | 5653.98 | 5649.74 | 5653.45 | 34924.0 |
| 2024-05-17 16:30:00 | ES | Futures | 5653.45 | 5654.25 | 5652.92 | 5653.72 | 5986.0 |
| 2024-05-17 00:00:00 | NQ | Futures | 19956.6 | 19960.88 | 19952.06 | 19959.81 | 685.0 |
| 2024-05-17 00:30:00 | NQ | Futures | 19960.08 | 19966.23 | 19960.08 | 19965.16 | 788.0 |
| 2024-05-17 01:00:00 | NQ | Futures | 19964.9 | 19971.32 | 19960.08 | 19960.62 | 1250.0 |
| 2024-05-17 01:30:00 | NQ | Futures | 19960.88 | 19971.85 | 19960.62 | 19969.98 | 1175.0 |
| 2024-05-17 02:00:00 | NQ | Futures | 19970.51 | 19982.02 | 19969.18 | 19974.79 | 2245.0 |
| 2024-05-17 02:30:00 | NQ | Futures | 19974.79 | 19980.41 | 19963.56 | 19964.09 | 1760.0 |
| 2024-05-17 03:00:00 | NQ | Futures | 19964.36 | 19970.25 | 19955.0 | 19962.22 | 3038.0 |
| 2024-05-17 03:30:00 | NQ | Futures | 19961.95 | 19965.16 | 19949.11 | 19953.13 | 2869.0 |
| 2024-05-17 04:00:00 | NQ | Futures | 19952.86 | 19954.46 | 19920.49 | 19927.18 | 5998.0 |
| 2024-05-17 04:30:00 | NQ | Futures | 19927.71 | 19941.62 | 19922.1 | 19939.75 | 2638.0 |
| 2024-05-17 05:00:00 | NQ | Futures | 19939.75 | 19958.48 | 19939.48 | 19957.94 | 3509.0 |
| 2024-05-17 05:30:00 | NQ | Futures | 19957.41 | 19966.5 | 19951.79 | 19960.62 | 2869.0 |
| 2024-05-17 06:00:00 | NQ | Futures | 19960.62 | 19969.71 | 19952.06 | 19967.84 | 2655.0 |
| 2024-05-17 06:30:00 | NQ | Futures | 19967.3 | 19973.99 | 19958.74 | 19973.72 | 2306.0 |
| 2024-05-17 07:00:00 | NQ | Futures | 19973.99 | 19977.74 | 19961.15 | 19975.86 | 3095.0 |
| 2024-05-17 07:30:00 | NQ | Futures | 19975.86 | 19984.96 | 19970.25 | 19975.86 | 3552.0 |
> showing 50 of 3,188 rows — these rows as CSV