PREVIEW / etf_1min / 2024-09-18
file: by_date/etf_1min/2024/2024-09-18.parquet size: 5.3 MB rows: 300,694
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-09-18 04:00:00 | SPY | ETF | 563.27 | 563.27 | 563.27 | 563.27 | 100.0 |
| 2024-09-18 04:02:00 | SPY | ETF | 563.21 | 563.21 | 563.18 | 563.18 | 476.0 |
| 2024-09-18 04:03:00 | SPY | ETF | 563.12 | 563.26 | 563.12 | 563.21 | 882.0 |
| 2024-09-18 04:04:00 | SPY | ETF | 563.2 | 563.23 | 563.14 | 563.23 | 694.0 |
| 2024-09-18 04:06:00 | SPY | ETF | 563.1 | 563.1 | 563.1 | 563.1 | 946.0 |
| 2024-09-18 04:07:00 | SPY | ETF | 563.12 | 563.12 | 563.12 | 563.12 | 126.0 |
| 2024-09-18 04:09:00 | SPY | ETF | 563.05 | 563.05 | 563.01 | 563.02 | 1169.0 |
| 2024-09-18 04:11:00 | SPY | ETF | 563.01 | 563.01 | 563.0 | 563.0 | 1000.0 |
| 2024-09-18 04:12:00 | SPY | ETF | 562.96 | 562.96 | 562.96 | 562.96 | 200.0 |
| 2024-09-18 04:13:00 | SPY | ETF | 562.95 | 562.98 | 562.95 | 562.98 | 5400.0 |
| 2024-09-18 04:14:00 | SPY | ETF | 562.98 | 562.98 | 562.98 | 562.98 | 14650.0 |
| 2024-09-18 04:15:00 | SPY | ETF | 562.98 | 562.98 | 562.95 | 562.95 | 2925.0 |
| 2024-09-18 04:16:00 | SPY | ETF | 563.07 | 563.07 | 563.07 | 563.07 | 1500.0 |
| 2024-09-18 04:19:00 | SPY | ETF | 563.19 | 563.19 | 563.19 | 563.19 | 100.0 |
| 2024-09-18 04:21:00 | SPY | ETF | 563.24 | 563.24 | 563.24 | 563.24 | 100.0 |
| 2024-09-18 04:22:00 | SPY | ETF | 563.1 | 563.1 | 563.1 | 563.1 | 200.0 |
| 2024-09-18 04:25:00 | SPY | ETF | 563.08 | 563.08 | 563.08 | 563.08 | 500.0 |
| 2024-09-18 04:28:00 | SPY | ETF | 562.94 | 562.94 | 562.94 | 562.94 | 140.0 |
| 2024-09-18 04:29:00 | SPY | ETF | 562.94 | 562.94 | 562.94 | 562.94 | 100.0 |
| 2024-09-18 04:30:00 | SPY | ETF | 562.91 | 562.91 | 562.91 | 562.91 | 100.0 |
| 2024-09-18 04:34:00 | SPY | ETF | 563.07 | 563.07 | 563.07 | 563.07 | 545.0 |
| 2024-09-18 04:39:00 | SPY | ETF | 563.08 | 563.08 | 563.08 | 563.08 | 100.0 |
| 2024-09-18 04:41:00 | SPY | ETF | 562.99 | 562.99 | 562.99 | 562.99 | 100.0 |
| 2024-09-18 04:46:00 | SPY | ETF | 563.03 | 563.03 | 563.0 | 563.0 | 898.0 |
| 2024-09-18 04:54:00 | SPY | ETF | 563.28 | 563.31 | 563.28 | 563.31 | 350.0 |
| 2024-09-18 04:59:00 | SPY | ETF | 563.37 | 563.37 | 563.37 | 563.37 | 100.0 |
| 2024-09-18 05:07:00 | SPY | ETF | 563.36 | 563.36 | 563.36 | 563.36 | 200.0 |
| 2024-09-18 05:15:00 | SPY | ETF | 563.35 | 563.35 | 563.35 | 563.35 | 100.0 |
| 2024-09-18 05:16:00 | SPY | ETF | 563.31 | 563.31 | 563.31 | 563.31 | 100.0 |
| 2024-09-18 05:18:00 | SPY | ETF | 563.41 | 563.41 | 563.41 | 563.41 | 110.0 |
| 2024-09-18 05:25:00 | SPY | ETF | 563.46 | 563.46 | 563.46 | 563.46 | 200.0 |
| 2024-09-18 05:26:00 | SPY | ETF | 563.51 | 563.51 | 563.51 | 563.51 | 300.0 |
| 2024-09-18 05:35:00 | SPY | ETF | 563.69 | 563.69 | 563.69 | 563.69 | 100.0 |
| 2024-09-18 05:39:00 | SPY | ETF | 563.71 | 563.71 | 563.7 | 563.7 | 500.0 |
| 2024-09-18 05:42:00 | SPY | ETF | 563.73 | 563.73 | 563.73 | 563.73 | 301.0 |
| 2024-09-18 05:56:00 | SPY | ETF | 563.81 | 563.87 | 563.81 | 563.87 | 200.0 |
| 2024-09-18 05:57:00 | SPY | ETF | 563.88 | 563.88 | 563.88 | 563.88 | 170.0 |
| 2024-09-18 05:59:00 | SPY | ETF | 563.92 | 563.92 | 563.92 | 563.92 | 104.0 |
| 2024-09-18 06:00:00 | SPY | ETF | 563.85 | 563.85 | 563.85 | 563.85 | 152.0 |
| 2024-09-18 06:04:00 | SPY | ETF | 563.8 | 563.8 | 563.8 | 563.8 | 500.0 |
| 2024-09-18 06:07:00 | SPY | ETF | 563.83 | 563.83 | 563.82 | 563.82 | 1152.0 |
| 2024-09-18 06:13:00 | SPY | ETF | 563.83 | 563.83 | 563.83 | 563.83 | 100.0 |
| 2024-09-18 06:14:00 | SPY | ETF | 563.69 | 563.69 | 563.69 | 563.69 | 122.0 |
| 2024-09-18 06:15:00 | SPY | ETF | 563.71 | 563.71 | 563.71 | 563.71 | 200.0 |
| 2024-09-18 06:16:00 | SPY | ETF | 563.68 | 563.68 | 563.66 | 563.66 | 296.0 |
| 2024-09-18 06:18:00 | SPY | ETF | 563.72 | 563.73 | 563.72 | 563.72 | 14000.0 |
| 2024-09-18 06:22:00 | SPY | ETF | 563.84 | 563.84 | 563.84 | 563.84 | 100.0 |
| 2024-09-18 06:23:00 | SPY | ETF | 563.77 | 563.79 | 563.77 | 563.78 | 1310.0 |
| 2024-09-18 06:28:00 | SPY | ETF | 563.8 | 563.8 | 563.8 | 563.8 | 100.0 |
| 2024-09-18 06:29:00 | SPY | ETF | 563.84 | 563.84 | 563.82 | 563.83 | 1126.0 |
> showing 50 of 300,694 rows — these rows as CSV