PREVIEW / stock_5min / 2022-07-18
file: by_date/stock_5min/2022/2022-07-18.parquet size: 6.9 MB rows: 424,378 symbols: 2,305
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-18 04:00:00 | AAPL | Stock | 150.61 | 151.79 | 150.61 | 151.45 | 19642.0 |
| 2022-07-18 04:05:00 | AAPL | Stock | 151.53 | 151.7 | 151.53 | 151.61 | 2785.0 |
| 2022-07-18 04:10:00 | AAPL | Stock | 151.61 | 151.61 | 151.48 | 151.56 | 2649.0 |
| 2022-07-18 04:15:00 | AAPL | Stock | 151.59 | 151.62 | 151.56 | 151.62 | 700.0 |
| 2022-07-18 04:20:00 | AAPL | Stock | 151.62 | 151.7 | 151.62 | 151.7 | 2581.0 |
| 2022-07-18 04:25:00 | AAPL | Stock | 151.74 | 151.85 | 151.69 | 151.85 | 1080.0 |
| 2022-07-18 04:30:00 | AAPL | Stock | 151.84 | 151.88 | 151.78 | 151.82 | 6648.0 |
| 2022-07-18 04:35:00 | AAPL | Stock | 151.8 | 151.8 | 151.68 | 151.76 | 2820.0 |
| 2022-07-18 04:40:00 | AAPL | Stock | 151.83 | 151.9 | 151.83 | 151.9 | 2206.0 |
| 2022-07-18 04:50:00 | AAPL | Stock | 151.77 | 151.77 | 151.72 | 151.74 | 1013.0 |
| 2022-07-18 04:55:00 | AAPL | Stock | 151.71 | 151.71 | 151.69 | 151.7 | 718.0 |
| 2022-07-18 05:00:00 | AAPL | Stock | 151.69 | 151.75 | 151.69 | 151.75 | 1343.0 |
| 2022-07-18 05:05:00 | AAPL | Stock | 151.61 | 151.61 | 151.51 | 151.52 | 2222.0 |
| 2022-07-18 05:15:00 | AAPL | Stock | 151.58 | 151.58 | 151.58 | 151.58 | 1040.0 |
| 2022-07-18 05:20:00 | AAPL | Stock | 151.67 | 151.68 | 151.67 | 151.68 | 800.0 |
| 2022-07-18 05:25:00 | AAPL | Stock | 151.63 | 151.63 | 151.6 | 151.63 | 550.0 |
| 2022-07-18 05:30:00 | AAPL | Stock | 151.5 | 151.5 | 151.5 | 151.5 | 436.0 |
| 2022-07-18 05:35:00 | AAPL | Stock | 151.51 | 151.59 | 151.5 | 151.59 | 1812.0 |
| 2022-07-18 05:40:00 | AAPL | Stock | 151.49 | 151.5 | 151.49 | 151.5 | 1800.0 |
| 2022-07-18 05:45:00 | AAPL | Stock | 151.57 | 151.57 | 151.57 | 151.57 | 100.0 |
| 2022-07-18 05:50:00 | AAPL | Stock | 151.45 | 151.49 | 151.4 | 151.45 | 7923.0 |
| 2022-07-18 05:55:00 | AAPL | Stock | 151.5 | 151.5 | 151.5 | 151.5 | 700.0 |
| 2022-07-18 06:00:00 | AAPL | Stock | 151.45 | 151.45 | 151.45 | 151.45 | 490.0 |
| 2022-07-18 06:05:00 | AAPL | Stock | 151.44 | 151.5 | 151.43 | 151.43 | 740.0 |
| 2022-07-18 06:15:00 | AAPL | Stock | 151.45 | 151.49 | 151.44 | 151.49 | 469.0 |
| 2022-07-18 06:20:00 | AAPL | Stock | 151.44 | 151.5 | 151.44 | 151.46 | 2503.0 |
| 2022-07-18 06:30:00 | AAPL | Stock | 151.57 | 151.57 | 151.57 | 151.57 | 984.0 |
| 2022-07-18 06:35:00 | AAPL | Stock | 151.56 | 151.56 | 151.47 | 151.49 | 579.0 |
| 2022-07-18 06:40:00 | AAPL | Stock | 151.42 | 151.42 | 151.4 | 151.42 | 2800.0 |
| 2022-07-18 06:45:00 | AAPL | Stock | 151.42 | 151.55 | 151.42 | 151.46 | 2309.0 |
| 2022-07-18 06:55:00 | AAPL | Stock | 151.54 | 151.55 | 151.51 | 151.51 | 302.0 |
| 2022-07-18 07:00:00 | AAPL | Stock | 151.5 | 151.59 | 151.31 | 151.46 | 38535.0 |
| 2022-07-18 07:05:00 | AAPL | Stock | 151.48 | 151.59 | 151.45 | 151.59 | 11215.0 |
| 2022-07-18 07:10:00 | AAPL | Stock | 151.6 | 151.67 | 151.6 | 151.61 | 8361.0 |
| 2022-07-18 07:15:00 | AAPL | Stock | 151.61 | 151.65 | 151.61 | 151.65 | 5608.0 |
| 2022-07-18 07:20:00 | AAPL | Stock | 151.65 | 151.7 | 151.65 | 151.7 | 4415.0 |
| 2022-07-18 07:25:00 | AAPL | Stock | 151.66 | 151.66 | 151.6 | 151.63 | 3723.0 |
| 2022-07-18 07:30:00 | AAPL | Stock | 151.63 | 151.63 | 151.58 | 151.58 | 5171.0 |
| 2022-07-18 07:35:00 | AAPL | Stock | 151.58 | 151.58 | 151.55 | 151.55 | 2909.0 |
| 2022-07-18 07:40:00 | AAPL | Stock | 151.55 | 151.55 | 151.46 | 151.47 | 14493.0 |
| 2022-07-18 07:45:00 | AAPL | Stock | 151.47 | 151.56 | 151.47 | 151.56 | 3759.0 |
| 2022-07-18 07:50:00 | AAPL | Stock | 151.56 | 151.6 | 151.51 | 151.51 | 10150.0 |
| 2022-07-18 07:55:00 | AAPL | Stock | 151.5 | 151.5 | 151.45 | 151.45 | 3442.0 |
| 2022-07-18 08:00:00 | AAPL | Stock | 151.5499 | 151.7 | 150.95 | 151.45 | 111465.0 |
| 2022-07-18 08:05:00 | AAPL | Stock | 151.48 | 151.55 | 151.46 | 151.5 | 10849.0 |
| 2022-07-18 08:10:00 | AAPL | Stock | 151.5 | 151.52 | 151.42 | 151.46 | 10394.0 |
| 2022-07-18 08:15:00 | AAPL | Stock | 151.45 | 151.45 | 151.2 | 151.25 | 24067.0 |
| 2022-07-18 08:20:00 | AAPL | Stock | 151.25 | 151.29 | 151.05 | 151.19 | 15923.0 |
| 2022-07-18 08:25:00 | AAPL | Stock | 151.2101 | 151.2101 | 150.96 | 150.99 | 25471.0 |
| 2022-07-18 08:30:00 | AAPL | Stock | 150.99 | 151.13 | 150.9699 | 151.12 | 29812.0 |
> showing 50 of 424,378 rows — these rows as CSV