PREVIEW / etf_5min / 2022-12-23
file: by_date/etf_5min/2022/2022-12-23.parquet size: 1.9 MB rows: 94,299
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-23 04:00:00 | SPY | ETF | 381.07 | 381.09 | 380.94 | 380.94 | 3924.0 |
| 2022-12-23 04:05:00 | SPY | ETF | 380.93 | 381.11 | 380.88 | 381.11 | 2504.0 |
| 2022-12-23 04:10:00 | SPY | ETF | 381.06 | 381.06 | 380.67 | 380.67 | 5454.0 |
| 2022-12-23 04:15:00 | SPY | ETF | 380.59 | 380.59 | 380.36 | 380.43 | 4781.0 |
| 2022-12-23 04:20:00 | SPY | ETF | 380.6 | 380.6 | 380.41 | 380.6 | 2214.0 |
| 2022-12-23 04:30:00 | SPY | ETF | 380.59 | 380.7 | 380.59 | 380.7 | 1700.0 |
| 2022-12-23 04:35:00 | SPY | ETF | 380.66 | 380.66 | 380.64 | 380.64 | 223.0 |
| 2022-12-23 04:40:00 | SPY | ETF | 380.67 | 380.74 | 380.67 | 380.72 | 1176.0 |
| 2022-12-23 04:45:00 | SPY | ETF | 380.7 | 380.93 | 380.7 | 380.93 | 4446.0 |
| 2022-12-23 04:50:00 | SPY | ETF | 380.94 | 381.01 | 380.9 | 381.01 | 2977.0 |
| 2022-12-23 04:55:00 | SPY | ETF | 380.92 | 380.92 | 380.9 | 380.9 | 314.0 |
| 2022-12-23 05:00:00 | SPY | ETF | 380.97 | 381.0 | 380.8 | 380.8 | 1258.0 |
| 2022-12-23 05:05:00 | SPY | ETF | 380.82 | 380.95 | 380.82 | 380.95 | 1050.0 |
| 2022-12-23 05:15:00 | SPY | ETF | 381.21 | 381.28 | 381.2 | 381.25 | 1137.0 |
| 2022-12-23 05:20:00 | SPY | ETF | 381.35 | 381.41 | 381.29 | 381.39 | 1171.0 |
| 2022-12-23 05:25:00 | SPY | ETF | 381.39 | 381.58 | 381.39 | 381.58 | 500.0 |
| 2022-12-23 05:30:00 | SPY | ETF | 381.64 | 381.8 | 381.64 | 381.7 | 11895.0 |
| 2022-12-23 05:35:00 | SPY | ETF | 381.76 | 382.04 | 381.76 | 381.93 | 4263.0 |
| 2022-12-23 05:40:00 | SPY | ETF | 381.97 | 381.97 | 381.9 | 381.9 | 515.0 |
| 2022-12-23 05:45:00 | SPY | ETF | 381.88 | 382.08 | 381.88 | 382.07 | 1363.0 |
| 2022-12-23 05:50:00 | SPY | ETF | 382.09 | 382.25 | 382.09 | 382.16 | 6094.0 |
| 2022-12-23 05:55:00 | SPY | ETF | 382.07 | 382.07 | 381.97 | 382.03 | 1600.0 |
| 2022-12-23 06:00:00 | SPY | ETF | 382.04 | 382.42 | 382.04 | 382.42 | 1250.0 |
| 2022-12-23 06:05:00 | SPY | ETF | 382.35 | 382.38 | 382.17 | 382.22 | 840.0 |
| 2022-12-23 06:10:00 | SPY | ETF | 382.1 | 382.16 | 382.0 | 382.16 | 4109.0 |
| 2022-12-23 06:15:00 | SPY | ETF | 381.99 | 381.99 | 381.89 | 381.89 | 900.0 |
| 2022-12-23 06:20:00 | SPY | ETF | 381.89 | 381.98 | 381.7 | 381.7 | 2840.0 |
| 2022-12-23 06:25:00 | SPY | ETF | 381.7 | 381.71 | 381.7 | 381.71 | 1100.0 |
| 2022-12-23 06:30:00 | SPY | ETF | 381.7 | 381.75 | 381.51 | 381.51 | 7963.0 |
| 2022-12-23 06:35:00 | SPY | ETF | 381.5 | 381.6 | 381.44 | 381.55 | 7865.0 |
| 2022-12-23 06:40:00 | SPY | ETF | 381.52 | 381.52 | 381.4 | 381.4 | 1190.0 |
| 2022-12-23 06:45:00 | SPY | ETF | 381.44 | 381.55 | 381.44 | 381.53 | 1450.0 |
| 2022-12-23 06:50:00 | SPY | ETF | 381.53 | 381.54 | 381.48 | 381.48 | 8590.0 |
| 2022-12-23 06:55:00 | SPY | ETF | 381.4 | 381.4 | 381.19 | 381.34 | 2994.0 |
| 2022-12-23 07:00:00 | SPY | ETF | 381.37 | 381.37 | 381.19 | 381.3 | 6060.0 |
| 2022-12-23 07:05:00 | SPY | ETF | 381.34 | 381.34 | 381.08 | 381.13 | 4680.0 |
| 2022-12-23 07:10:00 | SPY | ETF | 381.22 | 381.25 | 381.17 | 381.23 | 57210.0 |
| 2022-12-23 07:15:00 | SPY | ETF | 381.2 | 381.43 | 381.2 | 381.42 | 5121.0 |
| 2022-12-23 07:20:00 | SPY | ETF | 381.43 | 381.67 | 381.43 | 381.62 | 5216.0 |
| 2022-12-23 07:25:00 | SPY | ETF | 381.58 | 381.58 | 381.49 | 381.5 | 4579.0 |
| 2022-12-23 07:30:00 | SPY | ETF | 381.67 | 381.77 | 381.64 | 381.69 | 5234.0 |
| 2022-12-23 07:35:00 | SPY | ETF | 381.6 | 381.63 | 381.47 | 381.49 | 17924.0 |
| 2022-12-23 07:40:00 | SPY | ETF | 381.5 | 381.5 | 381.42 | 381.42 | 2793.0 |
| 2022-12-23 07:45:00 | SPY | ETF | 381.56 | 381.58 | 381.53 | 381.58 | 1117.0 |
| 2022-12-23 07:50:00 | SPY | ETF | 381.56 | 381.62 | 381.52 | 381.62 | 10845.0 |
| 2022-12-23 07:55:00 | SPY | ETF | 381.69 | 381.69 | 381.63 | 381.63 | 1250.0 |
| 2022-12-23 08:00:00 | SPY | ETF | 381.56 | 382.38 | 380.69 | 381.77 | 48656.0 |
| 2022-12-23 08:05:00 | SPY | ETF | 381.82 | 381.93 | 381.65 | 381.75 | 38890.0 |
| 2022-12-23 08:10:00 | SPY | ETF | 381.74 | 381.78 | 381.65 | 381.77 | 25301.0 |
| 2022-12-23 08:15:00 | SPY | ETF | 381.78 | 381.95 | 381.77 | 381.83 | 21568.0 |
> showing 50 of 94,299 rows — these rows as CSV