PREVIEW / futures_30min / 2012-04-30
file: by_date/futures_30min/2012/2012-04-30.parquet size: 71 KB rows: 2,685
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 |
|---|---|---|---|---|---|---|---|
| 2012-04-30 00:00:00 | ES | Futures | 1416.97 | 1417.22 | 1416.46 | 1416.97 | 895.0 |
| 2012-04-30 00:30:00 | ES | Futures | 1416.71 | 1417.47 | 1416.71 | 1416.97 | 327.0 |
| 2012-04-30 01:00:00 | ES | Futures | 1416.71 | 1417.72 | 1416.71 | 1417.22 | 522.0 |
| 2012-04-30 01:30:00 | ES | Futures | 1417.22 | 1417.22 | 1416.46 | 1417.22 | 730.0 |
| 2012-04-30 02:00:00 | ES | Futures | 1416.97 | 1419.24 | 1416.46 | 1418.74 | 4055.0 |
| 2012-04-30 02:30:00 | ES | Futures | 1418.74 | 1418.99 | 1418.48 | 1418.74 | 1784.0 |
| 2012-04-30 03:00:00 | ES | Futures | 1418.48 | 1418.74 | 1415.7 | 1417.22 | 13649.0 |
| 2012-04-30 03:30:00 | ES | Futures | 1417.47 | 1417.98 | 1414.94 | 1415.19 | 13676.0 |
| 2012-04-30 04:00:00 | ES | Futures | 1414.94 | 1416.46 | 1413.68 | 1414.69 | 17790.0 |
| 2012-04-30 04:30:00 | ES | Futures | 1414.94 | 1415.7 | 1413.93 | 1415.19 | 8930.0 |
| 2012-04-30 05:00:00 | ES | Futures | 1415.45 | 1415.95 | 1413.42 | 1413.68 | 10276.0 |
| 2012-04-30 05:30:00 | ES | Futures | 1413.93 | 1414.69 | 1413.42 | 1413.93 | 7288.0 |
| 2012-04-30 06:00:00 | ES | Futures | 1413.93 | 1413.93 | 1412.41 | 1413.68 | 8378.0 |
| 2012-04-30 06:30:00 | ES | Futures | 1413.68 | 1414.44 | 1412.92 | 1413.93 | 6354.0 |
| 2012-04-30 07:00:00 | ES | Futures | 1414.18 | 1414.44 | 1412.41 | 1412.66 | 8471.0 |
| 2012-04-30 07:30:00 | ES | Futures | 1412.66 | 1413.68 | 1411.15 | 1411.65 | 14150.0 |
| 2012-04-30 08:00:00 | ES | Futures | 1411.65 | 1412.16 | 1410.39 | 1411.65 | 30034.0 |
| 2012-04-30 08:30:00 | ES | Futures | 1411.4 | 1413.17 | 1410.89 | 1412.66 | 27407.0 |
| 2012-04-30 09:00:00 | ES | Futures | 1412.92 | 1413.17 | 1411.65 | 1412.92 | 19434.0 |
| 2012-04-30 09:30:00 | ES | Futures | 1412.92 | 1413.68 | 1408.11 | 1408.87 | 226167.0 |
| 2012-04-30 10:00:00 | ES | Futures | 1408.62 | 1412.16 | 1407.86 | 1410.13 | 115479.0 |
| 2012-04-30 10:30:00 | ES | Futures | 1410.13 | 1410.39 | 1407.6 | 1408.62 | 151567.0 |
| 2012-04-30 11:00:00 | ES | Futures | 1408.87 | 1410.13 | 1408.11 | 1409.63 | 88936.0 |
| 2012-04-30 11:30:00 | ES | Futures | 1409.38 | 1410.13 | 1407.86 | 1409.88 | 44927.0 |
| 2012-04-30 12:00:00 | ES | Futures | 1409.63 | 1409.88 | 1408.36 | 1409.12 | 31633.0 |
| 2012-04-30 12:30:00 | ES | Futures | 1409.12 | 1410.39 | 1408.62 | 1409.38 | 31781.0 |
| 2012-04-30 13:00:00 | ES | Futures | 1409.12 | 1410.13 | 1408.62 | 1408.87 | 35707.0 |
| 2012-04-30 13:30:00 | ES | Futures | 1409.12 | 1409.38 | 1407.86 | 1408.87 | 35462.0 |
| 2012-04-30 14:00:00 | ES | Futures | 1409.12 | 1409.38 | 1407.35 | 1407.35 | 44808.0 |
| 2012-04-30 14:30:00 | ES | Futures | 1407.6 | 1408.36 | 1406.34 | 1407.86 | 45800.0 |
| 2012-04-30 15:00:00 | ES | Futures | 1408.11 | 1408.87 | 1407.6 | 1408.36 | 26772.0 |
| 2012-04-30 15:30:00 | ES | Futures | 1408.11 | 1410.89 | 1408.11 | 1409.63 | 125322.0 |
| 2012-04-30 16:00:00 | ES | Futures | 1409.38 | 1411.15 | 1408.62 | 1410.89 | 98929.0 |
| 2012-04-30 16:30:00 | ES | Futures | 1410.89 | 1412.16 | 1410.89 | 1411.91 | 6028.0 |
| 2012-04-30 17:00:00 | ES | Futures | 1411.91 | 1412.41 | 1411.15 | 1412.41 | 2480.0 |
| 2012-04-30 18:00:00 | ES | Futures | 1411.91 | 1412.16 | 1411.65 | 1411.91 | 1277.0 |
| 2012-04-30 18:30:00 | ES | Futures | 1411.91 | 1412.41 | 1411.65 | 1411.91 | 686.0 |
| 2012-04-30 19:00:00 | ES | Futures | 1411.91 | 1412.16 | 1411.65 | 1411.91 | 817.0 |
| 2012-04-30 19:30:00 | ES | Futures | 1411.65 | 1412.16 | 1411.65 | 1411.91 | 787.0 |
| 2012-04-30 20:00:00 | ES | Futures | 1411.91 | 1412.16 | 1410.89 | 1411.4 | 2879.0 |
| 2012-04-30 20:30:00 | ES | Futures | 1411.4 | 1411.91 | 1410.89 | 1411.15 | 1877.0 |
| 2012-04-30 21:00:00 | ES | Futures | 1411.15 | 1411.91 | 1410.64 | 1411.91 | 2460.0 |
| 2012-04-30 21:30:00 | ES | Futures | 1411.65 | 1412.92 | 1411.65 | 1412.41 | 2185.0 |
| 2012-04-30 22:00:00 | ES | Futures | 1412.41 | 1412.66 | 1412.16 | 1412.41 | 816.0 |
| 2012-04-30 22:30:00 | ES | Futures | 1412.66 | 1412.66 | 1412.16 | 1412.16 | 639.0 |
| 2012-04-30 23:00:00 | ES | Futures | 1412.16 | 1412.66 | 1412.16 | 1412.41 | 441.0 |
| 2012-04-30 23:30:00 | ES | Futures | 1412.41 | 1412.41 | 1411.65 | 1411.65 | 1069.0 |
| 2012-04-30 00:00:00 | NQ | Futures | 3170.79 | 3170.79 | 3169.93 | 3169.93 | 80.0 |
| 2012-04-30 00:30:00 | NQ | Futures | 3170.22 | 3171.08 | 3170.22 | 3170.22 | 32.0 |
| 2012-04-30 01:00:00 | NQ | Futures | 3170.22 | 3171.66 | 3170.22 | 3171.08 | 130.0 |
> showing 50 of 2,685 rows — these rows as CSV