PREVIEW / etf_5min / 2024-05-14
file: by_date/etf_5min/2024/2024-05-14.parquet size: 2.2 MB rows: 107,899
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-14 04:00:00 | SPY | ETF | 521.03 | 521.03 | 521.03 | 521.03 | 200.0 |
| 2024-05-14 04:05:00 | SPY | ETF | 521.0 | 521.04 | 521.0 | 521.04 | 1225.0 |
| 2024-05-14 04:10:00 | SPY | ETF | 520.98 | 521.0 | 520.98 | 520.99 | 502.0 |
| 2024-05-14 04:15:00 | SPY | ETF | 521.0 | 521.04 | 521.0 | 521.04 | 587.0 |
| 2024-05-14 04:20:00 | SPY | ETF | 521.06 | 521.15 | 521.06 | 521.13 | 945.0 |
| 2024-05-14 04:30:00 | SPY | ETF | 521.07 | 521.1 | 521.07 | 521.1 | 313.0 |
| 2024-05-14 04:35:00 | SPY | ETF | 521.21 | 521.21 | 521.21 | 521.21 | 300.0 |
| 2024-05-14 04:40:00 | SPY | ETF | 521.2 | 521.2 | 521.2 | 521.2 | 2000.0 |
| 2024-05-14 05:15:00 | SPY | ETF | 521.18 | 521.18 | 521.18 | 521.18 | 500.0 |
| 2024-05-14 05:20:00 | SPY | ETF | 521.11 | 521.11 | 521.11 | 521.11 | 200.0 |
| 2024-05-14 05:30:00 | SPY | ETF | 521.02 | 521.03 | 521.02 | 521.03 | 200.0 |
| 2024-05-14 05:35:00 | SPY | ETF | 521.0 | 521.0 | 520.95 | 520.95 | 4848.0 |
| 2024-05-14 05:40:00 | SPY | ETF | 521.03 | 521.03 | 521.03 | 521.03 | 100.0 |
| 2024-05-14 05:55:00 | SPY | ETF | 521.15 | 521.16 | 521.15 | 521.16 | 500.0 |
| 2024-05-14 06:00:00 | SPY | ETF | 521.15 | 521.16 | 521.08 | 521.08 | 1588.0 |
| 2024-05-14 06:05:00 | SPY | ETF | 521.13 | 521.13 | 521.13 | 521.13 | 800.0 |
| 2024-05-14 06:10:00 | SPY | ETF | 521.05 | 521.05 | 521.05 | 521.05 | 300.0 |
| 2024-05-14 06:15:00 | SPY | ETF | 521.04 | 521.04 | 521.04 | 521.04 | 300.0 |
| 2024-05-14 06:20:00 | SPY | ETF | 521.05 | 521.05 | 521.05 | 521.05 | 100.0 |
| 2024-05-14 06:25:00 | SPY | ETF | 521.07 | 521.1 | 521.07 | 521.09 | 1200.0 |
| 2024-05-14 06:30:00 | SPY | ETF | 521.08 | 521.08 | 521.04 | 521.04 | 300.0 |
| 2024-05-14 06:35:00 | SPY | ETF | 521.01 | 521.05 | 520.99 | 520.99 | 600.0 |
| 2024-05-14 06:40:00 | SPY | ETF | 521.1 | 521.1 | 521.1 | 521.1 | 3887.0 |
| 2024-05-14 06:50:00 | SPY | ETF | 521.2 | 521.25 | 521.2 | 521.25 | 1169.0 |
| 2024-05-14 06:55:00 | SPY | ETF | 521.22 | 521.22 | 521.22 | 521.22 | 300.0 |
| 2024-05-14 07:00:00 | SPY | ETF | 521.2 | 521.21 | 521.2 | 521.21 | 4173.0 |
| 2024-05-14 07:05:00 | SPY | ETF | 521.12 | 521.12 | 521.09 | 521.09 | 299.0 |
| 2024-05-14 07:10:00 | SPY | ETF | 521.1 | 521.22 | 521.1 | 521.22 | 5537.0 |
| 2024-05-14 07:15:00 | SPY | ETF | 521.23 | 521.24 | 521.2 | 521.2 | 9548.0 |
| 2024-05-14 07:25:00 | SPY | ETF | 521.22 | 521.22 | 521.08 | 521.08 | 600.0 |
| 2024-05-14 07:30:00 | SPY | ETF | 521.08 | 521.08 | 520.98 | 521.07 | 2034.0 |
| 2024-05-14 07:35:00 | SPY | ETF | 521.11 | 521.11 | 521.08 | 521.08 | 477.0 |
| 2024-05-14 07:40:00 | SPY | ETF | 521.13 | 521.15 | 521.13 | 521.15 | 583.0 |
| 2024-05-14 07:45:00 | SPY | ETF | 521.14 | 521.15 | 521.08 | 521.08 | 2400.0 |
| 2024-05-14 07:50:00 | SPY | ETF | 521.08 | 521.15 | 521.08 | 521.13 | 1480.0 |
| 2024-05-14 08:00:00 | SPY | ETF | 521.08 | 521.25 | 520.85 | 521.13 | 30178.0 |
| 2024-05-14 08:05:00 | SPY | ETF | 521.17 | 521.24 | 520.7 | 521.22 | 6725.0 |
| 2024-05-14 08:10:00 | SPY | ETF | 521.24 | 521.32 | 521.24 | 521.24 | 5224.0 |
| 2024-05-14 08:15:00 | SPY | ETF | 521.24 | 521.28 | 521.24 | 521.2699 | 3498.0 |
| 2024-05-14 08:20:00 | SPY | ETF | 521.29 | 521.43 | 521.29 | 521.34 | 11958.0 |
| 2024-05-14 08:25:00 | SPY | ETF | 521.34 | 521.39 | 521.26 | 521.33 | 13719.0 |
| 2024-05-14 08:30:00 | SPY | ETF | 520.98 | 521.07 | 518.18 | 520.0 | 476531.0 |
| 2024-05-14 08:35:00 | SPY | ETF | 520.01 | 520.8 | 519.82 | 520.45 | 143331.0 |
| 2024-05-14 08:40:00 | SPY | ETF | 520.44 | 520.99 | 520.4 | 520.7704 | 138842.0 |
| 2024-05-14 08:45:00 | SPY | ETF | 520.76 | 520.92 | 520.4 | 520.63 | 63367.0 |
| 2024-05-14 08:50:00 | SPY | ETF | 520.63 | 521.04 | 520.63 | 521.0 | 24343.0 |
| 2024-05-14 08:55:00 | SPY | ETF | 520.96 | 521.15 | 520.82 | 520.87 | 37071.0 |
| 2024-05-14 09:00:00 | SPY | ETF | 520.86 | 520.89 | 520.52 | 520.57 | 33625.0 |
| 2024-05-14 09:05:00 | SPY | ETF | 520.54 | 520.86 | 520.52 | 520.82 | 43063.0 |
| 2024-05-14 09:10:00 | SPY | ETF | 520.81 | 521.42 | 520.77 | 521.27 | 71857.0 |
> showing 50 of 107,899 rows — these rows as CSV