PREVIEW / futures_1hour / 2010-12-09
file: by_date/futures_1hour/2010/2010-12-09.parquet size: 46 KB rows: 1,417
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-09 00:00:00 | ES | Futures | 1216.62 | 1220.07 | 1216.62 | 1219.33 | 12652.0 |
| 2010-12-09 01:00:00 | ES | Futures | 1219.08 | 1219.08 | 1216.87 | 1217.36 | 4449.0 |
| 2010-12-09 02:00:00 | ES | Futures | 1217.36 | 1219.08 | 1216.13 | 1217.36 | 11304.0 |
| 2010-12-09 03:00:00 | ES | Futures | 1217.61 | 1220.56 | 1216.62 | 1216.87 | 42650.0 |
| 2010-12-09 04:00:00 | ES | Futures | 1216.87 | 1218.1 | 1213.91 | 1215.14 | 19363.0 |
| 2010-12-09 05:00:00 | ES | Futures | 1215.14 | 1216.13 | 1213.66 | 1215.88 | 21580.0 |
| 2010-12-09 06:00:00 | ES | Futures | 1215.88 | 1216.62 | 1214.65 | 1215.39 | 27203.0 |
| 2010-12-09 07:00:00 | ES | Futures | 1215.39 | 1216.13 | 1214.89 | 1215.39 | 13161.0 |
| 2010-12-09 08:00:00 | ES | Futures | 1215.39 | 1218.59 | 1214.65 | 1217.36 | 44161.0 |
| 2010-12-09 09:00:00 | ES | Futures | 1217.36 | 1218.1 | 1213.91 | 1216.37 | 126719.0 |
| 2010-12-09 10:00:00 | ES | Futures | 1216.62 | 1217.11 | 1209.96 | 1211.2 | 159863.0 |
| 2010-12-09 11:00:00 | ES | Futures | 1211.2 | 1213.66 | 1209.23 | 1211.2 | 115218.0 |
| 2010-12-09 12:00:00 | ES | Futures | 1211.44 | 1212.92 | 1210.7 | 1212.43 | 51475.0 |
| 2010-12-09 13:00:00 | ES | Futures | 1212.43 | 1215.14 | 1211.94 | 1213.66 | 79387.0 |
| 2010-12-09 14:00:00 | ES | Futures | 1213.66 | 1213.91 | 1211.44 | 1213.42 | 48525.0 |
| 2010-12-09 15:00:00 | ES | Futures | 1213.42 | 1216.62 | 1212.68 | 1215.39 | 80697.0 |
| 2010-12-09 16:00:00 | ES | Futures | 1215.39 | 1216.37 | 1214.15 | 1214.65 | 30121.0 |
| 2010-12-09 17:00:00 | ES | Futures | 1214.89 | 1215.14 | 1214.65 | 1215.14 | 259.0 |
| 2010-12-09 18:00:00 | ES | Futures | 1215.14 | 1218.35 | 1215.14 | 1217.85 | 4770.0 |
| 2010-12-09 19:00:00 | ES | Futures | 1218.1 | 1218.84 | 1215.39 | 1216.87 | 4304.0 |
| 2010-12-09 20:00:00 | ES | Futures | 1216.62 | 1217.61 | 1216.13 | 1217.36 | 2163.0 |
| 2010-12-09 21:00:00 | ES | Futures | 1217.11 | 1218.84 | 1216.87 | 1217.11 | 2368.0 |
| 2010-12-09 22:00:00 | ES | Futures | 1217.36 | 1218.84 | 1217.11 | 1218.59 | 1384.0 |
| 2010-12-09 23:00:00 | ES | Futures | 1218.59 | 1218.84 | 1217.36 | 1218.1 | 1288.0 |
| 2010-12-09 00:00:00 | NQ | Futures | 2534.78 | 2540.81 | 2534.5 | 2538.8 | 932.0 |
| 2010-12-09 01:00:00 | NQ | Futures | 2539.09 | 2539.09 | 2535.36 | 2536.79 | 388.0 |
| 2010-12-09 02:00:00 | NQ | Futures | 2536.79 | 2539.09 | 2534.5 | 2536.51 | 836.0 |
| 2010-12-09 03:00:00 | NQ | Futures | 2536.22 | 2541.67 | 2535.07 | 2535.36 | 2617.0 |
| 2010-12-09 04:00:00 | NQ | Futures | 2535.36 | 2537.37 | 2528.18 | 2531.34 | 2075.0 |
| 2010-12-09 05:00:00 | NQ | Futures | 2530.77 | 2533.06 | 2528.18 | 2531.63 | 1761.0 |
| 2010-12-09 06:00:00 | NQ | Futures | 2531.63 | 2533.64 | 2530.19 | 2531.05 | 1628.0 |
| 2010-12-09 07:00:00 | NQ | Futures | 2530.77 | 2533.64 | 2529.62 | 2532.2 | 1193.0 |
| 2010-12-09 08:00:00 | NQ | Futures | 2532.2 | 2538.51 | 2531.05 | 2537.08 | 5212.0 |
| 2010-12-09 09:00:00 | NQ | Futures | 2537.08 | 2540.52 | 2528.47 | 2534.21 | 19841.0 |
| 2010-12-09 10:00:00 | NQ | Futures | 2534.21 | 2535.36 | 2519.0 | 2522.16 | 17813.0 |
| 2010-12-09 11:00:00 | NQ | Futures | 2521.87 | 2527.04 | 2517.57 | 2522.16 | 12730.0 |
| 2010-12-09 12:00:00 | NQ | Futures | 2522.45 | 2526.46 | 2521.59 | 2525.32 | 5166.0 |
| 2010-12-09 13:00:00 | NQ | Futures | 2525.32 | 2529.33 | 2524.46 | 2527.04 | 8188.0 |
| 2010-12-09 14:00:00 | NQ | Futures | 2527.04 | 2527.32 | 2520.44 | 2523.88 | 6672.0 |
| 2010-12-09 15:00:00 | NQ | Futures | 2523.88 | 2529.62 | 2522.45 | 2526.75 | 10819.0 |
| 2010-12-09 16:00:00 | NQ | Futures | 2526.46 | 2527.61 | 2521.59 | 2523.02 | 2627.0 |
| 2010-12-09 17:00:00 | NQ | Futures | 2522.73 | 2523.31 | 2522.45 | 2522.45 | 15.0 |
| 2010-12-09 18:00:00 | NQ | Futures | 2523.31 | 2536.22 | 2522.16 | 2527.9 | 296.0 |
| 2010-12-09 19:00:00 | NQ | Futures | 2528.18 | 2529.05 | 2524.46 | 2526.46 | 95.0 |
| 2010-12-09 20:00:00 | NQ | Futures | 2526.75 | 2527.61 | 2525.03 | 2527.32 | 47.0 |
| 2010-12-09 21:00:00 | NQ | Futures | 2527.32 | 2530.77 | 2527.04 | 2527.32 | 102.0 |
| 2010-12-09 22:00:00 | NQ | Futures | 2527.61 | 2529.91 | 2527.61 | 2529.62 | 28.0 |
| 2010-12-09 23:00:00 | NQ | Futures | 2529.62 | 2529.91 | 2527.9 | 2528.47 | 16.0 |
| 2010-12-09 00:00:00 | YM | Futures | 10872.6 | 10893.5 | 10871.6 | 10888.8 | 620.0 |
| 2010-12-09 01:00:00 | YM | Futures | 10888.8 | 10889.7 | 10874.5 | 10875.4 | 194.0 |
> showing 50 of 1,417 rows — these rows as CSV