PREVIEW / futures_1hour / 2010-10-03
file: by_date/futures_1hour/2010/2010-10-03.parquet size: 14 KB rows: 262
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-03 18:00:00 | ES | Futures | 1127.15 | 1127.64 | 1123.2 | 1123.45 | 6255.0 |
| 2010-10-03 19:00:00 | ES | Futures | 1123.45 | 1124.44 | 1122.71 | 1123.7 | 4734.0 |
| 2010-10-03 20:00:00 | ES | Futures | 1123.7 | 1124.44 | 1122.96 | 1123.45 | 3296.0 |
| 2010-10-03 21:00:00 | ES | Futures | 1123.45 | 1126.41 | 1123.2 | 1126.16 | 6086.0 |
| 2010-10-03 22:00:00 | ES | Futures | 1125.92 | 1127.89 | 1125.92 | 1127.64 | 5195.0 |
| 2010-10-03 23:00:00 | ES | Futures | 1127.39 | 1127.64 | 1123.94 | 1124.44 | 4647.0 |
| 2010-10-03 18:00:00 | NQ | Futures | 2292.64 | 2292.64 | 2282.02 | 2282.02 | 519.0 |
| 2010-10-03 19:00:00 | NQ | Futures | 2282.31 | 2284.6 | 2281.45 | 2282.02 | 277.0 |
| 2010-10-03 20:00:00 | NQ | Futures | 2282.6 | 2284.6 | 2281.74 | 2283.74 | 262.0 |
| 2010-10-03 21:00:00 | NQ | Futures | 2283.46 | 2289.48 | 2282.88 | 2288.33 | 303.0 |
| 2010-10-03 22:00:00 | NQ | Futures | 2288.05 | 2291.78 | 2288.05 | 2290.92 | 298.0 |
| 2010-10-03 23:00:00 | NQ | Futures | 2291.2 | 2291.2 | 2284.6 | 2285.47 | 267.0 |
| 2010-10-03 18:00:00 | YM | Futures | 10260.1 | 10269.6 | 10231.5 | 10234.4 | 143.0 |
| 2010-10-03 19:00:00 | YM | Futures | 10234.4 | 10242.0 | 10227.7 | 10238.2 | 126.0 |
| 2010-10-03 20:00:00 | YM | Futures | 10238.2 | 10243.9 | 10232.4 | 10239.1 | 363.0 |
| 2010-10-03 21:00:00 | YM | Futures | 10236.3 | 10261.0 | 10234.4 | 10258.2 | 462.0 |
| 2010-10-03 22:00:00 | YM | Futures | 10260.1 | 10269.6 | 10257.2 | 10266.7 | 233.0 |
| 2010-10-03 23:00:00 | YM | Futures | 10267.7 | 10268.6 | 10242.0 | 10245.8 | 225.0 |
| 2010-10-03 18:00:00 | CL | Futures | 154.52 | 154.88 | 154.28 | 154.28 | 942.0 |
| 2010-10-03 19:00:00 | CL | Futures | 154.31 | 154.33 | 154.09 | 154.28 | 439.0 |
| 2010-10-03 20:00:00 | CL | Futures | 154.28 | 154.41 | 154.11 | 154.22 | 515.0 |
| 2010-10-03 21:00:00 | CL | Futures | 154.24 | 154.31 | 154.18 | 154.24 | 414.0 |
| 2010-10-03 22:00:00 | CL | Futures | 154.2 | 154.48 | 154.18 | 154.33 | 247.0 |
| 2010-10-03 23:00:00 | CL | Futures | 154.37 | 154.43 | 154.16 | 154.24 | 280.0 |
| 2010-10-03 18:00:00 | GC | Futures | 1846.3 | 1848.5 | 1844.9 | 1848.5 | 720.0 |
| 2010-10-03 19:00:00 | GC | Futures | 1848.4 | 1848.4 | 1844.1 | 1844.8 | 920.0 |
| 2010-10-03 20:00:00 | GC | Futures | 1845.1 | 1846.3 | 1842.8 | 1845.5 | 1822.0 |
| 2010-10-03 21:00:00 | GC | Futures | 1845.6 | 1845.6 | 1841.7 | 1842.8 | 1429.0 |
| 2010-10-03 22:00:00 | GC | Futures | 1843.0 | 1843.9 | 1842.5 | 1843.1 | 615.0 |
| 2010-10-03 23:00:00 | GC | Futures | 1843.1 | 1845.1 | 1843.0 | 1844.9 | 532.0 |
| 2010-10-03 18:00:00 | ZN | Futures | 105.198536 | 105.25064 | 105.198536 | 105.237614 | 2171.0 |
| 2010-10-03 19:00:00 | ZN | Futures | 105.237614 | 105.31577 | 105.237614 | 105.263666 | 3539.0 |
| 2010-10-03 20:00:00 | ZN | Futures | 105.263666 | 105.289718 | 105.263666 | 105.276692 | 4524.0 |
| 2010-10-03 21:00:00 | ZN | Futures | 105.276692 | 105.289718 | 105.18551 | 105.224588 | 6133.0 |
| 2010-10-03 22:00:00 | ZN | Futures | 105.224588 | 105.263666 | 105.224588 | 105.263666 | 1266.0 |
| 2010-10-03 23:00:00 | ZN | Futures | 105.25064 | 105.31577 | 105.25064 | 105.302744 | 2881.0 |
> showing 36 of 262 rows — these rows as CSV