PREVIEW / stock_5min / 2021-11-08
file: by_date/stock_5min/2021/2021-11-08.parquet size: 7.8 MB rows: 481,862 symbols: 2,708
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-11-08 04:00:00 | AAPL | Stock | 151.08 | 151.35 | 151.08 | 151.3 | 10771.0 |
| 2021-11-08 04:05:00 | AAPL | Stock | 151.28 | 151.3 | 151.24 | 151.24 | 813.0 |
| 2021-11-08 04:10:00 | AAPL | Stock | 151.2 | 151.3 | 151.19 | 151.26 | 694.0 |
| 2021-11-08 04:15:00 | AAPL | Stock | 151.26 | 151.26 | 151.25 | 151.25 | 1826.0 |
| 2021-11-08 04:20:00 | AAPL | Stock | 151.24 | 151.26 | 151.24 | 151.25 | 530.0 |
| 2021-11-08 04:30:00 | AAPL | Stock | 151.2 | 151.2 | 151.2 | 151.2 | 371.0 |
| 2021-11-08 04:35:00 | AAPL | Stock | 151.25 | 151.25 | 151.2 | 151.2 | 1595.0 |
| 2021-11-08 04:40:00 | AAPL | Stock | 151.15 | 151.15 | 151.15 | 151.15 | 265.0 |
| 2021-11-08 04:45:00 | AAPL | Stock | 151.12 | 151.12 | 151.1 | 151.1 | 1409.0 |
| 2021-11-08 04:50:00 | AAPL | Stock | 151.13 | 151.13 | 151.12 | 151.12 | 254.0 |
| 2021-11-08 05:00:00 | AAPL | Stock | 151.14 | 151.2 | 151.14 | 151.2 | 793.0 |
| 2021-11-08 05:05:00 | AAPL | Stock | 151.21 | 151.21 | 151.21 | 151.21 | 419.0 |
| 2021-11-08 05:15:00 | AAPL | Stock | 151.27 | 151.34 | 151.27 | 151.34 | 2645.0 |
| 2021-11-08 05:20:00 | AAPL | Stock | 151.3 | 151.3 | 151.3 | 151.3 | 500.0 |
| 2021-11-08 05:25:00 | AAPL | Stock | 151.32 | 151.35 | 151.32 | 151.35 | 370.0 |
| 2021-11-08 05:30:00 | AAPL | Stock | 151.38 | 151.38 | 151.38 | 151.38 | 438.0 |
| 2021-11-08 05:35:00 | AAPL | Stock | 151.34 | 151.34 | 151.34 | 151.34 | 220.0 |
| 2021-11-08 05:45:00 | AAPL | Stock | 151.3 | 151.3 | 151.29 | 151.29 | 1166.0 |
| 2021-11-08 05:55:00 | AAPL | Stock | 151.28 | 151.28 | 151.28 | 151.28 | 197.0 |
| 2021-11-08 06:10:00 | AAPL | Stock | 151.32 | 151.34 | 151.32 | 151.34 | 693.0 |
| 2021-11-08 06:15:00 | AAPL | Stock | 151.33 | 151.33 | 151.33 | 151.33 | 296.0 |
| 2021-11-08 06:20:00 | AAPL | Stock | 151.36 | 151.36 | 151.35 | 151.35 | 469.0 |
| 2021-11-08 06:30:00 | AAPL | Stock | 151.35 | 151.35 | 151.35 | 151.35 | 1519.0 |
| 2021-11-08 06:35:00 | AAPL | Stock | 151.35 | 151.38 | 151.35 | 151.38 | 3535.0 |
| 2021-11-08 06:40:00 | AAPL | Stock | 151.4 | 151.55 | 151.3 | 151.55 | 3290.0 |
| 2021-11-08 06:45:00 | AAPL | Stock | 151.55 | 151.57 | 151.55 | 151.57 | 438.0 |
| 2021-11-08 06:50:00 | AAPL | Stock | 151.56 | 151.58 | 151.55 | 151.57 | 5622.0 |
| 2021-11-08 07:00:00 | AAPL | Stock | 151.47 | 151.47 | 151.28 | 151.4 | 6401.0 |
| 2021-11-08 07:05:00 | AAPL | Stock | 151.42 | 151.5 | 151.31 | 151.31 | 7702.0 |
| 2021-11-08 07:10:00 | AAPL | Stock | 151.31 | 151.36 | 151.31 | 151.36 | 10106.0 |
| 2021-11-08 07:15:00 | AAPL | Stock | 151.4 | 151.49 | 151.39 | 151.49 | 9872.0 |
| 2021-11-08 07:20:00 | AAPL | Stock | 151.49 | 151.63 | 151.49 | 151.56 | 5529.0 |
| 2021-11-08 07:25:00 | AAPL | Stock | 151.54 | 151.59 | 151.5 | 151.55 | 8454.0 |
| 2021-11-08 07:30:00 | AAPL | Stock | 151.55 | 151.59 | 151.55 | 151.55 | 3381.0 |
| 2021-11-08 07:35:00 | AAPL | Stock | 151.55 | 151.55 | 151.5 | 151.52 | 1825.0 |
| 2021-11-08 07:40:00 | AAPL | Stock | 151.52 | 151.52 | 151.43 | 151.45 | 4464.0 |
| 2021-11-08 07:45:00 | AAPL | Stock | 151.45 | 151.47 | 151.35 | 151.36 | 14843.0 |
| 2021-11-08 07:50:00 | AAPL | Stock | 151.36 | 151.36 | 151.31 | 151.33 | 5654.0 |
| 2021-11-08 07:55:00 | AAPL | Stock | 151.33 | 151.34 | 151.3 | 151.31 | 6977.0 |
| 2021-11-08 08:00:00 | AAPL | Stock | 151.44 | 151.61 | 150.902 | 151.35 | 58773.0 |
| 2021-11-08 08:05:00 | AAPL | Stock | 151.35 | 151.35 | 151.31 | 151.32 | 10444.0 |
| 2021-11-08 08:10:00 | AAPL | Stock | 151.34 | 151.35 | 151.31 | 151.31 | 2890.0 |
| 2021-11-08 08:15:00 | AAPL | Stock | 151.34 | 151.37 | 151.28 | 151.29 | 17669.0 |
| 2021-11-08 08:20:00 | AAPL | Stock | 151.29 | 151.35 | 151.28 | 151.33 | 4739.0 |
| 2021-11-08 08:25:00 | AAPL | Stock | 151.32 | 151.37 | 151.3 | 151.35 | 10284.0 |
| 2021-11-08 08:30:00 | AAPL | Stock | 151.35 | 151.35 | 151.26 | 151.26 | 12629.0 |
| 2021-11-08 08:35:00 | AAPL | Stock | 151.27 | 151.3 | 151.27 | 151.29 | 7896.0 |
| 2021-11-08 08:40:00 | AAPL | Stock | 151.28 | 151.28 | 151.21 | 151.25 | 17103.0 |
| 2021-11-08 08:45:00 | AAPL | Stock | 151.24 | 151.24 | 151.12 | 151.16 | 15568.0 |
| 2021-11-08 08:50:00 | AAPL | Stock | 151.18 | 151.19 | 151.17 | 151.17 | 7746.0 |
> showing 50 of 481,862 rows — these rows as CSV