PREVIEW / etf_5min / 2021-05-07
file: by_date/etf_5min/2021/2021-05-07.parquet size: 1.8 MB rows: 84,146
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-05-07 04:00:00 | SPY | ETF | 419.13 | 419.17 | 419.1 | 419.14 | 1700.0 |
| 2021-05-07 04:05:00 | SPY | ETF | 419.26 | 419.26 | 419.25 | 419.26 | 400.0 |
| 2021-05-07 04:15:00 | SPY | ETF | 419.18 | 419.18 | 419.14 | 419.17 | 1300.0 |
| 2021-05-07 04:20:00 | SPY | ETF | 419.3 | 419.38 | 419.3 | 419.38 | 400.0 |
| 2021-05-07 04:25:00 | SPY | ETF | 419.34 | 419.34 | 419.34 | 419.34 | 323.0 |
| 2021-05-07 04:30:00 | SPY | ETF | 419.45 | 419.47 | 419.44 | 419.47 | 900.0 |
| 2021-05-07 04:35:00 | SPY | ETF | 419.46 | 419.46 | 419.44 | 419.44 | 1400.0 |
| 2021-05-07 04:40:00 | SPY | ETF | 419.5 | 419.5 | 419.5 | 419.5 | 300.0 |
| 2021-05-07 04:45:00 | SPY | ETF | 419.59 | 419.59 | 419.53 | 419.53 | 9999.0 |
| 2021-05-07 04:50:00 | SPY | ETF | 419.52 | 419.52 | 419.48 | 419.5 | 540.0 |
| 2021-05-07 05:00:00 | SPY | ETF | 419.59 | 419.59 | 419.56 | 419.56 | 719.0 |
| 2021-05-07 05:05:00 | SPY | ETF | 419.56 | 419.56 | 419.56 | 419.56 | 200.0 |
| 2021-05-07 05:10:00 | SPY | ETF | 419.55 | 419.55 | 419.49 | 419.49 | 719.0 |
| 2021-05-07 05:20:00 | SPY | ETF | 419.64 | 419.64 | 419.64 | 419.64 | 200.0 |
| 2021-05-07 05:25:00 | SPY | ETF | 419.61 | 419.64 | 419.61 | 419.63 | 700.0 |
| 2021-05-07 05:30:00 | SPY | ETF | 419.64 | 419.71 | 419.63 | 419.71 | 1160.0 |
| 2021-05-07 05:35:00 | SPY | ETF | 419.71 | 419.71 | 419.71 | 419.71 | 200.0 |
| 2021-05-07 05:45:00 | SPY | ETF | 419.71 | 419.71 | 419.64 | 419.64 | 549.0 |
| 2021-05-07 05:55:00 | SPY | ETF | 419.64 | 419.64 | 419.64 | 419.64 | 216.0 |
| 2021-05-07 06:00:00 | SPY | ETF | 419.97 | 420.0 | 419.89 | 419.9 | 4210.0 |
| 2021-05-07 06:05:00 | SPY | ETF | 419.91 | 419.91 | 419.91 | 419.91 | 1400.0 |
| 2021-05-07 06:10:00 | SPY | ETF | 419.99 | 420.01 | 419.95 | 419.95 | 2075.0 |
| 2021-05-07 06:15:00 | SPY | ETF | 420.21 | 420.24 | 420.21 | 420.21 | 2499.0 |
| 2021-05-07 06:20:00 | SPY | ETF | 420.19 | 420.19 | 420.18 | 420.18 | 500.0 |
| 2021-05-07 06:25:00 | SPY | ETF | 420.22 | 420.22 | 420.15 | 420.19 | 500.0 |
| 2021-05-07 06:30:00 | SPY | ETF | 420.13 | 420.13 | 420.1 | 420.1 | 600.0 |
| 2021-05-07 06:35:00 | SPY | ETF | 420.11 | 420.11 | 420.08 | 420.08 | 200.0 |
| 2021-05-07 06:40:00 | SPY | ETF | 420.17 | 420.17 | 420.13 | 420.13 | 400.0 |
| 2021-05-07 06:45:00 | SPY | ETF | 420.25 | 420.25 | 420.23 | 420.23 | 3699.0 |
| 2021-05-07 06:50:00 | SPY | ETF | 420.18 | 420.2 | 420.18 | 420.2 | 700.0 |
| 2021-05-07 06:55:00 | SPY | ETF | 420.15 | 420.15 | 420.05 | 420.05 | 800.0 |
| 2021-05-07 07:00:00 | SPY | ETF | 420.09 | 420.1 | 420.01 | 420.05 | 23910.0 |
| 2021-05-07 07:05:00 | SPY | ETF | 420.11 | 420.11 | 420.06 | 420.06 | 18808.0 |
| 2021-05-07 07:10:00 | SPY | ETF | 420.05 | 420.05 | 419.96 | 419.96 | 3920.0 |
| 2021-05-07 07:15:00 | SPY | ETF | 419.95 | 420.03 | 419.95 | 420.01 | 2519.0 |
| 2021-05-07 07:20:00 | SPY | ETF | 419.98 | 419.98 | 419.81 | 419.85 | 7685.0 |
| 2021-05-07 07:25:00 | SPY | ETF | 419.85 | 419.94 | 419.85 | 419.89 | 12124.0 |
| 2021-05-07 07:30:00 | SPY | ETF | 419.92 | 419.92 | 419.9 | 419.9 | 5190.0 |
| 2021-05-07 07:35:00 | SPY | ETF | 419.97 | 420.06 | 419.97 | 420.06 | 830.0 |
| 2021-05-07 07:40:00 | SPY | ETF | 420.02 | 420.06 | 420.02 | 420.03 | 7350.0 |
| 2021-05-07 07:45:00 | SPY | ETF | 420.05 | 420.07 | 420.0 | 420.05 | 35040.0 |
| 2021-05-07 07:50:00 | SPY | ETF | 420.05 | 420.1 | 420.05 | 420.1 | 4390.0 |
| 2021-05-07 07:55:00 | SPY | ETF | 420.12 | 420.13 | 420.09 | 420.13 | 14425.0 |
| 2021-05-07 08:00:00 | SPY | ETF | 420.1 | 420.28 | 419.0 | 419.89 | 19183.0 |
| 2021-05-07 08:05:00 | SPY | ETF | 419.91 | 419.92 | 419.48 | 419.84 | 16731.0 |
| 2021-05-07 08:10:00 | SPY | ETF | 419.84 | 419.87 | 419.74 | 419.86 | 5974.0 |
| 2021-05-07 08:15:00 | SPY | ETF | 419.88 | 420.0 | 419.88 | 419.91 | 28690.0 |
| 2021-05-07 08:20:00 | SPY | ETF | 419.94 | 420.0 | 419.93 | 420.0 | 12219.0 |
| 2021-05-07 08:25:00 | SPY | ETF | 420.05 | 420.5 | 420.0 | 420.3 | 89203.0 |
| 2021-05-07 08:30:00 | SPY | ETF | 420.37 | 421.5 | 419.28 | 419.95 | 657408.0 |
> showing 50 of 84,146 rows — these rows as CSV