PREVIEW / etf_5min / 2021-01-05
file: by_date/etf_5min/2021/2021-01-05.parquet size: 1.8 MB rows: 85,351
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-01-05 04:00:00 | SPY | ETF | 369.1 | 369.3 | 368.89 | 369.2 | 4666.0 |
| 2021-01-05 04:05:00 | SPY | ETF | 369.3 | 369.32 | 369.15 | 369.15 | 5487.0 |
| 2021-01-05 04:10:00 | SPY | ETF | 369.16 | 369.46 | 369.08 | 369.44 | 11002.0 |
| 2021-01-05 04:15:00 | SPY | ETF | 369.4 | 369.6 | 369.34 | 369.6 | 9468.0 |
| 2021-01-05 04:20:00 | SPY | ETF | 369.5 | 369.51 | 369.13 | 369.17 | 4515.0 |
| 2021-01-05 04:25:00 | SPY | ETF | 369.2 | 369.2 | 369.15 | 369.15 | 5651.0 |
| 2021-01-05 04:30:00 | SPY | ETF | 369.17 | 369.17 | 369.17 | 369.17 | 718.0 |
| 2021-01-05 04:35:00 | SPY | ETF | 369.48 | 369.68 | 369.48 | 369.68 | 2826.0 |
| 2021-01-05 04:40:00 | SPY | ETF | 369.69 | 369.73 | 369.69 | 369.73 | 2059.0 |
| 2021-01-05 04:45:00 | SPY | ETF | 369.72 | 369.74 | 369.62 | 369.62 | 6940.0 |
| 2021-01-05 04:50:00 | SPY | ETF | 369.65 | 369.65 | 369.57 | 369.57 | 4431.0 |
| 2021-01-05 04:55:00 | SPY | ETF | 369.65 | 369.66 | 369.64 | 369.64 | 3140.0 |
| 2021-01-05 05:00:00 | SPY | ETF | 369.36 | 369.36 | 369.36 | 369.36 | 500.0 |
| 2021-01-05 05:05:00 | SPY | ETF | 369.56 | 369.56 | 369.56 | 369.56 | 500.0 |
| 2021-01-05 05:10:00 | SPY | ETF | 369.57 | 369.57 | 369.41 | 369.41 | 1851.0 |
| 2021-01-05 05:15:00 | SPY | ETF | 369.4 | 369.4 | 369.4 | 369.4 | 100.0 |
| 2021-01-05 05:20:00 | SPY | ETF | 369.39 | 369.39 | 369.29 | 369.29 | 749.0 |
| 2021-01-05 05:25:00 | SPY | ETF | 369.32 | 369.32 | 369.26 | 369.3 | 630.0 |
| 2021-01-05 05:30:00 | SPY | ETF | 369.3 | 369.3 | 369.26 | 369.26 | 1025.0 |
| 2021-01-05 05:35:00 | SPY | ETF | 369.39 | 369.53 | 369.39 | 369.53 | 1626.0 |
| 2021-01-05 05:40:00 | SPY | ETF | 369.59 | 369.59 | 369.59 | 369.59 | 500.0 |
| 2021-01-05 05:45:00 | SPY | ETF | 369.5 | 369.5 | 369.27 | 369.27 | 3151.0 |
| 2021-01-05 05:50:00 | SPY | ETF | 369.35 | 369.35 | 369.28 | 369.3 | 2950.0 |
| 2021-01-05 05:55:00 | SPY | ETF | 369.42 | 369.42 | 369.42 | 369.42 | 382.0 |
| 2021-01-05 06:00:00 | SPY | ETF | 369.39 | 369.4 | 369.39 | 369.4 | 1751.0 |
| 2021-01-05 06:05:00 | SPY | ETF | 369.7 | 369.72 | 369.7 | 369.72 | 4200.0 |
| 2021-01-05 06:10:00 | SPY | ETF | 369.7 | 369.72 | 369.66 | 369.71 | 7533.0 |
| 2021-01-05 06:15:00 | SPY | ETF | 369.75 | 369.79 | 369.64 | 369.7 | 18752.0 |
| 2021-01-05 06:20:00 | SPY | ETF | 369.7 | 369.78 | 369.7 | 369.74 | 20040.0 |
| 2021-01-05 06:25:00 | SPY | ETF | 369.73 | 369.88 | 369.73 | 369.88 | 38902.0 |
| 2021-01-05 06:30:00 | SPY | ETF | 369.7 | 369.7 | 369.48 | 369.59 | 5313.0 |
| 2021-01-05 06:35:00 | SPY | ETF | 369.59 | 369.6 | 369.2 | 369.2 | 2411.0 |
| 2021-01-05 06:40:00 | SPY | ETF | 369.2 | 369.23 | 369.06 | 369.13 | 5505.0 |
| 2021-01-05 06:45:00 | SPY | ETF | 369.14 | 369.14 | 369.0 | 369.07 | 4473.0 |
| 2021-01-05 06:50:00 | SPY | ETF | 369.02 | 369.12 | 369.0 | 369.0 | 26902.0 |
| 2021-01-05 06:55:00 | SPY | ETF | 368.98 | 368.98 | 368.67 | 368.92 | 33035.0 |
| 2021-01-05 07:00:00 | SPY | ETF | 368.93 | 369.05 | 368.79 | 368.84 | 8227.0 |
| 2021-01-05 07:05:00 | SPY | ETF | 368.92 | 368.92 | 368.27 | 368.33 | 34781.0 |
| 2021-01-05 07:10:00 | SPY | ETF | 368.44 | 368.59 | 368.41 | 368.54 | 21225.0 |
| 2021-01-05 07:15:00 | SPY | ETF | 368.57 | 368.61 | 368.16 | 368.16 | 68380.0 |
| 2021-01-05 07:20:00 | SPY | ETF | 368.15 | 368.18 | 367.76 | 368.18 | 39854.0 |
| 2021-01-05 07:25:00 | SPY | ETF | 368.23 | 368.29 | 367.83 | 367.89 | 22537.0 |
| 2021-01-05 07:30:00 | SPY | ETF | 367.95 | 368.0 | 367.66 | 367.8 | 22859.0 |
| 2021-01-05 07:35:00 | SPY | ETF | 367.9 | 368.2 | 367.86 | 367.95 | 17412.0 |
| 2021-01-05 07:40:00 | SPY | ETF | 367.8 | 367.98 | 367.63 | 367.98 | 17258.0 |
| 2021-01-05 07:45:00 | SPY | ETF | 367.98 | 368.15 | 367.86 | 368.13 | 10907.0 |
| 2021-01-05 07:50:00 | SPY | ETF | 368.13 | 368.56 | 368.1 | 368.49 | 34660.0 |
| 2021-01-05 07:55:00 | SPY | ETF | 368.45 | 368.5 | 368.42 | 368.46 | 10123.0 |
| 2021-01-05 08:00:00 | SPY | ETF | 368.0601 | 369.51 | 367.62 | 368.51 | 56018.0 |
| 2021-01-05 08:05:00 | SPY | ETF | 368.46 | 368.49 | 368.07 | 368.38 | 49107.0 |
> showing 50 of 85,351 rows — these rows as CSV