PREVIEW / etf_5min / 2020-03-11
file: by_date/etf_5min/2020/2020-03-11.parquet size: 1.9 MB rows: 85,409
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 |
|---|---|---|---|---|---|---|---|
| 2020-03-11 04:00:00 | SPY | ETF | 281.3 | 281.65 | 280.6 | 280.68 | 31173.0 |
| 2020-03-11 04:05:00 | SPY | ETF | 280.7 | 282.2 | 280.7 | 281.76 | 22654.0 |
| 2020-03-11 04:10:00 | SPY | ETF | 281.5 | 282.27 | 281.5 | 281.8 | 5686.0 |
| 2020-03-11 04:15:00 | SPY | ETF | 281.94 | 281.95 | 281.49 | 281.5 | 8845.0 |
| 2020-03-11 04:20:00 | SPY | ETF | 281.62 | 282.05 | 280.34 | 280.34 | 14708.0 |
| 2020-03-11 04:25:00 | SPY | ETF | 280.27 | 280.27 | 279.56 | 279.76 | 15380.0 |
| 2020-03-11 04:30:00 | SPY | ETF | 279.5 | 281.4 | 279.5 | 281.02 | 15112.0 |
| 2020-03-11 04:35:00 | SPY | ETF | 280.99 | 281.36 | 280.2 | 280.96 | 5866.0 |
| 2020-03-11 04:40:00 | SPY | ETF | 280.84 | 281.63 | 280.78 | 281.63 | 4362.0 |
| 2020-03-11 04:45:00 | SPY | ETF | 281.79 | 283.65 | 281.79 | 283.35 | 18619.0 |
| 2020-03-11 04:50:00 | SPY | ETF | 283.08 | 283.73 | 282.97 | 283.35 | 10623.0 |
| 2020-03-11 04:55:00 | SPY | ETF | 283.2 | 284.06 | 283.05 | 283.05 | 8734.0 |
| 2020-03-11 05:00:00 | SPY | ETF | 283.18 | 283.18 | 282.7 | 282.75 | 3083.0 |
| 2020-03-11 05:05:00 | SPY | ETF | 282.68 | 282.7 | 282.11 | 282.33 | 5610.0 |
| 2020-03-11 05:10:00 | SPY | ETF | 282.35 | 282.79 | 281.92 | 282.44 | 6852.0 |
| 2020-03-11 05:15:00 | SPY | ETF | 282.2 | 282.2 | 282.05 | 282.18 | 2420.0 |
| 2020-03-11 05:20:00 | SPY | ETF | 282.27 | 282.4 | 281.76 | 281.89 | 4718.0 |
| 2020-03-11 05:25:00 | SPY | ETF | 281.86 | 282.94 | 281.86 | 282.94 | 5224.0 |
| 2020-03-11 05:30:00 | SPY | ETF | 282.77 | 282.99 | 281.88 | 281.88 | 11619.0 |
| 2020-03-11 05:35:00 | SPY | ETF | 281.94 | 281.97 | 281.0 | 281.33 | 22798.0 |
| 2020-03-11 05:40:00 | SPY | ETF | 281.46 | 281.52 | 281.18 | 281.44 | 4700.0 |
| 2020-03-11 05:45:00 | SPY | ETF | 281.4 | 281.48 | 280.93 | 280.93 | 679.0 |
| 2020-03-11 05:50:00 | SPY | ETF | 280.85 | 281.18 | 280.68 | 281.18 | 5790.0 |
| 2020-03-11 05:55:00 | SPY | ETF | 281.23 | 281.79 | 280.95 | 281.79 | 4363.0 |
| 2020-03-11 06:00:00 | SPY | ETF | 281.7 | 281.7 | 281.26 | 281.69 | 3680.0 |
| 2020-03-11 06:05:00 | SPY | ETF | 281.57 | 281.57 | 281.31 | 281.31 | 3861.0 |
| 2020-03-11 06:10:00 | SPY | ETF | 281.17 | 281.71 | 281.17 | 281.51 | 6132.0 |
| 2020-03-11 06:15:00 | SPY | ETF | 281.56 | 281.81 | 281.51 | 281.51 | 17648.0 |
| 2020-03-11 06:20:00 | SPY | ETF | 281.51 | 281.51 | 281.12 | 281.15 | 33982.0 |
| 2020-03-11 06:25:00 | SPY | ETF | 281.31 | 281.31 | 279.81 | 280.27 | 33708.0 |
| 2020-03-11 06:30:00 | SPY | ETF | 280.46 | 282.51 | 280.22 | 281.83 | 22739.0 |
| 2020-03-11 06:35:00 | SPY | ETF | 281.79 | 281.79 | 280.74 | 280.82 | 18193.0 |
| 2020-03-11 06:40:00 | SPY | ETF | 280.9 | 281.35 | 280.83 | 281.32 | 18132.0 |
| 2020-03-11 06:45:00 | SPY | ETF | 281.55 | 282.25 | 281.55 | 281.87 | 43085.0 |
| 2020-03-11 06:50:00 | SPY | ETF | 281.6 | 282.29 | 281.6 | 281.96 | 29256.0 |
| 2020-03-11 06:55:00 | SPY | ETF | 282.09 | 282.09 | 281.37 | 281.38 | 40631.0 |
| 2020-03-11 07:00:00 | SPY | ETF | 281.49 | 281.74 | 281.11 | 281.67 | 59758.0 |
| 2020-03-11 07:05:00 | SPY | ETF | 281.73 | 281.73 | 280.7 | 280.77 | 62282.0 |
| 2020-03-11 07:10:00 | SPY | ETF | 280.7 | 281.02 | 280.62 | 280.76 | 90714.0 |
| 2020-03-11 07:15:00 | SPY | ETF | 280.859 | 281.18 | 280.48 | 280.5 | 92175.0 |
| 2020-03-11 07:20:00 | SPY | ETF | 280.46 | 280.95 | 280.29 | 280.48 | 70621.0 |
| 2020-03-11 07:25:00 | SPY | ETF | 280.38 | 280.38 | 279.79 | 279.92 | 130567.0 |
| 2020-03-11 07:30:00 | SPY | ETF | 279.85 | 280.31 | 279.7 | 280.29 | 165931.0 |
| 2020-03-11 07:35:00 | SPY | ETF | 280.36 | 280.37 | 279.58 | 280.03 | 48426.0 |
| 2020-03-11 07:40:00 | SPY | ETF | 279.9 | 279.9 | 278.96 | 279.15 | 153985.0 |
| 2020-03-11 07:45:00 | SPY | ETF | 279.1 | 279.35 | 278.58 | 279.27 | 107471.0 |
| 2020-03-11 07:50:00 | SPY | ETF | 279.18 | 279.44 | 279.07 | 279.19 | 49173.0 |
| 2020-03-11 07:55:00 | SPY | ETF | 279.19 | 280.0 | 279.19 | 279.85 | 77826.0 |
| 2020-03-11 08:00:00 | SPY | ETF | 281.35 | 281.66 | 278.67 | 279.93 | 190374.0 |
| 2020-03-11 08:05:00 | SPY | ETF | 279.95 | 280.92 | 279.23 | 279.5 | 43718.0 |
> showing 50 of 85,409 rows — these rows as CSV