PREVIEW / futures_1hour / 2010-12-14
file: by_date/futures_1hour/2010/2010-12-14.parquet size: 47 KB rows: 1,438
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-14 00:00:00 | ES | Futures | 1222.04 | 1223.77 | 1221.79 | 1223.53 | 1890.0 |
| 2010-12-14 01:00:00 | ES | Futures | 1223.53 | 1224.02 | 1223.28 | 1223.77 | 1264.0 |
| 2010-12-14 02:00:00 | ES | Futures | 1224.02 | 1225.26 | 1223.28 | 1224.76 | 7239.0 |
| 2010-12-14 03:00:00 | ES | Futures | 1224.76 | 1225.75 | 1224.27 | 1224.52 | 21783.0 |
| 2010-12-14 04:00:00 | ES | Futures | 1224.76 | 1225.01 | 1222.78 | 1224.27 | 13493.0 |
| 2010-12-14 05:00:00 | ES | Futures | 1224.27 | 1226.5 | 1223.77 | 1226.25 | 21540.0 |
| 2010-12-14 06:00:00 | ES | Futures | 1226.25 | 1226.25 | 1224.76 | 1225.01 | 9878.0 |
| 2010-12-14 07:00:00 | ES | Futures | 1225.01 | 1226.99 | 1224.76 | 1226.0 | 15218.0 |
| 2010-12-14 08:00:00 | ES | Futures | 1226.25 | 1226.25 | 1222.54 | 1225.26 | 76502.0 |
| 2010-12-14 09:00:00 | ES | Futures | 1225.01 | 1226.25 | 1223.53 | 1225.26 | 172891.0 |
| 2010-12-14 10:00:00 | ES | Futures | 1225.26 | 1227.98 | 1225.01 | 1225.75 | 244598.0 |
| 2010-12-14 11:00:00 | ES | Futures | 1225.75 | 1227.98 | 1225.51 | 1227.49 | 110618.0 |
| 2010-12-14 12:00:00 | ES | Futures | 1227.24 | 1228.48 | 1226.99 | 1227.73 | 64721.0 |
| 2010-12-14 13:00:00 | ES | Futures | 1227.73 | 1228.72 | 1227.73 | 1227.73 | 55165.0 |
| 2010-12-14 14:00:00 | ES | Futures | 1227.73 | 1229.47 | 1224.27 | 1226.74 | 214003.0 |
| 2010-12-14 15:00:00 | ES | Futures | 1226.5 | 1226.99 | 1220.06 | 1223.53 | 395048.0 |
| 2010-12-14 16:00:00 | ES | Futures | 1223.77 | 1224.76 | 1223.28 | 1223.77 | 73271.0 |
| 2010-12-14 17:00:00 | ES | Futures | 1223.77 | 1224.52 | 1223.77 | 1224.02 | 2048.0 |
| 2010-12-14 18:00:00 | ES | Futures | 1224.27 | 1224.52 | 1222.29 | 1222.78 | 7102.0 |
| 2010-12-14 19:00:00 | ES | Futures | 1223.03 | 1223.53 | 1221.55 | 1221.79 | 3276.0 |
| 2010-12-14 20:00:00 | ES | Futures | 1221.79 | 1222.54 | 1221.05 | 1221.3 | 4064.0 |
| 2010-12-14 21:00:00 | ES | Futures | 1221.05 | 1221.79 | 1220.81 | 1221.3 | 3201.0 |
| 2010-12-14 22:00:00 | ES | Futures | 1221.3 | 1222.78 | 1221.05 | 1222.54 | 4048.0 |
| 2010-12-14 23:00:00 | ES | Futures | 1222.54 | 1223.03 | 1222.04 | 1222.54 | 1522.0 |
| 2010-12-14 00:00:00 | NQ | Futures | 2534.78 | 2537.37 | 2534.78 | 2537.37 | 102.0 |
| 2010-12-14 01:00:00 | NQ | Futures | 2537.37 | 2538.51 | 2537.08 | 2538.51 | 174.0 |
| 2010-12-14 02:00:00 | NQ | Futures | 2538.23 | 2540.81 | 2537.65 | 2539.95 | 748.0 |
| 2010-12-14 03:00:00 | NQ | Futures | 2539.95 | 2541.1 | 2538.51 | 2539.66 | 1328.0 |
| 2010-12-14 04:00:00 | NQ | Futures | 2539.66 | 2540.24 | 2536.51 | 2539.09 | 1240.0 |
| 2010-12-14 05:00:00 | NQ | Futures | 2539.09 | 2543.11 | 2538.23 | 2542.53 | 1512.0 |
| 2010-12-14 06:00:00 | NQ | Futures | 2542.25 | 2542.82 | 2539.95 | 2540.52 | 913.0 |
| 2010-12-14 07:00:00 | NQ | Futures | 2540.52 | 2543.97 | 2540.24 | 2542.82 | 1557.0 |
| 2010-12-14 08:00:00 | NQ | Futures | 2542.53 | 2542.53 | 2533.92 | 2539.38 | 8591.0 |
| 2010-12-14 09:00:00 | NQ | Futures | 2539.66 | 2543.68 | 2533.35 | 2540.52 | 31048.0 |
| 2010-12-14 10:00:00 | NQ | Futures | 2540.52 | 2547.99 | 2539.95 | 2542.53 | 31373.0 |
| 2010-12-14 11:00:00 | NQ | Futures | 2542.53 | 2546.55 | 2541.39 | 2544.83 | 14622.0 |
| 2010-12-14 12:00:00 | NQ | Futures | 2545.12 | 2545.98 | 2543.11 | 2543.68 | 10236.0 |
| 2010-12-14 13:00:00 | NQ | Futures | 2543.39 | 2548.27 | 2543.11 | 2546.26 | 8613.0 |
| 2010-12-14 14:00:00 | NQ | Futures | 2545.98 | 2548.56 | 2539.66 | 2544.54 | 28775.0 |
| 2010-12-14 15:00:00 | NQ | Futures | 2544.26 | 2545.4 | 2530.77 | 2538.23 | 44008.0 |
| 2010-12-14 16:00:00 | NQ | Futures | 2537.94 | 2543.68 | 2535.36 | 2542.25 | 11865.0 |
| 2010-12-14 17:00:00 | NQ | Futures | 2542.25 | 2543.39 | 2541.96 | 2543.39 | 269.0 |
| 2010-12-14 18:00:00 | NQ | Futures | 2542.82 | 2543.39 | 2539.38 | 2540.52 | 463.0 |
| 2010-12-14 19:00:00 | NQ | Futures | 2540.24 | 2541.1 | 2537.94 | 2537.94 | 328.0 |
| 2010-12-14 20:00:00 | NQ | Futures | 2537.94 | 2539.38 | 2536.79 | 2537.08 | 221.0 |
| 2010-12-14 21:00:00 | NQ | Futures | 2537.37 | 2537.94 | 2536.51 | 2537.65 | 231.0 |
| 2010-12-14 22:00:00 | NQ | Futures | 2537.37 | 2540.81 | 2537.08 | 2540.24 | 231.0 |
| 2010-12-14 23:00:00 | NQ | Futures | 2540.24 | 2541.1 | 2539.66 | 2540.52 | 125.0 |
| 2010-12-14 00:00:00 | YM | Futures | 10876.6 | 10887.1 | 10874.7 | 10885.2 | 100.0 |
| 2010-12-14 01:00:00 | YM | Futures | 10886.2 | 10891.9 | 10884.2 | 10890.9 | 97.0 |
> showing 50 of 1,438 rows — these rows as CSV