PREVIEW / stock_5min / 2021-05-12
file: by_date/stock_5min/2021/2021-05-12.parquet size: 7.8 MB rows: 480,095 symbols: 2,981
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-05-12 04:00:00 | AAPL | Stock | 125.71 | 125.71 | 125.58 | 125.6 | 1979.0 |
| 2021-05-12 04:05:00 | AAPL | Stock | 125.58 | 125.58 | 125.25 | 125.35 | 1601.0 |
| 2021-05-12 04:10:00 | AAPL | Stock | 125.37 | 125.52 | 125.3 | 125.3 | 1415.0 |
| 2021-05-12 04:15:00 | AAPL | Stock | 125.22 | 125.24 | 125.2 | 125.2 | 703.0 |
| 2021-05-12 04:20:00 | AAPL | Stock | 125.2 | 125.28 | 125.14 | 125.14 | 879.0 |
| 2021-05-12 04:25:00 | AAPL | Stock | 125.14 | 125.21 | 125.05 | 125.05 | 2013.0 |
| 2021-05-12 04:30:00 | AAPL | Stock | 125.3 | 125.33 | 125.3 | 125.33 | 1100.0 |
| 2021-05-12 04:35:00 | AAPL | Stock | 125.34 | 125.34 | 125.34 | 125.34 | 351.0 |
| 2021-05-12 04:40:00 | AAPL | Stock | 125.33 | 125.33 | 125.06 | 125.27 | 549.0 |
| 2021-05-12 04:45:00 | AAPL | Stock | 125.27 | 125.27 | 125.27 | 125.27 | 483.0 |
| 2021-05-12 04:50:00 | AAPL | Stock | 125.17 | 125.17 | 125.17 | 125.17 | 396.0 |
| 2021-05-12 04:55:00 | AAPL | Stock | 125.22 | 125.22 | 125.2 | 125.2 | 594.0 |
| 2021-05-12 05:05:00 | AAPL | Stock | 125.23 | 125.23 | 125.23 | 125.23 | 396.0 |
| 2021-05-12 05:10:00 | AAPL | Stock | 125.23 | 125.28 | 125.23 | 125.28 | 4481.0 |
| 2021-05-12 05:15:00 | AAPL | Stock | 125.34 | 125.4 | 125.34 | 125.38 | 321.0 |
| 2021-05-12 05:20:00 | AAPL | Stock | 125.38 | 125.4 | 125.33 | 125.33 | 1992.0 |
| 2021-05-12 05:30:00 | AAPL | Stock | 125.34 | 125.34 | 125.23 | 125.23 | 2877.0 |
| 2021-05-12 05:35:00 | AAPL | Stock | 125.21 | 125.21 | 124.9 | 125.0 | 14000.0 |
| 2021-05-12 05:40:00 | AAPL | Stock | 125.0 | 125.0 | 124.83 | 124.83 | 1151.0 |
| 2021-05-12 05:45:00 | AAPL | Stock | 125.0 | 125.04 | 124.92 | 124.98 | 1624.0 |
| 2021-05-12 05:50:00 | AAPL | Stock | 124.97 | 125.06 | 124.97 | 125.06 | 1547.0 |
| 2021-05-12 05:55:00 | AAPL | Stock | 125.13 | 125.13 | 125.13 | 125.13 | 100.0 |
| 2021-05-12 06:00:00 | AAPL | Stock | 125.13 | 125.13 | 125.12 | 125.12 | 356.0 |
| 2021-05-12 06:05:00 | AAPL | Stock | 125.14 | 125.21 | 125.08 | 125.21 | 1703.0 |
| 2021-05-12 06:15:00 | AAPL | Stock | 125.38 | 125.38 | 125.3 | 125.3 | 1283.0 |
| 2021-05-12 06:25:00 | AAPL | Stock | 125.2 | 125.2 | 125.12 | 125.12 | 1063.0 |
| 2021-05-12 06:30:00 | AAPL | Stock | 125.29 | 125.3 | 125.28 | 125.29 | 1449.0 |
| 2021-05-12 06:40:00 | AAPL | Stock | 125.35 | 125.39 | 125.35 | 125.39 | 1227.0 |
| 2021-05-12 06:45:00 | AAPL | Stock | 125.22 | 125.26 | 125.12 | 125.13 | 4260.0 |
| 2021-05-12 06:50:00 | AAPL | Stock | 125.12 | 125.12 | 124.71 | 125.0 | 8827.0 |
| 2021-05-12 06:55:00 | AAPL | Stock | 125.0 | 125.0 | 125.0 | 125.0 | 663.0 |
| 2021-05-12 07:00:00 | AAPL | Stock | 124.92 | 125.1 | 124.89 | 125.05 | 15583.0 |
| 2021-05-12 07:05:00 | AAPL | Stock | 125.05 | 125.12 | 125.05 | 125.06 | 11796.0 |
| 2021-05-12 07:10:00 | AAPL | Stock | 125.08 | 125.13 | 125.06 | 125.13 | 5403.0 |
| 2021-05-12 07:15:00 | AAPL | Stock | 125.12 | 125.21 | 124.98 | 125.07 | 21775.0 |
| 2021-05-12 07:20:00 | AAPL | Stock | 125.05 | 125.21 | 125.05 | 125.13 | 4352.0 |
| 2021-05-12 07:25:00 | AAPL | Stock | 125.13 | 125.14 | 125.09 | 125.13 | 4388.0 |
| 2021-05-12 07:30:00 | AAPL | Stock | 125.13 | 125.16 | 125.05 | 125.05 | 3366.0 |
| 2021-05-12 07:35:00 | AAPL | Stock | 125.09 | 125.16 | 125.0 | 125.0 | 9372.0 |
| 2021-05-12 07:40:00 | AAPL | Stock | 125.0 | 125.07 | 125.0 | 125.06 | 9206.0 |
| 2021-05-12 07:45:00 | AAPL | Stock | 125.05 | 125.22 | 125.0 | 125.17 | 7765.0 |
| 2021-05-12 07:50:00 | AAPL | Stock | 125.11 | 125.11 | 125.09 | 125.1 | 1102.0 |
| 2021-05-12 07:55:00 | AAPL | Stock | 125.1 | 125.25 | 125.1 | 125.19 | 14255.0 |
| 2021-05-12 08:00:00 | AAPL | Stock | 125.035 | 125.26 | 124.92 | 125.19 | 58889.0 |
| 2021-05-12 08:05:00 | AAPL | Stock | 125.2 | 125.21 | 125.13 | 125.14 | 13724.0 |
| 2021-05-12 08:10:00 | AAPL | Stock | 125.16 | 125.38 | 125.16 | 125.33 | 15212.0 |
| 2021-05-12 08:15:00 | AAPL | Stock | 125.34 | 125.5 | 125.24 | 125.32 | 22593.0 |
| 2021-05-12 08:20:00 | AAPL | Stock | 125.29 | 125.45 | 125.23 | 125.23 | 10051.0 |
| 2021-05-12 08:25:00 | AAPL | Stock | 125.25 | 125.34 | 125.01 | 125.04 | 20978.0 |
| 2021-05-12 08:30:00 | AAPL | Stock | 125.04 | 125.04 | 123.77 | 124.25 | 177668.0 |
> showing 50 of 480,095 rows — these rows as CSV