PREVIEW / stock_5min / 2021-02-22
file: by_date/stock_5min/2021/2021-02-22.parquet size: 8.5 MB rows: 533,583 symbols: 2,838
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-02-22 04:00:00 | AAPL | Stock | 127.8 | 127.97 | 127.41 | 127.66 | 10884.0 |
| 2021-02-22 04:05:00 | AAPL | Stock | 127.69 | 127.69 | 127.29 | 127.5 | 7762.0 |
| 2021-02-22 04:10:00 | AAPL | Stock | 127.56 | 127.9 | 127.56 | 127.9 | 2166.0 |
| 2021-02-22 04:15:00 | AAPL | Stock | 127.87 | 127.87 | 127.6 | 127.62 | 6196.0 |
| 2021-02-22 04:20:00 | AAPL | Stock | 127.61 | 127.61 | 127.5 | 127.58 | 4457.0 |
| 2021-02-22 04:25:00 | AAPL | Stock | 127.56 | 127.6 | 127.5 | 127.52 | 3531.0 |
| 2021-02-22 04:30:00 | AAPL | Stock | 127.4 | 127.54 | 127.4 | 127.4 | 4185.0 |
| 2021-02-22 04:35:00 | AAPL | Stock | 127.36 | 127.36 | 127.16 | 127.36 | 3349.0 |
| 2021-02-22 04:40:00 | AAPL | Stock | 127.44 | 127.5 | 127.44 | 127.5 | 761.0 |
| 2021-02-22 04:45:00 | AAPL | Stock | 127.56 | 127.67 | 127.56 | 127.67 | 1140.0 |
| 2021-02-22 04:50:00 | AAPL | Stock | 127.61 | 127.65 | 127.57 | 127.65 | 587.0 |
| 2021-02-22 04:55:00 | AAPL | Stock | 127.69 | 127.79 | 127.69 | 127.75 | 3968.0 |
| 2021-02-22 05:00:00 | AAPL | Stock | 127.75 | 127.75 | 127.71 | 127.74 | 3067.0 |
| 2021-02-22 05:05:00 | AAPL | Stock | 127.76 | 127.94 | 127.76 | 127.79 | 1997.0 |
| 2021-02-22 05:10:00 | AAPL | Stock | 127.87 | 127.87 | 127.78 | 127.78 | 455.0 |
| 2021-02-22 05:15:00 | AAPL | Stock | 127.77 | 127.78 | 127.75 | 127.75 | 622.0 |
| 2021-02-22 05:20:00 | AAPL | Stock | 127.75 | 127.79 | 127.75 | 127.79 | 1810.0 |
| 2021-02-22 05:25:00 | AAPL | Stock | 127.88 | 127.88 | 127.88 | 127.88 | 1000.0 |
| 2021-02-22 05:30:00 | AAPL | Stock | 127.84 | 127.88 | 127.84 | 127.84 | 4022.0 |
| 2021-02-22 05:35:00 | AAPL | Stock | 127.86 | 127.87 | 127.74 | 127.8 | 4394.0 |
| 2021-02-22 05:40:00 | AAPL | Stock | 127.88 | 127.93 | 127.88 | 127.9 | 1259.0 |
| 2021-02-22 05:45:00 | AAPL | Stock | 127.9 | 128.0 | 127.9 | 128.0 | 3531.0 |
| 2021-02-22 05:50:00 | AAPL | Stock | 127.95 | 128.0 | 127.72 | 127.72 | 5772.0 |
| 2021-02-22 05:55:00 | AAPL | Stock | 127.85 | 127.85 | 127.57 | 127.57 | 1894.0 |
| 2021-02-22 06:00:00 | AAPL | Stock | 127.61 | 127.65 | 127.59 | 127.65 | 2543.0 |
| 2021-02-22 06:05:00 | AAPL | Stock | 127.73 | 127.75 | 127.73 | 127.74 | 733.0 |
| 2021-02-22 06:10:00 | AAPL | Stock | 127.73 | 127.73 | 127.66 | 127.66 | 5038.0 |
| 2021-02-22 06:15:00 | AAPL | Stock | 127.63 | 127.66 | 127.63 | 127.66 | 685.0 |
| 2021-02-22 06:20:00 | AAPL | Stock | 127.66 | 127.66 | 127.66 | 127.66 | 502.0 |
| 2021-02-22 06:25:00 | AAPL | Stock | 127.78 | 127.78 | 127.34 | 127.4 | 8105.0 |
| 2021-02-22 06:30:00 | AAPL | Stock | 127.46 | 127.47 | 127.2 | 127.25 | 10653.0 |
| 2021-02-22 06:35:00 | AAPL | Stock | 127.25 | 127.47 | 127.0 | 127.31 | 20454.0 |
| 2021-02-22 06:40:00 | AAPL | Stock | 127.39 | 127.45 | 127.39 | 127.41 | 1009.0 |
| 2021-02-22 06:45:00 | AAPL | Stock | 127.33 | 127.5 | 127.31 | 127.5 | 3552.0 |
| 2021-02-22 06:50:00 | AAPL | Stock | 127.39 | 127.42 | 127.36 | 127.36 | 2057.0 |
| 2021-02-22 06:55:00 | AAPL | Stock | 127.35 | 127.55 | 127.28 | 127.55 | 4608.0 |
| 2021-02-22 07:00:00 | AAPL | Stock | 127.5 | 128.06 | 127.5 | 128.02 | 87716.0 |
| 2021-02-22 07:05:00 | AAPL | Stock | 127.96 | 127.96 | 127.81 | 127.81 | 36724.0 |
| 2021-02-22 07:10:00 | AAPL | Stock | 127.8 | 127.81 | 127.56 | 127.74 | 20160.0 |
| 2021-02-22 07:15:00 | AAPL | Stock | 127.75 | 127.75 | 127.67 | 127.68 | 10907.0 |
| 2021-02-22 07:20:00 | AAPL | Stock | 127.68 | 127.72 | 127.65 | 127.68 | 14573.0 |
| 2021-02-22 07:25:00 | AAPL | Stock | 127.68 | 127.78 | 127.66 | 127.78 | 19914.0 |
| 2021-02-22 07:30:00 | AAPL | Stock | 127.8 | 127.84 | 127.58 | 127.61 | 31914.0 |
| 2021-02-22 07:35:00 | AAPL | Stock | 127.62 | 127.66 | 127.5 | 127.5 | 36908.0 |
| 2021-02-22 07:40:00 | AAPL | Stock | 127.52 | 127.56 | 127.33 | 127.39 | 45191.0 |
| 2021-02-22 07:45:00 | AAPL | Stock | 127.38 | 127.66 | 127.371 | 127.61 | 22877.0 |
| 2021-02-22 07:50:00 | AAPL | Stock | 127.59 | 127.71 | 127.56 | 127.66 | 22699.0 |
| 2021-02-22 07:55:00 | AAPL | Stock | 127.66 | 127.9 | 127.65 | 127.9 | 24839.0 |
| 2021-02-22 08:00:00 | AAPL | Stock | 127.88 | 130.194 | 127.33 | 127.8 | 174242.0 |
| 2021-02-22 08:05:00 | AAPL | Stock | 127.8 | 127.82 | 127.65 | 127.69 | 25822.0 |
> showing 50 of 533,583 rows — these rows as CSV