PREVIEW / stock_5min / 2020-09-16
file: by_date/stock_5min/2020/2020-09-16.parquet size: 6.5 MB rows: 408,293 symbols: 2,484
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 |
|---|---|---|---|---|---|---|---|
| 2020-09-16 04:00:00 | AAPL | Stock | 115.51 | 115.9 | 115.25 | 115.25 | 12733.0 |
| 2020-09-16 04:05:00 | AAPL | Stock | 115.44 | 116.15 | 115.44 | 116.07 | 11394.0 |
| 2020-09-16 04:10:00 | AAPL | Stock | 116.1 | 116.24 | 116.0 | 116.03 | 7932.0 |
| 2020-09-16 04:15:00 | AAPL | Stock | 116.1 | 116.12 | 116.05 | 116.1 | 2534.0 |
| 2020-09-16 04:20:00 | AAPL | Stock | 116.13 | 116.24 | 116.1 | 116.2 | 4064.0 |
| 2020-09-16 04:25:00 | AAPL | Stock | 116.24 | 116.3 | 116.1 | 116.11 | 6100.0 |
| 2020-09-16 04:30:00 | AAPL | Stock | 116.11 | 116.15 | 116.05 | 116.13 | 6155.0 |
| 2020-09-16 04:35:00 | AAPL | Stock | 116.13 | 116.13 | 116.06 | 116.08 | 1151.0 |
| 2020-09-16 04:40:00 | AAPL | Stock | 116.1 | 116.2 | 116.1 | 116.2 | 4048.0 |
| 2020-09-16 04:45:00 | AAPL | Stock | 116.15 | 116.16 | 116.12 | 116.14 | 2885.0 |
| 2020-09-16 04:50:00 | AAPL | Stock | 116.12 | 116.12 | 115.97 | 116.01 | 22703.0 |
| 2020-09-16 04:55:00 | AAPL | Stock | 116.05 | 116.11 | 116.0 | 116.0 | 3116.0 |
| 2020-09-16 05:00:00 | AAPL | Stock | 116.08 | 116.36 | 116.08 | 116.12 | 7235.0 |
| 2020-09-16 05:05:00 | AAPL | Stock | 116.14 | 116.2 | 116.14 | 116.2 | 2179.0 |
| 2020-09-16 05:10:00 | AAPL | Stock | 116.21 | 116.42 | 116.21 | 116.42 | 3025.0 |
| 2020-09-16 05:15:00 | AAPL | Stock | 116.35 | 116.5 | 116.22 | 116.22 | 5538.0 |
| 2020-09-16 05:20:00 | AAPL | Stock | 116.34 | 116.4 | 116.34 | 116.4 | 1090.0 |
| 2020-09-16 05:25:00 | AAPL | Stock | 116.43 | 116.45 | 116.4 | 116.4 | 3217.0 |
| 2020-09-16 05:30:00 | AAPL | Stock | 116.4 | 116.4 | 116.3 | 116.3 | 2759.0 |
| 2020-09-16 05:35:00 | AAPL | Stock | 116.3 | 116.35 | 116.25 | 116.35 | 4436.0 |
| 2020-09-16 05:40:00 | AAPL | Stock | 116.38 | 116.5 | 116.37 | 116.4 | 5302.0 |
| 2020-09-16 05:45:00 | AAPL | Stock | 116.27 | 116.36 | 116.27 | 116.36 | 1982.0 |
| 2020-09-16 05:50:00 | AAPL | Stock | 116.1 | 116.35 | 116.1 | 116.22 | 3554.0 |
| 2020-09-16 05:55:00 | AAPL | Stock | 116.18 | 116.18 | 116.1 | 116.18 | 520.0 |
| 2020-09-16 06:00:00 | AAPL | Stock | 116.18 | 116.24 | 116.07 | 116.18 | 2854.0 |
| 2020-09-16 06:05:00 | AAPL | Stock | 116.05 | 116.05 | 115.6 | 115.95 | 7732.0 |
| 2020-09-16 06:10:00 | AAPL | Stock | 115.95 | 115.95 | 115.9 | 115.95 | 1058.0 |
| 2020-09-16 06:15:00 | AAPL | Stock | 115.92 | 115.92 | 115.85 | 115.88 | 500.0 |
| 2020-09-16 06:20:00 | AAPL | Stock | 115.9 | 115.95 | 115.9 | 115.91 | 6738.0 |
| 2020-09-16 06:25:00 | AAPL | Stock | 115.9 | 116.0 | 115.9 | 115.98 | 3323.0 |
| 2020-09-16 06:30:00 | AAPL | Stock | 115.98 | 116.18 | 115.98 | 116.05 | 3224.0 |
| 2020-09-16 06:35:00 | AAPL | Stock | 116.1 | 116.4 | 116.1 | 116.4 | 5382.0 |
| 2020-09-16 06:40:00 | AAPL | Stock | 116.38 | 116.44 | 116.35 | 116.43 | 5254.0 |
| 2020-09-16 06:45:00 | AAPL | Stock | 116.36 | 116.45 | 116.3 | 116.45 | 3982.0 |
| 2020-09-16 06:50:00 | AAPL | Stock | 116.45 | 116.64 | 116.33 | 116.54 | 11439.0 |
| 2020-09-16 06:55:00 | AAPL | Stock | 116.58 | 116.58 | 116.3 | 116.39 | 6392.0 |
| 2020-09-16 07:00:00 | AAPL | Stock | 116.33 | 116.35 | 115.65 | 115.8 | 131767.0 |
| 2020-09-16 07:05:00 | AAPL | Stock | 115.8 | 115.86 | 115.5 | 115.7 | 47263.0 |
| 2020-09-16 07:10:00 | AAPL | Stock | 115.73 | 115.88 | 115.47 | 115.67 | 54368.0 |
| 2020-09-16 07:15:00 | AAPL | Stock | 115.67 | 115.67 | 115.21 | 115.43 | 45033.0 |
| 2020-09-16 07:20:00 | AAPL | Stock | 115.36 | 115.54 | 115.03 | 115.16 | 73384.0 |
| 2020-09-16 07:25:00 | AAPL | Stock | 115.19 | 115.5 | 115.15 | 115.15 | 50040.0 |
| 2020-09-16 07:30:00 | AAPL | Stock | 115.14 | 115.35 | 115.1 | 115.31 | 21401.0 |
| 2020-09-16 07:35:00 | AAPL | Stock | 115.3 | 115.31 | 114.88 | 115.13 | 66066.0 |
| 2020-09-16 07:40:00 | AAPL | Stock | 115.15 | 115.4 | 114.88 | 115.38 | 46950.0 |
| 2020-09-16 07:45:00 | AAPL | Stock | 115.33 | 115.47 | 115.23 | 115.43 | 29024.0 |
| 2020-09-16 07:50:00 | AAPL | Stock | 115.4 | 115.48 | 115.331 | 115.39 | 24321.0 |
| 2020-09-16 07:55:00 | AAPL | Stock | 115.37 | 115.6 | 115.19 | 115.6 | 42290.0 |
| 2020-09-16 08:00:00 | AAPL | Stock | 115.61 | 116.21 | 114.88 | 115.4 | 367141.0 |
| 2020-09-16 08:05:00 | AAPL | Stock | 115.4 | 115.6 | 115.38 | 115.56 | 41727.0 |
> showing 50 of 408,293 rows — these rows as CSV