PREVIEW / futures_5min / 2013-07-31
file: by_date/futures_5min/2013/2013-07-31.parquet size: 230 KB rows: 13,839
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-31 00:00:00 | ES | Futures | 1743.55 | 1743.55 | 1743.29 | 1743.29 | 127.0 |
| 2013-07-31 00:05:00 | ES | Futures | 1743.29 | 1743.29 | 1743.03 | 1743.29 | 194.0 |
| 2013-07-31 00:10:00 | ES | Futures | 1743.29 | 1743.29 | 1743.03 | 1743.29 | 29.0 |
| 2013-07-31 00:15:00 | ES | Futures | 1743.29 | 1743.29 | 1743.03 | 1743.29 | 64.0 |
| 2013-07-31 00:20:00 | ES | Futures | 1743.03 | 1743.29 | 1742.77 | 1742.77 | 162.0 |
| 2013-07-31 00:25:00 | ES | Futures | 1743.03 | 1743.29 | 1742.77 | 1743.29 | 260.0 |
| 2013-07-31 00:30:00 | ES | Futures | 1743.03 | 1743.29 | 1743.03 | 1743.03 | 77.0 |
| 2013-07-31 00:35:00 | ES | Futures | 1743.29 | 1743.29 | 1743.29 | 1743.29 | 5.0 |
| 2013-07-31 00:40:00 | ES | Futures | 1743.29 | 1743.29 | 1743.03 | 1743.03 | 27.0 |
| 2013-07-31 00:45:00 | ES | Futures | 1743.03 | 1743.29 | 1743.03 | 1743.03 | 14.0 |
| 2013-07-31 00:50:00 | ES | Futures | 1743.03 | 1743.29 | 1743.03 | 1743.03 | 8.0 |
| 2013-07-31 00:55:00 | ES | Futures | 1743.03 | 1743.29 | 1743.03 | 1743.29 | 57.0 |
| 2013-07-31 01:00:00 | ES | Futures | 1743.03 | 1743.29 | 1743.03 | 1743.03 | 172.0 |
| 2013-07-31 01:05:00 | ES | Futures | 1743.03 | 1743.03 | 1742.51 | 1742.51 | 362.0 |
| 2013-07-31 01:10:00 | ES | Futures | 1742.51 | 1743.03 | 1742.51 | 1743.03 | 187.0 |
| 2013-07-31 01:15:00 | ES | Futures | 1742.77 | 1742.77 | 1742.77 | 1742.77 | 24.0 |
| 2013-07-31 01:20:00 | ES | Futures | 1743.03 | 1743.03 | 1742.51 | 1742.51 | 74.0 |
| 2013-07-31 01:25:00 | ES | Futures | 1742.77 | 1742.77 | 1742.26 | 1742.26 | 145.0 |
| 2013-07-31 01:30:00 | ES | Futures | 1742.26 | 1742.51 | 1742.26 | 1742.51 | 127.0 |
| 2013-07-31 01:35:00 | ES | Futures | 1742.51 | 1742.51 | 1742.26 | 1742.51 | 197.0 |
| 2013-07-31 01:40:00 | ES | Futures | 1742.51 | 1743.03 | 1742.51 | 1742.51 | 142.0 |
| 2013-07-31 01:45:00 | ES | Futures | 1742.51 | 1742.77 | 1742.26 | 1742.51 | 252.0 |
| 2013-07-31 01:50:00 | ES | Futures | 1742.51 | 1742.77 | 1742.26 | 1742.26 | 133.0 |
| 2013-07-31 01:55:00 | ES | Futures | 1742.26 | 1742.51 | 1742.26 | 1742.26 | 172.0 |
| 2013-07-31 02:00:00 | ES | Futures | 1742.26 | 1742.77 | 1741.74 | 1742.0 | 1140.0 |
| 2013-07-31 02:05:00 | ES | Futures | 1742.0 | 1742.26 | 1740.96 | 1740.96 | 1293.0 |
| 2013-07-31 02:10:00 | ES | Futures | 1740.96 | 1741.22 | 1740.7 | 1740.96 | 740.0 |
| 2013-07-31 02:15:00 | ES | Futures | 1740.96 | 1741.22 | 1740.19 | 1740.45 | 1557.0 |
| 2013-07-31 02:20:00 | ES | Futures | 1740.45 | 1740.45 | 1739.41 | 1740.19 | 1590.0 |
| 2013-07-31 02:25:00 | ES | Futures | 1739.93 | 1740.45 | 1739.67 | 1740.45 | 860.0 |
| 2013-07-31 02:30:00 | ES | Futures | 1740.45 | 1740.7 | 1740.19 | 1740.45 | 553.0 |
| 2013-07-31 02:35:00 | ES | Futures | 1740.45 | 1740.7 | 1739.93 | 1740.19 | 407.0 |
| 2013-07-31 02:40:00 | ES | Futures | 1739.93 | 1740.7 | 1739.93 | 1739.93 | 730.0 |
| 2013-07-31 02:45:00 | ES | Futures | 1739.93 | 1740.96 | 1739.93 | 1740.96 | 572.0 |
| 2013-07-31 02:50:00 | ES | Futures | 1740.96 | 1740.96 | 1740.7 | 1740.7 | 229.0 |
| 2013-07-31 02:55:00 | ES | Futures | 1740.96 | 1740.96 | 1740.7 | 1740.96 | 258.0 |
| 2013-07-31 03:00:00 | ES | Futures | 1740.96 | 1741.74 | 1739.93 | 1740.96 | 2588.0 |
| 2013-07-31 03:05:00 | ES | Futures | 1741.22 | 1741.48 | 1740.7 | 1740.96 | 1011.0 |
| 2013-07-31 03:10:00 | ES | Futures | 1740.7 | 1740.96 | 1739.15 | 1740.96 | 4261.0 |
| 2013-07-31 03:15:00 | ES | Futures | 1740.7 | 1740.96 | 1740.19 | 1740.7 | 1255.0 |
| 2013-07-31 03:20:00 | ES | Futures | 1740.45 | 1740.96 | 1739.93 | 1740.45 | 1383.0 |
| 2013-07-31 03:25:00 | ES | Futures | 1740.45 | 1740.96 | 1739.93 | 1739.93 | 2372.0 |
| 2013-07-31 03:30:00 | ES | Futures | 1739.93 | 1742.0 | 1739.67 | 1740.96 | 2207.0 |
| 2013-07-31 03:35:00 | ES | Futures | 1740.96 | 1740.96 | 1739.93 | 1740.45 | 1362.0 |
| 2013-07-31 03:40:00 | ES | Futures | 1740.45 | 1740.96 | 1740.45 | 1740.7 | 1012.0 |
| 2013-07-31 03:45:00 | ES | Futures | 1740.96 | 1741.22 | 1740.45 | 1741.22 | 577.0 |
| 2013-07-31 03:50:00 | ES | Futures | 1740.96 | 1742.26 | 1740.96 | 1742.0 | 1498.0 |
| 2013-07-31 03:55:00 | ES | Futures | 1742.0 | 1742.0 | 1741.48 | 1741.74 | 876.0 |
| 2013-07-31 04:00:00 | ES | Futures | 1741.74 | 1742.0 | 1740.7 | 1741.22 | 1989.0 |
| 2013-07-31 04:05:00 | ES | Futures | 1741.22 | 1742.0 | 1741.22 | 1741.74 | 642.0 |
> showing 50 of 13,839 rows — these rows as CSV