PREVIEW / futures_30min / 2008-02-20
file: by_date/futures_30min/2008/2008-02-20.parquet size: 50 KB rows: 1,648
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-02-20 00:00:00 | ES | Futures | 1256.71 | 1257.88 | 1256.25 | 1256.25 | 2094.0 |
| 2008-02-20 00:30:00 | ES | Futures | 1256.25 | 1256.71 | 1255.31 | 1256.25 | 1723.0 |
| 2008-02-20 01:00:00 | ES | Futures | 1256.25 | 1256.48 | 1255.31 | 1255.31 | 1226.0 |
| 2008-02-20 01:30:00 | ES | Futures | 1255.55 | 1255.78 | 1254.61 | 1255.31 | 2383.0 |
| 2008-02-20 02:00:00 | ES | Futures | 1255.08 | 1256.48 | 1254.38 | 1255.78 | 5994.0 |
| 2008-02-20 02:30:00 | ES | Futures | 1256.01 | 1257.88 | 1255.08 | 1255.31 | 4585.0 |
| 2008-02-20 03:00:00 | ES | Futures | 1255.31 | 1257.18 | 1253.45 | 1256.25 | 10955.0 |
| 2008-02-20 03:30:00 | ES | Futures | 1256.25 | 1258.58 | 1255.31 | 1257.64 | 9648.0 |
| 2008-02-20 04:00:00 | ES | Futures | 1257.64 | 1259.28 | 1255.55 | 1258.58 | 6337.0 |
| 2008-02-20 04:30:00 | ES | Futures | 1258.58 | 1261.84 | 1257.88 | 1261.84 | 12210.0 |
| 2008-02-20 05:00:00 | ES | Futures | 1261.61 | 1261.61 | 1257.41 | 1257.88 | 6132.0 |
| 2008-02-20 05:30:00 | ES | Futures | 1257.64 | 1259.74 | 1255.55 | 1256.01 | 8478.0 |
| 2008-02-20 06:00:00 | ES | Futures | 1256.01 | 1256.71 | 1254.38 | 1256.01 | 5925.0 |
| 2008-02-20 06:30:00 | ES | Futures | 1256.25 | 1256.71 | 1253.91 | 1254.15 | 6005.0 |
| 2008-02-20 07:00:00 | ES | Futures | 1254.15 | 1255.31 | 1249.48 | 1251.82 | 28120.0 |
| 2008-02-20 07:30:00 | ES | Futures | 1252.05 | 1253.91 | 1251.82 | 1252.75 | 9075.0 |
| 2008-02-20 08:00:00 | ES | Futures | 1252.51 | 1254.85 | 1247.15 | 1247.62 | 24515.0 |
| 2008-02-20 08:30:00 | ES | Futures | 1247.85 | 1249.72 | 1242.96 | 1246.92 | 83344.0 |
| 2008-02-20 09:00:00 | ES | Futures | 1247.15 | 1249.02 | 1244.82 | 1248.55 | 35886.0 |
| 2008-02-20 09:30:00 | ES | Futures | 1248.55 | 1253.21 | 1247.15 | 1249.48 | 225768.0 |
| 2008-02-20 10:00:00 | ES | Futures | 1249.48 | 1253.91 | 1246.22 | 1252.05 | 174862.0 |
| 2008-02-20 10:30:00 | ES | Futures | 1251.82 | 1254.38 | 1249.95 | 1250.65 | 131210.0 |
| 2008-02-20 11:00:00 | ES | Futures | 1250.65 | 1254.15 | 1249.02 | 1252.51 | 85856.0 |
| 2008-02-20 11:30:00 | ES | Futures | 1252.51 | 1252.98 | 1250.18 | 1251.58 | 57266.0 |
| 2008-02-20 12:00:00 | ES | Futures | 1251.58 | 1264.17 | 1250.65 | 1260.91 | 271452.0 |
| 2008-02-20 12:30:00 | ES | Futures | 1260.68 | 1262.54 | 1259.74 | 1260.21 | 78250.0 |
| 2008-02-20 13:00:00 | ES | Futures | 1260.21 | 1266.74 | 1259.51 | 1260.68 | 117567.0 |
| 2008-02-20 13:30:00 | ES | Futures | 1260.44 | 1265.11 | 1258.58 | 1262.31 | 79364.0 |
| 2008-02-20 14:00:00 | ES | Futures | 1262.31 | 1267.44 | 1257.88 | 1262.31 | 207336.0 |
| 2008-02-20 14:30:00 | ES | Futures | 1262.07 | 1272.8 | 1260.91 | 1270.93 | 172711.0 |
| 2008-02-20 15:00:00 | ES | Futures | 1270.93 | 1271.63 | 1265.34 | 1266.04 | 112045.0 |
| 2008-02-20 15:30:00 | ES | Futures | 1266.04 | 1269.54 | 1264.17 | 1268.6 | 126138.0 |
| 2008-02-20 16:00:00 | ES | Futures | 1268.37 | 1268.84 | 1266.74 | 1267.44 | 64972.0 |
| 2008-02-20 16:30:00 | ES | Futures | 1266.74 | 1267.44 | 1266.04 | 1266.97 | 3762.0 |
| 2008-02-20 17:00:00 | ES | Futures | 1267.2 | 1267.9 | 1266.74 | 1267.2 | 1593.0 |
| 2008-02-20 18:00:00 | ES | Futures | 1267.44 | 1269.07 | 1267.44 | 1269.07 | 1341.0 |
| 2008-02-20 18:30:00 | ES | Futures | 1269.07 | 1269.77 | 1268.6 | 1269.07 | 1599.0 |
| 2008-02-20 19:00:00 | ES | Futures | 1269.07 | 1269.54 | 1268.84 | 1269.54 | 631.0 |
| 2008-02-20 19:30:00 | ES | Futures | 1269.54 | 1271.17 | 1269.3 | 1269.54 | 1764.0 |
| 2008-02-20 20:00:00 | ES | Futures | 1269.54 | 1271.17 | 1269.3 | 1270.47 | 583.0 |
| 2008-02-20 20:30:00 | ES | Futures | 1270.47 | 1271.17 | 1270.23 | 1271.17 | 569.0 |
| 2008-02-20 21:00:00 | ES | Futures | 1270.93 | 1271.17 | 1270.0 | 1270.7 | 387.0 |
| 2008-02-20 21:30:00 | ES | Futures | 1270.7 | 1270.7 | 1268.6 | 1268.6 | 766.0 |
| 2008-02-20 22:00:00 | ES | Futures | 1268.84 | 1269.77 | 1268.37 | 1268.84 | 520.0 |
| 2008-02-20 22:30:00 | ES | Futures | 1268.84 | 1271.17 | 1268.37 | 1271.17 | 1077.0 |
| 2008-02-20 23:00:00 | ES | Futures | 1270.93 | 1271.87 | 1270.93 | 1270.93 | 741.0 |
| 2008-02-20 23:30:00 | ES | Futures | 1271.4 | 1271.4 | 1270.23 | 1270.93 | 238.0 |
| 2008-02-20 00:00:00 | NQ | Futures | 2015.57 | 2017.28 | 2014.72 | 2015.01 | 256.0 |
| 2008-02-20 00:30:00 | NQ | Futures | 2015.29 | 2015.86 | 2013.59 | 2014.15 | 99.0 |
| 2008-02-20 01:00:00 | NQ | Futures | 2014.15 | 2014.44 | 2012.17 | 2012.17 | 199.0 |
> showing 50 of 1,648 rows — these rows as CSV