PREVIEW / futures_30min / 2008-05-14
file: by_date/futures_30min/2008/2008-05-14.parquet size: 65 KB rows: 2,235
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-14 00:00:00 | ES | Futures | 1306.02 | 1306.72 | 1305.79 | 1306.72 | 389.0 |
| 2008-05-14 00:30:00 | ES | Futures | 1306.49 | 1306.72 | 1306.25 | 1306.72 | 78.0 |
| 2008-05-14 01:00:00 | ES | Futures | 1306.49 | 1306.95 | 1306.25 | 1306.95 | 125.0 |
| 2008-05-14 01:30:00 | ES | Futures | 1306.95 | 1307.42 | 1306.72 | 1307.42 | 563.0 |
| 2008-05-14 02:00:00 | ES | Futures | 1307.42 | 1307.65 | 1306.49 | 1307.18 | 780.0 |
| 2008-05-14 02:30:00 | ES | Futures | 1307.42 | 1309.51 | 1307.18 | 1309.28 | 3817.0 |
| 2008-05-14 03:00:00 | ES | Futures | 1309.28 | 1310.44 | 1308.58 | 1309.05 | 6193.0 |
| 2008-05-14 03:30:00 | ES | Futures | 1309.05 | 1310.91 | 1308.58 | 1308.81 | 5334.0 |
| 2008-05-14 04:00:00 | ES | Futures | 1308.81 | 1309.75 | 1308.58 | 1308.81 | 2309.0 |
| 2008-05-14 04:30:00 | ES | Futures | 1308.81 | 1310.21 | 1308.81 | 1309.51 | 2601.0 |
| 2008-05-14 05:00:00 | ES | Futures | 1309.51 | 1309.98 | 1307.88 | 1308.35 | 5136.0 |
| 2008-05-14 05:30:00 | ES | Futures | 1308.35 | 1308.35 | 1307.42 | 1307.88 | 4968.0 |
| 2008-05-14 06:00:00 | ES | Futures | 1307.65 | 1307.88 | 1305.09 | 1305.55 | 5969.0 |
| 2008-05-14 06:30:00 | ES | Futures | 1305.55 | 1307.88 | 1305.09 | 1307.65 | 5919.0 |
| 2008-05-14 07:00:00 | ES | Futures | 1307.42 | 1307.65 | 1302.76 | 1304.62 | 17806.0 |
| 2008-05-14 07:30:00 | ES | Futures | 1304.86 | 1306.49 | 1304.62 | 1306.25 | 8347.0 |
| 2008-05-14 08:00:00 | ES | Futures | 1306.49 | 1307.18 | 1305.32 | 1306.95 | 12673.0 |
| 2008-05-14 08:30:00 | ES | Futures | 1307.18 | 1315.33 | 1307.18 | 1313.7 | 84419.0 |
| 2008-05-14 09:00:00 | ES | Futures | 1313.94 | 1314.4 | 1312.77 | 1313.47 | 18814.0 |
| 2008-05-14 09:30:00 | ES | Futures | 1313.24 | 1318.83 | 1312.54 | 1317.2 | 223871.0 |
| 2008-05-14 10:00:00 | ES | Futures | 1316.96 | 1318.36 | 1315.8 | 1317.43 | 133489.0 |
| 2008-05-14 10:30:00 | ES | Futures | 1317.43 | 1320.22 | 1316.96 | 1318.13 | 136850.0 |
| 2008-05-14 11:00:00 | ES | Futures | 1318.36 | 1318.83 | 1316.5 | 1318.13 | 87561.0 |
| 2008-05-14 11:30:00 | ES | Futures | 1318.13 | 1319.99 | 1317.9 | 1318.83 | 73698.0 |
| 2008-05-14 12:00:00 | ES | Futures | 1318.83 | 1320.46 | 1318.36 | 1319.06 | 52200.0 |
| 2008-05-14 12:30:00 | ES | Futures | 1319.29 | 1319.76 | 1317.9 | 1319.29 | 40476.0 |
| 2008-05-14 13:00:00 | ES | Futures | 1319.53 | 1322.32 | 1319.06 | 1321.85 | 96638.0 |
| 2008-05-14 13:30:00 | ES | Futures | 1321.85 | 1323.95 | 1321.62 | 1322.32 | 84389.0 |
| 2008-05-14 14:00:00 | ES | Futures | 1322.55 | 1323.02 | 1320.92 | 1321.85 | 72447.0 |
| 2008-05-14 14:30:00 | ES | Futures | 1321.85 | 1323.25 | 1319.99 | 1320.46 | 78677.0 |
| 2008-05-14 15:00:00 | ES | Futures | 1320.46 | 1320.92 | 1316.5 | 1317.2 | 146569.0 |
| 2008-05-14 15:30:00 | ES | Futures | 1316.96 | 1317.43 | 1311.14 | 1312.07 | 224003.0 |
| 2008-05-14 16:00:00 | ES | Futures | 1312.31 | 1313.7 | 1310.91 | 1310.91 | 82598.0 |
| 2008-05-14 16:30:00 | ES | Futures | 1310.91 | 1311.38 | 1308.58 | 1310.21 | 6297.0 |
| 2008-05-14 17:00:00 | ES | Futures | 1310.44 | 1310.91 | 1310.21 | 1310.21 | 966.0 |
| 2008-05-14 18:00:00 | ES | Futures | 1310.21 | 1311.38 | 1309.98 | 1311.14 | 1488.0 |
| 2008-05-14 18:30:00 | ES | Futures | 1311.14 | 1311.14 | 1310.68 | 1310.91 | 172.0 |
| 2008-05-14 19:00:00 | ES | Futures | 1310.91 | 1311.61 | 1310.44 | 1310.91 | 350.0 |
| 2008-05-14 19:30:00 | ES | Futures | 1310.91 | 1311.14 | 1310.21 | 1310.68 | 305.0 |
| 2008-05-14 20:00:00 | ES | Futures | 1310.68 | 1311.14 | 1310.44 | 1310.91 | 516.0 |
| 2008-05-14 20:30:00 | ES | Futures | 1311.14 | 1311.84 | 1310.91 | 1311.61 | 1347.0 |
| 2008-05-14 21:00:00 | ES | Futures | 1311.61 | 1312.07 | 1311.38 | 1312.07 | 627.0 |
| 2008-05-14 21:30:00 | ES | Futures | 1312.07 | 1312.07 | 1310.68 | 1310.68 | 586.0 |
| 2008-05-14 22:00:00 | ES | Futures | 1310.68 | 1311.14 | 1310.44 | 1310.91 | 683.0 |
| 2008-05-14 22:30:00 | ES | Futures | 1310.68 | 1310.91 | 1310.21 | 1310.68 | 283.0 |
| 2008-05-14 23:00:00 | ES | Futures | 1310.68 | 1310.91 | 1310.21 | 1310.44 | 319.0 |
| 2008-05-14 23:30:00 | ES | Futures | 1310.21 | 1311.38 | 1310.21 | 1311.14 | 578.0 |
| 2008-05-14 00:00:00 | NQ | Futures | 2266.59 | 2266.87 | 2266.31 | 2266.31 | 6.0 |
| 2008-05-14 00:30:00 | NQ | Futures | 2267.15 | 2267.15 | 2266.87 | 2266.87 | 2.0 |
| 2008-05-14 01:00:00 | NQ | Futures | 2267.15 | 2267.15 | 2266.59 | 2266.59 | 5.0 |
> showing 50 of 2,235 rows — these rows as CSV