PREVIEW / etf_5min / 2023-09-25
file: by_date/etf_5min/2023/2023-09-25.parquet size: 2.0 MB rows: 97,115
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-09-25 04:00:00 | SPY | ETF | 431.88 | 432.02 | 431.83 | 431.91 | 3163.0 |
| 2023-09-25 04:05:00 | SPY | ETF | 431.84 | 431.9 | 431.74 | 431.74 | 1854.0 |
| 2023-09-25 04:10:00 | SPY | ETF | 431.75 | 431.77 | 431.54 | 431.555 | 1631.0 |
| 2023-09-25 04:15:00 | SPY | ETF | 431.51 | 431.51 | 431.31 | 431.31 | 400.0 |
| 2023-09-25 04:20:00 | SPY | ETF | 431.21 | 431.21 | 431.07 | 431.07 | 1400.0 |
| 2023-09-25 04:25:00 | SPY | ETF | 431.0 | 431.0 | 430.62 | 430.62 | 3974.0 |
| 2023-09-25 04:30:00 | SPY | ETF | 430.59 | 430.59 | 430.29 | 430.38 | 6773.0 |
| 2023-09-25 04:35:00 | SPY | ETF | 430.36 | 430.36 | 429.78 | 429.78 | 32664.0 |
| 2023-09-25 04:40:00 | SPY | ETF | 429.71 | 429.72 | 429.16 | 429.17 | 16196.0 |
| 2023-09-25 04:45:00 | SPY | ETF | 429.14 | 429.54 | 429.13 | 429.54 | 12567.0 |
| 2023-09-25 04:50:00 | SPY | ETF | 429.66 | 429.68 | 429.45 | 429.45 | 2091.0 |
| 2023-09-25 04:55:00 | SPY | ETF | 429.6 | 429.72 | 429.5 | 429.71 | 32623.0 |
| 2023-09-25 05:00:00 | SPY | ETF | 429.7 | 429.81 | 429.6 | 429.7 | 4600.0 |
| 2023-09-25 05:05:00 | SPY | ETF | 429.62 | 430.03 | 429.62 | 430.03 | 2108.0 |
| 2023-09-25 05:10:00 | SPY | ETF | 430.01 | 430.01 | 429.83 | 429.84 | 1064.0 |
| 2023-09-25 05:15:00 | SPY | ETF | 429.99 | 429.99 | 429.84 | 429.9 | 1650.0 |
| 2023-09-25 05:20:00 | SPY | ETF | 430.12 | 430.13 | 430.01 | 430.13 | 902.0 |
| 2023-09-25 05:25:00 | SPY | ETF | 430.22 | 430.29 | 430.22 | 430.28 | 5700.0 |
| 2023-09-25 05:30:00 | SPY | ETF | 430.26 | 430.26 | 430.08 | 430.09 | 700.0 |
| 2023-09-25 05:35:00 | SPY | ETF | 430.2 | 430.2 | 430.03 | 430.03 | 1250.0 |
| 2023-09-25 05:40:00 | SPY | ETF | 430.02 | 430.04 | 429.72 | 429.87 | 9405.0 |
| 2023-09-25 05:45:00 | SPY | ETF | 429.8 | 429.98 | 429.8 | 429.96 | 12264.0 |
| 2023-09-25 05:50:00 | SPY | ETF | 430.05 | 430.05 | 429.9 | 429.9 | 2900.0 |
| 2023-09-25 05:55:00 | SPY | ETF | 430.23 | 430.29 | 430.23 | 430.25 | 5517.0 |
| 2023-09-25 06:00:00 | SPY | ETF | 430.31 | 430.31 | 430.1 | 430.18 | 900.0 |
| 2023-09-25 06:05:00 | SPY | ETF | 430.32 | 430.32 | 430.19 | 430.2 | 7041.0 |
| 2023-09-25 06:10:00 | SPY | ETF | 430.28 | 430.28 | 430.2 | 430.24 | 2375.0 |
| 2023-09-25 06:15:00 | SPY | ETF | 430.3 | 430.51 | 430.3 | 430.38 | 7552.0 |
| 2023-09-25 06:20:00 | SPY | ETF | 430.45 | 430.56 | 430.45 | 430.55 | 1100.0 |
| 2023-09-25 06:25:00 | SPY | ETF | 430.43 | 430.43 | 430.41 | 430.43 | 2603.0 |
| 2023-09-25 06:30:00 | SPY | ETF | 430.52 | 430.52 | 430.19 | 430.19 | 5770.0 |
| 2023-09-25 06:35:00 | SPY | ETF | 430.19 | 430.23 | 430.0 | 430.06 | 8917.0 |
| 2023-09-25 06:40:00 | SPY | ETF | 429.91 | 429.98 | 429.82 | 429.98 | 14400.0 |
| 2023-09-25 06:45:00 | SPY | ETF | 430.02 | 430.32 | 430.02 | 430.3 | 9104.0 |
| 2023-09-25 06:50:00 | SPY | ETF | 430.21 | 430.29 | 430.21 | 430.21 | 6712.0 |
| 2023-09-25 06:55:00 | SPY | ETF | 430.09 | 430.23 | 430.09 | 430.23 | 800.0 |
| 2023-09-25 07:00:00 | SPY | ETF | 430.2 | 430.4 | 430.19 | 430.4 | 14588.0 |
| 2023-09-25 07:05:00 | SPY | ETF | 430.36 | 430.45 | 430.33 | 430.4 | 16015.0 |
| 2023-09-25 07:10:00 | SPY | ETF | 430.39 | 430.4 | 429.99 | 430.15 | 102651.0 |
| 2023-09-25 07:15:00 | SPY | ETF | 430.15 | 430.29 | 429.91 | 429.95 | 24511.0 |
| 2023-09-25 07:20:00 | SPY | ETF | 429.97 | 430.08 | 429.9 | 430.07 | 8573.0 |
| 2023-09-25 07:25:00 | SPY | ETF | 430.05 | 430.19 | 430.0 | 430.0 | 55198.0 |
| 2023-09-25 07:30:00 | SPY | ETF | 430.0 | 430.0 | 429.49 | 429.5 | 54389.0 |
| 2023-09-25 07:35:00 | SPY | ETF | 429.45 | 429.75 | 429.4 | 429.69 | 12333.0 |
| 2023-09-25 07:40:00 | SPY | ETF | 429.72 | 429.72 | 429.47 | 429.49 | 12633.0 |
| 2023-09-25 07:45:00 | SPY | ETF | 429.5 | 429.51 | 429.14 | 429.17 | 20511.0 |
| 2023-09-25 07:50:00 | SPY | ETF | 429.11 | 429.36 | 429.11 | 429.34 | 16450.0 |
| 2023-09-25 07:55:00 | SPY | ETF | 429.32 | 429.32 | 429.14 | 429.27 | 58196.0 |
| 2023-09-25 08:00:00 | SPY | ETF | 429.26 | 432.06 | 429.15 | 429.37 | 87371.0 |
| 2023-09-25 08:05:00 | SPY | ETF | 429.39 | 429.47 | 429.29 | 429.465 | 36136.0 |
> showing 50 of 97,115 rows — these rows as CSV