PREVIEW / etf_5min / 2021-01-25
file: by_date/etf_5min/2021/2021-01-25.parquet size: 1.9 MB rows: 88,215
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-01-25 04:00:00 | SPY | ETF | 384.16 | 384.3 | 384.1 | 384.16 | 4153.0 |
| 2021-01-25 04:05:00 | SPY | ETF | 384.2 | 384.35 | 384.2 | 384.33 | 10730.0 |
| 2021-01-25 04:10:00 | SPY | ETF | 384.37 | 384.5 | 384.37 | 384.45 | 6188.0 |
| 2021-01-25 04:15:00 | SPY | ETF | 384.4 | 384.4 | 384.17 | 384.17 | 3168.0 |
| 2021-01-25 04:20:00 | SPY | ETF | 384.21 | 384.21 | 384.15 | 384.2 | 1800.0 |
| 2021-01-25 04:25:00 | SPY | ETF | 384.22 | 384.32 | 384.22 | 384.32 | 600.0 |
| 2021-01-25 04:30:00 | SPY | ETF | 384.31 | 384.33 | 384.18 | 384.33 | 4198.0 |
| 2021-01-25 04:35:00 | SPY | ETF | 384.3 | 384.3 | 384.17 | 384.17 | 667.0 |
| 2021-01-25 04:40:00 | SPY | ETF | 384.15 | 384.15 | 384.14 | 384.15 | 1500.0 |
| 2021-01-25 04:45:00 | SPY | ETF | 384.1 | 384.1 | 383.85 | 383.85 | 4700.0 |
| 2021-01-25 04:50:00 | SPY | ETF | 383.9 | 383.97 | 383.9 | 383.96 | 1300.0 |
| 2021-01-25 04:55:00 | SPY | ETF | 383.99 | 383.99 | 383.93 | 383.93 | 8814.0 |
| 2021-01-25 05:00:00 | SPY | ETF | 383.94 | 384.08 | 383.9 | 384.08 | 935.0 |
| 2021-01-25 05:05:00 | SPY | ETF | 383.9 | 383.9 | 383.9 | 383.9 | 100.0 |
| 2021-01-25 05:10:00 | SPY | ETF | 383.8 | 383.87 | 383.8 | 383.81 | 588.0 |
| 2021-01-25 05:15:00 | SPY | ETF | 383.79 | 383.9 | 383.79 | 383.89 | 1100.0 |
| 2021-01-25 05:20:00 | SPY | ETF | 383.97 | 383.97 | 383.97 | 383.97 | 100.0 |
| 2021-01-25 05:25:00 | SPY | ETF | 384.0 | 384.07 | 384.0 | 384.07 | 3153.0 |
| 2021-01-25 05:30:00 | SPY | ETF | 384.0 | 384.05 | 384.0 | 384.05 | 745.0 |
| 2021-01-25 05:35:00 | SPY | ETF | 384.01 | 384.1 | 384.01 | 384.1 | 600.0 |
| 2021-01-25 05:40:00 | SPY | ETF | 384.16 | 384.2 | 384.08 | 384.18 | 1783.0 |
| 2021-01-25 05:45:00 | SPY | ETF | 384.1 | 384.2 | 384.1 | 384.2 | 2900.0 |
| 2021-01-25 05:55:00 | SPY | ETF | 384.24 | 384.28 | 384.22 | 384.28 | 6150.0 |
| 2021-01-25 06:00:00 | SPY | ETF | 384.3 | 384.34 | 384.27 | 384.32 | 3520.0 |
| 2021-01-25 06:05:00 | SPY | ETF | 384.32 | 384.43 | 384.32 | 384.43 | 770.0 |
| 2021-01-25 06:10:00 | SPY | ETF | 384.37 | 384.37 | 384.33 | 384.33 | 830.0 |
| 2021-01-25 06:15:00 | SPY | ETF | 384.3 | 384.36 | 384.3 | 384.35 | 2499.0 |
| 2021-01-25 06:20:00 | SPY | ETF | 384.3 | 384.3 | 384.24 | 384.24 | 26100.0 |
| 2021-01-25 06:25:00 | SPY | ETF | 384.24 | 384.24 | 384.24 | 384.24 | 100.0 |
| 2021-01-25 06:30:00 | SPY | ETF | 384.25 | 384.28 | 384.25 | 384.28 | 44745.0 |
| 2021-01-25 06:35:00 | SPY | ETF | 384.28 | 384.28 | 384.28 | 384.28 | 1775.0 |
| 2021-01-25 06:40:00 | SPY | ETF | 384.28 | 384.28 | 384.25 | 384.25 | 3498.0 |
| 2021-01-25 06:45:00 | SPY | ETF | 384.25 | 384.25 | 383.45 | 384.1 | 56531.0 |
| 2021-01-25 06:50:00 | SPY | ETF | 384.08 | 384.08 | 383.95 | 383.95 | 6549.0 |
| 2021-01-25 06:55:00 | SPY | ETF | 384.0 | 384.0 | 383.65 | 383.89 | 11010.0 |
| 2021-01-25 07:00:00 | SPY | ETF | 383.91 | 383.91 | 383.57 | 383.71 | 21434.0 |
| 2021-01-25 07:05:00 | SPY | ETF | 383.631 | 383.83 | 383.631 | 383.78 | 9645.0 |
| 2021-01-25 07:10:00 | SPY | ETF | 383.7 | 384.1 | 383.62 | 384.05 | 14604.0 |
| 2021-01-25 07:15:00 | SPY | ETF | 384.06 | 384.14 | 384.01 | 384.09 | 7212.0 |
| 2021-01-25 07:20:00 | SPY | ETF | 384.03 | 384.06 | 383.9 | 383.9 | 5267.0 |
| 2021-01-25 07:25:00 | SPY | ETF | 383.8 | 383.87 | 383.65 | 383.65 | 6678.0 |
| 2021-01-25 07:30:00 | SPY | ETF | 383.6 | 383.74 | 383.49 | 383.5 | 24130.0 |
| 2021-01-25 07:35:00 | SPY | ETF | 383.48 | 383.51 | 383.06 | 383.25 | 11951.0 |
| 2021-01-25 07:40:00 | SPY | ETF | 383.25 | 383.44 | 383.25 | 383.39 | 31322.0 |
| 2021-01-25 07:45:00 | SPY | ETF | 383.3 | 383.42 | 383.24 | 383.38 | 9870.0 |
| 2021-01-25 07:50:00 | SPY | ETF | 383.44 | 383.44 | 382.84 | 383.0 | 60278.0 |
| 2021-01-25 07:55:00 | SPY | ETF | 383.03 | 383.09 | 382.74 | 383.04 | 21741.0 |
| 2021-01-25 08:00:00 | SPY | ETF | 383.05 | 384.3696 | 382.8099 | 383.38 | 91525.0 |
| 2021-01-25 08:05:00 | SPY | ETF | 383.38 | 383.42 | 383.15 | 383.36 | 111019.0 |
| 2021-01-25 08:10:00 | SPY | ETF | 383.37 | 383.5 | 383.26 | 383.481 | 83582.0 |
> showing 50 of 88,215 rows — these rows as CSV