PREVIEW / futures_1hour / 2008-07-27
file: by_date/futures_1hour/2008/2008-07-27.parquet size: 13 KB rows: 232
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-27 18:00:00 | ES | Futures | 1166.96 | 1169.05 | 1166.03 | 1167.89 | 3918.0 |
| 2008-07-27 19:00:00 | ES | Futures | 1167.65 | 1167.89 | 1164.87 | 1165.33 | 1110.0 |
| 2008-07-27 20:00:00 | ES | Futures | 1165.1 | 1166.26 | 1164.63 | 1165.8 | 1511.0 |
| 2008-07-27 21:00:00 | ES | Futures | 1165.56 | 1166.03 | 1165.33 | 1165.33 | 775.0 |
| 2008-07-27 22:00:00 | ES | Futures | 1165.56 | 1165.56 | 1163.47 | 1163.94 | 1600.0 |
| 2008-07-27 23:00:00 | ES | Futures | 1163.94 | 1165.56 | 1163.94 | 1164.17 | 941.0 |
| 2008-07-27 18:00:00 | NQ | Futures | 2076.19 | 2080.13 | 2075.35 | 2076.47 | 564.0 |
| 2008-07-27 19:00:00 | NQ | Futures | 2076.47 | 2077.04 | 2071.69 | 2071.69 | 216.0 |
| 2008-07-27 20:00:00 | NQ | Futures | 2072.82 | 2073.94 | 2072.25 | 2073.66 | 155.0 |
| 2008-07-27 21:00:00 | NQ | Futures | 2073.1 | 2074.22 | 2072.82 | 2074.22 | 45.0 |
| 2008-07-27 22:00:00 | NQ | Futures | 2073.1 | 2073.1 | 2069.16 | 2070.29 | 243.0 |
| 2008-07-27 23:00:00 | NQ | Futures | 2070.29 | 2073.1 | 2070.29 | 2070.29 | 50.0 |
| 2008-07-27 18:00:00 | YM | Futures | 10299.4 | 10310.3 | 10298.5 | 10301.2 | 173.0 |
| 2008-07-27 19:00:00 | YM | Futures | 10300.3 | 10303.9 | 10281.2 | 10281.2 | 79.0 |
| 2008-07-27 20:00:00 | YM | Futures | 10282.1 | 10291.2 | 10280.3 | 10283.9 | 89.0 |
| 2008-07-27 21:00:00 | YM | Futures | 10286.6 | 10288.5 | 10283.9 | 10283.9 | 54.0 |
| 2008-07-27 22:00:00 | YM | Futures | 10283.0 | 10286.6 | 10270.3 | 10274.8 | 220.0 |
| 2008-07-27 23:00:00 | YM | Futures | 10273.0 | 10285.7 | 10272.1 | 10277.5 | 77.0 |
| 2008-07-27 18:00:00 | CL | Futures | 466.61 | 467.25 | 464.83 | 466.12 | 455.0 |
| 2008-07-27 19:00:00 | CL | Futures | 465.93 | 466.95 | 465.89 | 466.08 | 174.0 |
| 2008-07-27 20:00:00 | CL | Futures | 466.19 | 468.46 | 465.85 | 468.08 | 621.0 |
| 2008-07-27 21:00:00 | CL | Futures | 468.08 | 468.27 | 467.59 | 467.78 | 167.0 |
| 2008-07-27 22:00:00 | CL | Futures | 467.67 | 467.89 | 466.95 | 466.95 | 182.0 |
| 2008-07-27 23:00:00 | CL | Futures | 466.99 | 467.55 | 466.27 | 466.61 | 247.0 |
| 2008-07-27 18:00:00 | GC | Futures | 1339.4 | 1342.7 | 1338.7 | 1340.2 | 106.0 |
| 2008-07-27 19:00:00 | GC | Futures | 1340.0 | 1341.6 | 1338.7 | 1340.2 | 31.0 |
| 2008-07-27 20:00:00 | GC | Futures | 1340.2 | 1344.0 | 1339.4 | 1342.9 | 57.0 |
| 2008-07-27 21:00:00 | GC | Futures | 1342.3 | 1342.6 | 1340.6 | 1341.6 | 73.0 |
| 2008-07-27 22:00:00 | GC | Futures | 1341.6 | 1341.6 | 1340.3 | 1340.6 | 43.0 |
| 2008-07-27 23:00:00 | GC | Futures | 1340.2 | 1342.7 | 1339.7 | 1342.7 | 44.0 |
| 2008-07-27 18:00:00 | ZN | Futures | 84.937829 | 84.972932 | 84.926128 | 84.937829 | 3315.0 |
| 2008-07-27 19:00:00 | ZN | Futures | 84.926128 | 84.961231 | 84.914427 | 84.94953 | 1614.0 |
| 2008-07-27 20:00:00 | ZN | Futures | 84.94953 | 84.984633 | 84.937829 | 84.961231 | 2026.0 |
| 2008-07-27 21:00:00 | ZN | Futures | 84.972932 | 85.066541 | 84.972932 | 85.066541 | 1654.0 |
| 2008-07-27 22:00:00 | ZN | Futures | 85.066541 | 85.078242 | 85.031437 | 85.031437 | 1161.0 |
| 2008-07-27 23:00:00 | ZN | Futures | 85.043138 | 85.101644 | 85.031437 | 85.101644 | 1808.0 |
> showing 36 of 232 rows — these rows as CSV