PREVIEW / futures_1hour / 2011-06-05
file: by_date/futures_1hour/2011/2011-06-05.parquet size: 13 KB rows: 252
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-05 18:00:00 | ES | Futures | 1290.6 | 1290.85 | 1287.37 | 1289.6 | 12239.0 |
| 2011-06-05 19:00:00 | ES | Futures | 1289.35 | 1290.6 | 1286.62 | 1290.35 | 6481.0 |
| 2011-06-05 20:00:00 | ES | Futures | 1290.6 | 1290.85 | 1289.85 | 1289.85 | 6282.0 |
| 2011-06-05 21:00:00 | ES | Futures | 1290.1 | 1290.1 | 1286.62 | 1287.62 | 6616.0 |
| 2011-06-05 22:00:00 | ES | Futures | 1287.62 | 1289.11 | 1287.12 | 1288.86 | 2330.0 |
| 2011-06-05 23:00:00 | ES | Futures | 1288.86 | 1289.85 | 1288.11 | 1288.11 | 3086.0 |
| 2011-06-05 18:00:00 | NQ | Futures | 2630.08 | 2633.24 | 2629.22 | 2630.94 | 1021.0 |
| 2011-06-05 19:00:00 | NQ | Futures | 2631.23 | 2634.96 | 2626.92 | 2634.68 | 617.0 |
| 2011-06-05 20:00:00 | NQ | Futures | 2634.39 | 2634.96 | 2632.09 | 2632.38 | 517.0 |
| 2011-06-05 21:00:00 | NQ | Futures | 2632.67 | 2632.95 | 2624.91 | 2628.07 | 1193.0 |
| 2011-06-05 22:00:00 | NQ | Futures | 2628.36 | 2631.52 | 2627.78 | 2631.52 | 278.0 |
| 2011-06-05 23:00:00 | NQ | Futures | 2631.23 | 2632.95 | 2629.79 | 2629.79 | 349.0 |
| 2011-06-05 18:00:00 | YM | Futures | 11686.4 | 11695.0 | 11670.9 | 11685.4 | 570.0 |
| 2011-06-05 19:00:00 | YM | Futures | 11686.4 | 11693.1 | 11664.2 | 11693.1 | 223.0 |
| 2011-06-05 20:00:00 | YM | Futures | 11694.1 | 11695.0 | 11688.3 | 11691.2 | 651.0 |
| 2011-06-05 21:00:00 | YM | Futures | 11691.2 | 11694.1 | 11666.1 | 11674.8 | 555.0 |
| 2011-06-05 22:00:00 | YM | Futures | 11674.8 | 11686.4 | 11670.9 | 11685.4 | 165.0 |
| 2011-06-05 23:00:00 | YM | Futures | 11685.4 | 11690.2 | 11676.7 | 11676.7 | 376.0 |
| 2011-06-05 18:00:00 | CL | Futures | 172.94 | 173.39 | 172.82 | 173.03 | 1032.0 |
| 2011-06-05 19:00:00 | CL | Futures | 173.03 | 173.1 | 172.56 | 173.1 | 1068.0 |
| 2011-06-05 20:00:00 | CL | Futures | 173.1 | 173.1 | 172.73 | 172.91 | 736.0 |
| 2011-06-05 21:00:00 | CL | Futures | 172.91 | 173.03 | 172.32 | 172.49 | 1079.0 |
| 2011-06-05 22:00:00 | CL | Futures | 172.48 | 172.63 | 172.25 | 172.32 | 410.0 |
| 2011-06-05 23:00:00 | CL | Futures | 172.32 | 172.48 | 172.13 | 172.36 | 1266.0 |
| 2011-06-05 18:00:00 | GC | Futures | 2154.2 | 2154.5 | 2150.1 | 2152.5 | 765.0 |
| 2011-06-05 19:00:00 | GC | Futures | 2152.7 | 2156.3 | 2152.1 | 2156.0 | 555.0 |
| 2011-06-05 20:00:00 | GC | Futures | 2155.9 | 2157.5 | 2152.4 | 2157.1 | 1419.0 |
| 2011-06-05 21:00:00 | GC | Futures | 2157.4 | 2158.2 | 2156.0 | 2156.4 | 1795.0 |
| 2011-06-05 22:00:00 | GC | Futures | 2156.4 | 2157.4 | 2156.1 | 2156.3 | 351.0 |
| 2011-06-05 23:00:00 | GC | Futures | 2156.6 | 2157.4 | 2156.3 | 2156.7 | 946.0 |
| 2011-06-05 19:00:00 | ZN | Futures | 106.253063 | 106.253063 | 106.253063 | 106.253063 | 5.0 |
| 2011-06-05 20:00:00 | ZN | Futures | 106.226457 | 106.226457 | 106.186547 | 106.186547 | 13.0 |
| 2011-06-05 21:00:00 | ZN | Futures | 106.213153 | 106.213153 | 106.213153 | 106.213153 | 7.0 |
| 2011-06-05 22:00:00 | ZN | Futures | 106.226457 | 106.226457 | 106.226457 | 106.226457 | 6.0 |
| 2011-06-05 23:00:00 | ZN | Futures | 106.226457 | 106.226457 | 106.226457 | 106.226457 | 239.0 |
> showing 35 of 252 rows — these rows as CSV