PREVIEW / etf_1min / 2024-08-02
file: by_date/etf_1min/2024/2024-08-02.parquet size: 6.1 MB rows: 356,277
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-02 04:00:00 | SPY | ETF | 538.9 | 539.92 | 538.03 | 538.06 | 2987.0 |
| 2024-08-02 04:01:00 | SPY | ETF | 538.1 | 538.17 | 538.1 | 538.17 | 729.0 |
| 2024-08-02 04:03:00 | SPY | ETF | 538.04 | 538.04 | 537.99 | 537.99 | 926.0 |
| 2024-08-02 04:04:00 | SPY | ETF | 537.99 | 538.07 | 537.92 | 538.07 | 1579.0 |
| 2024-08-02 04:05:00 | SPY | ETF | 537.97 | 537.97 | 537.87 | 537.87 | 458.0 |
| 2024-08-02 04:06:00 | SPY | ETF | 537.69 | 537.87 | 537.67 | 537.87 | 1184.0 |
| 2024-08-02 04:07:00 | SPY | ETF | 537.93 | 538.23 | 537.93 | 538.21 | 3624.0 |
| 2024-08-02 04:08:00 | SPY | ETF | 538.21 | 538.35 | 538.21 | 538.3 | 2596.0 |
| 2024-08-02 04:09:00 | SPY | ETF | 538.39 | 538.4 | 538.31 | 538.4 | 441.0 |
| 2024-08-02 04:10:00 | SPY | ETF | 538.14 | 538.19 | 538.14 | 538.16 | 1137.0 |
| 2024-08-02 04:12:00 | SPY | ETF | 537.95 | 537.95 | 537.95 | 537.95 | 500.0 |
| 2024-08-02 04:13:00 | SPY | ETF | 537.85 | 537.85 | 537.82 | 537.82 | 1400.0 |
| 2024-08-02 04:15:00 | SPY | ETF | 537.7 | 537.82 | 537.7 | 537.73 | 966.0 |
| 2024-08-02 04:17:00 | SPY | ETF | 537.5 | 537.5 | 537.5 | 537.5 | 625.0 |
| 2024-08-02 04:18:00 | SPY | ETF | 537.31 | 537.31 | 537.31 | 537.31 | 100.0 |
| 2024-08-02 04:19:00 | SPY | ETF | 537.58 | 537.58 | 537.58 | 537.58 | 100.0 |
| 2024-08-02 04:20:00 | SPY | ETF | 537.58 | 537.63 | 537.44 | 537.5 | 5524.0 |
| 2024-08-02 04:21:00 | SPY | ETF | 537.58 | 537.58 | 537.15 | 537.15 | 300.0 |
| 2024-08-02 04:22:00 | SPY | ETF | 537.28 | 537.28 | 537.28 | 537.28 | 300.0 |
| 2024-08-02 04:23:00 | SPY | ETF | 537.21 | 537.21 | 537.17 | 537.17 | 300.0 |
| 2024-08-02 04:24:00 | SPY | ETF | 537.37 | 537.51 | 537.37 | 537.51 | 2872.0 |
| 2024-08-02 04:25:00 | SPY | ETF | 537.53 | 537.53 | 537.41 | 537.52 | 2455.0 |
| 2024-08-02 04:26:00 | SPY | ETF | 537.7 | 537.75 | 537.7 | 537.74 | 400.0 |
| 2024-08-02 04:27:00 | SPY | ETF | 537.76 | 537.88 | 537.74 | 537.88 | 1000.0 |
| 2024-08-02 04:29:00 | SPY | ETF | 537.95 | 538.06 | 537.95 | 538.06 | 581.0 |
| 2024-08-02 04:30:00 | SPY | ETF | 538.07 | 538.15 | 538.07 | 538.15 | 1000.0 |
| 2024-08-02 04:31:00 | SPY | ETF | 538.04 | 538.13 | 538.04 | 538.13 | 422.0 |
| 2024-08-02 04:32:00 | SPY | ETF | 538.14 | 538.2 | 538.14 | 538.2 | 600.0 |
| 2024-08-02 04:33:00 | SPY | ETF | 537.87 | 537.87 | 537.87 | 537.87 | 165.0 |
| 2024-08-02 04:34:00 | SPY | ETF | 538.11 | 538.11 | 538.11 | 538.11 | 100.0 |
| 2024-08-02 04:35:00 | SPY | ETF | 538.29 | 538.3 | 538.24 | 538.24 | 542.0 |
| 2024-08-02 04:40:00 | SPY | ETF | 538.05 | 538.05 | 538.05 | 538.05 | 100.0 |
| 2024-08-02 04:41:00 | SPY | ETF | 537.92 | 537.92 | 537.92 | 537.92 | 500.0 |
| 2024-08-02 04:42:00 | SPY | ETF | 537.8 | 537.8 | 537.8 | 537.8 | 100.0 |
| 2024-08-02 04:44:00 | SPY | ETF | 538.05 | 538.05 | 538.05 | 538.05 | 100.0 |
| 2024-08-02 04:45:00 | SPY | ETF | 538.13 | 538.13 | 538.13 | 538.13 | 100.0 |
| 2024-08-02 04:46:00 | SPY | ETF | 538.21 | 538.21 | 538.21 | 538.21 | 100.0 |
| 2024-08-02 04:48:00 | SPY | ETF | 538.09 | 538.09 | 537.98 | 537.98 | 438.0 |
| 2024-08-02 04:50:00 | SPY | ETF | 537.88 | 537.89 | 537.84 | 537.84 | 667.0 |
| 2024-08-02 04:52:00 | SPY | ETF | 537.95 | 537.98 | 537.95 | 537.98 | 400.0 |
| 2024-08-02 04:53:00 | SPY | ETF | 538.0 | 538.08 | 538.0 | 538.08 | 400.0 |
| 2024-08-02 04:54:00 | SPY | ETF | 538.09 | 538.21 | 538.09 | 538.21 | 3582.0 |
| 2024-08-02 04:56:00 | SPY | ETF | 538.4 | 538.4 | 538.4 | 538.4 | 100.0 |
| 2024-08-02 04:57:00 | SPY | ETF | 538.35 | 538.49 | 538.35 | 538.49 | 992.0 |
| 2024-08-02 05:00:00 | SPY | ETF | 538.4 | 538.4 | 538.4 | 538.4 | 553.0 |
| 2024-08-02 05:01:00 | SPY | ETF | 538.23 | 538.23 | 538.23 | 538.23 | 300.0 |
| 2024-08-02 05:03:00 | SPY | ETF | 538.33 | 538.33 | 538.33 | 538.33 | 100.0 |
| 2024-08-02 05:05:00 | SPY | ETF | 537.99 | 537.99 | 537.84 | 537.84 | 1203.0 |
| 2024-08-02 05:06:00 | SPY | ETF | 537.88 | 537.97 | 537.8 | 537.97 | 6350.0 |
| 2024-08-02 05:07:00 | SPY | ETF | 538.0 | 538.0 | 537.99 | 537.99 | 382.0 |
> showing 50 of 356,277 rows — these rows as CSV