PREVIEW / etf_5min / 2022-12-16
file: by_date/etf_5min/2022/2022-12-16.parquet size: 2.1 MB rows: 100,568
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-12-16 04:00:00 | SPY | ETF | 383.94 | 387.85 | 383.9 | 384.13 | 33134.0 |
| 2022-12-16 04:05:00 | SPY | ETF | 383.95 | 384.11 | 383.85 | 383.89 | 9239.0 |
| 2022-12-16 04:10:00 | SPY | ETF | 383.92 | 383.93 | 383.49 | 383.55 | 21626.0 |
| 2022-12-16 04:15:00 | SPY | ETF | 383.55 | 383.66 | 383.4 | 383.66 | 10716.0 |
| 2022-12-16 04:20:00 | SPY | ETF | 383.77 | 383.85 | 383.43 | 383.46 | 9763.0 |
| 2022-12-16 04:25:00 | SPY | ETF | 383.43 | 383.69 | 383.2 | 383.69 | 11334.0 |
| 2022-12-16 04:30:00 | SPY | ETF | 383.68 | 384.06 | 383.65 | 383.93 | 3679.0 |
| 2022-12-16 04:35:00 | SPY | ETF | 383.7 | 383.88 | 383.59 | 383.59 | 5127.0 |
| 2022-12-16 04:40:00 | SPY | ETF | 383.58 | 383.75 | 383.3 | 383.31 | 7239.0 |
| 2022-12-16 04:45:00 | SPY | ETF | 383.56 | 383.84 | 383.56 | 383.78 | 2403.0 |
| 2022-12-16 04:50:00 | SPY | ETF | 383.7 | 383.9 | 383.7 | 383.9 | 1225.0 |
| 2022-12-16 04:55:00 | SPY | ETF | 383.85 | 383.99 | 383.7 | 383.99 | 4519.0 |
| 2022-12-16 05:00:00 | SPY | ETF | 383.76 | 383.91 | 383.64 | 383.91 | 18409.0 |
| 2022-12-16 05:05:00 | SPY | ETF | 383.73 | 384.05 | 383.73 | 384.0 | 2999.0 |
| 2022-12-16 05:10:00 | SPY | ETF | 383.82 | 384.05 | 383.5 | 383.51 | 8925.0 |
| 2022-12-16 05:15:00 | SPY | ETF | 383.43 | 383.5 | 383.06 | 383.06 | 34462.0 |
| 2022-12-16 05:20:00 | SPY | ETF | 383.14 | 383.15 | 382.76 | 382.86 | 43293.0 |
| 2022-12-16 05:25:00 | SPY | ETF | 382.7 | 382.91 | 382.7 | 382.91 | 7850.0 |
| 2022-12-16 05:30:00 | SPY | ETF | 382.85 | 382.95 | 382.68 | 382.95 | 2555.0 |
| 2022-12-16 05:35:00 | SPY | ETF | 382.91 | 383.31 | 382.91 | 383.31 | 11778.0 |
| 2022-12-16 05:40:00 | SPY | ETF | 383.28 | 383.28 | 383.08 | 383.08 | 4450.0 |
| 2022-12-16 05:45:00 | SPY | ETF | 382.9 | 382.9 | 382.5 | 382.72 | 8985.0 |
| 2022-12-16 05:50:00 | SPY | ETF | 382.61 | 382.72 | 382.56 | 382.6 | 9728.0 |
| 2022-12-16 05:55:00 | SPY | ETF | 382.58 | 383.02 | 382.5 | 382.98 | 8850.0 |
| 2022-12-16 06:00:00 | SPY | ETF | 382.76 | 383.06 | 382.64 | 383.06 | 2000.0 |
| 2022-12-16 06:05:00 | SPY | ETF | 382.93 | 383.34 | 382.93 | 383.24 | 9221.0 |
| 2022-12-16 06:10:00 | SPY | ETF | 383.32 | 383.65 | 383.32 | 383.65 | 7561.0 |
| 2022-12-16 06:15:00 | SPY | ETF | 383.65 | 383.84 | 383.63 | 383.84 | 11526.0 |
| 2022-12-16 06:20:00 | SPY | ETF | 383.9 | 383.93 | 383.61 | 383.63 | 30599.0 |
| 2022-12-16 06:25:00 | SPY | ETF | 383.64 | 383.99 | 383.64 | 383.89 | 2300.0 |
| 2022-12-16 06:30:00 | SPY | ETF | 383.77 | 384.04 | 383.75 | 383.87 | 7995.0 |
| 2022-12-16 06:35:00 | SPY | ETF | 383.83 | 384.1 | 383.69 | 384.1 | 7334.0 |
| 2022-12-16 06:40:00 | SPY | ETF | 384.01 | 384.01 | 383.81 | 383.81 | 3416.0 |
| 2022-12-16 06:45:00 | SPY | ETF | 383.7 | 383.73 | 383.55 | 383.55 | 1599.0 |
| 2022-12-16 06:50:00 | SPY | ETF | 383.51 | 383.7 | 383.43 | 383.67 | 10780.0 |
| 2022-12-16 06:55:00 | SPY | ETF | 383.58 | 383.73 | 383.53 | 383.68 | 19100.0 |
| 2022-12-16 07:00:00 | SPY | ETF | 383.7 | 384.46 | 383.65 | 384.42 | 41719.0 |
| 2022-12-16 07:05:00 | SPY | ETF | 384.4 | 384.6 | 384.18 | 384.28 | 25005.0 |
| 2022-12-16 07:10:00 | SPY | ETF | 384.3 | 384.43 | 384.12 | 384.15 | 40708.0 |
| 2022-12-16 07:15:00 | SPY | ETF | 384.09 | 384.4 | 384.08 | 384.31 | 28981.0 |
| 2022-12-16 07:20:00 | SPY | ETF | 384.3 | 384.45 | 383.97 | 383.97 | 14681.0 |
| 2022-12-16 07:25:00 | SPY | ETF | 383.9 | 383.93 | 383.58 | 383.75 | 18270.0 |
| 2022-12-16 07:30:00 | SPY | ETF | 383.72 | 383.8 | 383.42 | 383.77 | 32025.0 |
| 2022-12-16 07:35:00 | SPY | ETF | 383.78 | 384.06 | 383.73 | 383.89 | 75954.0 |
| 2022-12-16 07:40:00 | SPY | ETF | 383.9 | 384.19 | 383.76 | 384.19 | 24988.0 |
| 2022-12-16 07:45:00 | SPY | ETF | 384.2 | 384.8 | 384.2 | 384.31 | 54498.0 |
| 2022-12-16 07:50:00 | SPY | ETF | 384.37 | 384.49 | 384.27 | 384.33 | 27030.0 |
| 2022-12-16 07:55:00 | SPY | ETF | 384.35 | 385.05 | 384.33 | 385.05 | 48482.0 |
| 2022-12-16 08:00:00 | SPY | ETF | 384.2387 | 387.9 | 382.84 | 384.6604 | 152150.0 |
| 2022-12-16 08:05:00 | SPY | ETF | 384.69 | 384.91 | 384.59 | 384.71 | 36932.0 |
> showing 50 of 100,568 rows — these rows as CSV