PREVIEW / etf_5min / 2021-03-12
file: by_date/etf_5min/2021/2021-03-12.parquet size: 1.8 MB rows: 86,294
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-12 04:00:00 | SPY | ETF | 394.5 | 394.5 | 391.08 | 391.39 | 10482.0 |
| 2021-03-12 04:05:00 | SPY | ETF | 391.38 | 391.74 | 391.38 | 391.74 | 5220.0 |
| 2021-03-12 04:10:00 | SPY | ETF | 391.72 | 391.74 | 391.35 | 391.35 | 2747.0 |
| 2021-03-12 04:15:00 | SPY | ETF | 391.39 | 391.39 | 391.2 | 391.29 | 4100.0 |
| 2021-03-12 04:20:00 | SPY | ETF | 391.25 | 391.34 | 390.98 | 390.98 | 3490.0 |
| 2021-03-12 04:25:00 | SPY | ETF | 390.92 | 391.12 | 390.92 | 391.12 | 3360.0 |
| 2021-03-12 04:30:00 | SPY | ETF | 391.19 | 391.29 | 391.19 | 391.2 | 1000.0 |
| 2021-03-12 04:35:00 | SPY | ETF | 391.19 | 391.25 | 391.19 | 391.22 | 900.0 |
| 2021-03-12 04:45:00 | SPY | ETF | 391.22 | 391.36 | 391.22 | 391.28 | 1400.0 |
| 2021-03-12 04:50:00 | SPY | ETF | 391.18 | 391.25 | 391.07 | 391.08 | 3999.0 |
| 2021-03-12 04:55:00 | SPY | ETF | 391.03 | 391.27 | 391.02 | 391.25 | 4600.0 |
| 2021-03-12 05:00:00 | SPY | ETF | 391.23 | 391.25 | 391.05 | 391.05 | 7999.0 |
| 2021-03-12 05:05:00 | SPY | ETF | 390.97 | 391.08 | 390.97 | 391.02 | 7879.0 |
| 2021-03-12 05:15:00 | SPY | ETF | 391.01 | 391.01 | 390.91 | 390.91 | 1000.0 |
| 2021-03-12 05:20:00 | SPY | ETF | 390.9 | 390.95 | 390.88 | 390.88 | 2550.0 |
| 2021-03-12 05:25:00 | SPY | ETF | 390.98 | 390.98 | 390.95 | 390.95 | 2499.0 |
| 2021-03-12 05:30:00 | SPY | ETF | 391.0 | 391.29 | 391.0 | 391.29 | 3390.0 |
| 2021-03-12 05:35:00 | SPY | ETF | 391.42 | 391.57 | 391.35 | 391.35 | 7647.0 |
| 2021-03-12 05:40:00 | SPY | ETF | 391.42 | 391.6 | 391.26 | 391.58 | 9863.0 |
| 2021-03-12 05:45:00 | SPY | ETF | 391.55 | 391.7 | 391.54 | 391.58 | 6647.0 |
| 2021-03-12 05:50:00 | SPY | ETF | 391.57 | 391.68 | 391.28 | 391.33 | 1698.0 |
| 2021-03-12 05:55:00 | SPY | ETF | 391.33 | 391.36 | 391.33 | 391.36 | 10300.0 |
| 2021-03-12 06:00:00 | SPY | ETF | 391.3 | 391.3 | 390.99 | 391.23 | 11855.0 |
| 2021-03-12 06:05:00 | SPY | ETF | 391.26 | 391.3 | 391.25 | 391.3 | 300.0 |
| 2021-03-12 06:10:00 | SPY | ETF | 391.4 | 391.53 | 391.34 | 391.48 | 3602.0 |
| 2021-03-12 06:15:00 | SPY | ETF | 391.52 | 391.53 | 391.22 | 391.53 | 2300.0 |
| 2021-03-12 06:20:00 | SPY | ETF | 391.25 | 391.25 | 391.25 | 391.25 | 100.0 |
| 2021-03-12 06:25:00 | SPY | ETF | 391.25 | 391.4 | 391.17 | 391.17 | 1727.0 |
| 2021-03-12 06:30:00 | SPY | ETF | 391.3 | 391.43 | 391.3 | 391.43 | 1030.0 |
| 2021-03-12 06:35:00 | SPY | ETF | 391.42 | 391.6 | 391.42 | 391.6 | 1800.0 |
| 2021-03-12 06:40:00 | SPY | ETF | 391.65 | 391.72 | 391.46 | 391.46 | 5660.0 |
| 2021-03-12 06:45:00 | SPY | ETF | 391.24 | 391.43 | 391.24 | 391.4 | 1000.0 |
| 2021-03-12 06:50:00 | SPY | ETF | 391.36 | 391.62 | 391.31 | 391.62 | 1761.0 |
| 2021-03-12 06:55:00 | SPY | ETF | 391.62 | 391.7 | 391.3 | 391.3 | 14942.0 |
| 2021-03-12 07:00:00 | SPY | ETF | 391.35 | 391.779 | 391.29 | 391.76 | 33383.0 |
| 2021-03-12 07:05:00 | SPY | ETF | 391.74 | 391.95 | 391.71 | 391.89 | 47116.0 |
| 2021-03-12 07:10:00 | SPY | ETF | 391.92 | 392.01 | 391.84 | 391.96 | 30054.0 |
| 2021-03-12 07:15:00 | SPY | ETF | 391.96 | 392.2 | 391.93 | 391.95 | 40704.0 |
| 2021-03-12 07:20:00 | SPY | ETF | 392.06 | 392.09 | 391.87 | 391.96 | 5650.0 |
| 2021-03-12 07:25:00 | SPY | ETF | 391.86 | 391.9 | 391.72 | 391.78 | 4438.0 |
| 2021-03-12 07:30:00 | SPY | ETF | 391.75 | 391.76 | 391.7 | 391.71 | 6161.0 |
| 2021-03-12 07:35:00 | SPY | ETF | 391.77 | 391.97 | 391.76 | 391.88 | 19435.0 |
| 2021-03-12 07:40:00 | SPY | ETF | 391.89 | 392.15 | 391.82 | 392.15 | 41779.0 |
| 2021-03-12 07:45:00 | SPY | ETF | 392.11 | 392.39 | 392.09 | 392.39 | 11900.0 |
| 2021-03-12 07:50:00 | SPY | ETF | 392.39 | 392.5 | 392.29 | 392.49 | 23774.0 |
| 2021-03-12 07:55:00 | SPY | ETF | 392.5 | 392.6 | 392.48 | 392.54 | 16808.0 |
| 2021-03-12 08:00:00 | SPY | ETF | 392.54 | 394.05 | 391.2296 | 392.79 | 82725.0 |
| 2021-03-12 08:05:00 | SPY | ETF | 392.82 | 392.83 | 392.38 | 392.38 | 25190.0 |
| 2021-03-12 08:10:00 | SPY | ETF | 392.45 | 392.45 | 392.29 | 392.34 | 30718.0 |
| 2021-03-12 08:15:00 | SPY | ETF | 392.38 | 392.53 | 392.25 | 392.44 | 21890.0 |
> showing 50 of 86,294 rows — these rows as CSV