PREVIEW / stock_5min / 2023-07-07
file: by_date/stock_5min/2023/2023-07-07.parquet size: 6.6 MB rows: 400,483 symbols: 1,519
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-07-07 04:00:00 | AAPL | Stock | 192.4 | 192.46 | 191.3 | 191.33 | 5171.0 |
| 2023-07-07 04:05:00 | AAPL | Stock | 191.35 | 191.35 | 191.32 | 191.32 | 595.0 |
| 2023-07-07 04:10:00 | AAPL | Stock | 191.35 | 191.43 | 191.34 | 191.43 | 706.0 |
| 2023-07-07 04:15:00 | AAPL | Stock | 191.45 | 191.5 | 191.45 | 191.5 | 1282.0 |
| 2023-07-07 04:20:00 | AAPL | Stock | 191.51 | 191.51 | 191.51 | 191.51 | 100.0 |
| 2023-07-07 04:25:00 | AAPL | Stock | 191.5 | 191.5 | 191.49 | 191.5 | 665.0 |
| 2023-07-07 04:30:00 | AAPL | Stock | 191.58 | 191.58 | 191.58 | 191.58 | 104.0 |
| 2023-07-07 04:40:00 | AAPL | Stock | 191.6 | 191.68 | 191.6 | 191.68 | 400.0 |
| 2023-07-07 04:45:00 | AAPL | Stock | 191.71 | 191.72 | 191.71 | 191.72 | 204.0 |
| 2023-07-07 04:50:00 | AAPL | Stock | 191.73 | 191.77 | 191.73 | 191.75 | 704.0 |
| 2023-07-07 04:55:00 | AAPL | Stock | 191.75 | 191.79 | 191.75 | 191.79 | 425.0 |
| 2023-07-07 05:00:00 | AAPL | Stock | 191.75 | 191.78 | 191.65 | 191.78 | 1760.0 |
| 2023-07-07 05:05:00 | AAPL | Stock | 191.75 | 191.75 | 191.73 | 191.73 | 590.0 |
| 2023-07-07 05:10:00 | AAPL | Stock | 191.71 | 191.71 | 191.71 | 191.71 | 100.0 |
| 2023-07-07 05:20:00 | AAPL | Stock | 191.74 | 191.79 | 191.74 | 191.74 | 2189.0 |
| 2023-07-07 05:30:00 | AAPL | Stock | 191.75 | 191.75 | 191.75 | 191.75 | 338.0 |
| 2023-07-07 05:35:00 | AAPL | Stock | 191.75 | 191.8 | 191.75 | 191.8 | 962.0 |
| 2023-07-07 05:40:00 | AAPL | Stock | 191.75 | 191.75 | 191.75 | 191.75 | 100.0 |
| 2023-07-07 05:45:00 | AAPL | Stock | 191.77 | 191.77 | 191.77 | 191.77 | 100.0 |
| 2023-07-07 05:55:00 | AAPL | Stock | 191.79 | 191.79 | 191.73 | 191.73 | 260.0 |
| 2023-07-07 06:00:00 | AAPL | Stock | 191.73 | 191.73 | 191.46 | 191.48 | 959.0 |
| 2023-07-07 06:05:00 | AAPL | Stock | 191.47 | 191.5 | 191.47 | 191.47 | 479.0 |
| 2023-07-07 06:15:00 | AAPL | Stock | 191.44 | 191.5 | 191.44 | 191.5 | 1200.0 |
| 2023-07-07 06:20:00 | AAPL | Stock | 191.52 | 191.53 | 191.5 | 191.53 | 2548.0 |
| 2023-07-07 06:25:00 | AAPL | Stock | 191.5 | 191.5 | 191.5 | 191.5 | 322.0 |
| 2023-07-07 06:30:00 | AAPL | Stock | 191.55 | 191.55 | 191.55 | 191.55 | 192.0 |
| 2023-07-07 06:35:00 | AAPL | Stock | 191.59 | 191.59 | 191.5 | 191.5 | 1048.0 |
| 2023-07-07 06:55:00 | AAPL | Stock | 191.61 | 191.61 | 191.61 | 191.61 | 120.0 |
| 2023-07-07 07:00:00 | AAPL | Stock | 191.65 | 191.68 | 191.6 | 191.68 | 775.0 |
| 2023-07-07 07:05:00 | AAPL | Stock | 191.7 | 191.7 | 191.7 | 191.7 | 320.0 |
| 2023-07-07 07:10:00 | AAPL | Stock | 191.76 | 191.76 | 191.7 | 191.76 | 2560.0 |
| 2023-07-07 07:15:00 | AAPL | Stock | 191.66 | 191.76 | 191.6 | 191.63 | 13550.0 |
| 2023-07-07 07:20:00 | AAPL | Stock | 191.65 | 191.65 | 191.63 | 191.63 | 200.0 |
| 2023-07-07 07:25:00 | AAPL | Stock | 191.64 | 191.65 | 191.64 | 191.65 | 371.0 |
| 2023-07-07 07:30:00 | AAPL | Stock | 191.61 | 191.61 | 191.61 | 191.61 | 150.0 |
| 2023-07-07 07:35:00 | AAPL | Stock | 191.65 | 191.65 | 191.6 | 191.61 | 1869.0 |
| 2023-07-07 07:40:00 | AAPL | Stock | 191.61 | 191.61 | 191.58 | 191.58 | 850.0 |
| 2023-07-07 07:45:00 | AAPL | Stock | 191.62 | 191.7 | 191.62 | 191.69 | 11340.0 |
| 2023-07-07 07:50:00 | AAPL | Stock | 191.73 | 191.74 | 191.67 | 191.7 | 3028.0 |
| 2023-07-07 07:55:00 | AAPL | Stock | 191.66 | 191.66 | 191.56 | 191.56 | 2423.0 |
| 2023-07-07 08:00:00 | AAPL | Stock | 191.63 | 191.86 | 191.5 | 191.65 | 23669.0 |
| 2023-07-07 08:05:00 | AAPL | Stock | 191.7 | 191.72 | 191.63 | 191.72 | 800.0 |
| 2023-07-07 08:10:00 | AAPL | Stock | 191.7 | 191.7 | 191.65 | 191.65 | 2058.0 |
| 2023-07-07 08:15:00 | AAPL | Stock | 191.7 | 191.72 | 191.68 | 191.72 | 1500.0 |
| 2023-07-07 08:20:00 | AAPL | Stock | 191.65 | 191.65 | 191.61 | 191.6468 | 4131.0 |
| 2023-07-07 08:25:00 | AAPL | Stock | 191.62 | 191.68 | 191.6 | 191.67 | 11571.0 |
| 2023-07-07 08:30:00 | AAPL | Stock | 191.76 | 192.44 | 191.76 | 192.44 | 96907.0 |
| 2023-07-07 08:35:00 | AAPL | Stock | 192.44 | 192.44 | 191.97 | 192.12 | 44239.0 |
| 2023-07-07 08:40:00 | AAPL | Stock | 192.1 | 192.1 | 191.51 | 191.75 | 44563.0 |
| 2023-07-07 08:45:00 | AAPL | Stock | 191.86 | 191.9 | 191.45 | 191.85 | 37494.0 |
> showing 50 of 400,483 rows — these rows as CSV