PREVIEW / futures_30min / 2024-07-26
file: by_date/futures_30min/2024/2024-07-26.parquet size: 91 KB rows: 3,169
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-07-26 00:00:00 | ES | Futures | 5727.5 | 5732.21 | 5725.92 | 5731.69 | 2079.0 |
| 2024-07-26 00:30:00 | ES | Futures | 5731.69 | 5733.26 | 5730.64 | 5732.21 | 1972.0 |
| 2024-07-26 01:00:00 | ES | Futures | 5732.21 | 5735.1 | 5731.95 | 5734.84 | 3512.0 |
| 2024-07-26 01:30:00 | ES | Futures | 5734.84 | 5735.1 | 5725.4 | 5725.92 | 3818.0 |
| 2024-07-26 02:00:00 | ES | Futures | 5725.92 | 5734.84 | 5725.4 | 5727.23 | 5602.0 |
| 2024-07-26 02:30:00 | ES | Futures | 5727.23 | 5732.48 | 5726.71 | 5728.81 | 3937.0 |
| 2024-07-26 03:00:00 | ES | Futures | 5729.07 | 5737.2 | 5727.23 | 5734.31 | 11279.0 |
| 2024-07-26 03:30:00 | ES | Futures | 5734.31 | 5741.13 | 5733.0 | 5740.87 | 11670.0 |
| 2024-07-26 04:00:00 | ES | Futures | 5741.13 | 5747.94 | 5738.51 | 5745.85 | 12034.0 |
| 2024-07-26 04:30:00 | ES | Futures | 5745.85 | 5755.02 | 5744.01 | 5754.76 | 8945.0 |
| 2024-07-26 05:00:00 | ES | Futures | 5754.5 | 5754.76 | 5746.9 | 5748.21 | 9345.0 |
| 2024-07-26 05:30:00 | ES | Futures | 5747.94 | 5751.35 | 5747.42 | 5748.73 | 5585.0 |
| 2024-07-26 06:00:00 | ES | Futures | 5748.73 | 5750.04 | 5745.85 | 5748.21 | 4653.0 |
| 2024-07-26 06:30:00 | ES | Futures | 5748.47 | 5753.71 | 5746.37 | 5747.16 | 6001.0 |
| 2024-07-26 07:00:00 | ES | Futures | 5747.16 | 5752.4 | 5743.49 | 5749.52 | 8292.0 |
| 2024-07-26 07:30:00 | ES | Futures | 5749.52 | 5755.02 | 5748.99 | 5755.02 | 8161.0 |
| 2024-07-26 08:00:00 | ES | Futures | 5754.76 | 5755.81 | 5750.83 | 5751.88 | 10709.0 |
| 2024-07-26 08:30:00 | ES | Futures | 5752.4 | 5760.0 | 5744.54 | 5747.94 | 33456.0 |
| 2024-07-26 09:00:00 | ES | Futures | 5748.21 | 5748.73 | 5742.44 | 5745.06 | 26795.0 |
| 2024-07-26 09:30:00 | ES | Futures | 5745.06 | 5753.97 | 5736.15 | 5750.83 | 183434.0 |
| 2024-07-26 10:00:00 | ES | Futures | 5751.35 | 5769.44 | 5741.39 | 5758.96 | 181503.0 |
| 2024-07-26 10:30:00 | ES | Futures | 5758.96 | 5760.79 | 5737.98 | 5756.86 | 152544.0 |
| 2024-07-26 11:00:00 | ES | Futures | 5756.86 | 5763.15 | 5749.78 | 5754.5 | 110605.0 |
| 2024-07-26 11:30:00 | ES | Futures | 5754.5 | 5773.11 | 5750.83 | 5771.8 | 88804.0 |
| 2024-07-26 12:00:00 | ES | Futures | 5772.06 | 5784.39 | 5770.75 | 5779.67 | 100301.0 |
| 2024-07-26 12:30:00 | ES | Futures | 5779.67 | 5793.82 | 5776.78 | 5792.51 | 77896.0 |
| 2024-07-26 13:00:00 | ES | Futures | 5792.51 | 5797.23 | 5787.01 | 5795.66 | 63814.0 |
| 2024-07-26 13:30:00 | ES | Futures | 5795.66 | 5796.44 | 5763.15 | 5772.85 | 148984.0 |
| 2024-07-26 14:00:00 | ES | Futures | 5773.11 | 5778.36 | 5766.82 | 5768.13 | 73734.0 |
| 2024-07-26 14:30:00 | ES | Futures | 5768.39 | 5772.85 | 5756.33 | 5758.69 | 84575.0 |
| 2024-07-26 15:00:00 | ES | Futures | 5758.69 | 5774.42 | 5752.93 | 5771.02 | 93841.0 |
| 2024-07-26 15:30:00 | ES | Futures | 5771.02 | 5771.8 | 5749.26 | 5766.82 | 254254.0 |
| 2024-07-26 16:00:00 | ES | Futures | 5766.56 | 5770.23 | 5763.15 | 5769.18 | 51876.0 |
| 2024-07-26 16:30:00 | ES | Futures | 5768.92 | 5769.18 | 5766.03 | 5766.82 | 5522.0 |
| 2024-07-26 00:00:00 | NQ | Futures | 20140.28 | 20165.62 | 20131.57 | 20163.78 | 1389.0 |
| 2024-07-26 00:30:00 | NQ | Futures | 20164.3 | 20176.18 | 20156.91 | 20173.28 | 1714.0 |
| 2024-07-26 01:00:00 | NQ | Futures | 20173.28 | 20183.84 | 20166.15 | 20183.31 | 1553.0 |
| 2024-07-26 01:30:00 | NQ | Futures | 20183.31 | 20184.89 | 20131.31 | 20133.15 | 2524.0 |
| 2024-07-26 02:00:00 | NQ | Futures | 20133.15 | 20183.05 | 20130.78 | 20145.3 | 3698.0 |
| 2024-07-26 02:30:00 | NQ | Futures | 20144.5 | 20172.49 | 20143.18 | 20156.38 | 2849.0 |
| 2024-07-26 03:00:00 | NQ | Futures | 20155.06 | 20207.86 | 20152.16 | 20187.8 | 5303.0 |
| 2024-07-26 03:30:00 | NQ | Futures | 20187.53 | 20224.76 | 20181.46 | 20218.16 | 5705.0 |
| 2024-07-26 04:00:00 | NQ | Futures | 20217.63 | 20249.04 | 20201.79 | 20240.33 | 6218.0 |
| 2024-07-26 04:30:00 | NQ | Futures | 20239.01 | 20296.29 | 20223.44 | 20295.5 | 6174.0 |
| 2024-07-26 05:00:00 | NQ | Futures | 20294.71 | 20297.09 | 20252.47 | 20256.17 | 5402.0 |
| 2024-07-26 05:30:00 | NQ | Futures | 20256.96 | 20277.55 | 20255.91 | 20266.2 | 2738.0 |
| 2024-07-26 06:00:00 | NQ | Futures | 20266.73 | 20270.69 | 20240.33 | 20250.1 | 3097.0 |
| 2024-07-26 06:30:00 | NQ | Futures | 20250.36 | 20275.18 | 20235.31 | 20240.07 | 3848.0 |
| 2024-07-26 07:00:00 | NQ | Futures | 20240.33 | 20266.2 | 20225.81 | 20264.88 | 4318.0 |
| 2024-07-26 07:30:00 | NQ | Futures | 20265.67 | 20289.43 | 20263.56 | 20287.85 | 4094.0 |
> showing 50 of 3,169 rows — these rows as CSV