PREVIEW / futures_1hour / 2010-12-05
file: by_date/futures_1hour/2010/2010-12-05.parquet size: 14 KB rows: 255
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-12-05 18:00:00 | ES | Futures | 1206.02 | 1209.23 | 1206.02 | 1208.73 | 8035.0 |
| 2010-12-05 19:00:00 | ES | Futures | 1208.73 | 1209.47 | 1205.53 | 1205.77 | 8210.0 |
| 2010-12-05 20:00:00 | ES | Futures | 1205.77 | 1206.76 | 1204.79 | 1205.28 | 5247.0 |
| 2010-12-05 21:00:00 | ES | Futures | 1205.04 | 1205.77 | 1204.79 | 1205.28 | 3640.0 |
| 2010-12-05 22:00:00 | ES | Futures | 1205.28 | 1205.53 | 1204.05 | 1204.3 | 2940.0 |
| 2010-12-05 23:00:00 | ES | Futures | 1204.3 | 1206.02 | 1204.3 | 1205.77 | 1723.0 |
| 2010-12-05 18:00:00 | NQ | Futures | 2510.97 | 2517.57 | 2509.82 | 2517.0 | 546.0 |
| 2010-12-05 19:00:00 | NQ | Futures | 2517.0 | 2517.57 | 2510.4 | 2510.97 | 671.0 |
| 2010-12-05 20:00:00 | NQ | Futures | 2510.97 | 2512.69 | 2509.54 | 2510.68 | 287.0 |
| 2010-12-05 21:00:00 | NQ | Futures | 2510.4 | 2512.12 | 2508.96 | 2510.4 | 283.0 |
| 2010-12-05 22:00:00 | NQ | Futures | 2510.4 | 2510.4 | 2507.53 | 2508.68 | 203.0 |
| 2010-12-05 23:00:00 | NQ | Futures | 2508.68 | 2511.83 | 2508.39 | 2511.26 | 169.0 |
| 2010-12-05 18:00:00 | YM | Futures | 10824.0 | 10849.7 | 10824.0 | 10846.9 | 382.0 |
| 2010-12-05 19:00:00 | YM | Futures | 10847.8 | 10849.7 | 10823.0 | 10824.0 | 273.0 |
| 2010-12-05 20:00:00 | YM | Futures | 10823.0 | 10830.7 | 10815.4 | 10817.3 | 210.0 |
| 2010-12-05 21:00:00 | YM | Futures | 10820.2 | 10824.9 | 10817.3 | 10821.1 | 129.0 |
| 2010-12-05 22:00:00 | YM | Futures | 10820.2 | 10821.1 | 10811.6 | 10813.5 | 84.0 |
| 2010-12-05 23:00:00 | YM | Futures | 10812.6 | 10828.8 | 10812.6 | 10827.8 | 140.0 |
| 2010-12-05 18:00:00 | CL | Futures | 166.91 | 167.21 | 166.78 | 166.97 | 1382.0 |
| 2010-12-05 19:00:00 | CL | Futures | 166.99 | 167.01 | 166.56 | 166.8 | 1793.0 |
| 2010-12-05 20:00:00 | CL | Futures | 166.77 | 166.93 | 166.63 | 166.8 | 697.0 |
| 2010-12-05 21:00:00 | CL | Futures | 166.78 | 166.88 | 166.63 | 166.73 | 758.0 |
| 2010-12-05 22:00:00 | CL | Futures | 166.75 | 166.8 | 166.37 | 166.47 | 877.0 |
| 2010-12-05 23:00:00 | CL | Futures | 166.45 | 166.75 | 166.34 | 166.73 | 762.0 |
| 2010-12-05 18:00:00 | GC | Futures | 1976.6 | 1978.8 | 1971.0 | 1971.3 | 2729.0 |
| 2010-12-05 19:00:00 | GC | Futures | 1971.3 | 1974.4 | 1969.2 | 1972.7 | 2753.0 |
| 2010-12-05 20:00:00 | GC | Futures | 1972.7 | 1975.1 | 1972.1 | 1974.1 | 2890.0 |
| 2010-12-05 21:00:00 | GC | Futures | 1974.2 | 1975.1 | 1972.3 | 1973.5 | 1413.0 |
| 2010-12-05 22:00:00 | GC | Futures | 1973.5 | 1974.9 | 1972.6 | 1973.8 | 769.0 |
| 2010-12-05 23:00:00 | GC | Futures | 1973.8 | 1975.8 | 1973.4 | 1974.8 | 636.0 |
| 2010-12-05 18:00:00 | ZN | Futures | 103.192521 | 103.270677 | 103.192521 | 103.257651 | 4.0 |
| 2010-12-05 19:00:00 | ZN | Futures | 103.283703 | 103.413964 | 103.283703 | 103.348834 | 423.0 |
| 2010-12-05 20:00:00 | ZN | Futures | 103.348834 | 103.400938 | 103.348834 | 103.400938 | 58.0 |
| 2010-12-05 21:00:00 | ZN | Futures | 103.387912 | 103.453042 | 103.387912 | 103.453042 | 59.0 |
| 2010-12-05 22:00:00 | ZN | Futures | 103.453042 | 103.466068 | 103.453042 | 103.466068 | 60.0 |
| 2010-12-05 23:00:00 | ZN | Futures | 103.453042 | 103.453042 | 103.453042 | 103.453042 | 15.0 |
> showing 36 of 255 rows — these rows as CSV