PREVIEW / etf_5min / 2022-02-10
file: by_date/etf_5min/2022/2022-02-10.parquet size: 2.0 MB rows: 97,350
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-02-10 04:00:00 | SPY | ETF | 456.7 | 456.7 | 456.0 | 456.26 | 10243.0 |
| 2022-02-10 04:05:00 | SPY | ETF | 456.25 | 456.25 | 456.25 | 456.25 | 100.0 |
| 2022-02-10 04:10:00 | SPY | ETF | 456.38 | 456.38 | 456.33 | 456.37 | 1263.0 |
| 2022-02-10 04:15:00 | SPY | ETF | 456.37 | 456.41 | 456.3 | 456.3 | 6400.0 |
| 2022-02-10 04:25:00 | SPY | ETF | 456.36 | 456.55 | 456.29 | 456.55 | 3500.0 |
| 2022-02-10 04:30:00 | SPY | ETF | 456.56 | 456.57 | 456.5 | 456.5 | 5490.0 |
| 2022-02-10 04:35:00 | SPY | ETF | 456.7 | 456.7 | 456.7 | 456.7 | 100.0 |
| 2022-02-10 04:40:00 | SPY | ETF | 456.34 | 456.43 | 456.33 | 456.43 | 400.0 |
| 2022-02-10 04:45:00 | SPY | ETF | 456.45 | 456.45 | 456.34 | 456.34 | 300.0 |
| 2022-02-10 04:50:00 | SPY | ETF | 456.3 | 456.35 | 456.3 | 456.35 | 3150.0 |
| 2022-02-10 04:55:00 | SPY | ETF | 456.45 | 456.53 | 456.4 | 456.4 | 6099.0 |
| 2022-02-10 05:00:00 | SPY | ETF | 456.37 | 456.37 | 456.2 | 456.2 | 827.0 |
| 2022-02-10 05:05:00 | SPY | ETF | 456.17 | 456.17 | 456.17 | 456.17 | 100.0 |
| 2022-02-10 05:10:00 | SPY | ETF | 456.35 | 456.35 | 456.33 | 456.33 | 215.0 |
| 2022-02-10 05:15:00 | SPY | ETF | 456.5 | 456.53 | 456.45 | 456.45 | 1143.0 |
| 2022-02-10 05:20:00 | SPY | ETF | 456.46 | 456.46 | 456.46 | 456.46 | 110.0 |
| 2022-02-10 05:30:00 | SPY | ETF | 456.42 | 456.54 | 456.41 | 456.41 | 4830.0 |
| 2022-02-10 05:35:00 | SPY | ETF | 456.5 | 456.61 | 456.5 | 456.6 | 3600.0 |
| 2022-02-10 05:40:00 | SPY | ETF | 456.61 | 456.61 | 456.6 | 456.6 | 340.0 |
| 2022-02-10 05:45:00 | SPY | ETF | 456.75 | 456.78 | 456.72 | 456.76 | 5101.0 |
| 2022-02-10 05:50:00 | SPY | ETF | 456.9 | 456.9 | 456.85 | 456.85 | 1257.0 |
| 2022-02-10 05:55:00 | SPY | ETF | 456.77 | 456.82 | 456.77 | 456.82 | 200.0 |
| 2022-02-10 06:00:00 | SPY | ETF | 456.94 | 457.0 | 456.9 | 456.95 | 7676.0 |
| 2022-02-10 06:05:00 | SPY | ETF | 456.89 | 456.9 | 456.89 | 456.9 | 633.0 |
| 2022-02-10 06:10:00 | SPY | ETF | 456.89 | 456.9 | 456.89 | 456.9 | 550.0 |
| 2022-02-10 06:15:00 | SPY | ETF | 456.91 | 456.92 | 456.8 | 456.92 | 792.0 |
| 2022-02-10 06:20:00 | SPY | ETF | 456.9 | 456.95 | 456.9 | 456.95 | 300.0 |
| 2022-02-10 06:25:00 | SPY | ETF | 456.93 | 456.93 | 456.89 | 456.89 | 30400.0 |
| 2022-02-10 06:30:00 | SPY | ETF | 456.85 | 456.85 | 456.78 | 456.81 | 21751.0 |
| 2022-02-10 06:35:00 | SPY | ETF | 456.83 | 456.87 | 456.83 | 456.83 | 22086.0 |
| 2022-02-10 06:40:00 | SPY | ETF | 456.8 | 456.8 | 456.66 | 456.66 | 2600.0 |
| 2022-02-10 06:45:00 | SPY | ETF | 456.75 | 456.75 | 456.6 | 456.7 | 23400.0 |
| 2022-02-10 06:50:00 | SPY | ETF | 456.7 | 456.71 | 456.54 | 456.54 | 29884.0 |
| 2022-02-10 07:00:00 | SPY | ETF | 456.56 | 456.85 | 456.56 | 456.82 | 6680.0 |
| 2022-02-10 07:05:00 | SPY | ETF | 456.8 | 457.1 | 456.8 | 457.1 | 9951.0 |
| 2022-02-10 07:10:00 | SPY | ETF | 457.0 | 457.2 | 456.89 | 457.2 | 12401.0 |
| 2022-02-10 07:15:00 | SPY | ETF | 457.16 | 457.25 | 457.13 | 457.16 | 3405.0 |
| 2022-02-10 07:20:00 | SPY | ETF | 457.16 | 457.38 | 457.16 | 457.3 | 3410.0 |
| 2022-02-10 07:25:00 | SPY | ETF | 457.25 | 457.25 | 457.1 | 457.11 | 3900.0 |
| 2022-02-10 07:30:00 | SPY | ETF | 457.16 | 457.16 | 457.06 | 457.1 | 6200.0 |
| 2022-02-10 07:35:00 | SPY | ETF | 457.09 | 457.2 | 457.02 | 457.15 | 6960.0 |
| 2022-02-10 07:40:00 | SPY | ETF | 457.13 | 457.13 | 457.04 | 457.08 | 10899.0 |
| 2022-02-10 07:45:00 | SPY | ETF | 457.02 | 457.14 | 457.01 | 457.02 | 12441.0 |
| 2022-02-10 07:50:00 | SPY | ETF | 457.09 | 457.21 | 457.07 | 457.139 | 11154.0 |
| 2022-02-10 07:55:00 | SPY | ETF | 457.16 | 457.25 | 457.01 | 457.13 | 9749.0 |
| 2022-02-10 08:00:00 | SPY | ETF | 457.17 | 457.5 | 456.3196 | 457.44 | 24540.0 |
| 2022-02-10 08:05:00 | SPY | ETF | 457.39 | 457.88 | 457.39 | 457.84 | 55162.0 |
| 2022-02-10 08:10:00 | SPY | ETF | 457.8 | 457.883 | 457.45 | 457.47 | 26116.0 |
| 2022-02-10 08:15:00 | SPY | ETF | 457.47 | 457.55 | 457.37 | 457.37 | 52205.0 |
| 2022-02-10 08:20:00 | SPY | ETF | 457.35 | 457.4 | 457.07 | 457.22 | 30996.0 |
> showing 50 of 97,350 rows — these rows as CSV