PREVIEW / stock_5min / 2020-07-15
file: by_date/stock_5min/2020/2020-07-15.parquet size: 6.7 MB rows: 426,271 symbols: 2,454
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-07-15 04:00:00 | AAPL | Stock | 97.6 | 97.6 | 97.185 | 97.21 | 10788.0 |
| 2020-07-15 04:05:00 | AAPL | Stock | 97.2475 | 97.25 | 97.2475 | 97.2475 | 4296.0 |
| 2020-07-15 04:10:00 | AAPL | Stock | 97.2975 | 97.355 | 97.2975 | 97.355 | 1104.0 |
| 2020-07-15 04:15:00 | AAPL | Stock | 97.35 | 97.35 | 97.35 | 97.35 | 1356.0 |
| 2020-07-15 04:20:00 | AAPL | Stock | 97.3875 | 97.4 | 97.3875 | 97.4 | 1240.0 |
| 2020-07-15 04:25:00 | AAPL | Stock | 97.4 | 97.4 | 97.375 | 97.375 | 4804.0 |
| 2020-07-15 04:35:00 | AAPL | Stock | 97.475 | 97.5025 | 97.475 | 97.5 | 2000.0 |
| 2020-07-15 04:50:00 | AAPL | Stock | 97.48 | 97.4875 | 97.48 | 97.4875 | 900.0 |
| 2020-07-15 04:55:00 | AAPL | Stock | 97.4375 | 97.4375 | 97.43 | 97.43 | 1200.0 |
| 2020-07-15 05:00:00 | AAPL | Stock | 97.425 | 97.735 | 97.425 | 97.7325 | 20180.0 |
| 2020-07-15 05:05:00 | AAPL | Stock | 97.735 | 97.8525 | 97.735 | 97.8525 | 18384.0 |
| 2020-07-15 05:10:00 | AAPL | Stock | 97.8725 | 97.93 | 97.85 | 97.85 | 11248.0 |
| 2020-07-15 05:15:00 | AAPL | Stock | 97.8 | 97.905 | 97.555 | 97.875 | 17576.0 |
| 2020-07-15 05:20:00 | AAPL | Stock | 97.905 | 98.2125 | 97.905 | 98.2125 | 18032.0 |
| 2020-07-15 05:25:00 | AAPL | Stock | 98.1275 | 98.375 | 98.125 | 98.375 | 20012.0 |
| 2020-07-15 05:30:00 | AAPL | Stock | 98.38 | 98.565 | 98.38 | 98.4675 | 11536.0 |
| 2020-07-15 05:35:00 | AAPL | Stock | 98.44 | 98.44 | 98.34 | 98.4 | 16880.0 |
| 2020-07-15 05:40:00 | AAPL | Stock | 98.3725 | 98.42 | 98.255 | 98.255 | 20660.0 |
| 2020-07-15 05:45:00 | AAPL | Stock | 98.25 | 98.28 | 98.1275 | 98.28 | 8188.0 |
| 2020-07-15 05:50:00 | AAPL | Stock | 98.2975 | 98.3 | 98.1325 | 98.2575 | 14104.0 |
| 2020-07-15 05:55:00 | AAPL | Stock | 98.325 | 98.325 | 98.1825 | 98.25 | 7456.0 |
| 2020-07-15 06:00:00 | AAPL | Stock | 98.225 | 98.225 | 98.225 | 98.225 | 644.0 |
| 2020-07-15 06:05:00 | AAPL | Stock | 98.18 | 98.225 | 98.18 | 98.225 | 5280.0 |
| 2020-07-15 06:10:00 | AAPL | Stock | 98.2425 | 98.4175 | 98.2425 | 98.4 | 5760.0 |
| 2020-07-15 06:15:00 | AAPL | Stock | 98.39 | 98.4825 | 98.39 | 98.4575 | 5716.0 |
| 2020-07-15 06:20:00 | AAPL | Stock | 98.5275 | 98.71 | 98.5275 | 98.71 | 9824.0 |
| 2020-07-15 06:25:00 | AAPL | Stock | 98.5825 | 98.695 | 98.5825 | 98.63 | 1840.0 |
| 2020-07-15 06:30:00 | AAPL | Stock | 98.675 | 98.7175 | 98.675 | 98.7075 | 2160.0 |
| 2020-07-15 06:35:00 | AAPL | Stock | 98.6225 | 98.65 | 98.5275 | 98.5275 | 6376.0 |
| 2020-07-15 06:40:00 | AAPL | Stock | 98.5775 | 98.5775 | 98.505 | 98.5725 | 4224.0 |
| 2020-07-15 06:45:00 | AAPL | Stock | 98.6225 | 98.6225 | 98.6225 | 98.6225 | 1176.0 |
| 2020-07-15 06:50:00 | AAPL | Stock | 98.6975 | 98.7 | 98.695 | 98.7 | 4316.0 |
| 2020-07-15 06:55:00 | AAPL | Stock | 98.7 | 98.73 | 98.69 | 98.725 | 15672.0 |
| 2020-07-15 07:00:00 | AAPL | Stock | 98.7275 | 99.375 | 98.6675 | 99.3675 | 141852.0 |
| 2020-07-15 07:05:00 | AAPL | Stock | 99.325 | 99.47 | 99.29 | 99.4 | 131080.0 |
| 2020-07-15 07:10:00 | AAPL | Stock | 99.375 | 99.375 | 99.015 | 99.015 | 43980.0 |
| 2020-07-15 07:15:00 | AAPL | Stock | 99.095 | 99.095 | 98.9525 | 98.975 | 43768.0 |
| 2020-07-15 07:20:00 | AAPL | Stock | 98.9875 | 99.0075 | 98.925 | 98.95 | 30368.0 |
| 2020-07-15 07:25:00 | AAPL | Stock | 98.93 | 99.01 | 98.75 | 98.85 | 36796.0 |
| 2020-07-15 07:30:00 | AAPL | Stock | 98.875 | 98.925 | 98.75 | 98.75 | 38952.0 |
| 2020-07-15 07:35:00 | AAPL | Stock | 98.725 | 98.725 | 98.475 | 98.5975 | 64004.0 |
| 2020-07-15 07:40:00 | AAPL | Stock | 98.615 | 98.64 | 98.525 | 98.64 | 19520.0 |
| 2020-07-15 07:45:00 | AAPL | Stock | 98.6475 | 98.6475 | 98.5 | 98.5 | 52476.0 |
| 2020-07-15 07:50:00 | AAPL | Stock | 98.5 | 98.625 | 98.375 | 98.4975 | 55996.0 |
| 2020-07-15 07:55:00 | AAPL | Stock | 98.475 | 98.475 | 98.25 | 98.39 | 41756.0 |
| 2020-07-15 08:00:00 | AAPL | Stock | 99.1225 | 99.475 | 98.256 | 98.35 | 359756.0 |
| 2020-07-15 08:05:00 | AAPL | Stock | 98.3725 | 98.45 | 98.25 | 98.275 | 219460.0 |
| 2020-07-15 08:10:00 | AAPL | Stock | 98.275 | 98.5 | 98.255 | 98.475 | 58132.0 |
| 2020-07-15 08:15:00 | AAPL | Stock | 98.475 | 98.725 | 98.475 | 98.5688 | 98412.0 |
| 2020-07-15 08:20:00 | AAPL | Stock | 98.6 | 98.85 | 98.55 | 98.8 | 168744.0 |
> showing 50 of 426,271 rows — these rows as CSV