PREVIEW / futures_1hour / 2010-07-25
file: by_date/futures_1hour/2010/2010-07-25.parquet size: 13 KB rows: 242
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-07-25 18:00:00 | ES | Futures | 1080.9 | 1082.37 | 1078.44 | 1079.92 | 7806.0 |
| 2010-07-25 19:00:00 | ES | Futures | 1079.92 | 1080.65 | 1078.2 | 1079.42 | 3801.0 |
| 2010-07-25 20:00:00 | ES | Futures | 1079.42 | 1081.14 | 1078.69 | 1080.41 | 6166.0 |
| 2010-07-25 21:00:00 | ES | Futures | 1080.65 | 1084.09 | 1080.41 | 1083.35 | 9896.0 |
| 2010-07-25 22:00:00 | ES | Futures | 1083.11 | 1083.84 | 1082.37 | 1082.37 | 3969.0 |
| 2010-07-25 23:00:00 | ES | Futures | 1082.61 | 1082.86 | 1081.63 | 1082.61 | 3858.0 |
| 2010-07-25 18:00:00 | NQ | Futures | 2148.39 | 2152.4 | 2146.09 | 2148.96 | 724.0 |
| 2010-07-25 19:00:00 | NQ | Futures | 2148.39 | 2149.82 | 2146.09 | 2148.39 | 243.0 |
| 2010-07-25 20:00:00 | NQ | Futures | 2148.39 | 2152.11 | 2147.24 | 2150.68 | 586.0 |
| 2010-07-25 21:00:00 | NQ | Futures | 2151.25 | 2158.7 | 2150.68 | 2156.41 | 686.0 |
| 2010-07-25 22:00:00 | NQ | Futures | 2156.41 | 2158.13 | 2154.4 | 2154.98 | 257.0 |
| 2010-07-25 23:00:00 | NQ | Futures | 2154.98 | 2155.55 | 2153.26 | 2154.98 | 154.0 |
| 2010-07-25 18:00:00 | YM | Futures | 9835.2 | 9854.2 | 9818.2 | 9824.8 | 494.0 |
| 2010-07-25 19:00:00 | YM | Futures | 9825.8 | 9834.3 | 9817.3 | 9823.9 | 167.0 |
| 2010-07-25 20:00:00 | YM | Futures | 9826.7 | 9839.0 | 9822.0 | 9834.3 | 329.0 |
| 2010-07-25 21:00:00 | YM | Futures | 9837.1 | 9869.3 | 9833.3 | 9854.2 | 644.0 |
| 2010-07-25 22:00:00 | YM | Futures | 9855.1 | 9858.0 | 9843.8 | 9845.7 | 303.0 |
| 2010-07-25 23:00:00 | YM | Futures | 9845.7 | 9847.5 | 9840.0 | 9846.6 | 177.0 |
| 2010-07-25 18:00:00 | CL | Futures | 151.58 | 151.6 | 150.93 | 151.16 | 1122.0 |
| 2010-07-25 19:00:00 | CL | Futures | 151.1 | 151.33 | 151.1 | 151.28 | 208.0 |
| 2010-07-25 20:00:00 | CL | Futures | 151.33 | 151.47 | 151.1 | 151.33 | 442.0 |
| 2010-07-25 21:00:00 | CL | Futures | 151.3 | 151.91 | 151.28 | 151.76 | 750.0 |
| 2010-07-25 22:00:00 | CL | Futures | 151.76 | 151.89 | 151.6 | 151.81 | 379.0 |
| 2010-07-25 23:00:00 | CL | Futures | 151.79 | 151.97 | 151.77 | 151.95 | 312.0 |
| 2010-07-25 18:00:00 | GC | Futures | 1667.4 | 1670.4 | 1666.8 | 1668.8 | 669.0 |
| 2010-07-25 19:00:00 | GC | Futures | 1668.9 | 1671.3 | 1666.8 | 1671.1 | 947.0 |
| 2010-07-25 20:00:00 | GC | Futures | 1671.3 | 1672.1 | 1669.7 | 1671.3 | 667.0 |
| 2010-07-25 21:00:00 | GC | Futures | 1671.3 | 1672.3 | 1670.4 | 1671.7 | 578.0 |
| 2010-07-25 22:00:00 | GC | Futures | 1672.0 | 1672.4 | 1671.6 | 1672.0 | 244.0 |
| 2010-07-25 23:00:00 | GC | Futures | 1672.0 | 1673.5 | 1672.0 | 1673.0 | 391.0 |
| 2010-07-25 18:00:00 | ZN | Futures | 101.532451 | 101.545382 | 101.441936 | 101.480728 | 2600.0 |
| 2010-07-25 19:00:00 | ZN | Futures | 101.480728 | 101.545382 | 101.480728 | 101.532451 | 2838.0 |
| 2010-07-25 20:00:00 | ZN | Futures | 101.532451 | 101.597105 | 101.532451 | 101.558313 | 6201.0 |
| 2010-07-25 21:00:00 | ZN | Futures | 101.558313 | 101.558313 | 101.493659 | 101.519521 | 4538.0 |
| 2010-07-25 22:00:00 | ZN | Futures | 101.519521 | 101.571244 | 101.519521 | 101.558313 | 2724.0 |
| 2010-07-25 23:00:00 | ZN | Futures | 101.558313 | 101.558313 | 101.519521 | 101.519521 | 1565.0 |
> showing 36 of 242 rows — these rows as CSV