PREVIEW / etf_5min / 2016-03-16
file: by_date/etf_5min/2016/2016-03-16.parquet size: 1.1 MB rows: 48,964
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-16 04:00:00 | SPY | ETF | 202.27 | 202.34 | 202.27 | 202.34 | 450.0 |
| 2016-03-16 04:05:00 | SPY | ETF | 202.42 | 202.49 | 202.37 | 202.39 | 5065.0 |
| 2016-03-16 04:10:00 | SPY | ETF | 202.44 | 202.52 | 202.44 | 202.49 | 2220.0 |
| 2016-03-16 04:15:00 | SPY | ETF | 202.52 | 202.52 | 202.52 | 202.52 | 300.0 |
| 2016-03-16 04:35:00 | SPY | ETF | 202.49 | 202.49 | 202.49 | 202.49 | 302.0 |
| 2016-03-16 04:50:00 | SPY | ETF | 202.42 | 202.42 | 202.42 | 202.42 | 400.0 |
| 2016-03-16 04:55:00 | SPY | ETF | 202.51 | 202.51 | 202.51 | 202.51 | 200.0 |
| 2016-03-16 05:00:00 | SPY | ETF | 202.49 | 202.49 | 202.47 | 202.47 | 2414.0 |
| 2016-03-16 05:05:00 | SPY | ETF | 202.45 | 202.45 | 202.45 | 202.45 | 300.0 |
| 2016-03-16 05:20:00 | SPY | ETF | 202.46 | 202.48 | 202.46 | 202.48 | 402.0 |
| 2016-03-16 05:30:00 | SPY | ETF | 202.42 | 202.44 | 202.42 | 202.44 | 1207.0 |
| 2016-03-16 05:55:00 | SPY | ETF | 202.43 | 202.43 | 202.43 | 202.43 | 103.0 |
| 2016-03-16 06:00:00 | SPY | ETF | 202.46 | 202.48 | 202.4 | 202.44 | 7442.0 |
| 2016-03-16 06:05:00 | SPY | ETF | 202.41 | 202.41 | 202.32 | 202.32 | 2858.0 |
| 2016-03-16 06:10:00 | SPY | ETF | 202.32 | 202.32 | 202.25 | 202.31 | 588.0 |
| 2016-03-16 06:15:00 | SPY | ETF | 202.21 | 202.27 | 202.21 | 202.24 | 5613.0 |
| 2016-03-16 06:20:00 | SPY | ETF | 202.24 | 202.26 | 202.24 | 202.26 | 3004.0 |
| 2016-03-16 06:25:00 | SPY | ETF | 202.29 | 202.31 | 202.29 | 202.29 | 2966.0 |
| 2016-03-16 06:30:00 | SPY | ETF | 202.31 | 202.33 | 202.31 | 202.33 | 238.0 |
| 2016-03-16 06:35:00 | SPY | ETF | 202.3 | 202.33 | 202.3 | 202.33 | 6700.0 |
| 2016-03-16 06:45:00 | SPY | ETF | 202.32 | 202.33 | 202.24 | 202.24 | 701.0 |
| 2016-03-16 06:50:00 | SPY | ETF | 202.2 | 202.23 | 202.18 | 202.18 | 1901.0 |
| 2016-03-16 06:55:00 | SPY | ETF | 202.2 | 202.23 | 202.2 | 202.23 | 765.0 |
| 2016-03-16 07:00:00 | SPY | ETF | 202.15 | 202.16 | 202.15 | 202.16 | 2903.0 |
| 2016-03-16 07:05:00 | SPY | ETF | 202.13 | 202.16 | 202.13 | 202.16 | 1261.0 |
| 2016-03-16 07:10:00 | SPY | ETF | 202.16 | 202.18 | 202.15 | 202.17 | 1056.0 |
| 2016-03-16 07:15:00 | SPY | ETF | 202.17 | 202.21 | 202.15 | 202.2 | 16057.0 |
| 2016-03-16 07:20:00 | SPY | ETF | 202.2 | 202.23 | 202.2 | 202.21 | 16662.0 |
| 2016-03-16 07:25:00 | SPY | ETF | 202.22 | 202.22 | 202.1 | 202.16 | 23402.0 |
| 2016-03-16 07:30:00 | SPY | ETF | 202.13 | 202.13 | 202.02 | 202.12 | 13843.0 |
| 2016-03-16 07:35:00 | SPY | ETF | 202.12 | 202.14 | 202.1 | 202.14 | 5856.0 |
| 2016-03-16 07:40:00 | SPY | ETF | 202.14 | 202.14 | 202.06 | 202.06 | 1180.0 |
| 2016-03-16 07:45:00 | SPY | ETF | 202.02 | 202.07 | 202.02 | 202.02 | 13881.0 |
| 2016-03-16 07:50:00 | SPY | ETF | 202.02 | 202.03 | 202.0 | 202.0 | 3090.0 |
| 2016-03-16 07:55:00 | SPY | ETF | 202.02 | 202.04 | 201.98 | 202.04 | 13125.0 |
| 2016-03-16 08:00:00 | SPY | ETF | 202.05 | 202.15 | 201.98 | 202.15 | 71159.0 |
| 2016-03-16 08:05:00 | SPY | ETF | 202.07 | 202.15 | 202.05 | 202.13 | 121919.0 |
| 2016-03-16 08:10:00 | SPY | ETF | 202.13 | 202.15 | 202.11 | 202.12 | 19568.0 |
| 2016-03-16 08:15:00 | SPY | ETF | 202.13 | 202.13 | 201.97 | 201.99 | 49356.0 |
| 2016-03-16 08:20:00 | SPY | ETF | 201.99 | 202.02 | 201.98 | 201.98 | 18613.0 |
| 2016-03-16 08:25:00 | SPY | ETF | 201.98 | 202.02 | 201.97 | 201.99 | 33939.0 |
| 2016-03-16 08:30:00 | SPY | ETF | 201.99 | 202.1 | 201.82 | 201.88 | 220706.0 |
| 2016-03-16 08:35:00 | SPY | ETF | 201.87 | 201.93 | 201.78 | 201.8 | 31186.0 |
| 2016-03-16 08:40:00 | SPY | ETF | 201.81 | 201.81 | 201.6 | 201.65 | 152196.0 |
| 2016-03-16 08:45:00 | SPY | ETF | 201.67 | 201.71 | 201.61 | 201.66 | 28261.0 |
| 2016-03-16 08:50:00 | SPY | ETF | 201.65 | 201.66 | 201.41 | 201.52 | 100057.0 |
| 2016-03-16 08:55:00 | SPY | ETF | 201.52 | 201.54 | 201.43 | 201.47 | 39887.0 |
| 2016-03-16 09:00:00 | SPY | ETF | 201.47 | 201.47 | 201.28 | 201.4 | 111503.0 |
| 2016-03-16 09:05:00 | SPY | ETF | 201.41 | 201.52 | 201.41 | 201.52 | 89542.0 |
| 2016-03-16 09:10:00 | SPY | ETF | 201.48 | 201.54 | 201.45 | 201.53 | 63784.0 |
> showing 50 of 48,964 rows — these rows as CSV