PREVIEW / etf_5min / 2021-09-24
file: by_date/etf_5min/2021/2021-09-24.parquet size: 1.7 MB rows: 78,386
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-09-24 04:00:00 | SPY | ETF | 442.69 | 442.69 | 441.57 | 441.79 | 16550.0 |
| 2021-09-24 04:05:00 | SPY | ETF | 441.64 | 441.76 | 441.32 | 441.34 | 6246.0 |
| 2021-09-24 04:10:00 | SPY | ETF | 441.48 | 441.61 | 441.39 | 441.39 | 19567.0 |
| 2021-09-24 04:15:00 | SPY | ETF | 441.25 | 441.41 | 441.2 | 441.23 | 4600.0 |
| 2021-09-24 04:20:00 | SPY | ETF | 441.18 | 441.42 | 441.01 | 441.42 | 4850.0 |
| 2021-09-24 04:25:00 | SPY | ETF | 441.47 | 441.69 | 441.46 | 441.69 | 3867.0 |
| 2021-09-24 04:30:00 | SPY | ETF | 441.77 | 441.85 | 441.75 | 441.85 | 1320.0 |
| 2021-09-24 04:35:00 | SPY | ETF | 441.79 | 441.8 | 441.64 | 441.66 | 4499.0 |
| 2021-09-24 04:40:00 | SPY | ETF | 441.79 | 441.79 | 441.74 | 441.74 | 440.0 |
| 2021-09-24 04:45:00 | SPY | ETF | 441.6 | 441.77 | 441.6 | 441.77 | 2835.0 |
| 2021-09-24 04:50:00 | SPY | ETF | 442.0 | 442.15 | 442.0 | 442.15 | 4118.0 |
| 2021-09-24 04:55:00 | SPY | ETF | 442.09 | 442.14 | 442.09 | 442.14 | 600.0 |
| 2021-09-24 05:00:00 | SPY | ETF | 442.07 | 442.13 | 442.0 | 442.0 | 7950.0 |
| 2021-09-24 05:05:00 | SPY | ETF | 441.9 | 441.98 | 441.9 | 441.98 | 4200.0 |
| 2021-09-24 05:10:00 | SPY | ETF | 441.82 | 441.9 | 441.82 | 441.9 | 1845.0 |
| 2021-09-24 05:15:00 | SPY | ETF | 441.9 | 441.9 | 441.75 | 441.78 | 5220.0 |
| 2021-09-24 05:20:00 | SPY | ETF | 441.77 | 441.94 | 441.77 | 441.9 | 2049.0 |
| 2021-09-24 05:25:00 | SPY | ETF | 441.95 | 441.97 | 441.72 | 441.72 | 1169.0 |
| 2021-09-24 05:30:00 | SPY | ETF | 441.7 | 441.94 | 441.7 | 441.83 | 2900.0 |
| 2021-09-24 05:35:00 | SPY | ETF | 441.93 | 442.02 | 441.9 | 442.0 | 1185.0 |
| 2021-09-24 05:40:00 | SPY | ETF | 442.01 | 442.01 | 441.94 | 441.94 | 600.0 |
| 2021-09-24 05:45:00 | SPY | ETF | 441.87 | 441.87 | 441.49 | 441.49 | 14953.0 |
| 2021-09-24 05:50:00 | SPY | ETF | 441.39 | 441.49 | 441.24 | 441.42 | 13200.0 |
| 2021-09-24 05:55:00 | SPY | ETF | 441.4 | 441.4 | 441.18 | 441.24 | 1200.0 |
| 2021-09-24 06:00:00 | SPY | ETF | 441.21 | 441.32 | 441.15 | 441.2 | 6799.0 |
| 2021-09-24 06:05:00 | SPY | ETF | 441.32 | 441.51 | 441.22 | 441.5 | 4900.0 |
| 2021-09-24 06:10:00 | SPY | ETF | 441.53 | 441.67 | 441.53 | 441.6 | 1400.0 |
| 2021-09-24 06:15:00 | SPY | ETF | 441.67 | 441.72 | 441.67 | 441.72 | 800.0 |
| 2021-09-24 06:20:00 | SPY | ETF | 441.72 | 442.1 | 441.62 | 442.05 | 9000.0 |
| 2021-09-24 06:25:00 | SPY | ETF | 442.1 | 442.15 | 441.68 | 441.68 | 10570.0 |
| 2021-09-24 06:30:00 | SPY | ETF | 441.78 | 441.8 | 441.57 | 441.66 | 8300.0 |
| 2021-09-24 06:35:00 | SPY | ETF | 441.77 | 441.77 | 441.65 | 441.65 | 800.0 |
| 2021-09-24 06:40:00 | SPY | ETF | 441.64 | 441.83 | 441.64 | 441.83 | 799.0 |
| 2021-09-24 06:45:00 | SPY | ETF | 441.83 | 441.84 | 441.66 | 441.76 | 49610.0 |
| 2021-09-24 06:50:00 | SPY | ETF | 441.75 | 441.78 | 441.75 | 441.77 | 800.0 |
| 2021-09-24 06:55:00 | SPY | ETF | 441.7 | 441.7 | 441.51 | 441.51 | 17568.0 |
| 2021-09-24 07:00:00 | SPY | ETF | 441.5 | 441.71 | 441.47 | 441.65 | 10653.0 |
| 2021-09-24 07:05:00 | SPY | ETF | 441.63 | 441.72 | 441.62 | 441.7 | 6025.0 |
| 2021-09-24 07:10:00 | SPY | ETF | 441.71 | 441.71 | 441.02 | 441.16 | 32157.0 |
| 2021-09-24 07:15:00 | SPY | ETF | 441.13 | 441.18 | 440.95 | 441.0 | 48292.0 |
| 2021-09-24 07:20:00 | SPY | ETF | 441.06 | 441.5 | 441.06 | 441.44 | 41456.0 |
| 2021-09-24 07:25:00 | SPY | ETF | 441.4 | 441.7 | 441.22 | 441.7 | 34772.0 |
| 2021-09-24 07:30:00 | SPY | ETF | 441.67 | 441.78 | 441.46 | 441.59 | 39481.0 |
| 2021-09-24 07:35:00 | SPY | ETF | 441.59 | 441.69 | 441.55 | 441.69 | 14038.0 |
| 2021-09-24 07:40:00 | SPY | ETF | 441.68 | 441.68 | 441.36 | 441.38 | 23099.0 |
| 2021-09-24 07:45:00 | SPY | ETF | 441.38 | 441.43 | 441.3 | 441.41 | 30209.0 |
| 2021-09-24 07:50:00 | SPY | ETF | 441.43 | 441.45 | 441.15 | 441.23 | 54959.0 |
| 2021-09-24 07:55:00 | SPY | ETF | 441.2 | 441.2 | 441.0 | 441.02 | 22239.0 |
| 2021-09-24 08:00:00 | SPY | ETF | 441.3799 | 443.512 | 440.97 | 441.11 | 120254.0 |
| 2021-09-24 08:05:00 | SPY | ETF | 441.11 | 441.24 | 441.06 | 441.15 | 37316.0 |
> showing 50 of 78,386 rows — these rows as CSV