PREVIEW / stock_5min / 2021-12-09
file: by_date/stock_5min/2021/2021-12-09.parquet size: 7.4 MB rows: 456,764 symbols: 2,662
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-09 04:00:00 | AAPL | Stock | 175.58 | 175.58 | 174.68 | 174.71 | 6053.0 |
| 2021-12-09 04:05:00 | AAPL | Stock | 174.72 | 174.73 | 174.61 | 174.65 | 6174.0 |
| 2021-12-09 04:10:00 | AAPL | Stock | 174.65 | 174.65 | 174.4 | 174.6 | 4307.0 |
| 2021-12-09 04:15:00 | AAPL | Stock | 174.6 | 174.6 | 174.55 | 174.56 | 684.0 |
| 2021-12-09 04:20:00 | AAPL | Stock | 174.56 | 174.75 | 174.56 | 174.75 | 1011.0 |
| 2021-12-09 04:25:00 | AAPL | Stock | 174.7 | 174.7 | 174.46 | 174.5 | 5330.0 |
| 2021-12-09 04:30:00 | AAPL | Stock | 174.6 | 174.6 | 174.52 | 174.52 | 401.0 |
| 2021-12-09 04:35:00 | AAPL | Stock | 174.54 | 174.59 | 174.52 | 174.52 | 1000.0 |
| 2021-12-09 04:40:00 | AAPL | Stock | 174.48 | 174.54 | 174.48 | 174.54 | 382.0 |
| 2021-12-09 04:45:00 | AAPL | Stock | 174.7 | 174.7 | 174.65 | 174.65 | 1203.0 |
| 2021-12-09 04:50:00 | AAPL | Stock | 174.56 | 174.56 | 174.56 | 174.56 | 189.0 |
| 2021-12-09 04:55:00 | AAPL | Stock | 174.56 | 174.56 | 174.56 | 174.56 | 531.0 |
| 2021-12-09 05:00:00 | AAPL | Stock | 174.56 | 174.56 | 174.38 | 174.38 | 8237.0 |
| 2021-12-09 05:05:00 | AAPL | Stock | 174.38 | 174.4 | 173.95 | 173.95 | 8929.0 |
| 2021-12-09 05:10:00 | AAPL | Stock | 174.09 | 174.13 | 173.84 | 173.9 | 18846.0 |
| 2021-12-09 05:15:00 | AAPL | Stock | 173.98 | 174.08 | 173.9 | 173.9 | 7283.0 |
| 2021-12-09 05:20:00 | AAPL | Stock | 173.86 | 173.86 | 173.8 | 173.8 | 1919.0 |
| 2021-12-09 05:25:00 | AAPL | Stock | 173.83 | 173.94 | 173.83 | 173.94 | 600.0 |
| 2021-12-09 05:30:00 | AAPL | Stock | 173.95 | 174.0 | 173.8 | 173.8 | 6901.0 |
| 2021-12-09 05:40:00 | AAPL | Stock | 173.8 | 173.8 | 173.7 | 173.77 | 2980.0 |
| 2021-12-09 05:45:00 | AAPL | Stock | 173.8 | 173.8 | 173.76 | 173.76 | 2269.0 |
| 2021-12-09 05:50:00 | AAPL | Stock | 173.8 | 173.85 | 173.8 | 173.85 | 392.0 |
| 2021-12-09 05:55:00 | AAPL | Stock | 173.85 | 173.85 | 173.84 | 173.85 | 1854.0 |
| 2021-12-09 06:00:00 | AAPL | Stock | 173.85 | 173.9 | 173.85 | 173.9 | 6403.0 |
| 2021-12-09 06:05:00 | AAPL | Stock | 173.9 | 173.9 | 173.81 | 173.89 | 883.0 |
| 2021-12-09 06:10:00 | AAPL | Stock | 173.8 | 173.81 | 173.62 | 173.62 | 5249.0 |
| 2021-12-09 06:15:00 | AAPL | Stock | 173.61 | 173.67 | 173.61 | 173.67 | 492.0 |
| 2021-12-09 06:20:00 | AAPL | Stock | 173.66 | 173.83 | 173.66 | 173.83 | 2809.0 |
| 2021-12-09 06:25:00 | AAPL | Stock | 173.75 | 173.75 | 173.68 | 173.68 | 1828.0 |
| 2021-12-09 06:30:00 | AAPL | Stock | 173.73 | 173.8 | 173.73 | 173.8 | 4397.0 |
| 2021-12-09 06:35:00 | AAPL | Stock | 173.85 | 173.85 | 173.77 | 173.77 | 486.0 |
| 2021-12-09 06:40:00 | AAPL | Stock | 173.8 | 173.8 | 173.74 | 173.74 | 569.0 |
| 2021-12-09 06:45:00 | AAPL | Stock | 173.72 | 173.75 | 173.68 | 173.68 | 1169.0 |
| 2021-12-09 06:50:00 | AAPL | Stock | 173.71 | 173.71 | 173.71 | 173.71 | 100.0 |
| 2021-12-09 06:55:00 | AAPL | Stock | 173.71 | 173.85 | 173.67 | 173.85 | 1563.0 |
| 2021-12-09 07:00:00 | AAPL | Stock | 173.85 | 174.16 | 173.85 | 174.15 | 26194.0 |
| 2021-12-09 07:05:00 | AAPL | Stock | 174.16 | 174.18 | 174.11 | 174.11 | 20015.0 |
| 2021-12-09 07:10:00 | AAPL | Stock | 174.15 | 174.29 | 174.08 | 174.08 | 16831.0 |
| 2021-12-09 07:15:00 | AAPL | Stock | 174.13 | 174.43 | 174.13 | 174.37 | 12493.0 |
| 2021-12-09 07:20:00 | AAPL | Stock | 174.35 | 174.41 | 174.27 | 174.31 | 7058.0 |
| 2021-12-09 07:25:00 | AAPL | Stock | 174.29 | 174.41 | 174.22 | 174.22 | 11286.0 |
| 2021-12-09 07:30:00 | AAPL | Stock | 174.24 | 174.36 | 174.23 | 174.34 | 3181.0 |
| 2021-12-09 07:35:00 | AAPL | Stock | 174.35 | 174.69 | 174.35 | 174.68 | 26883.0 |
| 2021-12-09 07:40:00 | AAPL | Stock | 174.64 | 174.69 | 174.5 | 174.57 | 19817.0 |
| 2021-12-09 07:45:00 | AAPL | Stock | 174.57 | 174.57 | 174.47 | 174.5 | 12566.0 |
| 2021-12-09 07:50:00 | AAPL | Stock | 174.52 | 174.53 | 174.47 | 174.47 | 5863.0 |
| 2021-12-09 07:55:00 | AAPL | Stock | 174.47 | 174.64 | 174.47 | 174.57 | 11209.0 |
| 2021-12-09 08:00:00 | AAPL | Stock | 174.1001 | 174.68 | 173.82 | 174.5701 | 128260.0 |
| 2021-12-09 08:05:00 | AAPL | Stock | 174.58 | 174.71 | 174.5 | 174.51 | 30677.0 |
| 2021-12-09 08:10:00 | AAPL | Stock | 174.53 | 174.53 | 174.15 | 174.15 | 32197.0 |
> showing 50 of 456,764 rows — these rows as CSV