PREVIEW / etf_5min / 2022-04-12
file: by_date/etf_5min/2022/2022-04-12.parquet size: 2.0 MB rows: 97,315
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-04-12 04:00:00 | SPY | ETF | 438.59 | 438.59 | 438.09 | 438.2 | 18111.0 |
| 2022-04-12 04:05:00 | SPY | ETF | 438.28 | 438.32 | 438.08 | 438.32 | 2012.0 |
| 2022-04-12 04:10:00 | SPY | ETF | 438.5 | 438.59 | 438.39 | 438.59 | 9640.0 |
| 2022-04-12 04:15:00 | SPY | ETF | 438.71 | 438.73 | 438.5 | 438.5 | 2431.0 |
| 2022-04-12 04:20:00 | SPY | ETF | 438.7 | 438.93 | 438.7 | 438.86 | 3841.0 |
| 2022-04-12 04:25:00 | SPY | ETF | 438.73 | 438.88 | 438.61 | 438.86 | 3822.0 |
| 2022-04-12 04:30:00 | SPY | ETF | 438.97 | 439.26 | 438.86 | 439.26 | 6409.0 |
| 2022-04-12 04:35:00 | SPY | ETF | 439.25 | 439.64 | 439.25 | 439.58 | 1765.0 |
| 2022-04-12 04:40:00 | SPY | ETF | 439.67 | 439.77 | 439.55 | 439.55 | 4430.0 |
| 2022-04-12 04:45:00 | SPY | ETF | 439.62 | 439.9 | 439.58 | 439.68 | 5019.0 |
| 2022-04-12 04:50:00 | SPY | ETF | 439.88 | 440.0 | 439.87 | 439.99 | 4713.0 |
| 2022-04-12 04:55:00 | SPY | ETF | 439.95 | 439.96 | 439.7 | 439.7 | 3096.0 |
| 2022-04-12 05:00:00 | SPY | ETF | 439.64 | 439.77 | 439.61 | 439.61 | 3888.0 |
| 2022-04-12 05:05:00 | SPY | ETF | 439.76 | 439.92 | 439.76 | 439.92 | 300.0 |
| 2022-04-12 05:10:00 | SPY | ETF | 439.9 | 439.9 | 439.44 | 439.47 | 3400.0 |
| 2022-04-12 05:15:00 | SPY | ETF | 439.51 | 439.64 | 439.45 | 439.48 | 1900.0 |
| 2022-04-12 05:20:00 | SPY | ETF | 439.53 | 439.53 | 439.32 | 439.32 | 300.0 |
| 2022-04-12 05:25:00 | SPY | ETF | 439.53 | 439.73 | 439.49 | 439.73 | 8498.0 |
| 2022-04-12 05:30:00 | SPY | ETF | 439.77 | 439.82 | 439.75 | 439.8 | 609.0 |
| 2022-04-12 05:35:00 | SPY | ETF | 439.89 | 439.89 | 439.89 | 439.89 | 100.0 |
| 2022-04-12 05:40:00 | SPY | ETF | 439.96 | 440.0 | 439.96 | 440.0 | 5700.0 |
| 2022-04-12 05:45:00 | SPY | ETF | 440.0 | 440.07 | 439.79 | 439.79 | 7143.0 |
| 2022-04-12 05:50:00 | SPY | ETF | 440.08 | 440.18 | 440.08 | 440.18 | 1715.0 |
| 2022-04-12 05:55:00 | SPY | ETF | 440.13 | 440.2 | 439.96 | 439.96 | 6399.0 |
| 2022-04-12 06:00:00 | SPY | ETF | 439.98 | 440.28 | 439.97 | 440.15 | 12780.0 |
| 2022-04-12 06:05:00 | SPY | ETF | 440.07 | 440.07 | 440.01 | 440.07 | 1446.0 |
| 2022-04-12 06:10:00 | SPY | ETF | 439.93 | 440.28 | 439.93 | 440.26 | 400.0 |
| 2022-04-12 06:15:00 | SPY | ETF | 440.0 | 440.0 | 439.84 | 439.84 | 8618.0 |
| 2022-04-12 06:20:00 | SPY | ETF | 439.76 | 439.85 | 439.76 | 439.84 | 1233.0 |
| 2022-04-12 06:25:00 | SPY | ETF | 439.69 | 439.69 | 439.69 | 439.69 | 100.0 |
| 2022-04-12 06:30:00 | SPY | ETF | 440.03 | 440.07 | 440.02 | 440.07 | 600.0 |
| 2022-04-12 06:35:00 | SPY | ETF | 440.26 | 440.48 | 440.26 | 440.4 | 26966.0 |
| 2022-04-12 06:40:00 | SPY | ETF | 440.32 | 440.52 | 440.21 | 440.37 | 29552.0 |
| 2022-04-12 06:45:00 | SPY | ETF | 440.41 | 440.41 | 440.27 | 440.32 | 1322.0 |
| 2022-04-12 06:50:00 | SPY | ETF | 440.35 | 440.36 | 440.34 | 440.35 | 5495.0 |
| 2022-04-12 06:55:00 | SPY | ETF | 440.41 | 440.44 | 440.41 | 440.44 | 500.0 |
| 2022-04-12 07:00:00 | SPY | ETF | 440.1 | 440.26 | 440.1 | 440.26 | 7548.0 |
| 2022-04-12 07:05:00 | SPY | ETF | 440.08 | 440.15 | 439.95 | 439.98 | 10234.0 |
| 2022-04-12 07:10:00 | SPY | ETF | 439.96 | 439.96 | 439.85 | 439.85 | 8039.0 |
| 2022-04-12 07:15:00 | SPY | ETF | 439.81 | 439.9 | 439.66 | 439.86 | 1000.0 |
| 2022-04-12 07:20:00 | SPY | ETF | 439.89 | 440.05 | 439.77 | 439.93 | 5414.0 |
| 2022-04-12 07:25:00 | SPY | ETF | 439.86 | 440.1 | 439.86 | 440.05 | 6532.0 |
| 2022-04-12 07:30:00 | SPY | ETF | 440.18 | 440.37 | 440.18 | 440.29 | 3525.0 |
| 2022-04-12 07:35:00 | SPY | ETF | 440.38 | 440.4 | 440.17 | 440.32 | 4605.0 |
| 2022-04-12 07:40:00 | SPY | ETF | 440.31 | 440.43 | 440.1 | 440.16 | 6912.0 |
| 2022-04-12 07:45:00 | SPY | ETF | 440.34 | 440.49 | 440.32 | 440.46 | 7562.0 |
| 2022-04-12 07:50:00 | SPY | ETF | 440.46 | 440.57 | 440.45 | 440.45 | 10850.0 |
| 2022-04-12 07:55:00 | SPY | ETF | 440.44 | 440.55 | 440.35 | 440.53 | 60669.0 |
| 2022-04-12 08:00:00 | SPY | ETF | 440.44 | 440.58 | 437.5 | 440.54 | 69600.0 |
| 2022-04-12 08:05:00 | SPY | ETF | 440.54 | 441.03 | 440.53 | 441.0 | 53561.0 |
> showing 50 of 97,315 rows — these rows as CSV