PREVIEW / futures_30min / 2025-01-20
file: by_date/futures_30min/2025/2025-01-20.parquet size: 98 KB rows: 3,275
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-20 00:00:00 | ES | Futures | 6185.88 | 6187.16 | 6185.11 | 6185.88 | 1155.0 |
| 2025-01-20 00:30:00 | ES | Futures | 6185.62 | 6186.39 | 6185.11 | 6186.14 | 734.0 |
| 2025-01-20 01:00:00 | ES | Futures | 6186.14 | 6187.42 | 6184.85 | 6187.42 | 1268.0 |
| 2025-01-20 01:30:00 | ES | Futures | 6187.42 | 6190.75 | 6186.39 | 6188.96 | 2036.0 |
| 2025-01-20 02:00:00 | ES | Futures | 6189.21 | 6191.01 | 6188.19 | 6188.7 | 1967.0 |
| 2025-01-20 02:30:00 | ES | Futures | 6188.7 | 6195.88 | 6188.44 | 6195.62 | 3123.0 |
| 2025-01-20 03:00:00 | ES | Futures | 6195.36 | 6197.67 | 6185.88 | 6188.44 | 6767.0 |
| 2025-01-20 03:30:00 | ES | Futures | 6188.44 | 6193.06 | 6187.67 | 6191.01 | 3364.0 |
| 2025-01-20 04:00:00 | ES | Futures | 6191.26 | 6195.11 | 6189.98 | 6192.54 | 2921.0 |
| 2025-01-20 04:30:00 | ES | Futures | 6192.8 | 6193.83 | 6189.98 | 6192.54 | 1901.0 |
| 2025-01-20 05:00:00 | ES | Futures | 6192.54 | 6194.08 | 6188.19 | 6191.78 | 2930.0 |
| 2025-01-20 05:30:00 | ES | Futures | 6192.03 | 6194.08 | 6189.47 | 6191.52 | 2259.0 |
| 2025-01-20 06:00:00 | ES | Futures | 6191.26 | 6193.06 | 6189.21 | 6190.24 | 2257.0 |
| 2025-01-20 06:30:00 | ES | Futures | 6190.24 | 6192.54 | 6189.47 | 6189.98 | 1832.0 |
| 2025-01-20 07:00:00 | ES | Futures | 6190.24 | 6190.49 | 6179.47 | 6180.24 | 5680.0 |
| 2025-01-20 07:30:00 | ES | Futures | 6180.24 | 6184.6 | 6180.24 | 6181.78 | 3970.0 |
| 2025-01-20 08:00:00 | ES | Futures | 6181.78 | 6181.78 | 6177.42 | 6177.67 | 5167.0 |
| 2025-01-20 08:30:00 | ES | Futures | 6177.67 | 6213.05 | 6171.52 | 6211.77 | 43284.0 |
| 2025-01-20 09:00:00 | ES | Futures | 6211.77 | 6220.75 | 6204.34 | 6218.44 | 24472.0 |
| 2025-01-20 09:30:00 | ES | Futures | 6218.95 | 6233.31 | 6217.67 | 6222.54 | 31631.0 |
| 2025-01-20 10:00:00 | ES | Futures | 6222.28 | 6222.28 | 6209.47 | 6210.75 | 19991.0 |
| 2025-01-20 10:30:00 | ES | Futures | 6211.0 | 6211.26 | 6197.16 | 6208.18 | 17914.0 |
| 2025-01-20 11:00:00 | ES | Futures | 6208.18 | 6216.13 | 6207.93 | 6213.82 | 14329.0 |
| 2025-01-20 11:30:00 | ES | Futures | 6214.08 | 6215.87 | 6208.95 | 6209.98 | 7820.0 |
| 2025-01-20 12:00:00 | ES | Futures | 6210.23 | 6213.31 | 6190.49 | 6202.54 | 21372.0 |
| 2025-01-20 12:30:00 | ES | Futures | 6202.29 | 6216.64 | 6199.98 | 6209.72 | 13875.0 |
| 2025-01-20 18:00:00 | ES | Futures | 6215.11 | 6221.52 | 6211.26 | 6219.72 | 8193.0 |
| 2025-01-20 18:30:00 | ES | Futures | 6219.72 | 6223.82 | 6215.11 | 6222.8 | 4516.0 |
| 2025-01-20 19:00:00 | ES | Futures | 6223.05 | 6225.36 | 6216.13 | 6217.93 | 6489.0 |
| 2025-01-20 19:30:00 | ES | Futures | 6217.93 | 6219.21 | 6160.24 | 6164.34 | 30830.0 |
| 2025-01-20 20:00:00 | ES | Futures | 6164.09 | 6199.72 | 6147.42 | 6191.52 | 32478.0 |
| 2025-01-20 20:30:00 | ES | Futures | 6191.26 | 6195.36 | 6175.37 | 6190.49 | 15906.0 |
| 2025-01-20 21:00:00 | ES | Futures | 6190.75 | 6197.93 | 6190.75 | 6191.26 | 6895.0 |
| 2025-01-20 21:30:00 | ES | Futures | 6191.26 | 6194.6 | 6188.44 | 6193.31 | 4134.0 |
| 2025-01-20 22:00:00 | ES | Futures | 6193.06 | 6205.11 | 6192.8 | 6202.03 | 5434.0 |
| 2025-01-20 22:30:00 | ES | Futures | 6202.03 | 6203.57 | 6197.67 | 6199.98 | 3214.0 |
| 2025-01-20 23:00:00 | ES | Futures | 6200.24 | 6201.52 | 6196.13 | 6198.7 | 2142.0 |
| 2025-01-20 23:30:00 | ES | Futures | 6198.7 | 6199.21 | 6194.85 | 6195.62 | 2283.0 |
| 2025-01-20 00:00:00 | NQ | Futures | 22198.72 | 22205.42 | 22195.89 | 22199.5 | 700.0 |
| 2025-01-20 00:30:00 | NQ | Futures | 22199.24 | 22203.87 | 22197.44 | 22203.36 | 419.0 |
| 2025-01-20 01:00:00 | NQ | Futures | 22203.87 | 22216.22 | 22198.72 | 22215.19 | 1001.0 |
| 2025-01-20 01:30:00 | NQ | Futures | 22215.45 | 22239.9 | 22212.36 | 22229.09 | 1766.0 |
| 2025-01-20 02:00:00 | NQ | Futures | 22230.12 | 22235.78 | 22220.6 | 22224.46 | 1378.0 |
| 2025-01-20 02:30:00 | NQ | Futures | 22223.94 | 22267.18 | 22223.17 | 22256.88 | 2403.0 |
| 2025-01-20 03:00:00 | NQ | Futures | 22256.63 | 22273.87 | 22222.92 | 22237.07 | 3940.0 |
| 2025-01-20 03:30:00 | NQ | Futures | 22238.1 | 22257.4 | 22229.61 | 22252.51 | 2252.0 |
| 2025-01-20 04:00:00 | NQ | Futures | 22253.54 | 22268.72 | 22245.05 | 22255.6 | 1755.0 |
| 2025-01-20 04:30:00 | NQ | Futures | 22256.37 | 22264.86 | 22248.14 | 22257.66 | 1052.0 |
| 2025-01-20 05:00:00 | NQ | Futures | 22258.17 | 22266.41 | 22242.22 | 22258.69 | 1547.0 |
| 2025-01-20 05:30:00 | NQ | Futures | 22259.46 | 22272.07 | 22250.71 | 22260.49 | 1260.0 |
> showing 50 of 3,275 rows — these rows as CSV