PREVIEW / etf_5min / 2023-05-22
file: by_date/etf_5min/2023/2023-05-22.parquet size: 1.9 MB rows: 92,923
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-22 04:00:00 | SPY | ETF | 418.05 | 418.51 | 418.05 | 418.42 | 1421.0 |
| 2023-05-22 04:05:00 | SPY | ETF | 418.41 | 418.47 | 418.36 | 418.47 | 3542.0 |
| 2023-05-22 04:10:00 | SPY | ETF | 418.47 | 418.5 | 418.46 | 418.5 | 1673.0 |
| 2023-05-22 04:15:00 | SPY | ETF | 418.5 | 418.52 | 418.46 | 418.5 | 5049.0 |
| 2023-05-22 04:20:00 | SPY | ETF | 418.55 | 418.58 | 418.54 | 418.56 | 2077.0 |
| 2023-05-22 04:25:00 | SPY | ETF | 418.68 | 418.89 | 418.65 | 418.79 | 6640.0 |
| 2023-05-22 04:30:00 | SPY | ETF | 418.83 | 418.84 | 418.76 | 418.76 | 735.0 |
| 2023-05-22 04:35:00 | SPY | ETF | 418.69 | 418.72 | 418.69 | 418.72 | 200.0 |
| 2023-05-22 04:40:00 | SPY | ETF | 418.71 | 418.82 | 418.71 | 418.82 | 700.0 |
| 2023-05-22 04:45:00 | SPY | ETF | 418.87 | 418.87 | 418.82 | 418.82 | 300.0 |
| 2023-05-22 04:50:00 | SPY | ETF | 418.8 | 418.8 | 418.7 | 418.75 | 1369.0 |
| 2023-05-22 04:55:00 | SPY | ETF | 418.74 | 418.74 | 418.74 | 418.74 | 100.0 |
| 2023-05-22 05:00:00 | SPY | ETF | 418.75 | 418.76 | 418.75 | 418.76 | 1400.0 |
| 2023-05-22 05:05:00 | SPY | ETF | 418.78 | 418.79 | 418.78 | 418.79 | 567.0 |
| 2023-05-22 05:10:00 | SPY | ETF | 418.73 | 418.74 | 418.64 | 418.64 | 1800.0 |
| 2023-05-22 05:15:00 | SPY | ETF | 418.75 | 418.77 | 418.75 | 418.77 | 370.0 |
| 2023-05-22 05:20:00 | SPY | ETF | 418.7 | 418.7 | 418.7 | 418.7 | 150.0 |
| 2023-05-22 05:25:00 | SPY | ETF | 418.76 | 418.78 | 418.65 | 418.67 | 6100.0 |
| 2023-05-22 05:30:00 | SPY | ETF | 418.67 | 418.67 | 418.57 | 418.57 | 201.0 |
| 2023-05-22 05:35:00 | SPY | ETF | 418.62 | 418.65 | 418.61 | 418.65 | 1553.0 |
| 2023-05-22 05:40:00 | SPY | ETF | 418.62 | 418.62 | 418.58 | 418.58 | 7100.0 |
| 2023-05-22 05:50:00 | SPY | ETF | 418.6 | 418.63 | 418.56 | 418.56 | 4762.0 |
| 2023-05-22 05:55:00 | SPY | ETF | 418.5 | 418.5 | 418.44 | 418.44 | 1900.0 |
| 2023-05-22 06:00:00 | SPY | ETF | 418.37 | 418.59 | 418.37 | 418.59 | 2105.0 |
| 2023-05-22 06:05:00 | SPY | ETF | 418.61 | 418.62 | 418.59 | 418.62 | 20779.0 |
| 2023-05-22 06:10:00 | SPY | ETF | 418.62 | 418.65 | 418.62 | 418.65 | 798.0 |
| 2023-05-22 06:15:00 | SPY | ETF | 418.66 | 418.71 | 418.65 | 418.71 | 781.0 |
| 2023-05-22 06:20:00 | SPY | ETF | 418.61 | 418.65 | 418.6 | 418.65 | 21101.0 |
| 2023-05-22 06:25:00 | SPY | ETF | 418.62 | 418.62 | 418.62 | 418.62 | 1200.0 |
| 2023-05-22 06:30:00 | SPY | ETF | 418.66 | 418.66 | 418.61 | 418.61 | 375.0 |
| 2023-05-22 06:35:00 | SPY | ETF | 418.59 | 418.59 | 418.59 | 418.59 | 200.0 |
| 2023-05-22 06:40:00 | SPY | ETF | 418.45 | 418.45 | 418.41 | 418.45 | 12300.0 |
| 2023-05-22 06:45:00 | SPY | ETF | 418.4 | 418.42 | 418.4 | 418.42 | 1160.0 |
| 2023-05-22 06:50:00 | SPY | ETF | 418.3 | 418.3 | 418.18 | 418.23 | 4643.0 |
| 2023-05-22 06:55:00 | SPY | ETF | 418.31 | 418.41 | 418.31 | 418.41 | 1697.0 |
| 2023-05-22 07:00:00 | SPY | ETF | 418.44 | 418.46 | 418.23 | 418.3 | 6914.0 |
| 2023-05-22 07:05:00 | SPY | ETF | 418.3 | 418.42 | 418.3 | 418.31 | 3601.0 |
| 2023-05-22 07:10:00 | SPY | ETF | 418.3 | 418.33 | 418.1 | 418.26 | 11204.0 |
| 2023-05-22 07:15:00 | SPY | ETF | 418.23 | 418.41 | 418.23 | 418.39 | 3005.0 |
| 2023-05-22 07:20:00 | SPY | ETF | 418.39 | 418.42 | 418.28 | 418.28 | 10264.0 |
| 2023-05-22 07:25:00 | SPY | ETF | 418.281 | 418.37 | 418.281 | 418.37 | 2845.0 |
| 2023-05-22 07:30:00 | SPY | ETF | 418.389 | 418.7 | 418.37 | 418.66 | 12033.0 |
| 2023-05-22 07:35:00 | SPY | ETF | 418.65 | 418.65 | 418.5 | 418.63 | 3699.0 |
| 2023-05-22 07:40:00 | SPY | ETF | 418.62 | 418.66 | 418.61 | 418.62 | 3962.0 |
| 2023-05-22 07:45:00 | SPY | ETF | 418.6 | 418.65 | 418.59 | 418.65 | 3858.0 |
| 2023-05-22 07:50:00 | SPY | ETF | 418.66 | 418.78 | 418.66 | 418.74 | 3923.0 |
| 2023-05-22 07:55:00 | SPY | ETF | 418.71 | 418.9 | 418.71 | 418.89 | 6219.0 |
| 2023-05-22 08:00:00 | SPY | ETF | 418.4013 | 419.05 | 418.1 | 419.05 | 66099.0 |
| 2023-05-22 08:05:00 | SPY | ETF | 419.02 | 419.04 | 418.9 | 418.9 | 15511.0 |
| 2023-05-22 08:10:00 | SPY | ETF | 418.9 | 418.93 | 418.82 | 418.89 | 12737.0 |
> showing 50 of 92,923 rows — these rows as CSV