PREVIEW / futures_1hour / 2018-12-25
file: by_date/futures_1hour/2018/2018-12-25.parquet size: 14 KB rows: 267
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 |
|---|---|---|---|---|---|---|---|
| 2018-12-25 18:00:00 | ES | Futures | 2551.27 | 2553.98 | 2516.77 | 2548.01 | 41790.0 |
| 2018-12-25 19:00:00 | ES | Futures | 2548.28 | 2556.7 | 2543.39 | 2550.18 | 29239.0 |
| 2018-12-25 20:00:00 | ES | Futures | 2549.91 | 2554.8 | 2533.34 | 2539.59 | 20012.0 |
| 2018-12-25 21:00:00 | ES | Futures | 2539.59 | 2542.85 | 2525.74 | 2534.16 | 17256.0 |
| 2018-12-25 22:00:00 | ES | Futures | 2534.16 | 2539.32 | 2531.44 | 2538.23 | 14401.0 |
| 2018-12-25 23:00:00 | ES | Futures | 2538.23 | 2540.67 | 2529.0 | 2529.54 | 11005.0 |
| 2018-12-25 18:00:00 | NQ | Futures | 6898.01 | 6914.66 | 6802.75 | 6898.3 | 10032.0 |
| 2018-12-25 19:00:00 | NQ | Futures | 6899.17 | 6919.04 | 6882.81 | 6907.06 | 14288.0 |
| 2018-12-25 20:00:00 | NQ | Futures | 6906.19 | 6917.58 | 6854.76 | 6874.63 | 11728.0 |
| 2018-12-25 21:00:00 | NQ | Futures | 6873.75 | 6884.86 | 6834.89 | 6851.55 | 8992.0 |
| 2018-12-25 22:00:00 | NQ | Futures | 6852.13 | 6871.12 | 6843.66 | 6867.91 | 6981.0 |
| 2018-12-25 23:00:00 | NQ | Futures | 6868.49 | 6876.97 | 6843.37 | 6846.58 | 7369.0 |
| 2018-12-25 18:00:00 | YM | Futures | 23592.4 | 23639.1 | 23290.6 | 23574.0 | 6817.0 |
| 2018-12-25 19:00:00 | YM | Futures | 23580.5 | 23669.5 | 23550.1 | 23612.0 | 7354.0 |
| 2018-12-25 20:00:00 | YM | Futures | 23610.9 | 23656.5 | 23463.2 | 23516.4 | 7011.0 |
| 2018-12-25 21:00:00 | YM | Futures | 23518.6 | 23549.0 | 23384.0 | 23457.8 | 7359.0 |
| 2018-12-25 22:00:00 | YM | Futures | 23457.8 | 23494.7 | 23414.4 | 23479.5 | 5445.0 |
| 2018-12-25 23:00:00 | YM | Futures | 23478.4 | 23505.6 | 23401.3 | 23407.8 | 3995.0 |
| 2018-12-25 18:00:00 | CL | Futures | 39.11 | 39.48 | 39.11 | 39.39 | 6411.0 |
| 2018-12-25 19:00:00 | CL | Futures | 39.39 | 39.63 | 39.36 | 39.54 | 7117.0 |
| 2018-12-25 20:00:00 | CL | Futures | 39.54 | 39.54 | 38.89 | 39.17 | 22343.0 |
| 2018-12-25 21:00:00 | CL | Futures | 39.16 | 39.22 | 38.81 | 39.06 | 15866.0 |
| 2018-12-25 22:00:00 | CL | Futures | 39.06 | 39.15 | 38.85 | 39.07 | 11090.0 |
| 2018-12-25 23:00:00 | CL | Futures | 39.06 | 39.1 | 38.97 | 38.99 | 6470.0 |
| 2018-12-25 18:00:00 | GC | Futures | 1649.7 | 1651.6 | 1646.0 | 1646.2 | 3631.0 |
| 2018-12-25 19:00:00 | GC | Futures | 1646.1 | 1646.2 | 1642.0 | 1644.0 | 6337.0 |
| 2018-12-25 20:00:00 | GC | Futures | 1644.0 | 1651.6 | 1644.0 | 1650.8 | 8180.0 |
| 2018-12-25 21:00:00 | GC | Futures | 1650.8 | 1653.1 | 1650.8 | 1652.6 | 5517.0 |
| 2018-12-25 22:00:00 | GC | Futures | 1652.6 | 1653.4 | 1652.1 | 1652.6 | 3018.0 |
| 2018-12-25 23:00:00 | GC | Futures | 1652.7 | 1653.2 | 1652.3 | 1652.9 | 1542.0 |
| 2018-12-25 18:00:00 | ZN | Futures | 122.43117 | 122.478392 | 122.320985 | 122.336726 | 14156.0 |
| 2018-12-25 19:00:00 | ZN | Futures | 122.336726 | 122.352467 | 122.242282 | 122.305245 | 11071.0 |
| 2018-12-25 20:00:00 | ZN | Futures | 122.320985 | 122.399689 | 122.305245 | 122.383948 | 4813.0 |
| 2018-12-25 21:00:00 | ZN | Futures | 122.383948 | 122.494133 | 122.352467 | 122.446911 | 11103.0 |
| 2018-12-25 22:00:00 | ZN | Futures | 122.446911 | 122.494133 | 122.446911 | 122.462652 | 3227.0 |
| 2018-12-25 23:00:00 | ZN | Futures | 122.462652 | 122.509874 | 122.462652 | 122.509874 | 3767.0 |
> showing 36 of 267 rows — these rows as CSV