PREVIEW / futures_30min / 2009-12-20
file: by_date/futures_30min/2009/2009-12-20.parquet size: 17 KB rows: 396
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-20 18:00:00 | ES | Futures | 1069.12 | 1070.1 | 1066.93 | 1068.15 | 8088.0 |
| 2009-12-20 18:30:00 | ES | Futures | 1068.39 | 1069.12 | 1068.15 | 1068.88 | 1352.0 |
| 2009-12-20 19:00:00 | ES | Futures | 1069.12 | 1069.12 | 1067.66 | 1068.64 | 2162.0 |
| 2009-12-20 19:30:00 | ES | Futures | 1068.64 | 1069.37 | 1068.39 | 1068.88 | 1624.0 |
| 2009-12-20 20:00:00 | ES | Futures | 1068.88 | 1069.61 | 1068.64 | 1069.37 | 1686.0 |
| 2009-12-20 20:30:00 | ES | Futures | 1069.37 | 1069.85 | 1068.64 | 1068.88 | 1190.0 |
| 2009-12-20 21:00:00 | ES | Futures | 1069.12 | 1069.61 | 1068.88 | 1069.61 | 797.0 |
| 2009-12-20 21:30:00 | ES | Futures | 1069.61 | 1071.31 | 1069.61 | 1071.31 | 3608.0 |
| 2009-12-20 22:00:00 | ES | Futures | 1071.31 | 1072.28 | 1071.31 | 1072.04 | 2605.0 |
| 2009-12-20 22:30:00 | ES | Futures | 1071.8 | 1072.28 | 1070.83 | 1070.83 | 1972.0 |
| 2009-12-20 23:00:00 | ES | Futures | 1070.83 | 1071.8 | 1070.1 | 1071.31 | 1904.0 |
| 2009-12-20 23:30:00 | ES | Futures | 1071.55 | 1071.55 | 1070.58 | 1070.58 | 1511.0 |
| 2009-12-20 18:00:00 | NQ | Futures | 2063.38 | 2065.96 | 2059.96 | 2063.67 | 546.0 |
| 2009-12-20 18:30:00 | NQ | Futures | 2063.38 | 2065.38 | 2063.38 | 2064.53 | 93.0 |
| 2009-12-20 19:00:00 | NQ | Futures | 2064.53 | 2066.81 | 2063.96 | 2066.53 | 379.0 |
| 2009-12-20 19:30:00 | NQ | Futures | 2066.53 | 2067.1 | 2065.67 | 2066.53 | 163.0 |
| 2009-12-20 20:00:00 | NQ | Futures | 2066.53 | 2067.1 | 2065.96 | 2067.1 | 113.0 |
| 2009-12-20 20:30:00 | NQ | Futures | 2067.1 | 2067.95 | 2066.24 | 2067.38 | 85.0 |
| 2009-12-20 21:00:00 | NQ | Futures | 2067.67 | 2068.53 | 2067.1 | 2068.24 | 281.0 |
| 2009-12-20 21:30:00 | NQ | Futures | 2068.24 | 2073.95 | 2068.24 | 2073.67 | 1495.0 |
| 2009-12-20 22:00:00 | NQ | Futures | 2073.67 | 2074.81 | 2073.1 | 2073.67 | 172.0 |
| 2009-12-20 22:30:00 | NQ | Futures | 2073.67 | 2073.95 | 2072.53 | 2072.81 | 88.0 |
| 2009-12-20 23:00:00 | NQ | Futures | 2073.1 | 2074.52 | 2071.38 | 2073.1 | 234.0 |
| 2009-12-20 23:30:00 | NQ | Futures | 2073.38 | 2073.38 | 2070.81 | 2070.81 | 261.0 |
| 2009-12-20 18:00:00 | YM | Futures | 9616.4 | 9623.0 | 9602.4 | 9612.7 | 211.0 |
| 2009-12-20 18:30:00 | YM | Futures | 9614.5 | 9622.0 | 9611.7 | 9618.3 | 82.0 |
| 2009-12-20 19:00:00 | YM | Futures | 9619.2 | 9620.1 | 9611.7 | 9618.3 | 107.0 |
| 2009-12-20 19:30:00 | YM | Futures | 9619.2 | 9623.0 | 9618.3 | 9619.2 | 54.0 |
| 2009-12-20 20:00:00 | YM | Futures | 9620.1 | 9623.0 | 9617.3 | 9622.0 | 52.0 |
| 2009-12-20 20:30:00 | YM | Futures | 9623.9 | 9623.9 | 9620.1 | 9623.0 | 20.0 |
| 2009-12-20 21:00:00 | YM | Futures | 9622.0 | 9623.0 | 9618.3 | 9621.1 | 108.0 |
| 2009-12-20 21:30:00 | YM | Futures | 9623.0 | 9637.9 | 9622.0 | 9637.9 | 209.0 |
| 2009-12-20 22:00:00 | YM | Futures | 9638.9 | 9642.6 | 9637.0 | 9639.8 | 103.0 |
| 2009-12-20 22:30:00 | YM | Futures | 9641.7 | 9641.7 | 9629.5 | 9635.1 | 171.0 |
| 2009-12-20 23:00:00 | YM | Futures | 9633.2 | 9638.9 | 9626.7 | 9635.1 | 85.0 |
| 2009-12-20 23:30:00 | YM | Futures | 9635.1 | 9635.1 | 9629.5 | 9629.5 | 37.0 |
| 2009-12-20 18:00:00 | CL | Futures | 159.74 | 160.02 | 158.95 | 159.77 | 421.0 |
| 2009-12-20 18:30:00 | CL | Futures | 159.72 | 160.11 | 159.72 | 159.94 | 157.0 |
| 2009-12-20 19:00:00 | CL | Futures | 159.96 | 160.73 | 159.94 | 160.47 | 430.0 |
| 2009-12-20 19:30:00 | CL | Futures | 160.47 | 160.77 | 160.41 | 160.43 | 282.0 |
| 2009-12-20 20:00:00 | CL | Futures | 160.41 | 160.56 | 160.07 | 160.17 | 329.0 |
| 2009-12-20 20:30:00 | CL | Futures | 160.15 | 160.26 | 160.04 | 160.09 | 240.0 |
| 2009-12-20 21:00:00 | CL | Futures | 160.07 | 160.24 | 160.04 | 160.13 | 144.0 |
| 2009-12-20 21:30:00 | CL | Futures | 160.17 | 160.39 | 160.09 | 160.37 | 339.0 |
| 2009-12-20 22:00:00 | CL | Futures | 160.3 | 160.39 | 160.19 | 160.26 | 115.0 |
| 2009-12-20 22:30:00 | CL | Futures | 160.3 | 160.39 | 160.22 | 160.26 | 98.0 |
| 2009-12-20 23:00:00 | CL | Futures | 160.24 | 160.45 | 160.11 | 160.24 | 153.0 |
| 2009-12-20 23:30:00 | CL | Futures | 160.26 | 160.39 | 160.15 | 160.22 | 197.0 |
| 2009-12-20 18:00:00 | GC | Futures | 1567.0 | 1574.9 | 1565.6 | 1573.6 | 1173.0 |
| 2009-12-20 18:30:00 | GC | Futures | 1573.7 | 1579.5 | 1571.2 | 1571.6 | 2500.0 |
> showing 50 of 396 rows — these rows as CSV