PREVIEW / futures_30min / 2012-07-11
file: by_date/futures_30min/2012/2012-07-11.parquet size: 77 KB rows: 2,809
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 |
|---|---|---|---|---|---|---|---|
| 2012-07-11 00:00:00 | ES | Futures | 1357.87 | 1359.14 | 1357.87 | 1358.89 | 1262.0 |
| 2012-07-11 00:30:00 | ES | Futures | 1358.89 | 1359.14 | 1358.13 | 1358.89 | 1106.0 |
| 2012-07-11 01:00:00 | ES | Futures | 1358.89 | 1359.65 | 1358.89 | 1359.65 | 1796.0 |
| 2012-07-11 01:30:00 | ES | Futures | 1359.65 | 1360.16 | 1359.14 | 1360.16 | 2183.0 |
| 2012-07-11 02:00:00 | ES | Futures | 1360.16 | 1360.42 | 1359.14 | 1359.65 | 2496.0 |
| 2012-07-11 02:30:00 | ES | Futures | 1359.91 | 1360.42 | 1359.14 | 1359.14 | 3250.0 |
| 2012-07-11 03:00:00 | ES | Futures | 1359.14 | 1360.92 | 1357.62 | 1360.67 | 16116.0 |
| 2012-07-11 03:30:00 | ES | Futures | 1360.67 | 1361.94 | 1359.4 | 1359.65 | 10817.0 |
| 2012-07-11 04:00:00 | ES | Futures | 1359.65 | 1359.91 | 1358.38 | 1359.65 | 9012.0 |
| 2012-07-11 04:30:00 | ES | Futures | 1359.65 | 1362.96 | 1359.14 | 1362.45 | 13663.0 |
| 2012-07-11 05:00:00 | ES | Futures | 1362.7 | 1362.7 | 1361.18 | 1361.94 | 10386.0 |
| 2012-07-11 05:30:00 | ES | Futures | 1361.69 | 1362.2 | 1360.92 | 1361.18 | 6950.0 |
| 2012-07-11 06:00:00 | ES | Futures | 1361.18 | 1361.69 | 1360.42 | 1361.43 | 4856.0 |
| 2012-07-11 06:30:00 | ES | Futures | 1361.69 | 1364.48 | 1361.69 | 1363.98 | 19699.0 |
| 2012-07-11 07:00:00 | ES | Futures | 1363.72 | 1365.5 | 1362.96 | 1363.21 | 14374.0 |
| 2012-07-11 07:30:00 | ES | Futures | 1363.47 | 1363.72 | 1361.18 | 1361.69 | 14791.0 |
| 2012-07-11 08:00:00 | ES | Futures | 1361.69 | 1361.94 | 1359.4 | 1359.91 | 22548.0 |
| 2012-07-11 08:30:00 | ES | Futures | 1359.65 | 1361.94 | 1359.65 | 1359.91 | 19025.0 |
| 2012-07-11 09:00:00 | ES | Futures | 1359.91 | 1361.18 | 1358.13 | 1358.89 | 25973.0 |
| 2012-07-11 09:30:00 | ES | Futures | 1358.89 | 1362.2 | 1356.6 | 1360.42 | 178460.0 |
| 2012-07-11 10:00:00 | ES | Futures | 1360.16 | 1362.96 | 1358.89 | 1359.65 | 130262.0 |
| 2012-07-11 10:30:00 | ES | Futures | 1359.4 | 1360.42 | 1356.09 | 1356.09 | 121975.0 |
| 2012-07-11 11:00:00 | ES | Futures | 1356.09 | 1359.91 | 1355.84 | 1357.62 | 142288.0 |
| 2012-07-11 11:30:00 | ES | Futures | 1357.87 | 1360.16 | 1357.37 | 1359.65 | 78983.0 |
| 2012-07-11 12:00:00 | ES | Futures | 1359.4 | 1361.94 | 1359.14 | 1359.4 | 91429.0 |
| 2012-07-11 12:30:00 | ES | Futures | 1359.65 | 1361.69 | 1359.4 | 1361.18 | 59218.0 |
| 2012-07-11 13:00:00 | ES | Futures | 1361.18 | 1361.43 | 1357.62 | 1359.14 | 56122.0 |
| 2012-07-11 13:30:00 | ES | Futures | 1359.14 | 1360.92 | 1358.13 | 1360.42 | 41257.0 |
| 2012-07-11 14:00:00 | ES | Futures | 1360.16 | 1361.94 | 1351.52 | 1352.53 | 235936.0 |
| 2012-07-11 14:30:00 | ES | Futures | 1352.79 | 1355.33 | 1350.5 | 1353.04 | 122789.0 |
| 2012-07-11 15:00:00 | ES | Futures | 1353.04 | 1356.6 | 1353.04 | 1354.31 | 121441.0 |
| 2012-07-11 15:30:00 | ES | Futures | 1354.31 | 1362.45 | 1353.55 | 1358.89 | 234546.0 |
| 2012-07-11 16:00:00 | ES | Futures | 1358.64 | 1359.91 | 1358.13 | 1359.65 | 58276.0 |
| 2012-07-11 16:30:00 | ES | Futures | 1359.4 | 1361.43 | 1359.4 | 1360.67 | 5012.0 |
| 2012-07-11 17:00:00 | ES | Futures | 1360.92 | 1362.45 | 1360.67 | 1362.2 | 2430.0 |
| 2012-07-11 18:00:00 | ES | Futures | 1362.2 | 1362.2 | 1360.42 | 1360.42 | 2442.0 |
| 2012-07-11 18:30:00 | ES | Futures | 1360.67 | 1361.18 | 1360.42 | 1361.18 | 699.0 |
| 2012-07-11 19:00:00 | ES | Futures | 1361.18 | 1361.18 | 1360.92 | 1360.92 | 536.0 |
| 2012-07-11 19:30:00 | ES | Futures | 1361.18 | 1361.94 | 1360.67 | 1361.43 | 1449.0 |
| 2012-07-11 20:00:00 | ES | Futures | 1361.43 | 1361.43 | 1360.42 | 1360.42 | 1733.0 |
| 2012-07-11 20:30:00 | ES | Futures | 1360.67 | 1360.92 | 1359.65 | 1360.42 | 1569.0 |
| 2012-07-11 21:00:00 | ES | Futures | 1360.42 | 1360.92 | 1359.14 | 1359.4 | 2743.0 |
| 2012-07-11 21:30:00 | ES | Futures | 1359.4 | 1359.4 | 1356.86 | 1356.86 | 9190.0 |
| 2012-07-11 22:00:00 | ES | Futures | 1357.11 | 1357.87 | 1356.6 | 1357.37 | 5243.0 |
| 2012-07-11 22:30:00 | ES | Futures | 1357.37 | 1358.38 | 1357.11 | 1357.62 | 3188.0 |
| 2012-07-11 23:00:00 | ES | Futures | 1357.62 | 1358.13 | 1357.37 | 1357.87 | 1184.0 |
| 2012-07-11 23:30:00 | ES | Futures | 1357.87 | 1358.89 | 1357.11 | 1358.13 | 3006.0 |
| 2012-07-11 00:00:00 | NQ | Futures | 2988.71 | 2991.61 | 2988.71 | 2991.32 | 173.0 |
| 2012-07-11 00:30:00 | NQ | Futures | 2991.32 | 2991.32 | 2989.58 | 2990.45 | 132.0 |
| 2012-07-11 01:00:00 | NQ | Futures | 2991.03 | 2992.77 | 2990.74 | 2992.19 | 227.0 |
> showing 50 of 2,809 rows — these rows as CSV