PREVIEW / futures_30min / 2024-08-23
file: by_date/futures_30min/2024/2024-08-23.parquet size: 92 KB rows: 3,123
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-08-23 00:00:00 | ES | Futures | 5882.96 | 5886.89 | 5882.96 | 5886.1 | 1845.0 |
| 2024-08-23 00:30:00 | ES | Futures | 5885.84 | 5886.37 | 5884.53 | 5885.32 | 894.0 |
| 2024-08-23 01:00:00 | ES | Futures | 5885.32 | 5887.42 | 5885.06 | 5886.37 | 1132.0 |
| 2024-08-23 01:30:00 | ES | Futures | 5886.63 | 5888.2 | 5884.79 | 5885.84 | 1887.0 |
| 2024-08-23 02:00:00 | ES | Futures | 5886.1 | 5887.94 | 5885.06 | 5885.58 | 1709.0 |
| 2024-08-23 02:30:00 | ES | Futures | 5885.84 | 5887.94 | 5885.32 | 5886.37 | 2269.0 |
| 2024-08-23 03:00:00 | ES | Futures | 5886.63 | 5889.51 | 5885.58 | 5887.42 | 4790.0 |
| 2024-08-23 03:30:00 | ES | Futures | 5887.42 | 5888.2 | 5883.75 | 5884.01 | 2711.0 |
| 2024-08-23 04:00:00 | ES | Futures | 5884.01 | 5888.46 | 5882.96 | 5887.42 | 4086.0 |
| 2024-08-23 04:30:00 | ES | Futures | 5887.68 | 5891.87 | 5887.15 | 5891.61 | 4962.0 |
| 2024-08-23 05:00:00 | ES | Futures | 5891.87 | 5891.87 | 5887.68 | 5890.82 | 3479.0 |
| 2024-08-23 05:30:00 | ES | Futures | 5891.09 | 5893.45 | 5890.82 | 5892.92 | 4179.0 |
| 2024-08-23 06:00:00 | ES | Futures | 5892.92 | 5895.81 | 5891.61 | 5892.13 | 4153.0 |
| 2024-08-23 06:30:00 | ES | Futures | 5892.13 | 5901.57 | 5891.87 | 5898.69 | 7101.0 |
| 2024-08-23 07:00:00 | ES | Futures | 5898.43 | 5899.48 | 5894.76 | 5896.85 | 4988.0 |
| 2024-08-23 07:30:00 | ES | Futures | 5896.85 | 5898.95 | 5895.02 | 5898.43 | 4344.0 |
| 2024-08-23 08:00:00 | ES | Futures | 5898.43 | 5900.79 | 5894.76 | 5896.07 | 6854.0 |
| 2024-08-23 08:30:00 | ES | Futures | 5895.81 | 5902.88 | 5895.28 | 5902.36 | 9484.0 |
| 2024-08-23 09:00:00 | ES | Futures | 5902.1 | 5904.19 | 5898.16 | 5900.0 | 19851.0 |
| 2024-08-23 09:30:00 | ES | Futures | 5899.74 | 5902.88 | 5892.13 | 5902.1 | 83380.0 |
| 2024-08-23 10:00:00 | ES | Futures | 5902.36 | 5937.75 | 5902.36 | 5933.03 | 199565.0 |
| 2024-08-23 10:30:00 | ES | Futures | 5933.03 | 5934.87 | 5887.42 | 5910.22 | 178580.0 |
| 2024-08-23 11:00:00 | ES | Futures | 5909.96 | 5930.41 | 5899.48 | 5922.02 | 117734.0 |
| 2024-08-23 11:30:00 | ES | Futures | 5922.28 | 5931.2 | 5903.93 | 5904.46 | 92921.0 |
| 2024-08-23 12:00:00 | ES | Futures | 5904.46 | 5906.29 | 5883.22 | 5889.25 | 87899.0 |
| 2024-08-23 12:30:00 | ES | Futures | 5889.51 | 5901.31 | 5875.62 | 5896.85 | 86385.0 |
| 2024-08-23 13:00:00 | ES | Futures | 5896.85 | 5909.18 | 5893.45 | 5907.34 | 42696.0 |
| 2024-08-23 13:30:00 | ES | Futures | 5907.34 | 5915.21 | 5906.03 | 5908.65 | 43336.0 |
| 2024-08-23 14:00:00 | ES | Futures | 5908.91 | 5915.21 | 5906.55 | 5913.63 | 29968.0 |
| 2024-08-23 14:30:00 | ES | Futures | 5913.63 | 5917.3 | 5908.13 | 5912.85 | 36826.0 |
| 2024-08-23 15:00:00 | ES | Futures | 5912.85 | 5928.58 | 5906.29 | 5927.26 | 49421.0 |
| 2024-08-23 15:30:00 | ES | Futures | 5927.53 | 5933.03 | 5911.53 | 5926.22 | 137053.0 |
| 2024-08-23 16:00:00 | ES | Futures | 5926.48 | 5930.67 | 5923.33 | 5929.1 | 40140.0 |
| 2024-08-23 16:30:00 | ES | Futures | 5928.84 | 5929.36 | 5925.69 | 5925.69 | 4794.0 |
| 2024-08-23 00:00:00 | NQ | Futures | 20766.45 | 20792.58 | 20765.39 | 20783.61 | 1531.0 |
| 2024-08-23 00:30:00 | NQ | Futures | 20782.81 | 20787.04 | 20776.48 | 20779.12 | 768.0 |
| 2024-08-23 01:00:00 | NQ | Futures | 20779.65 | 20794.17 | 20778.59 | 20789.68 | 646.0 |
| 2024-08-23 01:30:00 | NQ | Futures | 20789.41 | 20802.09 | 20777.53 | 20783.87 | 1760.0 |
| 2024-08-23 02:00:00 | NQ | Futures | 20783.61 | 20793.37 | 20771.99 | 20780.97 | 1221.0 |
| 2024-08-23 02:30:00 | NQ | Futures | 20781.23 | 20797.07 | 20778.06 | 20793.9 | 1355.0 |
| 2024-08-23 03:00:00 | NQ | Futures | 20794.17 | 20810.27 | 20784.93 | 20802.88 | 2303.0 |
| 2024-08-23 03:30:00 | NQ | Futures | 20803.41 | 20807.1 | 20780.44 | 20780.7 | 1745.0 |
| 2024-08-23 04:00:00 | NQ | Futures | 20780.7 | 20802.09 | 20774.37 | 20796.01 | 2410.0 |
| 2024-08-23 04:30:00 | NQ | Futures | 20795.49 | 20815.81 | 20793.37 | 20815.81 | 2015.0 |
| 2024-08-23 05:00:00 | NQ | Futures | 20816.08 | 20817.66 | 20785.98 | 20806.57 | 2150.0 |
| 2024-08-23 05:30:00 | NQ | Futures | 20807.36 | 20822.94 | 20806.31 | 20818.72 | 1587.0 |
| 2024-08-23 06:00:00 | NQ | Futures | 20818.45 | 20837.99 | 20818.19 | 20820.04 | 2363.0 |
| 2024-08-23 06:30:00 | NQ | Futures | 20821.09 | 20859.9 | 20820.3 | 20844.32 | 3560.0 |
| 2024-08-23 07:00:00 | NQ | Futures | 20844.85 | 20850.66 | 20824.79 | 20832.97 | 3333.0 |
| 2024-08-23 07:30:00 | NQ | Futures | 20833.76 | 20845.11 | 20828.22 | 20841.68 | 2297.0 |
> showing 50 of 3,123 rows — these rows as CSV