PREVIEW / etf_1min / 2024-10-11
file: by_date/etf_1min/2024/2024-10-11.parquet size: 5.2 MB rows: 287,774
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-10-11 04:00:00 | SPY | ETF | 575.68 | 576.1 | 575.68 | 576.1 | 2448.0 |
| 2024-10-11 04:01:00 | SPY | ETF | 576.09 | 576.09 | 576.09 | 576.09 | 188.0 |
| 2024-10-11 04:03:00 | SPY | ETF | 576.02 | 576.02 | 576.02 | 576.02 | 1200.0 |
| 2024-10-11 04:04:00 | SPY | ETF | 576.0 | 576.0 | 575.97 | 575.97 | 1337.0 |
| 2024-10-11 04:06:00 | SPY | ETF | 575.88 | 575.88 | 575.88 | 575.88 | 522.0 |
| 2024-10-11 04:07:00 | SPY | ETF | 575.82 | 575.82 | 575.82 | 575.82 | 156.0 |
| 2024-10-11 04:08:00 | SPY | ETF | 575.85 | 575.85 | 575.85 | 575.85 | 200.0 |
| 2024-10-11 04:09:00 | SPY | ETF | 575.74 | 575.74 | 575.74 | 575.74 | 100.0 |
| 2024-10-11 04:11:00 | SPY | ETF | 575.75 | 575.75 | 575.7 | 575.7 | 343.0 |
| 2024-10-11 04:12:00 | SPY | ETF | 575.74 | 575.74 | 575.74 | 575.74 | 200.0 |
| 2024-10-11 04:13:00 | SPY | ETF | 575.61 | 575.61 | 575.61 | 575.61 | 358.0 |
| 2024-10-11 04:16:00 | SPY | ETF | 575.68 | 575.68 | 575.68 | 575.68 | 100.0 |
| 2024-10-11 04:20:00 | SPY | ETF | 575.65 | 575.66 | 575.65 | 575.66 | 227.0 |
| 2024-10-11 04:21:00 | SPY | ETF | 575.65 | 575.7 | 575.6 | 575.61 | 805.0 |
| 2024-10-11 04:22:00 | SPY | ETF | 575.68 | 575.8 | 575.68 | 575.77 | 1000.0 |
| 2024-10-11 04:23:00 | SPY | ETF | 575.72 | 575.72 | 575.68 | 575.68 | 646.0 |
| 2024-10-11 04:24:00 | SPY | ETF | 575.88 | 575.88 | 575.88 | 575.88 | 141.0 |
| 2024-10-11 04:25:00 | SPY | ETF | 575.81 | 575.82 | 575.81 | 575.82 | 456.0 |
| 2024-10-11 04:33:00 | SPY | ETF | 575.76 | 575.87 | 575.76 | 575.87 | 530.0 |
| 2024-10-11 04:41:00 | SPY | ETF | 575.76 | 575.76 | 575.76 | 575.76 | 500.0 |
| 2024-10-11 04:42:00 | SPY | ETF | 575.77 | 575.77 | 575.77 | 575.77 | 276.0 |
| 2024-10-11 04:43:00 | SPY | ETF | 575.67 | 575.67 | 575.65 | 575.65 | 273.0 |
| 2024-10-11 04:44:00 | SPY | ETF | 575.72 | 575.72 | 575.72 | 575.72 | 106.0 |
| 2024-10-11 04:49:00 | SPY | ETF | 575.42 | 575.42 | 575.31 | 575.31 | 420.0 |
| 2024-10-11 04:53:00 | SPY | ETF | 575.37 | 575.37 | 575.37 | 575.37 | 150.0 |
| 2024-10-11 04:55:00 | SPY | ETF | 575.4 | 575.4 | 575.4 | 575.4 | 100.0 |
| 2024-10-11 04:56:00 | SPY | ETF | 575.35 | 575.35 | 575.35 | 575.35 | 130.0 |
| 2024-10-11 04:57:00 | SPY | ETF | 575.41 | 575.41 | 575.41 | 575.41 | 187.0 |
| 2024-10-11 04:58:00 | SPY | ETF | 575.35 | 575.35 | 575.29 | 575.29 | 313.0 |
| 2024-10-11 04:59:00 | SPY | ETF | 575.29 | 575.29 | 575.27 | 575.28 | 1512.0 |
| 2024-10-11 05:00:00 | SPY | ETF | 575.37 | 575.38 | 575.28 | 575.38 | 717.0 |
| 2024-10-11 05:04:00 | SPY | ETF | 575.6 | 575.6 | 575.6 | 575.6 | 600.0 |
| 2024-10-11 05:05:00 | SPY | ETF | 575.6 | 575.6 | 575.6 | 575.6 | 374.0 |
| 2024-10-11 05:06:00 | SPY | ETF | 575.6 | 575.6 | 575.6 | 575.6 | 104.0 |
| 2024-10-11 05:08:00 | SPY | ETF | 575.71 | 575.74 | 575.71 | 575.74 | 300.0 |
| 2024-10-11 05:13:00 | SPY | ETF | 575.7 | 575.7 | 575.7 | 575.7 | 6843.0 |
| 2024-10-11 05:19:00 | SPY | ETF | 575.45 | 575.45 | 575.45 | 575.45 | 911.0 |
| 2024-10-11 05:20:00 | SPY | ETF | 575.45 | 575.55 | 575.45 | 575.53 | 1979.0 |
| 2024-10-11 05:21:00 | SPY | ETF | 575.48 | 575.48 | 575.48 | 575.48 | 297.0 |
| 2024-10-11 05:23:00 | SPY | ETF | 575.5 | 575.5 | 575.44 | 575.44 | 524.0 |
| 2024-10-11 05:24:00 | SPY | ETF | 575.41 | 575.48 | 575.41 | 575.48 | 604.0 |
| 2024-10-11 05:27:00 | SPY | ETF | 575.5 | 575.5 | 575.5 | 575.5 | 276.0 |
| 2024-10-11 05:33:00 | SPY | ETF | 575.56 | 575.56 | 575.56 | 575.56 | 187.0 |
| 2024-10-11 05:46:00 | SPY | ETF | 575.42 | 575.48 | 575.42 | 575.48 | 374.0 |
| 2024-10-11 05:49:00 | SPY | ETF | 575.48 | 575.5 | 575.48 | 575.5 | 2489.0 |
| 2024-10-11 05:52:00 | SPY | ETF | 575.49 | 575.49 | 575.49 | 575.49 | 187.0 |
| 2024-10-11 05:53:00 | SPY | ETF | 575.4 | 575.4 | 575.4 | 575.4 | 2100.0 |
| 2024-10-11 05:54:00 | SPY | ETF | 575.4 | 575.4 | 575.4 | 575.4 | 455.0 |
| 2024-10-11 05:56:00 | SPY | ETF | 575.3 | 575.3 | 575.3 | 575.3 | 2674.0 |
| 2024-10-11 06:00:00 | SPY | ETF | 575.35 | 575.42 | 575.35 | 575.42 | 903.0 |
> showing 50 of 287,774 rows — these rows as CSV