PREVIEW / etf_5min / 2022-03-30
file: by_date/etf_5min/2022/2022-03-30.parquet size: 2.0 MB rows: 94,721
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-03-30 04:00:00 | SPY | ETF | 460.36 | 460.42 | 459.74 | 459.99 | 5825.0 |
| 2022-03-30 04:05:00 | SPY | ETF | 459.91 | 459.98 | 459.74 | 459.98 | 5679.0 |
| 2022-03-30 04:10:00 | SPY | ETF | 459.95 | 459.98 | 459.59 | 459.59 | 3381.0 |
| 2022-03-30 04:15:00 | SPY | ETF | 459.51 | 459.78 | 459.51 | 459.7 | 4500.0 |
| 2022-03-30 04:20:00 | SPY | ETF | 459.72 | 459.79 | 459.7 | 459.7 | 3041.0 |
| 2022-03-30 04:25:00 | SPY | ETF | 459.68 | 459.93 | 459.64 | 459.93 | 3606.0 |
| 2022-03-30 04:30:00 | SPY | ETF | 459.89 | 459.99 | 459.89 | 459.94 | 3911.0 |
| 2022-03-30 04:35:00 | SPY | ETF | 459.94 | 459.98 | 459.93 | 459.93 | 1753.0 |
| 2022-03-30 04:40:00 | SPY | ETF | 459.74 | 459.74 | 459.63 | 459.65 | 799.0 |
| 2022-03-30 04:45:00 | SPY | ETF | 459.66 | 459.66 | 459.52 | 459.52 | 1300.0 |
| 2022-03-30 04:50:00 | SPY | ETF | 459.5 | 459.68 | 459.45 | 459.64 | 1046.0 |
| 2022-03-30 04:55:00 | SPY | ETF | 459.62 | 459.62 | 459.62 | 459.62 | 100.0 |
| 2022-03-30 05:00:00 | SPY | ETF | 459.84 | 459.95 | 459.79 | 459.95 | 3600.0 |
| 2022-03-30 05:05:00 | SPY | ETF | 459.99 | 460.03 | 459.92 | 459.98 | 2522.0 |
| 2022-03-30 05:10:00 | SPY | ETF | 460.0 | 460.01 | 459.92 | 460.01 | 678.0 |
| 2022-03-30 05:15:00 | SPY | ETF | 460.05 | 460.14 | 460.0 | 460.12 | 3530.0 |
| 2022-03-30 05:20:00 | SPY | ETF | 460.19 | 460.3 | 460.19 | 460.29 | 711.0 |
| 2022-03-30 05:25:00 | SPY | ETF | 460.26 | 460.26 | 460.21 | 460.21 | 2400.0 |
| 2022-03-30 05:30:00 | SPY | ETF | 460.19 | 460.25 | 460.13 | 460.17 | 1849.0 |
| 2022-03-30 05:35:00 | SPY | ETF | 460.19 | 460.19 | 460.05 | 460.05 | 480.0 |
| 2022-03-30 05:40:00 | SPY | ETF | 460.16 | 460.23 | 460.16 | 460.19 | 1299.0 |
| 2022-03-30 05:45:00 | SPY | ETF | 460.2 | 460.32 | 460.2 | 460.28 | 1073.0 |
| 2022-03-30 05:50:00 | SPY | ETF | 460.27 | 460.57 | 460.17 | 460.17 | 5742.0 |
| 2022-03-30 05:55:00 | SPY | ETF | 460.1 | 460.1 | 460.1 | 460.1 | 100.0 |
| 2022-03-30 06:00:00 | SPY | ETF | 460.25 | 460.26 | 459.59 | 460.04 | 6856.0 |
| 2022-03-30 06:05:00 | SPY | ETF | 460.2 | 460.21 | 459.76 | 459.76 | 5600.0 |
| 2022-03-30 06:10:00 | SPY | ETF | 459.67 | 459.8 | 459.66 | 459.69 | 3045.0 |
| 2022-03-30 06:15:00 | SPY | ETF | 459.82 | 459.82 | 459.48 | 459.64 | 5468.0 |
| 2022-03-30 06:20:00 | SPY | ETF | 459.78 | 459.87 | 459.74 | 459.87 | 1400.0 |
| 2022-03-30 06:25:00 | SPY | ETF | 459.85 | 459.97 | 459.81 | 459.81 | 4326.0 |
| 2022-03-30 06:35:00 | SPY | ETF | 460.0 | 460.0 | 460.0 | 460.0 | 183.0 |
| 2022-03-30 06:40:00 | SPY | ETF | 459.95 | 460.08 | 459.95 | 460.04 | 9549.0 |
| 2022-03-30 06:45:00 | SPY | ETF | 460.17 | 460.26 | 460.17 | 460.26 | 3787.0 |
| 2022-03-30 06:50:00 | SPY | ETF | 460.25 | 460.37 | 460.25 | 460.32 | 5409.0 |
| 2022-03-30 06:55:00 | SPY | ETF | 460.36 | 460.36 | 460.2 | 460.22 | 4160.0 |
| 2022-03-30 07:00:00 | SPY | ETF | 460.29 | 460.64 | 460.2 | 460.5 | 21815.0 |
| 2022-03-30 07:05:00 | SPY | ETF | 460.47 | 460.47 | 460.22 | 460.24 | 9597.0 |
| 2022-03-30 07:10:00 | SPY | ETF | 460.26 | 460.35 | 460.224 | 460.26 | 7673.0 |
| 2022-03-30 07:15:00 | SPY | ETF | 460.22 | 460.36 | 460.21 | 460.3 | 15235.0 |
| 2022-03-30 07:20:00 | SPY | ETF | 460.23 | 460.51 | 460.21 | 460.4 | 6938.0 |
| 2022-03-30 07:25:00 | SPY | ETF | 460.42 | 460.5 | 460.4 | 460.41 | 4240.0 |
| 2022-03-30 07:30:00 | SPY | ETF | 460.4 | 460.62 | 460.38 | 460.62 | 3827.0 |
| 2022-03-30 07:35:00 | SPY | ETF | 460.63 | 460.66 | 460.56 | 460.57 | 7822.0 |
| 2022-03-30 07:40:00 | SPY | ETF | 460.54 | 460.54 | 460.45 | 460.45 | 1815.0 |
| 2022-03-30 07:45:00 | SPY | ETF | 460.43 | 460.44 | 460.4 | 460.41 | 3400.0 |
| 2022-03-30 07:50:00 | SPY | ETF | 460.42 | 460.58 | 460.42 | 460.58 | 5852.0 |
| 2022-03-30 07:55:00 | SPY | ETF | 460.57 | 460.57 | 460.41 | 460.43 | 2100.0 |
| 2022-03-30 08:00:00 | SPY | ETF | 460.44 | 461.896 | 460.16 | 460.29 | 41728.0 |
| 2022-03-30 08:05:00 | SPY | ETF | 460.22 | 460.22 | 460.06 | 460.16 | 8319.0 |
| 2022-03-30 08:10:00 | SPY | ETF | 460.11 | 460.35 | 459.37 | 459.43 | 145103.0 |
> showing 50 of 94,721 rows — these rows as CSV