PREVIEW / etf_1min / 2024-06-24
file: by_date/etf_1min/2024/2024-06-24.parquet size: 5.2 MB rows: 291,410
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-06-24 04:00:00 | SPY | ETF | 545.12 | 545.49 | 544.4 | 545.49 | 4340.0 |
| 2024-06-24 04:01:00 | SPY | ETF | 545.36 | 545.36 | 545.24 | 545.29 | 600.0 |
| 2024-06-24 04:02:00 | SPY | ETF | 545.26 | 545.35 | 545.26 | 545.34 | 968.0 |
| 2024-06-24 04:03:00 | SPY | ETF | 545.39 | 545.4 | 545.39 | 545.4 | 206.0 |
| 2024-06-24 04:04:00 | SPY | ETF | 545.23 | 545.31 | 545.21 | 545.31 | 2822.0 |
| 2024-06-24 04:06:00 | SPY | ETF | 545.31 | 545.4 | 545.25 | 545.4 | 1100.0 |
| 2024-06-24 04:07:00 | SPY | ETF | 545.47 | 545.47 | 545.36 | 545.36 | 600.0 |
| 2024-06-24 04:08:00 | SPY | ETF | 545.46 | 545.46 | 545.46 | 545.46 | 305.0 |
| 2024-06-24 04:09:00 | SPY | ETF | 545.5 | 545.56 | 545.46 | 545.54 | 1125.0 |
| 2024-06-24 04:10:00 | SPY | ETF | 545.54 | 545.55 | 545.54 | 545.55 | 468.0 |
| 2024-06-24 04:11:00 | SPY | ETF | 545.55 | 545.55 | 545.45 | 545.45 | 660.0 |
| 2024-06-24 04:12:00 | SPY | ETF | 545.53 | 545.62 | 545.53 | 545.62 | 314.0 |
| 2024-06-24 04:14:00 | SPY | ETF | 545.53 | 545.53 | 545.53 | 545.53 | 400.0 |
| 2024-06-24 04:16:00 | SPY | ETF | 545.59 | 545.59 | 545.58 | 545.58 | 434.0 |
| 2024-06-24 04:19:00 | SPY | ETF | 545.47 | 545.47 | 545.47 | 545.47 | 650.0 |
| 2024-06-24 04:20:00 | SPY | ETF | 545.49 | 545.49 | 545.49 | 545.49 | 500.0 |
| 2024-06-24 04:21:00 | SPY | ETF | 545.5 | 545.5 | 545.5 | 545.5 | 100.0 |
| 2024-06-24 04:24:00 | SPY | ETF | 545.54 | 545.6 | 545.54 | 545.6 | 635.0 |
| 2024-06-24 04:25:00 | SPY | ETF | 545.61 | 545.66 | 545.61 | 545.66 | 599.0 |
| 2024-06-24 04:29:00 | SPY | ETF | 545.73 | 545.73 | 545.73 | 545.73 | 100.0 |
| 2024-06-24 04:31:00 | SPY | ETF | 545.6 | 545.6 | 545.6 | 545.6 | 200.0 |
| 2024-06-24 04:33:00 | SPY | ETF | 545.55 | 545.55 | 545.55 | 545.55 | 400.0 |
| 2024-06-24 04:37:00 | SPY | ETF | 545.52 | 545.52 | 545.52 | 545.52 | 2000.0 |
| 2024-06-24 04:41:00 | SPY | ETF | 545.57 | 545.57 | 545.57 | 545.57 | 100.0 |
| 2024-06-24 04:44:00 | SPY | ETF | 545.58 | 545.58 | 545.58 | 545.58 | 162.0 |
| 2024-06-24 04:46:00 | SPY | ETF | 545.57 | 545.57 | 545.57 | 545.57 | 200.0 |
| 2024-06-24 04:53:00 | SPY | ETF | 545.37 | 545.4 | 545.37 | 545.4 | 250.0 |
| 2024-06-24 04:54:00 | SPY | ETF | 545.41 | 545.41 | 545.41 | 545.41 | 100.0 |
| 2024-06-24 04:59:00 | SPY | ETF | 545.38 | 545.38 | 545.38 | 545.38 | 990.0 |
| 2024-06-24 05:02:00 | SPY | ETF | 545.49 | 545.49 | 545.49 | 545.49 | 100.0 |
| 2024-06-24 05:03:00 | SPY | ETF | 545.4 | 545.4 | 545.4 | 545.4 | 184.0 |
| 2024-06-24 05:04:00 | SPY | ETF | 545.36 | 545.36 | 545.36 | 545.36 | 100.0 |
| 2024-06-24 05:08:00 | SPY | ETF | 545.49 | 545.49 | 545.49 | 545.49 | 150.0 |
| 2024-06-24 05:11:00 | SPY | ETF | 545.31 | 545.31 | 545.31 | 545.31 | 525.0 |
| 2024-06-24 05:15:00 | SPY | ETF | 545.21 | 545.21 | 545.21 | 545.21 | 1600.0 |
| 2024-06-24 05:17:00 | SPY | ETF | 545.23 | 545.23 | 545.18 | 545.18 | 475.0 |
| 2024-06-24 05:18:00 | SPY | ETF | 545.22 | 545.22 | 545.22 | 545.22 | 100.0 |
| 2024-06-24 05:20:00 | SPY | ETF | 545.25 | 545.25 | 545.25 | 545.25 | 500.0 |
| 2024-06-24 05:22:00 | SPY | ETF | 545.33 | 545.33 | 545.33 | 545.33 | 200.0 |
| 2024-06-24 05:24:00 | SPY | ETF | 545.36 | 545.36 | 545.36 | 545.36 | 198.0 |
| 2024-06-24 05:25:00 | SPY | ETF | 545.32 | 545.32 | 545.32 | 545.32 | 100.0 |
| 2024-06-24 05:29:00 | SPY | ETF | 545.25 | 545.25 | 545.25 | 545.25 | 501.0 |
| 2024-06-24 05:30:00 | SPY | ETF | 545.1 | 545.1 | 545.1 | 545.1 | 122.0 |
| 2024-06-24 05:31:00 | SPY | ETF | 545.11 | 545.11 | 545.11 | 545.11 | 200.0 |
| 2024-06-24 05:32:00 | SPY | ETF | 545.09 | 545.09 | 545.09 | 545.09 | 100.0 |
| 2024-06-24 05:33:00 | SPY | ETF | 545.01 | 545.01 | 544.91 | 544.91 | 900.0 |
| 2024-06-24 05:34:00 | SPY | ETF | 544.98 | 544.98 | 544.98 | 544.98 | 100.0 |
| 2024-06-24 05:36:00 | SPY | ETF | 544.96 | 544.96 | 544.96 | 544.96 | 331.0 |
| 2024-06-24 05:40:00 | SPY | ETF | 544.97 | 544.97 | 544.97 | 544.97 | 100.0 |
| 2024-06-24 05:45:00 | SPY | ETF | 544.82 | 544.82 | 544.82 | 544.82 | 100.0 |
> showing 50 of 291,410 rows — these rows as CSV