PREVIEW / etf_5min / 2022-01-28
file: by_date/etf_5min/2022/2022-01-28.parquet size: 2.0 MB rows: 99,168
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-01-28 04:00:00 | SPY | ETF | 432.21 | 432.38 | 431.75 | 431.75 | 6913.0 |
| 2022-01-28 04:05:00 | SPY | ETF | 431.46 | 431.5 | 431.19 | 431.19 | 2640.0 |
| 2022-01-28 04:10:00 | SPY | ETF | 432.0 | 432.55 | 432.0 | 432.55 | 2310.0 |
| 2022-01-28 04:15:00 | SPY | ETF | 432.69 | 432.69 | 432.56 | 432.56 | 400.0 |
| 2022-01-28 04:25:00 | SPY | ETF | 432.31 | 432.39 | 432.31 | 432.34 | 400.0 |
| 2022-01-28 04:30:00 | SPY | ETF | 431.84 | 432.44 | 431.76 | 432.12 | 1078.0 |
| 2022-01-28 04:35:00 | SPY | ETF | 432.01 | 432.01 | 432.01 | 432.01 | 300.0 |
| 2022-01-28 04:40:00 | SPY | ETF | 431.64 | 432.1 | 431.64 | 432.1 | 300.0 |
| 2022-01-28 04:45:00 | SPY | ETF | 432.4 | 432.4 | 432.0 | 432.0 | 559.0 |
| 2022-01-28 04:50:00 | SPY | ETF | 431.52 | 431.65 | 431.5 | 431.5 | 600.0 |
| 2022-01-28 04:55:00 | SPY | ETF | 431.86 | 431.86 | 431.35 | 431.35 | 2082.0 |
| 2022-01-28 05:00:00 | SPY | ETF | 431.42 | 431.42 | 431.01 | 431.05 | 6903.0 |
| 2022-01-28 05:05:00 | SPY | ETF | 431.22 | 431.22 | 430.63 | 430.69 | 7219.0 |
| 2022-01-28 05:10:00 | SPY | ETF | 430.96 | 431.0 | 430.96 | 431.0 | 989.0 |
| 2022-01-28 05:15:00 | SPY | ETF | 430.7 | 430.7 | 430.39 | 430.49 | 1200.0 |
| 2022-01-28 05:20:00 | SPY | ETF | 430.4 | 430.9 | 430.21 | 430.9 | 5018.0 |
| 2022-01-28 05:25:00 | SPY | ETF | 431.23 | 431.23 | 430.75 | 430.75 | 1990.0 |
| 2022-01-28 05:30:00 | SPY | ETF | 430.71 | 430.73 | 430.45 | 430.45 | 1821.0 |
| 2022-01-28 05:35:00 | SPY | ETF | 430.34 | 430.4 | 430.0 | 430.0 | 2972.0 |
| 2022-01-28 05:40:00 | SPY | ETF | 430.02 | 430.55 | 430.01 | 430.55 | 3401.0 |
| 2022-01-28 05:45:00 | SPY | ETF | 430.7 | 430.7 | 430.58 | 430.69 | 1177.0 |
| 2022-01-28 05:50:00 | SPY | ETF | 430.61 | 430.61 | 430.12 | 430.23 | 13717.0 |
| 2022-01-28 05:55:00 | SPY | ETF | 430.1 | 430.48 | 429.91 | 430.48 | 7620.0 |
| 2022-01-28 06:00:00 | SPY | ETF | 430.62 | 430.63 | 430.26 | 430.31 | 1623.0 |
| 2022-01-28 06:05:00 | SPY | ETF | 430.16 | 430.29 | 430.01 | 430.01 | 1230.0 |
| 2022-01-28 06:10:00 | SPY | ETF | 429.99 | 430.19 | 429.84 | 429.99 | 11581.0 |
| 2022-01-28 06:15:00 | SPY | ETF | 429.59 | 429.72 | 428.68 | 428.86 | 40905.0 |
| 2022-01-28 06:20:00 | SPY | ETF | 429.07 | 429.67 | 428.78 | 429.67 | 11977.0 |
| 2022-01-28 06:25:00 | SPY | ETF | 429.67 | 430.04 | 429.39 | 429.98 | 30808.0 |
| 2022-01-28 06:30:00 | SPY | ETF | 429.96 | 430.15 | 429.76 | 429.76 | 2147.0 |
| 2022-01-28 06:35:00 | SPY | ETF | 430.15 | 430.28 | 429.82 | 429.82 | 2885.0 |
| 2022-01-28 06:40:00 | SPY | ETF | 429.6 | 429.63 | 429.31 | 429.31 | 3947.0 |
| 2022-01-28 06:45:00 | SPY | ETF | 429.19 | 429.8 | 428.96 | 429.64 | 5125.0 |
| 2022-01-28 06:50:00 | SPY | ETF | 429.39 | 429.39 | 429.03 | 429.07 | 13911.0 |
| 2022-01-28 06:55:00 | SPY | ETF | 429.31 | 429.83 | 429.03 | 429.58 | 4942.0 |
| 2022-01-28 07:00:00 | SPY | ETF | 429.88 | 430.16 | 429.36 | 430.16 | 30797.0 |
| 2022-01-28 07:05:00 | SPY | ETF | 430.06 | 430.13 | 429.54 | 429.54 | 44054.0 |
| 2022-01-28 07:10:00 | SPY | ETF | 429.5 | 429.97 | 429.31 | 429.77 | 6576.0 |
| 2022-01-28 07:15:00 | SPY | ETF | 429.61 | 429.88 | 429.15 | 429.15 | 18915.0 |
| 2022-01-28 07:20:00 | SPY | ETF | 429.32 | 429.39 | 427.76 | 427.81 | 45849.0 |
| 2022-01-28 07:25:00 | SPY | ETF | 427.87 | 428.25 | 427.39 | 428.1 | 62674.0 |
| 2022-01-28 07:30:00 | SPY | ETF | 427.92 | 428.43 | 427.89 | 427.99 | 31407.0 |
| 2022-01-28 07:35:00 | SPY | ETF | 428.2 | 428.21 | 427.11 | 427.13 | 31342.0 |
| 2022-01-28 07:40:00 | SPY | ETF | 427.09 | 427.39 | 426.7 | 426.77 | 55039.0 |
| 2022-01-28 07:45:00 | SPY | ETF | 426.88 | 426.88 | 426.2 | 426.5 | 52805.0 |
| 2022-01-28 07:50:00 | SPY | ETF | 426.45 | 427.13 | 426.32 | 427.01 | 48038.0 |
| 2022-01-28 07:55:00 | SPY | ETF | 426.97 | 427.38 | 426.56 | 427.33 | 51202.0 |
| 2022-01-28 08:00:00 | SPY | ETF | 429.6799 | 434.1 | 426.27 | 427.76 | 119529.0 |
| 2022-01-28 08:05:00 | SPY | ETF | 427.77 | 427.83 | 426.92 | 427.18 | 67247.0 |
| 2022-01-28 08:10:00 | SPY | ETF | 427.12 | 427.81 | 427.04 | 427.77 | 96391.0 |
> showing 50 of 99,168 rows — these rows as CSV