PREVIEW / etf_5min / 2022-06-07
file: by_date/etf_5min/2022/2022-06-07.parquet size: 1.9 MB rows: 90,966
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-06-07 04:00:00 | SPY | ETF | 410.5 | 410.5 | 410.35 | 410.41 | 6195.0 |
| 2022-06-07 04:05:00 | SPY | ETF | 410.47 | 410.68 | 410.47 | 410.54 | 10172.0 |
| 2022-06-07 04:10:00 | SPY | ETF | 410.5 | 410.58 | 410.41 | 410.47 | 1500.0 |
| 2022-06-07 04:15:00 | SPY | ETF | 410.35 | 410.35 | 410.16 | 410.16 | 2800.0 |
| 2022-06-07 04:20:00 | SPY | ETF | 410.34 | 410.38 | 410.25 | 410.36 | 5000.0 |
| 2022-06-07 04:25:00 | SPY | ETF | 410.49 | 410.5 | 410.4 | 410.4 | 3494.0 |
| 2022-06-07 04:30:00 | SPY | ETF | 410.4 | 410.47 | 410.4 | 410.47 | 1300.0 |
| 2022-06-07 04:35:00 | SPY | ETF | 410.6 | 410.85 | 410.6 | 410.85 | 4400.0 |
| 2022-06-07 04:40:00 | SPY | ETF | 410.7 | 410.78 | 410.7 | 410.72 | 5700.0 |
| 2022-06-07 04:45:00 | SPY | ETF | 410.66 | 410.66 | 410.63 | 410.63 | 300.0 |
| 2022-06-07 04:50:00 | SPY | ETF | 410.46 | 410.46 | 410.46 | 410.46 | 120.0 |
| 2022-06-07 04:55:00 | SPY | ETF | 410.55 | 410.56 | 410.54 | 410.54 | 527.0 |
| 2022-06-07 05:00:00 | SPY | ETF | 410.35 | 410.35 | 410.32 | 410.32 | 400.0 |
| 2022-06-07 05:05:00 | SPY | ETF | 410.28 | 410.33 | 410.07 | 410.1 | 7601.0 |
| 2022-06-07 05:10:00 | SPY | ETF | 410.14 | 410.14 | 409.99 | 409.99 | 3756.0 |
| 2022-06-07 05:15:00 | SPY | ETF | 409.94 | 410.2 | 409.89 | 410.2 | 3312.0 |
| 2022-06-07 05:20:00 | SPY | ETF | 410.24 | 410.39 | 410.24 | 410.39 | 550.0 |
| 2022-06-07 05:25:00 | SPY | ETF | 410.49 | 410.52 | 410.48 | 410.5 | 2000.0 |
| 2022-06-07 05:30:00 | SPY | ETF | 410.56 | 410.61 | 410.5 | 410.58 | 600.0 |
| 2022-06-07 05:35:00 | SPY | ETF | 410.57 | 410.57 | 410.5 | 410.5 | 900.0 |
| 2022-06-07 05:40:00 | SPY | ETF | 410.26 | 410.26 | 410.07 | 410.07 | 1524.0 |
| 2022-06-07 05:45:00 | SPY | ETF | 410.05 | 410.1 | 409.99 | 409.99 | 3798.0 |
| 2022-06-07 05:50:00 | SPY | ETF | 409.93 | 409.95 | 409.86 | 409.87 | 1220.0 |
| 2022-06-07 05:55:00 | SPY | ETF | 409.95 | 410.02 | 409.88 | 409.88 | 1324.0 |
| 2022-06-07 06:00:00 | SPY | ETF | 409.98 | 410.03 | 409.98 | 410.01 | 700.0 |
| 2022-06-07 06:05:00 | SPY | ETF | 410.05 | 410.07 | 410.05 | 410.05 | 4000.0 |
| 2022-06-07 06:15:00 | SPY | ETF | 409.89 | 409.89 | 409.38 | 409.4 | 5743.0 |
| 2022-06-07 06:20:00 | SPY | ETF | 409.25 | 409.3 | 409.09 | 409.18 | 8419.0 |
| 2022-06-07 06:25:00 | SPY | ETF | 409.31 | 409.5 | 409.27 | 409.46 | 2600.0 |
| 2022-06-07 06:30:00 | SPY | ETF | 409.49 | 409.77 | 409.49 | 409.75 | 6500.0 |
| 2022-06-07 06:35:00 | SPY | ETF | 409.69 | 410.01 | 409.69 | 409.92 | 3150.0 |
| 2022-06-07 06:40:00 | SPY | ETF | 409.93 | 409.93 | 409.68 | 409.68 | 3523.0 |
| 2022-06-07 06:45:00 | SPY | ETF | 409.87 | 409.99 | 409.8 | 409.99 | 1500.0 |
| 2022-06-07 06:50:00 | SPY | ETF | 410.02 | 410.09 | 410.02 | 410.05 | 1800.0 |
| 2022-06-07 06:55:00 | SPY | ETF | 410.01 | 410.06 | 408.67 | 408.8 | 22375.0 |
| 2022-06-07 07:00:00 | SPY | ETF | 408.87 | 409.43 | 408.77 | 409.42 | 42191.0 |
| 2022-06-07 07:05:00 | SPY | ETF | 409.33 | 409.36 | 408.55 | 408.58 | 33826.0 |
| 2022-06-07 07:10:00 | SPY | ETF | 408.53 | 408.53 | 407.66 | 407.83 | 94272.0 |
| 2022-06-07 07:15:00 | SPY | ETF | 407.82 | 408.47 | 407.71 | 408.36 | 57364.0 |
| 2022-06-07 07:20:00 | SPY | ETF | 408.42 | 408.45 | 408.22 | 408.42 | 41970.0 |
| 2022-06-07 07:25:00 | SPY | ETF | 408.4 | 408.77 | 408.28 | 408.7 | 32100.0 |
| 2022-06-07 07:30:00 | SPY | ETF | 408.62 | 408.91 | 408.57 | 408.8 | 23185.0 |
| 2022-06-07 07:35:00 | SPY | ETF | 408.77 | 408.83 | 408.72 | 408.82 | 23074.0 |
| 2022-06-07 07:40:00 | SPY | ETF | 408.76 | 408.78 | 408.5 | 408.5 | 37175.0 |
| 2022-06-07 07:45:00 | SPY | ETF | 408.55 | 408.77 | 408.49 | 408.77 | 35451.0 |
| 2022-06-07 07:50:00 | SPY | ETF | 408.71 | 408.75 | 408.45 | 408.45 | 35371.0 |
| 2022-06-07 07:55:00 | SPY | ETF | 408.45 | 408.65 | 408.4 | 408.65 | 54371.0 |
| 2022-06-07 08:00:00 | SPY | ETF | 409.38 | 410.08 | 407.76 | 408.4 | 46200.0 |
| 2022-06-07 08:05:00 | SPY | ETF | 408.37 | 408.53 | 408.29 | 408.33 | 37386.0 |
| 2022-06-07 08:10:00 | SPY | ETF | 408.4 | 408.44 | 407.99 | 408.37 | 23458.0 |
> showing 50 of 90,966 rows — these rows as CSV