PREVIEW / etf_1min / 2024-01-12
file: by_date/etf_1min/2024/2024-01-12.parquet size: 5.1 MB rows: 288,008
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-01-12 04:00:00 | SPY | ETF | 476.12 | 476.77 | 475.82 | 476.62 | 1821.0 |
| 2024-01-12 04:01:00 | SPY | ETF | 476.62 | 476.73 | 476.62 | 476.73 | 500.0 |
| 2024-01-12 04:02:00 | SPY | ETF | 476.79 | 476.79 | 476.71 | 476.71 | 1800.0 |
| 2024-01-12 04:05:00 | SPY | ETF | 476.71 | 476.71 | 476.7 | 476.71 | 1200.0 |
| 2024-01-12 04:07:00 | SPY | ETF | 476.75 | 476.75 | 476.73 | 476.73 | 300.0 |
| 2024-01-12 04:08:00 | SPY | ETF | 476.75 | 476.79 | 476.75 | 476.78 | 1200.0 |
| 2024-01-12 04:09:00 | SPY | ETF | 476.79 | 476.83 | 476.79 | 476.83 | 2200.0 |
| 2024-01-12 04:11:00 | SPY | ETF | 476.88 | 476.88 | 476.88 | 476.88 | 300.0 |
| 2024-01-12 04:12:00 | SPY | ETF | 476.89 | 477.04 | 476.89 | 477.04 | 1035.0 |
| 2024-01-12 04:14:00 | SPY | ETF | 477.09 | 477.09 | 477.09 | 477.09 | 405.0 |
| 2024-01-12 04:15:00 | SPY | ETF | 477.01 | 477.02 | 477.0 | 477.02 | 1440.0 |
| 2024-01-12 04:16:00 | SPY | ETF | 476.97 | 476.98 | 476.97 | 476.98 | 200.0 |
| 2024-01-12 04:17:00 | SPY | ETF | 476.86 | 476.9 | 476.85 | 476.9 | 1141.0 |
| 2024-01-12 04:18:00 | SPY | ETF | 476.84 | 476.84 | 476.84 | 476.84 | 500.0 |
| 2024-01-12 04:19:00 | SPY | ETF | 476.87 | 476.87 | 476.87 | 476.87 | 100.0 |
| 2024-01-12 04:25:00 | SPY | ETF | 476.5 | 476.5 | 476.47 | 476.48 | 1900.0 |
| 2024-01-12 04:26:00 | SPY | ETF | 476.51 | 476.55 | 476.51 | 476.55 | 350.0 |
| 2024-01-12 04:28:00 | SPY | ETF | 476.63 | 476.65 | 476.63 | 476.65 | 400.0 |
| 2024-01-12 04:34:00 | SPY | ETF | 476.9 | 476.9 | 476.9 | 476.9 | 240.0 |
| 2024-01-12 04:35:00 | SPY | ETF | 476.77 | 476.88 | 476.75 | 476.88 | 1209.0 |
| 2024-01-12 04:38:00 | SPY | ETF | 476.66 | 476.66 | 476.66 | 476.66 | 190.0 |
| 2024-01-12 04:39:00 | SPY | ETF | 476.65 | 476.65 | 476.58 | 476.58 | 5200.0 |
| 2024-01-12 04:40:00 | SPY | ETF | 476.56 | 476.56 | 476.56 | 476.56 | 300.0 |
| 2024-01-12 04:41:00 | SPY | ETF | 476.48 | 476.48 | 476.48 | 476.48 | 200.0 |
| 2024-01-12 04:42:00 | SPY | ETF | 476.53 | 476.53 | 476.53 | 476.53 | 206.0 |
| 2024-01-12 04:44:00 | SPY | ETF | 476.5 | 476.5 | 476.5 | 476.5 | 100.0 |
| 2024-01-12 04:45:00 | SPY | ETF | 476.55 | 476.55 | 476.55 | 476.55 | 300.0 |
| 2024-01-12 04:53:00 | SPY | ETF | 476.45 | 476.45 | 476.35 | 476.35 | 505.0 |
| 2024-01-12 04:57:00 | SPY | ETF | 476.3 | 476.3 | 476.3 | 476.3 | 226.0 |
| 2024-01-12 04:58:00 | SPY | ETF | 476.34 | 476.36 | 476.34 | 476.36 | 200.0 |
| 2024-01-12 05:00:00 | SPY | ETF | 476.24 | 476.24 | 476.24 | 476.24 | 100.0 |
| 2024-01-12 05:07:00 | SPY | ETF | 476.2 | 476.2 | 476.2 | 476.2 | 100.0 |
| 2024-01-12 05:10:00 | SPY | ETF | 476.35 | 476.35 | 476.35 | 476.35 | 269.0 |
| 2024-01-12 05:13:00 | SPY | ETF | 476.47 | 476.47 | 476.47 | 476.47 | 200.0 |
| 2024-01-12 05:17:00 | SPY | ETF | 476.45 | 476.45 | 476.45 | 476.45 | 100.0 |
| 2024-01-12 05:20:00 | SPY | ETF | 476.46 | 476.46 | 476.46 | 476.46 | 100.0 |
| 2024-01-12 05:21:00 | SPY | ETF | 476.56 | 476.56 | 476.56 | 476.56 | 100.0 |
| 2024-01-12 05:22:00 | SPY | ETF | 476.52 | 476.52 | 476.52 | 476.52 | 125.0 |
| 2024-01-12 05:23:00 | SPY | ETF | 476.52 | 476.52 | 476.52 | 476.52 | 100.0 |
| 2024-01-12 05:24:00 | SPY | ETF | 476.55 | 476.55 | 476.51 | 476.51 | 500.0 |
| 2024-01-12 05:25:00 | SPY | ETF | 476.55 | 476.55 | 476.55 | 476.55 | 100.0 |
| 2024-01-12 05:29:00 | SPY | ETF | 476.6 | 476.6 | 476.6 | 476.6 | 715.0 |
| 2024-01-12 05:30:00 | SPY | ETF | 476.43 | 476.43 | 476.41 | 476.41 | 715.0 |
| 2024-01-12 05:31:00 | SPY | ETF | 476.45 | 476.45 | 476.45 | 476.45 | 100.0 |
| 2024-01-12 05:39:00 | SPY | ETF | 476.49 | 476.49 | 476.49 | 476.49 | 100.0 |
| 2024-01-12 05:48:00 | SPY | ETF | 476.2 | 476.2 | 476.2 | 476.2 | 100.0 |
| 2024-01-12 05:53:00 | SPY | ETF | 476.05 | 476.05 | 475.99 | 475.99 | 450.0 |
| 2024-01-12 05:55:00 | SPY | ETF | 476.17 | 476.19 | 476.17 | 476.19 | 600.0 |
| 2024-01-12 06:03:00 | SPY | ETF | 476.4 | 476.4 | 476.4 | 476.4 | 100.0 |
| 2024-01-12 06:04:00 | SPY | ETF | 476.35 | 476.35 | 476.35 | 476.35 | 100.0 |
> showing 50 of 288,008 rows — these rows as CSV