PREVIEW / futures_30min / 2025-01-28
file: by_date/futures_30min/2025/2025-01-28.parquet size: 107 KB rows: 4,024
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-28 00:00:00 | ES | Futures | 6201.52 | 6203.83 | 6195.88 | 6196.9 | 1966.0 |
| 2025-01-28 00:30:00 | ES | Futures | 6196.65 | 6197.93 | 6190.24 | 6197.67 | 3133.0 |
| 2025-01-28 01:00:00 | ES | Futures | 6197.93 | 6200.24 | 6195.36 | 6197.16 | 2289.0 |
| 2025-01-28 01:30:00 | ES | Futures | 6197.16 | 6200.24 | 6191.52 | 6195.11 | 2422.0 |
| 2025-01-28 02:00:00 | ES | Futures | 6194.85 | 6204.85 | 6191.01 | 6202.8 | 5186.0 |
| 2025-01-28 02:30:00 | ES | Futures | 6202.8 | 6206.9 | 6200.24 | 6204.59 | 5044.0 |
| 2025-01-28 03:00:00 | ES | Futures | 6204.59 | 6208.95 | 6197.67 | 6202.29 | 11062.0 |
| 2025-01-28 03:30:00 | ES | Futures | 6202.54 | 6220.75 | 6202.03 | 6219.46 | 11136.0 |
| 2025-01-28 04:00:00 | ES | Futures | 6219.21 | 6224.08 | 6215.87 | 6216.13 | 13655.0 |
| 2025-01-28 04:30:00 | ES | Futures | 6216.39 | 6222.8 | 6213.31 | 6222.54 | 6324.0 |
| 2025-01-28 05:00:00 | ES | Futures | 6222.54 | 6227.92 | 6221.52 | 6225.87 | 8479.0 |
| 2025-01-28 05:30:00 | ES | Futures | 6226.13 | 6227.16 | 6222.28 | 6223.05 | 5479.0 |
| 2025-01-28 06:00:00 | ES | Futures | 6223.05 | 6226.9 | 6218.18 | 6218.7 | 5016.0 |
| 2025-01-28 06:30:00 | ES | Futures | 6218.7 | 6219.98 | 6212.03 | 6214.59 | 7424.0 |
| 2025-01-28 07:00:00 | ES | Futures | 6214.85 | 6216.13 | 6200.24 | 6203.31 | 13706.0 |
| 2025-01-28 07:30:00 | ES | Futures | 6203.31 | 6215.36 | 6200.49 | 6212.54 | 17166.0 |
| 2025-01-28 08:00:00 | ES | Futures | 6212.54 | 6221.0 | 6209.47 | 6218.7 | 15692.0 |
| 2025-01-28 08:30:00 | ES | Futures | 6218.7 | 6220.49 | 6205.88 | 6209.47 | 19450.0 |
| 2025-01-28 09:00:00 | ES | Futures | 6209.21 | 6213.57 | 6205.36 | 6212.29 | 20442.0 |
| 2025-01-28 09:30:00 | ES | Futures | 6212.03 | 6214.08 | 6177.16 | 6193.83 | 178133.0 |
| 2025-01-28 10:00:00 | ES | Futures | 6193.83 | 6234.08 | 6192.8 | 6230.74 | 139388.0 |
| 2025-01-28 10:30:00 | ES | Futures | 6231.0 | 6237.41 | 6223.31 | 6236.9 | 112577.0 |
| 2025-01-28 11:00:00 | ES | Futures | 6237.15 | 6242.54 | 6215.87 | 6219.98 | 115111.0 |
| 2025-01-28 11:30:00 | ES | Futures | 6219.98 | 6232.28 | 6214.85 | 6232.03 | 99650.0 |
| 2025-01-28 12:00:00 | ES | Futures | 6231.77 | 6245.87 | 6229.98 | 6243.56 | 81954.0 |
| 2025-01-28 12:30:00 | ES | Futures | 6243.82 | 6247.92 | 6239.46 | 6245.36 | 61069.0 |
| 2025-01-28 13:00:00 | ES | Futures | 6245.36 | 6254.84 | 6244.08 | 6248.95 | 59243.0 |
| 2025-01-28 13:30:00 | ES | Futures | 6248.95 | 6251.77 | 6241.77 | 6244.59 | 60743.0 |
| 2025-01-28 14:00:00 | ES | Futures | 6244.85 | 6248.43 | 6238.95 | 6247.15 | 54396.0 |
| 2025-01-28 14:30:00 | ES | Futures | 6247.41 | 6259.97 | 6247.15 | 6258.69 | 55923.0 |
| 2025-01-28 15:00:00 | ES | Futures | 6258.43 | 6261.25 | 6254.08 | 6257.92 | 61676.0 |
| 2025-01-28 15:30:00 | ES | Futures | 6257.92 | 6259.72 | 6250.74 | 6251.51 | 146903.0 |
| 2025-01-28 16:00:00 | ES | Futures | 6251.51 | 6251.77 | 6245.1 | 6245.87 | 46796.0 |
| 2025-01-28 16:30:00 | ES | Futures | 6245.87 | 6247.41 | 6245.1 | 6246.64 | 5798.0 |
| 2025-01-28 18:00:00 | ES | Futures | 6246.13 | 6250.23 | 6241.77 | 6247.92 | 4266.0 |
| 2025-01-28 18:30:00 | ES | Futures | 6247.67 | 6247.92 | 6241.77 | 6243.05 | 2362.0 |
| 2025-01-28 19:00:00 | ES | Futures | 6243.05 | 6248.95 | 6241.77 | 6245.36 | 2771.0 |
| 2025-01-28 19:30:00 | ES | Futures | 6245.36 | 6248.18 | 6243.56 | 6247.67 | 1762.0 |
| 2025-01-28 20:00:00 | ES | Futures | 6247.41 | 6248.69 | 6245.36 | 6248.18 | 1669.0 |
| 2025-01-28 20:30:00 | ES | Futures | 6248.18 | 6249.46 | 6247.15 | 6247.15 | 1282.0 |
| 2025-01-28 21:00:00 | ES | Futures | 6247.41 | 6248.43 | 6245.61 | 6246.38 | 1031.0 |
| 2025-01-28 21:30:00 | ES | Futures | 6246.64 | 6251.25 | 6246.38 | 6249.97 | 1722.0 |
| 2025-01-28 22:00:00 | ES | Futures | 6249.97 | 6250.23 | 6244.08 | 6246.13 | 2296.0 |
| 2025-01-28 22:30:00 | ES | Futures | 6245.87 | 6249.72 | 6244.08 | 6249.72 | 1414.0 |
| 2025-01-28 23:00:00 | ES | Futures | 6249.72 | 6255.36 | 6249.72 | 6255.1 | 3108.0 |
| 2025-01-28 23:30:00 | ES | Futures | 6255.1 | 6255.1 | 6252.28 | 6252.54 | 962.0 |
| 2025-01-28 00:00:00 | NQ | Futures | 21926.71 | 21941.38 | 21905.86 | 21911.27 | 1182.0 |
| 2025-01-28 00:30:00 | NQ | Futures | 21909.98 | 21919.25 | 21870.61 | 21917.96 | 2295.0 |
| 2025-01-28 01:00:00 | NQ | Futures | 21918.22 | 21934.94 | 21911.01 | 21921.82 | 1865.0 |
| 2025-01-28 01:30:00 | NQ | Futures | 21922.08 | 21939.32 | 21889.14 | 21916.67 | 2280.0 |
> showing 50 of 4,024 rows — these rows as CSV