PREVIEW / futures_1hour / 2010-03-28
file: by_date/futures_1hour/2010/2010-03-28.parquet size: 13 KB rows: 235
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-03-28 18:00:00 | ES | Futures | 1138.78 | 1140.98 | 1138.54 | 1139.52 | 6885.0 |
| 2010-03-28 19:00:00 | ES | Futures | 1139.27 | 1140.25 | 1138.78 | 1139.27 | 2015.0 |
| 2010-03-28 20:00:00 | ES | Futures | 1139.27 | 1140.0 | 1138.05 | 1139.52 | 3607.0 |
| 2010-03-28 21:00:00 | ES | Futures | 1139.27 | 1140.0 | 1138.78 | 1138.78 | 2409.0 |
| 2010-03-28 22:00:00 | ES | Futures | 1138.78 | 1140.49 | 1138.54 | 1140.25 | 4366.0 |
| 2010-03-28 23:00:00 | ES | Futures | 1140.25 | 1141.47 | 1140.0 | 1140.98 | 3510.0 |
| 2010-03-28 18:00:00 | NQ | Futures | 2236.0 | 2241.15 | 2236.0 | 2238.57 | 617.0 |
| 2010-03-28 19:00:00 | NQ | Futures | 2238.29 | 2239.15 | 2237.14 | 2237.43 | 159.0 |
| 2010-03-28 20:00:00 | NQ | Futures | 2237.43 | 2238.86 | 2235.71 | 2238.29 | 478.0 |
| 2010-03-28 21:00:00 | NQ | Futures | 2238.57 | 2239.15 | 2237.43 | 2237.43 | 142.0 |
| 2010-03-28 22:00:00 | NQ | Futures | 2237.72 | 2239.72 | 2237.14 | 2239.72 | 166.0 |
| 2010-03-28 23:00:00 | NQ | Futures | 2239.43 | 2241.44 | 2239.43 | 2241.15 | 210.0 |
| 2010-03-28 18:00:00 | YM | Futures | 10167.3 | 10186.1 | 10165.4 | 10173.9 | 240.0 |
| 2010-03-28 19:00:00 | YM | Futures | 10173.9 | 10179.5 | 10169.2 | 10172.0 | 255.0 |
| 2010-03-28 20:00:00 | YM | Futures | 10173.9 | 10175.8 | 10162.6 | 10173.9 | 194.0 |
| 2010-03-28 21:00:00 | YM | Futures | 10173.9 | 10175.8 | 10169.2 | 10169.2 | 138.0 |
| 2010-03-28 22:00:00 | YM | Futures | 10169.2 | 10180.5 | 10166.3 | 10178.6 | 321.0 |
| 2010-03-28 23:00:00 | YM | Futures | 10178.6 | 10190.8 | 10177.6 | 10187.0 | 194.0 |
| 2010-03-28 18:00:00 | CL | Futures | 169.83 | 170.15 | 169.71 | 169.94 | 630.0 |
| 2010-03-28 19:00:00 | CL | Futures | 169.92 | 170.13 | 169.81 | 170.05 | 259.0 |
| 2010-03-28 20:00:00 | CL | Futures | 170.07 | 170.32 | 169.88 | 170.17 | 813.0 |
| 2010-03-28 21:00:00 | CL | Futures | 170.17 | 170.3 | 169.96 | 170.09 | 504.0 |
| 2010-03-28 22:00:00 | CL | Futures | 170.09 | 170.32 | 170.02 | 170.3 | 343.0 |
| 2010-03-28 23:00:00 | CL | Futures | 170.24 | 170.36 | 170.19 | 170.32 | 235.0 |
| 2010-03-28 18:00:00 | GC | Futures | 1562.1 | 1567.8 | 1561.3 | 1562.4 | 787.0 |
| 2010-03-28 19:00:00 | GC | Futures | 1562.4 | 1563.0 | 1558.1 | 1558.3 | 702.0 |
| 2010-03-28 20:00:00 | GC | Futures | 1558.5 | 1558.5 | 1556.4 | 1556.5 | 663.0 |
| 2010-03-28 21:00:00 | GC | Futures | 1556.5 | 1556.7 | 1552.6 | 1553.6 | 868.0 |
| 2010-03-28 22:00:00 | GC | Futures | 1553.4 | 1556.1 | 1553.3 | 1556.1 | 352.0 |
| 2010-03-28 23:00:00 | GC | Futures | 1556.2 | 1557.2 | 1555.5 | 1556.4 | 543.0 |
| 2010-03-28 18:00:00 | ZN | Futures | 95.31689 | 95.329738 | 95.175566 | 95.201261 | 5061.0 |
| 2010-03-28 19:00:00 | ZN | Futures | 95.201261 | 95.252652 | 95.188413 | 95.239804 | 3520.0 |
| 2010-03-28 20:00:00 | ZN | Futures | 95.239804 | 95.278347 | 95.239804 | 95.252652 | 3046.0 |
| 2010-03-28 21:00:00 | ZN | Futures | 95.252652 | 95.2655 | 95.124175 | 95.175566 | 7992.0 |
| 2010-03-28 22:00:00 | ZN | Futures | 95.188413 | 95.188413 | 95.14987 | 95.162718 | 2056.0 |
| 2010-03-28 23:00:00 | ZN | Futures | 95.14987 | 95.175566 | 95.137023 | 95.14987 | 1931.0 |
> showing 36 of 235 rows — these rows as CSV