PREVIEW / futures_30min / 2008-06-25
file: by_date/futures_30min/2008/2008-06-25.parquet size: 63 KB rows: 2,180
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-06-25 00:00:00 | ES | Futures | 1223.43 | 1223.67 | 1222.74 | 1223.43 | 400.0 |
| 2008-06-25 00:30:00 | ES | Futures | 1223.67 | 1224.36 | 1222.97 | 1224.13 | 491.0 |
| 2008-06-25 01:00:00 | ES | Futures | 1224.13 | 1224.83 | 1223.9 | 1224.83 | 774.0 |
| 2008-06-25 01:30:00 | ES | Futures | 1224.36 | 1225.29 | 1223.9 | 1224.6 | 1176.0 |
| 2008-06-25 02:00:00 | ES | Futures | 1225.06 | 1226.22 | 1223.67 | 1225.76 | 2823.0 |
| 2008-06-25 02:30:00 | ES | Futures | 1225.76 | 1227.15 | 1225.53 | 1226.69 | 3193.0 |
| 2008-06-25 03:00:00 | ES | Futures | 1226.69 | 1228.08 | 1226.46 | 1226.92 | 6229.0 |
| 2008-06-25 03:30:00 | ES | Futures | 1226.92 | 1228.78 | 1226.92 | 1228.08 | 4523.0 |
| 2008-06-25 04:00:00 | ES | Futures | 1228.08 | 1229.48 | 1227.85 | 1227.85 | 5022.0 |
| 2008-06-25 04:30:00 | ES | Futures | 1228.08 | 1229.01 | 1227.15 | 1228.08 | 4058.0 |
| 2008-06-25 05:00:00 | ES | Futures | 1228.08 | 1229.48 | 1227.39 | 1229.24 | 2552.0 |
| 2008-06-25 05:30:00 | ES | Futures | 1229.24 | 1230.64 | 1228.55 | 1230.17 | 5755.0 |
| 2008-06-25 06:00:00 | ES | Futures | 1229.94 | 1230.41 | 1229.01 | 1229.71 | 3264.0 |
| 2008-06-25 06:30:00 | ES | Futures | 1229.48 | 1230.64 | 1229.24 | 1229.24 | 5240.0 |
| 2008-06-25 07:00:00 | ES | Futures | 1229.48 | 1231.1 | 1228.55 | 1229.71 | 9848.0 |
| 2008-06-25 07:30:00 | ES | Futures | 1229.71 | 1229.94 | 1228.32 | 1228.78 | 8085.0 |
| 2008-06-25 08:00:00 | ES | Futures | 1228.78 | 1229.01 | 1227.85 | 1228.78 | 11573.0 |
| 2008-06-25 08:30:00 | ES | Futures | 1228.78 | 1230.41 | 1228.32 | 1229.01 | 22722.0 |
| 2008-06-25 09:00:00 | ES | Futures | 1229.24 | 1229.48 | 1226.92 | 1227.39 | 19610.0 |
| 2008-06-25 09:30:00 | ES | Futures | 1227.39 | 1233.43 | 1226.46 | 1231.8 | 203910.0 |
| 2008-06-25 10:00:00 | ES | Futures | 1231.8 | 1233.66 | 1229.48 | 1230.64 | 103124.0 |
| 2008-06-25 10:30:00 | ES | Futures | 1230.41 | 1236.91 | 1230.17 | 1235.52 | 190866.0 |
| 2008-06-25 11:00:00 | ES | Futures | 1235.29 | 1236.45 | 1234.36 | 1235.75 | 76863.0 |
| 2008-06-25 11:30:00 | ES | Futures | 1235.52 | 1236.45 | 1233.43 | 1234.82 | 76247.0 |
| 2008-06-25 12:00:00 | ES | Futures | 1234.82 | 1235.06 | 1233.43 | 1234.59 | 33708.0 |
| 2008-06-25 12:30:00 | ES | Futures | 1234.82 | 1235.52 | 1232.73 | 1233.66 | 41854.0 |
| 2008-06-25 13:00:00 | ES | Futures | 1233.43 | 1235.52 | 1233.2 | 1233.66 | 25356.0 |
| 2008-06-25 13:30:00 | ES | Futures | 1233.66 | 1234.59 | 1232.73 | 1233.43 | 26861.0 |
| 2008-06-25 14:00:00 | ES | Futures | 1233.2 | 1240.63 | 1232.03 | 1234.59 | 264389.0 |
| 2008-06-25 14:30:00 | ES | Futures | 1234.82 | 1239.24 | 1231.34 | 1238.08 | 263400.0 |
| 2008-06-25 15:00:00 | ES | Futures | 1237.84 | 1243.65 | 1232.96 | 1235.06 | 258004.0 |
| 2008-06-25 15:30:00 | ES | Futures | 1235.06 | 1235.29 | 1227.62 | 1230.17 | 260873.0 |
| 2008-06-25 16:00:00 | ES | Futures | 1230.17 | 1231.8 | 1228.08 | 1229.01 | 116097.0 |
| 2008-06-25 16:30:00 | ES | Futures | 1229.24 | 1229.24 | 1225.76 | 1226.69 | 7462.0 |
| 2008-06-25 17:00:00 | ES | Futures | 1226.69 | 1226.69 | 1222.74 | 1223.2 | 6573.0 |
| 2008-06-25 18:00:00 | ES | Futures | 1223.9 | 1224.83 | 1223.43 | 1224.13 | 1233.0 |
| 2008-06-25 18:30:00 | ES | Futures | 1224.13 | 1225.06 | 1223.9 | 1224.36 | 573.0 |
| 2008-06-25 19:00:00 | ES | Futures | 1224.13 | 1225.29 | 1223.9 | 1225.29 | 374.0 |
| 2008-06-25 19:30:00 | ES | Futures | 1225.29 | 1225.99 | 1225.06 | 1225.99 | 832.0 |
| 2008-06-25 20:00:00 | ES | Futures | 1226.22 | 1226.46 | 1225.76 | 1225.99 | 539.0 |
| 2008-06-25 20:30:00 | ES | Futures | 1225.99 | 1227.39 | 1225.99 | 1226.69 | 1548.0 |
| 2008-06-25 21:00:00 | ES | Futures | 1226.69 | 1227.15 | 1226.22 | 1226.46 | 344.0 |
| 2008-06-25 21:30:00 | ES | Futures | 1226.69 | 1227.15 | 1226.46 | 1226.92 | 383.0 |
| 2008-06-25 22:00:00 | ES | Futures | 1226.92 | 1227.15 | 1226.69 | 1227.15 | 1413.0 |
| 2008-06-25 22:30:00 | ES | Futures | 1227.15 | 1227.15 | 1226.69 | 1226.69 | 344.0 |
| 2008-06-25 23:00:00 | ES | Futures | 1226.69 | 1226.92 | 1226.69 | 1226.69 | 382.0 |
| 2008-06-25 23:30:00 | ES | Futures | 1226.92 | 1227.62 | 1226.69 | 1226.69 | 564.0 |
| 2008-06-25 00:00:00 | NQ | Futures | 2153.27 | 2153.55 | 2152.42 | 2152.42 | 14.0 |
| 2008-06-25 00:30:00 | NQ | Futures | 2152.42 | 2153.83 | 2152.42 | 2153.55 | 53.0 |
| 2008-06-25 01:00:00 | NQ | Futures | 2154.11 | 2155.52 | 2154.11 | 2154.95 | 97.0 |
> showing 50 of 2,180 rows — these rows as CSV