PREVIEW / futures_30min / 2008-05-20
file: by_date/futures_30min/2008/2008-05-20.parquet size: 64 KB rows: 2,161
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-05-20 00:00:00 | ES | Futures | 1329.3 | 1329.77 | 1328.84 | 1329.54 | 240.0 |
| 2008-05-20 00:30:00 | ES | Futures | 1329.54 | 1329.54 | 1329.07 | 1329.07 | 177.0 |
| 2008-05-20 01:00:00 | ES | Futures | 1329.07 | 1329.54 | 1329.07 | 1329.54 | 90.0 |
| 2008-05-20 01:30:00 | ES | Futures | 1329.54 | 1329.77 | 1329.07 | 1329.07 | 482.0 |
| 2008-05-20 02:00:00 | ES | Futures | 1329.3 | 1329.3 | 1328.14 | 1328.14 | 2704.0 |
| 2008-05-20 02:30:00 | ES | Futures | 1328.37 | 1328.37 | 1326.51 | 1326.74 | 3498.0 |
| 2008-05-20 03:00:00 | ES | Futures | 1326.98 | 1328.37 | 1326.74 | 1326.98 | 6874.0 |
| 2008-05-20 03:30:00 | ES | Futures | 1326.98 | 1328.14 | 1326.51 | 1327.44 | 4323.0 |
| 2008-05-20 04:00:00 | ES | Futures | 1327.21 | 1327.91 | 1326.74 | 1327.91 | 2901.0 |
| 2008-05-20 04:30:00 | ES | Futures | 1327.91 | 1328.14 | 1326.28 | 1326.51 | 3521.0 |
| 2008-05-20 05:00:00 | ES | Futures | 1326.74 | 1326.74 | 1325.58 | 1326.04 | 5611.0 |
| 2008-05-20 05:30:00 | ES | Futures | 1326.28 | 1326.28 | 1325.35 | 1325.35 | 5910.0 |
| 2008-05-20 06:00:00 | ES | Futures | 1325.35 | 1326.74 | 1325.11 | 1325.81 | 5964.0 |
| 2008-05-20 06:30:00 | ES | Futures | 1326.04 | 1326.74 | 1325.11 | 1325.81 | 5064.0 |
| 2008-05-20 07:00:00 | ES | Futures | 1325.58 | 1326.28 | 1325.11 | 1325.11 | 6400.0 |
| 2008-05-20 07:30:00 | ES | Futures | 1325.35 | 1326.04 | 1325.11 | 1325.81 | 4310.0 |
| 2008-05-20 08:00:00 | ES | Futures | 1325.58 | 1326.98 | 1324.65 | 1325.11 | 25751.0 |
| 2008-05-20 08:30:00 | ES | Futures | 1325.11 | 1326.74 | 1321.39 | 1322.79 | 62621.0 |
| 2008-05-20 09:00:00 | ES | Futures | 1322.79 | 1323.72 | 1321.62 | 1323.72 | 37429.0 |
| 2008-05-20 09:30:00 | ES | Futures | 1323.72 | 1324.41 | 1319.76 | 1319.99 | 173450.0 |
| 2008-05-20 10:00:00 | ES | Futures | 1319.76 | 1321.62 | 1317.9 | 1320.92 | 164756.0 |
| 2008-05-20 10:30:00 | ES | Futures | 1320.92 | 1321.16 | 1317.66 | 1320.69 | 146894.0 |
| 2008-05-20 11:00:00 | ES | Futures | 1320.92 | 1321.39 | 1316.73 | 1318.13 | 136225.0 |
| 2008-05-20 11:30:00 | ES | Futures | 1317.9 | 1318.59 | 1315.1 | 1316.27 | 124052.0 |
| 2008-05-20 12:00:00 | ES | Futures | 1316.27 | 1319.99 | 1315.57 | 1319.29 | 89335.0 |
| 2008-05-20 12:30:00 | ES | Futures | 1319.06 | 1320.46 | 1316.03 | 1316.96 | 78837.0 |
| 2008-05-20 13:00:00 | ES | Futures | 1317.2 | 1319.53 | 1316.5 | 1318.36 | 61644.0 |
| 2008-05-20 13:30:00 | ES | Futures | 1318.36 | 1318.59 | 1313.7 | 1314.17 | 122113.0 |
| 2008-05-20 14:00:00 | ES | Futures | 1314.4 | 1315.57 | 1312.31 | 1313.01 | 110969.0 |
| 2008-05-20 14:30:00 | ES | Futures | 1312.77 | 1315.8 | 1312.54 | 1313.7 | 81806.0 |
| 2008-05-20 15:00:00 | ES | Futures | 1313.94 | 1318.13 | 1313.47 | 1316.5 | 106897.0 |
| 2008-05-20 15:30:00 | ES | Futures | 1316.5 | 1318.36 | 1312.31 | 1317.9 | 179799.0 |
| 2008-05-20 16:00:00 | ES | Futures | 1317.9 | 1320.69 | 1317.66 | 1319.76 | 80258.0 |
| 2008-05-20 16:30:00 | ES | Futures | 1319.76 | 1319.76 | 1318.83 | 1319.06 | 3166.0 |
| 2008-05-20 17:00:00 | ES | Futures | 1319.06 | 1319.29 | 1318.59 | 1319.06 | 790.0 |
| 2008-05-20 18:00:00 | ES | Futures | 1319.06 | 1319.29 | 1318.36 | 1318.59 | 648.0 |
| 2008-05-20 18:30:00 | ES | Futures | 1318.59 | 1319.06 | 1318.36 | 1318.83 | 610.0 |
| 2008-05-20 19:00:00 | ES | Futures | 1318.83 | 1319.99 | 1318.59 | 1319.29 | 625.0 |
| 2008-05-20 19:30:00 | ES | Futures | 1319.29 | 1319.53 | 1318.36 | 1318.59 | 549.0 |
| 2008-05-20 20:00:00 | ES | Futures | 1318.59 | 1319.06 | 1318.13 | 1318.83 | 1291.0 |
| 2008-05-20 20:30:00 | ES | Futures | 1319.06 | 1319.76 | 1318.59 | 1319.76 | 478.0 |
| 2008-05-20 21:00:00 | ES | Futures | 1319.76 | 1319.76 | 1319.06 | 1319.06 | 498.0 |
| 2008-05-20 21:30:00 | ES | Futures | 1319.29 | 1319.53 | 1318.59 | 1319.29 | 728.0 |
| 2008-05-20 22:00:00 | ES | Futures | 1319.06 | 1320.22 | 1318.83 | 1319.99 | 716.0 |
| 2008-05-20 22:30:00 | ES | Futures | 1319.99 | 1320.22 | 1319.53 | 1319.53 | 906.0 |
| 2008-05-20 23:00:00 | ES | Futures | 1319.76 | 1319.99 | 1319.53 | 1319.76 | 722.0 |
| 2008-05-20 23:30:00 | ES | Futures | 1319.99 | 1320.22 | 1319.29 | 1319.99 | 947.0 |
| 2008-05-20 00:00:00 | NQ | Futures | 2287.8 | 2288.37 | 2287.24 | 2288.08 | 47.0 |
| 2008-05-20 00:30:00 | NQ | Futures | 2288.08 | 2288.08 | 2287.24 | 2287.24 | 39.0 |
| 2008-05-20 01:00:00 | NQ | Futures | 2286.95 | 2288.08 | 2286.95 | 2287.52 | 13.0 |
> showing 50 of 2,161 rows — these rows as CSV