PREVIEW / futures_1hour / 2009-10-04
file: by_date/futures_1hour/2009/2009-10-04.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 |
|---|---|---|---|---|---|---|---|
| 2009-10-04 18:00:00 | ES | Futures | 989.96 | 990.2 | 987.78 | 989.72 | 5521.0 |
| 2009-10-04 19:00:00 | ES | Futures | 989.72 | 993.84 | 989.23 | 990.93 | 7369.0 |
| 2009-10-04 20:00:00 | ES | Futures | 990.93 | 992.87 | 990.93 | 992.38 | 6059.0 |
| 2009-10-04 21:00:00 | ES | Futures | 992.38 | 993.59 | 992.14 | 992.38 | 3630.0 |
| 2009-10-04 22:00:00 | ES | Futures | 992.14 | 993.35 | 992.14 | 992.87 | 2861.0 |
| 2009-10-04 23:00:00 | ES | Futures | 993.11 | 993.35 | 991.66 | 992.62 | 2457.0 |
| 2009-10-04 18:00:00 | NQ | Futures | 1896.54 | 1896.83 | 1893.4 | 1895.97 | 427.0 |
| 2009-10-04 19:00:00 | NQ | Futures | 1896.83 | 1903.96 | 1896.54 | 1899.39 | 536.0 |
| 2009-10-04 20:00:00 | NQ | Futures | 1899.68 | 1903.39 | 1899.11 | 1902.53 | 681.0 |
| 2009-10-04 21:00:00 | NQ | Futures | 1902.53 | 1905.1 | 1901.39 | 1901.96 | 476.0 |
| 2009-10-04 22:00:00 | NQ | Futures | 1901.39 | 1903.96 | 1901.39 | 1903.1 | 95.0 |
| 2009-10-04 23:00:00 | NQ | Futures | 1903.39 | 1903.39 | 1900.25 | 1902.82 | 217.0 |
| 2009-10-04 18:00:00 | YM | Futures | 8773.5 | 8775.4 | 8758.6 | 8773.5 | 221.0 |
| 2009-10-04 19:00:00 | YM | Futures | 8774.4 | 8805.1 | 8774.4 | 8784.7 | 429.0 |
| 2009-10-04 20:00:00 | YM | Futures | 8785.6 | 8800.5 | 8783.7 | 8795.8 | 434.0 |
| 2009-10-04 21:00:00 | YM | Futures | 8797.7 | 8807.9 | 8794.0 | 8796.8 | 261.0 |
| 2009-10-04 22:00:00 | YM | Futures | 8794.9 | 8805.1 | 8794.9 | 8801.4 | 206.0 |
| 2009-10-04 23:00:00 | YM | Futures | 8801.4 | 8802.3 | 8791.2 | 8799.5 | 173.0 |
| 2009-10-04 18:00:00 | CL | Futures | 157.01 | 157.05 | 155.82 | 156.09 | 544.0 |
| 2009-10-04 19:00:00 | CL | Futures | 156.09 | 156.47 | 156.09 | 156.36 | 351.0 |
| 2009-10-04 20:00:00 | CL | Futures | 156.36 | 157.19 | 156.22 | 156.98 | 852.0 |
| 2009-10-04 21:00:00 | CL | Futures | 156.98 | 157.32 | 156.96 | 157.16 | 572.0 |
| 2009-10-04 22:00:00 | CL | Futures | 157.21 | 157.32 | 157.14 | 157.3 | 201.0 |
| 2009-10-04 23:00:00 | CL | Futures | 157.32 | 157.32 | 156.87 | 157.12 | 307.0 |
| 2009-10-04 18:00:00 | GC | Futures | 1417.2 | 1417.2 | 1413.8 | 1415.9 | 467.0 |
| 2009-10-04 19:00:00 | GC | Futures | 1416.1 | 1419.3 | 1414.4 | 1416.5 | 1020.0 |
| 2009-10-04 20:00:00 | GC | Futures | 1416.1 | 1417.9 | 1414.5 | 1416.8 | 925.0 |
| 2009-10-04 21:00:00 | GC | Futures | 1416.8 | 1419.2 | 1416.8 | 1418.2 | 869.0 |
| 2009-10-04 22:00:00 | GC | Futures | 1418.1 | 1419.2 | 1417.6 | 1419.2 | 405.0 |
| 2009-10-04 23:00:00 | GC | Futures | 1418.9 | 1419.0 | 1416.8 | 1418.5 | 622.0 |
| 2009-10-04 18:00:00 | ZN | Futures | 95.737626 | 95.825458 | 95.737626 | 95.775268 | 1144.0 |
| 2009-10-04 19:00:00 | ZN | Futures | 95.775268 | 95.800363 | 95.762721 | 95.787816 | 1131.0 |
| 2009-10-04 20:00:00 | ZN | Futures | 95.787816 | 95.787816 | 95.699983 | 95.712531 | 2533.0 |
| 2009-10-04 21:00:00 | ZN | Futures | 95.712531 | 95.712531 | 95.674888 | 95.687435 | 3060.0 |
| 2009-10-04 22:00:00 | ZN | Futures | 95.687435 | 95.712531 | 95.66234 | 95.674888 | 1257.0 |
| 2009-10-04 23:00:00 | ZN | Futures | 95.674888 | 95.737626 | 95.674888 | 95.712531 | 1461.0 |
> showing 36 of 227 rows — these rows as CSV