PREVIEW / etf_5min / 2014-12-16
file: by_date/etf_5min/2014/2014-12-16.parquet size: 1.2 MB rows: 51,645
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-16 04:00:00 | SPY | ETF | 200.08 | 200.08 | 199.9 | 199.9 | 2120.0 |
| 2014-12-16 04:05:00 | SPY | ETF | 199.7 | 199.7 | 199.7 | 199.7 | 20000.0 |
| 2014-12-16 04:10:00 | SPY | ETF | 199.9 | 199.9 | 199.9 | 199.9 | 100.0 |
| 2014-12-16 04:15:00 | SPY | ETF | 199.83 | 199.98 | 199.83 | 199.98 | 10000.0 |
| 2014-12-16 04:20:00 | SPY | ETF | 200.07 | 200.1 | 200.07 | 200.1 | 5113.0 |
| 2014-12-16 04:30:00 | SPY | ETF | 200.13 | 200.33 | 200.13 | 200.25 | 5984.0 |
| 2014-12-16 04:35:00 | SPY | ETF | 200.22 | 200.22 | 200.22 | 200.22 | 10000.0 |
| 2014-12-16 04:40:00 | SPY | ETF | 199.94 | 199.94 | 199.93 | 199.94 | 11100.0 |
| 2014-12-16 04:45:00 | SPY | ETF | 200.06 | 200.06 | 200.06 | 200.06 | 10300.0 |
| 2014-12-16 04:50:00 | SPY | ETF | 200.2 | 200.36 | 200.2 | 200.36 | 1150.0 |
| 2014-12-16 04:55:00 | SPY | ETF | 200.2 | 200.34 | 200.2 | 200.34 | 20100.0 |
| 2014-12-16 05:00:00 | SPY | ETF | 200.4 | 200.4 | 200.4 | 200.4 | 200.0 |
| 2014-12-16 05:05:00 | SPY | ETF | 200.35 | 200.35 | 200.35 | 200.35 | 200.0 |
| 2014-12-16 05:10:00 | SPY | ETF | 200.2 | 200.4 | 200.2 | 200.37 | 1900.0 |
| 2014-12-16 05:15:00 | SPY | ETF | 200.43 | 200.46 | 200.43 | 200.46 | 352.0 |
| 2014-12-16 05:20:00 | SPY | ETF | 200.4 | 200.4 | 200.25 | 200.3 | 3000.0 |
| 2014-12-16 05:25:00 | SPY | ETF | 200.35 | 200.4 | 200.35 | 200.4 | 2500.0 |
| 2014-12-16 05:30:00 | SPY | ETF | 200.35 | 200.35 | 200.35 | 200.35 | 500.0 |
| 2014-12-16 05:35:00 | SPY | ETF | 200.4 | 200.46 | 200.35 | 200.44 | 33400.0 |
| 2014-12-16 05:40:00 | SPY | ETF | 200.46 | 200.46 | 200.46 | 200.46 | 18550.0 |
| 2014-12-16 05:45:00 | SPY | ETF | 200.6 | 200.69 | 200.5 | 200.69 | 32277.0 |
| 2014-12-16 05:50:00 | SPY | ETF | 200.64 | 200.67 | 200.52 | 200.58 | 33773.0 |
| 2014-12-16 05:55:00 | SPY | ETF | 200.58 | 200.61 | 200.42 | 200.43 | 25200.0 |
| 2014-12-16 06:00:00 | SPY | ETF | 200.44 | 200.44 | 200.17 | 200.17 | 8025.0 |
| 2014-12-16 06:05:00 | SPY | ETF | 200.27 | 200.27 | 200.1 | 200.1 | 13051.0 |
| 2014-12-16 06:10:00 | SPY | ETF | 200.17 | 200.17 | 200.11 | 200.11 | 300.0 |
| 2014-12-16 06:15:00 | SPY | ETF | 200.21 | 200.36 | 200.21 | 200.26 | 15501.0 |
| 2014-12-16 06:20:00 | SPY | ETF | 200.2 | 200.26 | 200.0 | 200.02 | 10702.0 |
| 2014-12-16 06:25:00 | SPY | ETF | 200.03 | 200.08 | 199.95 | 200.08 | 12800.0 |
| 2014-12-16 06:30:00 | SPY | ETF | 200.11 | 200.16 | 199.8 | 199.8 | 17299.0 |
| 2014-12-16 06:35:00 | SPY | ETF | 199.76 | 199.91 | 199.69 | 199.72 | 56995.0 |
| 2014-12-16 06:40:00 | SPY | ETF | 199.69 | 199.72 | 199.47 | 199.47 | 49501.0 |
| 2014-12-16 06:45:00 | SPY | ETF | 199.5 | 199.6 | 199.39 | 199.51 | 61574.0 |
| 2014-12-16 06:50:00 | SPY | ETF | 199.53 | 199.54 | 199.22 | 199.37 | 47525.0 |
| 2014-12-16 06:55:00 | SPY | ETF | 199.28 | 199.28 | 198.84 | 198.89 | 45435.0 |
| 2014-12-16 07:00:00 | SPY | ETF | 198.82 | 198.85 | 198.53 | 198.85 | 113037.0 |
| 2014-12-16 07:05:00 | SPY | ETF | 198.81 | 198.88 | 198.52 | 198.88 | 61311.0 |
| 2014-12-16 07:10:00 | SPY | ETF | 198.77 | 198.85 | 198.54 | 198.72 | 123750.0 |
| 2014-12-16 07:15:00 | SPY | ETF | 198.75 | 198.78 | 198.29 | 198.31 | 102318.0 |
| 2014-12-16 07:20:00 | SPY | ETF | 198.25 | 198.38 | 197.74 | 197.74 | 342235.0 |
| 2014-12-16 07:25:00 | SPY | ETF | 197.7 | 198.2 | 197.49 | 198.2 | 410080.0 |
| 2014-12-16 07:30:00 | SPY | ETF | 198.17 | 198.36 | 198.03 | 198.08 | 202677.0 |
| 2014-12-16 07:35:00 | SPY | ETF | 198.15 | 198.55 | 198.15 | 198.55 | 246226.0 |
| 2014-12-16 07:40:00 | SPY | ETF | 198.55 | 198.6 | 198.4 | 198.48 | 248790.0 |
| 2014-12-16 07:45:00 | SPY | ETF | 198.52 | 198.6 | 198.43 | 198.5 | 214279.0 |
| 2014-12-16 07:50:00 | SPY | ETF | 198.51 | 198.51 | 198.1 | 198.24 | 258285.0 |
| 2014-12-16 07:55:00 | SPY | ETF | 198.27 | 198.4 | 198.05 | 198.12 | 186725.0 |
| 2014-12-16 08:00:00 | SPY | ETF | 198.12 | 200.35 | 197.78 | 198.3 | 336315.0 |
| 2014-12-16 08:05:00 | SPY | ETF | 197.85 | 198.46 | 197.85 | 198.46 | 194371.0 |
| 2014-12-16 08:10:00 | SPY | ETF | 198.48 | 198.62 | 198.38 | 198.56 | 181907.0 |
> showing 50 of 51,645 rows — these rows as CSV