PREVIEW / etf_5min / 2019-03-14
file: by_date/etf_5min/2019/2019-03-14.parquet size: 1.3 MB rows: 58,929
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-03-14 04:00:00 | SPY | ETF | 281.59 | 281.7 | 281.59 | 281.7 | 1010.0 |
| 2019-03-14 04:05:00 | SPY | ETF | 281.85 | 281.96 | 281.85 | 281.96 | 3003.0 |
| 2019-03-14 04:10:00 | SPY | ETF | 281.88 | 281.88 | 281.87 | 281.87 | 800.0 |
| 2019-03-14 04:15:00 | SPY | ETF | 281.92 | 281.92 | 281.92 | 281.92 | 100.0 |
| 2019-03-14 04:25:00 | SPY | ETF | 281.95 | 282.01 | 281.95 | 282.01 | 441.0 |
| 2019-03-14 04:35:00 | SPY | ETF | 281.94 | 281.94 | 281.94 | 281.94 | 100.0 |
| 2019-03-14 04:40:00 | SPY | ETF | 281.97 | 282.01 | 281.97 | 282.01 | 203.0 |
| 2019-03-14 04:45:00 | SPY | ETF | 282.02 | 282.04 | 282.02 | 282.04 | 3000.0 |
| 2019-03-14 04:50:00 | SPY | ETF | 282.08 | 282.14 | 282.08 | 282.14 | 2500.0 |
| 2019-03-14 04:55:00 | SPY | ETF | 282.18 | 282.18 | 282.18 | 282.18 | 1000.0 |
| 2019-03-14 05:00:00 | SPY | ETF | 282.22 | 282.22 | 282.2 | 282.2 | 600.0 |
| 2019-03-14 05:05:00 | SPY | ETF | 282.23 | 282.23 | 282.11 | 282.11 | 1150.0 |
| 2019-03-14 05:15:00 | SPY | ETF | 282.17 | 282.17 | 282.17 | 282.17 | 400.0 |
| 2019-03-14 05:20:00 | SPY | ETF | 282.09 | 282.1 | 282.06 | 282.1 | 1300.0 |
| 2019-03-14 05:25:00 | SPY | ETF | 282.08 | 282.1 | 282.07 | 282.07 | 1714.0 |
| 2019-03-14 05:30:00 | SPY | ETF | 282.04 | 282.06 | 282.03 | 282.06 | 4000.0 |
| 2019-03-14 05:35:00 | SPY | ETF | 282.07 | 282.18 | 282.07 | 282.18 | 3138.0 |
| 2019-03-14 05:40:00 | SPY | ETF | 282.13 | 282.14 | 282.13 | 282.14 | 1111.0 |
| 2019-03-14 05:50:00 | SPY | ETF | 282.18 | 282.23 | 282.18 | 282.23 | 1805.0 |
| 2019-03-14 05:55:00 | SPY | ETF | 282.28 | 282.3 | 282.21 | 282.21 | 4200.0 |
| 2019-03-14 06:00:00 | SPY | ETF | 282.2 | 282.2 | 281.58 | 281.69 | 20349.0 |
| 2019-03-14 06:05:00 | SPY | ETF | 281.63 | 281.69 | 281.54 | 281.69 | 14546.0 |
| 2019-03-14 06:10:00 | SPY | ETF | 281.66 | 281.89 | 281.66 | 281.89 | 4912.0 |
| 2019-03-14 06:15:00 | SPY | ETF | 281.89 | 281.89 | 281.81 | 281.81 | 497.0 |
| 2019-03-14 06:20:00 | SPY | ETF | 281.78 | 281.78 | 281.62 | 281.62 | 2475.0 |
| 2019-03-14 06:25:00 | SPY | ETF | 281.61 | 281.61 | 281.5 | 281.54 | 1966.0 |
| 2019-03-14 06:30:00 | SPY | ETF | 281.5 | 281.57 | 281.5 | 281.53 | 5650.0 |
| 2019-03-14 06:35:00 | SPY | ETF | 281.5 | 281.54 | 281.42 | 281.42 | 8701.0 |
| 2019-03-14 06:40:00 | SPY | ETF | 281.42 | 281.5 | 281.35 | 281.5 | 8792.0 |
| 2019-03-14 06:45:00 | SPY | ETF | 281.5 | 281.5 | 281.2 | 281.2 | 93292.0 |
| 2019-03-14 06:50:00 | SPY | ETF | 281.22 | 281.22 | 280.89 | 281.05 | 86749.0 |
| 2019-03-14 06:55:00 | SPY | ETF | 281.03 | 281.18 | 281.02 | 281.18 | 2853.0 |
| 2019-03-14 07:00:00 | SPY | ETF | 281.12 | 281.17 | 281.12 | 281.15 | 17135.0 |
| 2019-03-14 07:05:00 | SPY | ETF | 281.14 | 281.3 | 281.14 | 281.3 | 6151.0 |
| 2019-03-14 07:10:00 | SPY | ETF | 281.28 | 281.28 | 281.19 | 281.26 | 12463.0 |
| 2019-03-14 07:15:00 | SPY | ETF | 281.32 | 281.41 | 281.32 | 281.41 | 10409.0 |
| 2019-03-14 07:20:00 | SPY | ETF | 281.38 | 281.39 | 281.34 | 281.34 | 33800.0 |
| 2019-03-14 07:25:00 | SPY | ETF | 281.36 | 281.4 | 281.36 | 281.38 | 8415.0 |
| 2019-03-14 07:30:00 | SPY | ETF | 281.38 | 281.38 | 281.31 | 281.35 | 18005.0 |
| 2019-03-14 07:35:00 | SPY | ETF | 281.35 | 281.45 | 281.32 | 281.44 | 19445.0 |
| 2019-03-14 07:40:00 | SPY | ETF | 281.42 | 281.43 | 281.4 | 281.42 | 7425.0 |
| 2019-03-14 07:45:00 | SPY | ETF | 281.42 | 281.43 | 281.4 | 281.43 | 1166.0 |
| 2019-03-14 07:50:00 | SPY | ETF | 281.41 | 281.44 | 281.39 | 281.42 | 20659.0 |
| 2019-03-14 07:55:00 | SPY | ETF | 281.45 | 281.56 | 281.4 | 281.56 | 24602.0 |
| 2019-03-14 08:00:00 | SPY | ETF | 281.58 | 281.75 | 281.15 | 281.55 | 93078.0 |
| 2019-03-14 08:05:00 | SPY | ETF | 281.57 | 281.65 | 281.56 | 281.64 | 23583.0 |
| 2019-03-14 08:10:00 | SPY | ETF | 281.64 | 281.72 | 281.63 | 281.63 | 56890.0 |
| 2019-03-14 08:15:00 | SPY | ETF | 281.61 | 281.62 | 281.55 | 281.55 | 7855.0 |
| 2019-03-14 08:20:00 | SPY | ETF | 281.57 | 281.65 | 281.52 | 281.65 | 17841.0 |
| 2019-03-14 08:25:00 | SPY | ETF | 281.65 | 281.8 | 281.65 | 281.8 | 22802.0 |
> showing 50 of 58,929 rows — these rows as CSV