PREVIEW / futures_1hour / 2009-08-09
file: by_date/futures_1hour/2009/2009-08-09.parquet size: 13 KB rows: 230
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-08-09 18:00:00 | ES | Futures | 970.21 | 970.93 | 968.28 | 969.25 | 7269.0 |
| 2009-08-09 19:00:00 | ES | Futures | 969.25 | 970.69 | 968.28 | 969.49 | 3795.0 |
| 2009-08-09 20:00:00 | ES | Futures | 969.49 | 970.93 | 969.0 | 970.45 | 4909.0 |
| 2009-08-09 21:00:00 | ES | Futures | 970.45 | 972.14 | 969.73 | 970.69 | 3424.0 |
| 2009-08-09 22:00:00 | ES | Futures | 970.69 | 971.9 | 970.45 | 971.66 | 1493.0 |
| 2009-08-09 23:00:00 | ES | Futures | 971.66 | 971.9 | 969.49 | 969.97 | 1955.0 |
| 2009-08-09 18:00:00 | NQ | Futures | 1844.43 | 1844.72 | 1839.88 | 1841.3 | 378.0 |
| 2009-08-09 19:00:00 | NQ | Futures | 1841.3 | 1843.86 | 1839.02 | 1840.73 | 483.0 |
| 2009-08-09 20:00:00 | NQ | Futures | 1840.73 | 1843.58 | 1840.16 | 1842.72 | 409.0 |
| 2009-08-09 21:00:00 | NQ | Futures | 1842.72 | 1845.29 | 1841.01 | 1843.29 | 351.0 |
| 2009-08-09 22:00:00 | NQ | Futures | 1843.58 | 1845.0 | 1843.01 | 1844.43 | 74.0 |
| 2009-08-09 23:00:00 | NQ | Futures | 1844.43 | 1845.0 | 1841.01 | 1841.58 | 161.0 |
| 2009-08-09 18:00:00 | YM | Futures | 8618.6 | 8624.1 | 8603.8 | 8611.2 | 315.0 |
| 2009-08-09 19:00:00 | YM | Futures | 8610.2 | 8622.3 | 8603.8 | 8613.9 | 365.0 |
| 2009-08-09 20:00:00 | YM | Futures | 8613.0 | 8625.0 | 8612.1 | 8624.1 | 230.0 |
| 2009-08-09 21:00:00 | YM | Futures | 8623.2 | 8636.1 | 8615.8 | 8624.1 | 222.0 |
| 2009-08-09 22:00:00 | YM | Futures | 8624.1 | 8631.5 | 8623.2 | 8630.6 | 110.0 |
| 2009-08-09 23:00:00 | YM | Futures | 8630.6 | 8634.3 | 8615.8 | 8617.6 | 261.0 |
| 2009-08-09 18:00:00 | CL | Futures | 164.99 | 164.99 | 164.18 | 164.5 | 424.0 |
| 2009-08-09 19:00:00 | CL | Futures | 164.46 | 164.81 | 164.43 | 164.64 | 198.0 |
| 2009-08-09 20:00:00 | CL | Futures | 164.71 | 164.78 | 164.32 | 164.6 | 310.0 |
| 2009-08-09 21:00:00 | CL | Futures | 164.6 | 165.3 | 164.39 | 164.99 | 443.0 |
| 2009-08-09 22:00:00 | CL | Futures | 164.97 | 165.42 | 164.97 | 165.39 | 255.0 |
| 2009-08-09 23:00:00 | CL | Futures | 165.37 | 166.0 | 165.23 | 165.95 | 596.0 |
| 2009-08-09 18:00:00 | GC | Futures | 1350.3 | 1351.4 | 1349.6 | 1350.7 | 519.0 |
| 2009-08-09 19:00:00 | GC | Futures | 1350.7 | 1350.7 | 1349.6 | 1349.9 | 226.0 |
| 2009-08-09 20:00:00 | GC | Futures | 1350.0 | 1350.0 | 1345.5 | 1348.2 | 1517.0 |
| 2009-08-09 21:00:00 | GC | Futures | 1348.0 | 1350.9 | 1348.0 | 1350.4 | 649.0 |
| 2009-08-09 22:00:00 | GC | Futures | 1350.3 | 1351.7 | 1349.7 | 1351.1 | 406.0 |
| 2009-08-09 23:00:00 | GC | Futures | 1351.3 | 1351.3 | 1350.3 | 1350.9 | 333.0 |
| 2009-08-09 18:00:00 | ZN | Futures | 91.191935 | 91.204335 | 91.117533 | 91.154734 | 767.0 |
| 2009-08-09 19:00:00 | ZN | Futures | 91.154734 | 91.179534 | 91.154734 | 91.179534 | 878.0 |
| 2009-08-09 20:00:00 | ZN | Futures | 91.167134 | 91.204335 | 91.154734 | 91.154734 | 1384.0 |
| 2009-08-09 21:00:00 | ZN | Futures | 91.154734 | 91.154734 | 91.117533 | 91.117533 | 2327.0 |
| 2009-08-09 22:00:00 | ZN | Futures | 91.117533 | 91.142333 | 91.105132 | 91.142333 | 700.0 |
| 2009-08-09 23:00:00 | ZN | Futures | 91.129933 | 91.129933 | 91.105132 | 91.105132 | 536.0 |
> showing 36 of 230 rows — these rows as CSV