PREVIEW / etf_5min / 2022-12-06
file: by_date/etf_5min/2022/2022-12-06.parquet size: 2.0 MB rows: 98,569
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-06 04:00:00 | SPY | ETF | 400.65 | 400.72 | 400.49 | 400.52 | 7055.0 |
| 2022-12-06 04:05:00 | SPY | ETF | 400.55 | 400.67 | 400.53 | 400.67 | 603.0 |
| 2022-12-06 04:10:00 | SPY | ETF | 400.4 | 400.41 | 400.32 | 400.35 | 2977.0 |
| 2022-12-06 04:15:00 | SPY | ETF | 400.28 | 400.52 | 400.22 | 400.52 | 1626.0 |
| 2022-12-06 04:20:00 | SPY | ETF | 400.44 | 400.65 | 400.38 | 400.65 | 2712.0 |
| 2022-12-06 04:25:00 | SPY | ETF | 400.5 | 400.58 | 400.5 | 400.57 | 3000.0 |
| 2022-12-06 04:30:00 | SPY | ETF | 400.28 | 400.36 | 400.17 | 400.36 | 1806.0 |
| 2022-12-06 04:35:00 | SPY | ETF | 400.56 | 400.63 | 400.5 | 400.5 | 2625.0 |
| 2022-12-06 04:40:00 | SPY | ETF | 400.56 | 400.6 | 400.46 | 400.46 | 1763.0 |
| 2022-12-06 04:45:00 | SPY | ETF | 400.38 | 400.4 | 400.36 | 400.38 | 2131.0 |
| 2022-12-06 04:50:00 | SPY | ETF | 400.44 | 400.44 | 400.33 | 400.35 | 2295.0 |
| 2022-12-06 04:55:00 | SPY | ETF | 400.51 | 400.51 | 399.89 | 399.89 | 3213.0 |
| 2022-12-06 05:00:00 | SPY | ETF | 399.93 | 400.01 | 399.79 | 400.0 | 4825.0 |
| 2022-12-06 05:05:00 | SPY | ETF | 400.04 | 400.1 | 399.98 | 399.98 | 3837.0 |
| 2022-12-06 05:10:00 | SPY | ETF | 399.97 | 399.97 | 399.86 | 399.91 | 1350.0 |
| 2022-12-06 05:15:00 | SPY | ETF | 399.95 | 399.95 | 399.73 | 399.75 | 1266.0 |
| 2022-12-06 05:20:00 | SPY | ETF | 399.68 | 399.68 | 399.56 | 399.56 | 1878.0 |
| 2022-12-06 05:25:00 | SPY | ETF | 399.64 | 399.64 | 399.3 | 399.36 | 6214.0 |
| 2022-12-06 05:30:00 | SPY | ETF | 399.18 | 399.5 | 399.09 | 399.5 | 13284.0 |
| 2022-12-06 05:35:00 | SPY | ETF | 399.41 | 399.45 | 399.3 | 399.45 | 2045.0 |
| 2022-12-06 05:40:00 | SPY | ETF | 399.6 | 399.65 | 399.44 | 399.61 | 4330.0 |
| 2022-12-06 05:45:00 | SPY | ETF | 399.58 | 399.62 | 399.58 | 399.58 | 705.0 |
| 2022-12-06 05:50:00 | SPY | ETF | 399.63 | 400.1 | 399.63 | 400.1 | 4747.0 |
| 2022-12-06 05:55:00 | SPY | ETF | 400.09 | 400.09 | 399.93 | 399.93 | 6125.0 |
| 2022-12-06 06:00:00 | SPY | ETF | 399.79 | 399.8 | 399.75 | 399.8 | 1150.0 |
| 2022-12-06 06:05:00 | SPY | ETF | 399.86 | 399.86 | 399.82 | 399.82 | 400.0 |
| 2022-12-06 06:10:00 | SPY | ETF | 399.67 | 399.67 | 399.43 | 399.43 | 3885.0 |
| 2022-12-06 06:15:00 | SPY | ETF | 399.48 | 399.59 | 399.48 | 399.5 | 2070.0 |
| 2022-12-06 06:20:00 | SPY | ETF | 399.55 | 399.67 | 399.55 | 399.57 | 3727.0 |
| 2022-12-06 06:25:00 | SPY | ETF | 399.54 | 399.54 | 399.51 | 399.51 | 1150.0 |
| 2022-12-06 06:30:00 | SPY | ETF | 399.66 | 399.97 | 399.65 | 399.97 | 2572.0 |
| 2022-12-06 06:35:00 | SPY | ETF | 399.94 | 399.96 | 399.76 | 399.76 | 2685.0 |
| 2022-12-06 06:40:00 | SPY | ETF | 399.85 | 399.87 | 399.75 | 399.82 | 1254.0 |
| 2022-12-06 06:45:00 | SPY | ETF | 399.86 | 399.86 | 399.68 | 399.85 | 2099.0 |
| 2022-12-06 06:50:00 | SPY | ETF | 399.81 | 399.89 | 399.67 | 399.89 | 2750.0 |
| 2022-12-06 06:55:00 | SPY | ETF | 399.79 | 400.02 | 399.78 | 400.01 | 5918.0 |
| 2022-12-06 07:00:00 | SPY | ETF | 400.01 | 400.24 | 399.94 | 400.16 | 24728.0 |
| 2022-12-06 07:05:00 | SPY | ETF | 400.22 | 400.35 | 400.2 | 400.3 | 12507.0 |
| 2022-12-06 07:10:00 | SPY | ETF | 400.34 | 400.5 | 400.34 | 400.5 | 48199.0 |
| 2022-12-06 07:15:00 | SPY | ETF | 400.48 | 400.54 | 400.32 | 400.32 | 22592.0 |
| 2022-12-06 07:20:00 | SPY | ETF | 400.32 | 400.41 | 400.19 | 400.38 | 13449.0 |
| 2022-12-06 07:25:00 | SPY | ETF | 400.3 | 400.5 | 400.17 | 400.43 | 27268.0 |
| 2022-12-06 07:30:00 | SPY | ETF | 400.44 | 400.5 | 400.39 | 400.41 | 21937.0 |
| 2022-12-06 07:35:00 | SPY | ETF | 400.39 | 400.4 | 400.3 | 400.4 | 8938.0 |
| 2022-12-06 07:40:00 | SPY | ETF | 400.41 | 400.41 | 400.08 | 400.09 | 15171.0 |
| 2022-12-06 07:45:00 | SPY | ETF | 400.14 | 400.18 | 399.95 | 399.97 | 15483.0 |
| 2022-12-06 07:50:00 | SPY | ETF | 399.97 | 400.12 | 399.93 | 400.081 | 22622.0 |
| 2022-12-06 07:55:00 | SPY | ETF | 400.1 | 400.15 | 399.89 | 399.89 | 13204.0 |
| 2022-12-06 08:00:00 | SPY | ETF | 400.3301 | 400.5 | 399.1396 | 399.76 | 134338.0 |
| 2022-12-06 08:05:00 | SPY | ETF | 399.76 | 399.76 | 399.27 | 399.29 | 73074.0 |
> showing 50 of 98,569 rows — these rows as CSV