PREVIEW / etf_5min / 2022-08-02
file: by_date/etf_5min/2022/2022-08-02.parquet size: 1.9 MB rows: 92,725
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-08-02 04:00:00 | SPY | ETF | 408.68 | 409.49 | 408.55 | 408.71 | 3198.0 |
| 2022-08-02 04:05:00 | SPY | ETF | 408.65 | 408.74 | 408.65 | 408.74 | 1132.0 |
| 2022-08-02 04:10:00 | SPY | ETF | 408.73 | 408.73 | 408.44 | 408.44 | 1100.0 |
| 2022-08-02 04:15:00 | SPY | ETF | 408.38 | 408.39 | 408.2 | 408.24 | 6817.0 |
| 2022-08-02 04:20:00 | SPY | ETF | 408.2 | 408.57 | 408.14 | 408.57 | 1100.0 |
| 2022-08-02 04:25:00 | SPY | ETF | 408.55 | 408.55 | 408.55 | 408.55 | 100.0 |
| 2022-08-02 04:30:00 | SPY | ETF | 408.66 | 408.66 | 408.43 | 408.46 | 604.0 |
| 2022-08-02 04:35:00 | SPY | ETF | 408.28 | 408.28 | 408.22 | 408.26 | 3473.0 |
| 2022-08-02 04:40:00 | SPY | ETF | 408.08 | 408.08 | 408.0 | 408.05 | 6342.0 |
| 2022-08-02 04:45:00 | SPY | ETF | 407.98 | 407.98 | 407.83 | 407.83 | 700.0 |
| 2022-08-02 04:50:00 | SPY | ETF | 407.88 | 408.1 | 407.88 | 408.1 | 1178.0 |
| 2022-08-02 04:55:00 | SPY | ETF | 408.11 | 408.14 | 408.06 | 408.14 | 3496.0 |
| 2022-08-02 05:00:00 | SPY | ETF | 408.16 | 408.24 | 408.02 | 408.24 | 2000.0 |
| 2022-08-02 05:05:00 | SPY | ETF | 408.2 | 408.21 | 408.2 | 408.21 | 1589.0 |
| 2022-08-02 05:10:00 | SPY | ETF | 408.19 | 408.2 | 408.15 | 408.2 | 911.0 |
| 2022-08-02 05:15:00 | SPY | ETF | 408.39 | 408.39 | 408.39 | 408.39 | 800.0 |
| 2022-08-02 05:20:00 | SPY | ETF | 408.34 | 408.34 | 408.34 | 408.34 | 500.0 |
| 2022-08-02 05:25:00 | SPY | ETF | 408.2 | 408.2 | 408.12 | 408.2 | 1400.0 |
| 2022-08-02 05:30:00 | SPY | ETF | 408.24 | 408.24 | 407.82 | 407.89 | 7467.0 |
| 2022-08-02 05:35:00 | SPY | ETF | 408.14 | 408.14 | 407.95 | 407.95 | 4738.0 |
| 2022-08-02 05:40:00 | SPY | ETF | 407.95 | 408.23 | 407.95 | 408.2 | 3524.0 |
| 2022-08-02 05:45:00 | SPY | ETF | 408.2 | 408.2 | 408.07 | 408.07 | 8701.0 |
| 2022-08-02 05:50:00 | SPY | ETF | 407.95 | 407.95 | 407.76 | 407.8 | 3075.0 |
| 2022-08-02 05:55:00 | SPY | ETF | 407.75 | 407.75 | 407.6 | 407.6 | 601.0 |
| 2022-08-02 06:00:00 | SPY | ETF | 407.76 | 407.82 | 407.75 | 407.75 | 1565.0 |
| 2022-08-02 06:05:00 | SPY | ETF | 407.6 | 407.62 | 407.54 | 407.55 | 1768.0 |
| 2022-08-02 06:10:00 | SPY | ETF | 407.63 | 407.66 | 407.63 | 407.66 | 600.0 |
| 2022-08-02 06:15:00 | SPY | ETF | 407.77 | 407.77 | 407.18 | 407.31 | 7631.0 |
| 2022-08-02 06:20:00 | SPY | ETF | 407.5 | 407.5 | 407.28 | 407.4 | 28131.0 |
| 2022-08-02 06:25:00 | SPY | ETF | 407.46 | 407.47 | 407.38 | 407.39 | 15686.0 |
| 2022-08-02 06:30:00 | SPY | ETF | 407.31 | 407.34 | 407.25 | 407.28 | 2377.0 |
| 2022-08-02 06:35:00 | SPY | ETF | 407.2 | 407.5 | 407.17 | 407.49 | 6953.0 |
| 2022-08-02 06:40:00 | SPY | ETF | 407.51 | 407.58 | 407.49 | 407.56 | 2578.0 |
| 2022-08-02 06:45:00 | SPY | ETF | 407.49 | 407.64 | 407.49 | 407.49 | 4054.0 |
| 2022-08-02 06:55:00 | SPY | ETF | 407.4 | 407.69 | 407.4 | 407.69 | 2640.0 |
| 2022-08-02 07:00:00 | SPY | ETF | 407.68 | 408.35 | 407.6 | 408.3 | 27476.0 |
| 2022-08-02 07:05:00 | SPY | ETF | 408.18 | 408.18 | 407.9 | 407.99 | 7831.0 |
| 2022-08-02 07:10:00 | SPY | ETF | 407.99 | 408.15 | 407.99 | 408.12 | 4014.0 |
| 2022-08-02 07:15:00 | SPY | ETF | 408.11 | 408.32 | 408.11 | 408.18 | 3700.0 |
| 2022-08-02 07:20:00 | SPY | ETF | 408.2 | 408.44 | 408.18 | 408.43 | 12294.0 |
| 2022-08-02 07:25:00 | SPY | ETF | 408.44 | 408.44 | 408.27 | 408.34 | 8771.0 |
| 2022-08-02 07:30:00 | SPY | ETF | 408.32 | 408.6 | 408.32 | 408.6 | 12902.0 |
| 2022-08-02 07:35:00 | SPY | ETF | 408.48 | 408.49 | 408.41 | 408.45 | 2024.0 |
| 2022-08-02 07:40:00 | SPY | ETF | 408.45 | 408.48 | 408.2 | 408.2 | 25278.0 |
| 2022-08-02 07:45:00 | SPY | ETF | 408.2 | 408.44 | 408.2 | 408.28 | 16900.0 |
| 2022-08-02 07:50:00 | SPY | ETF | 408.38 | 408.43 | 408.25 | 408.35 | 19643.0 |
| 2022-08-02 07:55:00 | SPY | ETF | 408.38 | 408.38 | 408.24 | 408.26 | 3850.0 |
| 2022-08-02 08:00:00 | SPY | ETF | 408.13 | 409.07 | 407.4204 | 408.52 | 241583.0 |
| 2022-08-02 08:05:00 | SPY | ETF | 408.5 | 408.51 | 408.32 | 408.41 | 30465.0 |
| 2022-08-02 08:10:00 | SPY | ETF | 408.41 | 408.5 | 408.25 | 408.35 | 22755.0 |
> showing 50 of 92,725 rows — these rows as CSV