PREVIEW / etf_5min / 2022-09-09
file: by_date/etf_5min/2022/2022-09-09.parquet size: 1.8 MB rows: 89,150
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-09 04:00:00 | SPY | ETF | 402.02 | 402.63 | 402.02 | 402.55 | 7379.0 |
| 2022-09-09 04:05:00 | SPY | ETF | 402.56 | 402.82 | 402.56 | 402.81 | 3981.0 |
| 2022-09-09 04:10:00 | SPY | ETF | 402.8 | 403.02 | 402.78 | 403.02 | 2526.0 |
| 2022-09-09 04:15:00 | SPY | ETF | 403.07 | 403.5 | 403.02 | 403.45 | 4230.0 |
| 2022-09-09 04:20:00 | SPY | ETF | 403.53 | 403.67 | 403.45 | 403.6 | 2850.0 |
| 2022-09-09 04:25:00 | SPY | ETF | 403.61 | 403.69 | 403.54 | 403.62 | 3200.0 |
| 2022-09-09 04:30:00 | SPY | ETF | 403.7 | 403.7 | 403.37 | 403.37 | 2475.0 |
| 2022-09-09 04:35:00 | SPY | ETF | 403.5 | 403.5 | 403.2 | 403.2 | 5000.0 |
| 2022-09-09 04:40:00 | SPY | ETF | 403.15 | 403.56 | 403.12 | 403.51 | 2805.0 |
| 2022-09-09 04:45:00 | SPY | ETF | 403.6 | 403.73 | 403.6 | 403.7 | 9225.0 |
| 2022-09-09 04:50:00 | SPY | ETF | 403.73 | 403.73 | 403.68 | 403.7 | 3194.0 |
| 2022-09-09 04:55:00 | SPY | ETF | 403.72 | 403.79 | 403.69 | 403.69 | 745.0 |
| 2022-09-09 05:00:00 | SPY | ETF | 403.71 | 403.79 | 403.5 | 403.79 | 3400.0 |
| 2022-09-09 05:05:00 | SPY | ETF | 403.7 | 403.7 | 403.44 | 403.69 | 7399.0 |
| 2022-09-09 05:10:00 | SPY | ETF | 403.73 | 403.75 | 403.67 | 403.71 | 1357.0 |
| 2022-09-09 05:15:00 | SPY | ETF | 403.7 | 403.7 | 403.58 | 403.58 | 300.0 |
| 2022-09-09 05:20:00 | SPY | ETF | 403.5 | 403.77 | 403.5 | 403.77 | 1015.0 |
| 2022-09-09 05:25:00 | SPY | ETF | 403.56 | 403.65 | 403.56 | 403.58 | 2729.0 |
| 2022-09-09 05:30:00 | SPY | ETF | 403.66 | 403.67 | 403.66 | 403.67 | 250.0 |
| 2022-09-09 05:35:00 | SPY | ETF | 403.6 | 403.65 | 403.6 | 403.65 | 200.0 |
| 2022-09-09 05:40:00 | SPY | ETF | 403.75 | 403.79 | 403.46 | 403.46 | 2150.0 |
| 2022-09-09 05:45:00 | SPY | ETF | 403.42 | 403.42 | 403.38 | 403.38 | 400.0 |
| 2022-09-09 05:50:00 | SPY | ETF | 403.3 | 403.34 | 403.11 | 403.11 | 8949.0 |
| 2022-09-09 05:55:00 | SPY | ETF | 403.25 | 403.37 | 403.25 | 403.37 | 490.0 |
| 2022-09-09 06:00:00 | SPY | ETF | 403.53 | 403.54 | 403.33 | 403.33 | 1900.0 |
| 2022-09-09 06:05:00 | SPY | ETF | 403.29 | 403.31 | 403.11 | 403.11 | 18843.0 |
| 2022-09-09 06:10:00 | SPY | ETF | 403.21 | 403.28 | 403.18 | 403.27 | 2481.0 |
| 2022-09-09 06:15:00 | SPY | ETF | 403.27 | 403.64 | 403.21 | 403.33 | 8540.0 |
| 2022-09-09 06:20:00 | SPY | ETF | 403.27 | 403.57 | 403.24 | 403.57 | 6298.0 |
| 2022-09-09 06:25:00 | SPY | ETF | 403.56 | 403.61 | 403.56 | 403.61 | 1627.0 |
| 2022-09-09 06:30:00 | SPY | ETF | 403.64 | 403.81 | 403.63 | 403.78 | 4040.0 |
| 2022-09-09 06:35:00 | SPY | ETF | 403.74 | 404.09 | 403.67 | 404.03 | 21563.0 |
| 2022-09-09 06:40:00 | SPY | ETF | 404.05 | 404.17 | 404.0 | 404.17 | 5606.0 |
| 2022-09-09 06:45:00 | SPY | ETF | 404.1 | 404.28 | 404.1 | 404.15 | 27295.0 |
| 2022-09-09 06:50:00 | SPY | ETF | 404.17 | 404.19 | 404.03 | 404.07 | 11905.0 |
| 2022-09-09 06:55:00 | SPY | ETF | 404.02 | 404.04 | 403.9 | 403.94 | 6960.0 |
| 2022-09-09 07:00:00 | SPY | ETF | 403.91 | 403.96 | 403.66 | 403.66 | 16276.0 |
| 2022-09-09 07:05:00 | SPY | ETF | 403.7 | 403.87 | 403.7 | 403.81 | 9202.0 |
| 2022-09-09 07:10:00 | SPY | ETF | 403.8 | 403.8 | 403.6 | 403.78 | 18385.0 |
| 2022-09-09 07:15:00 | SPY | ETF | 403.78 | 403.87 | 403.61 | 403.69 | 25294.0 |
| 2022-09-09 07:20:00 | SPY | ETF | 403.64 | 403.7 | 403.46 | 403.46 | 12323.0 |
| 2022-09-09 07:25:00 | SPY | ETF | 403.44 | 403.61 | 403.44 | 403.58 | 13396.0 |
| 2022-09-09 07:30:00 | SPY | ETF | 403.54 | 403.54 | 403.25 | 403.25 | 6270.0 |
| 2022-09-09 07:35:00 | SPY | ETF | 403.32 | 403.53 | 403.32 | 403.49 | 10078.0 |
| 2022-09-09 07:40:00 | SPY | ETF | 403.4 | 403.54 | 403.4 | 403.5 | 12451.0 |
| 2022-09-09 07:45:00 | SPY | ETF | 403.47 | 403.54 | 403.43 | 403.49 | 6555.0 |
| 2022-09-09 07:50:00 | SPY | ETF | 403.46 | 403.48 | 403.36 | 403.43 | 2555.0 |
| 2022-09-09 07:55:00 | SPY | ETF | 403.3 | 403.45 | 403.17 | 403.38 | 11410.0 |
| 2022-09-09 08:00:00 | SPY | ETF | 403.67 | 403.8499 | 401.1 | 403.26 | 46747.0 |
| 2022-09-09 08:05:00 | SPY | ETF | 403.19 | 403.19 | 403.0 | 403.02 | 16068.0 |
> showing 50 of 89,150 rows — these rows as CSV