PREVIEW / futures_1hour / 2010-12-20
file: by_date/futures_1hour/2010/2010-12-20.parquet size: 46 KB rows: 1,400
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-20 00:00:00 | ES | Futures | 1222.29 | 1222.54 | 1221.3 | 1222.29 | 3262.0 |
| 2010-12-20 01:00:00 | ES | Futures | 1222.29 | 1223.77 | 1221.79 | 1222.78 | 3075.0 |
| 2010-12-20 02:00:00 | ES | Futures | 1222.78 | 1224.27 | 1222.54 | 1223.77 | 4242.0 |
| 2010-12-20 03:00:00 | ES | Futures | 1224.02 | 1227.24 | 1223.28 | 1226.25 | 17685.0 |
| 2010-12-20 04:00:00 | ES | Futures | 1226.25 | 1226.99 | 1225.51 | 1225.75 | 7133.0 |
| 2010-12-20 05:00:00 | ES | Futures | 1226.0 | 1227.73 | 1225.51 | 1227.49 | 7572.0 |
| 2010-12-20 06:00:00 | ES | Futures | 1227.49 | 1229.47 | 1227.49 | 1229.47 | 19430.0 |
| 2010-12-20 07:00:00 | ES | Futures | 1229.47 | 1231.69 | 1228.97 | 1229.96 | 34857.0 |
| 2010-12-20 08:00:00 | ES | Futures | 1230.21 | 1230.95 | 1229.71 | 1229.96 | 18298.0 |
| 2010-12-20 09:00:00 | ES | Futures | 1229.96 | 1230.95 | 1228.48 | 1229.22 | 99827.0 |
| 2010-12-20 10:00:00 | ES | Futures | 1228.97 | 1229.22 | 1224.52 | 1224.52 | 244893.0 |
| 2010-12-20 11:00:00 | ES | Futures | 1224.52 | 1227.24 | 1223.53 | 1226.99 | 136712.0 |
| 2010-12-20 12:00:00 | ES | Futures | 1226.99 | 1229.71 | 1226.5 | 1229.71 | 100324.0 |
| 2010-12-20 13:00:00 | ES | Futures | 1229.71 | 1230.21 | 1229.22 | 1229.47 | 48468.0 |
| 2010-12-20 14:00:00 | ES | Futures | 1229.71 | 1232.93 | 1229.47 | 1231.2 | 157170.0 |
| 2010-12-20 15:00:00 | ES | Futures | 1231.2 | 1231.44 | 1229.22 | 1229.47 | 146327.0 |
| 2010-12-20 16:00:00 | ES | Futures | 1229.47 | 1229.96 | 1227.98 | 1228.72 | 68349.0 |
| 2010-12-20 17:00:00 | ES | Futures | 1228.72 | 1228.97 | 1228.48 | 1228.97 | 506.0 |
| 2010-12-20 18:00:00 | ES | Futures | 1229.22 | 1229.96 | 1228.23 | 1228.48 | 3747.0 |
| 2010-12-20 19:00:00 | ES | Futures | 1228.48 | 1228.97 | 1228.23 | 1228.23 | 1462.0 |
| 2010-12-20 20:00:00 | ES | Futures | 1228.48 | 1231.2 | 1228.23 | 1230.7 | 4573.0 |
| 2010-12-20 21:00:00 | ES | Futures | 1230.7 | 1233.42 | 1230.45 | 1232.68 | 9669.0 |
| 2010-12-20 22:00:00 | ES | Futures | 1232.43 | 1233.18 | 1232.19 | 1232.68 | 2111.0 |
| 2010-12-20 23:00:00 | ES | Futures | 1232.68 | 1232.93 | 1231.94 | 1232.43 | 1547.0 |
| 2010-12-20 00:00:00 | NQ | Futures | 2534.78 | 2535.64 | 2533.35 | 2535.36 | 182.0 |
| 2010-12-20 01:00:00 | NQ | Futures | 2535.36 | 2537.94 | 2535.07 | 2535.64 | 338.0 |
| 2010-12-20 02:00:00 | NQ | Futures | 2535.93 | 2539.66 | 2535.93 | 2539.09 | 597.0 |
| 2010-12-20 03:00:00 | NQ | Futures | 2539.09 | 2545.12 | 2537.65 | 2543.68 | 1799.0 |
| 2010-12-20 04:00:00 | NQ | Futures | 2543.68 | 2545.12 | 2541.96 | 2543.11 | 909.0 |
| 2010-12-20 05:00:00 | NQ | Futures | 2543.11 | 2545.98 | 2542.82 | 2545.4 | 804.0 |
| 2010-12-20 06:00:00 | NQ | Futures | 2545.69 | 2551.14 | 2545.69 | 2550.57 | 2472.0 |
| 2010-12-20 07:00:00 | NQ | Futures | 2550.86 | 2554.59 | 2550.28 | 2551.72 | 2713.0 |
| 2010-12-20 08:00:00 | NQ | Futures | 2551.72 | 2553.73 | 2551.43 | 2551.72 | 2005.0 |
| 2010-12-20 09:00:00 | NQ | Futures | 2551.72 | 2554.3 | 2545.98 | 2547.13 | 18816.0 |
| 2010-12-20 10:00:00 | NQ | Futures | 2546.84 | 2546.84 | 2532.2 | 2535.07 | 40700.0 |
| 2010-12-20 11:00:00 | NQ | Futures | 2534.78 | 2544.83 | 2532.49 | 2543.97 | 21638.0 |
| 2010-12-20 12:00:00 | NQ | Futures | 2543.97 | 2550.0 | 2539.66 | 2549.71 | 16863.0 |
| 2010-12-20 13:00:00 | NQ | Futures | 2549.71 | 2553.44 | 2549.42 | 2551.14 | 13461.0 |
| 2010-12-20 14:00:00 | NQ | Futures | 2551.14 | 2560.33 | 2550.86 | 2556.02 | 18649.0 |
| 2010-12-20 15:00:00 | NQ | Futures | 2556.02 | 2556.89 | 2549.71 | 2551.14 | 22066.0 |
| 2010-12-20 16:00:00 | NQ | Futures | 2551.14 | 2553.44 | 2547.99 | 2549.14 | 6109.0 |
| 2010-12-20 17:00:00 | NQ | Futures | 2548.85 | 2549.14 | 2547.99 | 2548.85 | 52.0 |
| 2010-12-20 18:00:00 | NQ | Futures | 2549.14 | 2551.14 | 2547.99 | 2548.85 | 221.0 |
| 2010-12-20 19:00:00 | NQ | Futures | 2548.27 | 2548.85 | 2547.99 | 2548.85 | 85.0 |
| 2010-12-20 20:00:00 | NQ | Futures | 2548.85 | 2554.3 | 2548.85 | 2552.29 | 368.0 |
| 2010-12-20 21:00:00 | NQ | Futures | 2552.87 | 2557.75 | 2552.29 | 2556.6 | 414.0 |
| 2010-12-20 22:00:00 | NQ | Futures | 2556.6 | 2558.32 | 2555.74 | 2556.02 | 215.0 |
| 2010-12-20 23:00:00 | NQ | Futures | 2555.74 | 2558.03 | 2555.74 | 2556.6 | 126.0 |
| 2010-12-20 00:00:00 | YM | Futures | 10919.7 | 10920.6 | 10911.1 | 10918.7 | 167.0 |
| 2010-12-20 01:00:00 | YM | Futures | 10919.7 | 10934.0 | 10918.7 | 10926.4 | 173.0 |
> showing 50 of 1,400 rows — these rows as CSV