PREVIEW / etf_5min / 2022-11-10
file: by_date/etf_5min/2022/2022-11-10.parquet size: 2.1 MB rows: 104,457
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-11-10 04:00:00 | SPY | ETF | 374.88 | 374.99 | 374.71 | 374.81 | 3447.0 |
| 2022-11-10 04:05:00 | SPY | ETF | 374.77 | 375.05 | 374.77 | 375.0 | 3600.0 |
| 2022-11-10 04:10:00 | SPY | ETF | 374.99 | 375.1 | 374.95 | 374.95 | 7167.0 |
| 2022-11-10 04:15:00 | SPY | ETF | 375.0 | 375.0 | 374.71 | 374.81 | 1578.0 |
| 2022-11-10 04:20:00 | SPY | ETF | 374.89 | 375.11 | 374.89 | 375.01 | 1512.0 |
| 2022-11-10 04:25:00 | SPY | ETF | 375.01 | 375.09 | 375.01 | 375.03 | 908.0 |
| 2022-11-10 04:30:00 | SPY | ETF | 375.11 | 375.16 | 375.11 | 375.16 | 533.0 |
| 2022-11-10 04:35:00 | SPY | ETF | 375.14 | 375.25 | 375.14 | 375.25 | 394.0 |
| 2022-11-10 04:40:00 | SPY | ETF | 375.24 | 375.24 | 375.15 | 375.15 | 400.0 |
| 2022-11-10 04:45:00 | SPY | ETF | 375.18 | 375.36 | 375.18 | 375.25 | 1410.0 |
| 2022-11-10 04:50:00 | SPY | ETF | 375.35 | 375.35 | 375.2 | 375.2 | 795.0 |
| 2022-11-10 04:55:00 | SPY | ETF | 375.21 | 375.21 | 375.21 | 375.21 | 200.0 |
| 2022-11-10 05:00:00 | SPY | ETF | 375.29 | 375.29 | 375.16 | 375.19 | 383.0 |
| 2022-11-10 05:05:00 | SPY | ETF | 375.11 | 375.17 | 375.11 | 375.17 | 266.0 |
| 2022-11-10 05:10:00 | SPY | ETF | 375.16 | 375.17 | 374.91 | 374.91 | 602.0 |
| 2022-11-10 05:15:00 | SPY | ETF | 374.94 | 374.94 | 374.82 | 374.86 | 650.0 |
| 2022-11-10 05:20:00 | SPY | ETF | 374.73 | 374.73 | 374.67 | 374.67 | 700.0 |
| 2022-11-10 05:25:00 | SPY | ETF | 374.62 | 374.62 | 374.48 | 374.58 | 1699.0 |
| 2022-11-10 05:30:00 | SPY | ETF | 374.65 | 374.75 | 374.65 | 374.75 | 550.0 |
| 2022-11-10 05:35:00 | SPY | ETF | 374.51 | 374.51 | 374.51 | 374.51 | 200.0 |
| 2022-11-10 05:40:00 | SPY | ETF | 374.68 | 374.86 | 374.68 | 374.79 | 3208.0 |
| 2022-11-10 05:45:00 | SPY | ETF | 374.88 | 374.88 | 374.7 | 374.7 | 1090.0 |
| 2022-11-10 05:50:00 | SPY | ETF | 374.72 | 374.72 | 374.72 | 374.72 | 107.0 |
| 2022-11-10 05:55:00 | SPY | ETF | 374.88 | 375.5 | 374.85 | 375.5 | 3923.0 |
| 2022-11-10 06:00:00 | SPY | ETF | 375.53 | 375.55 | 374.68 | 375.1 | 27588.0 |
| 2022-11-10 06:05:00 | SPY | ETF | 375.1 | 375.1 | 375.1 | 375.1 | 200.0 |
| 2022-11-10 06:10:00 | SPY | ETF | 375.16 | 375.28 | 375.16 | 375.27 | 1127.0 |
| 2022-11-10 06:15:00 | SPY | ETF | 375.23 | 375.23 | 375.23 | 375.23 | 130.0 |
| 2022-11-10 06:20:00 | SPY | ETF | 375.3 | 375.6 | 375.3 | 375.59 | 1991.0 |
| 2022-11-10 06:25:00 | SPY | ETF | 375.51 | 375.57 | 375.41 | 375.41 | 11149.0 |
| 2022-11-10 06:30:00 | SPY | ETF | 375.35 | 375.39 | 375.25 | 375.25 | 10115.0 |
| 2022-11-10 06:35:00 | SPY | ETF | 375.3 | 375.58 | 375.3 | 375.54 | 3865.0 |
| 2022-11-10 06:40:00 | SPY | ETF | 375.57 | 375.78 | 375.57 | 375.64 | 2381.0 |
| 2022-11-10 06:45:00 | SPY | ETF | 375.64 | 375.8 | 375.47 | 375.47 | 3692.0 |
| 2022-11-10 06:50:00 | SPY | ETF | 375.47 | 375.51 | 375.34 | 375.34 | 2105.0 |
| 2022-11-10 06:55:00 | SPY | ETF | 375.41 | 375.41 | 375.31 | 375.31 | 1424.0 |
| 2022-11-10 07:00:00 | SPY | ETF | 375.28 | 375.29 | 375.07 | 375.15 | 10566.0 |
| 2022-11-10 07:05:00 | SPY | ETF | 375.2 | 375.36 | 375.1 | 375.23 | 10981.0 |
| 2022-11-10 07:10:00 | SPY | ETF | 375.32 | 375.48 | 375.25 | 375.35 | 20540.0 |
| 2022-11-10 07:15:00 | SPY | ETF | 375.32 | 375.32 | 375.2 | 375.2 | 30969.0 |
| 2022-11-10 07:20:00 | SPY | ETF | 375.31 | 375.34 | 374.92 | 375.04 | 21170.0 |
| 2022-11-10 07:25:00 | SPY | ETF | 375.0 | 375.08 | 374.95 | 375.0 | 11220.0 |
| 2022-11-10 07:30:00 | SPY | ETF | 375.03 | 375.03 | 374.88 | 374.91 | 5092.0 |
| 2022-11-10 07:35:00 | SPY | ETF | 374.91 | 374.91 | 374.77 | 374.82 | 20039.0 |
| 2022-11-10 07:40:00 | SPY | ETF | 374.78 | 374.92 | 374.73 | 374.87 | 6431.0 |
| 2022-11-10 07:45:00 | SPY | ETF | 374.82 | 375.01 | 374.77 | 374.88 | 12546.0 |
| 2022-11-10 07:50:00 | SPY | ETF | 374.97 | 375.07 | 374.8 | 374.8 | 3520.0 |
| 2022-11-10 07:55:00 | SPY | ETF | 374.78 | 375.29 | 374.78 | 375.18 | 32490.0 |
| 2022-11-10 08:00:00 | SPY | ETF | 375.2 | 375.7396 | 374.67 | 375.3 | 42058.0 |
| 2022-11-10 08:05:00 | SPY | ETF | 375.31 | 375.31 | 375.09 | 375.18 | 17738.0 |
> showing 50 of 104,457 rows — these rows as CSV