PREVIEW / futures_1hour / 2010-12-16
file: by_date/futures_1hour/2010/2010-12-16.parquet size: 47 KB rows: 1,449
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-16 00:00:00 | ES | Futures | 1218.83 | 1219.57 | 1218.58 | 1219.32 | 1788.0 |
| 2010-12-16 01:00:00 | ES | Futures | 1219.32 | 1220.31 | 1219.07 | 1219.57 | 3163.0 |
| 2010-12-16 02:00:00 | ES | Futures | 1219.57 | 1219.82 | 1217.84 | 1219.32 | 7299.0 |
| 2010-12-16 03:00:00 | ES | Futures | 1219.57 | 1221.05 | 1218.33 | 1220.56 | 20828.0 |
| 2010-12-16 04:00:00 | ES | Futures | 1220.81 | 1221.55 | 1219.57 | 1221.05 | 15717.0 |
| 2010-12-16 05:00:00 | ES | Futures | 1221.05 | 1221.3 | 1219.07 | 1219.32 | 13619.0 |
| 2010-12-16 06:00:00 | ES | Futures | 1219.32 | 1221.55 | 1218.33 | 1221.3 | 14545.0 |
| 2010-12-16 07:00:00 | ES | Futures | 1221.55 | 1222.29 | 1217.84 | 1219.07 | 38529.0 |
| 2010-12-16 08:00:00 | ES | Futures | 1219.07 | 1221.05 | 1218.83 | 1219.82 | 39607.0 |
| 2010-12-16 09:00:00 | ES | Futures | 1219.82 | 1221.05 | 1214.87 | 1215.36 | 159762.0 |
| 2010-12-16 10:00:00 | ES | Futures | 1215.11 | 1219.82 | 1215.11 | 1219.32 | 293441.0 |
| 2010-12-16 11:00:00 | ES | Futures | 1219.32 | 1224.52 | 1218.83 | 1223.77 | 230769.0 |
| 2010-12-16 12:00:00 | ES | Futures | 1224.02 | 1226.5 | 1223.03 | 1226.0 | 101428.0 |
| 2010-12-16 13:00:00 | ES | Futures | 1225.75 | 1226.5 | 1224.27 | 1225.26 | 77943.0 |
| 2010-12-16 14:00:00 | ES | Futures | 1225.51 | 1226.0 | 1223.03 | 1223.53 | 112534.0 |
| 2010-12-16 15:00:00 | ES | Futures | 1223.28 | 1225.75 | 1222.78 | 1225.26 | 241264.0 |
| 2010-12-16 16:00:00 | ES | Futures | 1225.51 | 1226.99 | 1225.01 | 1226.5 | 112487.0 |
| 2010-12-16 17:00:00 | ES | Futures | 1226.5 | 1226.74 | 1225.51 | 1225.75 | 1966.0 |
| 2010-12-16 18:00:00 | ES | Futures | 1226.0 | 1226.5 | 1225.01 | 1225.51 | 5242.0 |
| 2010-12-16 19:00:00 | ES | Futures | 1225.51 | 1225.75 | 1224.76 | 1225.75 | 3202.0 |
| 2010-12-16 20:00:00 | ES | Futures | 1225.51 | 1226.0 | 1225.26 | 1225.51 | 2948.0 |
| 2010-12-16 21:00:00 | ES | Futures | 1225.75 | 1225.75 | 1225.01 | 1225.26 | 2111.0 |
| 2010-12-16 22:00:00 | ES | Futures | 1225.01 | 1225.75 | 1224.27 | 1225.01 | 3723.0 |
| 2010-12-16 23:00:00 | ES | Futures | 1224.76 | 1225.26 | 1224.52 | 1224.76 | 1579.0 |
| 2010-12-16 00:00:00 | NQ | Futures | 2527.32 | 2528.76 | 2527.03 | 2528.18 | 121.0 |
| 2010-12-16 01:00:00 | NQ | Futures | 2528.47 | 2531.34 | 2528.18 | 2529.04 | 324.0 |
| 2010-12-16 02:00:00 | NQ | Futures | 2529.04 | 2529.9 | 2525.89 | 2529.33 | 582.0 |
| 2010-12-16 03:00:00 | NQ | Futures | 2529.33 | 2532.49 | 2527.61 | 2531.91 | 1763.0 |
| 2010-12-16 04:00:00 | NQ | Futures | 2531.91 | 2533.35 | 2530.19 | 2533.06 | 1907.0 |
| 2010-12-16 05:00:00 | NQ | Futures | 2533.06 | 2533.06 | 2528.76 | 2529.33 | 901.0 |
| 2010-12-16 06:00:00 | NQ | Futures | 2528.76 | 2533.06 | 2527.32 | 2532.77 | 1342.0 |
| 2010-12-16 07:00:00 | NQ | Futures | 2533.06 | 2534.5 | 2526.75 | 2529.04 | 2881.0 |
| 2010-12-16 08:00:00 | NQ | Futures | 2529.04 | 2533.06 | 2529.04 | 2531.34 | 3972.0 |
| 2010-12-16 09:00:00 | NQ | Futures | 2531.34 | 2535.93 | 2523.59 | 2523.59 | 28404.0 |
| 2010-12-16 10:00:00 | NQ | Futures | 2523.59 | 2537.08 | 2523.3 | 2535.93 | 33897.0 |
| 2010-12-16 11:00:00 | NQ | Futures | 2536.22 | 2549.42 | 2534.21 | 2547.41 | 36442.0 |
| 2010-12-16 12:00:00 | NQ | Futures | 2547.41 | 2550.86 | 2545.69 | 2550.0 | 16358.0 |
| 2010-12-16 13:00:00 | NQ | Futures | 2550.0 | 2550.28 | 2545.98 | 2546.55 | 13526.0 |
| 2010-12-16 14:00:00 | NQ | Futures | 2546.55 | 2548.27 | 2543.68 | 2544.26 | 12651.0 |
| 2010-12-16 15:00:00 | NQ | Futures | 2544.26 | 2548.85 | 2543.97 | 2546.26 | 29539.0 |
| 2010-12-16 16:00:00 | NQ | Futures | 2546.55 | 2554.3 | 2545.4 | 2550.57 | 15031.0 |
| 2010-12-16 17:00:00 | NQ | Futures | 2550.0 | 2551.43 | 2548.56 | 2548.56 | 340.0 |
| 2010-12-16 18:00:00 | NQ | Futures | 2549.42 | 2550.28 | 2547.99 | 2549.42 | 147.0 |
| 2010-12-16 19:00:00 | NQ | Futures | 2549.14 | 2550.0 | 2547.99 | 2549.42 | 131.0 |
| 2010-12-16 20:00:00 | NQ | Futures | 2549.14 | 2551.43 | 2549.14 | 2550.28 | 357.0 |
| 2010-12-16 21:00:00 | NQ | Futures | 2550.0 | 2550.0 | 2549.14 | 2549.42 | 86.0 |
| 2010-12-16 22:00:00 | NQ | Futures | 2549.42 | 2550.0 | 2547.99 | 2548.27 | 125.0 |
| 2010-12-16 23:00:00 | NQ | Futures | 2548.27 | 2548.56 | 2547.13 | 2547.7 | 167.0 |
| 2010-12-16 00:00:00 | YM | Futures | 10928.3 | 10934.0 | 10925.4 | 10932.1 | 97.0 |
| 2010-12-16 01:00:00 | YM | Futures | 10932.1 | 10939.8 | 10931.2 | 10933.1 | 166.0 |
> showing 50 of 1,449 rows — these rows as CSV