PREVIEW / futures_30min / 2009-01-25
file: by_date/futures_30min/2009/2009-01-25.parquet size: 18 KB rows: 424
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-01-25 18:00:00 | ES | Futures | 781.29 | 781.53 | 776.07 | 776.78 | 4575.0 |
| 2009-01-25 18:30:00 | ES | Futures | 777.02 | 777.73 | 776.07 | 777.26 | 2504.0 |
| 2009-01-25 19:00:00 | ES | Futures | 777.26 | 777.73 | 774.17 | 775.83 | 3763.0 |
| 2009-01-25 19:30:00 | ES | Futures | 775.6 | 776.54 | 774.88 | 776.07 | 1954.0 |
| 2009-01-25 20:00:00 | ES | Futures | 776.07 | 776.54 | 775.6 | 775.6 | 1413.0 |
| 2009-01-25 20:30:00 | ES | Futures | 775.83 | 777.26 | 775.83 | 776.54 | 1113.0 |
| 2009-01-25 21:00:00 | ES | Futures | 776.54 | 777.02 | 776.31 | 777.02 | 443.0 |
| 2009-01-25 21:30:00 | ES | Futures | 777.02 | 777.02 | 775.6 | 776.54 | 1078.0 |
| 2009-01-25 22:00:00 | ES | Futures | 776.54 | 776.78 | 776.07 | 776.31 | 278.0 |
| 2009-01-25 22:30:00 | ES | Futures | 776.31 | 777.02 | 776.31 | 777.02 | 272.0 |
| 2009-01-25 23:00:00 | ES | Futures | 776.78 | 777.97 | 776.54 | 777.73 | 1715.0 |
| 2009-01-25 23:30:00 | ES | Futures | 777.73 | 778.68 | 777.49 | 778.68 | 865.0 |
| 2009-01-25 18:00:00 | NQ | Futures | 1315.89 | 1315.89 | 1306.01 | 1307.42 | 317.0 |
| 2009-01-25 18:30:00 | NQ | Futures | 1307.42 | 1309.68 | 1306.86 | 1308.83 | 53.0 |
| 2009-01-25 19:00:00 | NQ | Futures | 1308.55 | 1308.83 | 1303.75 | 1306.86 | 163.0 |
| 2009-01-25 19:30:00 | NQ | Futures | 1306.29 | 1306.86 | 1305.16 | 1306.86 | 25.0 |
| 2009-01-25 20:00:00 | NQ | Futures | 1307.42 | 1307.42 | 1306.01 | 1306.01 | 28.0 |
| 2009-01-25 20:30:00 | NQ | Futures | 1306.01 | 1307.99 | 1306.01 | 1307.7 | 50.0 |
| 2009-01-25 21:00:00 | NQ | Futures | 1308.27 | 1309.12 | 1307.42 | 1309.12 | 52.0 |
| 2009-01-25 21:30:00 | NQ | Futures | 1308.83 | 1308.83 | 1306.86 | 1307.42 | 52.0 |
| 2009-01-25 22:00:00 | NQ | Futures | 1307.42 | 1308.27 | 1307.14 | 1307.99 | 7.0 |
| 2009-01-25 22:30:00 | NQ | Futures | 1307.99 | 1308.55 | 1307.14 | 1307.99 | 16.0 |
| 2009-01-25 23:00:00 | NQ | Futures | 1307.99 | 1309.4 | 1307.99 | 1308.83 | 11.0 |
| 2009-01-25 23:30:00 | NQ | Futures | 1309.12 | 1310.81 | 1309.12 | 1310.81 | 36.0 |
| 2009-01-25 18:00:00 | YM | Futures | 7272.9 | 7272.9 | 7225.5 | 7234.6 | 401.0 |
| 2009-01-25 18:30:00 | YM | Futures | 7232.8 | 7240.1 | 7229.1 | 7235.5 | 96.0 |
| 2009-01-25 19:00:00 | YM | Futures | 7232.8 | 7237.3 | 7213.6 | 7222.8 | 86.0 |
| 2009-01-25 19:30:00 | YM | Futures | 7222.8 | 7233.7 | 7219.1 | 7232.8 | 66.0 |
| 2009-01-25 20:00:00 | YM | Futures | 7231.9 | 7231.9 | 7225.5 | 7227.3 | 102.0 |
| 2009-01-25 20:30:00 | YM | Futures | 7231.0 | 7235.5 | 7228.2 | 7231.9 | 65.0 |
| 2009-01-25 21:00:00 | YM | Futures | 7230.0 | 7237.3 | 7229.1 | 7235.5 | 139.0 |
| 2009-01-25 21:30:00 | YM | Futures | 7237.3 | 7238.2 | 7228.2 | 7230.0 | 265.0 |
| 2009-01-25 22:00:00 | YM | Futures | 7233.7 | 7234.6 | 7231.0 | 7231.9 | 11.0 |
| 2009-01-25 22:30:00 | YM | Futures | 7234.6 | 7241.0 | 7231.9 | 7240.1 | 52.0 |
| 2009-01-25 23:00:00 | YM | Futures | 7240.1 | 7252.8 | 7238.2 | 7245.5 | 133.0 |
| 2009-01-25 23:30:00 | YM | Futures | 7245.5 | 7251.0 | 7244.6 | 7250.1 | 55.0 |
| 2009-01-25 18:00:00 | CL | Futures | 138.01 | 139.2 | 138.01 | 138.49 | 837.0 |
| 2009-01-25 18:30:00 | CL | Futures | 138.4 | 138.49 | 137.29 | 137.53 | 440.0 |
| 2009-01-25 19:00:00 | CL | Futures | 137.41 | 137.41 | 136.69 | 136.9 | 507.0 |
| 2009-01-25 19:30:00 | CL | Futures | 136.81 | 137.23 | 136.66 | 137.11 | 134.0 |
| 2009-01-25 20:00:00 | CL | Futures | 136.96 | 137.47 | 136.72 | 137.11 | 119.0 |
| 2009-01-25 20:30:00 | CL | Futures | 137.05 | 137.23 | 136.72 | 136.96 | 113.0 |
| 2009-01-25 21:00:00 | CL | Futures | 137.02 | 137.53 | 136.84 | 137.41 | 90.0 |
| 2009-01-25 21:30:00 | CL | Futures | 137.35 | 137.83 | 137.29 | 137.44 | 121.0 |
| 2009-01-25 22:00:00 | CL | Futures | 137.35 | 137.41 | 137.14 | 137.17 | 37.0 |
| 2009-01-25 22:30:00 | CL | Futures | 137.11 | 137.41 | 136.69 | 137.41 | 119.0 |
| 2009-01-25 23:00:00 | CL | Futures | 137.26 | 137.29 | 136.72 | 136.9 | 99.0 |
| 2009-01-25 23:30:00 | CL | Futures | 136.9 | 137.2 | 136.81 | 136.96 | 124.0 |
| 2009-01-25 18:00:00 | GC | Futures | 1281.7 | 1284.5 | 1274.3 | 1274.7 | 2326.0 |
| 2009-01-25 18:30:00 | GC | Futures | 1274.4 | 1281.2 | 1273.3 | 1279.0 | 1072.0 |
> showing 50 of 424 rows — these rows as CSV