PREVIEW / etf_5min / 2022-09-26
file: by_date/etf_5min/2022/2022-09-26.parquet size: 2.1 MB rows: 103,412
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-09-26 04:00:00 | SPY | ETF | 367.17 | 367.26 | 365.9 | 367.15 | 17958.0 |
| 2022-09-26 04:05:00 | SPY | ETF | 367.09 | 367.13 | 366.71 | 366.89 | 8400.0 |
| 2022-09-26 04:10:00 | SPY | ETF | 366.98 | 367.13 | 366.98 | 367.1 | 4206.0 |
| 2022-09-26 04:15:00 | SPY | ETF | 366.88 | 367.09 | 366.68 | 366.68 | 2200.0 |
| 2022-09-26 04:20:00 | SPY | ETF | 367.09 | 367.45 | 367.09 | 367.45 | 8190.0 |
| 2022-09-26 04:25:00 | SPY | ETF | 367.65 | 368.03 | 367.65 | 368.03 | 3200.0 |
| 2022-09-26 04:30:00 | SPY | ETF | 368.14 | 368.22 | 367.88 | 367.88 | 5664.0 |
| 2022-09-26 04:35:00 | SPY | ETF | 367.81 | 367.81 | 367.57 | 367.59 | 2900.0 |
| 2022-09-26 04:40:00 | SPY | ETF | 367.41 | 367.76 | 367.37 | 367.76 | 1500.0 |
| 2022-09-26 04:45:00 | SPY | ETF | 367.84 | 367.91 | 367.52 | 367.69 | 1500.0 |
| 2022-09-26 04:50:00 | SPY | ETF | 367.61 | 367.77 | 367.61 | 367.77 | 600.0 |
| 2022-09-26 04:55:00 | SPY | ETF | 367.46 | 367.6 | 367.44 | 367.6 | 3170.0 |
| 2022-09-26 05:00:00 | SPY | ETF | 367.54 | 367.76 | 367.45 | 367.58 | 3028.0 |
| 2022-09-26 05:05:00 | SPY | ETF | 367.39 | 367.39 | 367.01 | 367.01 | 4798.0 |
| 2022-09-26 05:10:00 | SPY | ETF | 367.08 | 367.19 | 367.0 | 367.0 | 2440.0 |
| 2022-09-26 05:15:00 | SPY | ETF | 366.88 | 366.97 | 366.79 | 366.83 | 8532.0 |
| 2022-09-26 05:20:00 | SPY | ETF | 366.64 | 366.64 | 366.3 | 366.33 | 4130.0 |
| 2022-09-26 05:25:00 | SPY | ETF | 366.2 | 366.23 | 365.82 | 366.0 | 16935.0 |
| 2022-09-26 05:30:00 | SPY | ETF | 365.99 | 366.01 | 365.54 | 365.56 | 2700.0 |
| 2022-09-26 05:35:00 | SPY | ETF | 365.58 | 365.64 | 364.88 | 364.88 | 15808.0 |
| 2022-09-26 05:40:00 | SPY | ETF | 364.83 | 364.98 | 364.44 | 364.98 | 20540.0 |
| 2022-09-26 05:45:00 | SPY | ETF | 364.8 | 364.8 | 364.74 | 364.76 | 2243.0 |
| 2022-09-26 05:50:00 | SPY | ETF | 365.15 | 365.34 | 364.96 | 365.26 | 4780.0 |
| 2022-09-26 05:55:00 | SPY | ETF | 365.01 | 365.03 | 364.82 | 364.82 | 4454.0 |
| 2022-09-26 06:00:00 | SPY | ETF | 365.08 | 365.26 | 365.03 | 365.26 | 3950.0 |
| 2022-09-26 06:05:00 | SPY | ETF | 365.18 | 365.21 | 365.01 | 365.02 | 12668.0 |
| 2022-09-26 06:10:00 | SPY | ETF | 365.09 | 365.09 | 364.43 | 364.89 | 4080.0 |
| 2022-09-26 06:15:00 | SPY | ETF | 364.94 | 365.41 | 364.94 | 365.22 | 5550.0 |
| 2022-09-26 06:20:00 | SPY | ETF | 365.27 | 365.27 | 365.16 | 365.26 | 2019.0 |
| 2022-09-26 06:25:00 | SPY | ETF | 365.36 | 365.96 | 365.36 | 365.87 | 7005.0 |
| 2022-09-26 06:30:00 | SPY | ETF | 365.84 | 365.84 | 365.67 | 365.75 | 10086.0 |
| 2022-09-26 06:35:00 | SPY | ETF | 365.72 | 365.72 | 365.38 | 365.59 | 3730.0 |
| 2022-09-26 06:40:00 | SPY | ETF | 365.5 | 365.64 | 365.45 | 365.64 | 11200.0 |
| 2022-09-26 06:45:00 | SPY | ETF | 365.71 | 365.99 | 365.65 | 365.87 | 4023.0 |
| 2022-09-26 06:50:00 | SPY | ETF | 365.78 | 365.85 | 365.52 | 365.85 | 35520.0 |
| 2022-09-26 06:55:00 | SPY | ETF | 365.9 | 366.0 | 365.3 | 365.4 | 80884.0 |
| 2022-09-26 07:00:00 | SPY | ETF | 365.32 | 365.5 | 365.16 | 365.42 | 37063.0 |
| 2022-09-26 07:05:00 | SPY | ETF | 365.45 | 365.5 | 364.91 | 364.92 | 51364.0 |
| 2022-09-26 07:10:00 | SPY | ETF | 364.92 | 365.05 | 364.81 | 365.05 | 23683.0 |
| 2022-09-26 07:15:00 | SPY | ETF | 365.08 | 365.48 | 365.08 | 365.48 | 18555.0 |
| 2022-09-26 07:20:00 | SPY | ETF | 365.43 | 365.55 | 365.05 | 365.43 | 35157.0 |
| 2022-09-26 07:25:00 | SPY | ETF | 365.46 | 365.68 | 365.4 | 365.65 | 8102.0 |
| 2022-09-26 07:30:00 | SPY | ETF | 365.59 | 365.93 | 365.54 | 365.89 | 43737.0 |
| 2022-09-26 07:35:00 | SPY | ETF | 365.84 | 366.0 | 365.6 | 365.93 | 33332.0 |
| 2022-09-26 07:40:00 | SPY | ETF | 365.92 | 365.95 | 365.6 | 365.89 | 15163.0 |
| 2022-09-26 07:45:00 | SPY | ETF | 365.75 | 365.75 | 365.6 | 365.6 | 12160.0 |
| 2022-09-26 07:50:00 | SPY | ETF | 365.6 | 365.72 | 365.5 | 365.64 | 20823.0 |
| 2022-09-26 07:55:00 | SPY | ETF | 365.64 | 365.94 | 365.63 | 365.76 | 28372.0 |
| 2022-09-26 08:00:00 | SPY | ETF | 365.8 | 368.7 | 364.7396 | 365.41 | 134679.0 |
| 2022-09-26 08:05:00 | SPY | ETF | 365.41 | 365.42 | 365.01 | 365.03 | 50686.0 |
> showing 50 of 103,412 rows — these rows as CSV