PREVIEW / etf_5min / 2021-07-08
file: by_date/etf_5min/2021/2021-07-08.parquet size: 1.8 MB rows: 86,014
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-07-08 04:00:00 | SPY | ETF | 431.09 | 433.02 | 430.25 | 430.28 | 22845.0 |
| 2021-07-08 04:05:00 | SPY | ETF | 430.38 | 430.7 | 430.15 | 430.54 | 6900.0 |
| 2021-07-08 04:10:00 | SPY | ETF | 430.57 | 430.81 | 430.38 | 430.76 | 4700.0 |
| 2021-07-08 04:15:00 | SPY | ETF | 430.85 | 431.2 | 430.77 | 431.2 | 5900.0 |
| 2021-07-08 04:20:00 | SPY | ETF | 431.04 | 431.04 | 430.57 | 430.58 | 6300.0 |
| 2021-07-08 04:25:00 | SPY | ETF | 430.41 | 430.47 | 429.75 | 430.11 | 7850.0 |
| 2021-07-08 04:30:00 | SPY | ETF | 429.9 | 430.04 | 429.75 | 429.87 | 10200.0 |
| 2021-07-08 04:35:00 | SPY | ETF | 429.94 | 430.0 | 429.75 | 429.99 | 4590.0 |
| 2021-07-08 04:40:00 | SPY | ETF | 430.18 | 430.22 | 429.97 | 430.18 | 5600.0 |
| 2021-07-08 04:45:00 | SPY | ETF | 430.05 | 430.43 | 430.05 | 430.43 | 2469.0 |
| 2021-07-08 04:50:00 | SPY | ETF | 430.41 | 430.46 | 430.26 | 430.3 | 36050.0 |
| 2021-07-08 04:55:00 | SPY | ETF | 430.34 | 430.57 | 430.31 | 430.4 | 17298.0 |
| 2021-07-08 05:00:00 | SPY | ETF | 430.41 | 430.51 | 430.25 | 430.25 | 13750.0 |
| 2021-07-08 05:05:00 | SPY | ETF | 430.11 | 430.11 | 429.82 | 429.85 | 6215.0 |
| 2021-07-08 05:10:00 | SPY | ETF | 429.78 | 430.0 | 429.67 | 430.0 | 6450.0 |
| 2021-07-08 05:15:00 | SPY | ETF | 430.03 | 430.03 | 429.85 | 429.88 | 25435.0 |
| 2021-07-08 05:20:00 | SPY | ETF | 429.71 | 429.87 | 429.13 | 429.42 | 66692.0 |
| 2021-07-08 05:25:00 | SPY | ETF | 429.45 | 429.78 | 429.35 | 429.78 | 37922.0 |
| 2021-07-08 05:30:00 | SPY | ETF | 429.89 | 430.04 | 429.84 | 429.96 | 10536.0 |
| 2021-07-08 05:35:00 | SPY | ETF | 429.98 | 430.03 | 429.9 | 429.9 | 1599.0 |
| 2021-07-08 05:40:00 | SPY | ETF | 430.14 | 430.2 | 429.94 | 429.94 | 3400.0 |
| 2021-07-08 05:45:00 | SPY | ETF | 430.1 | 430.16 | 430.1 | 430.1 | 2899.0 |
| 2021-07-08 05:50:00 | SPY | ETF | 430.02 | 430.03 | 429.82 | 429.94 | 4100.0 |
| 2021-07-08 05:55:00 | SPY | ETF | 429.63 | 429.68 | 429.42 | 429.51 | 43926.0 |
| 2021-07-08 06:00:00 | SPY | ETF | 429.29 | 429.29 | 428.68 | 429.01 | 85830.0 |
| 2021-07-08 06:05:00 | SPY | ETF | 429.06 | 429.06 | 428.71 | 428.72 | 16600.0 |
| 2021-07-08 06:10:00 | SPY | ETF | 428.7 | 428.75 | 428.34 | 428.62 | 66459.0 |
| 2021-07-08 06:15:00 | SPY | ETF | 428.51 | 428.54 | 427.87 | 428.19 | 58698.0 |
| 2021-07-08 06:20:00 | SPY | ETF | 428.06 | 428.09 | 427.6 | 428.01 | 127739.0 |
| 2021-07-08 06:25:00 | SPY | ETF | 428.0 | 428.05 | 427.82 | 427.93 | 24146.0 |
| 2021-07-08 06:30:00 | SPY | ETF | 427.82 | 428.3 | 427.69 | 428.14 | 55463.0 |
| 2021-07-08 06:35:00 | SPY | ETF | 428.27 | 428.35 | 428.18 | 428.35 | 24444.0 |
| 2021-07-08 06:40:00 | SPY | ETF | 428.23 | 428.31 | 427.97 | 428.02 | 13700.0 |
| 2021-07-08 06:45:00 | SPY | ETF | 428.06 | 428.52 | 428.03 | 428.48 | 13049.0 |
| 2021-07-08 06:50:00 | SPY | ETF | 428.38 | 428.83 | 428.32 | 428.67 | 68040.0 |
| 2021-07-08 06:55:00 | SPY | ETF | 428.51 | 429.0 | 428.39 | 428.97 | 16989.0 |
| 2021-07-08 07:00:00 | SPY | ETF | 428.97 | 429.22 | 428.84 | 428.89 | 126703.0 |
| 2021-07-08 07:05:00 | SPY | ETF | 428.85 | 429.09 | 428.67 | 428.95 | 21331.0 |
| 2021-07-08 07:10:00 | SPY | ETF | 428.94 | 429.02 | 428.56 | 428.89 | 20851.0 |
| 2021-07-08 07:15:00 | SPY | ETF | 428.89 | 429.15 | 428.76 | 429.01 | 62035.0 |
| 2021-07-08 07:20:00 | SPY | ETF | 428.91 | 429.24 | 428.9 | 429.18 | 67991.0 |
| 2021-07-08 07:25:00 | SPY | ETF | 429.12 | 429.25 | 428.88 | 429.14 | 53798.0 |
| 2021-07-08 07:30:00 | SPY | ETF | 429.01 | 429.05 | 428.46 | 428.84 | 115597.0 |
| 2021-07-08 07:35:00 | SPY | ETF | 428.81 | 428.84 | 428.53 | 428.69 | 56522.0 |
| 2021-07-08 07:40:00 | SPY | ETF | 428.61 | 428.71 | 428.47 | 428.61 | 87057.0 |
| 2021-07-08 07:45:00 | SPY | ETF | 428.63 | 428.69 | 428.15 | 428.53 | 141126.0 |
| 2021-07-08 07:50:00 | SPY | ETF | 428.49 | 428.61 | 428.31 | 428.35 | 56322.0 |
| 2021-07-08 07:55:00 | SPY | ETF | 428.35 | 428.41 | 428.23 | 428.31 | 83314.0 |
| 2021-07-08 08:00:00 | SPY | ETF | 428.31 | 433.69 | 427.9596 | 428.13 | 211770.0 |
| 2021-07-08 08:05:00 | SPY | ETF | 428.15 | 428.16 | 427.69 | 427.72 | 83289.0 |
> showing 50 of 86,014 rows — these rows as CSV