PREVIEW / futures_1hour / 2010-08-15
file: by_date/futures_1hour/2010/2010-08-15.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 |
|---|---|---|---|---|---|---|---|
| 2010-08-15 18:00:00 | ES | Futures | 1057.59 | 1057.59 | 1055.87 | 1057.34 | 2683.0 |
| 2010-08-15 19:00:00 | ES | Futures | 1057.34 | 1057.59 | 1053.66 | 1054.64 | 4934.0 |
| 2010-08-15 20:00:00 | ES | Futures | 1054.64 | 1054.89 | 1050.22 | 1050.96 | 17875.0 |
| 2010-08-15 21:00:00 | ES | Futures | 1050.96 | 1053.66 | 1048.75 | 1053.17 | 14072.0 |
| 2010-08-15 22:00:00 | ES | Futures | 1053.41 | 1054.64 | 1052.43 | 1054.15 | 7681.0 |
| 2010-08-15 23:00:00 | ES | Futures | 1054.15 | 1054.64 | 1051.94 | 1052.19 | 4549.0 |
| 2010-08-15 18:00:00 | NQ | Futures | 2083.62 | 2085.05 | 2081.33 | 2083.34 | 241.0 |
| 2010-08-15 19:00:00 | NQ | Futures | 2083.62 | 2084.48 | 2078.75 | 2080.18 | 1099.0 |
| 2010-08-15 20:00:00 | NQ | Futures | 2079.9 | 2080.18 | 2071.01 | 2072.45 | 1042.0 |
| 2010-08-15 21:00:00 | NQ | Futures | 2072.45 | 2077.6 | 2069.01 | 2076.74 | 935.0 |
| 2010-08-15 22:00:00 | NQ | Futures | 2077.03 | 2079.61 | 2075.02 | 2079.04 | 590.0 |
| 2010-08-15 23:00:00 | NQ | Futures | 2078.75 | 2079.9 | 2075.31 | 2075.88 | 386.0 |
| 2010-08-15 18:00:00 | YM | Futures | 9723.5 | 9730.2 | 9716.0 | 9725.4 | 268.0 |
| 2010-08-15 19:00:00 | YM | Futures | 9726.4 | 9731.1 | 9698.9 | 9708.4 | 322.0 |
| 2010-08-15 20:00:00 | YM | Futures | 9708.4 | 9708.4 | 9672.4 | 9676.2 | 720.0 |
| 2010-08-15 21:00:00 | YM | Futures | 9680.0 | 9698.9 | 9661.1 | 9696.1 | 673.0 |
| 2010-08-15 22:00:00 | YM | Futures | 9697.0 | 9708.4 | 9692.3 | 9704.6 | 571.0 |
| 2010-08-15 23:00:00 | YM | Futures | 9704.6 | 9705.6 | 9687.6 | 9688.5 | 331.0 |
| 2010-08-15 18:00:00 | CL | Futures | 145.04 | 145.57 | 145.04 | 145.52 | 292.0 |
| 2010-08-15 19:00:00 | CL | Futures | 145.52 | 145.52 | 144.89 | 144.92 | 144.0 |
| 2010-08-15 20:00:00 | CL | Futures | 144.92 | 144.92 | 144.43 | 144.56 | 282.0 |
| 2010-08-15 21:00:00 | CL | Futures | 144.62 | 144.79 | 144.43 | 144.66 | 175.0 |
| 2010-08-15 22:00:00 | CL | Futures | 144.68 | 145.27 | 144.62 | 145.25 | 463.0 |
| 2010-08-15 23:00:00 | CL | Futures | 145.27 | 145.42 | 145.19 | 145.19 | 271.0 |
| 2010-08-15 18:00:00 | GC | Futures | 1701.9 | 1702.5 | 1701.5 | 1702.3 | 380.0 |
| 2010-08-15 19:00:00 | GC | Futures | 1702.5 | 1703.2 | 1701.6 | 1702.9 | 318.0 |
| 2010-08-15 20:00:00 | GC | Futures | 1702.9 | 1707.1 | 1702.8 | 1705.4 | 1818.0 |
| 2010-08-15 21:00:00 | GC | Futures | 1705.1 | 1706.7 | 1705.1 | 1706.0 | 695.0 |
| 2010-08-15 22:00:00 | GC | Futures | 1706.4 | 1709.2 | 1706.1 | 1708.2 | 2175.0 |
| 2010-08-15 23:00:00 | GC | Futures | 1707.9 | 1708.8 | 1707.0 | 1707.5 | 571.0 |
| 2010-08-15 18:00:00 | ZN | Futures | 103.924645 | 103.924645 | 103.898783 | 103.911714 | 1144.0 |
| 2010-08-15 19:00:00 | ZN | Futures | 103.911714 | 104.028091 | 103.911714 | 104.01516 | 3981.0 |
| 2010-08-15 20:00:00 | ZN | Futures | 104.01516 | 104.105676 | 104.00223 | 104.079814 | 9979.0 |
| 2010-08-15 21:00:00 | ZN | Futures | 104.092745 | 104.118607 | 104.041022 | 104.053953 | 6582.0 |
| 2010-08-15 22:00:00 | ZN | Futures | 104.053953 | 104.053953 | 104.01516 | 104.01516 | 3311.0 |
| 2010-08-15 23:00:00 | ZN | Futures | 104.028091 | 104.053953 | 104.00223 | 104.041022 | 2422.0 |
> showing 36 of 232 rows — these rows as CSV