PREVIEW / etf_1min / 2023-05-17
file: by_date/etf_1min/2023/2023-05-17.parquet size: 4.5 MB rows: 251,460
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-05-17 04:00:00 | SPY | ETF | 410.76 | 410.76 | 410.76 | 410.76 | 200.0 |
| 2023-05-17 04:02:00 | SPY | ETF | 410.74 | 410.74 | 410.73 | 410.73 | 1300.0 |
| 2023-05-17 04:04:00 | SPY | ETF | 410.78 | 410.85 | 410.78 | 410.82 | 2357.0 |
| 2023-05-17 04:05:00 | SPY | ETF | 410.86 | 410.96 | 410.86 | 410.96 | 600.0 |
| 2023-05-17 04:06:00 | SPY | ETF | 411.0 | 411.0 | 410.94 | 410.94 | 338.0 |
| 2023-05-17 04:07:00 | SPY | ETF | 411.0 | 411.04 | 411.0 | 411.04 | 300.0 |
| 2023-05-17 04:08:00 | SPY | ETF | 411.05 | 411.1 | 411.05 | 411.1 | 1000.0 |
| 2023-05-17 04:09:00 | SPY | ETF | 411.17 | 411.25 | 411.17 | 411.25 | 1476.0 |
| 2023-05-17 04:11:00 | SPY | ETF | 411.11 | 411.11 | 411.11 | 411.11 | 500.0 |
| 2023-05-17 04:15:00 | SPY | ETF | 411.26 | 411.26 | 411.26 | 411.26 | 102.0 |
| 2023-05-17 04:16:00 | SPY | ETF | 411.16 | 411.16 | 411.16 | 411.16 | 600.0 |
| 2023-05-17 04:17:00 | SPY | ETF | 411.21 | 411.21 | 411.1 | 411.15 | 414.0 |
| 2023-05-17 04:18:00 | SPY | ETF | 411.15 | 411.15 | 411.15 | 411.15 | 500.0 |
| 2023-05-17 04:19:00 | SPY | ETF | 411.25 | 411.32 | 411.25 | 411.32 | 600.0 |
| 2023-05-17 04:21:00 | SPY | ETF | 411.32 | 411.33 | 411.32 | 411.33 | 2532.0 |
| 2023-05-17 04:22:00 | SPY | ETF | 411.4 | 411.4 | 411.4 | 411.4 | 400.0 |
| 2023-05-17 04:23:00 | SPY | ETF | 411.32 | 411.32 | 411.32 | 411.32 | 200.0 |
| 2023-05-17 04:24:00 | SPY | ETF | 411.32 | 411.34 | 411.32 | 411.34 | 650.0 |
| 2023-05-17 04:25:00 | SPY | ETF | 411.35 | 411.36 | 411.35 | 411.36 | 1429.0 |
| 2023-05-17 04:26:00 | SPY | ETF | 411.38 | 411.41 | 411.38 | 411.41 | 2100.0 |
| 2023-05-17 04:29:00 | SPY | ETF | 411.34 | 411.34 | 411.31 | 411.31 | 600.0 |
| 2023-05-17 04:30:00 | SPY | ETF | 411.31 | 411.37 | 411.31 | 411.37 | 600.0 |
| 2023-05-17 04:31:00 | SPY | ETF | 411.43 | 411.43 | 411.43 | 411.43 | 300.0 |
| 2023-05-17 04:32:00 | SPY | ETF | 411.44 | 411.44 | 411.44 | 411.44 | 304.0 |
| 2023-05-17 04:33:00 | SPY | ETF | 411.4 | 411.4 | 411.4 | 411.4 | 4841.0 |
| 2023-05-17 04:34:00 | SPY | ETF | 411.37 | 411.37 | 411.37 | 411.37 | 124.0 |
| 2023-05-17 04:36:00 | SPY | ETF | 411.43 | 411.43 | 411.43 | 411.43 | 140.0 |
| 2023-05-17 04:37:00 | SPY | ETF | 411.44 | 411.45 | 411.44 | 411.45 | 2360.0 |
| 2023-05-17 04:38:00 | SPY | ETF | 411.42 | 411.45 | 411.42 | 411.45 | 600.0 |
| 2023-05-17 04:41:00 | SPY | ETF | 411.34 | 411.34 | 411.34 | 411.34 | 300.0 |
| 2023-05-17 04:46:00 | SPY | ETF | 411.41 | 411.41 | 411.41 | 411.41 | 1236.0 |
| 2023-05-17 04:52:00 | SPY | ETF | 411.4 | 411.4 | 411.4 | 411.4 | 600.0 |
| 2023-05-17 04:53:00 | SPY | ETF | 411.33 | 411.33 | 411.3 | 411.3 | 500.0 |
| 2023-05-17 04:57:00 | SPY | ETF | 411.25 | 411.25 | 411.25 | 411.25 | 100.0 |
| 2023-05-17 05:00:00 | SPY | ETF | 411.4 | 411.4 | 411.4 | 411.4 | 400.0 |
| 2023-05-17 05:02:00 | SPY | ETF | 411.35 | 411.35 | 411.35 | 411.35 | 125.0 |
| 2023-05-17 05:06:00 | SPY | ETF | 411.29 | 411.29 | 411.29 | 411.29 | 100.0 |
| 2023-05-17 05:10:00 | SPY | ETF | 411.21 | 411.21 | 411.21 | 411.21 | 500.0 |
| 2023-05-17 05:11:00 | SPY | ETF | 411.2 | 411.2 | 411.2 | 411.2 | 500.0 |
| 2023-05-17 05:12:00 | SPY | ETF | 411.19 | 411.19 | 411.19 | 411.19 | 177.0 |
| 2023-05-17 05:13:00 | SPY | ETF | 411.15 | 411.15 | 411.14 | 411.14 | 535.0 |
| 2023-05-17 05:15:00 | SPY | ETF | 411.2 | 411.2 | 411.2 | 411.2 | 300.0 |
| 2023-05-17 05:24:00 | SPY | ETF | 411.27 | 411.27 | 411.27 | 411.27 | 100.0 |
| 2023-05-17 05:26:00 | SPY | ETF | 411.35 | 411.35 | 411.35 | 411.35 | 6940.0 |
| 2023-05-17 05:30:00 | SPY | ETF | 411.25 | 411.25 | 411.25 | 411.25 | 133.0 |
| 2023-05-17 05:31:00 | SPY | ETF | 411.24 | 411.24 | 411.24 | 411.24 | 200.0 |
| 2023-05-17 05:36:00 | SPY | ETF | 411.21 | 411.21 | 411.18 | 411.18 | 4999.0 |
| 2023-05-17 05:38:00 | SPY | ETF | 411.17 | 411.17 | 411.17 | 411.17 | 1000.0 |
| 2023-05-17 05:40:00 | SPY | ETF | 411.3 | 411.3 | 411.3 | 411.3 | 1073.0 |
| 2023-05-17 05:41:00 | SPY | ETF | 411.29 | 411.29 | 411.29 | 411.29 | 699.0 |
> showing 50 of 251,460 rows — these rows as CSV