PREVIEW / futures_1hour / 2008-01-13
file: by_date/futures_1hour/2008/2008-01-13.parquet size: 10 KB rows: 159
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-01-13 18:00:00 | ES | Futures | 1313.6 | 1318.73 | 1312.44 | 1317.57 | 7953.0 |
| 2008-01-13 19:00:00 | ES | Futures | 1317.33 | 1318.03 | 1315.93 | 1317.57 | 2630.0 |
| 2008-01-13 20:00:00 | ES | Futures | 1317.8 | 1319.2 | 1317.33 | 1317.33 | 2902.0 |
| 2008-01-13 21:00:00 | ES | Futures | 1317.33 | 1317.57 | 1316.17 | 1316.63 | 2373.0 |
| 2008-01-13 22:00:00 | ES | Futures | 1316.4 | 1317.33 | 1315.23 | 1316.4 | 2922.0 |
| 2008-01-13 23:00:00 | ES | Futures | 1316.4 | 1317.33 | 1315.93 | 1315.93 | 1127.0 |
| 2008-01-13 18:00:00 | NQ | Futures | 2188.43 | 2196.1 | 2187.87 | 2194.4 | 638.0 |
| 2008-01-13 19:00:00 | NQ | Futures | 2194.4 | 2195.53 | 2192.41 | 2195.53 | 113.0 |
| 2008-01-13 20:00:00 | NQ | Futures | 2195.25 | 2196.95 | 2194.68 | 2195.81 | 375.0 |
| 2008-01-13 21:00:00 | NQ | Futures | 2195.81 | 2195.81 | 2192.98 | 2192.98 | 98.0 |
| 2008-01-13 22:00:00 | NQ | Futures | 2192.69 | 2193.26 | 2191.84 | 2193.26 | 99.0 |
| 2008-01-13 23:00:00 | NQ | Futures | 2193.26 | 2193.54 | 2191.84 | 2192.98 | 39.0 |
| 2008-01-13 18:00:00 | YM | Futures | 11508.9 | 11547.9 | 11502.5 | 11541.6 | 185.0 |
| 2008-01-13 19:00:00 | YM | Futures | 11536.1 | 11537.9 | 11523.4 | 11535.2 | 137.0 |
| 2008-01-13 20:00:00 | YM | Futures | 11536.1 | 11548.8 | 11536.1 | 11540.7 | 168.0 |
| 2008-01-13 21:00:00 | YM | Futures | 11540.7 | 11544.3 | 11527.0 | 11527.9 | 146.0 |
| 2008-01-13 22:00:00 | YM | Futures | 11527.9 | 11534.3 | 11525.2 | 11527.9 | 103.0 |
| 2008-01-13 23:00:00 | YM | Futures | 11528.8 | 11528.8 | 11520.7 | 11520.7 | 128.0 |
| 2008-01-13 18:00:00 | CL | Futures | 347.11 | 347.22 | 345.46 | 345.87 | 1033.0 |
| 2008-01-13 19:00:00 | CL | Futures | 345.87 | 345.91 | 345.24 | 345.31 | 350.0 |
| 2008-01-13 20:00:00 | CL | Futures | 345.46 | 345.54 | 345.2 | 345.54 | 279.0 |
| 2008-01-13 21:00:00 | CL | Futures | 345.54 | 346.25 | 345.54 | 346.25 | 307.0 |
| 2008-01-13 22:00:00 | CL | Futures | 346.17 | 346.32 | 345.99 | 346.17 | 267.0 |
| 2008-01-13 23:00:00 | CL | Futures | 346.21 | 346.88 | 346.06 | 346.73 | 402.0 |
| 2008-01-13 19:00:00 | ZN | Futures | 84.223547 | 84.269116 | 84.18937 | 84.246332 | 4501.0 |
| 2008-01-13 20:00:00 | ZN | Futures | 84.246332 | 84.257724 | 84.200762 | 84.212155 | 3243.0 |
| 2008-01-13 21:00:00 | ZN | Futures | 84.212155 | 84.246332 | 84.212155 | 84.223547 | 623.0 |
| 2008-01-13 22:00:00 | ZN | Futures | 84.234939 | 84.269116 | 84.223547 | 84.246332 | 1174.0 |
| 2008-01-13 23:00:00 | ZN | Futures | 84.246332 | 84.257724 | 84.234939 | 84.234939 | 881.0 |
> showing 29 of 159 rows — these rows as CSV