PREVIEW / futures_30min / 2008-04-16
file: by_date/futures_30min/2008/2008-04-16.parquet size: 69 KB rows: 2,304
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-04-16 00:00:00 | ES | Futures | 1251.07 | 1251.53 | 1250.84 | 1251.3 | 294.0 |
| 2008-04-16 00:30:00 | ES | Futures | 1251.3 | 1251.53 | 1251.07 | 1251.53 | 224.0 |
| 2008-04-16 01:00:00 | ES | Futures | 1251.77 | 1251.77 | 1250.84 | 1251.53 | 503.0 |
| 2008-04-16 01:30:00 | ES | Futures | 1251.53 | 1252.0 | 1250.6 | 1250.84 | 591.0 |
| 2008-04-16 02:00:00 | ES | Futures | 1250.84 | 1250.84 | 1248.51 | 1248.97 | 3970.0 |
| 2008-04-16 02:30:00 | ES | Futures | 1248.97 | 1249.67 | 1248.51 | 1248.51 | 1362.0 |
| 2008-04-16 03:00:00 | ES | Futures | 1248.74 | 1249.9 | 1248.04 | 1248.04 | 4630.0 |
| 2008-04-16 03:30:00 | ES | Futures | 1248.28 | 1249.67 | 1248.04 | 1248.97 | 3189.0 |
| 2008-04-16 04:00:00 | ES | Futures | 1248.74 | 1250.84 | 1248.28 | 1250.84 | 2847.0 |
| 2008-04-16 04:30:00 | ES | Futures | 1250.84 | 1251.53 | 1249.9 | 1251.53 | 3622.0 |
| 2008-04-16 05:00:00 | ES | Futures | 1251.3 | 1251.53 | 1247.81 | 1248.28 | 5584.0 |
| 2008-04-16 05:30:00 | ES | Futures | 1248.04 | 1248.74 | 1245.48 | 1246.65 | 12235.0 |
| 2008-04-16 06:00:00 | ES | Futures | 1246.65 | 1247.81 | 1246.18 | 1247.81 | 3556.0 |
| 2008-04-16 06:30:00 | ES | Futures | 1247.81 | 1249.44 | 1246.88 | 1248.51 | 5066.0 |
| 2008-04-16 07:00:00 | ES | Futures | 1248.97 | 1251.3 | 1248.04 | 1250.84 | 13645.0 |
| 2008-04-16 07:30:00 | ES | Futures | 1250.84 | 1250.84 | 1249.9 | 1250.37 | 6890.0 |
| 2008-04-16 08:00:00 | ES | Futures | 1250.37 | 1252.93 | 1248.28 | 1249.9 | 22009.0 |
| 2008-04-16 08:30:00 | ES | Futures | 1250.6 | 1254.79 | 1250.37 | 1254.56 | 62499.0 |
| 2008-04-16 09:00:00 | ES | Futures | 1254.79 | 1256.42 | 1254.1 | 1254.56 | 46196.0 |
| 2008-04-16 09:30:00 | ES | Futures | 1254.56 | 1258.75 | 1254.1 | 1256.42 | 230355.0 |
| 2008-04-16 10:00:00 | ES | Futures | 1256.66 | 1261.78 | 1254.56 | 1260.85 | 211449.0 |
| 2008-04-16 10:30:00 | ES | Futures | 1260.85 | 1264.11 | 1260.15 | 1263.88 | 194137.0 |
| 2008-04-16 11:00:00 | ES | Futures | 1263.88 | 1264.57 | 1261.08 | 1261.78 | 118146.0 |
| 2008-04-16 11:30:00 | ES | Futures | 1261.55 | 1262.94 | 1259.92 | 1261.08 | 102908.0 |
| 2008-04-16 12:00:00 | ES | Futures | 1261.08 | 1265.51 | 1260.85 | 1264.81 | 79846.0 |
| 2008-04-16 12:30:00 | ES | Futures | 1264.81 | 1265.74 | 1263.18 | 1264.81 | 70141.0 |
| 2008-04-16 13:00:00 | ES | Futures | 1264.81 | 1265.74 | 1262.48 | 1264.57 | 79700.0 |
| 2008-04-16 13:30:00 | ES | Futures | 1264.34 | 1264.81 | 1262.01 | 1263.41 | 56569.0 |
| 2008-04-16 14:00:00 | ES | Futures | 1263.41 | 1263.88 | 1260.62 | 1262.94 | 96915.0 |
| 2008-04-16 14:30:00 | ES | Futures | 1263.18 | 1267.37 | 1262.94 | 1266.2 | 115308.0 |
| 2008-04-16 15:00:00 | ES | Futures | 1266.2 | 1269.93 | 1265.74 | 1269.23 | 132725.0 |
| 2008-04-16 15:30:00 | ES | Futures | 1269.46 | 1273.66 | 1267.83 | 1270.63 | 226236.0 |
| 2008-04-16 16:00:00 | ES | Futures | 1270.63 | 1277.38 | 1270.63 | 1276.91 | 134597.0 |
| 2008-04-16 16:30:00 | ES | Futures | 1276.91 | 1278.08 | 1276.22 | 1276.45 | 13062.0 |
| 2008-04-16 17:00:00 | ES | Futures | 1276.22 | 1276.45 | 1275.05 | 1275.05 | 3331.0 |
| 2008-04-16 18:00:00 | ES | Futures | 1275.28 | 1275.98 | 1274.59 | 1275.52 | 2415.0 |
| 2008-04-16 18:30:00 | ES | Futures | 1275.52 | 1275.98 | 1274.82 | 1275.75 | 764.0 |
| 2008-04-16 19:00:00 | ES | Futures | 1275.75 | 1275.98 | 1273.89 | 1274.59 | 1518.0 |
| 2008-04-16 19:30:00 | ES | Futures | 1274.35 | 1274.82 | 1273.89 | 1274.12 | 570.0 |
| 2008-04-16 20:00:00 | ES | Futures | 1273.89 | 1274.59 | 1273.89 | 1274.35 | 521.0 |
| 2008-04-16 20:30:00 | ES | Futures | 1274.59 | 1274.82 | 1274.12 | 1274.35 | 564.0 |
| 2008-04-16 21:00:00 | ES | Futures | 1274.59 | 1274.82 | 1274.35 | 1274.59 | 286.0 |
| 2008-04-16 21:30:00 | ES | Futures | 1274.35 | 1275.98 | 1274.35 | 1274.82 | 1041.0 |
| 2008-04-16 22:00:00 | ES | Futures | 1274.82 | 1274.82 | 1273.89 | 1274.35 | 1019.0 |
| 2008-04-16 22:30:00 | ES | Futures | 1274.35 | 1274.82 | 1274.12 | 1274.59 | 364.0 |
| 2008-04-16 23:00:00 | ES | Futures | 1274.59 | 1275.28 | 1274.59 | 1274.59 | 527.0 |
| 2008-04-16 23:30:00 | ES | Futures | 1274.82 | 1276.68 | 1274.59 | 1276.45 | 1304.0 |
| 2008-04-16 00:00:00 | NQ | Futures | 2058.14 | 2058.99 | 2057.86 | 2058.99 | 53.0 |
| 2008-04-16 00:30:00 | NQ | Futures | 2058.99 | 2060.12 | 2057.86 | 2060.12 | 67.0 |
| 2008-04-16 01:00:00 | NQ | Futures | 2059.56 | 2060.41 | 2058.43 | 2060.12 | 111.0 |
> showing 50 of 2,304 rows — these rows as CSV