PREVIEW / etf_5min / 2024-11-22
file: by_date/etf_5min/2024/2024-11-22.parquet size: 2.6 MB rows: 124,568
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-11-22 04:00:00 | SPY | ETF | 593.74 | 593.74 | 593.58 | 593.65 | 918.0 |
| 2024-11-22 04:05:00 | SPY | ETF | 593.56 | 593.57 | 593.56 | 593.57 | 206.0 |
| 2024-11-22 04:10:00 | SPY | ETF | 592.98 | 592.99 | 592.98 | 592.99 | 300.0 |
| 2024-11-22 04:15:00 | SPY | ETF | 592.9 | 593.17 | 592.9 | 592.96 | 2311.0 |
| 2024-11-22 04:20:00 | SPY | ETF | 593.02 | 593.06 | 592.98 | 592.99 | 1683.0 |
| 2024-11-22 04:25:00 | SPY | ETF | 592.42 | 592.52 | 591.67 | 591.91 | 6038.0 |
| 2024-11-22 04:30:00 | SPY | ETF | 591.5 | 591.5 | 591.1 | 591.37 | 3795.0 |
| 2024-11-22 04:35:00 | SPY | ETF | 591.4 | 591.41 | 591.13 | 591.28 | 3901.0 |
| 2024-11-22 04:40:00 | SPY | ETF | 591.48 | 591.57 | 591.3 | 591.38 | 2482.0 |
| 2024-11-22 04:45:00 | SPY | ETF | 591.59 | 591.91 | 591.47 | 591.91 | 5618.0 |
| 2024-11-22 04:50:00 | SPY | ETF | 591.92 | 592.5 | 591.92 | 592.5 | 2361.0 |
| 2024-11-22 04:55:00 | SPY | ETF | 592.54 | 592.69 | 592.5 | 592.52 | 3643.0 |
| 2024-11-22 05:00:00 | SPY | ETF | 592.43 | 592.48 | 592.02 | 592.48 | 1057.0 |
| 2024-11-22 05:05:00 | SPY | ETF | 592.0 | 592.0 | 591.84 | 591.9 | 1713.0 |
| 2024-11-22 05:10:00 | SPY | ETF | 591.3 | 591.63 | 591.06 | 591.38 | 5604.0 |
| 2024-11-22 05:15:00 | SPY | ETF | 591.45 | 591.68 | 591.37 | 591.68 | 374.0 |
| 2024-11-22 05:20:00 | SPY | ETF | 591.75 | 591.75 | 591.56 | 591.56 | 200.0 |
| 2024-11-22 05:25:00 | SPY | ETF | 591.88 | 591.88 | 591.85 | 591.85 | 600.0 |
| 2024-11-22 05:30:00 | SPY | ETF | 591.78 | 592.29 | 591.73 | 592.15 | 3261.0 |
| 2024-11-22 05:35:00 | SPY | ETF | 592.07 | 592.35 | 592.07 | 592.35 | 3796.0 |
| 2024-11-22 05:40:00 | SPY | ETF | 592.3 | 592.3 | 592.3 | 592.3 | 262.0 |
| 2024-11-22 05:45:00 | SPY | ETF | 592.25 | 592.25 | 592.21 | 592.21 | 200.0 |
| 2024-11-22 05:50:00 | SPY | ETF | 592.18 | 592.48 | 592.18 | 592.34 | 55213.0 |
| 2024-11-22 05:55:00 | SPY | ETF | 592.2 | 592.26 | 592.15 | 592.15 | 639.0 |
| 2024-11-22 06:00:00 | SPY | ETF | 591.95 | 592.3 | 591.83 | 592.25 | 1968.0 |
| 2024-11-22 06:05:00 | SPY | ETF | 592.19 | 592.5 | 592.15 | 592.34 | 2430.0 |
| 2024-11-22 06:10:00 | SPY | ETF | 592.2 | 592.2 | 591.68 | 592.0 | 1420.0 |
| 2024-11-22 06:15:00 | SPY | ETF | 591.79 | 591.84 | 591.79 | 591.84 | 474.0 |
| 2024-11-22 06:20:00 | SPY | ETF | 592.09 | 592.09 | 592.09 | 592.09 | 100.0 |
| 2024-11-22 06:25:00 | SPY | ETF | 592.24 | 592.24 | 592.24 | 592.24 | 100.0 |
| 2024-11-22 06:30:00 | SPY | ETF | 592.18 | 592.18 | 592.18 | 592.18 | 190.0 |
| 2024-11-22 06:35:00 | SPY | ETF | 591.96 | 591.96 | 591.72 | 591.77 | 613.0 |
| 2024-11-22 06:40:00 | SPY | ETF | 592.35 | 592.35 | 592.3 | 592.3 | 1104.0 |
| 2024-11-22 06:45:00 | SPY | ETF | 592.23 | 592.23 | 592.23 | 592.23 | 287.0 |
| 2024-11-22 06:50:00 | SPY | ETF | 592.56 | 592.7 | 592.51 | 592.68 | 3069.0 |
| 2024-11-22 06:55:00 | SPY | ETF | 592.68 | 592.77 | 592.66 | 592.73 | 2657.0 |
| 2024-11-22 07:00:00 | SPY | ETF | 592.86 | 593.15 | 592.81 | 593.03 | 4724.0 |
| 2024-11-22 07:05:00 | SPY | ETF | 592.93 | 593.09 | 592.92 | 592.92 | 7693.0 |
| 2024-11-22 07:10:00 | SPY | ETF | 593.03 | 593.03 | 592.96 | 592.96 | 200.0 |
| 2024-11-22 07:15:00 | SPY | ETF | 593.16 | 593.26 | 593.16 | 593.26 | 4878.0 |
| 2024-11-22 07:20:00 | SPY | ETF | 593.14 | 593.26 | 593.0 | 593.26 | 4706.0 |
| 2024-11-22 07:25:00 | SPY | ETF | 593.19 | 593.29 | 593.19 | 593.29 | 807.0 |
| 2024-11-22 07:30:00 | SPY | ETF | 593.34 | 593.35 | 593.0 | 593.1 | 10849.0 |
| 2024-11-22 07:35:00 | SPY | ETF | 593.21 | 593.29 | 593.21 | 593.29 | 1507.0 |
| 2024-11-22 07:40:00 | SPY | ETF | 593.35 | 593.4 | 593.11 | 593.11 | 12543.0 |
| 2024-11-22 07:45:00 | SPY | ETF | 593.19 | 593.36 | 593.18 | 593.18 | 16350.0 |
| 2024-11-22 07:50:00 | SPY | ETF | 593.34 | 593.58 | 593.34 | 593.58 | 17901.0 |
| 2024-11-22 07:55:00 | SPY | ETF | 593.58 | 593.62 | 593.46 | 593.55 | 51104.0 |
| 2024-11-22 08:00:00 | SPY | ETF | 593.05 | 594.15 | 592.72 | 593.59 | 34225.0 |
| 2024-11-22 08:05:00 | SPY | ETF | 593.56 | 593.78 | 593.55 | 593.691 | 5447.0 |
> showing 50 of 124,568 rows — these rows as CSV