PREVIEW / futures_1hour / 2018-04-29
file: by_date/futures_1hour/2018/2018-04-29.parquet size: 14 KB rows: 297
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 |
|---|---|---|---|---|---|---|---|
| 2018-04-29 18:00:00 | ES | Futures | 2915.2 | 2924.76 | 2914.93 | 2920.39 | 6120.0 |
| 2018-04-29 19:00:00 | ES | Futures | 2920.39 | 2920.66 | 2914.66 | 2917.93 | 6017.0 |
| 2018-04-29 20:00:00 | ES | Futures | 2918.21 | 2919.84 | 2917.39 | 2919.02 | 3744.0 |
| 2018-04-29 21:00:00 | ES | Futures | 2918.75 | 2923.12 | 2917.66 | 2922.85 | 5274.0 |
| 2018-04-29 22:00:00 | ES | Futures | 2922.57 | 2923.94 | 2921.75 | 2922.3 | 3620.0 |
| 2018-04-29 23:00:00 | ES | Futures | 2922.3 | 2923.12 | 2921.75 | 2922.57 | 1820.0 |
| 2018-04-29 18:00:00 | NQ | Futures | 7882.43 | 7911.99 | 7880.36 | 7900.46 | 2012.0 |
| 2018-04-29 19:00:00 | NQ | Futures | 7900.17 | 7902.53 | 7883.32 | 7892.19 | 1323.0 |
| 2018-04-29 20:00:00 | NQ | Futures | 7892.48 | 7902.82 | 7891.3 | 7899.57 | 1462.0 |
| 2018-04-29 21:00:00 | NQ | Futures | 7899.28 | 7919.67 | 7896.03 | 7918.78 | 2637.0 |
| 2018-04-29 22:00:00 | NQ | Futures | 7918.78 | 7923.81 | 7914.35 | 7916.42 | 2197.0 |
| 2018-04-29 23:00:00 | NQ | Futures | 7916.71 | 7917.6 | 7912.87 | 7916.42 | 921.0 |
| 2018-04-29 18:00:00 | YM | Futures | 26367.6 | 26463.1 | 26361.0 | 26416.4 | 1791.0 |
| 2018-04-29 19:00:00 | YM | Futures | 26413.2 | 26416.4 | 26374.1 | 26396.9 | 934.0 |
| 2018-04-29 20:00:00 | YM | Futures | 26395.8 | 26407.7 | 26384.9 | 26400.1 | 961.0 |
| 2018-04-29 21:00:00 | YM | Futures | 26399.1 | 26438.1 | 26387.1 | 26437.1 | 1507.0 |
| 2018-04-29 22:00:00 | YM | Futures | 26437.1 | 26442.5 | 26427.3 | 26431.6 | 1158.0 |
| 2018-04-29 23:00:00 | YM | Futures | 26431.6 | 26438.1 | 26419.7 | 26430.5 | 1419.0 |
| 2018-04-29 18:00:00 | CL | Futures | 60.91 | 60.96 | 60.79 | 60.8 | 2791.0 |
| 2018-04-29 19:00:00 | CL | Futures | 60.8 | 60.86 | 60.73 | 60.78 | 1936.0 |
| 2018-04-29 20:00:00 | CL | Futures | 60.78 | 60.82 | 60.75 | 60.8 | 2826.0 |
| 2018-04-29 21:00:00 | CL | Futures | 60.8 | 60.85 | 60.67 | 60.74 | 7719.0 |
| 2018-04-29 22:00:00 | CL | Futures | 60.74 | 60.74 | 60.66 | 60.67 | 1998.0 |
| 2018-04-29 23:00:00 | CL | Futures | 60.67 | 60.71 | 60.62 | 60.64 | 3839.0 |
| 2018-04-29 18:00:00 | GC | Futures | 1744.4 | 1745.5 | 1743.7 | 1744.4 | 1328.0 |
| 2018-04-29 19:00:00 | GC | Futures | 1744.3 | 1745.4 | 1744.2 | 1745.0 | 1106.0 |
| 2018-04-29 20:00:00 | GC | Futures | 1744.8 | 1746.9 | 1744.6 | 1746.2 | 2873.0 |
| 2018-04-29 21:00:00 | GC | Futures | 1746.3 | 1746.5 | 1745.0 | 1746.5 | 2647.0 |
| 2018-04-29 22:00:00 | GC | Futures | 1746.5 | 1746.8 | 1742.6 | 1743.1 | 5367.0 |
| 2018-04-29 23:00:00 | GC | Futures | 1743.1 | 1743.4 | 1741.8 | 1741.8 | 4388.0 |
| 2018-04-29 18:00:00 | ZN | Futures | 119.852089 | 119.852089 | 119.805069 | 119.805069 | 2862.0 |
| 2018-04-29 19:00:00 | ZN | Futures | 119.820742 | 119.836415 | 119.805069 | 119.820742 | 3564.0 |
| 2018-04-29 20:00:00 | ZN | Futures | 119.836415 | 119.836415 | 119.805069 | 119.805069 | 3905.0 |
| 2018-04-29 21:00:00 | ZN | Futures | 119.805069 | 119.820742 | 119.789396 | 119.805069 | 2609.0 |
| 2018-04-29 22:00:00 | ZN | Futures | 119.805069 | 119.820742 | 119.789396 | 119.820742 | 3203.0 |
| 2018-04-29 23:00:00 | ZN | Futures | 119.820742 | 119.836415 | 119.805069 | 119.820742 | 3752.0 |
> showing 36 of 297 rows — these rows as CSV