PREVIEW / etf_5min / 2021-11-24
file: by_date/etf_5min/2021/2021-11-24.parquet size: 1.7 MB rows: 83,385
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-24 04:00:00 | SPY | ETF | 468.02 | 468.02 | 467.83 | 467.83 | 2149.0 |
| 2021-11-24 04:05:00 | SPY | ETF | 467.6 | 467.75 | 467.6 | 467.75 | 713.0 |
| 2021-11-24 04:10:00 | SPY | ETF | 467.78 | 467.84 | 467.69 | 467.73 | 895.0 |
| 2021-11-24 04:15:00 | SPY | ETF | 467.64 | 467.83 | 467.64 | 467.83 | 200.0 |
| 2021-11-24 04:20:00 | SPY | ETF | 467.98 | 468.09 | 467.98 | 468.09 | 600.0 |
| 2021-11-24 04:25:00 | SPY | ETF | 468.17 | 468.2 | 468.08 | 468.08 | 1298.0 |
| 2021-11-24 04:30:00 | SPY | ETF | 468.08 | 468.08 | 467.93 | 467.94 | 571.0 |
| 2021-11-24 04:35:00 | SPY | ETF | 467.88 | 467.88 | 467.54 | 467.54 | 800.0 |
| 2021-11-24 04:40:00 | SPY | ETF | 467.64 | 467.64 | 467.31 | 467.31 | 343.0 |
| 2021-11-24 04:45:00 | SPY | ETF | 467.42 | 467.44 | 467.3 | 467.44 | 1300.0 |
| 2021-11-24 04:50:00 | SPY | ETF | 467.24 | 467.24 | 466.67 | 466.7 | 9298.0 |
| 2021-11-24 04:55:00 | SPY | ETF | 466.57 | 467.05 | 466.57 | 466.88 | 4700.0 |
| 2021-11-24 05:00:00 | SPY | ETF | 466.82 | 467.17 | 466.82 | 467.17 | 1500.0 |
| 2021-11-24 05:05:00 | SPY | ETF | 467.12 | 467.12 | 467.04 | 467.06 | 601.0 |
| 2021-11-24 05:10:00 | SPY | ETF | 466.95 | 467.1 | 466.95 | 467.09 | 1000.0 |
| 2021-11-24 05:15:00 | SPY | ETF | 467.36 | 467.36 | 467.36 | 467.36 | 100.0 |
| 2021-11-24 05:20:00 | SPY | ETF | 467.28 | 467.28 | 467.28 | 467.28 | 100.0 |
| 2021-11-24 05:25:00 | SPY | ETF | 467.24 | 467.25 | 467.18 | 467.18 | 300.0 |
| 2021-11-24 05:30:00 | SPY | ETF | 467.21 | 467.21 | 467.21 | 467.21 | 400.0 |
| 2021-11-24 05:35:00 | SPY | ETF | 467.17 | 467.25 | 467.16 | 467.16 | 450.0 |
| 2021-11-24 05:40:00 | SPY | ETF | 467.07 | 467.07 | 467.07 | 467.07 | 100.0 |
| 2021-11-24 05:45:00 | SPY | ETF | 467.13 | 467.26 | 466.81 | 466.81 | 899.0 |
| 2021-11-24 05:50:00 | SPY | ETF | 466.7 | 466.73 | 466.65 | 466.73 | 1160.0 |
| 2021-11-24 05:55:00 | SPY | ETF | 466.71 | 466.71 | 466.48 | 466.48 | 2470.0 |
| 2021-11-24 06:00:00 | SPY | ETF | 466.46 | 466.47 | 466.33 | 466.39 | 2500.0 |
| 2021-11-24 06:05:00 | SPY | ETF | 466.44 | 466.51 | 466.35 | 466.42 | 4529.0 |
| 2021-11-24 06:10:00 | SPY | ETF | 466.41 | 466.47 | 466.41 | 466.47 | 1219.0 |
| 2021-11-24 06:15:00 | SPY | ETF | 466.42 | 467.04 | 466.41 | 467.02 | 5360.0 |
| 2021-11-24 06:20:00 | SPY | ETF | 467.02 | 467.22 | 466.97 | 466.97 | 5051.0 |
| 2021-11-24 06:25:00 | SPY | ETF | 466.99 | 467.01 | 466.95 | 466.95 | 3100.0 |
| 2021-11-24 06:30:00 | SPY | ETF | 466.98 | 467.11 | 466.93 | 467.08 | 5200.0 |
| 2021-11-24 06:35:00 | SPY | ETF | 467.17 | 467.25 | 467.17 | 467.23 | 1100.0 |
| 2021-11-24 06:40:00 | SPY | ETF | 467.32 | 467.57 | 467.32 | 467.55 | 11982.0 |
| 2021-11-24 06:45:00 | SPY | ETF | 467.63 | 467.7 | 467.45 | 467.57 | 5901.0 |
| 2021-11-24 06:50:00 | SPY | ETF | 467.64 | 467.64 | 467.5 | 467.5 | 500.0 |
| 2021-11-24 06:55:00 | SPY | ETF | 467.24 | 467.24 | 467.12 | 467.12 | 3000.0 |
| 2021-11-24 07:00:00 | SPY | ETF | 467.13 | 467.38 | 467.09 | 467.15 | 3140.0 |
| 2021-11-24 07:05:00 | SPY | ETF | 467.18 | 467.18 | 466.91 | 466.91 | 6577.0 |
| 2021-11-24 07:10:00 | SPY | ETF | 466.92 | 467.07 | 466.9 | 466.91 | 2925.0 |
| 2021-11-24 07:15:00 | SPY | ETF | 466.95 | 467.1 | 466.9 | 466.97 | 9225.0 |
| 2021-11-24 07:20:00 | SPY | ETF | 467.05 | 467.06 | 466.81 | 466.81 | 12617.0 |
| 2021-11-24 07:25:00 | SPY | ETF | 466.82 | 467.04 | 466.81 | 467.03 | 5306.0 |
| 2021-11-24 07:30:00 | SPY | ETF | 466.95 | 466.96 | 466.77 | 466.88 | 20460.0 |
| 2021-11-24 07:35:00 | SPY | ETF | 466.94 | 467.06 | 466.88 | 467.06 | 5001.0 |
| 2021-11-24 07:40:00 | SPY | ETF | 467.07 | 467.19 | 466.91 | 466.91 | 7535.0 |
| 2021-11-24 07:45:00 | SPY | ETF | 466.93 | 466.94 | 466.49 | 466.55 | 11594.0 |
| 2021-11-24 07:50:00 | SPY | ETF | 466.56 | 466.8 | 466.54 | 466.78 | 7438.0 |
| 2021-11-24 07:55:00 | SPY | ETF | 466.8 | 466.82 | 466.66 | 466.7 | 7646.0 |
| 2021-11-24 08:00:00 | SPY | ETF | 466.73 | 468.25 | 466.57 | 466.77 | 35406.0 |
| 2021-11-24 08:05:00 | SPY | ETF | 466.78 | 467.0 | 466.78 | 466.93 | 8385.0 |
> showing 50 of 83,385 rows — these rows as CSV