PREVIEW / futures_1hour / 2010-11-28
file: by_date/futures_1hour/2010/2010-11-28.parquet size: 14 KB rows: 258
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-11-28 18:00:00 | ES | Futures | 1171.76 | 1175.7 | 1170.28 | 1170.77 | 33953.0 |
| 2010-11-28 19:00:00 | ES | Futures | 1170.77 | 1174.23 | 1167.57 | 1168.06 | 25461.0 |
| 2010-11-28 20:00:00 | ES | Futures | 1167.82 | 1170.28 | 1167.32 | 1169.79 | 10051.0 |
| 2010-11-28 21:00:00 | ES | Futures | 1170.04 | 1172.75 | 1169.79 | 1172.25 | 7171.0 |
| 2010-11-28 22:00:00 | ES | Futures | 1172.01 | 1173.73 | 1172.01 | 1172.75 | 4402.0 |
| 2010-11-28 23:00:00 | ES | Futures | 1172.5 | 1173.24 | 1171.27 | 1172.75 | 4531.0 |
| 2010-11-28 18:00:00 | NQ | Futures | 2467.36 | 2477.4 | 2459.33 | 2468.51 | 2185.0 |
| 2010-11-28 19:00:00 | NQ | Futures | 2468.8 | 2476.26 | 2462.48 | 2464.21 | 1350.0 |
| 2010-11-28 20:00:00 | NQ | Futures | 2464.49 | 2467.94 | 2463.92 | 2467.94 | 653.0 |
| 2010-11-28 21:00:00 | NQ | Futures | 2467.94 | 2472.53 | 2467.65 | 2472.24 | 386.0 |
| 2010-11-28 22:00:00 | NQ | Futures | 2472.24 | 2474.53 | 2471.38 | 2472.81 | 370.0 |
| 2010-11-28 23:00:00 | NQ | Futures | 2473.1 | 2474.25 | 2468.8 | 2471.09 | 580.0 |
| 2010-11-28 18:00:00 | YM | Futures | 10530.6 | 10577.3 | 10530.6 | 10537.3 | 1100.0 |
| 2010-11-28 19:00:00 | YM | Futures | 10539.2 | 10565.8 | 10511.6 | 10515.4 | 917.0 |
| 2010-11-28 20:00:00 | YM | Futures | 10515.4 | 10536.3 | 10514.4 | 10536.3 | 646.0 |
| 2010-11-28 21:00:00 | YM | Futures | 10536.3 | 10558.2 | 10536.3 | 10553.5 | 316.0 |
| 2010-11-28 22:00:00 | YM | Futures | 10553.5 | 10562.0 | 10547.7 | 10557.3 | 371.0 |
| 2010-11-28 23:00:00 | YM | Futures | 10558.2 | 10571.6 | 10549.7 | 10555.4 | 530.0 |
| 2010-11-28 18:00:00 | CL | Futures | 156.58 | 157.04 | 156.24 | 156.71 | 1581.0 |
| 2010-11-28 19:00:00 | CL | Futures | 156.74 | 157.14 | 156.31 | 156.35 | 1543.0 |
| 2010-11-28 20:00:00 | CL | Futures | 156.37 | 156.67 | 156.11 | 156.61 | 1261.0 |
| 2010-11-28 21:00:00 | CL | Futures | 156.63 | 157.62 | 156.63 | 157.43 | 2543.0 |
| 2010-11-28 22:00:00 | CL | Futures | 157.45 | 157.51 | 157.25 | 157.3 | 661.0 |
| 2010-11-28 23:00:00 | CL | Futures | 157.32 | 157.45 | 157.04 | 157.17 | 748.0 |
| 2010-11-28 18:00:00 | GC | Futures | 1906.6 | 1907.6 | 1897.1 | 1898.1 | 1556.0 |
| 2010-11-28 19:00:00 | GC | Futures | 1897.5 | 1900.1 | 1892.0 | 1893.8 | 2667.0 |
| 2010-11-28 20:00:00 | GC | Futures | 1893.6 | 1896.3 | 1892.7 | 1896.3 | 1334.0 |
| 2010-11-28 21:00:00 | GC | Futures | 1896.1 | 1907.6 | 1896.1 | 1907.2 | 3321.0 |
| 2010-11-28 22:00:00 | GC | Futures | 1907.2 | 1908.0 | 1905.2 | 1907.0 | 1185.0 |
| 2010-11-28 23:00:00 | GC | Futures | 1907.0 | 1907.5 | 1901.0 | 1902.9 | 1374.0 |
| 2010-11-28 18:00:00 | ZN | Futures | 103.79172 | 103.804746 | 103.622381 | 103.72659 | 6117.0 |
| 2010-11-28 19:00:00 | ZN | Futures | 103.72659 | 103.804746 | 103.661459 | 103.804746 | 4976.0 |
| 2010-11-28 20:00:00 | ZN | Futures | 103.804746 | 103.817772 | 103.765668 | 103.79172 | 3310.0 |
| 2010-11-28 21:00:00 | ZN | Futures | 103.778694 | 103.79172 | 103.687512 | 103.713564 | 3641.0 |
| 2010-11-28 22:00:00 | ZN | Futures | 103.713564 | 103.739616 | 103.674486 | 103.700538 | 2814.0 |
| 2010-11-28 23:00:00 | ZN | Futures | 103.700538 | 103.739616 | 103.700538 | 103.739616 | 2923.0 |
> showing 36 of 258 rows — these rows as CSV