PREVIEW / futures_1hour / 2008-04-27
file: by_date/futures_1hour/2008/2008-04-27.parquet size: 13 KB rows: 227
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-27 18:00:00 | ES | Futures | 1302.76 | 1303.92 | 1299.27 | 1300.2 | 3175.0 |
| 2008-04-27 19:00:00 | ES | Futures | 1300.2 | 1300.9 | 1299.73 | 1300.43 | 1220.0 |
| 2008-04-27 20:00:00 | ES | Futures | 1300.2 | 1301.83 | 1298.57 | 1301.83 | 3026.0 |
| 2008-04-27 21:00:00 | ES | Futures | 1301.83 | 1302.29 | 1300.43 | 1301.36 | 943.0 |
| 2008-04-27 22:00:00 | ES | Futures | 1301.36 | 1301.6 | 1299.5 | 1300.2 | 985.0 |
| 2008-04-27 23:00:00 | ES | Futures | 1299.97 | 1301.83 | 1299.73 | 1301.36 | 827.0 |
| 2008-04-27 18:00:00 | NQ | Futures | 2174.67 | 2176.65 | 2170.99 | 2172.12 | 104.0 |
| 2008-04-27 19:00:00 | NQ | Futures | 2173.82 | 2174.39 | 2171.28 | 2172.12 | 58.0 |
| 2008-04-27 20:00:00 | NQ | Futures | 2172.69 | 2175.52 | 2170.71 | 2175.52 | 60.0 |
| 2008-04-27 21:00:00 | NQ | Futures | 2175.52 | 2176.37 | 2173.54 | 2173.82 | 37.0 |
| 2008-04-27 22:00:00 | NQ | Futures | 2174.39 | 2174.67 | 2170.71 | 2172.69 | 66.0 |
| 2008-04-27 23:00:00 | NQ | Futures | 2172.12 | 2176.37 | 2172.12 | 2174.39 | 62.0 |
| 2008-04-27 18:00:00 | YM | Futures | 11703.4 | 11713.4 | 11681.6 | 11692.5 | 126.0 |
| 2008-04-27 19:00:00 | YM | Futures | 11692.5 | 11692.5 | 11681.6 | 11688.0 | 62.0 |
| 2008-04-27 20:00:00 | YM | Futures | 11685.3 | 11698.9 | 11677.1 | 11698.9 | 140.0 |
| 2008-04-27 21:00:00 | YM | Futures | 11701.6 | 11703.4 | 11689.8 | 11697.1 | 116.0 |
| 2008-04-27 22:00:00 | YM | Futures | 11698.0 | 11702.5 | 11683.4 | 11687.1 | 131.0 |
| 2008-04-27 23:00:00 | YM | Futures | 11687.1 | 11698.9 | 11687.1 | 11697.1 | 83.0 |
| 2008-04-27 18:00:00 | CL | Futures | 452.43 | 456.15 | 452.39 | 453.8 | 1702.0 |
| 2008-04-27 19:00:00 | CL | Futures | 453.8 | 454.41 | 453.8 | 454.1 | 389.0 |
| 2008-04-27 20:00:00 | CL | Futures | 454.1 | 454.41 | 453.95 | 454.1 | 477.0 |
| 2008-04-27 21:00:00 | CL | Futures | 454.14 | 454.25 | 453.38 | 453.83 | 317.0 |
| 2008-04-27 22:00:00 | CL | Futures | 453.83 | 454.25 | 453.8 | 454.14 | 255.0 |
| 2008-04-27 23:00:00 | CL | Futures | 454.14 | 454.25 | 453.76 | 453.76 | 167.0 |
| 2008-04-27 18:00:00 | GC | Futures | 1289.4 | 1294.1 | 1287.7 | 1288.7 | 527.0 |
| 2008-04-27 19:00:00 | GC | Futures | 1289.2 | 1292.2 | 1288.7 | 1291.5 | 460.0 |
| 2008-04-27 20:00:00 | GC | Futures | 1291.5 | 1295.4 | 1290.5 | 1294.2 | 718.0 |
| 2008-04-27 21:00:00 | GC | Futures | 1293.6 | 1297.4 | 1293.6 | 1296.0 | 755.0 |
| 2008-04-27 22:00:00 | GC | Futures | 1296.0 | 1297.8 | 1294.8 | 1297.1 | 522.0 |
| 2008-04-27 23:00:00 | GC | Futures | 1297.1 | 1298.0 | 1296.0 | 1296.4 | 433.0 |
| 2008-04-27 18:00:00 | ZN | Futures | 85.060547 | 85.14148 | 85.025861 | 85.118356 | 1859.0 |
| 2008-04-27 19:00:00 | ZN | Futures | 85.118356 | 85.14148 | 85.095232 | 85.095232 | 1539.0 |
| 2008-04-27 20:00:00 | ZN | Futures | 85.095232 | 85.129918 | 85.095232 | 85.106794 | 1486.0 |
| 2008-04-27 21:00:00 | ZN | Futures | 85.106794 | 85.106794 | 85.025861 | 85.037423 | 3189.0 |
| 2008-04-27 22:00:00 | ZN | Futures | 85.037423 | 85.072109 | 85.037423 | 85.072109 | 816.0 |
| 2008-04-27 23:00:00 | ZN | Futures | 85.072109 | 85.072109 | 85.048985 | 85.060547 | 1283.0 |
> showing 36 of 227 rows — these rows as CSV