PREVIEW / futures_1hour / 2010-12-15
file: by_date/futures_1hour/2010/2010-12-15.parquet size: 49 KB rows: 1,450
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-15 00:00:00 | ES | Futures | 1222.54 | 1223.53 | 1222.54 | 1223.03 | 1424.0 |
| 2010-12-15 01:00:00 | ES | Futures | 1223.03 | 1223.03 | 1219.57 | 1219.57 | 10424.0 |
| 2010-12-15 02:00:00 | ES | Futures | 1219.82 | 1220.81 | 1218.58 | 1220.06 | 9189.0 |
| 2010-12-15 03:00:00 | ES | Futures | 1220.06 | 1221.3 | 1217.34 | 1217.84 | 31048.0 |
| 2010-12-15 04:00:00 | ES | Futures | 1217.59 | 1220.31 | 1217.09 | 1219.32 | 17970.0 |
| 2010-12-15 05:00:00 | ES | Futures | 1219.57 | 1219.57 | 1217.34 | 1218.33 | 15365.0 |
| 2010-12-15 06:00:00 | ES | Futures | 1218.33 | 1220.31 | 1217.84 | 1219.57 | 12142.0 |
| 2010-12-15 07:00:00 | ES | Futures | 1219.57 | 1222.04 | 1219.07 | 1220.31 | 22119.0 |
| 2010-12-15 08:00:00 | ES | Futures | 1220.06 | 1222.29 | 1219.32 | 1220.56 | 45074.0 |
| 2010-12-15 09:00:00 | ES | Futures | 1220.56 | 1225.01 | 1219.32 | 1224.76 | 177421.0 |
| 2010-12-15 10:00:00 | ES | Futures | 1224.76 | 1226.74 | 1224.27 | 1225.26 | 227175.0 |
| 2010-12-15 11:00:00 | ES | Futures | 1225.51 | 1226.5 | 1223.03 | 1224.02 | 168721.0 |
| 2010-12-15 12:00:00 | ES | Futures | 1224.02 | 1224.27 | 1219.32 | 1220.81 | 172125.0 |
| 2010-12-15 13:00:00 | ES | Futures | 1220.81 | 1222.54 | 1219.57 | 1222.54 | 155171.0 |
| 2010-12-15 14:00:00 | ES | Futures | 1222.54 | 1222.54 | 1216.1 | 1217.34 | 248093.0 |
| 2010-12-15 15:00:00 | ES | Futures | 1217.09 | 1222.04 | 1216.85 | 1218.33 | 348839.0 |
| 2010-12-15 16:00:00 | ES | Futures | 1218.58 | 1221.05 | 1218.33 | 1220.81 | 90897.0 |
| 2010-12-15 17:00:00 | ES | Futures | 1220.56 | 1221.05 | 1219.57 | 1220.81 | 1761.0 |
| 2010-12-15 18:00:00 | ES | Futures | 1220.56 | 1220.56 | 1217.59 | 1218.08 | 6681.0 |
| 2010-12-15 19:00:00 | ES | Futures | 1217.84 | 1218.33 | 1216.85 | 1217.84 | 7879.0 |
| 2010-12-15 20:00:00 | ES | Futures | 1217.84 | 1219.32 | 1217.09 | 1219.07 | 4133.0 |
| 2010-12-15 21:00:00 | ES | Futures | 1219.32 | 1219.32 | 1217.34 | 1217.84 | 3013.0 |
| 2010-12-15 22:00:00 | ES | Futures | 1217.59 | 1218.33 | 1216.85 | 1217.84 | 3703.0 |
| 2010-12-15 23:00:00 | ES | Futures | 1218.08 | 1218.83 | 1218.08 | 1218.58 | 2184.0 |
| 2010-12-15 00:00:00 | NQ | Futures | 2540.81 | 2542.25 | 2540.24 | 2540.24 | 366.0 |
| 2010-12-15 01:00:00 | NQ | Futures | 2540.24 | 2540.52 | 2533.64 | 2533.64 | 669.0 |
| 2010-12-15 02:00:00 | NQ | Futures | 2533.92 | 2536.22 | 2531.63 | 2533.92 | 724.0 |
| 2010-12-15 03:00:00 | NQ | Futures | 2533.92 | 2535.93 | 2528.76 | 2529.33 | 2618.0 |
| 2010-12-15 04:00:00 | NQ | Futures | 2529.04 | 2534.21 | 2528.18 | 2532.49 | 1434.0 |
| 2010-12-15 05:00:00 | NQ | Futures | 2532.49 | 2532.49 | 2528.76 | 2530.48 | 1326.0 |
| 2010-12-15 06:00:00 | NQ | Futures | 2531.05 | 2535.07 | 2529.62 | 2533.35 | 1074.0 |
| 2010-12-15 07:00:00 | NQ | Futures | 2533.35 | 2537.08 | 2532.49 | 2534.5 | 1924.0 |
| 2010-12-15 08:00:00 | NQ | Futures | 2534.78 | 2539.38 | 2532.2 | 2535.07 | 5008.0 |
| 2010-12-15 09:00:00 | NQ | Futures | 2534.78 | 2539.95 | 2533.64 | 2539.66 | 26395.0 |
| 2010-12-15 10:00:00 | NQ | Futures | 2539.66 | 2552.87 | 2537.94 | 2549.71 | 42218.0 |
| 2010-12-15 11:00:00 | NQ | Futures | 2550.0 | 2552.01 | 2538.23 | 2542.53 | 29080.0 |
| 2010-12-15 12:00:00 | NQ | Futures | 2542.53 | 2542.82 | 2529.33 | 2530.77 | 26550.0 |
| 2010-12-15 13:00:00 | NQ | Futures | 2531.05 | 2532.77 | 2526.75 | 2532.49 | 25625.0 |
| 2010-12-15 14:00:00 | NQ | Futures | 2532.77 | 2533.35 | 2521.29 | 2522.73 | 29049.0 |
| 2010-12-15 15:00:00 | NQ | Futures | 2522.73 | 2535.07 | 2521.87 | 2527.32 | 49058.0 |
| 2010-12-15 16:00:00 | NQ | Futures | 2527.32 | 2532.2 | 2527.03 | 2531.63 | 10122.0 |
| 2010-12-15 17:00:00 | NQ | Futures | 2531.34 | 2531.34 | 2528.47 | 2530.48 | 121.0 |
| 2010-12-15 18:00:00 | NQ | Futures | 2530.48 | 2531.05 | 2524.74 | 2525.6 | 369.0 |
| 2010-12-15 19:00:00 | NQ | Futures | 2525.31 | 2525.6 | 2522.73 | 2525.02 | 698.0 |
| 2010-12-15 20:00:00 | NQ | Futures | 2525.31 | 2528.47 | 2524.16 | 2528.47 | 286.0 |
| 2010-12-15 21:00:00 | NQ | Futures | 2528.18 | 2528.18 | 2525.02 | 2525.6 | 232.0 |
| 2010-12-15 22:00:00 | NQ | Futures | 2525.6 | 2525.89 | 2523.59 | 2525.02 | 200.0 |
| 2010-12-15 23:00:00 | NQ | Futures | 2525.6 | 2528.18 | 2525.31 | 2527.32 | 238.0 |
| 2010-12-15 00:00:00 | YM | Futures | 10925.4 | 10932.1 | 10925.4 | 10930.2 | 86.0 |
| 2010-12-15 01:00:00 | YM | Futures | 10931.2 | 10931.2 | 10901.5 | 10902.4 | 494.0 |
> showing 50 of 1,450 rows — these rows as CSV