PREVIEW / etf_5min / 2024-05-10
file: by_date/etf_5min/2024/2024-05-10.parquet size: 2.1 MB rows: 104,607
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-10 04:00:00 | SPY | ETF | 521.0 | 521.23 | 520.92 | 520.92 | 635.0 |
| 2024-05-10 04:05:00 | SPY | ETF | 521.03 | 521.03 | 520.86 | 520.86 | 3538.0 |
| 2024-05-10 04:10:00 | SPY | ETF | 521.22 | 521.22 | 521.22 | 521.22 | 249.0 |
| 2024-05-10 04:15:00 | SPY | ETF | 521.24 | 521.24 | 521.18 | 521.18 | 1264.0 |
| 2024-05-10 04:20:00 | SPY | ETF | 521.37 | 521.42 | 521.37 | 521.4 | 880.0 |
| 2024-05-10 04:25:00 | SPY | ETF | 521.4 | 521.4 | 521.4 | 521.4 | 600.0 |
| 2024-05-10 04:30:00 | SPY | ETF | 521.41 | 521.41 | 521.41 | 521.41 | 187.0 |
| 2024-05-10 04:35:00 | SPY | ETF | 521.43 | 521.51 | 521.43 | 521.51 | 1671.0 |
| 2024-05-10 04:40:00 | SPY | ETF | 521.5 | 521.5 | 521.5 | 521.5 | 154.0 |
| 2024-05-10 04:45:00 | SPY | ETF | 521.62 | 521.62 | 521.62 | 521.62 | 100.0 |
| 2024-05-10 04:55:00 | SPY | ETF | 521.86 | 521.91 | 521.86 | 521.91 | 265.0 |
| 2024-05-10 05:00:00 | SPY | ETF | 521.9 | 522.0 | 521.9 | 522.0 | 3576.0 |
| 2024-05-10 05:05:00 | SPY | ETF | 522.1 | 522.17 | 522.09 | 522.17 | 4600.0 |
| 2024-05-10 05:10:00 | SPY | ETF | 522.16 | 522.18 | 522.16 | 522.18 | 2949.0 |
| 2024-05-10 05:15:00 | SPY | ETF | 522.18 | 522.24 | 522.18 | 522.24 | 2026.0 |
| 2024-05-10 05:20:00 | SPY | ETF | 522.25 | 522.28 | 522.13 | 522.13 | 4200.0 |
| 2024-05-10 05:25:00 | SPY | ETF | 522.15 | 522.16 | 522.12 | 522.16 | 1596.0 |
| 2024-05-10 05:30:00 | SPY | ETF | 522.12 | 522.12 | 522.12 | 522.12 | 149.0 |
| 2024-05-10 05:35:00 | SPY | ETF | 522.29 | 522.29 | 522.25 | 522.25 | 300.0 |
| 2024-05-10 05:40:00 | SPY | ETF | 522.16 | 522.2 | 522.16 | 522.2 | 675.0 |
| 2024-05-10 05:45:00 | SPY | ETF | 522.15 | 522.29 | 522.15 | 522.27 | 1000.0 |
| 2024-05-10 05:50:00 | SPY | ETF | 522.3 | 522.32 | 522.26 | 522.26 | 1459.0 |
| 2024-05-10 05:55:00 | SPY | ETF | 522.25 | 522.25 | 522.22 | 522.22 | 1393.0 |
| 2024-05-10 06:00:00 | SPY | ETF | 522.11 | 522.11 | 522.11 | 522.11 | 200.0 |
| 2024-05-10 06:05:00 | SPY | ETF | 522.07 | 522.07 | 522.05 | 522.05 | 200.0 |
| 2024-05-10 06:10:00 | SPY | ETF | 522.05 | 522.05 | 521.94 | 521.94 | 22544.0 |
| 2024-05-10 06:15:00 | SPY | ETF | 521.99 | 522.02 | 521.99 | 522.02 | 14200.0 |
| 2024-05-10 06:20:00 | SPY | ETF | 522.04 | 522.04 | 521.99 | 522.0 | 451.0 |
| 2024-05-10 06:25:00 | SPY | ETF | 521.97 | 521.97 | 521.97 | 521.97 | 447.0 |
| 2024-05-10 06:30:00 | SPY | ETF | 522.05 | 522.11 | 522.05 | 522.1 | 7240.0 |
| 2024-05-10 06:40:00 | SPY | ETF | 522.09 | 522.09 | 522.09 | 522.09 | 700.0 |
| 2024-05-10 06:45:00 | SPY | ETF | 522.06 | 522.06 | 522.06 | 522.06 | 300.0 |
| 2024-05-10 06:50:00 | SPY | ETF | 522.06 | 522.06 | 521.94 | 521.94 | 3970.0 |
| 2024-05-10 06:55:00 | SPY | ETF | 521.94 | 521.94 | 521.8 | 521.92 | 44821.0 |
| 2024-05-10 07:00:00 | SPY | ETF | 521.91 | 521.93 | 520.94 | 521.86 | 82915.0 |
| 2024-05-10 07:05:00 | SPY | ETF | 521.89 | 522.0 | 521.87 | 521.9 | 11914.0 |
| 2024-05-10 07:10:00 | SPY | ETF | 521.84 | 521.85 | 521.73 | 521.73 | 9044.0 |
| 2024-05-10 07:15:00 | SPY | ETF | 521.71 | 521.75 | 521.71 | 521.75 | 18935.0 |
| 2024-05-10 07:20:00 | SPY | ETF | 521.77 | 521.77 | 521.72 | 521.76 | 2333.0 |
| 2024-05-10 07:25:00 | SPY | ETF | 521.79 | 521.8 | 521.73 | 521.8 | 1511.0 |
| 2024-05-10 07:30:00 | SPY | ETF | 521.78 | 521.84 | 521.73 | 521.81 | 37710.0 |
| 2024-05-10 07:35:00 | SPY | ETF | 521.81 | 521.83 | 521.8 | 521.8 | 1611.0 |
| 2024-05-10 07:40:00 | SPY | ETF | 521.72 | 521.74 | 521.68 | 521.7 | 2290.0 |
| 2024-05-10 07:45:00 | SPY | ETF | 521.76 | 521.76 | 521.62 | 521.68 | 19285.0 |
| 2024-05-10 07:50:00 | SPY | ETF | 521.72 | 521.73 | 521.62 | 521.65 | 4650.0 |
| 2024-05-10 07:55:00 | SPY | ETF | 521.689 | 521.74 | 521.67 | 521.73 | 2534.0 |
| 2024-05-10 08:00:00 | SPY | ETF | 521.88 | 522.32 | 520.78 | 521.76 | 34974.0 |
| 2024-05-10 08:05:00 | SPY | ETF | 521.76 | 521.76 | 521.64 | 521.64 | 21526.0 |
| 2024-05-10 08:10:00 | SPY | ETF | 521.6701 | 521.85 | 521.6701 | 521.83 | 34751.0 |
| 2024-05-10 08:15:00 | SPY | ETF | 521.87 | 521.87 | 521.76 | 521.79 | 5867.0 |
> showing 50 of 104,607 rows — these rows as CSV