PREVIEW / futures_30min / 2008-04-27
file: by_date/futures_30min/2008/2008-04-27.parquet size: 17 KB rows: 416
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-27 18:00:00 | ES | Futures | 1302.76 | 1303.92 | 1300.43 | 1300.66 | 2491.0 |
| 2008-04-27 18:30:00 | ES | Futures | 1300.66 | 1300.9 | 1299.27 | 1300.2 | 684.0 |
| 2008-04-27 19:00:00 | ES | Futures | 1300.2 | 1300.2 | 1299.73 | 1300.2 | 322.0 |
| 2008-04-27 19:30:00 | ES | Futures | 1300.2 | 1300.9 | 1299.73 | 1300.43 | 898.0 |
| 2008-04-27 20:00:00 | ES | Futures | 1300.2 | 1300.2 | 1298.57 | 1300.2 | 1565.0 |
| 2008-04-27 20:30:00 | ES | Futures | 1299.97 | 1301.83 | 1299.97 | 1301.83 | 1461.0 |
| 2008-04-27 21:00:00 | ES | Futures | 1301.83 | 1302.29 | 1301.36 | 1301.83 | 365.0 |
| 2008-04-27 21:30:00 | ES | Futures | 1301.83 | 1301.83 | 1300.43 | 1301.36 | 578.0 |
| 2008-04-27 22:00:00 | ES | Futures | 1301.36 | 1301.6 | 1300.66 | 1300.66 | 301.0 |
| 2008-04-27 22:30:00 | ES | Futures | 1300.9 | 1300.9 | 1299.5 | 1300.2 | 684.0 |
| 2008-04-27 23:00:00 | ES | Futures | 1299.97 | 1300.9 | 1299.73 | 1300.66 | 357.0 |
| 2008-04-27 23:30:00 | ES | Futures | 1300.9 | 1301.83 | 1300.43 | 1301.36 | 470.0 |
| 2008-04-27 18:00:00 | NQ | Futures | 2174.67 | 2176.65 | 2170.99 | 2172.41 | 85.0 |
| 2008-04-27 18:30:00 | NQ | Futures | 2172.12 | 2173.26 | 2170.99 | 2172.12 | 19.0 |
| 2008-04-27 19:00:00 | NQ | Futures | 2173.82 | 2174.39 | 2171.28 | 2171.28 | 32.0 |
| 2008-04-27 19:30:00 | NQ | Futures | 2171.56 | 2173.82 | 2171.56 | 2172.12 | 26.0 |
| 2008-04-27 20:00:00 | NQ | Futures | 2172.69 | 2172.97 | 2170.71 | 2172.41 | 41.0 |
| 2008-04-27 20:30:00 | NQ | Futures | 2172.69 | 2175.52 | 2172.69 | 2175.52 | 19.0 |
| 2008-04-27 21:00:00 | NQ | Futures | 2175.52 | 2176.37 | 2175.23 | 2175.23 | 10.0 |
| 2008-04-27 21:30:00 | NQ | Futures | 2174.67 | 2176.37 | 2173.54 | 2173.82 | 27.0 |
| 2008-04-27 22:00:00 | NQ | Futures | 2174.39 | 2174.67 | 2173.54 | 2174.39 | 8.0 |
| 2008-04-27 22:30:00 | NQ | Futures | 2173.54 | 2173.54 | 2170.71 | 2172.69 | 58.0 |
| 2008-04-27 23:00:00 | NQ | Futures | 2172.12 | 2173.82 | 2172.12 | 2173.82 | 23.0 |
| 2008-04-27 23:30:00 | NQ | Futures | 2174.1 | 2176.37 | 2174.1 | 2174.39 | 39.0 |
| 2008-04-27 18:00:00 | YM | Futures | 11703.4 | 11713.4 | 11687.1 | 11688.0 | 90.0 |
| 2008-04-27 18:30:00 | YM | Futures | 11692.5 | 11695.3 | 11681.6 | 11692.5 | 36.0 |
| 2008-04-27 19:00:00 | YM | Futures | 11692.5 | 11692.5 | 11685.3 | 11691.6 | 20.0 |
| 2008-04-27 19:30:00 | YM | Futures | 11687.1 | 11690.7 | 11681.6 | 11688.0 | 42.0 |
| 2008-04-27 20:00:00 | YM | Futures | 11685.3 | 11685.3 | 11677.1 | 11683.4 | 88.0 |
| 2008-04-27 20:30:00 | YM | Futures | 11686.2 | 11698.9 | 11684.3 | 11698.9 | 52.0 |
| 2008-04-27 21:00:00 | YM | Futures | 11701.6 | 11703.4 | 11698.0 | 11698.9 | 54.0 |
| 2008-04-27 21:30:00 | YM | Futures | 11698.9 | 11700.7 | 11689.8 | 11697.1 | 62.0 |
| 2008-04-27 22:00:00 | YM | Futures | 11698.0 | 11702.5 | 11696.2 | 11696.2 | 64.0 |
| 2008-04-27 22:30:00 | YM | Futures | 11693.4 | 11697.1 | 11683.4 | 11687.1 | 67.0 |
| 2008-04-27 23:00:00 | YM | Futures | 11687.1 | 11696.2 | 11687.1 | 11690.7 | 49.0 |
| 2008-04-27 23:30:00 | YM | Futures | 11693.4 | 11698.9 | 11689.8 | 11697.1 | 34.0 |
| 2008-04-27 18:00:00 | CL | Futures | 452.43 | 456.15 | 452.39 | 454.63 | 1231.0 |
| 2008-04-27 18:30:00 | CL | Futures | 454.63 | 454.63 | 453.3 | 453.8 | 471.0 |
| 2008-04-27 19:00:00 | CL | Futures | 453.8 | 454.41 | 453.8 | 454.14 | 265.0 |
| 2008-04-27 19:30:00 | CL | Futures | 454.18 | 454.25 | 454.06 | 454.1 | 124.0 |
| 2008-04-27 20:00:00 | CL | Futures | 454.1 | 454.41 | 453.95 | 454.14 | 330.0 |
| 2008-04-27 20:30:00 | CL | Futures | 454.21 | 454.41 | 454.02 | 454.1 | 147.0 |
| 2008-04-27 21:00:00 | CL | Futures | 454.14 | 454.25 | 453.61 | 453.87 | 243.0 |
| 2008-04-27 21:30:00 | CL | Futures | 453.72 | 454.1 | 453.38 | 453.83 | 74.0 |
| 2008-04-27 22:00:00 | CL | Futures | 453.83 | 454.14 | 453.83 | 453.91 | 158.0 |
| 2008-04-27 22:30:00 | CL | Futures | 453.87 | 454.25 | 453.8 | 454.14 | 97.0 |
| 2008-04-27 23:00:00 | CL | Futures | 454.14 | 454.21 | 454.02 | 454.21 | 52.0 |
| 2008-04-27 23:30:00 | CL | Futures | 454.21 | 454.25 | 453.76 | 453.76 | 115.0 |
| 2008-04-27 18:00:00 | GC | Futures | 1289.4 | 1294.1 | 1289.3 | 1292.3 | 323.0 |
| 2008-04-27 18:30:00 | GC | Futures | 1291.9 | 1291.9 | 1287.7 | 1288.7 | 204.0 |
> showing 50 of 416 rows — these rows as CSV