PREVIEW / etf_5min / 2021-08-31
file: by_date/etf_5min/2021/2021-08-31.parquet size: 1.7 MB rows: 79,277
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-08-31 04:00:00 | SPY | ETF | 453.17 | 453.37 | 453.17 | 453.28 | 2393.0 |
| 2021-08-31 04:05:00 | SPY | ETF | 453.31 | 453.36 | 453.3 | 453.3 | 1024.0 |
| 2021-08-31 04:10:00 | SPY | ETF | 453.36 | 453.4 | 453.34 | 453.4 | 771.0 |
| 2021-08-31 04:15:00 | SPY | ETF | 453.36 | 453.42 | 453.36 | 453.42 | 300.0 |
| 2021-08-31 04:20:00 | SPY | ETF | 453.37 | 453.37 | 453.35 | 453.35 | 9643.0 |
| 2021-08-31 04:25:00 | SPY | ETF | 453.35 | 453.36 | 453.29 | 453.33 | 2572.0 |
| 2021-08-31 04:30:00 | SPY | ETF | 453.19 | 453.28 | 453.19 | 453.23 | 509.0 |
| 2021-08-31 04:35:00 | SPY | ETF | 453.13 | 453.13 | 453.13 | 453.13 | 100.0 |
| 2021-08-31 04:40:00 | SPY | ETF | 453.15 | 453.26 | 453.15 | 453.19 | 900.0 |
| 2021-08-31 04:45:00 | SPY | ETF | 453.15 | 453.21 | 453.15 | 453.19 | 800.0 |
| 2021-08-31 04:50:00 | SPY | ETF | 453.19 | 453.19 | 453.14 | 453.14 | 200.0 |
| 2021-08-31 04:55:00 | SPY | ETF | 453.22 | 453.22 | 453.22 | 453.22 | 100.0 |
| 2021-08-31 05:00:00 | SPY | ETF | 453.22 | 453.22 | 453.15 | 453.2 | 1600.0 |
| 2021-08-31 05:05:00 | SPY | ETF | 453.17 | 453.25 | 453.15 | 453.21 | 968.0 |
| 2021-08-31 05:10:00 | SPY | ETF | 453.19 | 453.19 | 453.18 | 453.18 | 200.0 |
| 2021-08-31 05:20:00 | SPY | ETF | 453.19 | 453.19 | 453.18 | 453.18 | 600.0 |
| 2021-08-31 05:30:00 | SPY | ETF | 453.18 | 453.18 | 453.1 | 453.1 | 200.0 |
| 2021-08-31 05:35:00 | SPY | ETF | 453.15 | 453.15 | 453.0 | 453.01 | 1400.0 |
| 2021-08-31 05:40:00 | SPY | ETF | 453.06 | 453.06 | 452.95 | 453.01 | 3709.0 |
| 2021-08-31 05:45:00 | SPY | ETF | 452.95 | 452.95 | 452.95 | 452.95 | 200.0 |
| 2021-08-31 05:50:00 | SPY | ETF | 453.02 | 453.02 | 453.0 | 453.0 | 600.0 |
| 2021-08-31 05:55:00 | SPY | ETF | 452.97 | 452.97 | 452.92 | 452.94 | 500.0 |
| 2021-08-31 06:00:00 | SPY | ETF | 452.91 | 453.05 | 452.91 | 453.05 | 859.0 |
| 2021-08-31 06:05:00 | SPY | ETF | 452.93 | 452.99 | 452.93 | 452.99 | 350.0 |
| 2021-08-31 06:10:00 | SPY | ETF | 453.0 | 453.0 | 453.0 | 453.0 | 300.0 |
| 2021-08-31 06:15:00 | SPY | ETF | 452.96 | 452.96 | 452.95 | 452.95 | 298.0 |
| 2021-08-31 06:20:00 | SPY | ETF | 452.9 | 452.93 | 452.86 | 452.93 | 1471.0 |
| 2021-08-31 06:25:00 | SPY | ETF | 452.85 | 452.85 | 452.67 | 452.81 | 5636.0 |
| 2021-08-31 06:30:00 | SPY | ETF | 452.83 | 452.83 | 452.69 | 452.69 | 2500.0 |
| 2021-08-31 06:35:00 | SPY | ETF | 452.69 | 452.69 | 452.4 | 452.49 | 6300.0 |
| 2021-08-31 06:40:00 | SPY | ETF | 452.54 | 452.71 | 452.54 | 452.65 | 1300.0 |
| 2021-08-31 06:45:00 | SPY | ETF | 452.58 | 452.58 | 452.0 | 452.34 | 24965.0 |
| 2021-08-31 06:50:00 | SPY | ETF | 452.3 | 452.3 | 451.91 | 452.15 | 10780.0 |
| 2021-08-31 06:55:00 | SPY | ETF | 452.12 | 452.12 | 451.88 | 452.05 | 3500.0 |
| 2021-08-31 07:00:00 | SPY | ETF | 452.07 | 452.12 | 451.87 | 452.12 | 16075.0 |
| 2021-08-31 07:05:00 | SPY | ETF | 452.12 | 452.34 | 452.1 | 452.33 | 6320.0 |
| 2021-08-31 07:10:00 | SPY | ETF | 452.32 | 452.39 | 452.26 | 452.3 | 5867.0 |
| 2021-08-31 07:15:00 | SPY | ETF | 452.33 | 452.37 | 452.26 | 452.33 | 2202.0 |
| 2021-08-31 07:20:00 | SPY | ETF | 452.43 | 452.48 | 452.3 | 452.38 | 13198.0 |
| 2021-08-31 07:25:00 | SPY | ETF | 452.31 | 452.39 | 452.0 | 452.31 | 19010.0 |
| 2021-08-31 07:30:00 | SPY | ETF | 452.26 | 452.26 | 452.0 | 452.1 | 23345.0 |
| 2021-08-31 07:35:00 | SPY | ETF | 452.18 | 452.27 | 452.09 | 452.21 | 18784.0 |
| 2021-08-31 07:40:00 | SPY | ETF | 452.21 | 452.3 | 451.98 | 452.29 | 23803.0 |
| 2021-08-31 07:45:00 | SPY | ETF | 452.28 | 452.28 | 452.01 | 452.02 | 15685.0 |
| 2021-08-31 07:50:00 | SPY | ETF | 452.03 | 452.1 | 451.96 | 451.99 | 14317.0 |
| 2021-08-31 07:55:00 | SPY | ETF | 451.99 | 452.04 | 451.92 | 452.01 | 7342.0 |
| 2021-08-31 08:00:00 | SPY | ETF | 452.16 | 453.48 | 451.78 | 451.97 | 43497.0 |
| 2021-08-31 08:05:00 | SPY | ETF | 451.97 | 452.04 | 451.93 | 451.93 | 12102.0 |
| 2021-08-31 08:10:00 | SPY | ETF | 452.0 | 452.09 | 451.86 | 451.92 | 12936.0 |
| 2021-08-31 08:15:00 | SPY | ETF | 451.93 | 451.95 | 451.75 | 451.78 | 13719.0 |
> showing 50 of 79,277 rows — these rows as CSV