PREVIEW / futures_30min / 2024-04-18
file: by_date/futures_30min/2024/2024-04-18.parquet size: 116 KB rows: 4,011
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-04-18 00:00:00 | ES | Futures | 5387.09 | 5388.69 | 5386.03 | 5388.69 | 1336.0 |
| 2024-04-18 00:30:00 | ES | Futures | 5388.69 | 5388.69 | 5385.77 | 5386.3 | 1382.0 |
| 2024-04-18 01:00:00 | ES | Futures | 5386.56 | 5387.89 | 5383.12 | 5386.83 | 3159.0 |
| 2024-04-18 01:30:00 | ES | Futures | 5387.09 | 5391.87 | 5387.09 | 5390.28 | 4928.0 |
| 2024-04-18 02:00:00 | ES | Futures | 5390.28 | 5395.32 | 5389.75 | 5391.87 | 7291.0 |
| 2024-04-18 02:30:00 | ES | Futures | 5391.87 | 5394.52 | 5391.07 | 5392.93 | 4637.0 |
| 2024-04-18 03:00:00 | ES | Futures | 5392.93 | 5393.73 | 5387.09 | 5390.81 | 9383.0 |
| 2024-04-18 03:30:00 | ES | Futures | 5391.07 | 5392.67 | 5387.63 | 5390.28 | 6668.0 |
| 2024-04-18 04:00:00 | ES | Futures | 5390.28 | 5391.87 | 5381.52 | 5386.56 | 10661.0 |
| 2024-04-18 04:30:00 | ES | Futures | 5386.56 | 5388.16 | 5382.05 | 5384.44 | 5815.0 |
| 2024-04-18 05:00:00 | ES | Futures | 5384.18 | 5386.03 | 5374.1 | 5375.95 | 6977.0 |
| 2024-04-18 05:30:00 | ES | Futures | 5375.69 | 5382.58 | 5373.56 | 5382.58 | 8011.0 |
| 2024-04-18 06:00:00 | ES | Futures | 5382.58 | 5384.97 | 5377.54 | 5383.65 | 8509.0 |
| 2024-04-18 06:30:00 | ES | Futures | 5383.65 | 5387.63 | 5383.65 | 5383.91 | 15108.0 |
| 2024-04-18 07:00:00 | ES | Futures | 5383.91 | 5388.69 | 5380.99 | 5384.44 | 8113.0 |
| 2024-04-18 07:30:00 | ES | Futures | 5384.18 | 5390.28 | 5384.18 | 5386.56 | 11935.0 |
| 2024-04-18 08:00:00 | ES | Futures | 5386.83 | 5387.36 | 5378.07 | 5379.14 | 13145.0 |
| 2024-04-18 08:30:00 | ES | Futures | 5378.87 | 5384.18 | 5373.03 | 5379.93 | 34727.0 |
| 2024-04-18 09:00:00 | ES | Futures | 5380.2 | 5387.89 | 5378.61 | 5383.91 | 35719.0 |
| 2024-04-18 09:30:00 | ES | Futures | 5384.18 | 5385.24 | 5359.77 | 5375.42 | 196981.0 |
| 2024-04-18 10:00:00 | ES | Futures | 5375.42 | 5386.83 | 5366.14 | 5384.44 | 120101.0 |
| 2024-04-18 10:30:00 | ES | Futures | 5384.44 | 5403.81 | 5383.91 | 5399.03 | 120114.0 |
| 2024-04-18 11:00:00 | ES | Futures | 5399.03 | 5406.99 | 5395.58 | 5397.18 | 89836.0 |
| 2024-04-18 11:30:00 | ES | Futures | 5397.18 | 5399.03 | 5390.81 | 5393.73 | 71228.0 |
| 2024-04-18 12:00:00 | ES | Futures | 5393.73 | 5398.77 | 5386.3 | 5390.81 | 64274.0 |
| 2024-04-18 12:30:00 | ES | Futures | 5390.81 | 5391.07 | 5368.79 | 5370.91 | 91721.0 |
| 2024-04-18 13:00:00 | ES | Futures | 5370.65 | 5374.89 | 5350.22 | 5365.08 | 119175.0 |
| 2024-04-18 13:30:00 | ES | Futures | 5365.34 | 5365.87 | 5350.75 | 5358.18 | 90952.0 |
| 2024-04-18 14:00:00 | ES | Futures | 5358.44 | 5367.46 | 5347.57 | 5357.91 | 87307.0 |
| 2024-04-18 14:30:00 | ES | Futures | 5357.91 | 5358.97 | 5346.77 | 5351.28 | 75241.0 |
| 2024-04-18 15:00:00 | ES | Futures | 5351.28 | 5366.14 | 5351.28 | 5360.83 | 74063.0 |
| 2024-04-18 15:30:00 | ES | Futures | 5360.83 | 5371.97 | 5354.46 | 5357.12 | 144076.0 |
| 2024-04-18 16:00:00 | ES | Futures | 5357.38 | 5364.28 | 5351.81 | 5357.65 | 69321.0 |
| 2024-04-18 16:30:00 | ES | Futures | 5357.91 | 5358.97 | 5352.87 | 5356.85 | 7616.0 |
| 2024-04-18 18:00:00 | ES | Futures | 5356.06 | 5360.57 | 5356.06 | 5358.97 | 2772.0 |
| 2024-04-18 18:30:00 | ES | Futures | 5358.97 | 5359.77 | 5355.52 | 5356.32 | 1541.0 |
| 2024-04-18 19:00:00 | ES | Futures | 5356.32 | 5356.59 | 5352.34 | 5352.87 | 3845.0 |
| 2024-04-18 19:30:00 | ES | Futures | 5353.14 | 5354.73 | 5344.38 | 5348.36 | 5997.0 |
| 2024-04-18 20:00:00 | ES | Futures | 5348.36 | 5350.22 | 5335.36 | 5339.34 | 16526.0 |
| 2024-04-18 20:30:00 | ES | Futures | 5339.61 | 5339.87 | 5328.46 | 5331.65 | 17239.0 |
| 2024-04-18 21:00:00 | ES | Futures | 5331.65 | 5334.04 | 5301.67 | 5303.26 | 39309.0 |
| 2024-04-18 21:30:00 | ES | Futures | 5303.0 | 5304.06 | 5277.79 | 5290.79 | 47501.0 |
| 2024-04-18 22:00:00 | ES | Futures | 5290.79 | 5292.38 | 5267.18 | 5285.75 | 41364.0 |
| 2024-04-18 22:30:00 | ES | Futures | 5285.75 | 5294.24 | 5275.67 | 5292.12 | 31683.0 |
| 2024-04-18 23:00:00 | ES | Futures | 5292.12 | 5303.79 | 5287.61 | 5303.53 | 25574.0 |
| 2024-04-18 23:30:00 | ES | Futures | 5303.53 | 5312.02 | 5299.55 | 5306.44 | 17268.0 |
| 2024-04-18 00:00:00 | NQ | Futures | 18971.39 | 18978.34 | 18967.37 | 18978.34 | 927.0 |
| 2024-04-18 00:30:00 | NQ | Futures | 18977.54 | 18977.81 | 18963.9 | 18966.57 | 1403.0 |
| 2024-04-18 01:00:00 | NQ | Futures | 18967.11 | 18974.6 | 18952.13 | 18970.32 | 2527.0 |
| 2024-04-18 01:30:00 | NQ | Futures | 18970.05 | 18998.67 | 18970.05 | 18986.1 | 4405.0 |
> showing 50 of 4,011 rows — these rows as CSV