PREVIEW / futures_30min / 2008-03-27
file: by_date/futures_30min/2008/2008-03-27.parquet size: 65 KB rows: 2,213
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-27 00:00:00 | ES | Futures | 1243.62 | 1244.78 | 1243.15 | 1244.55 | 1081.0 |
| 2008-03-27 00:30:00 | ES | Futures | 1244.55 | 1245.25 | 1244.55 | 1244.78 | 961.0 |
| 2008-03-27 01:00:00 | ES | Futures | 1244.78 | 1245.25 | 1243.85 | 1244.08 | 793.0 |
| 2008-03-27 01:30:00 | ES | Futures | 1244.08 | 1244.32 | 1243.15 | 1243.62 | 665.0 |
| 2008-03-27 02:00:00 | ES | Futures | 1243.85 | 1244.08 | 1243.39 | 1243.62 | 371.0 |
| 2008-03-27 02:30:00 | ES | Futures | 1243.85 | 1244.78 | 1243.62 | 1244.78 | 199.0 |
| 2008-03-27 03:00:00 | ES | Futures | 1244.78 | 1245.71 | 1244.32 | 1244.78 | 1932.0 |
| 2008-03-27 03:30:00 | ES | Futures | 1244.55 | 1246.65 | 1244.32 | 1246.18 | 2557.0 |
| 2008-03-27 04:00:00 | ES | Futures | 1246.18 | 1248.97 | 1245.95 | 1248.51 | 14429.0 |
| 2008-03-27 04:30:00 | ES | Futures | 1248.51 | 1249.9 | 1247.81 | 1249.9 | 12288.0 |
| 2008-03-27 05:00:00 | ES | Futures | 1249.9 | 1251.77 | 1249.67 | 1251.07 | 11577.0 |
| 2008-03-27 05:30:00 | ES | Futures | 1251.07 | 1252.47 | 1249.44 | 1250.14 | 6976.0 |
| 2008-03-27 06:00:00 | ES | Futures | 1250.14 | 1251.77 | 1249.21 | 1250.84 | 5012.0 |
| 2008-03-27 06:30:00 | ES | Futures | 1251.07 | 1252.93 | 1250.6 | 1251.53 | 8542.0 |
| 2008-03-27 07:00:00 | ES | Futures | 1251.77 | 1252.0 | 1247.34 | 1247.81 | 16875.0 |
| 2008-03-27 07:30:00 | ES | Futures | 1247.58 | 1249.67 | 1246.65 | 1248.97 | 10105.0 |
| 2008-03-27 08:00:00 | ES | Futures | 1248.74 | 1249.21 | 1246.65 | 1247.81 | 14471.0 |
| 2008-03-27 08:30:00 | ES | Futures | 1247.81 | 1255.49 | 1247.58 | 1254.56 | 71591.0 |
| 2008-03-27 09:00:00 | ES | Futures | 1254.33 | 1254.33 | 1252.47 | 1253.16 | 20787.0 |
| 2008-03-27 09:30:00 | ES | Futures | 1253.16 | 1254.56 | 1248.97 | 1251.77 | 163583.0 |
| 2008-03-27 10:00:00 | ES | Futures | 1251.77 | 1252.47 | 1241.52 | 1242.22 | 190991.0 |
| 2008-03-27 10:30:00 | ES | Futures | 1242.45 | 1244.78 | 1239.19 | 1243.85 | 203916.0 |
| 2008-03-27 11:00:00 | ES | Futures | 1243.62 | 1247.34 | 1241.76 | 1245.48 | 111966.0 |
| 2008-03-27 11:30:00 | ES | Futures | 1245.25 | 1250.37 | 1244.08 | 1248.04 | 106492.0 |
| 2008-03-27 12:00:00 | ES | Futures | 1248.04 | 1253.4 | 1246.88 | 1253.16 | 99022.0 |
| 2008-03-27 12:30:00 | ES | Futures | 1253.16 | 1255.49 | 1251.07 | 1251.07 | 90770.0 |
| 2008-03-27 13:00:00 | ES | Futures | 1251.3 | 1254.1 | 1249.44 | 1249.9 | 61451.0 |
| 2008-03-27 13:30:00 | ES | Futures | 1250.14 | 1250.37 | 1242.45 | 1244.55 | 129040.0 |
| 2008-03-27 14:00:00 | ES | Futures | 1244.55 | 1245.95 | 1241.29 | 1244.32 | 105248.0 |
| 2008-03-27 14:30:00 | ES | Futures | 1244.32 | 1251.07 | 1244.32 | 1245.95 | 135140.0 |
| 2008-03-27 15:00:00 | ES | Futures | 1245.95 | 1247.58 | 1242.22 | 1243.85 | 97389.0 |
| 2008-03-27 15:30:00 | ES | Futures | 1243.85 | 1245.02 | 1235.47 | 1236.4 | 225606.0 |
| 2008-03-27 16:00:00 | ES | Futures | 1236.17 | 1239.43 | 1236.17 | 1238.96 | 68220.0 |
| 2008-03-27 16:30:00 | ES | Futures | 1238.96 | 1241.06 | 1238.5 | 1240.36 | 6210.0 |
| 2008-03-27 17:00:00 | ES | Futures | 1240.36 | 1240.36 | 1239.19 | 1239.19 | 1096.0 |
| 2008-03-27 18:00:00 | ES | Futures | 1238.96 | 1239.66 | 1238.5 | 1239.66 | 1202.0 |
| 2008-03-27 18:30:00 | ES | Futures | 1239.66 | 1240.13 | 1239.19 | 1239.43 | 584.0 |
| 2008-03-27 19:00:00 | ES | Futures | 1239.66 | 1239.66 | 1238.03 | 1238.26 | 408.0 |
| 2008-03-27 19:30:00 | ES | Futures | 1238.26 | 1240.36 | 1238.26 | 1240.13 | 564.0 |
| 2008-03-27 20:00:00 | ES | Futures | 1240.13 | 1240.82 | 1240.13 | 1240.13 | 565.0 |
| 2008-03-27 20:30:00 | ES | Futures | 1240.36 | 1240.82 | 1239.89 | 1240.82 | 1289.0 |
| 2008-03-27 21:00:00 | ES | Futures | 1240.82 | 1241.99 | 1240.59 | 1241.76 | 1116.0 |
| 2008-03-27 21:30:00 | ES | Futures | 1241.76 | 1242.45 | 1241.29 | 1242.22 | 921.0 |
| 2008-03-27 22:00:00 | ES | Futures | 1242.22 | 1243.39 | 1241.99 | 1242.92 | 2405.0 |
| 2008-03-27 22:30:00 | ES | Futures | 1242.69 | 1243.39 | 1242.69 | 1242.92 | 380.0 |
| 2008-03-27 23:00:00 | ES | Futures | 1242.92 | 1243.39 | 1242.69 | 1243.39 | 360.0 |
| 2008-03-27 23:30:00 | ES | Futures | 1243.39 | 1246.41 | 1243.15 | 1246.18 | 4272.0 |
| 2008-03-27 00:00:00 | NQ | Futures | 2046.55 | 2047.96 | 2045.98 | 2047.68 | 83.0 |
| 2008-03-27 00:30:00 | NQ | Futures | 2047.96 | 2049.09 | 2047.11 | 2048.53 | 42.0 |
| 2008-03-27 01:00:00 | NQ | Futures | 2048.24 | 2049.09 | 2045.98 | 2046.83 | 68.0 |
> showing 50 of 2,213 rows — these rows as CSV