PREVIEW / etf_5min / 2021-12-21
file: by_date/etf_5min/2021/2021-12-21.parquet size: 1.9 MB rows: 92,958
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-21 04:00:00 | SPY | ETF | 457.56 | 457.83 | 457.47 | 457.64 | 7855.0 |
| 2021-12-21 04:05:00 | SPY | ETF | 457.65 | 458.11 | 457.65 | 458.11 | 1000.0 |
| 2021-12-21 04:10:00 | SPY | ETF | 458.15 | 458.39 | 458.1 | 458.34 | 8742.0 |
| 2021-12-21 04:15:00 | SPY | ETF | 458.33 | 458.43 | 458.26 | 458.31 | 1887.0 |
| 2021-12-21 04:20:00 | SPY | ETF | 458.28 | 458.31 | 458.14 | 458.21 | 5362.0 |
| 2021-12-21 04:25:00 | SPY | ETF | 458.24 | 458.28 | 458.22 | 458.28 | 1646.0 |
| 2021-12-21 04:30:00 | SPY | ETF | 458.33 | 458.35 | 457.92 | 457.92 | 5968.0 |
| 2021-12-21 04:35:00 | SPY | ETF | 457.92 | 458.16 | 457.92 | 458.06 | 3220.0 |
| 2021-12-21 04:40:00 | SPY | ETF | 458.09 | 458.11 | 457.75 | 457.75 | 1627.0 |
| 2021-12-21 04:45:00 | SPY | ETF | 457.7 | 457.7 | 457.38 | 457.38 | 1509.0 |
| 2021-12-21 04:50:00 | SPY | ETF | 457.34 | 457.51 | 457.34 | 457.51 | 300.0 |
| 2021-12-21 04:55:00 | SPY | ETF | 457.56 | 457.56 | 457.2 | 457.2 | 1223.0 |
| 2021-12-21 05:00:00 | SPY | ETF | 457.1 | 457.27 | 457.09 | 457.27 | 600.0 |
| 2021-12-21 05:05:00 | SPY | ETF | 457.31 | 457.51 | 457.31 | 457.48 | 1529.0 |
| 2021-12-21 05:10:00 | SPY | ETF | 457.54 | 457.68 | 457.54 | 457.59 | 403.0 |
| 2021-12-21 05:15:00 | SPY | ETF | 457.93 | 457.98 | 457.89 | 457.94 | 1328.0 |
| 2021-12-21 05:20:00 | SPY | ETF | 458.02 | 458.08 | 458.02 | 458.08 | 701.0 |
| 2021-12-21 05:25:00 | SPY | ETF | 458.09 | 458.09 | 457.82 | 457.82 | 671.0 |
| 2021-12-21 05:30:00 | SPY | ETF | 457.82 | 458.01 | 457.77 | 457.99 | 1583.0 |
| 2021-12-21 05:35:00 | SPY | ETF | 458.11 | 458.24 | 458.11 | 458.14 | 420.0 |
| 2021-12-21 05:40:00 | SPY | ETF | 458.18 | 458.18 | 457.98 | 457.98 | 2310.0 |
| 2021-12-21 05:45:00 | SPY | ETF | 458.01 | 458.28 | 457.98 | 458.2 | 1000.0 |
| 2021-12-21 05:50:00 | SPY | ETF | 458.22 | 458.22 | 457.99 | 458.2 | 962.0 |
| 2021-12-21 05:55:00 | SPY | ETF | 458.2 | 458.41 | 458.15 | 458.41 | 2764.0 |
| 2021-12-21 06:00:00 | SPY | ETF | 458.37 | 458.48 | 458.37 | 458.48 | 3421.0 |
| 2021-12-21 06:05:00 | SPY | ETF | 458.35 | 458.5 | 458.34 | 458.49 | 1690.0 |
| 2021-12-21 06:10:00 | SPY | ETF | 458.52 | 458.67 | 458.47 | 458.66 | 1015.0 |
| 2021-12-21 06:15:00 | SPY | ETF | 458.72 | 459.02 | 458.7 | 459.01 | 33549.0 |
| 2021-12-21 06:20:00 | SPY | ETF | 459.01 | 459.11 | 458.92 | 459.01 | 10772.0 |
| 2021-12-21 06:25:00 | SPY | ETF | 459.13 | 459.53 | 459.13 | 459.49 | 4614.0 |
| 2021-12-21 06:30:00 | SPY | ETF | 459.6 | 459.6 | 459.34 | 459.4 | 3613.0 |
| 2021-12-21 06:35:00 | SPY | ETF | 459.52 | 459.6 | 459.42 | 459.44 | 2467.0 |
| 2021-12-21 06:40:00 | SPY | ETF | 459.42 | 459.42 | 459.21 | 459.21 | 38498.0 |
| 2021-12-21 06:45:00 | SPY | ETF | 459.21 | 459.49 | 459.21 | 459.49 | 5430.0 |
| 2021-12-21 06:50:00 | SPY | ETF | 459.56 | 459.56 | 459.43 | 459.49 | 4614.0 |
| 2021-12-21 06:55:00 | SPY | ETF | 459.49 | 459.49 | 459.4 | 459.41 | 2451.0 |
| 2021-12-21 07:00:00 | SPY | ETF | 459.47 | 459.47 | 459.3 | 459.36 | 14909.0 |
| 2021-12-21 07:05:00 | SPY | ETF | 459.36 | 459.4 | 459.25 | 459.25 | 46392.0 |
| 2021-12-21 07:10:00 | SPY | ETF | 459.24 | 459.34 | 459.24 | 459.26 | 17852.0 |
| 2021-12-21 07:15:00 | SPY | ETF | 459.26 | 459.29 | 459.19 | 459.23 | 7134.0 |
| 2021-12-21 07:20:00 | SPY | ETF | 459.25 | 459.47 | 459.25 | 459.36 | 18246.0 |
| 2021-12-21 07:25:00 | SPY | ETF | 459.38 | 459.58 | 459.38 | 459.41 | 8152.0 |
| 2021-12-21 07:30:00 | SPY | ETF | 459.45 | 459.47 | 459.24 | 459.25 | 7932.0 |
| 2021-12-21 07:35:00 | SPY | ETF | 459.25 | 459.38 | 459.19 | 459.33 | 11979.0 |
| 2021-12-21 07:40:00 | SPY | ETF | 459.36 | 459.37 | 459.26 | 459.32 | 7426.0 |
| 2021-12-21 07:45:00 | SPY | ETF | 459.34 | 459.61 | 459.31 | 459.44 | 13761.0 |
| 2021-12-21 07:50:00 | SPY | ETF | 459.46 | 459.69 | 459.43 | 459.6 | 7800.0 |
| 2021-12-21 07:55:00 | SPY | ETF | 459.69 | 459.75 | 459.56 | 459.56 | 16255.0 |
| 2021-12-21 08:00:00 | SPY | ETF | 459.62 | 459.69 | 455.321 | 459.21 | 72993.0 |
| 2021-12-21 08:05:00 | SPY | ETF | 459.21 | 459.25 | 458.83 | 458.85 | 53285.0 |
> showing 50 of 92,958 rows — these rows as CSV