PREVIEW / etf_5min / 2021-03-22
file: by_date/etf_5min/2021/2021-03-22.parquet size: 1.8 MB rows: 84,321
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-22 04:00:00 | SPY | ETF | 389.75 | 390.4 | 388.44 | 388.52 | 43856.0 |
| 2021-03-22 04:05:00 | SPY | ETF | 388.35 | 388.42 | 388.34 | 388.42 | 2800.0 |
| 2021-03-22 04:10:00 | SPY | ETF | 388.47 | 389.19 | 388.45 | 389.19 | 6385.0 |
| 2021-03-22 04:15:00 | SPY | ETF | 389.25 | 389.28 | 389.25 | 389.28 | 791.0 |
| 2021-03-22 04:20:00 | SPY | ETF | 389.36 | 389.43 | 389.32 | 389.36 | 1570.0 |
| 2021-03-22 04:25:00 | SPY | ETF | 389.33 | 389.38 | 389.21 | 389.35 | 1100.0 |
| 2021-03-22 04:30:00 | SPY | ETF | 389.42 | 389.49 | 389.38 | 389.43 | 3700.0 |
| 2021-03-22 04:35:00 | SPY | ETF | 389.55 | 389.61 | 389.5 | 389.51 | 2500.0 |
| 2021-03-22 04:40:00 | SPY | ETF | 389.48 | 389.5 | 389.38 | 389.38 | 2336.0 |
| 2021-03-22 04:45:00 | SPY | ETF | 389.48 | 389.5 | 389.27 | 389.27 | 1400.0 |
| 2021-03-22 04:50:00 | SPY | ETF | 389.32 | 389.4 | 389.17 | 389.38 | 1750.0 |
| 2021-03-22 04:55:00 | SPY | ETF | 389.35 | 389.48 | 389.27 | 389.28 | 3600.0 |
| 2021-03-22 05:00:00 | SPY | ETF | 389.4 | 389.47 | 389.4 | 389.45 | 1162.0 |
| 2021-03-22 05:05:00 | SPY | ETF | 389.46 | 389.46 | 389.38 | 389.38 | 300.0 |
| 2021-03-22 05:10:00 | SPY | ETF | 389.19 | 389.19 | 389.19 | 389.19 | 987.0 |
| 2021-03-22 05:15:00 | SPY | ETF | 389.21 | 389.26 | 389.14 | 389.14 | 1000.0 |
| 2021-03-22 05:20:00 | SPY | ETF | 388.95 | 389.3 | 388.9 | 389.29 | 2100.0 |
| 2021-03-22 05:25:00 | SPY | ETF | 389.28 | 389.28 | 389.25 | 389.25 | 1800.0 |
| 2021-03-22 05:30:00 | SPY | ETF | 389.47 | 389.48 | 389.36 | 389.36 | 1600.0 |
| 2021-03-22 05:35:00 | SPY | ETF | 389.47 | 389.47 | 389.31 | 389.31 | 560.0 |
| 2021-03-22 05:40:00 | SPY | ETF | 389.26 | 389.42 | 389.26 | 389.42 | 3980.0 |
| 2021-03-22 05:45:00 | SPY | ETF | 389.42 | 389.57 | 389.42 | 389.57 | 50190.0 |
| 2021-03-22 05:50:00 | SPY | ETF | 389.47 | 389.47 | 389.37 | 389.37 | 2750.0 |
| 2021-03-22 05:55:00 | SPY | ETF | 389.39 | 389.39 | 389.37 | 389.37 | 600.0 |
| 2021-03-22 06:00:00 | SPY | ETF | 389.48 | 389.49 | 389.48 | 389.49 | 1700.0 |
| 2021-03-22 06:10:00 | SPY | ETF | 389.65 | 389.65 | 389.65 | 389.65 | 200.0 |
| 2021-03-22 06:15:00 | SPY | ETF | 389.78 | 389.82 | 389.78 | 389.81 | 700.0 |
| 2021-03-22 06:20:00 | SPY | ETF | 389.79 | 389.79 | 389.79 | 389.79 | 110.0 |
| 2021-03-22 06:25:00 | SPY | ETF | 389.83 | 389.83 | 389.83 | 389.83 | 495.0 |
| 2021-03-22 06:30:00 | SPY | ETF | 389.82 | 389.84 | 389.77 | 389.77 | 1344.0 |
| 2021-03-22 06:35:00 | SPY | ETF | 389.81 | 389.81 | 389.75 | 389.79 | 1610.0 |
| 2021-03-22 06:40:00 | SPY | ETF | 389.76 | 389.79 | 389.71 | 389.72 | 1799.0 |
| 2021-03-22 06:45:00 | SPY | ETF | 389.79 | 389.82 | 389.79 | 389.79 | 1690.0 |
| 2021-03-22 06:50:00 | SPY | ETF | 389.81 | 389.84 | 389.81 | 389.81 | 500.0 |
| 2021-03-22 06:55:00 | SPY | ETF | 389.83 | 389.86 | 389.83 | 389.85 | 2700.0 |
| 2021-03-22 07:00:00 | SPY | ETF | 389.76 | 390.21 | 389.76 | 390.21 | 32868.0 |
| 2021-03-22 07:05:00 | SPY | ETF | 390.21 | 390.29 | 390.1 | 390.12 | 3654.0 |
| 2021-03-22 07:10:00 | SPY | ETF | 390.12 | 390.25 | 390.08 | 390.19 | 39372.0 |
| 2021-03-22 07:15:00 | SPY | ETF | 390.19 | 390.4 | 390.16 | 390.338 | 37790.0 |
| 2021-03-22 07:20:00 | SPY | ETF | 390.3 | 390.45 | 390.3 | 390.43 | 30184.0 |
| 2021-03-22 07:25:00 | SPY | ETF | 390.398 | 390.66 | 390.398 | 390.57 | 21988.0 |
| 2021-03-22 07:30:00 | SPY | ETF | 390.6 | 390.6 | 390.51 | 390.56 | 18970.0 |
| 2021-03-22 07:35:00 | SPY | ETF | 390.56 | 390.71 | 390.54 | 390.7 | 11742.0 |
| 2021-03-22 07:40:00 | SPY | ETF | 390.7 | 390.72 | 390.4 | 390.47 | 15092.0 |
| 2021-03-22 07:45:00 | SPY | ETF | 390.47 | 390.6 | 390.45 | 390.57 | 10899.0 |
| 2021-03-22 07:50:00 | SPY | ETF | 390.56 | 390.56 | 390.51 | 390.548 | 3670.0 |
| 2021-03-22 07:55:00 | SPY | ETF | 390.57 | 390.6 | 390.51 | 390.53 | 2534.0 |
| 2021-03-22 08:00:00 | SPY | ETF | 389.96 | 390.7 | 388.48 | 390.285 | 37222.0 |
| 2021-03-22 08:05:00 | SPY | ETF | 390.32 | 390.38 | 390.24 | 390.31 | 11138.0 |
| 2021-03-22 08:10:00 | SPY | ETF | 390.3 | 390.34 | 390.25 | 390.34 | 6506.0 |
> showing 50 of 84,321 rows — these rows as CSV