PREVIEW / futures_1hour / 2010-10-31
file: by_date/futures_1hour/2010/2010-10-31.parquet size: 14 KB rows: 267
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-31 18:00:00 | ES | Futures | 1163.87 | 1170.28 | 1163.63 | 1168.56 | 13080.0 |
| 2010-10-31 19:00:00 | ES | Futures | 1168.8 | 1170.77 | 1168.56 | 1169.54 | 12433.0 |
| 2010-10-31 20:00:00 | ES | Futures | 1169.54 | 1170.77 | 1168.31 | 1170.04 | 12539.0 |
| 2010-10-31 21:00:00 | ES | Futures | 1169.79 | 1172.25 | 1169.79 | 1171.76 | 14692.0 |
| 2010-10-31 22:00:00 | ES | Futures | 1172.01 | 1172.01 | 1171.27 | 1171.51 | 5575.0 |
| 2010-10-31 23:00:00 | ES | Futures | 1171.51 | 1172.25 | 1171.51 | 1171.76 | 2969.0 |
| 2010-10-31 18:00:00 | NQ | Futures | 2438.67 | 2447.57 | 2438.67 | 2445.56 | 1253.0 |
| 2010-10-31 19:00:00 | NQ | Futures | 2445.84 | 2449.86 | 2445.84 | 2447.85 | 477.0 |
| 2010-10-31 20:00:00 | NQ | Futures | 2448.43 | 2450.43 | 2445.56 | 2448.14 | 906.0 |
| 2010-10-31 21:00:00 | NQ | Futures | 2448.43 | 2451.01 | 2447.85 | 2450.15 | 1169.0 |
| 2010-10-31 22:00:00 | NQ | Futures | 2450.15 | 2450.72 | 2449.57 | 2450.15 | 402.0 |
| 2010-10-31 23:00:00 | NQ | Futures | 2449.86 | 2451.01 | 2449.57 | 2450.43 | 257.0 |
| 2010-10-31 18:00:00 | YM | Futures | 10543.0 | 10603.0 | 10543.0 | 10591.6 | 566.0 |
| 2010-10-31 19:00:00 | YM | Futures | 10589.7 | 10603.9 | 10589.7 | 10596.3 | 330.0 |
| 2010-10-31 20:00:00 | YM | Futures | 10597.3 | 10604.9 | 10587.8 | 10598.2 | 548.0 |
| 2010-10-31 21:00:00 | YM | Futures | 10598.2 | 10614.4 | 10598.2 | 10611.6 | 689.0 |
| 2010-10-31 22:00:00 | YM | Futures | 10611.6 | 10614.4 | 10606.8 | 10609.7 | 224.0 |
| 2010-10-31 23:00:00 | YM | Futures | 10609.7 | 10613.5 | 10606.8 | 10611.6 | 176.0 |
| 2010-10-31 18:00:00 | CL | Futures | 152.88 | 153.73 | 152.64 | 153.48 | 1538.0 |
| 2010-10-31 19:00:00 | CL | Futures | 153.46 | 153.65 | 153.37 | 153.58 | 359.0 |
| 2010-10-31 20:00:00 | CL | Futures | 153.58 | 153.6 | 153.13 | 153.54 | 1027.0 |
| 2010-10-31 21:00:00 | CL | Futures | 153.56 | 153.82 | 153.37 | 153.8 | 1333.0 |
| 2010-10-31 22:00:00 | CL | Futures | 153.8 | 153.84 | 153.39 | 153.69 | 826.0 |
| 2010-10-31 23:00:00 | CL | Futures | 153.63 | 153.71 | 153.54 | 153.58 | 402.0 |
| 2010-10-31 18:00:00 | GC | Futures | 1902.3 | 1911.6 | 1901.9 | 1908.4 | 2698.0 |
| 2010-10-31 19:00:00 | GC | Futures | 1908.7 | 1908.8 | 1904.4 | 1906.9 | 1646.0 |
| 2010-10-31 20:00:00 | GC | Futures | 1906.9 | 1907.2 | 1898.6 | 1900.7 | 3580.0 |
| 2010-10-31 21:00:00 | GC | Futures | 1900.9 | 1902.3 | 1898.1 | 1900.6 | 2082.0 |
| 2010-10-31 22:00:00 | GC | Futures | 1900.7 | 1900.9 | 1898.9 | 1900.2 | 1002.0 |
| 2010-10-31 23:00:00 | GC | Futures | 1900.0 | 1901.7 | 1899.8 | 1901.2 | 1025.0 |
| 2010-10-31 18:00:00 | ZN | Futures | 105.276692 | 105.289718 | 105.224588 | 105.237614 | 3407.0 |
| 2010-10-31 19:00:00 | ZN | Futures | 105.237614 | 105.25064 | 105.224588 | 105.237614 | 1172.0 |
| 2010-10-31 20:00:00 | ZN | Futures | 105.237614 | 105.276692 | 105.107353 | 105.263666 | 9098.0 |
| 2010-10-31 21:00:00 | ZN | Futures | 105.263666 | 105.263666 | 105.146431 | 105.198536 | 3975.0 |
| 2010-10-31 22:00:00 | ZN | Futures | 105.211562 | 105.224588 | 105.172484 | 105.172484 | 1146.0 |
| 2010-10-31 23:00:00 | ZN | Futures | 105.172484 | 105.18551 | 105.159457 | 105.172484 | 1039.0 |
> showing 36 of 267 rows — these rows as CSV