PREVIEW / futures_30min / 2012-04-04
file: by_date/futures_30min/2012/2012-04-04.parquet size: 77 KB rows: 2,781
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-04 00:00:00 | ES | Futures | 1420.0 | 1421.27 | 1419.75 | 1420.51 | 1886.0 |
| 2012-04-04 00:30:00 | ES | Futures | 1420.51 | 1421.27 | 1420.0 | 1420.0 | 1934.0 |
| 2012-04-04 01:00:00 | ES | Futures | 1420.25 | 1420.76 | 1419.24 | 1419.75 | 3336.0 |
| 2012-04-04 01:30:00 | ES | Futures | 1419.75 | 1420.51 | 1419.5 | 1420.0 | 2076.0 |
| 2012-04-04 02:00:00 | ES | Futures | 1420.0 | 1420.76 | 1419.24 | 1420.76 | 4579.0 |
| 2012-04-04 02:30:00 | ES | Futures | 1420.76 | 1421.01 | 1419.75 | 1420.76 | 3013.0 |
| 2012-04-04 03:00:00 | ES | Futures | 1420.76 | 1421.27 | 1418.99 | 1418.99 | 18959.0 |
| 2012-04-04 03:30:00 | ES | Futures | 1419.24 | 1419.24 | 1417.22 | 1417.72 | 25573.0 |
| 2012-04-04 04:00:00 | ES | Futures | 1417.72 | 1418.99 | 1416.46 | 1418.23 | 21623.0 |
| 2012-04-04 04:30:00 | ES | Futures | 1418.23 | 1418.74 | 1414.18 | 1414.94 | 31666.0 |
| 2012-04-04 05:00:00 | ES | Futures | 1414.69 | 1415.7 | 1413.42 | 1414.94 | 20211.0 |
| 2012-04-04 05:30:00 | ES | Futures | 1415.19 | 1415.45 | 1413.93 | 1414.94 | 15814.0 |
| 2012-04-04 06:00:00 | ES | Futures | 1414.94 | 1415.7 | 1413.17 | 1414.94 | 18346.0 |
| 2012-04-04 06:30:00 | ES | Futures | 1414.94 | 1416.21 | 1413.93 | 1414.18 | 15525.0 |
| 2012-04-04 07:00:00 | ES | Futures | 1414.18 | 1414.69 | 1412.16 | 1413.68 | 27175.0 |
| 2012-04-04 07:30:00 | ES | Futures | 1413.93 | 1415.95 | 1413.68 | 1414.69 | 17119.0 |
| 2012-04-04 08:00:00 | ES | Futures | 1414.94 | 1416.21 | 1413.93 | 1414.44 | 27562.0 |
| 2012-04-04 08:30:00 | ES | Futures | 1414.44 | 1414.94 | 1412.16 | 1413.17 | 52515.0 |
| 2012-04-04 09:00:00 | ES | Futures | 1413.42 | 1414.44 | 1412.41 | 1413.93 | 34479.0 |
| 2012-04-04 09:30:00 | ES | Futures | 1413.68 | 1415.19 | 1411.91 | 1414.69 | 144678.0 |
| 2012-04-04 10:00:00 | ES | Futures | 1414.69 | 1414.69 | 1408.62 | 1409.88 | 211697.0 |
| 2012-04-04 10:30:00 | ES | Futures | 1409.63 | 1410.39 | 1405.58 | 1405.83 | 218032.0 |
| 2012-04-04 11:00:00 | ES | Futures | 1405.83 | 1409.12 | 1405.83 | 1407.1 | 162482.0 |
| 2012-04-04 11:30:00 | ES | Futures | 1407.35 | 1410.64 | 1407.1 | 1408.87 | 111460.0 |
| 2012-04-04 12:00:00 | ES | Futures | 1408.62 | 1410.39 | 1408.11 | 1409.63 | 47113.0 |
| 2012-04-04 12:30:00 | ES | Futures | 1409.38 | 1409.63 | 1407.86 | 1408.62 | 35784.0 |
| 2012-04-04 13:00:00 | ES | Futures | 1408.36 | 1408.62 | 1405.58 | 1405.83 | 52454.0 |
| 2012-04-04 13:30:00 | ES | Futures | 1405.58 | 1409.63 | 1405.08 | 1409.38 | 51379.0 |
| 2012-04-04 14:00:00 | ES | Futures | 1409.12 | 1409.63 | 1407.1 | 1408.11 | 34307.0 |
| 2012-04-04 14:30:00 | ES | Futures | 1408.11 | 1411.91 | 1407.6 | 1410.64 | 78849.0 |
| 2012-04-04 15:00:00 | ES | Futures | 1410.89 | 1412.92 | 1409.88 | 1411.4 | 61706.0 |
| 2012-04-04 15:30:00 | ES | Futures | 1411.65 | 1413.17 | 1410.13 | 1410.64 | 145238.0 |
| 2012-04-04 16:00:00 | ES | Futures | 1410.64 | 1411.15 | 1409.63 | 1409.88 | 91607.0 |
| 2012-04-04 16:30:00 | ES | Futures | 1409.88 | 1410.13 | 1408.87 | 1409.38 | 7625.0 |
| 2012-04-04 17:00:00 | ES | Futures | 1409.12 | 1409.38 | 1407.6 | 1408.11 | 2813.0 |
| 2012-04-04 18:00:00 | ES | Futures | 1408.11 | 1410.13 | 1408.11 | 1409.88 | 4176.0 |
| 2012-04-04 18:30:00 | ES | Futures | 1409.88 | 1410.13 | 1409.38 | 1409.63 | 1386.0 |
| 2012-04-04 19:00:00 | ES | Futures | 1409.63 | 1410.13 | 1409.38 | 1409.88 | 1025.0 |
| 2012-04-04 19:30:00 | ES | Futures | 1410.13 | 1410.39 | 1409.63 | 1409.63 | 1522.0 |
| 2012-04-04 20:00:00 | ES | Futures | 1409.63 | 1410.64 | 1409.12 | 1410.64 | 4662.0 |
| 2012-04-04 20:30:00 | ES | Futures | 1410.64 | 1410.89 | 1410.13 | 1410.64 | 2481.0 |
| 2012-04-04 21:00:00 | ES | Futures | 1410.64 | 1410.89 | 1409.63 | 1409.63 | 2846.0 |
| 2012-04-04 21:30:00 | ES | Futures | 1409.88 | 1410.39 | 1407.35 | 1408.36 | 8102.0 |
| 2012-04-04 22:00:00 | ES | Futures | 1408.36 | 1409.88 | 1407.86 | 1409.63 | 3126.0 |
| 2012-04-04 22:30:00 | ES | Futures | 1409.63 | 1411.15 | 1409.38 | 1410.39 | 2979.0 |
| 2012-04-04 23:00:00 | ES | Futures | 1410.39 | 1411.65 | 1410.39 | 1411.4 | 3286.0 |
| 2012-04-04 23:30:00 | ES | Futures | 1411.4 | 1411.91 | 1410.64 | 1411.65 | 1954.0 |
| 2012-04-04 00:00:00 | NQ | Futures | 3203.76 | 3206.37 | 3202.32 | 3202.9 | 835.0 |
| 2012-04-04 00:30:00 | NQ | Futures | 3203.19 | 3204.34 | 3202.03 | 3202.32 | 423.0 |
| 2012-04-04 01:00:00 | NQ | Futures | 3202.61 | 3204.05 | 3202.03 | 3202.9 | 322.0 |
> showing 50 of 2,781 rows — these rows as CSV