PREVIEW / etf_5min / 2022-05-09
file: by_date/etf_5min/2022/2022-05-09.parquet size: 2.2 MB rows: 109,993
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-05-09 04:00:00 | SPY | ETF | 406.64 | 407.7 | 406.0 | 406.15 | 27476.0 |
| 2022-05-09 04:05:00 | SPY | ETF | 406.17 | 406.59 | 406.04 | 406.59 | 4890.0 |
| 2022-05-09 04:10:00 | SPY | ETF | 406.58 | 406.75 | 406.45 | 406.54 | 7100.0 |
| 2022-05-09 04:15:00 | SPY | ETF | 406.56 | 406.74 | 406.16 | 406.22 | 5377.0 |
| 2022-05-09 04:20:00 | SPY | ETF | 406.21 | 406.4 | 405.92 | 405.92 | 9544.0 |
| 2022-05-09 04:25:00 | SPY | ETF | 406.13 | 406.15 | 405.7 | 405.9 | 3730.0 |
| 2022-05-09 04:30:00 | SPY | ETF | 405.8 | 405.8 | 404.84 | 404.84 | 9550.0 |
| 2022-05-09 04:35:00 | SPY | ETF | 404.85 | 405.23 | 404.73 | 405.23 | 12568.0 |
| 2022-05-09 04:40:00 | SPY | ETF | 405.22 | 405.43 | 405.22 | 405.38 | 449.0 |
| 2022-05-09 04:45:00 | SPY | ETF | 405.44 | 405.72 | 405.44 | 405.68 | 12807.0 |
| 2022-05-09 04:50:00 | SPY | ETF | 405.97 | 406.2 | 405.89 | 406.01 | 24016.0 |
| 2022-05-09 04:55:00 | SPY | ETF | 406.16 | 406.16 | 405.68 | 405.86 | 5072.0 |
| 2022-05-09 05:00:00 | SPY | ETF | 405.88 | 406.0 | 405.82 | 406.0 | 9820.0 |
| 2022-05-09 05:05:00 | SPY | ETF | 405.86 | 405.88 | 405.72 | 405.86 | 7488.0 |
| 2022-05-09 05:10:00 | SPY | ETF | 405.92 | 406.27 | 405.9 | 406.25 | 6244.0 |
| 2022-05-09 05:15:00 | SPY | ETF | 406.3 | 406.3 | 405.85 | 405.91 | 2315.0 |
| 2022-05-09 05:20:00 | SPY | ETF | 406.18 | 406.39 | 405.9 | 405.9 | 1900.0 |
| 2022-05-09 05:25:00 | SPY | ETF | 405.98 | 405.98 | 405.29 | 405.3 | 4750.0 |
| 2022-05-09 05:30:00 | SPY | ETF | 405.3 | 405.49 | 405.15 | 405.29 | 1600.0 |
| 2022-05-09 05:35:00 | SPY | ETF | 405.1 | 405.19 | 404.68 | 404.83 | 6954.0 |
| 2022-05-09 05:40:00 | SPY | ETF | 404.85 | 405.28 | 404.65 | 405.27 | 23435.0 |
| 2022-05-09 05:45:00 | SPY | ETF | 405.2 | 405.2 | 404.81 | 404.9 | 3872.0 |
| 2022-05-09 05:50:00 | SPY | ETF | 405.06 | 405.27 | 404.94 | 404.94 | 9976.0 |
| 2022-05-09 05:55:00 | SPY | ETF | 405.06 | 405.2 | 404.62 | 405.2 | 9290.0 |
| 2022-05-09 06:00:00 | SPY | ETF | 405.16 | 405.16 | 404.9 | 404.98 | 6392.0 |
| 2022-05-09 06:05:00 | SPY | ETF | 405.0 | 405.15 | 404.85 | 404.85 | 3353.0 |
| 2022-05-09 06:10:00 | SPY | ETF | 404.85 | 404.85 | 404.63 | 404.65 | 32653.0 |
| 2022-05-09 06:15:00 | SPY | ETF | 404.65 | 404.91 | 404.55 | 404.7 | 36472.0 |
| 2022-05-09 06:20:00 | SPY | ETF | 404.75 | 404.77 | 404.62 | 404.69 | 2553.0 |
| 2022-05-09 06:25:00 | SPY | ETF | 404.59 | 404.68 | 404.22 | 404.5 | 10498.0 |
| 2022-05-09 06:30:00 | SPY | ETF | 404.52 | 404.52 | 403.94 | 404.08 | 14818.0 |
| 2022-05-09 06:35:00 | SPY | ETF | 403.97 | 404.0 | 403.65 | 403.65 | 46344.0 |
| 2022-05-09 06:40:00 | SPY | ETF | 403.65 | 403.65 | 403.28 | 403.34 | 46140.0 |
| 2022-05-09 06:45:00 | SPY | ETF | 403.36 | 403.49 | 402.92 | 403.49 | 25243.0 |
| 2022-05-09 06:50:00 | SPY | ETF | 403.57 | 403.57 | 402.99 | 403.25 | 56234.0 |
| 2022-05-09 06:55:00 | SPY | ETF | 403.33 | 403.54 | 403.12 | 403.25 | 42554.0 |
| 2022-05-09 07:00:00 | SPY | ETF | 403.39 | 403.99 | 403.39 | 403.74 | 65106.0 |
| 2022-05-09 07:05:00 | SPY | ETF | 403.84 | 404.09 | 403.62 | 403.62 | 10466.0 |
| 2022-05-09 07:10:00 | SPY | ETF | 403.86 | 403.86 | 403.31 | 403.5 | 13607.0 |
| 2022-05-09 07:15:00 | SPY | ETF | 403.5 | 403.67 | 403.24 | 403.36 | 46755.0 |
| 2022-05-09 07:20:00 | SPY | ETF | 403.3 | 403.3 | 402.75 | 403.0 | 64275.0 |
| 2022-05-09 07:25:00 | SPY | ETF | 403.06 | 403.11 | 402.84 | 402.9 | 27956.0 |
| 2022-05-09 07:30:00 | SPY | ETF | 402.89 | 403.41 | 402.69 | 403.41 | 40263.0 |
| 2022-05-09 07:35:00 | SPY | ETF | 403.39 | 403.77 | 403.19 | 403.29 | 41334.0 |
| 2022-05-09 07:40:00 | SPY | ETF | 403.3 | 403.5 | 402.95 | 403.34 | 25972.0 |
| 2022-05-09 07:45:00 | SPY | ETF | 403.2 | 403.94 | 403.12 | 403.91 | 49282.0 |
| 2022-05-09 07:50:00 | SPY | ETF | 403.91 | 404.51 | 403.76 | 404.51 | 106393.0 |
| 2022-05-09 07:55:00 | SPY | ETF | 404.52 | 404.79 | 404.23 | 404.54 | 85911.0 |
| 2022-05-09 08:00:00 | SPY | ETF | 403.4699 | 408.56 | 402.7299 | 404.85 | 106395.0 |
| 2022-05-09 08:05:00 | SPY | ETF | 404.88 | 405.51 | 404.61 | 405.0 | 128008.0 |
> showing 50 of 109,993 rows — these rows as CSV