PREVIEW / futures_1hour / 2009-09-06
file: by_date/futures_1hour/2009/2009-09-06.parquet size: 10 KB rows: 160
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-09-06 18:00:00 | ES | Futures | 977.69 | 979.62 | 976.72 | 979.37 | 2802.0 |
| 2009-09-06 19:00:00 | ES | Futures | 979.13 | 979.13 | 976.72 | 976.96 | 2032.0 |
| 2009-09-06 20:00:00 | ES | Futures | 976.96 | 977.45 | 976.48 | 976.96 | 1913.0 |
| 2009-09-06 21:00:00 | ES | Futures | 976.96 | 977.93 | 976.48 | 976.96 | 1055.0 |
| 2009-09-06 22:00:00 | ES | Futures | 976.96 | 978.65 | 976.48 | 977.2 | 1588.0 |
| 2009-09-06 23:00:00 | ES | Futures | 977.2 | 978.41 | 977.2 | 977.93 | 1762.0 |
| 2009-09-06 18:00:00 | NQ | Futures | 1863.23 | 1867.22 | 1861.81 | 1866.93 | 225.0 |
| 2009-09-06 19:00:00 | NQ | Futures | 1866.65 | 1866.65 | 1862.38 | 1862.66 | 92.0 |
| 2009-09-06 20:00:00 | NQ | Futures | 1862.66 | 1863.51 | 1861.81 | 1862.38 | 242.0 |
| 2009-09-06 21:00:00 | NQ | Futures | 1862.09 | 1863.51 | 1861.24 | 1862.09 | 149.0 |
| 2009-09-06 22:00:00 | NQ | Futures | 1861.81 | 1864.94 | 1861.81 | 1863.23 | 79.0 |
| 2009-09-06 23:00:00 | NQ | Futures | 1863.51 | 1865.22 | 1863.51 | 1864.37 | 270.0 |
| 2009-09-06 18:00:00 | YM | Futures | 8700.8 | 8717.5 | 8695.3 | 8717.5 | 161.0 |
| 2009-09-06 19:00:00 | YM | Futures | 8714.7 | 8714.7 | 8699.0 | 8699.0 | 63.0 |
| 2009-09-06 20:00:00 | YM | Futures | 8698.1 | 8701.8 | 8692.5 | 8698.1 | 192.0 |
| 2009-09-06 21:00:00 | YM | Futures | 8698.1 | 8704.5 | 8695.3 | 8697.2 | 80.0 |
| 2009-09-06 22:00:00 | YM | Futures | 8696.2 | 8707.3 | 8694.4 | 8699.0 | 161.0 |
| 2009-09-06 23:00:00 | YM | Futures | 8700.8 | 8707.3 | 8700.8 | 8706.4 | 151.0 |
| 2009-09-06 18:00:00 | CL | Futures | 154.17 | 154.19 | 153.67 | 154.03 | 397.0 |
| 2009-09-06 19:00:00 | CL | Futures | 154.01 | 154.01 | 153.42 | 153.46 | 168.0 |
| 2009-09-06 20:00:00 | CL | Futures | 153.51 | 154.12 | 153.42 | 154.05 | 216.0 |
| 2009-09-06 21:00:00 | CL | Futures | 154.01 | 154.33 | 153.92 | 154.17 | 279.0 |
| 2009-09-06 22:00:00 | CL | Futures | 154.1 | 154.74 | 154.1 | 154.71 | 284.0 |
| 2009-09-06 23:00:00 | CL | Futures | 154.76 | 154.87 | 154.46 | 154.8 | 210.0 |
| 2009-09-06 18:00:00 | GC | Futures | 1404.4 | 1406.8 | 1402.8 | 1406.5 | 628.0 |
| 2009-09-06 19:00:00 | GC | Futures | 1406.6 | 1407.2 | 1404.5 | 1404.6 | 373.0 |
| 2009-09-06 20:00:00 | GC | Futures | 1404.6 | 1404.8 | 1401.1 | 1402.8 | 616.0 |
| 2009-09-06 21:00:00 | GC | Futures | 1402.2 | 1403.8 | 1402.0 | 1402.2 | 491.0 |
| 2009-09-06 22:00:00 | GC | Futures | 1402.2 | 1403.8 | 1402.0 | 1403.7 | 301.0 |
| 2009-09-06 23:00:00 | GC | Futures | 1403.5 | 1403.8 | 1402.8 | 1403.2 | 242.0 |
| 2009-09-06 18:00:00 | ZN | Futures | 93.982006 | 93.982006 | 93.982006 | 93.982006 | 1.0 |
| 2009-09-06 23:00:00 | ZN | Futures | 93.944805 | 93.982006 | 93.944805 | 93.982006 | 20.0 |
> showing 32 of 160 rows — these rows as CSV