PREVIEW / etf_5min / 2022-09-21
file: by_date/etf_5min/2022/2022-09-21.parquet size: 1.9 MB rows: 93,846
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 |
|---|---|---|---|---|---|---|---|
| 2022-09-21 04:00:00 | SPY | ETF | 383.96 | 384.02 | 383.9 | 383.9 | 2199.0 |
| 2022-09-21 04:05:00 | SPY | ETF | 383.8 | 384.1 | 383.75 | 384.09 | 4504.0 |
| 2022-09-21 04:10:00 | SPY | ETF | 384.1 | 384.2 | 384.06 | 384.11 | 2900.0 |
| 2022-09-21 04:15:00 | SPY | ETF | 384.09 | 384.49 | 384.09 | 384.49 | 5829.0 |
| 2022-09-21 04:20:00 | SPY | ETF | 384.49 | 384.63 | 384.49 | 384.61 | 1728.0 |
| 2022-09-21 04:25:00 | SPY | ETF | 384.64 | 384.65 | 384.4 | 384.4 | 1206.0 |
| 2022-09-21 04:30:00 | SPY | ETF | 384.43 | 384.46 | 384.24 | 384.42 | 1275.0 |
| 2022-09-21 04:35:00 | SPY | ETF | 384.45 | 384.51 | 384.45 | 384.51 | 905.0 |
| 2022-09-21 04:40:00 | SPY | ETF | 384.61 | 384.62 | 384.59 | 384.59 | 800.0 |
| 2022-09-21 04:45:00 | SPY | ETF | 384.52 | 384.58 | 384.52 | 384.58 | 622.0 |
| 2022-09-21 04:50:00 | SPY | ETF | 384.48 | 384.48 | 384.43 | 384.43 | 253.0 |
| 2022-09-21 04:55:00 | SPY | ETF | 384.47 | 384.47 | 384.39 | 384.39 | 3564.0 |
| 2022-09-21 05:00:00 | SPY | ETF | 384.41 | 384.41 | 384.23 | 384.29 | 708.0 |
| 2022-09-21 05:05:00 | SPY | ETF | 384.28 | 384.28 | 384.23 | 384.23 | 548.0 |
| 2022-09-21 05:10:00 | SPY | ETF | 384.24 | 384.28 | 384.21 | 384.21 | 1063.0 |
| 2022-09-21 05:15:00 | SPY | ETF | 384.17 | 384.17 | 384.06 | 384.06 | 1650.0 |
| 2022-09-21 05:20:00 | SPY | ETF | 384.1 | 384.1 | 384.04 | 384.04 | 881.0 |
| 2022-09-21 05:25:00 | SPY | ETF | 384.2 | 384.36 | 384.2 | 384.36 | 800.0 |
| 2022-09-21 05:30:00 | SPY | ETF | 384.59 | 384.74 | 384.59 | 384.74 | 642.0 |
| 2022-09-21 05:35:00 | SPY | ETF | 384.7 | 384.84 | 384.7 | 384.79 | 12200.0 |
| 2022-09-21 05:40:00 | SPY | ETF | 384.82 | 384.95 | 384.82 | 384.91 | 1000.0 |
| 2022-09-21 05:45:00 | SPY | ETF | 384.93 | 385.27 | 384.93 | 385.19 | 4173.0 |
| 2022-09-21 05:50:00 | SPY | ETF | 385.27 | 385.32 | 385.06 | 385.06 | 6286.0 |
| 2022-09-21 05:55:00 | SPY | ETF | 385.09 | 385.22 | 385.09 | 385.21 | 1627.0 |
| 2022-09-21 06:00:00 | SPY | ETF | 385.24 | 385.31 | 385.07 | 385.07 | 29569.0 |
| 2022-09-21 06:05:00 | SPY | ETF | 385.07 | 385.09 | 384.95 | 384.98 | 4359.0 |
| 2022-09-21 06:10:00 | SPY | ETF | 384.96 | 384.98 | 384.9 | 384.98 | 1225.0 |
| 2022-09-21 06:15:00 | SPY | ETF | 384.99 | 385.16 | 384.96 | 385.04 | 3075.0 |
| 2022-09-21 06:20:00 | SPY | ETF | 385.02 | 385.02 | 384.75 | 384.75 | 3660.0 |
| 2022-09-21 06:25:00 | SPY | ETF | 384.69 | 385.05 | 384.69 | 385.05 | 2406.0 |
| 2022-09-21 06:30:00 | SPY | ETF | 384.85 | 384.85 | 384.28 | 384.45 | 11448.0 |
| 2022-09-21 06:35:00 | SPY | ETF | 384.47 | 384.74 | 384.16 | 384.67 | 22542.0 |
| 2022-09-21 06:40:00 | SPY | ETF | 384.67 | 384.89 | 384.66 | 384.78 | 68374.0 |
| 2022-09-21 06:45:00 | SPY | ETF | 384.87 | 385.13 | 384.87 | 385.13 | 2977.0 |
| 2022-09-21 06:50:00 | SPY | ETF | 385.04 | 385.3 | 385.0 | 385.26 | 12628.0 |
| 2022-09-21 06:55:00 | SPY | ETF | 385.14 | 385.16 | 384.91 | 384.91 | 2070.0 |
| 2022-09-21 07:00:00 | SPY | ETF | 384.96 | 385.09 | 384.94 | 384.94 | 8123.0 |
| 2022-09-21 07:05:00 | SPY | ETF | 384.9 | 384.9 | 384.71 | 384.8 | 45448.0 |
| 2022-09-21 07:10:00 | SPY | ETF | 384.8 | 384.87 | 384.69 | 384.69 | 61485.0 |
| 2022-09-21 07:15:00 | SPY | ETF | 384.75 | 385.01 | 384.75 | 384.83 | 74995.0 |
| 2022-09-21 07:20:00 | SPY | ETF | 384.83 | 384.83 | 384.64 | 384.81 | 26792.0 |
| 2022-09-21 07:25:00 | SPY | ETF | 384.8 | 384.8 | 384.66 | 384.73 | 8388.0 |
| 2022-09-21 07:30:00 | SPY | ETF | 384.7 | 384.93 | 384.67 | 384.91 | 4300.0 |
| 2022-09-21 07:35:00 | SPY | ETF | 384.79 | 385.08 | 384.72 | 385.0 | 19860.0 |
| 2022-09-21 07:40:00 | SPY | ETF | 385.0 | 385.17 | 384.98 | 385.09 | 17523.0 |
| 2022-09-21 07:45:00 | SPY | ETF | 385.16 | 385.59 | 385.16 | 385.5 | 90774.0 |
| 2022-09-21 07:50:00 | SPY | ETF | 385.5 | 385.79 | 385.41 | 385.61 | 42396.0 |
| 2022-09-21 07:55:00 | SPY | ETF | 385.7 | 385.72 | 385.43 | 385.51 | 43304.0 |
| 2022-09-21 08:00:00 | SPY | ETF | 384.85 | 385.67 | 382.79 | 385.42 | 47056.0 |
| 2022-09-21 08:05:00 | SPY | ETF | 385.44 | 385.62 | 385.44 | 385.56 | 31039.0 |
> showing 50 of 93,846 rows — these rows as CSV