PREVIEW / etf_5min / 2022-10-05
file: by_date/etf_5min/2022/2022-10-05.parquet size: 2.0 MB rows: 99,047
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-10-05 04:00:00 | SPY | ETF | 375.32 | 376.3 | 375.19 | 375.31 | 34867.0 |
| 2022-10-05 04:05:00 | SPY | ETF | 375.29 | 375.36 | 375.16 | 375.18 | 1161.0 |
| 2022-10-05 04:10:00 | SPY | ETF | 375.1 | 375.1 | 374.84 | 374.96 | 2687.0 |
| 2022-10-05 04:15:00 | SPY | ETF | 374.93 | 375.05 | 374.6 | 374.61 | 4269.0 |
| 2022-10-05 04:20:00 | SPY | ETF | 374.61 | 374.63 | 374.13 | 374.16 | 18318.0 |
| 2022-10-05 04:25:00 | SPY | ETF | 374.14 | 374.3 | 374.11 | 374.11 | 4700.0 |
| 2022-10-05 04:30:00 | SPY | ETF | 374.36 | 374.76 | 374.0 | 374.61 | 7985.0 |
| 2022-10-05 04:35:00 | SPY | ETF | 374.7 | 374.92 | 374.7 | 374.86 | 7149.0 |
| 2022-10-05 04:40:00 | SPY | ETF | 374.91 | 374.92 | 374.64 | 374.64 | 3575.0 |
| 2022-10-05 04:45:00 | SPY | ETF | 374.76 | 375.07 | 374.76 | 375.07 | 2500.0 |
| 2022-10-05 04:50:00 | SPY | ETF | 375.11 | 375.31 | 374.99 | 374.99 | 2451.0 |
| 2022-10-05 04:55:00 | SPY | ETF | 375.1 | 375.18 | 375.0 | 375.0 | 4625.0 |
| 2022-10-05 05:00:00 | SPY | ETF | 374.98 | 374.98 | 374.62 | 374.8 | 15350.0 |
| 2022-10-05 05:05:00 | SPY | ETF | 374.94 | 374.94 | 374.47 | 374.67 | 14775.0 |
| 2022-10-05 05:10:00 | SPY | ETF | 374.67 | 375.0 | 374.67 | 374.94 | 6820.0 |
| 2022-10-05 05:15:00 | SPY | ETF | 374.99 | 375.16 | 374.89 | 374.89 | 3756.0 |
| 2022-10-05 05:20:00 | SPY | ETF | 374.73 | 375.0 | 374.7 | 374.95 | 2340.0 |
| 2022-10-05 05:25:00 | SPY | ETF | 374.77 | 375.0 | 374.76 | 375.0 | 4498.0 |
| 2022-10-05 05:30:00 | SPY | ETF | 375.04 | 375.04 | 374.8 | 374.82 | 1248.0 |
| 2022-10-05 05:35:00 | SPY | ETF | 374.9 | 374.9 | 374.8 | 374.82 | 900.0 |
| 2022-10-05 05:40:00 | SPY | ETF | 374.59 | 374.59 | 374.36 | 374.36 | 9509.0 |
| 2022-10-05 05:45:00 | SPY | ETF | 374.36 | 374.4 | 374.17 | 374.25 | 5879.0 |
| 2022-10-05 05:50:00 | SPY | ETF | 374.19 | 374.25 | 373.93 | 373.93 | 13925.0 |
| 2022-10-05 05:55:00 | SPY | ETF | 373.91 | 374.1 | 373.81 | 374.1 | 42581.0 |
| 2022-10-05 06:00:00 | SPY | ETF | 374.11 | 374.58 | 374.11 | 374.58 | 10987.0 |
| 2022-10-05 06:05:00 | SPY | ETF | 374.58 | 374.6 | 374.42 | 374.47 | 16524.0 |
| 2022-10-05 06:10:00 | SPY | ETF | 374.43 | 374.43 | 374.36 | 374.4 | 13048.0 |
| 2022-10-05 06:15:00 | SPY | ETF | 374.45 | 374.45 | 374.17 | 374.23 | 2399.0 |
| 2022-10-05 06:20:00 | SPY | ETF | 374.16 | 374.35 | 374.12 | 374.35 | 1961.0 |
| 2022-10-05 06:25:00 | SPY | ETF | 374.47 | 374.78 | 374.47 | 374.7 | 1200.0 |
| 2022-10-05 06:30:00 | SPY | ETF | 374.85 | 375.13 | 374.84 | 374.96 | 7490.0 |
| 2022-10-05 06:35:00 | SPY | ETF | 374.97 | 375.04 | 374.72 | 374.78 | 7279.0 |
| 2022-10-05 06:40:00 | SPY | ETF | 374.85 | 375.19 | 374.85 | 375.11 | 18871.0 |
| 2022-10-05 06:45:00 | SPY | ETF | 375.04 | 375.12 | 374.99 | 375.05 | 16605.0 |
| 2022-10-05 06:50:00 | SPY | ETF | 375.02 | 375.25 | 374.95 | 375.23 | 3305.0 |
| 2022-10-05 06:55:00 | SPY | ETF | 375.15 | 375.25 | 375.15 | 375.25 | 5360.0 |
| 2022-10-05 07:00:00 | SPY | ETF | 375.3 | 375.39 | 375.18 | 375.28 | 16311.0 |
| 2022-10-05 07:05:00 | SPY | ETF | 375.25 | 375.3 | 375.07 | 375.14 | 9624.0 |
| 2022-10-05 07:10:00 | SPY | ETF | 375.15 | 375.15 | 374.64 | 374.83 | 15210.0 |
| 2022-10-05 07:15:00 | SPY | ETF | 374.8 | 375.0 | 374.66 | 374.73 | 6861.0 |
| 2022-10-05 07:20:00 | SPY | ETF | 374.7 | 374.72 | 374.45 | 374.6 | 21360.0 |
| 2022-10-05 07:25:00 | SPY | ETF | 374.65 | 374.89 | 374.59 | 374.89 | 25990.0 |
| 2022-10-05 07:30:00 | SPY | ETF | 374.88 | 375.38 | 374.74 | 374.86 | 48867.0 |
| 2022-10-05 07:35:00 | SPY | ETF | 374.88 | 374.88 | 374.36 | 374.4 | 40030.0 |
| 2022-10-05 07:40:00 | SPY | ETF | 374.39 | 374.65 | 374.34 | 374.43 | 9770.0 |
| 2022-10-05 07:45:00 | SPY | ETF | 374.5 | 374.67 | 374.38 | 374.38 | 12838.0 |
| 2022-10-05 07:50:00 | SPY | ETF | 374.38 | 374.48 | 374.35 | 374.4 | 13597.0 |
| 2022-10-05 07:55:00 | SPY | ETF | 374.41 | 374.65 | 374.19 | 374.56 | 32932.0 |
| 2022-10-05 08:00:00 | SPY | ETF | 375.24 | 376.4 | 374.14 | 374.55 | 112924.0 |
| 2022-10-05 08:05:00 | SPY | ETF | 374.58 | 374.59 | 374.2 | 374.278 | 45094.0 |
> showing 50 of 99,047 rows — these rows as CSV