PREVIEW / futures_30min / 2024-10-18
file: by_date/futures_30min/2024/2024-10-18.parquet size: 91 KB rows: 3,191
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-10-18 00:00:00 | ES | Futures | 6108.4 | 6110.22 | 6107.62 | 6108.66 | 1011.0 |
| 2024-10-18 00:30:00 | ES | Futures | 6108.92 | 6110.74 | 6108.66 | 6109.7 | 883.0 |
| 2024-10-18 01:00:00 | ES | Futures | 6109.7 | 6111.26 | 6108.92 | 6109.18 | 1737.0 |
| 2024-10-18 01:30:00 | ES | Futures | 6109.44 | 6113.07 | 6109.44 | 6112.55 | 2957.0 |
| 2024-10-18 02:00:00 | ES | Futures | 6112.81 | 6113.85 | 6111.52 | 6112.81 | 3255.0 |
| 2024-10-18 02:30:00 | ES | Futures | 6112.81 | 6114.63 | 6111.52 | 6113.59 | 3317.0 |
| 2024-10-18 03:00:00 | ES | Futures | 6113.85 | 6115.93 | 6113.33 | 6115.67 | 4683.0 |
| 2024-10-18 03:30:00 | ES | Futures | 6115.41 | 6121.9 | 6114.63 | 6121.9 | 6604.0 |
| 2024-10-18 04:00:00 | ES | Futures | 6121.9 | 6124.49 | 6120.86 | 6123.45 | 5525.0 |
| 2024-10-18 04:30:00 | ES | Futures | 6123.2 | 6123.71 | 6119.56 | 6121.9 | 4033.0 |
| 2024-10-18 05:00:00 | ES | Futures | 6122.16 | 6125.27 | 6121.9 | 6122.94 | 3925.0 |
| 2024-10-18 05:30:00 | ES | Futures | 6122.94 | 6122.94 | 6118.0 | 6119.04 | 4089.0 |
| 2024-10-18 06:00:00 | ES | Futures | 6118.78 | 6121.12 | 6116.45 | 6120.6 | 3333.0 |
| 2024-10-18 06:30:00 | ES | Futures | 6120.6 | 6122.16 | 6119.82 | 6121.9 | 2779.0 |
| 2024-10-18 07:00:00 | ES | Futures | 6121.64 | 6126.05 | 6118.78 | 6123.97 | 8525.0 |
| 2024-10-18 07:30:00 | ES | Futures | 6123.71 | 6125.79 | 6123.2 | 6123.97 | 4893.0 |
| 2024-10-18 08:00:00 | ES | Futures | 6123.97 | 6125.27 | 6121.12 | 6123.2 | 6262.0 |
| 2024-10-18 08:30:00 | ES | Futures | 6123.45 | 6127.35 | 6123.45 | 6125.01 | 10299.0 |
| 2024-10-18 09:00:00 | ES | Futures | 6125.01 | 6131.5 | 6121.12 | 6126.05 | 40813.0 |
| 2024-10-18 09:30:00 | ES | Futures | 6126.31 | 6128.13 | 6110.74 | 6118.0 | 124829.0 |
| 2024-10-18 10:00:00 | ES | Futures | 6118.0 | 6125.79 | 6116.19 | 6120.08 | 68723.0 |
| 2024-10-18 10:30:00 | ES | Futures | 6119.82 | 6124.49 | 6115.67 | 6119.82 | 49866.0 |
| 2024-10-18 11:00:00 | ES | Futures | 6119.56 | 6129.42 | 6119.3 | 6128.39 | 40218.0 |
| 2024-10-18 11:30:00 | ES | Futures | 6128.65 | 6130.72 | 6122.68 | 6124.75 | 44056.0 |
| 2024-10-18 12:00:00 | ES | Futures | 6124.75 | 6129.16 | 6122.42 | 6127.35 | 29700.0 |
| 2024-10-18 12:30:00 | ES | Futures | 6127.61 | 6139.29 | 6126.83 | 6133.06 | 42292.0 |
| 2024-10-18 13:00:00 | ES | Futures | 6133.06 | 6137.73 | 6131.5 | 6132.54 | 38796.0 |
| 2024-10-18 13:30:00 | ES | Futures | 6132.8 | 6136.17 | 6130.98 | 6132.02 | 23019.0 |
| 2024-10-18 14:00:00 | ES | Futures | 6132.02 | 6140.84 | 6123.97 | 6137.99 | 44251.0 |
| 2024-10-18 14:30:00 | ES | Futures | 6137.99 | 6139.29 | 6133.58 | 6134.61 | 29326.0 |
| 2024-10-18 15:00:00 | ES | Futures | 6134.61 | 6134.61 | 6128.13 | 6130.72 | 40165.0 |
| 2024-10-18 15:30:00 | ES | Futures | 6130.46 | 6133.84 | 6126.05 | 6131.24 | 99016.0 |
| 2024-10-18 16:00:00 | ES | Futures | 6130.98 | 6134.87 | 6129.16 | 6133.06 | 39244.0 |
| 2024-10-18 16:30:00 | ES | Futures | 6132.8 | 6134.1 | 6131.76 | 6132.54 | 16884.0 |
| 2024-10-18 00:00:00 | NQ | Futures | 21251.05 | 21266.18 | 21247.39 | 21257.05 | 814.0 |
| 2024-10-18 00:30:00 | NQ | Futures | 21257.57 | 21270.36 | 21256.53 | 21263.05 | 764.0 |
| 2024-10-18 01:00:00 | NQ | Futures | 21263.57 | 21279.23 | 21258.61 | 21269.31 | 987.0 |
| 2024-10-18 01:30:00 | NQ | Futures | 21269.57 | 21297.75 | 21269.57 | 21295.4 | 1577.0 |
| 2024-10-18 02:00:00 | NQ | Futures | 21295.14 | 21304.8 | 21287.31 | 21301.4 | 1323.0 |
| 2024-10-18 02:30:00 | NQ | Futures | 21301.93 | 21324.89 | 21300.1 | 21321.75 | 3023.0 |
| 2024-10-18 03:00:00 | NQ | Futures | 21322.02 | 21329.58 | 21313.14 | 21324.62 | 2231.0 |
| 2024-10-18 03:30:00 | NQ | Futures | 21325.15 | 21348.63 | 21315.23 | 21347.06 | 2775.0 |
| 2024-10-18 04:00:00 | NQ | Futures | 21347.59 | 21361.41 | 21339.5 | 21348.63 | 3549.0 |
| 2024-10-18 04:30:00 | NQ | Futures | 21347.59 | 21349.67 | 21327.49 | 21341.32 | 2072.0 |
| 2024-10-18 05:00:00 | NQ | Futures | 21342.63 | 21355.41 | 21336.89 | 21339.76 | 1699.0 |
| 2024-10-18 05:30:00 | NQ | Futures | 21340.28 | 21341.32 | 21314.97 | 21320.97 | 2605.0 |
| 2024-10-18 06:00:00 | NQ | Futures | 21321.75 | 21335.32 | 21309.75 | 21333.76 | 2015.0 |
| 2024-10-18 06:30:00 | NQ | Futures | 21334.02 | 21343.15 | 21330.36 | 21340.8 | 1882.0 |
| 2024-10-18 07:00:00 | NQ | Futures | 21340.54 | 21368.98 | 21328.8 | 21359.33 | 3946.0 |
| 2024-10-18 07:30:00 | NQ | Futures | 21359.59 | 21373.68 | 21359.33 | 21361.67 | 2602.0 |
> showing 50 of 3,191 rows — these rows as CSV