PREVIEW / futures_30min / 2012-08-08
file: by_date/futures_30min/2012/2012-08-08.parquet size: 74 KB rows: 2,780
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-08-08 00:00:00 | ES | Futures | 1418.9 | 1419.66 | 1418.9 | 1419.41 | 1065.0 |
| 2012-08-08 00:30:00 | ES | Futures | 1419.66 | 1419.66 | 1418.39 | 1418.65 | 1806.0 |
| 2012-08-08 01:00:00 | ES | Futures | 1418.65 | 1419.16 | 1418.14 | 1418.9 | 1572.0 |
| 2012-08-08 01:30:00 | ES | Futures | 1419.16 | 1419.41 | 1418.39 | 1419.16 | 2039.0 |
| 2012-08-08 02:00:00 | ES | Futures | 1419.41 | 1419.92 | 1418.14 | 1418.9 | 3646.0 |
| 2012-08-08 02:30:00 | ES | Futures | 1419.16 | 1419.16 | 1417.38 | 1417.88 | 4843.0 |
| 2012-08-08 03:00:00 | ES | Futures | 1417.88 | 1419.16 | 1416.61 | 1416.87 | 16059.0 |
| 2012-08-08 03:30:00 | ES | Futures | 1417.12 | 1418.39 | 1416.87 | 1417.88 | 8448.0 |
| 2012-08-08 04:00:00 | ES | Futures | 1418.14 | 1419.41 | 1417.12 | 1417.88 | 11857.0 |
| 2012-08-08 04:30:00 | ES | Futures | 1417.88 | 1418.39 | 1416.87 | 1417.38 | 9129.0 |
| 2012-08-08 05:00:00 | ES | Futures | 1417.38 | 1417.88 | 1416.61 | 1417.38 | 8064.0 |
| 2012-08-08 05:30:00 | ES | Futures | 1417.38 | 1417.63 | 1415.85 | 1416.61 | 11956.0 |
| 2012-08-08 06:00:00 | ES | Futures | 1416.87 | 1418.14 | 1415.85 | 1417.63 | 11423.0 |
| 2012-08-08 06:30:00 | ES | Futures | 1417.88 | 1419.66 | 1417.12 | 1417.12 | 13875.0 |
| 2012-08-08 07:00:00 | ES | Futures | 1417.12 | 1417.88 | 1416.61 | 1417.38 | 9333.0 |
| 2012-08-08 07:30:00 | ES | Futures | 1417.38 | 1418.14 | 1416.61 | 1416.61 | 10682.0 |
| 2012-08-08 08:00:00 | ES | Futures | 1416.87 | 1417.12 | 1414.83 | 1415.34 | 24458.0 |
| 2012-08-08 08:30:00 | ES | Futures | 1415.6 | 1416.61 | 1414.32 | 1415.09 | 23031.0 |
| 2012-08-08 09:00:00 | ES | Futures | 1415.09 | 1416.61 | 1414.83 | 1416.36 | 27526.0 |
| 2012-08-08 09:30:00 | ES | Futures | 1416.36 | 1419.66 | 1415.85 | 1418.39 | 131859.0 |
| 2012-08-08 10:00:00 | ES | Futures | 1418.14 | 1420.17 | 1417.63 | 1419.16 | 100305.0 |
| 2012-08-08 10:30:00 | ES | Futures | 1419.16 | 1419.92 | 1417.38 | 1419.16 | 97240.0 |
| 2012-08-08 11:00:00 | ES | Futures | 1419.41 | 1423.73 | 1418.9 | 1423.48 | 142833.0 |
| 2012-08-08 11:30:00 | ES | Futures | 1423.48 | 1424.24 | 1422.46 | 1422.46 | 67062.0 |
| 2012-08-08 12:00:00 | ES | Futures | 1422.72 | 1423.73 | 1422.21 | 1422.46 | 29123.0 |
| 2012-08-08 12:30:00 | ES | Futures | 1422.46 | 1422.97 | 1420.17 | 1421.95 | 52880.0 |
| 2012-08-08 13:00:00 | ES | Futures | 1422.21 | 1423.73 | 1421.7 | 1422.46 | 40781.0 |
| 2012-08-08 13:30:00 | ES | Futures | 1422.46 | 1423.22 | 1421.19 | 1421.95 | 22653.0 |
| 2012-08-08 14:00:00 | ES | Futures | 1421.95 | 1422.21 | 1419.41 | 1420.68 | 51388.0 |
| 2012-08-08 14:30:00 | ES | Futures | 1420.68 | 1421.7 | 1419.92 | 1420.43 | 50681.0 |
| 2012-08-08 15:00:00 | ES | Futures | 1420.68 | 1423.22 | 1420.43 | 1422.46 | 65634.0 |
| 2012-08-08 15:30:00 | ES | Futures | 1422.46 | 1423.48 | 1421.19 | 1422.72 | 84499.0 |
| 2012-08-08 16:00:00 | ES | Futures | 1422.72 | 1423.48 | 1421.95 | 1422.72 | 56104.0 |
| 2012-08-08 16:30:00 | ES | Futures | 1422.46 | 1422.46 | 1421.19 | 1421.7 | 4255.0 |
| 2012-08-08 17:00:00 | ES | Futures | 1421.7 | 1421.7 | 1420.94 | 1421.19 | 1165.0 |
| 2012-08-08 18:00:00 | ES | Futures | 1421.44 | 1421.95 | 1421.19 | 1421.44 | 858.0 |
| 2012-08-08 18:30:00 | ES | Futures | 1421.44 | 1421.95 | 1421.19 | 1421.44 | 599.0 |
| 2012-08-08 19:00:00 | ES | Futures | 1421.44 | 1421.44 | 1420.94 | 1421.19 | 289.0 |
| 2012-08-08 19:30:00 | ES | Futures | 1421.19 | 1421.44 | 1420.94 | 1420.94 | 629.0 |
| 2012-08-08 20:00:00 | ES | Futures | 1420.94 | 1421.7 | 1420.43 | 1420.68 | 2100.0 |
| 2012-08-08 20:30:00 | ES | Futures | 1420.68 | 1420.94 | 1420.43 | 1420.68 | 973.0 |
| 2012-08-08 21:00:00 | ES | Futures | 1420.68 | 1421.95 | 1420.43 | 1421.7 | 2563.0 |
| 2012-08-08 21:30:00 | ES | Futures | 1421.7 | 1424.5 | 1421.7 | 1424.5 | 6191.0 |
| 2012-08-08 22:00:00 | ES | Futures | 1424.24 | 1425.51 | 1423.99 | 1424.24 | 3836.0 |
| 2012-08-08 22:30:00 | ES | Futures | 1424.24 | 1425.77 | 1423.99 | 1425.0 | 3321.0 |
| 2012-08-08 23:00:00 | ES | Futures | 1425.0 | 1426.02 | 1424.75 | 1425.51 | 2448.0 |
| 2012-08-08 23:30:00 | ES | Futures | 1425.51 | 1426.02 | 1425.0 | 1426.02 | 2292.0 |
| 2012-08-08 00:00:00 | NQ | Futures | 3142.64 | 3144.67 | 3142.64 | 3144.38 | 313.0 |
| 2012-08-08 00:30:00 | NQ | Futures | 3144.38 | 3144.67 | 3142.35 | 3143.8 | 551.0 |
| 2012-08-08 01:00:00 | NQ | Futures | 3143.51 | 3144.09 | 3142.35 | 3144.09 | 459.0 |
> showing 50 of 2,780 rows — these rows as CSV