PREVIEW / futures_30min / 2010-01-03
file: by_date/futures_30min/2010/2010-01-03.parquet size: 18 KB rows: 428
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-01-03 18:00:00 | ES | Futures | 1083.72 | 1086.39 | 1083.23 | 1085.91 | 10291.0 |
| 2010-01-03 18:30:00 | ES | Futures | 1085.91 | 1085.91 | 1084.93 | 1084.93 | 1354.0 |
| 2010-01-03 19:00:00 | ES | Futures | 1085.18 | 1086.15 | 1084.93 | 1085.42 | 2437.0 |
| 2010-01-03 19:30:00 | ES | Futures | 1085.42 | 1085.91 | 1085.18 | 1085.66 | 1328.0 |
| 2010-01-03 20:00:00 | ES | Futures | 1085.42 | 1085.91 | 1085.18 | 1085.66 | 1193.0 |
| 2010-01-03 20:30:00 | ES | Futures | 1085.42 | 1085.91 | 1083.96 | 1084.2 | 2904.0 |
| 2010-01-03 21:00:00 | ES | Futures | 1084.2 | 1085.18 | 1083.96 | 1084.69 | 1181.0 |
| 2010-01-03 21:30:00 | ES | Futures | 1084.69 | 1085.66 | 1084.45 | 1085.66 | 1750.0 |
| 2010-01-03 22:00:00 | ES | Futures | 1085.66 | 1085.66 | 1084.93 | 1084.93 | 1128.0 |
| 2010-01-03 22:30:00 | ES | Futures | 1084.93 | 1085.66 | 1084.69 | 1085.18 | 1813.0 |
| 2010-01-03 23:00:00 | ES | Futures | 1085.18 | 1085.42 | 1084.69 | 1084.93 | 880.0 |
| 2010-01-03 23:30:00 | ES | Futures | 1084.93 | 1085.18 | 1084.45 | 1084.69 | 955.0 |
| 2010-01-03 18:00:00 | NQ | Futures | 2131.36 | 2138.51 | 2131.36 | 2137.36 | 1644.0 |
| 2010-01-03 18:30:00 | NQ | Futures | 2137.36 | 2137.36 | 2134.79 | 2136.51 | 319.0 |
| 2010-01-03 19:00:00 | NQ | Futures | 2136.51 | 2138.79 | 2136.22 | 2137.65 | 431.0 |
| 2010-01-03 19:30:00 | NQ | Futures | 2137.65 | 2137.65 | 2135.93 | 2136.22 | 95.0 |
| 2010-01-03 20:00:00 | NQ | Futures | 2136.22 | 2137.08 | 2135.93 | 2136.79 | 138.0 |
| 2010-01-03 20:30:00 | NQ | Futures | 2136.51 | 2136.79 | 2133.36 | 2133.36 | 476.0 |
| 2010-01-03 21:00:00 | NQ | Futures | 2133.36 | 2134.79 | 2133.08 | 2134.51 | 189.0 |
| 2010-01-03 21:30:00 | NQ | Futures | 2134.51 | 2136.51 | 2134.51 | 2136.51 | 171.0 |
| 2010-01-03 22:00:00 | NQ | Futures | 2136.51 | 2136.51 | 2135.08 | 2135.36 | 97.0 |
| 2010-01-03 22:30:00 | NQ | Futures | 2135.36 | 2136.51 | 2135.08 | 2136.22 | 199.0 |
| 2010-01-03 23:00:00 | NQ | Futures | 2136.22 | 2136.22 | 2135.36 | 2135.65 | 79.0 |
| 2010-01-03 23:30:00 | NQ | Futures | 2135.36 | 2136.51 | 2135.08 | 2135.65 | 211.0 |
| 2010-01-03 18:00:00 | YM | Futures | 9717.5 | 9745.5 | 9717.5 | 9743.7 | 330.0 |
| 2010-01-03 18:30:00 | YM | Futures | 9745.5 | 9745.5 | 9734.3 | 9739.0 | 112.0 |
| 2010-01-03 19:00:00 | YM | Futures | 9740.9 | 9747.4 | 9739.9 | 9744.6 | 224.0 |
| 2010-01-03 19:30:00 | YM | Futures | 9743.7 | 9745.5 | 9741.8 | 9744.6 | 105.0 |
| 2010-01-03 20:00:00 | YM | Futures | 9743.7 | 9744.6 | 9741.8 | 9742.7 | 74.0 |
| 2010-01-03 20:30:00 | YM | Futures | 9742.7 | 9743.7 | 9729.6 | 9729.6 | 300.0 |
| 2010-01-03 21:00:00 | YM | Futures | 9729.6 | 9733.4 | 9727.8 | 9731.5 | 112.0 |
| 2010-01-03 21:30:00 | YM | Futures | 9730.6 | 9737.1 | 9730.6 | 9737.1 | 171.0 |
| 2010-01-03 22:00:00 | YM | Futures | 9737.1 | 9739.0 | 9731.5 | 9733.4 | 88.0 |
| 2010-01-03 22:30:00 | YM | Futures | 9733.4 | 9735.2 | 9730.6 | 9733.4 | 292.0 |
| 2010-01-03 23:00:00 | YM | Futures | 9734.3 | 9736.2 | 9731.5 | 9732.4 | 50.0 |
| 2010-01-03 23:30:00 | YM | Futures | 9731.5 | 9733.4 | 9730.6 | 9733.4 | 47.0 |
| 2010-01-03 18:00:00 | CL | Futures | 171.0 | 171.7 | 171.0 | 171.4 | 818.0 |
| 2010-01-03 18:30:00 | CL | Futures | 171.43 | 171.79 | 171.3 | 171.66 | 582.0 |
| 2010-01-03 19:00:00 | CL | Futures | 171.68 | 171.79 | 171.58 | 171.66 | 475.0 |
| 2010-01-03 19:30:00 | CL | Futures | 171.68 | 171.79 | 171.6 | 171.7 | 267.0 |
| 2010-01-03 20:00:00 | CL | Futures | 171.75 | 171.77 | 171.62 | 171.68 | 167.0 |
| 2010-01-03 20:30:00 | CL | Futures | 171.7 | 171.7 | 171.58 | 171.6 | 179.0 |
| 2010-01-03 21:00:00 | CL | Futures | 171.58 | 171.73 | 171.3 | 171.49 | 447.0 |
| 2010-01-03 21:30:00 | CL | Futures | 171.49 | 171.79 | 171.47 | 171.68 | 271.0 |
| 2010-01-03 22:00:00 | CL | Futures | 171.7 | 171.79 | 171.49 | 171.73 | 703.0 |
| 2010-01-03 22:30:00 | CL | Futures | 171.73 | 171.77 | 171.58 | 171.77 | 215.0 |
| 2010-01-03 23:00:00 | CL | Futures | 171.73 | 171.79 | 171.66 | 171.75 | 170.0 |
| 2010-01-03 23:30:00 | CL | Futures | 171.75 | 171.79 | 171.68 | 171.79 | 457.0 |
| 2010-01-03 18:00:00 | GC | Futures | 1548.8 | 1552.0 | 1548.7 | 1550.1 | 1062.0 |
| 2010-01-03 18:30:00 | GC | Futures | 1549.6 | 1549.9 | 1545.1 | 1545.3 | 733.0 |
> showing 50 of 428 rows — these rows as CSV