PREVIEW / etf_1min / 2024-08-15
file: by_date/etf_1min/2024/2024-08-15.parquet size: 5.2 MB rows: 294,926
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-08-15 04:00:00 | SPY | ETF | 545.37 | 545.37 | 545.37 | 545.37 | 700.0 |
| 2024-08-15 04:02:00 | SPY | ETF | 545.35 | 545.36 | 545.27 | 545.36 | 940.0 |
| 2024-08-15 04:03:00 | SPY | ETF | 545.37 | 545.37 | 545.37 | 545.37 | 146.0 |
| 2024-08-15 04:05:00 | SPY | ETF | 545.35 | 545.35 | 545.3 | 545.3 | 1257.0 |
| 2024-08-15 04:06:00 | SPY | ETF | 545.35 | 545.44 | 545.35 | 545.44 | 431.0 |
| 2024-08-15 04:09:00 | SPY | ETF | 545.3 | 545.3 | 545.28 | 545.28 | 1028.0 |
| 2024-08-15 04:10:00 | SPY | ETF | 545.21 | 545.21 | 545.18 | 545.18 | 200.0 |
| 2024-08-15 04:11:00 | SPY | ETF | 545.04 | 545.04 | 545.04 | 545.04 | 112.0 |
| 2024-08-15 04:12:00 | SPY | ETF | 545.11 | 545.17 | 545.11 | 545.17 | 1010.0 |
| 2024-08-15 04:13:00 | SPY | ETF | 545.14 | 545.14 | 545.01 | 545.01 | 676.0 |
| 2024-08-15 04:17:00 | SPY | ETF | 545.11 | 545.11 | 545.11 | 545.11 | 200.0 |
| 2024-08-15 04:18:00 | SPY | ETF | 544.99 | 544.99 | 544.99 | 544.99 | 571.0 |
| 2024-08-15 04:19:00 | SPY | ETF | 545.0 | 545.0 | 545.0 | 545.0 | 100.0 |
| 2024-08-15 04:20:00 | SPY | ETF | 545.04 | 545.04 | 545.04 | 545.04 | 203.0 |
| 2024-08-15 04:21:00 | SPY | ETF | 544.98 | 545.0 | 544.98 | 544.99 | 516.0 |
| 2024-08-15 04:24:00 | SPY | ETF | 544.8 | 544.8 | 544.76 | 544.76 | 600.0 |
| 2024-08-15 04:26:00 | SPY | ETF | 544.81 | 544.81 | 544.75 | 544.75 | 700.0 |
| 2024-08-15 04:27:00 | SPY | ETF | 544.77 | 544.77 | 544.77 | 544.77 | 882.0 |
| 2024-08-15 04:28:00 | SPY | ETF | 544.73 | 544.73 | 544.7 | 544.73 | 3700.0 |
| 2024-08-15 04:29:00 | SPY | ETF | 544.63 | 544.63 | 544.61 | 544.61 | 561.0 |
| 2024-08-15 04:34:00 | SPY | ETF | 544.4 | 544.4 | 544.4 | 544.4 | 100.0 |
| 2024-08-15 04:35:00 | SPY | ETF | 544.21 | 544.21 | 544.11 | 544.11 | 900.0 |
| 2024-08-15 04:36:00 | SPY | ETF | 544.3 | 544.3 | 544.3 | 544.3 | 200.0 |
| 2024-08-15 04:37:00 | SPY | ETF | 544.25 | 544.3 | 544.25 | 544.29 | 471.0 |
| 2024-08-15 04:38:00 | SPY | ETF | 544.25 | 544.25 | 544.25 | 544.25 | 200.0 |
| 2024-08-15 04:39:00 | SPY | ETF | 544.27 | 544.35 | 544.27 | 544.35 | 450.0 |
| 2024-08-15 04:40:00 | SPY | ETF | 544.42 | 544.43 | 544.42 | 544.43 | 532.0 |
| 2024-08-15 04:43:00 | SPY | ETF | 544.41 | 544.41 | 544.41 | 544.41 | 736.0 |
| 2024-08-15 04:45:00 | SPY | ETF | 544.73 | 544.73 | 544.73 | 544.73 | 103.0 |
| 2024-08-15 04:50:00 | SPY | ETF | 544.54 | 544.54 | 544.54 | 544.54 | 142.0 |
| 2024-08-15 04:54:00 | SPY | ETF | 544.64 | 544.64 | 544.64 | 544.64 | 200.0 |
| 2024-08-15 05:21:00 | SPY | ETF | 544.82 | 544.83 | 544.82 | 544.83 | 4877.0 |
| 2024-08-15 05:23:00 | SPY | ETF | 544.82 | 544.82 | 544.82 | 544.82 | 144.0 |
| 2024-08-15 05:26:00 | SPY | ETF | 544.76 | 544.76 | 544.76 | 544.76 | 502.0 |
| 2024-08-15 05:27:00 | SPY | ETF | 544.7 | 544.7 | 544.7 | 544.7 | 200.0 |
| 2024-08-15 05:28:00 | SPY | ETF | 544.71 | 544.71 | 544.71 | 544.71 | 1134.0 |
| 2024-08-15 05:29:00 | SPY | ETF | 544.86 | 544.86 | 544.86 | 544.86 | 100.0 |
| 2024-08-15 05:31:00 | SPY | ETF | 544.9 | 544.9 | 544.9 | 544.9 | 495.0 |
| 2024-08-15 05:35:00 | SPY | ETF | 544.95 | 544.95 | 544.95 | 544.95 | 100.0 |
| 2024-08-15 05:36:00 | SPY | ETF | 544.91 | 544.91 | 544.84 | 544.84 | 775.0 |
| 2024-08-15 05:40:00 | SPY | ETF | 544.81 | 544.81 | 544.8 | 544.8 | 224.0 |
| 2024-08-15 05:45:00 | SPY | ETF | 544.69 | 544.69 | 544.69 | 544.69 | 100.0 |
| 2024-08-15 05:59:00 | SPY | ETF | 544.91 | 544.91 | 544.91 | 544.91 | 144.0 |
| 2024-08-15 06:01:00 | SPY | ETF | 544.99 | 545.0 | 544.99 | 545.0 | 300.0 |
| 2024-08-15 06:02:00 | SPY | ETF | 545.04 | 545.05 | 545.04 | 545.05 | 908.0 |
| 2024-08-15 06:06:00 | SPY | ETF | 544.92 | 544.92 | 544.9 | 544.9 | 399.0 |
| 2024-08-15 06:15:00 | SPY | ETF | 544.71 | 544.71 | 544.71 | 544.71 | 750.0 |
| 2024-08-15 06:16:00 | SPY | ETF | 544.71 | 544.75 | 544.71 | 544.75 | 1940.0 |
| 2024-08-15 06:17:00 | SPY | ETF | 544.74 | 544.74 | 544.74 | 544.74 | 100.0 |
| 2024-08-15 06:18:00 | SPY | ETF | 544.7 | 544.7 | 544.6 | 544.6 | 809.0 |
> showing 50 of 294,926 rows — these rows as CSV