PREVIEW / futures_1hour / 2009-04-26
file: by_date/futures_1hour/2009/2009-04-26.parquet size: 13 KB rows: 236
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-26 18:00:00 | ES | Futures | 827.46 | 827.46 | 818.11 | 819.55 | 16380.0 |
| 2009-04-26 19:00:00 | ES | Futures | 819.55 | 820.51 | 818.59 | 820.03 | 5955.0 |
| 2009-04-26 20:00:00 | ES | Futures | 820.03 | 820.03 | 816.19 | 819.07 | 12342.0 |
| 2009-04-26 21:00:00 | ES | Futures | 819.07 | 819.31 | 817.15 | 817.63 | 5120.0 |
| 2009-04-26 22:00:00 | ES | Futures | 817.39 | 817.63 | 814.28 | 814.28 | 8138.0 |
| 2009-04-26 23:00:00 | ES | Futures | 814.52 | 815.71 | 811.64 | 812.84 | 7700.0 |
| 2009-04-26 18:00:00 | NQ | Futures | 1554.81 | 1556.23 | 1543.45 | 1544.02 | 1368.0 |
| 2009-04-26 19:00:00 | NQ | Futures | 1543.73 | 1545.72 | 1543.45 | 1544.58 | 276.0 |
| 2009-04-26 20:00:00 | NQ | Futures | 1545.15 | 1545.72 | 1537.76 | 1544.02 | 1119.0 |
| 2009-04-26 21:00:00 | NQ | Futures | 1544.02 | 1545.44 | 1541.46 | 1541.46 | 251.0 |
| 2009-04-26 22:00:00 | NQ | Futures | 1541.46 | 1542.31 | 1538.9 | 1538.9 | 599.0 |
| 2009-04-26 23:00:00 | NQ | Futures | 1539.19 | 1541.17 | 1534.64 | 1536.34 | 564.0 |
| 2009-04-26 18:00:00 | YM | Futures | 7385.6 | 7385.6 | 7310.2 | 7312.1 | 766.0 |
| 2009-04-26 19:00:00 | YM | Futures | 7313.0 | 7318.5 | 7304.7 | 7313.9 | 462.0 |
| 2009-04-26 20:00:00 | YM | Futures | 7311.2 | 7315.8 | 7284.5 | 7310.2 | 800.0 |
| 2009-04-26 21:00:00 | YM | Futures | 7310.2 | 7311.2 | 7298.3 | 7300.1 | 403.0 |
| 2009-04-26 22:00:00 | YM | Futures | 7299.2 | 7299.2 | 7276.2 | 7276.2 | 557.0 |
| 2009-04-26 23:00:00 | YM | Futures | 7279.0 | 7286.3 | 7258.8 | 7264.3 | 569.0 |
| 2009-04-26 18:00:00 | CL | Futures | 124.879 | 124.879 | 123.302 | 123.544 | 729.0 |
| 2009-04-26 19:00:00 | CL | Futures | 123.569 | 123.569 | 123.18 | 123.277 | 552.0 |
| 2009-04-26 20:00:00 | CL | Futures | 123.253 | 123.253 | 122.452 | 122.573 | 1198.0 |
| 2009-04-26 21:00:00 | CL | Futures | 122.573 | 123.374 | 122.549 | 123.132 | 736.0 |
| 2009-04-26 22:00:00 | CL | Futures | 123.107 | 123.253 | 122.282 | 122.331 | 609.0 |
| 2009-04-26 23:00:00 | CL | Futures | 122.355 | 122.768 | 122.258 | 122.258 | 550.0 |
| 2009-04-26 18:00:00 | GC | Futures | 1298.5 | 1303.5 | 1298.5 | 1303.0 | 2516.0 |
| 2009-04-26 19:00:00 | GC | Futures | 1303.0 | 1304.2 | 1301.1 | 1303.9 | 700.0 |
| 2009-04-26 20:00:00 | GC | Futures | 1303.8 | 1305.2 | 1302.1 | 1302.1 | 1051.0 |
| 2009-04-26 21:00:00 | GC | Futures | 1302.1 | 1302.3 | 1300.1 | 1300.3 | 748.0 |
| 2009-04-26 22:00:00 | GC | Futures | 1300.1 | 1301.3 | 1298.8 | 1298.8 | 509.0 |
| 2009-04-26 23:00:00 | GC | Futures | 1298.9 | 1302.2 | 1298.8 | 1301.8 | 697.0 |
| 2009-04-26 18:00:00 | ZN | Futures | 95.101545 | 95.223642 | 95.101545 | 95.199223 | 3595.0 |
| 2009-04-26 19:00:00 | ZN | Futures | 95.211432 | 95.248061 | 95.199223 | 95.235852 | 1657.0 |
| 2009-04-26 20:00:00 | ZN | Futures | 95.223642 | 95.260271 | 95.162593 | 95.187013 | 3729.0 |
| 2009-04-26 21:00:00 | ZN | Futures | 95.187013 | 95.211432 | 95.125964 | 95.187013 | 1923.0 |
| 2009-04-26 22:00:00 | ZN | Futures | 95.199223 | 95.235852 | 95.199223 | 95.223642 | 2629.0 |
| 2009-04-26 23:00:00 | ZN | Futures | 95.223642 | 95.32132 | 95.223642 | 95.32132 | 3871.0 |
> showing 36 of 236 rows — these rows as CSV