PREVIEW / etf_5min / 2022-05-26
file: by_date/etf_5min/2022/2022-05-26.parquet size: 2.0 MB rows: 95,413
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-26 04:00:00 | SPY | ETF | 398.7 | 398.76 | 398.48 | 398.48 | 14438.0 |
| 2022-05-26 04:05:00 | SPY | ETF | 398.5 | 398.73 | 398.44 | 398.59 | 3688.0 |
| 2022-05-26 04:10:00 | SPY | ETF | 398.55 | 398.55 | 398.27 | 398.27 | 1219.0 |
| 2022-05-26 04:15:00 | SPY | ETF | 398.0 | 398.14 | 397.94 | 398.14 | 897.0 |
| 2022-05-26 04:20:00 | SPY | ETF | 397.93 | 397.93 | 397.79 | 397.85 | 12030.0 |
| 2022-05-26 04:25:00 | SPY | ETF | 397.67 | 397.67 | 397.48 | 397.53 | 8438.0 |
| 2022-05-26 04:30:00 | SPY | ETF | 397.5 | 397.5 | 397.27 | 397.27 | 4197.0 |
| 2022-05-26 04:35:00 | SPY | ETF | 397.2 | 397.2 | 396.8 | 396.96 | 6370.0 |
| 2022-05-26 04:40:00 | SPY | ETF | 397.03 | 397.03 | 396.9 | 396.98 | 809.0 |
| 2022-05-26 04:45:00 | SPY | ETF | 397.0 | 397.0 | 396.64 | 396.73 | 8454.0 |
| 2022-05-26 04:50:00 | SPY | ETF | 396.91 | 396.98 | 396.91 | 396.98 | 596.0 |
| 2022-05-26 04:55:00 | SPY | ETF | 397.05 | 397.05 | 396.98 | 397.0 | 700.0 |
| 2022-05-26 05:05:00 | SPY | ETF | 396.89 | 396.94 | 396.89 | 396.94 | 1801.0 |
| 2022-05-26 05:10:00 | SPY | ETF | 396.9 | 397.0 | 396.9 | 397.0 | 3097.0 |
| 2022-05-26 05:15:00 | SPY | ETF | 397.05 | 397.1 | 397.05 | 397.1 | 300.0 |
| 2022-05-26 05:20:00 | SPY | ETF | 397.11 | 397.5 | 397.11 | 397.5 | 3830.0 |
| 2022-05-26 05:25:00 | SPY | ETF | 397.6 | 397.77 | 397.45 | 397.45 | 2000.0 |
| 2022-05-26 05:30:00 | SPY | ETF | 397.48 | 397.48 | 397.43 | 397.43 | 450.0 |
| 2022-05-26 05:35:00 | SPY | ETF | 397.51 | 397.56 | 397.51 | 397.56 | 1200.0 |
| 2022-05-26 05:40:00 | SPY | ETF | 397.61 | 397.86 | 397.61 | 397.86 | 2000.0 |
| 2022-05-26 05:45:00 | SPY | ETF | 398.0 | 398.4 | 398.0 | 398.4 | 3000.0 |
| 2022-05-26 05:50:00 | SPY | ETF | 398.33 | 398.35 | 398.28 | 398.35 | 500.0 |
| 2022-05-26 05:55:00 | SPY | ETF | 398.39 | 398.54 | 398.3 | 398.33 | 3500.0 |
| 2022-05-26 06:00:00 | SPY | ETF | 398.3 | 398.5 | 398.3 | 398.35 | 1465.0 |
| 2022-05-26 06:05:00 | SPY | ETF | 398.45 | 398.7 | 398.45 | 398.7 | 12897.0 |
| 2022-05-26 06:10:00 | SPY | ETF | 398.66 | 398.75 | 398.33 | 398.35 | 6176.0 |
| 2022-05-26 06:15:00 | SPY | ETF | 398.2 | 398.2 | 398.1 | 398.1 | 2450.0 |
| 2022-05-26 06:20:00 | SPY | ETF | 398.15 | 398.15 | 398.12 | 398.12 | 450.0 |
| 2022-05-26 06:25:00 | SPY | ETF | 398.05 | 398.15 | 398.0 | 398.03 | 1654.0 |
| 2022-05-26 06:30:00 | SPY | ETF | 398.0 | 398.0 | 397.76 | 397.81 | 8800.0 |
| 2022-05-26 06:35:00 | SPY | ETF | 397.95 | 397.95 | 397.93 | 397.93 | 621.0 |
| 2022-05-26 06:40:00 | SPY | ETF | 397.91 | 397.91 | 397.88 | 397.9 | 405.0 |
| 2022-05-26 06:45:00 | SPY | ETF | 397.96 | 398.1 | 397.96 | 398.0 | 1318.0 |
| 2022-05-26 06:50:00 | SPY | ETF | 398.28 | 398.65 | 398.25 | 398.65 | 3437.0 |
| 2022-05-26 06:55:00 | SPY | ETF | 398.65 | 398.95 | 398.57 | 398.88 | 24616.0 |
| 2022-05-26 07:00:00 | SPY | ETF | 398.66 | 399.25 | 398.56 | 399.25 | 42143.0 |
| 2022-05-26 07:05:00 | SPY | ETF | 399.19 | 399.19 | 398.93 | 399.07 | 9996.0 |
| 2022-05-26 07:10:00 | SPY | ETF | 399.12 | 399.71 | 399.11 | 399.71 | 27665.0 |
| 2022-05-26 07:15:00 | SPY | ETF | 399.65 | 399.99 | 399.5 | 399.85 | 21667.0 |
| 2022-05-26 07:20:00 | SPY | ETF | 399.8 | 400.3 | 399.69 | 400.26 | 21652.0 |
| 2022-05-26 07:25:00 | SPY | ETF | 400.32 | 400.7 | 400.13 | 400.6 | 63899.0 |
| 2022-05-26 07:30:00 | SPY | ETF | 400.57 | 400.66 | 400.0 | 400.0 | 46656.0 |
| 2022-05-26 07:35:00 | SPY | ETF | 399.93 | 400.21 | 399.84 | 400.17 | 24232.0 |
| 2022-05-26 07:40:00 | SPY | ETF | 400.15 | 400.28 | 400.07 | 400.1 | 11201.0 |
| 2022-05-26 07:45:00 | SPY | ETF | 400.03 | 400.35 | 400.0 | 400.27 | 8573.0 |
| 2022-05-26 07:50:00 | SPY | ETF | 400.28 | 400.39 | 399.98 | 400.06 | 14502.0 |
| 2022-05-26 07:55:00 | SPY | ETF | 399.9 | 399.95 | 399.71 | 399.92 | 16868.0 |
| 2022-05-26 08:00:00 | SPY | ETF | 399.16 | 400.65 | 396.0 | 399.7 | 126077.0 |
| 2022-05-26 08:05:00 | SPY | ETF | 399.64 | 399.64 | 399.36 | 399.46 | 114143.0 |
| 2022-05-26 08:10:00 | SPY | ETF | 399.4 | 400.21 | 399.35 | 399.48 | 31031.0 |
> showing 50 of 95,413 rows — these rows as CSV