PREVIEW / etf_1min / 2023-08-31
file: by_date/etf_1min/2023/2023-08-31.parquet size: 4.5 MB rows: 251,545
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-31 04:00:00 | SPY | ETF | 451.93 | 451.93 | 451.42 | 451.93 | 2452.0 |
| 2023-08-31 04:01:00 | SPY | ETF | 451.89 | 451.9 | 451.89 | 451.9 | 217.0 |
| 2023-08-31 04:02:00 | SPY | ETF | 451.85 | 451.85 | 451.85 | 451.85 | 100.0 |
| 2023-08-31 04:03:00 | SPY | ETF | 451.84 | 451.84 | 451.73 | 451.73 | 500.0 |
| 2023-08-31 04:04:00 | SPY | ETF | 451.69 | 451.69 | 451.69 | 451.69 | 109.0 |
| 2023-08-31 04:05:00 | SPY | ETF | 451.74 | 451.77 | 451.74 | 451.77 | 635.0 |
| 2023-08-31 04:06:00 | SPY | ETF | 451.77 | 451.77 | 451.77 | 451.77 | 109.0 |
| 2023-08-31 04:07:00 | SPY | ETF | 451.79 | 451.79 | 451.79 | 451.79 | 1300.0 |
| 2023-08-31 04:11:00 | SPY | ETF | 451.86 | 451.9 | 451.86 | 451.9 | 975.0 |
| 2023-08-31 04:12:00 | SPY | ETF | 451.9 | 451.9 | 451.9 | 451.9 | 1550.0 |
| 2023-08-31 04:13:00 | SPY | ETF | 451.93 | 451.93 | 451.93 | 451.93 | 100.0 |
| 2023-08-31 04:14:00 | SPY | ETF | 451.94 | 451.97 | 451.94 | 451.97 | 207.0 |
| 2023-08-31 04:15:00 | SPY | ETF | 451.92 | 451.92 | 451.91 | 451.91 | 200.0 |
| 2023-08-31 04:16:00 | SPY | ETF | 451.91 | 451.91 | 451.82 | 451.82 | 929.0 |
| 2023-08-31 04:17:00 | SPY | ETF | 451.82 | 451.82 | 451.74 | 451.74 | 389.0 |
| 2023-08-31 04:18:00 | SPY | ETF | 451.79 | 451.79 | 451.79 | 451.79 | 500.0 |
| 2023-08-31 04:19:00 | SPY | ETF | 451.8 | 451.8 | 451.8 | 451.8 | 701.0 |
| 2023-08-31 04:21:00 | SPY | ETF | 451.82 | 451.82 | 451.82 | 451.82 | 127.0 |
| 2023-08-31 04:27:00 | SPY | ETF | 451.74 | 451.74 | 451.74 | 451.74 | 400.0 |
| 2023-08-31 04:29:00 | SPY | ETF | 451.79 | 451.79 | 451.79 | 451.79 | 500.0 |
| 2023-08-31 04:31:00 | SPY | ETF | 451.8 | 451.82 | 451.8 | 451.82 | 421.0 |
| 2023-08-31 04:33:00 | SPY | ETF | 451.85 | 451.85 | 451.85 | 451.85 | 100.0 |
| 2023-08-31 04:37:00 | SPY | ETF | 451.68 | 451.68 | 451.67 | 451.67 | 1800.0 |
| 2023-08-31 04:40:00 | SPY | ETF | 451.8 | 451.8 | 451.8 | 451.8 | 250.0 |
| 2023-08-31 04:43:00 | SPY | ETF | 451.74 | 451.74 | 451.74 | 451.74 | 300.0 |
| 2023-08-31 04:44:00 | SPY | ETF | 451.79 | 451.79 | 451.78 | 451.79 | 1064.0 |
| 2023-08-31 04:47:00 | SPY | ETF | 451.84 | 451.84 | 451.84 | 451.84 | 100.0 |
| 2023-08-31 04:49:00 | SPY | ETF | 451.85 | 451.85 | 451.85 | 451.85 | 205.0 |
| 2023-08-31 04:52:00 | SPY | ETF | 451.8 | 451.8 | 451.8 | 451.8 | 1300.0 |
| 2023-08-31 04:53:00 | SPY | ETF | 451.8 | 451.8 | 451.8 | 451.8 | 1500.0 |
| 2023-08-31 04:59:00 | SPY | ETF | 451.86 | 451.86 | 451.86 | 451.86 | 100.0 |
| 2023-08-31 05:00:00 | SPY | ETF | 451.93 | 451.93 | 451.93 | 451.93 | 100.0 |
| 2023-08-31 05:01:00 | SPY | ETF | 451.84 | 451.84 | 451.7 | 451.7 | 330.0 |
| 2023-08-31 05:02:00 | SPY | ETF | 451.68 | 451.68 | 451.58 | 451.58 | 2200.0 |
| 2023-08-31 05:03:00 | SPY | ETF | 451.63 | 451.63 | 451.63 | 451.63 | 100.0 |
| 2023-08-31 05:04:00 | SPY | ETF | 451.59 | 451.59 | 451.59 | 451.59 | 500.0 |
| 2023-08-31 05:05:00 | SPY | ETF | 451.67 | 451.67 | 451.59 | 451.6 | 3400.0 |
| 2023-08-31 05:06:00 | SPY | ETF | 451.53 | 451.55 | 451.5 | 451.55 | 5990.0 |
| 2023-08-31 05:10:00 | SPY | ETF | 451.44 | 451.44 | 451.41 | 451.41 | 226.0 |
| 2023-08-31 05:11:00 | SPY | ETF | 451.38 | 451.38 | 451.32 | 451.32 | 2198.0 |
| 2023-08-31 05:12:00 | SPY | ETF | 451.23 | 451.25 | 451.22 | 451.22 | 600.0 |
| 2023-08-31 05:13:00 | SPY | ETF | 451.32 | 451.32 | 451.32 | 451.32 | 250.0 |
| 2023-08-31 05:14:00 | SPY | ETF | 451.45 | 451.45 | 451.45 | 451.45 | 125.0 |
| 2023-08-31 05:15:00 | SPY | ETF | 451.43 | 451.43 | 451.43 | 451.43 | 131.0 |
| 2023-08-31 05:16:00 | SPY | ETF | 451.49 | 451.49 | 451.49 | 451.49 | 1035.0 |
| 2023-08-31 05:18:00 | SPY | ETF | 451.58 | 451.58 | 451.58 | 451.58 | 100.0 |
| 2023-08-31 05:23:00 | SPY | ETF | 451.42 | 451.45 | 451.41 | 451.45 | 400.0 |
| 2023-08-31 05:24:00 | SPY | ETF | 451.46 | 451.46 | 451.46 | 451.46 | 200.0 |
| 2023-08-31 05:25:00 | SPY | ETF | 451.48 | 451.48 | 451.48 | 451.48 | 1000.0 |
| 2023-08-31 05:29:00 | SPY | ETF | 451.46 | 451.46 | 451.46 | 451.46 | 112.0 |
> showing 50 of 251,545 rows — these rows as CSV