PREVIEW / etf_1min / 2024-09-23
file: by_date/etf_1min/2024/2024-09-23.parquet size: 5.1 MB rows: 293,250
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-23 04:00:00 | SPY | ETF | 569.19 | 569.19 | 568.34 | 568.56 | 4600.0 |
| 2024-09-23 04:01:00 | SPY | ETF | 568.61 | 568.84 | 568.56 | 568.84 | 31753.0 |
| 2024-09-23 04:02:00 | SPY | ETF | 568.82 | 568.9 | 568.71 | 568.71 | 4670.0 |
| 2024-09-23 04:03:00 | SPY | ETF | 568.69 | 568.7 | 568.51 | 568.53 | 3489.0 |
| 2024-09-23 04:04:00 | SPY | ETF | 568.55 | 568.55 | 568.55 | 568.55 | 500.0 |
| 2024-09-23 04:06:00 | SPY | ETF | 568.51 | 568.51 | 568.31 | 568.46 | 6956.0 |
| 2024-09-23 04:07:00 | SPY | ETF | 568.51 | 568.53 | 568.51 | 568.52 | 1800.0 |
| 2024-09-23 04:08:00 | SPY | ETF | 568.48 | 568.49 | 568.48 | 568.48 | 1643.0 |
| 2024-09-23 04:09:00 | SPY | ETF | 568.43 | 568.43 | 568.33 | 568.37 | 5784.0 |
| 2024-09-23 04:10:00 | SPY | ETF | 568.38 | 568.39 | 568.33 | 568.34 | 1819.0 |
| 2024-09-23 04:11:00 | SPY | ETF | 568.29 | 568.41 | 568.29 | 568.41 | 1741.0 |
| 2024-09-23 04:12:00 | SPY | ETF | 568.5 | 568.5 | 568.5 | 568.5 | 350.0 |
| 2024-09-23 04:13:00 | SPY | ETF | 568.29 | 568.29 | 568.04 | 568.13 | 19760.0 |
| 2024-09-23 04:14:00 | SPY | ETF | 568.17 | 568.2 | 568.15 | 568.17 | 4004.0 |
| 2024-09-23 04:15:00 | SPY | ETF | 568.2 | 568.32 | 568.2 | 568.2 | 800.0 |
| 2024-09-23 04:16:00 | SPY | ETF | 568.23 | 568.23 | 568.23 | 568.23 | 478.0 |
| 2024-09-23 04:17:00 | SPY | ETF | 568.1 | 568.1 | 568.1 | 568.1 | 100.0 |
| 2024-09-23 04:19:00 | SPY | ETF | 568.27 | 568.27 | 568.27 | 568.27 | 100.0 |
| 2024-09-23 04:22:00 | SPY | ETF | 568.37 | 568.37 | 568.37 | 568.37 | 200.0 |
| 2024-09-23 04:25:00 | SPY | ETF | 568.59 | 568.59 | 568.59 | 568.59 | 183.0 |
| 2024-09-23 04:27:00 | SPY | ETF | 568.71 | 568.79 | 568.71 | 568.73 | 8267.0 |
| 2024-09-23 04:28:00 | SPY | ETF | 568.75 | 568.78 | 568.68 | 568.68 | 3985.0 |
| 2024-09-23 04:29:00 | SPY | ETF | 568.66 | 568.66 | 568.66 | 568.66 | 1000.0 |
| 2024-09-23 04:30:00 | SPY | ETF | 568.59 | 568.59 | 568.59 | 568.59 | 200.0 |
| 2024-09-23 04:31:00 | SPY | ETF | 568.68 | 568.68 | 568.68 | 568.68 | 100.0 |
| 2024-09-23 04:32:00 | SPY | ETF | 568.3 | 568.3 | 568.3 | 568.3 | 374.0 |
| 2024-09-23 04:34:00 | SPY | ETF | 568.35 | 568.35 | 568.35 | 568.35 | 100.0 |
| 2024-09-23 04:35:00 | SPY | ETF | 568.35 | 568.35 | 568.35 | 568.35 | 200.0 |
| 2024-09-23 04:36:00 | SPY | ETF | 568.39 | 568.41 | 568.39 | 568.4 | 3000.0 |
| 2024-09-23 04:37:00 | SPY | ETF | 568.16 | 568.16 | 568.16 | 568.16 | 100.0 |
| 2024-09-23 04:38:00 | SPY | ETF | 568.08 | 568.08 | 568.08 | 568.08 | 500.0 |
| 2024-09-23 04:40:00 | SPY | ETF | 567.94 | 567.94 | 567.94 | 567.94 | 110.0 |
| 2024-09-23 04:41:00 | SPY | ETF | 567.86 | 568.04 | 567.86 | 568.04 | 765.0 |
| 2024-09-23 04:43:00 | SPY | ETF | 568.08 | 568.08 | 568.05 | 568.05 | 625.0 |
| 2024-09-23 04:45:00 | SPY | ETF | 568.1 | 568.1 | 568.01 | 568.01 | 998.0 |
| 2024-09-23 04:47:00 | SPY | ETF | 568.1 | 568.11 | 568.1 | 568.11 | 333.0 |
| 2024-09-23 04:48:00 | SPY | ETF | 568.2 | 568.2 | 568.2 | 568.2 | 100.0 |
| 2024-09-23 04:49:00 | SPY | ETF | 568.14 | 568.25 | 568.14 | 568.25 | 574.0 |
| 2024-09-23 04:50:00 | SPY | ETF | 568.38 | 568.42 | 568.38 | 568.42 | 500.0 |
| 2024-09-23 04:54:00 | SPY | ETF | 568.48 | 568.48 | 568.48 | 568.48 | 100.0 |
| 2024-09-23 04:55:00 | SPY | ETF | 568.57 | 568.57 | 568.57 | 568.57 | 100.0 |
| 2024-09-23 04:58:00 | SPY | ETF | 568.6 | 568.61 | 568.6 | 568.61 | 200.0 |
| 2024-09-23 04:59:00 | SPY | ETF | 568.56 | 568.56 | 568.55 | 568.55 | 200.0 |
| 2024-09-23 05:00:00 | SPY | ETF | 568.55 | 568.55 | 568.48 | 568.48 | 500.0 |
| 2024-09-23 05:01:00 | SPY | ETF | 568.48 | 568.49 | 568.48 | 568.49 | 561.0 |
| 2024-09-23 05:02:00 | SPY | ETF | 568.48 | 568.48 | 568.48 | 568.48 | 200.0 |
| 2024-09-23 05:03:00 | SPY | ETF | 568.53 | 568.53 | 568.53 | 568.53 | 200.0 |
| 2024-09-23 05:04:00 | SPY | ETF | 568.45 | 568.45 | 568.4 | 568.44 | 2182.0 |
| 2024-09-23 05:05:00 | SPY | ETF | 568.38 | 568.39 | 568.3 | 568.3 | 3400.0 |
| 2024-09-23 05:06:00 | SPY | ETF | 568.32 | 568.47 | 568.32 | 568.47 | 3285.0 |
> showing 50 of 293,250 rows — these rows as CSV