PREVIEW / etf_5min / 2023-08-11
file: by_date/etf_5min/2023/2023-08-11.parquet size: 1.9 MB rows: 93,364
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-08-11 04:00:00 | SPY | ETF | 446.25 | 446.31 | 446.17 | 446.22 | 2950.0 |
| 2023-08-11 04:05:00 | SPY | ETF | 446.2 | 446.2 | 445.9 | 445.9 | 3416.0 |
| 2023-08-11 04:10:00 | SPY | ETF | 445.87 | 445.88 | 445.8 | 445.88 | 1569.0 |
| 2023-08-11 04:15:00 | SPY | ETF | 446.02 | 446.06 | 446.02 | 446.06 | 600.0 |
| 2023-08-11 04:20:00 | SPY | ETF | 445.94 | 445.94 | 445.8 | 445.8 | 220.0 |
| 2023-08-11 04:25:00 | SPY | ETF | 445.8 | 445.93 | 445.8 | 445.85 | 1000.0 |
| 2023-08-11 04:30:00 | SPY | ETF | 445.5 | 445.5 | 445.41 | 445.41 | 3536.0 |
| 2023-08-11 04:35:00 | SPY | ETF | 445.51 | 445.54 | 445.19 | 445.2 | 2400.0 |
| 2023-08-11 04:40:00 | SPY | ETF | 445.24 | 445.42 | 445.24 | 445.42 | 1562.0 |
| 2023-08-11 04:45:00 | SPY | ETF | 445.36 | 445.39 | 445.36 | 445.39 | 400.0 |
| 2023-08-11 04:50:00 | SPY | ETF | 445.48 | 445.51 | 445.42 | 445.5 | 6000.0 |
| 2023-08-11 04:55:00 | SPY | ETF | 445.57 | 445.58 | 445.57 | 445.57 | 1300.0 |
| 2023-08-11 05:00:00 | SPY | ETF | 445.7 | 445.7 | 445.66 | 445.67 | 1450.0 |
| 2023-08-11 05:05:00 | SPY | ETF | 445.78 | 445.78 | 445.78 | 445.78 | 100.0 |
| 2023-08-11 05:10:00 | SPY | ETF | 445.86 | 445.87 | 445.86 | 445.87 | 209.0 |
| 2023-08-11 05:15:00 | SPY | ETF | 445.89 | 445.89 | 445.89 | 445.89 | 100.0 |
| 2023-08-11 05:20:00 | SPY | ETF | 445.79 | 445.79 | 445.73 | 445.73 | 200.0 |
| 2023-08-11 05:25:00 | SPY | ETF | 445.92 | 445.94 | 445.9 | 445.92 | 1300.0 |
| 2023-08-11 05:30:00 | SPY | ETF | 445.93 | 445.96 | 445.86 | 445.86 | 2006.0 |
| 2023-08-11 05:35:00 | SPY | ETF | 445.72 | 445.88 | 445.72 | 445.87 | 300.0 |
| 2023-08-11 05:40:00 | SPY | ETF | 445.98 | 446.03 | 445.92 | 445.92 | 1387.0 |
| 2023-08-11 05:45:00 | SPY | ETF | 445.87 | 445.87 | 445.87 | 445.87 | 100.0 |
| 2023-08-11 05:50:00 | SPY | ETF | 445.69 | 445.69 | 445.19 | 445.19 | 4450.0 |
| 2023-08-11 05:55:00 | SPY | ETF | 445.13 | 445.21 | 445.05 | 445.05 | 3650.0 |
| 2023-08-11 06:00:00 | SPY | ETF | 445.27 | 445.44 | 445.27 | 445.39 | 3400.0 |
| 2023-08-11 06:05:00 | SPY | ETF | 445.48 | 445.63 | 445.48 | 445.63 | 2144.0 |
| 2023-08-11 06:10:00 | SPY | ETF | 445.58 | 445.69 | 445.58 | 445.69 | 500.0 |
| 2023-08-11 06:15:00 | SPY | ETF | 445.6 | 445.71 | 445.58 | 445.62 | 3800.0 |
| 2023-08-11 06:20:00 | SPY | ETF | 445.7 | 445.73 | 445.61 | 445.7 | 4100.0 |
| 2023-08-11 06:25:00 | SPY | ETF | 445.69 | 445.76 | 445.69 | 445.7 | 500.0 |
| 2023-08-11 06:30:00 | SPY | ETF | 445.75 | 445.83 | 445.75 | 445.83 | 1000.0 |
| 2023-08-11 06:35:00 | SPY | ETF | 445.88 | 446.04 | 445.85 | 445.86 | 3400.0 |
| 2023-08-11 06:40:00 | SPY | ETF | 445.89 | 445.89 | 445.7 | 445.7 | 21799.0 |
| 2023-08-11 06:45:00 | SPY | ETF | 445.71 | 445.71 | 445.58 | 445.58 | 3200.0 |
| 2023-08-11 06:50:00 | SPY | ETF | 445.62 | 445.62 | 445.54 | 445.58 | 1400.0 |
| 2023-08-11 06:55:00 | SPY | ETF | 445.57 | 445.59 | 445.52 | 445.52 | 3411.0 |
| 2023-08-11 07:00:00 | SPY | ETF | 445.52 | 445.93 | 445.51 | 445.89 | 6112.0 |
| 2023-08-11 07:05:00 | SPY | ETF | 445.95 | 446.07 | 445.9 | 445.92 | 4200.0 |
| 2023-08-11 07:10:00 | SPY | ETF | 445.92 | 445.92 | 445.66 | 445.73 | 103680.0 |
| 2023-08-11 07:15:00 | SPY | ETF | 445.77 | 445.8 | 445.77 | 445.78 | 1600.0 |
| 2023-08-11 07:20:00 | SPY | ETF | 445.74 | 445.91 | 445.69 | 445.69 | 7935.0 |
| 2023-08-11 07:25:00 | SPY | ETF | 445.73 | 445.84 | 445.68 | 445.84 | 1996.0 |
| 2023-08-11 07:30:00 | SPY | ETF | 445.85 | 445.98 | 445.75 | 445.9 | 33692.0 |
| 2023-08-11 07:35:00 | SPY | ETF | 445.89 | 445.93 | 445.78 | 445.93 | 28500.0 |
| 2023-08-11 07:40:00 | SPY | ETF | 445.86 | 445.86 | 445.63 | 445.65 | 8498.0 |
| 2023-08-11 07:45:00 | SPY | ETF | 445.69 | 445.84 | 445.65 | 445.77 | 9600.0 |
| 2023-08-11 07:50:00 | SPY | ETF | 445.7 | 445.75 | 445.57 | 445.6 | 15262.0 |
| 2023-08-11 07:55:00 | SPY | ETF | 445.56 | 445.6 | 445.47 | 445.57 | 11014.0 |
| 2023-08-11 08:00:00 | SPY | ETF | 445.6816 | 446.27 | 445.3 | 445.77 | 60897.0 |
| 2023-08-11 08:05:00 | SPY | ETF | 445.75 | 445.76 | 445.5 | 445.55 | 3091.0 |
> showing 50 of 93,364 rows — these rows as CSV