PREVIEW / stock_5min / 2021-09-01
file: by_date/stock_5min/2021/2021-09-01.parquet size: 7.5 MB rows: 457,643 symbols: 2,781
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-09-01 04:00:00 | AAPL | Stock | 152.34 | 152.4 | 152.2 | 152.29 | 2413.0 |
| 2021-09-01 04:05:00 | AAPL | Stock | 152.31 | 152.31 | 152.12 | 152.12 | 1032.0 |
| 2021-09-01 04:10:00 | AAPL | Stock | 152.17 | 152.17 | 152.1 | 152.1 | 1408.0 |
| 2021-09-01 04:15:00 | AAPL | Stock | 152.0 | 152.0 | 151.93 | 151.93 | 1508.0 |
| 2021-09-01 04:20:00 | AAPL | Stock | 151.93 | 151.93 | 151.92 | 151.92 | 600.0 |
| 2021-09-01 04:30:00 | AAPL | Stock | 151.84 | 151.9 | 151.84 | 151.9 | 1430.0 |
| 2021-09-01 04:35:00 | AAPL | Stock | 151.9 | 152.07 | 151.9 | 151.91 | 1033.0 |
| 2021-09-01 04:40:00 | AAPL | Stock | 151.89 | 151.91 | 151.89 | 151.91 | 473.0 |
| 2021-09-01 04:45:00 | AAPL | Stock | 151.94 | 151.94 | 151.94 | 151.94 | 498.0 |
| 2021-09-01 05:00:00 | AAPL | Stock | 151.93 | 151.95 | 151.93 | 151.95 | 233.0 |
| 2021-09-01 05:05:00 | AAPL | Stock | 151.95 | 151.95 | 151.92 | 151.92 | 350.0 |
| 2021-09-01 05:20:00 | AAPL | Stock | 151.86 | 151.86 | 151.86 | 151.86 | 600.0 |
| 2021-09-01 05:25:00 | AAPL | Stock | 151.88 | 151.9 | 151.87 | 151.9 | 437.0 |
| 2021-09-01 05:35:00 | AAPL | Stock | 151.96 | 151.99 | 151.96 | 151.99 | 1325.0 |
| 2021-09-01 05:40:00 | AAPL | Stock | 151.99 | 151.99 | 151.99 | 151.99 | 289.0 |
| 2021-09-01 05:45:00 | AAPL | Stock | 151.99 | 151.99 | 151.99 | 151.99 | 200.0 |
| 2021-09-01 05:50:00 | AAPL | Stock | 151.99 | 152.0 | 151.99 | 152.0 | 2777.0 |
| 2021-09-01 06:10:00 | AAPL | Stock | 152.04 | 152.05 | 152.04 | 152.05 | 563.0 |
| 2021-09-01 06:15:00 | AAPL | Stock | 152.06 | 152.06 | 152.05 | 152.05 | 1077.0 |
| 2021-09-01 06:20:00 | AAPL | Stock | 152.08 | 152.09 | 152.08 | 152.09 | 804.0 |
| 2021-09-01 06:25:00 | AAPL | Stock | 152.05 | 152.11 | 152.05 | 152.11 | 797.0 |
| 2021-09-01 06:30:00 | AAPL | Stock | 152.14 | 152.18 | 152.14 | 152.18 | 1586.0 |
| 2021-09-01 06:35:00 | AAPL | Stock | 152.15 | 152.15 | 152.15 | 152.15 | 100.0 |
| 2021-09-01 06:40:00 | AAPL | Stock | 152.15 | 152.15 | 152.15 | 152.15 | 2073.0 |
| 2021-09-01 06:45:00 | AAPL | Stock | 152.15 | 152.25 | 152.15 | 152.25 | 1731.0 |
| 2021-09-01 06:50:00 | AAPL | Stock | 152.25 | 152.25 | 152.25 | 152.25 | 1029.0 |
| 2021-09-01 06:55:00 | AAPL | Stock | 152.25 | 152.26 | 152.2 | 152.26 | 1097.0 |
| 2021-09-01 07:00:00 | AAPL | Stock | 152.25 | 152.25 | 152.11 | 152.12 | 16745.0 |
| 2021-09-01 07:05:00 | AAPL | Stock | 152.11 | 152.11 | 152.07 | 152.08 | 9444.0 |
| 2021-09-01 07:10:00 | AAPL | Stock | 152.07 | 152.3 | 152.07 | 152.29 | 11787.0 |
| 2021-09-01 07:15:00 | AAPL | Stock | 152.27 | 152.5 | 152.2 | 152.5 | 39524.0 |
| 2021-09-01 07:20:00 | AAPL | Stock | 152.45 | 152.55 | 152.43 | 152.51 | 8374.0 |
| 2021-09-01 07:25:00 | AAPL | Stock | 152.499 | 152.53 | 152.45 | 152.52 | 6863.0 |
| 2021-09-01 07:30:00 | AAPL | Stock | 152.49 | 152.54 | 152.42 | 152.53 | 4791.0 |
| 2021-09-01 07:35:00 | AAPL | Stock | 152.53 | 152.59 | 152.47 | 152.52 | 8752.0 |
| 2021-09-01 07:40:00 | AAPL | Stock | 152.51 | 152.52 | 152.45 | 152.47 | 3010.0 |
| 2021-09-01 07:45:00 | AAPL | Stock | 152.46 | 152.49 | 152.44 | 152.46 | 3739.0 |
| 2021-09-01 07:50:00 | AAPL | Stock | 152.45 | 152.51 | 152.389 | 152.5 | 18192.0 |
| 2021-09-01 07:55:00 | AAPL | Stock | 152.5 | 152.59 | 152.5 | 152.53 | 12887.0 |
| 2021-09-01 08:00:00 | AAPL | Stock | 152.4302 | 152.57 | 151.451 | 152.53 | 182558.0 |
| 2021-09-01 08:05:00 | AAPL | Stock | 152.53 | 152.61 | 152.53 | 152.61 | 22421.0 |
| 2021-09-01 08:10:00 | AAPL | Stock | 152.62 | 152.62 | 152.57 | 152.62 | 6535.0 |
| 2021-09-01 08:15:00 | AAPL | Stock | 152.62 | 152.68 | 152.56 | 152.64 | 63632.0 |
| 2021-09-01 08:20:00 | AAPL | Stock | 152.635 | 152.64 | 152.5 | 152.57 | 26891.0 |
| 2021-09-01 08:25:00 | AAPL | Stock | 152.57 | 152.57 | 152.53 | 152.55 | 10075.0 |
| 2021-09-01 08:30:00 | AAPL | Stock | 152.56 | 152.67 | 152.55 | 152.56 | 29566.0 |
| 2021-09-01 08:35:00 | AAPL | Stock | 152.58 | 152.64 | 152.56 | 152.64 | 14324.0 |
| 2021-09-01 08:40:00 | AAPL | Stock | 152.65 | 152.66 | 152.52 | 152.58 | 26737.0 |
| 2021-09-01 08:45:00 | AAPL | Stock | 152.56 | 152.56 | 152.45 | 152.46 | 30525.0 |
| 2021-09-01 08:50:00 | AAPL | Stock | 152.46 | 152.5 | 152.38 | 152.47 | 23573.0 |
> showing 50 of 457,643 rows — these rows as CSV