PREVIEW / etf_5min / 2023-09-28
file: by_date/etf_5min/2023/2023-09-28.parquet size: 2.0 MB rows: 99,149
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-28 04:00:00 | SPY | ETF | 426.28 | 426.36 | 425.77 | 425.8 | 9580.0 |
| 2023-09-28 04:05:00 | SPY | ETF | 425.9 | 425.93 | 425.69 | 425.92 | 6249.0 |
| 2023-09-28 04:10:00 | SPY | ETF | 425.91 | 426.07 | 425.87 | 425.96 | 1450.0 |
| 2023-09-28 04:15:00 | SPY | ETF | 425.99 | 426.02 | 425.87 | 425.98 | 8025.0 |
| 2023-09-28 04:20:00 | SPY | ETF | 425.89 | 425.89 | 425.74 | 425.74 | 1886.0 |
| 2023-09-28 04:25:00 | SPY | ETF | 425.62 | 425.72 | 425.62 | 425.65 | 714.0 |
| 2023-09-28 04:30:00 | SPY | ETF | 425.78 | 425.78 | 425.6 | 425.6 | 475.0 |
| 2023-09-28 04:35:00 | SPY | ETF | 425.78 | 426.09 | 425.78 | 426.09 | 1600.0 |
| 2023-09-28 04:40:00 | SPY | ETF | 426.07 | 426.07 | 425.92 | 426.04 | 837.0 |
| 2023-09-28 04:45:00 | SPY | ETF | 426.0 | 426.0 | 426.0 | 426.0 | 450.0 |
| 2023-09-28 04:50:00 | SPY | ETF | 426.12 | 426.3 | 426.12 | 426.27 | 2440.0 |
| 2023-09-28 04:55:00 | SPY | ETF | 426.25 | 426.25 | 425.89 | 425.89 | 3950.0 |
| 2023-09-28 05:00:00 | SPY | ETF | 425.88 | 425.88 | 425.63 | 425.63 | 3995.0 |
| 2023-09-28 05:05:00 | SPY | ETF | 425.51 | 425.51 | 425.3 | 425.35 | 6835.0 |
| 2023-09-28 05:10:00 | SPY | ETF | 425.34 | 425.34 | 425.3 | 425.3 | 207.0 |
| 2023-09-28 05:15:00 | SPY | ETF | 425.22 | 425.26 | 425.0 | 425.0 | 7193.0 |
| 2023-09-28 05:20:00 | SPY | ETF | 424.97 | 425.36 | 424.95 | 425.34 | 8735.0 |
| 2023-09-28 05:25:00 | SPY | ETF | 425.4 | 425.46 | 425.07 | 425.32 | 11774.0 |
| 2023-09-28 05:30:00 | SPY | ETF | 425.31 | 425.36 | 425.14 | 425.15 | 700.0 |
| 2023-09-28 05:35:00 | SPY | ETF | 425.27 | 425.29 | 425.25 | 425.28 | 1425.0 |
| 2023-09-28 05:40:00 | SPY | ETF | 425.32 | 425.85 | 425.32 | 425.85 | 3214.0 |
| 2023-09-28 05:45:00 | SPY | ETF | 425.83 | 426.07 | 425.83 | 426.03 | 6860.0 |
| 2023-09-28 05:50:00 | SPY | ETF | 426.1 | 426.33 | 426.1 | 426.25 | 2310.0 |
| 2023-09-28 05:55:00 | SPY | ETF | 426.35 | 426.56 | 426.3 | 426.56 | 2883.0 |
| 2023-09-28 06:00:00 | SPY | ETF | 426.52 | 426.8 | 426.49 | 426.6 | 11046.0 |
| 2023-09-28 06:05:00 | SPY | ETF | 426.69 | 426.72 | 426.6 | 426.6 | 7500.0 |
| 2023-09-28 06:10:00 | SPY | ETF | 426.82 | 426.82 | 426.72 | 426.77 | 2690.0 |
| 2023-09-28 06:15:00 | SPY | ETF | 426.71 | 426.72 | 426.44 | 426.44 | 8515.0 |
| 2023-09-28 06:20:00 | SPY | ETF | 426.41 | 426.44 | 426.23 | 426.23 | 9050.0 |
| 2023-09-28 06:25:00 | SPY | ETF | 426.25 | 426.31 | 426.13 | 426.28 | 3460.0 |
| 2023-09-28 06:30:00 | SPY | ETF | 426.34 | 426.43 | 426.34 | 426.37 | 800.0 |
| 2023-09-28 06:35:00 | SPY | ETF | 426.48 | 426.68 | 426.47 | 426.56 | 8389.0 |
| 2023-09-28 06:40:00 | SPY | ETF | 426.61 | 426.73 | 426.57 | 426.68 | 2500.0 |
| 2023-09-28 06:45:00 | SPY | ETF | 426.5 | 426.59 | 426.44 | 426.44 | 2177.0 |
| 2023-09-28 06:50:00 | SPY | ETF | 426.44 | 426.45 | 426.21 | 426.25 | 4095.0 |
| 2023-09-28 06:55:00 | SPY | ETF | 426.26 | 426.52 | 426.19 | 426.5 | 40604.0 |
| 2023-09-28 07:00:00 | SPY | ETF | 426.5 | 426.5 | 426.31 | 426.32 | 12285.0 |
| 2023-09-28 07:05:00 | SPY | ETF | 426.32 | 426.32 | 426.03 | 426.13 | 9111.0 |
| 2023-09-28 07:10:00 | SPY | ETF | 426.21 | 426.21 | 426.0 | 426.08 | 104483.0 |
| 2023-09-28 07:15:00 | SPY | ETF | 426.05 | 426.07 | 425.9 | 425.97 | 21240.0 |
| 2023-09-28 07:20:00 | SPY | ETF | 425.94 | 426.33 | 425.94 | 426.23 | 6315.0 |
| 2023-09-28 07:25:00 | SPY | ETF | 426.21 | 426.3 | 425.89 | 425.95 | 28662.0 |
| 2023-09-28 07:30:00 | SPY | ETF | 425.92 | 425.92 | 425.56 | 425.56 | 17289.0 |
| 2023-09-28 07:35:00 | SPY | ETF | 425.54 | 425.71 | 425.39 | 425.4 | 133949.0 |
| 2023-09-28 07:40:00 | SPY | ETF | 425.44 | 425.53 | 425.34 | 425.35 | 16658.0 |
| 2023-09-28 07:45:00 | SPY | ETF | 425.31 | 425.49 | 425.3 | 425.4 | 25267.0 |
| 2023-09-28 07:50:00 | SPY | ETF | 425.45 | 425.64 | 425.45 | 425.48 | 36031.0 |
| 2023-09-28 07:55:00 | SPY | ETF | 425.57 | 425.9 | 425.57 | 425.87 | 19167.0 |
| 2023-09-28 08:00:00 | SPY | ETF | 425.87 | 427.03 | 425.1496 | 426.36 | 112399.0 |
| 2023-09-28 08:05:00 | SPY | ETF | 426.37 | 426.65 | 426.3 | 426.48 | 35969.0 |
> showing 50 of 99,149 rows — these rows as CSV