PREVIEW / futures_1hour / 2012-12-10
file: by_date/futures_1hour/2012/2012-12-10.parquet size: 41 KB rows: 1,322
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-12-10 00:00:00 | ES | Futures | 1447.46 | 1447.97 | 1446.69 | 1447.46 | 2410.0 |
| 2012-12-10 01:00:00 | ES | Futures | 1447.71 | 1448.48 | 1447.46 | 1447.71 | 1976.0 |
| 2012-12-10 02:00:00 | ES | Futures | 1447.46 | 1448.48 | 1443.11 | 1444.39 | 12770.0 |
| 2012-12-10 03:00:00 | ES | Futures | 1444.14 | 1446.44 | 1442.35 | 1443.88 | 30405.0 |
| 2012-12-10 04:00:00 | ES | Futures | 1443.63 | 1443.88 | 1441.84 | 1442.09 | 15877.0 |
| 2012-12-10 05:00:00 | ES | Futures | 1442.09 | 1442.86 | 1441.58 | 1442.35 | 13432.0 |
| 2012-12-10 06:00:00 | ES | Futures | 1442.35 | 1444.9 | 1442.09 | 1444.39 | 11555.0 |
| 2012-12-10 07:00:00 | ES | Futures | 1444.39 | 1444.65 | 1443.11 | 1443.88 | 15901.0 |
| 2012-12-10 08:00:00 | ES | Futures | 1443.88 | 1447.2 | 1443.88 | 1446.44 | 33320.0 |
| 2012-12-10 09:00:00 | ES | Futures | 1446.69 | 1449.76 | 1444.9 | 1448.73 | 174131.0 |
| 2012-12-10 10:00:00 | ES | Futures | 1448.73 | 1452.06 | 1447.46 | 1452.06 | 188741.0 |
| 2012-12-10 11:00:00 | ES | Futures | 1451.8 | 1452.06 | 1449.5 | 1450.01 | 92996.0 |
| 2012-12-10 12:00:00 | ES | Futures | 1450.01 | 1452.06 | 1449.5 | 1450.27 | 73875.0 |
| 2012-12-10 13:00:00 | ES | Futures | 1450.27 | 1450.52 | 1448.48 | 1448.99 | 55560.0 |
| 2012-12-10 14:00:00 | ES | Futures | 1448.73 | 1449.76 | 1446.69 | 1449.5 | 78998.0 |
| 2012-12-10 15:00:00 | ES | Futures | 1449.25 | 1450.78 | 1448.22 | 1448.73 | 166931.0 |
| 2012-12-10 16:00:00 | ES | Futures | 1448.99 | 1451.54 | 1448.22 | 1448.73 | 88402.0 |
| 2012-12-10 17:00:00 | ES | Futures | 1448.99 | 1448.99 | 1448.22 | 1448.22 | 1626.0 |
| 2012-12-10 18:00:00 | ES | Futures | 1448.48 | 1448.73 | 1446.95 | 1446.95 | 6236.0 |
| 2012-12-10 19:00:00 | ES | Futures | 1447.2 | 1447.71 | 1446.69 | 1447.2 | 5203.0 |
| 2012-12-10 20:00:00 | ES | Futures | 1447.46 | 1447.71 | 1445.92 | 1447.46 | 7798.0 |
| 2012-12-10 21:00:00 | ES | Futures | 1447.2 | 1448.99 | 1446.69 | 1448.22 | 5577.0 |
| 2012-12-10 22:00:00 | ES | Futures | 1448.22 | 1448.99 | 1447.46 | 1447.97 | 2613.0 |
| 2012-12-10 23:00:00 | ES | Futures | 1447.97 | 1448.99 | 1447.97 | 1448.73 | 4200.0 |
| 2012-12-10 00:00:00 | NQ | Futures | 3063.84 | 3064.13 | 3061.8 | 3063.26 | 916.0 |
| 2012-12-10 01:00:00 | NQ | Futures | 3063.55 | 3064.42 | 3063.26 | 3063.55 | 490.0 |
| 2012-12-10 02:00:00 | NQ | Futures | 3063.84 | 3064.42 | 3054.54 | 3055.7 | 1521.0 |
| 2012-12-10 03:00:00 | NQ | Futures | 3055.99 | 3060.93 | 3051.92 | 3054.54 | 4405.0 |
| 2012-12-10 04:00:00 | NQ | Futures | 3054.54 | 3057.44 | 3053.38 | 3054.25 | 2570.0 |
| 2012-12-10 05:00:00 | NQ | Futures | 3053.96 | 3055.99 | 3052.5 | 3054.25 | 1793.0 |
| 2012-12-10 06:00:00 | NQ | Futures | 3054.54 | 3059.48 | 3053.96 | 3058.32 | 1481.0 |
| 2012-12-10 07:00:00 | NQ | Futures | 3058.61 | 3058.9 | 3055.41 | 3056.86 | 1506.0 |
| 2012-12-10 08:00:00 | NQ | Futures | 3057.15 | 3062.09 | 3056.86 | 3060.64 | 3911.0 |
| 2012-12-10 09:00:00 | NQ | Futures | 3060.64 | 3081.56 | 3056.28 | 3078.08 | 46759.0 |
| 2012-12-10 10:00:00 | NQ | Futures | 3078.08 | 3092.31 | 3072.26 | 3091.73 | 42543.0 |
| 2012-12-10 11:00:00 | NQ | Futures | 3091.73 | 3092.6 | 3080.69 | 3081.56 | 21114.0 |
| 2012-12-10 12:00:00 | NQ | Futures | 3081.27 | 3085.05 | 3074.3 | 3076.04 | 17934.0 |
| 2012-12-10 13:00:00 | NQ | Futures | 3076.33 | 3076.91 | 3069.94 | 3074.59 | 14644.0 |
| 2012-12-10 14:00:00 | NQ | Futures | 3074.3 | 3078.95 | 3067.32 | 3078.08 | 17115.0 |
| 2012-12-10 15:00:00 | NQ | Futures | 3078.08 | 3080.4 | 3073.14 | 3076.33 | 22953.0 |
| 2012-12-10 16:00:00 | NQ | Futures | 3076.62 | 3083.31 | 3075.75 | 3078.37 | 5486.0 |
| 2012-12-10 17:00:00 | NQ | Futures | 3078.95 | 3079.24 | 3077.2 | 3077.2 | 143.0 |
| 2012-12-10 18:00:00 | NQ | Futures | 3077.2 | 3078.37 | 3075.46 | 3076.04 | 479.0 |
| 2012-12-10 19:00:00 | NQ | Futures | 3075.75 | 3077.2 | 3075.46 | 3076.33 | 312.0 |
| 2012-12-10 20:00:00 | NQ | Futures | 3076.04 | 3076.33 | 3073.43 | 3076.04 | 579.0 |
| 2012-12-10 21:00:00 | NQ | Futures | 3076.33 | 3079.24 | 3075.17 | 3077.79 | 680.0 |
| 2012-12-10 22:00:00 | NQ | Futures | 3077.79 | 3078.95 | 3076.33 | 3077.79 | 249.0 |
| 2012-12-10 23:00:00 | NQ | Futures | 3077.79 | 3079.53 | 3077.49 | 3078.66 | 388.0 |
| 2012-12-10 00:00:00 | YM | Futures | 13152.8 | 13156.8 | 13152.8 | 13153.8 | 3.0 |
| 2012-12-10 01:00:00 | YM | Futures | 13155.8 | 13161.8 | 13155.8 | 13159.8 | 17.0 |
> showing 50 of 1,322 rows — these rows as CSV