PREVIEW / etf_5min / 2021-09-21
file: by_date/etf_5min/2021/2021-09-21.parquet size: 1.8 MB rows: 83,042
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-21 04:00:00 | SPY | ETF | 435.0 | 438.65 | 435.0 | 438.34 | 40380.0 |
| 2021-09-21 04:05:00 | SPY | ETF | 438.36 | 438.53 | 438.36 | 438.53 | 3140.0 |
| 2021-09-21 04:10:00 | SPY | ETF | 438.55 | 438.66 | 438.49 | 438.54 | 11009.0 |
| 2021-09-21 04:15:00 | SPY | ETF | 438.73 | 438.73 | 438.46 | 438.46 | 3868.0 |
| 2021-09-21 04:20:00 | SPY | ETF | 438.46 | 438.47 | 438.08 | 438.09 | 16095.0 |
| 2021-09-21 04:25:00 | SPY | ETF | 438.09 | 438.18 | 438.09 | 438.17 | 3100.0 |
| 2021-09-21 04:30:00 | SPY | ETF | 438.25 | 438.67 | 438.2 | 438.61 | 6414.0 |
| 2021-09-21 04:35:00 | SPY | ETF | 438.66 | 438.77 | 438.64 | 438.72 | 8100.0 |
| 2021-09-21 04:40:00 | SPY | ETF | 438.71 | 438.93 | 438.65 | 438.65 | 5812.0 |
| 2021-09-21 04:45:00 | SPY | ETF | 438.66 | 438.68 | 438.62 | 438.67 | 1787.0 |
| 2021-09-21 04:50:00 | SPY | ETF | 438.71 | 438.81 | 438.48 | 438.54 | 8316.0 |
| 2021-09-21 04:55:00 | SPY | ETF | 438.49 | 438.52 | 438.07 | 438.09 | 5798.0 |
| 2021-09-21 05:00:00 | SPY | ETF | 438.28 | 438.35 | 438.0 | 438.13 | 9161.0 |
| 2021-09-21 05:05:00 | SPY | ETF | 438.1 | 438.1 | 437.9 | 437.9 | 8400.0 |
| 2021-09-21 05:10:00 | SPY | ETF | 437.93 | 437.97 | 437.89 | 437.97 | 1975.0 |
| 2021-09-21 05:15:00 | SPY | ETF | 437.92 | 437.92 | 437.7 | 437.76 | 2400.0 |
| 2021-09-21 05:20:00 | SPY | ETF | 437.78 | 437.78 | 437.51 | 437.57 | 7399.0 |
| 2021-09-21 05:25:00 | SPY | ETF | 437.6 | 437.75 | 437.6 | 437.72 | 2710.0 |
| 2021-09-21 05:30:00 | SPY | ETF | 437.71 | 437.98 | 437.71 | 437.91 | 17698.0 |
| 2021-09-21 05:35:00 | SPY | ETF | 437.91 | 438.07 | 437.9 | 437.95 | 8856.0 |
| 2021-09-21 05:40:00 | SPY | ETF | 437.95 | 438.12 | 437.95 | 438.12 | 1200.0 |
| 2021-09-21 05:45:00 | SPY | ETF | 438.17 | 438.17 | 438.09 | 438.13 | 6973.0 |
| 2021-09-21 05:50:00 | SPY | ETF | 438.13 | 438.32 | 438.13 | 438.2 | 4919.0 |
| 2021-09-21 05:55:00 | SPY | ETF | 438.16 | 438.17 | 438.05 | 438.12 | 15911.0 |
| 2021-09-21 06:00:00 | SPY | ETF | 438.1 | 438.26 | 438.1 | 438.26 | 2400.0 |
| 2021-09-21 06:05:00 | SPY | ETF | 438.21 | 438.24 | 437.96 | 437.96 | 4940.0 |
| 2021-09-21 06:10:00 | SPY | ETF | 437.9 | 437.9 | 437.73 | 437.73 | 1700.0 |
| 2021-09-21 06:15:00 | SPY | ETF | 437.73 | 437.88 | 437.73 | 437.82 | 6842.0 |
| 2021-09-21 06:20:00 | SPY | ETF | 437.87 | 438.06 | 437.85 | 438.06 | 19144.0 |
| 2021-09-21 06:25:00 | SPY | ETF | 438.05 | 438.07 | 437.79 | 438.0 | 26514.0 |
| 2021-09-21 06:30:00 | SPY | ETF | 437.91 | 437.94 | 437.7 | 437.75 | 7628.0 |
| 2021-09-21 06:35:00 | SPY | ETF | 437.75 | 437.9 | 437.75 | 437.89 | 2289.0 |
| 2021-09-21 06:40:00 | SPY | ETF | 437.8 | 437.84 | 437.75 | 437.82 | 18000.0 |
| 2021-09-21 06:45:00 | SPY | ETF | 437.7 | 437.79 | 437.7 | 437.76 | 52879.0 |
| 2021-09-21 06:50:00 | SPY | ETF | 437.76 | 437.98 | 437.75 | 437.91 | 12700.0 |
| 2021-09-21 06:55:00 | SPY | ETF | 437.95 | 437.96 | 437.93 | 437.94 | 5400.0 |
| 2021-09-21 07:00:00 | SPY | ETF | 437.97 | 438.0 | 437.7 | 437.88 | 22998.0 |
| 2021-09-21 07:05:00 | SPY | ETF | 437.86 | 437.88 | 437.65 | 437.65 | 9594.0 |
| 2021-09-21 07:10:00 | SPY | ETF | 437.66 | 437.74 | 437.5 | 437.54 | 65465.0 |
| 2021-09-21 07:15:00 | SPY | ETF | 437.56 | 437.62 | 437.5 | 437.6 | 75456.0 |
| 2021-09-21 07:20:00 | SPY | ETF | 437.58 | 437.59 | 437.5 | 437.59 | 53765.0 |
| 2021-09-21 07:25:00 | SPY | ETF | 437.59 | 437.64 | 437.49 | 437.5 | 45852.0 |
| 2021-09-21 07:30:00 | SPY | ETF | 437.5 | 437.57 | 437.42 | 437.44 | 42493.0 |
| 2021-09-21 07:35:00 | SPY | ETF | 437.44 | 437.47 | 436.9 | 436.93 | 69282.0 |
| 2021-09-21 07:40:00 | SPY | ETF | 436.89 | 437.25 | 436.88 | 437.25 | 117568.0 |
| 2021-09-21 07:45:00 | SPY | ETF | 437.17 | 437.45 | 437.17 | 437.3 | 56669.0 |
| 2021-09-21 07:50:00 | SPY | ETF | 437.3 | 437.31 | 437.15 | 437.26 | 40276.0 |
| 2021-09-21 07:55:00 | SPY | ETF | 437.35 | 437.48 | 437.31 | 437.46 | 21470.0 |
| 2021-09-21 08:00:00 | SPY | ETF | 437.9001 | 438.43 | 436.13 | 437.34 | 293988.0 |
| 2021-09-21 08:05:00 | SPY | ETF | 437.34 | 437.62 | 437.34 | 437.62 | 7526.0 |
> showing 50 of 83,042 rows — these rows as CSV