PREVIEW / futures_1hour / 2011-12-30
file: by_date/futures_1hour/2011/2011-12-30.parquet size: 38 KB rows: 1,097
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-30 00:00:00 | ES | Futures | 1264.48 | 1264.98 | 1263.97 | 1264.48 | 1352.0 |
| 2011-12-30 01:00:00 | ES | Futures | 1264.48 | 1267.5 | 1264.48 | 1267.25 | 2715.0 |
| 2011-12-30 02:00:00 | ES | Futures | 1267.25 | 1269.52 | 1266.74 | 1267.5 | 5500.0 |
| 2011-12-30 03:00:00 | ES | Futures | 1267.5 | 1269.01 | 1264.48 | 1265.99 | 21142.0 |
| 2011-12-30 04:00:00 | ES | Futures | 1265.99 | 1267.5 | 1265.23 | 1266.74 | 12188.0 |
| 2011-12-30 05:00:00 | ES | Futures | 1266.49 | 1269.77 | 1265.99 | 1269.26 | 12310.0 |
| 2011-12-30 06:00:00 | ES | Futures | 1269.26 | 1269.77 | 1267.5 | 1268.76 | 10732.0 |
| 2011-12-30 07:00:00 | ES | Futures | 1269.01 | 1270.52 | 1268.26 | 1270.02 | 10578.0 |
| 2011-12-30 08:00:00 | ES | Futures | 1270.02 | 1270.27 | 1267.5 | 1267.75 | 11920.0 |
| 2011-12-30 09:00:00 | ES | Futures | 1267.5 | 1268.26 | 1264.73 | 1267.5 | 67463.0 |
| 2011-12-30 10:00:00 | ES | Futures | 1267.25 | 1269.26 | 1265.99 | 1267.0 | 75471.0 |
| 2011-12-30 11:00:00 | ES | Futures | 1267.0 | 1268.51 | 1266.24 | 1266.24 | 88546.0 |
| 2011-12-30 12:00:00 | ES | Futures | 1266.24 | 1266.74 | 1265.48 | 1266.24 | 39250.0 |
| 2011-12-30 13:00:00 | ES | Futures | 1266.24 | 1266.74 | 1265.48 | 1265.99 | 23876.0 |
| 2011-12-30 14:00:00 | ES | Futures | 1265.99 | 1266.24 | 1262.46 | 1264.22 | 43717.0 |
| 2011-12-30 15:00:00 | ES | Futures | 1264.22 | 1266.24 | 1261.45 | 1261.96 | 158210.0 |
| 2011-12-30 16:00:00 | ES | Futures | 1261.7 | 1263.47 | 1260.7 | 1262.96 | 88396.0 |
| 2011-12-30 00:00:00 | NQ | Futures | 2628.64 | 2628.93 | 2627.49 | 2628.06 | 68.0 |
| 2011-12-30 01:00:00 | NQ | Futures | 2628.06 | 2632.11 | 2627.78 | 2631.82 | 141.0 |
| 2011-12-30 02:00:00 | NQ | Futures | 2631.24 | 2635.57 | 2630.95 | 2634.13 | 483.0 |
| 2011-12-30 03:00:00 | NQ | Futures | 2633.84 | 2639.04 | 2628.93 | 2631.53 | 1722.0 |
| 2011-12-30 04:00:00 | NQ | Futures | 2631.82 | 2633.26 | 2628.93 | 2630.95 | 767.0 |
| 2011-12-30 05:00:00 | NQ | Futures | 2630.09 | 2635.28 | 2628.93 | 2634.42 | 508.0 |
| 2011-12-30 06:00:00 | NQ | Futures | 2634.42 | 2634.42 | 2629.8 | 2633.26 | 952.0 |
| 2011-12-30 07:00:00 | NQ | Futures | 2633.26 | 2635.86 | 2631.53 | 2635.0 | 725.0 |
| 2011-12-30 08:00:00 | NQ | Futures | 2635.28 | 2636.15 | 2628.35 | 2629.22 | 1939.0 |
| 2011-12-30 09:00:00 | NQ | Futures | 2628.64 | 2636.73 | 2626.33 | 2636.15 | 9640.0 |
| 2011-12-30 10:00:00 | NQ | Futures | 2636.15 | 2639.04 | 2631.24 | 2634.13 | 9982.0 |
| 2011-12-30 11:00:00 | NQ | Futures | 2634.13 | 2638.17 | 2633.26 | 2634.13 | 8185.0 |
| 2011-12-30 12:00:00 | NQ | Futures | 2634.13 | 2636.44 | 2632.69 | 2636.15 | 4902.0 |
| 2011-12-30 13:00:00 | NQ | Futures | 2636.15 | 2637.02 | 2634.13 | 2635.0 | 4309.0 |
| 2011-12-30 14:00:00 | NQ | Futures | 2635.0 | 2635.0 | 2626.91 | 2629.22 | 6208.0 |
| 2011-12-30 15:00:00 | NQ | Futures | 2629.22 | 2632.97 | 2624.6 | 2625.18 | 11044.0 |
| 2011-12-30 16:00:00 | NQ | Futures | 2625.18 | 2629.51 | 2622.58 | 2627.78 | 6370.0 |
| 2011-12-30 00:00:00 | YM | Futures | 12082.9 | 12084.9 | 12078.0 | 12082.9 | 119.0 |
| 2011-12-30 01:00:00 | YM | Futures | 12081.9 | 12102.8 | 12080.9 | 12102.8 | 398.0 |
| 2011-12-30 02:00:00 | YM | Futures | 12101.8 | 12119.6 | 12097.8 | 12105.7 | 657.0 |
| 2011-12-30 03:00:00 | YM | Futures | 12104.7 | 12117.6 | 12079.0 | 12093.8 | 1545.0 |
| 2011-12-30 04:00:00 | YM | Futures | 12094.8 | 12106.7 | 12085.9 | 12095.8 | 982.0 |
| 2011-12-30 05:00:00 | YM | Futures | 12094.8 | 12121.6 | 12091.9 | 12115.6 | 676.0 |
| 2011-12-30 06:00:00 | YM | Futures | 12115.6 | 12117.6 | 12100.8 | 12112.7 | 592.0 |
| 2011-12-30 07:00:00 | YM | Futures | 12114.6 | 12125.5 | 12106.7 | 12119.6 | 875.0 |
| 2011-12-30 08:00:00 | YM | Futures | 12120.6 | 12122.6 | 12100.8 | 12103.7 | 687.0 |
| 2011-12-30 09:00:00 | YM | Futures | 12102.8 | 12107.7 | 12074.0 | 12100.8 | 5639.0 |
| 2011-12-30 10:00:00 | YM | Futures | 12099.8 | 12114.6 | 12083.9 | 12093.8 | 6036.0 |
| 2011-12-30 11:00:00 | YM | Futures | 12093.8 | 12105.7 | 12082.9 | 12082.9 | 5348.0 |
| 2011-12-30 12:00:00 | YM | Futures | 12083.9 | 12090.9 | 12075.0 | 12078.0 | 2567.0 |
| 2011-12-30 13:00:00 | YM | Futures | 12078.0 | 12084.9 | 12072.0 | 12074.0 | 2358.0 |
| 2011-12-30 14:00:00 | YM | Futures | 12075.0 | 12078.0 | 12043.3 | 12054.2 | 4632.0 |
| 2011-12-30 15:00:00 | YM | Futures | 12054.2 | 12075.0 | 12036.3 | 12037.3 | 6828.0 |
> showing 50 of 1,097 rows — these rows as CSV