PREVIEW / futures_30min / 2008-05-19
file: by_date/futures_30min/2008/2008-05-19.parquet size: 62 KB rows: 2,135
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-19 00:00:00 | ES | Futures | 1327.21 | 1327.91 | 1326.98 | 1327.67 | 266.0 |
| 2008-05-19 00:30:00 | ES | Futures | 1327.44 | 1327.91 | 1326.74 | 1326.74 | 357.0 |
| 2008-05-19 01:00:00 | ES | Futures | 1326.98 | 1327.21 | 1326.28 | 1326.98 | 802.0 |
| 2008-05-19 01:30:00 | ES | Futures | 1326.74 | 1327.21 | 1326.74 | 1327.21 | 246.0 |
| 2008-05-19 02:00:00 | ES | Futures | 1326.98 | 1327.21 | 1326.51 | 1326.98 | 783.0 |
| 2008-05-19 02:30:00 | ES | Futures | 1326.98 | 1327.21 | 1326.28 | 1327.21 | 676.0 |
| 2008-05-19 03:00:00 | ES | Futures | 1326.98 | 1327.21 | 1325.35 | 1325.81 | 3175.0 |
| 2008-05-19 03:30:00 | ES | Futures | 1325.81 | 1327.21 | 1325.35 | 1326.98 | 1847.0 |
| 2008-05-19 04:00:00 | ES | Futures | 1327.21 | 1327.67 | 1326.04 | 1326.98 | 2713.0 |
| 2008-05-19 04:30:00 | ES | Futures | 1326.74 | 1327.21 | 1325.58 | 1325.58 | 3501.0 |
| 2008-05-19 05:00:00 | ES | Futures | 1325.58 | 1327.67 | 1325.11 | 1327.21 | 2902.0 |
| 2008-05-19 05:30:00 | ES | Futures | 1327.44 | 1327.91 | 1326.74 | 1327.67 | 1605.0 |
| 2008-05-19 06:00:00 | ES | Futures | 1327.67 | 1328.61 | 1327.44 | 1328.14 | 3105.0 |
| 2008-05-19 06:30:00 | ES | Futures | 1328.14 | 1328.37 | 1327.67 | 1327.67 | 1799.0 |
| 2008-05-19 07:00:00 | ES | Futures | 1327.67 | 1328.14 | 1326.98 | 1327.21 | 3684.0 |
| 2008-05-19 07:30:00 | ES | Futures | 1326.98 | 1327.91 | 1326.98 | 1327.91 | 2466.0 |
| 2008-05-19 08:00:00 | ES | Futures | 1327.91 | 1328.84 | 1327.67 | 1327.91 | 11950.0 |
| 2008-05-19 08:30:00 | ES | Futures | 1328.14 | 1328.61 | 1327.44 | 1328.14 | 13890.0 |
| 2008-05-19 09:00:00 | ES | Futures | 1327.91 | 1328.84 | 1327.67 | 1328.61 | 10951.0 |
| 2008-05-19 09:30:00 | ES | Futures | 1328.84 | 1331.4 | 1325.81 | 1330.93 | 161119.0 |
| 2008-05-19 10:00:00 | ES | Futures | 1330.93 | 1334.19 | 1330.24 | 1333.26 | 162727.0 |
| 2008-05-19 10:30:00 | ES | Futures | 1333.26 | 1336.29 | 1333.03 | 1334.89 | 136714.0 |
| 2008-05-19 11:00:00 | ES | Futures | 1334.66 | 1338.85 | 1333.96 | 1337.69 | 133710.0 |
| 2008-05-19 11:30:00 | ES | Futures | 1337.69 | 1340.71 | 1337.45 | 1339.08 | 131654.0 |
| 2008-05-19 12:00:00 | ES | Futures | 1339.32 | 1340.71 | 1338.39 | 1340.02 | 77622.0 |
| 2008-05-19 12:30:00 | ES | Futures | 1340.25 | 1341.18 | 1338.62 | 1339.08 | 69819.0 |
| 2008-05-19 13:00:00 | ES | Futures | 1339.08 | 1342.11 | 1339.08 | 1341.65 | 75937.0 |
| 2008-05-19 13:30:00 | ES | Futures | 1341.65 | 1341.88 | 1336.76 | 1336.99 | 101299.0 |
| 2008-05-19 14:00:00 | ES | Futures | 1336.99 | 1337.22 | 1329.07 | 1330.24 | 219041.0 |
| 2008-05-19 14:30:00 | ES | Futures | 1330.24 | 1333.03 | 1330.0 | 1332.8 | 96378.0 |
| 2008-05-19 15:00:00 | ES | Futures | 1332.56 | 1333.73 | 1330.47 | 1331.4 | 86275.0 |
| 2008-05-19 15:30:00 | ES | Futures | 1331.4 | 1331.87 | 1324.18 | 1329.07 | 190447.0 |
| 2008-05-19 16:00:00 | ES | Futures | 1329.07 | 1332.1 | 1328.61 | 1331.4 | 60619.0 |
| 2008-05-19 16:30:00 | ES | Futures | 1330.7 | 1330.93 | 1330.0 | 1330.47 | 5702.0 |
| 2008-05-19 17:00:00 | ES | Futures | 1330.47 | 1331.17 | 1330.47 | 1330.93 | 750.0 |
| 2008-05-19 18:00:00 | ES | Futures | 1330.93 | 1330.93 | 1330.47 | 1330.47 | 773.0 |
| 2008-05-19 18:30:00 | ES | Futures | 1330.7 | 1330.93 | 1330.24 | 1330.24 | 257.0 |
| 2008-05-19 19:00:00 | ES | Futures | 1330.47 | 1330.7 | 1330.24 | 1330.47 | 249.0 |
| 2008-05-19 19:30:00 | ES | Futures | 1330.47 | 1330.7 | 1330.47 | 1330.47 | 223.0 |
| 2008-05-19 20:00:00 | ES | Futures | 1330.47 | 1330.7 | 1330.24 | 1330.47 | 622.0 |
| 2008-05-19 20:30:00 | ES | Futures | 1330.7 | 1331.17 | 1330.47 | 1330.47 | 967.0 |
| 2008-05-19 21:00:00 | ES | Futures | 1330.7 | 1330.7 | 1330.0 | 1330.24 | 821.0 |
| 2008-05-19 21:30:00 | ES | Futures | 1330.24 | 1330.47 | 1329.77 | 1330.0 | 1279.0 |
| 2008-05-19 22:00:00 | ES | Futures | 1329.77 | 1330.47 | 1329.77 | 1329.77 | 1923.0 |
| 2008-05-19 22:30:00 | ES | Futures | 1329.77 | 1330.24 | 1329.77 | 1329.77 | 779.0 |
| 2008-05-19 23:00:00 | ES | Futures | 1330.0 | 1330.0 | 1329.54 | 1329.54 | 444.0 |
| 2008-05-19 23:30:00 | ES | Futures | 1329.54 | 1329.77 | 1328.84 | 1329.07 | 1268.0 |
| 2008-05-19 00:00:00 | NQ | Futures | 2300.81 | 2302.22 | 2300.81 | 2300.81 | 23.0 |
| 2008-05-19 00:30:00 | NQ | Futures | 2301.66 | 2302.79 | 2301.09 | 2301.94 | 62.0 |
| 2008-05-19 01:00:00 | NQ | Futures | 2300.53 | 2302.79 | 2300.53 | 2301.94 | 116.0 |
> showing 50 of 2,135 rows — these rows as CSV