PREVIEW / etf_1min / 2024-05-15
file: by_date/etf_1min/2024/2024-05-15.parquet size: 5.2 MB rows: 295,235
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-05-15 04:00:00 | SPY | ETF | 523.5 | 523.5 | 523.47 | 523.5 | 5499.0 |
| 2024-05-15 04:03:00 | SPY | ETF | 523.53 | 523.58 | 523.53 | 523.58 | 207.0 |
| 2024-05-15 04:05:00 | SPY | ETF | 523.54 | 523.54 | 523.54 | 523.54 | 374.0 |
| 2024-05-15 04:08:00 | SPY | ETF | 523.52 | 523.52 | 523.52 | 523.52 | 105.0 |
| 2024-05-15 04:11:00 | SPY | ETF | 523.5 | 523.51 | 523.5 | 523.51 | 900.0 |
| 2024-05-15 04:14:00 | SPY | ETF | 523.52 | 523.52 | 523.52 | 523.52 | 100.0 |
| 2024-05-15 04:15:00 | SPY | ETF | 523.56 | 523.56 | 523.56 | 523.56 | 625.0 |
| 2024-05-15 04:18:00 | SPY | ETF | 523.48 | 523.48 | 523.48 | 523.48 | 1847.0 |
| 2024-05-15 04:20:00 | SPY | ETF | 523.46 | 523.46 | 523.46 | 523.46 | 200.0 |
| 2024-05-15 04:25:00 | SPY | ETF | 523.45 | 523.45 | 523.45 | 523.45 | 500.0 |
| 2024-05-15 04:32:00 | SPY | ETF | 523.56 | 523.56 | 523.56 | 523.56 | 100.0 |
| 2024-05-15 04:35:00 | SPY | ETF | 523.65 | 523.65 | 523.65 | 523.65 | 100.0 |
| 2024-05-15 04:43:00 | SPY | ETF | 523.58 | 523.58 | 523.58 | 523.58 | 499.0 |
| 2024-05-15 04:49:00 | SPY | ETF | 523.56 | 523.56 | 523.53 | 523.53 | 500.0 |
| 2024-05-15 04:50:00 | SPY | ETF | 523.53 | 523.53 | 523.53 | 523.53 | 115.0 |
| 2024-05-15 04:51:00 | SPY | ETF | 523.54 | 523.65 | 523.54 | 523.65 | 3500.0 |
| 2024-05-15 04:52:00 | SPY | ETF | 523.66 | 523.68 | 523.66 | 523.68 | 2992.0 |
| 2024-05-15 04:53:00 | SPY | ETF | 523.71 | 523.73 | 523.68 | 523.72 | 3141.0 |
| 2024-05-15 04:54:00 | SPY | ETF | 523.67 | 523.69 | 523.67 | 523.69 | 300.0 |
| 2024-05-15 04:58:00 | SPY | ETF | 523.73 | 523.75 | 523.73 | 523.75 | 200.0 |
| 2024-05-15 05:04:00 | SPY | ETF | 523.77 | 523.82 | 523.77 | 523.82 | 1600.0 |
| 2024-05-15 05:06:00 | SPY | ETF | 523.72 | 523.77 | 523.72 | 523.77 | 3900.0 |
| 2024-05-15 05:07:00 | SPY | ETF | 523.77 | 523.78 | 523.76 | 523.78 | 12500.0 |
| 2024-05-15 05:08:00 | SPY | ETF | 523.77 | 523.78 | 523.77 | 523.78 | 4901.0 |
| 2024-05-15 05:13:00 | SPY | ETF | 523.79 | 523.79 | 523.79 | 523.79 | 100.0 |
| 2024-05-15 05:16:00 | SPY | ETF | 523.81 | 523.81 | 523.81 | 523.81 | 200.0 |
| 2024-05-15 05:19:00 | SPY | ETF | 523.73 | 523.73 | 523.73 | 523.73 | 357.0 |
| 2024-05-15 05:28:00 | SPY | ETF | 523.65 | 523.65 | 523.65 | 523.65 | 100.0 |
| 2024-05-15 05:32:00 | SPY | ETF | 523.7 | 523.7 | 523.7 | 523.7 | 100.0 |
| 2024-05-15 05:35:00 | SPY | ETF | 523.71 | 523.72 | 523.71 | 523.72 | 635.0 |
| 2024-05-15 05:36:00 | SPY | ETF | 523.72 | 523.72 | 523.72 | 523.72 | 399.0 |
| 2024-05-15 05:40:00 | SPY | ETF | 523.75 | 523.76 | 523.75 | 523.76 | 955.0 |
| 2024-05-15 05:43:00 | SPY | ETF | 523.72 | 523.72 | 523.72 | 523.72 | 100.0 |
| 2024-05-15 05:54:00 | SPY | ETF | 523.78 | 523.78 | 523.78 | 523.78 | 100.0 |
| 2024-05-15 06:03:00 | SPY | ETF | 523.71 | 523.71 | 523.65 | 523.65 | 1300.0 |
| 2024-05-15 06:08:00 | SPY | ETF | 523.63 | 523.63 | 523.61 | 523.61 | 1590.0 |
| 2024-05-15 06:17:00 | SPY | ETF | 523.62 | 523.62 | 523.62 | 523.62 | 1387.0 |
| 2024-05-15 06:24:00 | SPY | ETF | 523.65 | 523.65 | 523.65 | 523.65 | 132.0 |
| 2024-05-15 06:29:00 | SPY | ETF | 523.64 | 523.64 | 523.6 | 523.6 | 599.0 |
| 2024-05-15 06:39:00 | SPY | ETF | 523.59 | 523.59 | 523.59 | 523.59 | 100.0 |
| 2024-05-15 06:47:00 | SPY | ETF | 523.61 | 523.61 | 523.61 | 523.61 | 100.0 |
| 2024-05-15 06:50:00 | SPY | ETF | 523.61 | 523.61 | 523.61 | 523.61 | 500.0 |
| 2024-05-15 06:52:00 | SPY | ETF | 523.61 | 523.61 | 523.61 | 523.61 | 400.0 |
| 2024-05-15 06:53:00 | SPY | ETF | 523.61 | 523.61 | 523.61 | 523.61 | 500.0 |
| 2024-05-15 06:59:00 | SPY | ETF | 523.57 | 523.57 | 523.57 | 523.57 | 100.0 |
| 2024-05-15 07:00:00 | SPY | ETF | 523.6 | 523.63 | 523.6 | 523.63 | 456.0 |
| 2024-05-15 07:01:00 | SPY | ETF | 523.63 | 523.63 | 523.63 | 523.63 | 1900.0 |
| 2024-05-15 07:02:00 | SPY | ETF | 523.65 | 523.78 | 523.65 | 523.66 | 8541.0 |
| 2024-05-15 07:04:00 | SPY | ETF | 523.6 | 523.6 | 523.6 | 523.6 | 200.0 |
| 2024-05-15 07:05:00 | SPY | ETF | 523.58 | 523.58 | 523.58 | 523.58 | 500.0 |
> showing 50 of 295,235 rows — these rows as CSV