PREVIEW / etf_5min / 2019-05-13
file: by_date/etf_5min/2019/2019-05-13.parquet size: 1.6 MB rows: 67,331
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-13 04:00:00 | SPY | ETF | 284.34 | 284.49 | 284.19 | 284.26 | 7965.0 |
| 2019-05-13 04:05:00 | SPY | ETF | 284.2 | 284.21 | 284.11 | 284.16 | 4999.0 |
| 2019-05-13 04:10:00 | SPY | ETF | 284.15 | 284.36 | 284.13 | 284.28 | 8198.0 |
| 2019-05-13 04:15:00 | SPY | ETF | 284.46 | 284.54 | 284.46 | 284.46 | 4528.0 |
| 2019-05-13 04:20:00 | SPY | ETF | 284.48 | 284.62 | 284.48 | 284.6 | 8656.0 |
| 2019-05-13 04:25:00 | SPY | ETF | 284.61 | 284.73 | 284.56 | 284.7 | 2019.0 |
| 2019-05-13 04:30:00 | SPY | ETF | 284.71 | 284.81 | 284.71 | 284.81 | 23793.0 |
| 2019-05-13 04:35:00 | SPY | ETF | 284.76 | 284.86 | 284.74 | 284.86 | 3304.0 |
| 2019-05-13 04:40:00 | SPY | ETF | 284.9 | 284.96 | 284.83 | 284.88 | 8934.0 |
| 2019-05-13 04:45:00 | SPY | ETF | 284.83 | 284.83 | 284.78 | 284.83 | 1077.0 |
| 2019-05-13 04:50:00 | SPY | ETF | 284.74 | 284.86 | 284.73 | 284.78 | 960.0 |
| 2019-05-13 04:55:00 | SPY | ETF | 284.76 | 284.78 | 284.58 | 284.66 | 4792.0 |
| 2019-05-13 05:00:00 | SPY | ETF | 284.71 | 284.95 | 284.71 | 284.95 | 3843.0 |
| 2019-05-13 05:05:00 | SPY | ETF | 285.0 | 285.03 | 284.96 | 284.96 | 3109.0 |
| 2019-05-13 05:10:00 | SPY | ETF | 285.01 | 285.01 | 284.92 | 284.95 | 2779.0 |
| 2019-05-13 05:15:00 | SPY | ETF | 285.01 | 285.01 | 284.82 | 284.82 | 2450.0 |
| 2019-05-13 05:20:00 | SPY | ETF | 284.91 | 284.91 | 284.88 | 284.88 | 719.0 |
| 2019-05-13 05:25:00 | SPY | ETF | 284.84 | 284.84 | 284.76 | 284.76 | 1596.0 |
| 2019-05-13 05:35:00 | SPY | ETF | 284.85 | 284.9 | 284.84 | 284.9 | 2600.0 |
| 2019-05-13 05:40:00 | SPY | ETF | 284.9 | 285.0 | 284.9 | 284.99 | 13701.0 |
| 2019-05-13 05:45:00 | SPY | ETF | 284.99 | 285.09 | 284.99 | 285.09 | 16749.0 |
| 2019-05-13 05:50:00 | SPY | ETF | 285.07 | 285.07 | 284.87 | 285.06 | 3481.0 |
| 2019-05-13 05:55:00 | SPY | ETF | 285.07 | 285.1 | 285.05 | 285.1 | 2842.0 |
| 2019-05-13 06:05:00 | SPY | ETF | 285.11 | 285.11 | 285.05 | 285.07 | 1106.0 |
| 2019-05-13 06:15:00 | SPY | ETF | 285.09 | 285.1 | 284.95 | 284.95 | 41726.0 |
| 2019-05-13 06:20:00 | SPY | ETF | 284.94 | 284.95 | 284.87 | 284.87 | 3185.0 |
| 2019-05-13 06:25:00 | SPY | ETF | 284.88 | 284.88 | 284.72 | 284.81 | 23579.0 |
| 2019-05-13 06:30:00 | SPY | ETF | 284.83 | 284.92 | 284.68 | 284.68 | 14591.0 |
| 2019-05-13 06:35:00 | SPY | ETF | 284.72 | 284.85 | 284.72 | 284.8 | 36270.0 |
| 2019-05-13 06:40:00 | SPY | ETF | 284.8 | 285.02 | 284.57 | 284.62 | 55289.0 |
| 2019-05-13 06:45:00 | SPY | ETF | 284.6 | 284.78 | 284.6 | 284.73 | 30442.0 |
| 2019-05-13 06:50:00 | SPY | ETF | 284.76 | 284.87 | 284.73 | 284.73 | 20801.0 |
| 2019-05-13 06:55:00 | SPY | ETF | 284.83 | 284.91 | 284.83 | 284.89 | 3915.0 |
| 2019-05-13 07:00:00 | SPY | ETF | 284.91 | 284.95 | 284.78 | 284.79 | 80452.0 |
| 2019-05-13 07:05:00 | SPY | ETF | 284.82 | 284.82 | 284.65 | 284.72 | 46679.0 |
| 2019-05-13 07:10:00 | SPY | ETF | 284.7 | 284.71 | 284.61 | 284.61 | 24804.0 |
| 2019-05-13 07:15:00 | SPY | ETF | 284.61 | 284.61 | 284.43 | 284.46 | 89779.0 |
| 2019-05-13 07:20:00 | SPY | ETF | 284.52 | 284.52 | 284.45 | 284.45 | 31700.0 |
| 2019-05-13 07:25:00 | SPY | ETF | 284.47 | 284.55 | 284.47 | 284.55 | 50782.0 |
| 2019-05-13 07:30:00 | SPY | ETF | 284.55 | 284.67 | 284.5 | 284.59 | 71536.0 |
| 2019-05-13 07:35:00 | SPY | ETF | 284.61 | 284.74 | 284.5 | 284.71 | 51110.0 |
| 2019-05-13 07:40:00 | SPY | ETF | 284.7 | 284.75 | 284.6 | 284.6 | 7066.0 |
| 2019-05-13 07:45:00 | SPY | ETF | 284.6 | 284.6 | 284.26 | 284.26 | 137308.0 |
| 2019-05-13 07:50:00 | SPY | ETF | 284.33 | 284.35 | 284.06 | 284.2 | 18200.0 |
| 2019-05-13 07:55:00 | SPY | ETF | 284.18 | 284.24 | 284.11 | 284.11 | 88360.0 |
| 2019-05-13 08:00:00 | SPY | ETF | 284.14 | 285.53 | 284.11 | 284.18 | 144452.0 |
| 2019-05-13 08:05:00 | SPY | ETF | 284.18 | 284.23 | 283.2 | 283.46 | 628597.0 |
| 2019-05-13 08:10:00 | SPY | ETF | 283.45 | 283.59 | 282.9 | 282.95 | 428016.0 |
| 2019-05-13 08:15:00 | SPY | ETF | 282.94 | 283.09 | 282.54 | 282.65 | 437365.0 |
| 2019-05-13 08:20:00 | SPY | ETF | 282.63 | 282.97 | 282.63 | 282.97 | 208573.0 |
> showing 50 of 67,331 rows — these rows as CSV