PREVIEW / etf_5min / 2021-12-22
file: by_date/etf_5min/2021/2021-12-22.parquet size: 1.9 MB rows: 89,357
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-12-22 04:00:00 | SPY | ETF | 461.98 | 462.0 | 461.83 | 462.0 | 6391.0 |
| 2021-12-22 04:05:00 | SPY | ETF | 461.86 | 462.09 | 461.86 | 461.94 | 1258.0 |
| 2021-12-22 04:10:00 | SPY | ETF | 461.94 | 462.23 | 461.85 | 462.23 | 2915.0 |
| 2021-12-22 04:15:00 | SPY | ETF | 462.23 | 462.32 | 462.15 | 462.32 | 1394.0 |
| 2021-12-22 04:20:00 | SPY | ETF | 462.46 | 462.46 | 462.18 | 462.21 | 7788.0 |
| 2021-12-22 04:25:00 | SPY | ETF | 462.16 | 462.21 | 462.12 | 462.14 | 4586.0 |
| 2021-12-22 04:30:00 | SPY | ETF | 462.16 | 462.34 | 462.1 | 462.34 | 4389.0 |
| 2021-12-22 04:35:00 | SPY | ETF | 462.33 | 462.34 | 462.26 | 462.31 | 8159.0 |
| 2021-12-22 04:40:00 | SPY | ETF | 462.21 | 462.21 | 462.14 | 462.15 | 5113.0 |
| 2021-12-22 04:45:00 | SPY | ETF | 462.13 | 462.13 | 462.02 | 462.03 | 300.0 |
| 2021-12-22 04:50:00 | SPY | ETF | 462.11 | 462.26 | 462.11 | 462.19 | 1874.0 |
| 2021-12-22 04:55:00 | SPY | ETF | 462.18 | 462.18 | 462.04 | 462.04 | 909.0 |
| 2021-12-22 05:00:00 | SPY | ETF | 462.18 | 462.18 | 462.18 | 462.18 | 123.0 |
| 2021-12-22 05:05:00 | SPY | ETF | 462.1 | 462.1 | 462.1 | 462.1 | 120.0 |
| 2021-12-22 05:10:00 | SPY | ETF | 462.25 | 462.25 | 462.25 | 462.25 | 100.0 |
| 2021-12-22 05:15:00 | SPY | ETF | 462.24 | 462.33 | 462.24 | 462.33 | 314.0 |
| 2021-12-22 05:20:00 | SPY | ETF | 462.31 | 462.33 | 462.25 | 462.33 | 832.0 |
| 2021-12-22 05:25:00 | SPY | ETF | 462.22 | 462.33 | 462.22 | 462.33 | 400.0 |
| 2021-12-22 05:30:00 | SPY | ETF | 462.39 | 462.39 | 462.28 | 462.28 | 518.0 |
| 2021-12-22 05:35:00 | SPY | ETF | 462.26 | 462.5 | 462.25 | 462.5 | 515.0 |
| 2021-12-22 05:40:00 | SPY | ETF | 462.53 | 462.84 | 462.53 | 462.7 | 2374.0 |
| 2021-12-22 05:45:00 | SPY | ETF | 462.71 | 462.96 | 462.71 | 462.93 | 6062.0 |
| 2021-12-22 05:50:00 | SPY | ETF | 463.04 | 463.13 | 463.03 | 463.03 | 2881.0 |
| 2021-12-22 05:55:00 | SPY | ETF | 462.98 | 463.05 | 462.91 | 463.05 | 4350.0 |
| 2021-12-22 06:00:00 | SPY | ETF | 463.08 | 463.1 | 463.01 | 463.1 | 1620.0 |
| 2021-12-22 06:05:00 | SPY | ETF | 463.14 | 463.19 | 463.06 | 463.17 | 9546.0 |
| 2021-12-22 06:10:00 | SPY | ETF | 463.24 | 463.29 | 463.15 | 463.15 | 13063.0 |
| 2021-12-22 06:15:00 | SPY | ETF | 463.32 | 463.35 | 463.27 | 463.28 | 3470.0 |
| 2021-12-22 06:20:00 | SPY | ETF | 463.32 | 463.35 | 463.3 | 463.3 | 6216.0 |
| 2021-12-22 06:25:00 | SPY | ETF | 463.27 | 463.27 | 463.21 | 463.21 | 9099.0 |
| 2021-12-22 06:30:00 | SPY | ETF | 463.2 | 463.2 | 463.06 | 463.06 | 6798.0 |
| 2021-12-22 06:35:00 | SPY | ETF | 463.06 | 463.08 | 463.01 | 463.01 | 9980.0 |
| 2021-12-22 06:40:00 | SPY | ETF | 463.03 | 463.12 | 462.98 | 463.1 | 4924.0 |
| 2021-12-22 06:45:00 | SPY | ETF | 463.19 | 463.39 | 463.19 | 463.36 | 4638.0 |
| 2021-12-22 06:50:00 | SPY | ETF | 463.32 | 463.35 | 463.27 | 463.28 | 6243.0 |
| 2021-12-22 06:55:00 | SPY | ETF | 463.39 | 463.63 | 463.39 | 463.62 | 7702.0 |
| 2021-12-22 07:00:00 | SPY | ETF | 463.6 | 463.67 | 463.45 | 463.49 | 7908.0 |
| 2021-12-22 07:05:00 | SPY | ETF | 463.49 | 463.6 | 463.49 | 463.5 | 6386.0 |
| 2021-12-22 07:10:00 | SPY | ETF | 463.56 | 463.56 | 463.5 | 463.54 | 2126.0 |
| 2021-12-22 07:15:00 | SPY | ETF | 463.54 | 463.54 | 463.43 | 463.43 | 4158.0 |
| 2021-12-22 07:20:00 | SPY | ETF | 463.45 | 463.47 | 463.4 | 463.45 | 6805.0 |
| 2021-12-22 07:25:00 | SPY | ETF | 463.49 | 463.49 | 463.33 | 463.33 | 8835.0 |
| 2021-12-22 07:30:00 | SPY | ETF | 463.33 | 463.46 | 463.33 | 463.45 | 6872.0 |
| 2021-12-22 07:35:00 | SPY | ETF | 463.43 | 463.43 | 463.3 | 463.3 | 13801.0 |
| 2021-12-22 07:40:00 | SPY | ETF | 463.35 | 463.35 | 463.24 | 463.29 | 2293.0 |
| 2021-12-22 07:45:00 | SPY | ETF | 463.32 | 463.36 | 463.29 | 463.29 | 28255.0 |
| 2021-12-22 07:50:00 | SPY | ETF | 463.33 | 463.36 | 463.16 | 463.18 | 2842.0 |
| 2021-12-22 07:55:00 | SPY | ETF | 463.25 | 463.25 | 463.01 | 463.01 | 8243.0 |
| 2021-12-22 08:00:00 | SPY | ETF | 463.26 | 463.6399 | 462.1 | 462.91 | 40087.0 |
| 2021-12-22 08:05:00 | SPY | ETF | 462.94 | 462.99 | 462.91 | 462.93 | 15115.0 |
> showing 50 of 89,357 rows — these rows as CSV