PREVIEW / stock_5min / 2023-04-14
file: by_date/stock_5min/2023/2023-04-14.parquet size: 6.7 MB rows: 410,687 symbols: 1,680
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-14 04:00:00 | AAPL | Stock | 165.3 | 165.78 | 165.3 | 165.51 | 3225.0 |
| 2023-04-14 04:05:00 | AAPL | Stock | 165.51 | 165.51 | 165.28 | 165.28 | 587.0 |
| 2023-04-14 04:10:00 | AAPL | Stock | 165.14 | 165.14 | 165.14 | 165.14 | 250.0 |
| 2023-04-14 04:15:00 | AAPL | Stock | 165.18 | 165.18 | 165.17 | 165.17 | 200.0 |
| 2023-04-14 04:20:00 | AAPL | Stock | 165.15 | 165.15 | 165.15 | 165.15 | 1052.0 |
| 2023-04-14 04:25:00 | AAPL | Stock | 165.09 | 165.09 | 165.09 | 165.09 | 150.0 |
| 2023-04-14 04:40:00 | AAPL | Stock | 165.05 | 165.1 | 165.05 | 165.1 | 317.0 |
| 2023-04-14 04:45:00 | AAPL | Stock | 165.08 | 165.08 | 165.05 | 165.05 | 512.0 |
| 2023-04-14 05:05:00 | AAPL | Stock | 165.0 | 165.0 | 164.99 | 164.99 | 250.0 |
| 2023-04-14 05:10:00 | AAPL | Stock | 164.94 | 164.94 | 164.94 | 164.94 | 119.0 |
| 2023-04-14 05:20:00 | AAPL | Stock | 164.99 | 164.99 | 164.99 | 164.99 | 405.0 |
| 2023-04-14 05:35:00 | AAPL | Stock | 164.89 | 164.89 | 164.89 | 164.89 | 100.0 |
| 2023-04-14 05:40:00 | AAPL | Stock | 164.94 | 164.97 | 164.94 | 164.97 | 259.0 |
| 2023-04-14 05:45:00 | AAPL | Stock | 164.92 | 164.93 | 164.92 | 164.93 | 200.0 |
| 2023-04-14 05:50:00 | AAPL | Stock | 164.96 | 164.96 | 164.96 | 164.96 | 100.0 |
| 2023-04-14 05:55:00 | AAPL | Stock | 164.96 | 164.96 | 164.94 | 164.94 | 1185.0 |
| 2023-04-14 06:00:00 | AAPL | Stock | 164.93 | 164.93 | 164.93 | 164.93 | 328.0 |
| 2023-04-14 06:10:00 | AAPL | Stock | 164.93 | 164.93 | 164.86 | 164.86 | 1392.0 |
| 2023-04-14 06:15:00 | AAPL | Stock | 164.83 | 164.83 | 164.79 | 164.79 | 1629.0 |
| 2023-04-14 06:20:00 | AAPL | Stock | 164.8 | 164.8 | 164.77 | 164.79 | 4036.0 |
| 2023-04-14 06:25:00 | AAPL | Stock | 164.81 | 164.85 | 164.81 | 164.85 | 1162.0 |
| 2023-04-14 06:35:00 | AAPL | Stock | 164.85 | 164.85 | 164.85 | 164.85 | 144.0 |
| 2023-04-14 06:40:00 | AAPL | Stock | 164.85 | 164.85 | 164.85 | 164.85 | 365.0 |
| 2023-04-14 06:50:00 | AAPL | Stock | 164.95 | 164.95 | 164.5 | 164.5 | 11226.0 |
| 2023-04-14 06:55:00 | AAPL | Stock | 164.36 | 164.44 | 164.3 | 164.31 | 1530.0 |
| 2023-04-14 07:00:00 | AAPL | Stock | 164.55 | 164.72 | 164.5 | 164.55 | 12754.0 |
| 2023-04-14 07:05:00 | AAPL | Stock | 164.68 | 164.68 | 164.36 | 164.4 | 4559.0 |
| 2023-04-14 07:10:00 | AAPL | Stock | 164.47 | 164.6 | 164.47 | 164.6 | 3553.0 |
| 2023-04-14 07:15:00 | AAPL | Stock | 164.55 | 164.57 | 164.35 | 164.35 | 5237.0 |
| 2023-04-14 07:20:00 | AAPL | Stock | 164.4 | 164.5 | 164.35 | 164.5 | 9383.0 |
| 2023-04-14 07:25:00 | AAPL | Stock | 164.54 | 164.54 | 164.5 | 164.53 | 1997.0 |
| 2023-04-14 07:30:00 | AAPL | Stock | 164.53 | 164.61 | 164.53 | 164.55 | 11084.0 |
| 2023-04-14 07:35:00 | AAPL | Stock | 164.6 | 164.61 | 164.46 | 164.46 | 2670.0 |
| 2023-04-14 07:40:00 | AAPL | Stock | 164.47 | 164.5 | 164.45 | 164.45 | 7588.0 |
| 2023-04-14 07:45:00 | AAPL | Stock | 164.5 | 164.53 | 164.4 | 164.53 | 1602.0 |
| 2023-04-14 07:50:00 | AAPL | Stock | 164.54 | 164.6 | 164.54 | 164.6 | 2503.0 |
| 2023-04-14 07:55:00 | AAPL | Stock | 164.61 | 164.64 | 164.55 | 164.55 | 7575.0 |
| 2023-04-14 08:00:00 | AAPL | Stock | 165.05 | 165.25 | 164.35 | 164.74 | 91819.0 |
| 2023-04-14 08:05:00 | AAPL | Stock | 164.75 | 164.8 | 164.75 | 164.79 | 4368.0 |
| 2023-04-14 08:10:00 | AAPL | Stock | 164.79 | 164.89 | 164.79 | 164.875 | 12476.0 |
| 2023-04-14 08:15:00 | AAPL | Stock | 164.88 | 164.88 | 164.8 | 164.85 | 1905.0 |
| 2023-04-14 08:20:00 | AAPL | Stock | 164.8399 | 164.84 | 164.72 | 164.72 | 5816.0 |
| 2023-04-14 08:25:00 | AAPL | Stock | 164.8255 | 165.0 | 164.75 | 164.77 | 23115.0 |
| 2023-04-14 08:30:00 | AAPL | Stock | 164.8 | 165.15 | 164.35 | 164.35 | 59844.0 |
| 2023-04-14 08:35:00 | AAPL | Stock | 164.4 | 164.59 | 164.31 | 164.58 | 32004.0 |
| 2023-04-14 08:40:00 | AAPL | Stock | 164.51 | 164.51 | 164.15 | 164.15 | 46373.0 |
| 2023-04-14 08:45:00 | AAPL | Stock | 164.16 | 164.21 | 164.0 | 164.21 | 43694.0 |
| 2023-04-14 08:50:00 | AAPL | Stock | 164.2484 | 164.34 | 164.0 | 164.1499 | 16751.0 |
| 2023-04-14 08:55:00 | AAPL | Stock | 164.0 | 164.12 | 163.87 | 164.1018 | 35181.0 |
| 2023-04-14 09:00:00 | AAPL | Stock | 164.18 | 164.25 | 164.18 | 164.2 | 6170.0 |
> showing 50 of 410,687 rows — these rows as CSV