PREVIEW / futures_1hour / 2010-08-29
file: by_date/futures_1hour/2010/2010-08-29.parquet size: 13 KB rows: 245
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-29 18:00:00 | ES | Futures | 1044.83 | 1049.0 | 1044.09 | 1046.79 | 11952.0 |
| 2010-08-29 19:00:00 | ES | Futures | 1046.79 | 1047.53 | 1046.3 | 1047.53 | 2806.0 |
| 2010-08-29 20:00:00 | ES | Futures | 1047.28 | 1048.26 | 1046.54 | 1047.77 | 6247.0 |
| 2010-08-29 21:00:00 | ES | Futures | 1047.53 | 1052.92 | 1047.53 | 1051.94 | 18476.0 |
| 2010-08-29 22:00:00 | ES | Futures | 1051.94 | 1052.43 | 1051.45 | 1052.19 | 4972.0 |
| 2010-08-29 23:00:00 | ES | Futures | 1052.19 | 1052.19 | 1048.02 | 1048.75 | 11694.0 |
| 2010-08-29 18:00:00 | NQ | Futures | 2052.67 | 2061.56 | 2052.1 | 2056.97 | 720.0 |
| 2010-08-29 19:00:00 | NQ | Futures | 2056.68 | 2058.4 | 2056.4 | 2058.4 | 129.0 |
| 2010-08-29 20:00:00 | NQ | Futures | 2058.12 | 2059.84 | 2056.4 | 2058.98 | 358.0 |
| 2010-08-29 21:00:00 | NQ | Futures | 2058.98 | 2069.58 | 2058.98 | 2067.57 | 1254.0 |
| 2010-08-29 22:00:00 | NQ | Futures | 2067.57 | 2068.15 | 2066.14 | 2068.15 | 195.0 |
| 2010-08-29 23:00:00 | NQ | Futures | 2067.86 | 2068.15 | 2060.41 | 2061.27 | 537.0 |
| 2010-08-29 18:00:00 | YM | Futures | 9595.8 | 9633.6 | 9594.8 | 9616.6 | 461.0 |
| 2010-08-29 19:00:00 | YM | Futures | 9614.7 | 9624.1 | 9614.7 | 9624.1 | 92.0 |
| 2010-08-29 20:00:00 | YM | Futures | 9622.3 | 9630.8 | 9618.5 | 9626.0 | 142.0 |
| 2010-08-29 21:00:00 | YM | Futures | 9627.0 | 9666.7 | 9627.0 | 9662.0 | 1100.0 |
| 2010-08-29 22:00:00 | YM | Futures | 9660.1 | 9663.0 | 9655.4 | 9663.0 | 237.0 |
| 2010-08-29 23:00:00 | YM | Futures | 9662.0 | 9662.0 | 9627.9 | 9629.8 | 477.0 |
| 2010-08-29 18:00:00 | CL | Futures | 144.31 | 144.37 | 143.87 | 144.14 | 1476.0 |
| 2010-08-29 19:00:00 | CL | Futures | 144.08 | 144.46 | 144.08 | 144.31 | 432.0 |
| 2010-08-29 20:00:00 | CL | Futures | 144.33 | 144.41 | 143.97 | 144.1 | 604.0 |
| 2010-08-29 21:00:00 | CL | Futures | 144.08 | 144.18 | 143.93 | 144.03 | 658.0 |
| 2010-08-29 22:00:00 | CL | Futures | 144.03 | 144.2 | 144.01 | 144.14 | 372.0 |
| 2010-08-29 23:00:00 | CL | Futures | 144.12 | 144.24 | 143.66 | 143.68 | 891.0 |
| 2010-08-29 18:00:00 | GC | Futures | 1733.3 | 1735.4 | 1733.0 | 1733.7 | 550.0 |
| 2010-08-29 19:00:00 | GC | Futures | 1733.8 | 1735.2 | 1730.6 | 1733.0 | 737.0 |
| 2010-08-29 20:00:00 | GC | Futures | 1733.0 | 1735.4 | 1729.1 | 1731.2 | 1801.0 |
| 2010-08-29 21:00:00 | GC | Futures | 1731.3 | 1732.3 | 1730.2 | 1731.2 | 558.0 |
| 2010-08-29 22:00:00 | GC | Futures | 1731.2 | 1731.6 | 1729.9 | 1730.5 | 707.0 |
| 2010-08-29 23:00:00 | GC | Futures | 1730.6 | 1733.1 | 1730.5 | 1731.3 | 757.0 |
| 2010-08-29 18:00:00 | ZN | Futures | 103.536722 | 103.67896 | 103.381552 | 103.653099 | 7301.0 |
| 2010-08-29 19:00:00 | ZN | Futures | 103.653099 | 103.67896 | 103.588445 | 103.588445 | 3419.0 |
| 2010-08-29 20:00:00 | ZN | Futures | 103.588445 | 103.640168 | 103.523791 | 103.627237 | 7845.0 |
| 2010-08-29 21:00:00 | ZN | Futures | 103.627237 | 103.653099 | 103.588445 | 103.627237 | 6229.0 |
| 2010-08-29 22:00:00 | ZN | Futures | 103.627237 | 103.653099 | 103.627237 | 103.640168 | 1261.0 |
| 2010-08-29 23:00:00 | ZN | Futures | 103.640168 | 103.808268 | 103.640168 | 103.795337 | 11468.0 |
> showing 36 of 245 rows — these rows as CSV