PREVIEW / etf_5min / 2022-09-30
file: by_date/etf_5min/2022/2022-09-30.parquet size: 2.0 MB rows: 98,499
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-30 04:00:00 | SPY | ETF | 366.02 | 366.13 | 365.87 | 366.02 | 12077.0 |
| 2022-09-30 04:05:00 | SPY | ETF | 365.89 | 365.92 | 365.49 | 365.49 | 8157.0 |
| 2022-09-30 04:10:00 | SPY | ETF | 365.5 | 365.75 | 365.48 | 365.75 | 2760.0 |
| 2022-09-30 04:15:00 | SPY | ETF | 365.72 | 366.2 | 365.71 | 366.09 | 4509.0 |
| 2022-09-30 04:20:00 | SPY | ETF | 366.05 | 366.05 | 365.73 | 365.94 | 9350.0 |
| 2022-09-30 04:25:00 | SPY | ETF | 366.23 | 366.23 | 365.8 | 365.8 | 5790.0 |
| 2022-09-30 04:30:00 | SPY | ETF | 365.9 | 366.09 | 365.68 | 365.9 | 4647.0 |
| 2022-09-30 04:35:00 | SPY | ETF | 365.85 | 365.85 | 365.51 | 365.69 | 6250.0 |
| 2022-09-30 04:40:00 | SPY | ETF | 365.56 | 365.7 | 365.51 | 365.7 | 1900.0 |
| 2022-09-30 04:45:00 | SPY | ETF | 365.85 | 365.98 | 365.69 | 365.84 | 5410.0 |
| 2022-09-30 04:50:00 | SPY | ETF | 365.81 | 366.64 | 365.81 | 366.55 | 11013.0 |
| 2022-09-30 04:55:00 | SPY | ETF | 366.64 | 366.75 | 366.55 | 366.66 | 4814.0 |
| 2022-09-30 05:00:00 | SPY | ETF | 366.5 | 366.5 | 366.0 | 366.05 | 18896.0 |
| 2022-09-30 05:05:00 | SPY | ETF | 366.2 | 366.23 | 365.95 | 366.05 | 5025.0 |
| 2022-09-30 05:10:00 | SPY | ETF | 366.0 | 366.2 | 365.93 | 365.93 | 10800.0 |
| 2022-09-30 05:15:00 | SPY | ETF | 365.93 | 365.96 | 365.33 | 365.33 | 3157.0 |
| 2022-09-30 05:20:00 | SPY | ETF | 365.34 | 365.59 | 365.15 | 365.59 | 13403.0 |
| 2022-09-30 05:25:00 | SPY | ETF | 365.59 | 365.59 | 365.46 | 365.46 | 1310.0 |
| 2022-09-30 05:30:00 | SPY | ETF | 365.58 | 365.84 | 365.58 | 365.78 | 1400.0 |
| 2022-09-30 05:35:00 | SPY | ETF | 365.52 | 365.52 | 365.13 | 365.25 | 1230.0 |
| 2022-09-30 05:40:00 | SPY | ETF | 365.11 | 365.16 | 365.0 | 365.11 | 15488.0 |
| 2022-09-30 05:45:00 | SPY | ETF | 365.45 | 365.45 | 365.31 | 365.31 | 3150.0 |
| 2022-09-30 05:50:00 | SPY | ETF | 365.44 | 365.46 | 365.13 | 365.19 | 5900.0 |
| 2022-09-30 05:55:00 | SPY | ETF | 364.9 | 365.18 | 364.9 | 365.18 | 1450.0 |
| 2022-09-30 06:00:00 | SPY | ETF | 365.2 | 365.63 | 365.2 | 365.63 | 569.0 |
| 2022-09-30 06:05:00 | SPY | ETF | 365.82 | 365.89 | 365.62 | 365.89 | 4572.0 |
| 2022-09-30 06:10:00 | SPY | ETF | 365.9 | 366.25 | 365.89 | 366.24 | 15652.0 |
| 2022-09-30 06:15:00 | SPY | ETF | 366.2 | 366.33 | 365.84 | 365.9 | 2794.0 |
| 2022-09-30 06:20:00 | SPY | ETF | 365.74 | 365.74 | 365.44 | 365.67 | 13744.0 |
| 2022-09-30 06:25:00 | SPY | ETF | 365.76 | 366.36 | 365.74 | 366.18 | 7859.0 |
| 2022-09-30 06:30:00 | SPY | ETF | 366.03 | 366.3 | 365.85 | 365.92 | 15693.0 |
| 2022-09-30 06:35:00 | SPY | ETF | 365.92 | 366.15 | 365.79 | 365.79 | 9717.0 |
| 2022-09-30 06:40:00 | SPY | ETF | 365.92 | 365.92 | 365.62 | 365.62 | 1680.0 |
| 2022-09-30 06:45:00 | SPY | ETF | 365.55 | 365.55 | 364.99 | 365.25 | 62692.0 |
| 2022-09-30 06:50:00 | SPY | ETF | 365.13 | 365.13 | 364.5 | 364.7 | 52458.0 |
| 2022-09-30 06:55:00 | SPY | ETF | 364.72 | 364.72 | 364.34 | 364.5 | 80837.0 |
| 2022-09-30 07:00:00 | SPY | ETF | 364.6 | 364.76 | 364.27 | 364.29 | 29723.0 |
| 2022-09-30 07:05:00 | SPY | ETF | 364.27 | 364.41 | 363.98 | 364.02 | 89306.0 |
| 2022-09-30 07:10:00 | SPY | ETF | 363.91 | 364.0 | 363.69 | 363.94 | 56679.0 |
| 2022-09-30 07:15:00 | SPY | ETF | 363.97 | 364.18 | 363.89 | 364.17 | 58909.0 |
| 2022-09-30 07:20:00 | SPY | ETF | 364.17 | 364.29 | 364.05 | 364.16 | 32799.0 |
| 2022-09-30 07:25:00 | SPY | ETF | 364.12 | 364.45 | 364.02 | 364.43 | 45936.0 |
| 2022-09-30 07:30:00 | SPY | ETF | 364.35 | 364.39 | 363.86 | 363.9 | 28530.0 |
| 2022-09-30 07:35:00 | SPY | ETF | 363.84 | 363.86 | 363.47 | 363.84 | 32527.0 |
| 2022-09-30 07:40:00 | SPY | ETF | 363.8 | 363.86 | 363.62 | 363.63 | 23135.0 |
| 2022-09-30 07:45:00 | SPY | ETF | 363.56 | 363.56 | 363.0 | 363.16 | 100739.0 |
| 2022-09-30 07:50:00 | SPY | ETF | 363.29 | 363.31 | 363.0 | 363.22 | 85289.0 |
| 2022-09-30 07:55:00 | SPY | ETF | 363.21 | 363.72 | 363.18 | 363.7 | 43544.0 |
| 2022-09-30 08:00:00 | SPY | ETF | 363.68 | 366.5604 | 361.6 | 363.78 | 85448.0 |
| 2022-09-30 08:05:00 | SPY | ETF | 363.74 | 363.8 | 363.01 | 363.7 | 30190.0 |
> showing 50 of 98,499 rows — these rows as CSV