PREVIEW / etf_1min / 2024-12-18
file: by_date/etf_1min/2024/2024-12-18.parquet size: 6.8 MB rows: 380,611
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-12-18 04:02:00 | SPY | ETF | 604.89 | 604.89 | 604.89 | 604.89 | 400.0 |
| 2024-12-18 04:04:00 | SPY | ETF | 604.87 | 604.87 | 604.87 | 604.87 | 131.0 |
| 2024-12-18 04:05:00 | SPY | ETF | 604.95 | 604.95 | 604.93 | 604.93 | 2552.0 |
| 2024-12-18 04:06:00 | SPY | ETF | 604.99 | 605.0 | 604.95 | 604.95 | 2397.0 |
| 2024-12-18 04:07:00 | SPY | ETF | 604.97 | 604.97 | 604.97 | 604.97 | 400.0 |
| 2024-12-18 04:10:00 | SPY | ETF | 604.97 | 604.97 | 604.97 | 604.97 | 109.0 |
| 2024-12-18 04:11:00 | SPY | ETF | 605.0 | 605.0 | 604.96 | 604.96 | 344.0 |
| 2024-12-18 04:12:00 | SPY | ETF | 605.03 | 605.03 | 604.97 | 604.97 | 331.0 |
| 2024-12-18 04:16:00 | SPY | ETF | 605.1 | 605.1 | 605.1 | 605.1 | 111.0 |
| 2024-12-18 04:19:00 | SPY | ETF | 605.13 | 605.13 | 605.13 | 605.13 | 109.0 |
| 2024-12-18 04:20:00 | SPY | ETF | 605.04 | 605.1 | 605.04 | 605.1 | 702.0 |
| 2024-12-18 04:23:00 | SPY | ETF | 605.04 | 605.04 | 605.04 | 605.04 | 483.0 |
| 2024-12-18 04:27:00 | SPY | ETF | 605.0 | 605.0 | 605.0 | 605.0 | 421.0 |
| 2024-12-18 04:31:00 | SPY | ETF | 605.1 | 605.1 | 605.1 | 605.1 | 314.0 |
| 2024-12-18 04:34:00 | SPY | ETF | 605.22 | 605.22 | 605.22 | 605.22 | 368.0 |
| 2024-12-18 04:40:00 | SPY | ETF | 605.35 | 605.35 | 605.35 | 605.35 | 508.0 |
| 2024-12-18 04:41:00 | SPY | ETF | 605.42 | 605.42 | 605.42 | 605.42 | 100.0 |
| 2024-12-18 04:44:00 | SPY | ETF | 605.34 | 605.34 | 605.33 | 605.33 | 769.0 |
| 2024-12-18 04:45:00 | SPY | ETF | 605.36 | 605.36 | 605.36 | 605.36 | 258.0 |
| 2024-12-18 04:49:00 | SPY | ETF | 605.42 | 605.42 | 605.42 | 605.42 | 300.0 |
| 2024-12-18 04:50:00 | SPY | ETF | 605.28 | 605.28 | 605.28 | 605.28 | 176.0 |
| 2024-12-18 04:57:00 | SPY | ETF | 605.31 | 605.31 | 605.31 | 605.31 | 103.0 |
| 2024-12-18 05:03:00 | SPY | ETF | 605.52 | 605.52 | 605.52 | 605.52 | 130.0 |
| 2024-12-18 05:07:00 | SPY | ETF | 605.59 | 605.59 | 605.59 | 605.59 | 100.0 |
| 2024-12-18 05:09:00 | SPY | ETF | 605.53 | 605.6 | 605.53 | 605.6 | 522.0 |
| 2024-12-18 05:16:00 | SPY | ETF | 605.89 | 605.89 | 605.88 | 605.88 | 700.0 |
| 2024-12-18 05:19:00 | SPY | ETF | 605.9 | 605.9 | 605.9 | 605.9 | 119.0 |
| 2024-12-18 05:21:00 | SPY | ETF | 605.82 | 605.82 | 605.81 | 605.81 | 560.0 |
| 2024-12-18 05:22:00 | SPY | ETF | 605.86 | 605.91 | 605.86 | 605.91 | 284.0 |
| 2024-12-18 05:25:00 | SPY | ETF | 605.92 | 605.94 | 605.92 | 605.94 | 9773.0 |
| 2024-12-18 05:26:00 | SPY | ETF | 605.95 | 605.95 | 605.95 | 605.95 | 100.0 |
| 2024-12-18 05:30:00 | SPY | ETF | 605.92 | 605.92 | 605.85 | 605.85 | 446.0 |
| 2024-12-18 05:32:00 | SPY | ETF | 605.8 | 605.8 | 605.8 | 605.8 | 321.0 |
| 2024-12-18 05:34:00 | SPY | ETF | 605.75 | 605.75 | 605.75 | 605.75 | 164.0 |
| 2024-12-18 05:35:00 | SPY | ETF | 605.69 | 605.7 | 605.69 | 605.7 | 810.0 |
| 2024-12-18 05:38:00 | SPY | ETF | 605.8 | 605.8 | 605.8 | 605.8 | 627.0 |
| 2024-12-18 05:41:00 | SPY | ETF | 605.8 | 605.8 | 605.8 | 605.8 | 200.0 |
| 2024-12-18 05:54:00 | SPY | ETF | 605.67 | 605.67 | 605.67 | 605.67 | 100.0 |
| 2024-12-18 05:59:00 | SPY | ETF | 605.88 | 605.88 | 605.88 | 605.88 | 100.0 |
| 2024-12-18 06:00:00 | SPY | ETF | 605.9 | 605.9 | 605.9 | 605.9 | 200.0 |
| 2024-12-18 06:02:00 | SPY | ETF | 605.89 | 605.89 | 605.89 | 605.89 | 500.0 |
| 2024-12-18 06:04:00 | SPY | ETF | 605.86 | 605.86 | 605.86 | 605.86 | 100.0 |
| 2024-12-18 06:09:00 | SPY | ETF | 605.94 | 605.94 | 605.94 | 605.94 | 129.0 |
| 2024-12-18 06:10:00 | SPY | ETF | 605.85 | 605.85 | 605.85 | 605.85 | 100.0 |
| 2024-12-18 06:13:00 | SPY | ETF | 605.87 | 605.87 | 605.87 | 605.87 | 100.0 |
| 2024-12-18 06:14:00 | SPY | ETF | 605.89 | 605.89 | 605.89 | 605.89 | 400.0 |
| 2024-12-18 06:15:00 | SPY | ETF | 605.93 | 605.93 | 605.93 | 605.93 | 5056.0 |
| 2024-12-18 06:21:00 | SPY | ETF | 605.94 | 605.94 | 605.94 | 605.94 | 700.0 |
| 2024-12-18 06:23:00 | SPY | ETF | 606.02 | 606.02 | 606.02 | 606.02 | 382.0 |
| 2024-12-18 06:26:00 | SPY | ETF | 605.94 | 605.94 | 605.94 | 605.94 | 160.0 |
> showing 50 of 380,611 rows — these rows as CSV