PREVIEW / stock_5min / 2021-02-18
file: by_date/stock_5min/2021/2021-02-18.parquet size: 8.2 MB rows: 514,310 symbols: 2,827
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-02-18 04:00:00 | AAPL | Stock | 130.5 | 130.5 | 130.0 | 130.0 | 8061.0 |
| 2021-02-18 04:05:00 | AAPL | Stock | 130.01 | 130.05 | 129.98 | 130.0 | 2097.0 |
| 2021-02-18 04:10:00 | AAPL | Stock | 130.0 | 130.0 | 129.98 | 129.98 | 2950.0 |
| 2021-02-18 04:15:00 | AAPL | Stock | 129.94 | 130.0 | 129.94 | 129.97 | 1419.0 |
| 2021-02-18 04:20:00 | AAPL | Stock | 130.0 | 130.01 | 129.97 | 130.01 | 2228.0 |
| 2021-02-18 04:25:00 | AAPL | Stock | 129.97 | 129.97 | 129.87 | 129.87 | 2290.0 |
| 2021-02-18 04:30:00 | AAPL | Stock | 129.88 | 129.92 | 129.87 | 129.87 | 1262.0 |
| 2021-02-18 04:35:00 | AAPL | Stock | 129.87 | 129.91 | 129.84 | 129.9 | 4044.0 |
| 2021-02-18 04:40:00 | AAPL | Stock | 129.89 | 129.9 | 129.85 | 129.85 | 915.0 |
| 2021-02-18 04:45:00 | AAPL | Stock | 129.86 | 129.88 | 129.85 | 129.88 | 356.0 |
| 2021-02-18 04:50:00 | AAPL | Stock | 129.9 | 129.94 | 129.88 | 129.94 | 4103.0 |
| 2021-02-18 04:55:00 | AAPL | Stock | 129.9 | 129.9 | 129.9 | 129.9 | 100.0 |
| 2021-02-18 05:00:00 | AAPL | Stock | 129.9 | 129.92 | 129.9 | 129.92 | 503.0 |
| 2021-02-18 05:05:00 | AAPL | Stock | 129.9 | 129.9 | 129.85 | 129.85 | 469.0 |
| 2021-02-18 05:10:00 | AAPL | Stock | 129.87 | 129.87 | 129.82 | 129.85 | 1610.0 |
| 2021-02-18 05:15:00 | AAPL | Stock | 129.85 | 129.9 | 129.85 | 129.9 | 922.0 |
| 2021-02-18 05:20:00 | AAPL | Stock | 129.9 | 129.9 | 129.9 | 129.9 | 260.0 |
| 2021-02-18 05:25:00 | AAPL | Stock | 129.8 | 129.8 | 129.75 | 129.75 | 2709.0 |
| 2021-02-18 05:30:00 | AAPL | Stock | 129.75 | 129.81 | 129.75 | 129.81 | 1101.0 |
| 2021-02-18 05:35:00 | AAPL | Stock | 129.81 | 129.85 | 129.81 | 129.84 | 797.0 |
| 2021-02-18 05:40:00 | AAPL | Stock | 129.95 | 130.02 | 129.9 | 129.99 | 14840.0 |
| 2021-02-18 05:45:00 | AAPL | Stock | 129.9 | 129.9 | 129.76 | 129.8 | 5805.0 |
| 2021-02-18 05:50:00 | AAPL | Stock | 129.8 | 129.8 | 129.8 | 129.8 | 2554.0 |
| 2021-02-18 05:55:00 | AAPL | Stock | 129.75 | 129.75 | 129.72 | 129.72 | 702.0 |
| 2021-02-18 06:00:00 | AAPL | Stock | 129.64 | 129.64 | 129.41 | 129.41 | 6011.0 |
| 2021-02-18 06:05:00 | AAPL | Stock | 129.42 | 129.5 | 129.25 | 129.25 | 16538.0 |
| 2021-02-18 06:10:00 | AAPL | Stock | 129.23 | 129.23 | 128.81 | 128.9 | 34782.0 |
| 2021-02-18 06:15:00 | AAPL | Stock | 128.9 | 129.07 | 128.89 | 129.01 | 25905.0 |
| 2021-02-18 06:20:00 | AAPL | Stock | 129.01 | 129.6 | 129.0 | 129.22 | 9484.0 |
| 2021-02-18 06:25:00 | AAPL | Stock | 129.17 | 129.18 | 128.91 | 128.96 | 3236.0 |
| 2021-02-18 06:30:00 | AAPL | Stock | 129.0 | 129.0 | 128.9 | 128.9 | 8263.0 |
| 2021-02-18 06:35:00 | AAPL | Stock | 128.94 | 129.08 | 128.9 | 129.03 | 5333.0 |
| 2021-02-18 06:40:00 | AAPL | Stock | 129.0 | 129.47 | 128.94 | 129.02 | 21309.0 |
| 2021-02-18 06:45:00 | AAPL | Stock | 129.0 | 129.21 | 129.0 | 129.12 | 4383.0 |
| 2021-02-18 06:50:00 | AAPL | Stock | 129.1 | 129.23 | 129.1 | 129.2 | 2612.0 |
| 2021-02-18 06:55:00 | AAPL | Stock | 129.26 | 129.26 | 129.24 | 129.26 | 1300.0 |
| 2021-02-18 07:00:00 | AAPL | Stock | 129.25 | 129.52 | 129.22 | 129.41 | 43087.0 |
| 2021-02-18 07:05:00 | AAPL | Stock | 129.42 | 129.42 | 129.25 | 129.26 | 21479.0 |
| 2021-02-18 07:10:00 | AAPL | Stock | 129.28 | 129.37 | 129.28 | 129.3 | 8636.0 |
| 2021-02-18 07:15:00 | AAPL | Stock | 129.35 | 129.36 | 129.2 | 129.25 | 10227.0 |
| 2021-02-18 07:20:00 | AAPL | Stock | 129.25 | 129.38 | 129.24 | 129.38 | 22592.0 |
| 2021-02-18 07:25:00 | AAPL | Stock | 129.37 | 129.49 | 129.34 | 129.49 | 17356.0 |
| 2021-02-18 07:30:00 | AAPL | Stock | 129.48 | 129.53 | 129.41 | 129.5 | 14470.0 |
| 2021-02-18 07:35:00 | AAPL | Stock | 129.529 | 129.6 | 129.51 | 129.54 | 6561.0 |
| 2021-02-18 07:40:00 | AAPL | Stock | 129.54 | 129.54 | 129.51 | 129.51 | 4216.0 |
| 2021-02-18 07:45:00 | AAPL | Stock | 129.51 | 129.51 | 129.35 | 129.4 | 15318.0 |
| 2021-02-18 07:50:00 | AAPL | Stock | 129.41 | 129.42 | 129.3 | 129.339 | 23226.0 |
| 2021-02-18 07:55:00 | AAPL | Stock | 129.34 | 129.38 | 129.33 | 129.38 | 6667.0 |
| 2021-02-18 08:00:00 | AAPL | Stock | 129.41 | 129.58 | 129.23 | 129.35 | 155827.0 |
| 2021-02-18 08:05:00 | AAPL | Stock | 129.35 | 129.35 | 129.18 | 129.28 | 65353.0 |
> showing 50 of 514,310 rows — these rows as CSV