PREVIEW / futures_1hour / 2010-10-24
file: by_date/futures_1hour/2010/2010-10-24.parquet size: 14 KB rows: 276
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-24 18:00:00 | ES | Futures | 1164.12 | 1166.58 | 1163.87 | 1164.12 | 7807.0 |
| 2010-10-24 19:00:00 | ES | Futures | 1164.12 | 1166.34 | 1163.87 | 1166.09 | 2325.0 |
| 2010-10-24 20:00:00 | ES | Futures | 1166.34 | 1168.56 | 1165.85 | 1168.31 | 10717.0 |
| 2010-10-24 21:00:00 | ES | Futures | 1168.56 | 1168.56 | 1166.58 | 1167.08 | 4854.0 |
| 2010-10-24 22:00:00 | ES | Futures | 1167.08 | 1169.3 | 1166.58 | 1169.05 | 6373.0 |
| 2010-10-24 23:00:00 | ES | Futures | 1169.05 | 1172.5 | 1168.8 | 1172.5 | 16276.0 |
| 2010-10-24 18:00:00 | NQ | Futures | 2414.57 | 2419.16 | 2412.56 | 2412.85 | 1601.0 |
| 2010-10-24 19:00:00 | NQ | Futures | 2412.56 | 2416.87 | 2412.28 | 2416.58 | 243.0 |
| 2010-10-24 20:00:00 | NQ | Futures | 2416.29 | 2421.17 | 2416.01 | 2420.88 | 649.0 |
| 2010-10-24 21:00:00 | NQ | Futures | 2420.6 | 2421.46 | 2417.44 | 2418.3 | 346.0 |
| 2010-10-24 22:00:00 | NQ | Futures | 2418.59 | 2423.18 | 2418.3 | 2422.6 | 613.0 |
| 2010-10-24 23:00:00 | NQ | Futures | 2422.6 | 2428.92 | 2422.03 | 2428.34 | 891.0 |
| 2010-10-24 18:00:00 | YM | Futures | 10566.8 | 10581.1 | 10562.0 | 10563.0 | 198.0 |
| 2010-10-24 19:00:00 | YM | Futures | 10565.8 | 10579.2 | 10560.1 | 10577.3 | 139.0 |
| 2010-10-24 20:00:00 | YM | Futures | 10579.2 | 10598.2 | 10576.3 | 10597.3 | 320.0 |
| 2010-10-24 21:00:00 | YM | Futures | 10596.3 | 10599.2 | 10584.9 | 10586.8 | 124.0 |
| 2010-10-24 22:00:00 | YM | Futures | 10587.8 | 10604.9 | 10586.8 | 10603.0 | 340.0 |
| 2010-10-24 23:00:00 | YM | Futures | 10603.0 | 10628.7 | 10602.0 | 10627.8 | 556.0 |
| 2010-10-24 18:00:00 | CL | Futures | 153.93 | 154.22 | 153.45 | 153.54 | 1392.0 |
| 2010-10-24 19:00:00 | CL | Futures | 153.52 | 154.05 | 153.41 | 154.03 | 572.0 |
| 2010-10-24 20:00:00 | CL | Futures | 153.99 | 154.48 | 153.99 | 154.44 | 1696.0 |
| 2010-10-24 21:00:00 | CL | Futures | 154.42 | 154.57 | 154.35 | 154.38 | 1097.0 |
| 2010-10-24 22:00:00 | CL | Futures | 154.38 | 154.8 | 154.33 | 154.76 | 1134.0 |
| 2010-10-24 23:00:00 | CL | Futures | 154.76 | 154.85 | 154.5 | 154.8 | 1580.0 |
| 2010-10-24 18:00:00 | GC | Futures | 1859.7 | 1869.5 | 1859.7 | 1863.8 | 3709.0 |
| 2010-10-24 19:00:00 | GC | Futures | 1863.8 | 1866.7 | 1863.2 | 1866.6 | 647.0 |
| 2010-10-24 20:00:00 | GC | Futures | 1866.3 | 1872.2 | 1865.1 | 1872.1 | 2992.0 |
| 2010-10-24 21:00:00 | GC | Futures | 1872.1 | 1873.0 | 1870.7 | 1872.6 | 1309.0 |
| 2010-10-24 22:00:00 | GC | Futures | 1873.0 | 1874.2 | 1872.2 | 1873.0 | 1086.0 |
| 2010-10-24 23:00:00 | GC | Futures | 1873.2 | 1874.3 | 1872.9 | 1873.5 | 1113.0 |
| 2010-10-24 18:00:00 | ZN | Futures | 105.406953 | 105.446031 | 105.406953 | 105.419979 | 1402.0 |
| 2010-10-24 19:00:00 | ZN | Futures | 105.433005 | 105.459057 | 105.393927 | 105.393927 | 2951.0 |
| 2010-10-24 20:00:00 | ZN | Futures | 105.406953 | 105.472083 | 105.393927 | 105.459057 | 4209.0 |
| 2010-10-24 21:00:00 | ZN | Futures | 105.459057 | 105.459057 | 105.433005 | 105.459057 | 2382.0 |
| 2010-10-24 22:00:00 | ZN | Futures | 105.459057 | 105.472083 | 105.446031 | 105.459057 | 1827.0 |
| 2010-10-24 23:00:00 | ZN | Futures | 105.459057 | 105.498135 | 105.459057 | 105.485109 | 3984.0 |
> showing 36 of 276 rows — these rows as CSV