PREVIEW / futures_1hour / 2009-09-20
file: by_date/futures_1hour/2009/2009-09-20.parquet size: 12 KB rows: 205
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-20 18:00:00 | ES | Futures | 1026.29 | 1026.78 | 1024.6 | 1026.05 | 6094.0 |
| 2009-09-20 19:00:00 | ES | Futures | 1026.05 | 1027.5 | 1025.81 | 1027.02 | 2167.0 |
| 2009-09-20 20:00:00 | ES | Futures | 1026.78 | 1027.75 | 1026.78 | 1026.78 | 2054.0 |
| 2009-09-20 21:00:00 | ES | Futures | 1026.78 | 1026.78 | 1025.32 | 1025.81 | 2580.0 |
| 2009-09-20 22:00:00 | ES | Futures | 1026.05 | 1027.5 | 1025.32 | 1026.05 | 3156.0 |
| 2009-09-20 23:00:00 | ES | Futures | 1026.05 | 1026.29 | 1024.84 | 1025.08 | 2183.0 |
| 2009-09-20 18:00:00 | NQ | Futures | 1959.0 | 1961.28 | 1956.72 | 1959.85 | 857.0 |
| 2009-09-20 19:00:00 | NQ | Futures | 1959.85 | 1962.42 | 1959.85 | 1960.71 | 329.0 |
| 2009-09-20 20:00:00 | NQ | Futures | 1960.71 | 1962.14 | 1960.42 | 1960.71 | 373.0 |
| 2009-09-20 21:00:00 | NQ | Futures | 1960.71 | 1960.71 | 1958.14 | 1958.71 | 222.0 |
| 2009-09-20 22:00:00 | NQ | Futures | 1959.0 | 1961.28 | 1957.86 | 1959.0 | 245.0 |
| 2009-09-20 23:00:00 | NQ | Futures | 1959.28 | 1959.57 | 1956.15 | 1956.43 | 488.0 |
| 2009-09-20 18:00:00 | YM | Futures | 9037.7 | 9047.0 | 9026.5 | 9037.7 | 279.0 |
| 2009-09-20 19:00:00 | YM | Futures | 9036.7 | 9052.6 | 9036.7 | 9048.8 | 123.0 |
| 2009-09-20 20:00:00 | YM | Futures | 9047.0 | 9052.6 | 9044.2 | 9045.1 | 187.0 |
| 2009-09-20 21:00:00 | YM | Futures | 9045.1 | 9045.1 | 9034.9 | 9037.7 | 141.0 |
| 2009-09-20 22:00:00 | YM | Futures | 9042.3 | 9050.7 | 9034.9 | 9041.4 | 248.0 |
| 2009-09-20 23:00:00 | YM | Futures | 9041.4 | 9044.2 | 9032.1 | 9034.0 | 216.0 |
| 2009-09-20 18:00:00 | CL | Futures | 162.41 | 162.61 | 161.93 | 162.5 | 423.0 |
| 2009-09-20 19:00:00 | CL | Futures | 162.5 | 162.92 | 162.32 | 162.76 | 222.0 |
| 2009-09-20 20:00:00 | CL | Futures | 162.81 | 163.39 | 162.76 | 162.94 | 418.0 |
| 2009-09-20 21:00:00 | CL | Futures | 162.92 | 163.01 | 162.38 | 162.63 | 242.0 |
| 2009-09-20 22:00:00 | CL | Futures | 162.65 | 162.79 | 162.05 | 162.14 | 334.0 |
| 2009-09-20 23:00:00 | CL | Futures | 162.14 | 162.61 | 162.05 | 162.16 | 323.0 |
| 2009-09-20 18:00:00 | GC | Futures | 1421.2 | 1421.4 | 1418.2 | 1418.5 | 1499.0 |
| 2009-09-20 19:00:00 | GC | Futures | 1418.5 | 1420.3 | 1418.3 | 1419.3 | 543.0 |
| 2009-09-20 20:00:00 | GC | Futures | 1419.7 | 1423.3 | 1418.6 | 1419.0 | 935.0 |
| 2009-09-20 21:00:00 | GC | Futures | 1419.2 | 1421.4 | 1418.3 | 1419.9 | 1611.0 |
| 2009-09-20 22:00:00 | GC | Futures | 1419.9 | 1420.7 | 1418.3 | 1418.8 | 803.0 |
| 2009-09-20 23:00:00 | GC | Futures | 1418.8 | 1419.0 | 1412.3 | 1414.9 | 4131.0 |
| 2009-09-20 18:00:00 | ZN | Futures | 93.855497 | 93.905687 | 93.842949 | 93.855497 | 941.0 |
| 2009-09-20 19:00:00 | ZN | Futures | 93.855497 | 93.880592 | 93.842949 | 93.842949 | 616.0 |
| 2009-09-20 20:00:00 | ZN | Futures | 93.855497 | 93.855497 | 93.817854 | 93.830402 | 985.0 |
| 2009-09-20 21:00:00 | ZN | Futures | 93.830402 | 93.930782 | 93.805307 | 93.905687 | 1279.0 |
| 2009-09-20 22:00:00 | ZN | Futures | 93.893139 | 93.955877 | 93.880592 | 93.943329 | 1522.0 |
| 2009-09-20 23:00:00 | ZN | Futures | 93.943329 | 93.980972 | 93.918234 | 93.918234 | 655.0 |
> showing 36 of 205 rows — these rows as CSV