PREVIEW / etf_5min / 2022-06-06
file: by_date/etf_5min/2022/2022-06-06.parquet size: 1.9 MB rows: 92,235
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-06-06 04:00:00 | SPY | ETF | 414.35 | 414.88 | 412.8 | 414.82 | 12024.0 |
| 2022-06-06 04:05:00 | SPY | ETF | 414.76 | 414.77 | 414.63 | 414.69 | 13450.0 |
| 2022-06-06 04:10:00 | SPY | ETF | 414.67 | 415.21 | 414.67 | 415.2 | 16407.0 |
| 2022-06-06 04:15:00 | SPY | ETF | 415.27 | 415.33 | 415.03 | 415.03 | 1600.0 |
| 2022-06-06 04:20:00 | SPY | ETF | 415.06 | 415.11 | 415.03 | 415.11 | 400.0 |
| 2022-06-06 04:25:00 | SPY | ETF | 415.13 | 415.23 | 415.13 | 415.2 | 5348.0 |
| 2022-06-06 04:30:00 | SPY | ETF | 415.3 | 415.45 | 415.02 | 415.02 | 3732.0 |
| 2022-06-06 04:35:00 | SPY | ETF | 415.07 | 415.07 | 415.05 | 415.07 | 499.0 |
| 2022-06-06 04:40:00 | SPY | ETF | 415.16 | 415.17 | 415.08 | 415.11 | 1077.0 |
| 2022-06-06 04:45:00 | SPY | ETF | 415.12 | 415.16 | 414.92 | 415.16 | 3239.0 |
| 2022-06-06 04:50:00 | SPY | ETF | 415.18 | 415.37 | 415.18 | 415.37 | 4114.0 |
| 2022-06-06 04:55:00 | SPY | ETF | 415.26 | 415.33 | 415.26 | 415.33 | 500.0 |
| 2022-06-06 05:00:00 | SPY | ETF | 415.37 | 415.37 | 415.13 | 415.16 | 5202.0 |
| 2022-06-06 05:05:00 | SPY | ETF | 415.03 | 415.05 | 415.03 | 415.05 | 411.0 |
| 2022-06-06 05:10:00 | SPY | ETF | 414.97 | 415.05 | 414.97 | 415.05 | 1797.0 |
| 2022-06-06 05:15:00 | SPY | ETF | 415.03 | 415.05 | 414.99 | 415.03 | 2426.0 |
| 2022-06-06 05:20:00 | SPY | ETF | 414.89 | 414.93 | 414.85 | 414.93 | 1100.0 |
| 2022-06-06 05:25:00 | SPY | ETF | 414.81 | 414.82 | 414.72 | 414.72 | 3900.0 |
| 2022-06-06 05:30:00 | SPY | ETF | 414.82 | 414.82 | 414.7 | 414.7 | 1735.0 |
| 2022-06-06 05:35:00 | SPY | ETF | 414.61 | 414.61 | 414.5 | 414.5 | 274.0 |
| 2022-06-06 05:40:00 | SPY | ETF | 414.38 | 414.49 | 414.26 | 414.28 | 2020.0 |
| 2022-06-06 05:45:00 | SPY | ETF | 414.45 | 414.5 | 414.36 | 414.47 | 8599.0 |
| 2022-06-06 05:50:00 | SPY | ETF | 414.56 | 414.56 | 414.56 | 414.56 | 400.0 |
| 2022-06-06 05:55:00 | SPY | ETF | 414.4 | 414.42 | 414.38 | 414.42 | 1616.0 |
| 2022-06-06 06:00:00 | SPY | ETF | 414.57 | 414.86 | 414.56 | 414.83 | 5415.0 |
| 2022-06-06 06:05:00 | SPY | ETF | 414.75 | 414.8 | 414.68 | 414.8 | 820.0 |
| 2022-06-06 06:10:00 | SPY | ETF | 414.78 | 414.78 | 414.73 | 414.73 | 798.0 |
| 2022-06-06 06:15:00 | SPY | ETF | 414.68 | 414.68 | 414.68 | 414.68 | 3000.0 |
| 2022-06-06 06:20:00 | SPY | ETF | 414.7 | 414.83 | 414.7 | 414.83 | 900.0 |
| 2022-06-06 06:25:00 | SPY | ETF | 414.88 | 414.92 | 414.88 | 414.88 | 4048.0 |
| 2022-06-06 06:30:00 | SPY | ETF | 414.92 | 414.92 | 414.87 | 414.91 | 4802.0 |
| 2022-06-06 06:35:00 | SPY | ETF | 414.95 | 414.95 | 414.95 | 414.95 | 100.0 |
| 2022-06-06 06:40:00 | SPY | ETF | 414.82 | 414.82 | 414.82 | 414.82 | 100.0 |
| 2022-06-06 06:45:00 | SPY | ETF | 414.88 | 414.92 | 414.85 | 414.85 | 8033.0 |
| 2022-06-06 06:50:00 | SPY | ETF | 414.85 | 415.04 | 414.85 | 414.97 | 12064.0 |
| 2022-06-06 06:55:00 | SPY | ETF | 415.03 | 415.03 | 414.93 | 414.95 | 9700.0 |
| 2022-06-06 07:00:00 | SPY | ETF | 414.97 | 414.97 | 414.67 | 414.75 | 26292.0 |
| 2022-06-06 07:05:00 | SPY | ETF | 414.71 | 414.77 | 414.63 | 414.76 | 24080.0 |
| 2022-06-06 07:10:00 | SPY | ETF | 414.71 | 414.73 | 414.68 | 414.72 | 7845.0 |
| 2022-06-06 07:15:00 | SPY | ETF | 414.65 | 414.87 | 414.65 | 414.85 | 7428.0 |
| 2022-06-06 07:20:00 | SPY | ETF | 414.9 | 415.0 | 414.87 | 415.0 | 10799.0 |
| 2022-06-06 07:25:00 | SPY | ETF | 415.01 | 415.01 | 414.86 | 414.95 | 3435.0 |
| 2022-06-06 07:30:00 | SPY | ETF | 415.01 | 415.09 | 414.9 | 414.9 | 6289.0 |
| 2022-06-06 07:35:00 | SPY | ETF | 414.91 | 414.91 | 414.84 | 414.84 | 1300.0 |
| 2022-06-06 07:40:00 | SPY | ETF | 414.78 | 414.78 | 414.67 | 414.67 | 18833.0 |
| 2022-06-06 07:45:00 | SPY | ETF | 414.69 | 414.74 | 414.27 | 414.34 | 6599.0 |
| 2022-06-06 07:50:00 | SPY | ETF | 414.31 | 414.78 | 414.3 | 414.76 | 13189.0 |
| 2022-06-06 07:55:00 | SPY | ETF | 414.84 | 415.08 | 414.73 | 415.08 | 27299.0 |
| 2022-06-06 08:00:00 | SPY | ETF | 415.07 | 415.15 | 412.2 | 414.9304 | 60201.0 |
| 2022-06-06 08:05:00 | SPY | ETF | 414.91 | 415.28 | 414.9 | 415.08 | 37962.0 |
> showing 50 of 92,235 rows — these rows as CSV