PREVIEW / stock_5min / 2020-07-10
file: by_date/stock_5min/2020/2020-07-10.parquet size: 6.5 MB rows: 407,883 symbols: 2,448
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-10 04:00:00 | AAPL | Stock | 95.22 | 95.2825 | 95.22 | 95.2825 | 13844.0 |
| 2020-07-10 04:05:00 | AAPL | Stock | 95.3725 | 95.5 | 95.3725 | 95.5 | 1112.0 |
| 2020-07-10 04:10:00 | AAPL | Stock | 95.4 | 95.4 | 95.375 | 95.375 | 1276.0 |
| 2020-07-10 04:15:00 | AAPL | Stock | 95.3625 | 95.3625 | 95.3625 | 95.3625 | 440.0 |
| 2020-07-10 04:20:00 | AAPL | Stock | 95.35 | 95.35 | 95.35 | 95.35 | 400.0 |
| 2020-07-10 04:35:00 | AAPL | Stock | 95.25 | 95.26 | 95.25 | 95.26 | 3600.0 |
| 2020-07-10 04:45:00 | AAPL | Stock | 95.305 | 95.305 | 95.25 | 95.25 | 3728.0 |
| 2020-07-10 04:50:00 | AAPL | Stock | 95.205 | 95.225 | 95.18 | 95.195 | 2528.0 |
| 2020-07-10 05:00:00 | AAPL | Stock | 95.2425 | 95.25 | 95.2425 | 95.25 | 2456.0 |
| 2020-07-10 05:05:00 | AAPL | Stock | 95.245 | 95.2525 | 95.125 | 95.125 | 10928.0 |
| 2020-07-10 05:10:00 | AAPL | Stock | 95.14 | 95.14 | 95.075 | 95.075 | 6032.0 |
| 2020-07-10 05:15:00 | AAPL | Stock | 95.12 | 95.125 | 95.12 | 95.125 | 26568.0 |
| 2020-07-10 05:20:00 | AAPL | Stock | 95.1275 | 95.155 | 95.1275 | 95.155 | 1200.0 |
| 2020-07-10 05:40:00 | AAPL | Stock | 95.35 | 95.375 | 95.35 | 95.375 | 1200.0 |
| 2020-07-10 05:45:00 | AAPL | Stock | 95.3775 | 95.3775 | 95.3775 | 95.3775 | 432.0 |
| 2020-07-10 05:55:00 | AAPL | Stock | 95.4675 | 95.4675 | 95.4 | 95.4 | 2736.0 |
| 2020-07-10 06:05:00 | AAPL | Stock | 95.4525 | 95.4525 | 95.4125 | 95.4125 | 1200.0 |
| 2020-07-10 06:10:00 | AAPL | Stock | 95.4 | 95.4 | 95.4 | 95.4 | 1720.0 |
| 2020-07-10 06:15:00 | AAPL | Stock | 95.4 | 95.4 | 95.35 | 95.35 | 3384.0 |
| 2020-07-10 06:20:00 | AAPL | Stock | 95.3475 | 95.3475 | 95.3 | 95.3 | 800.0 |
| 2020-07-10 07:00:00 | AAPL | Stock | 95.485 | 95.49 | 95.4025 | 95.455 | 21536.0 |
| 2020-07-10 07:05:00 | AAPL | Stock | 95.4475 | 95.525 | 95.4475 | 95.4925 | 21608.0 |
| 2020-07-10 07:10:00 | AAPL | Stock | 95.4975 | 95.525 | 95.465 | 95.5 | 8520.0 |
| 2020-07-10 07:15:00 | AAPL | Stock | 95.525 | 95.5425 | 95.4625 | 95.4925 | 25712.0 |
| 2020-07-10 07:20:00 | AAPL | Stock | 95.47 | 95.4825 | 95.4375 | 95.4375 | 16532.0 |
| 2020-07-10 07:25:00 | AAPL | Stock | 95.4925 | 95.5 | 95.405 | 95.405 | 21156.0 |
| 2020-07-10 07:30:00 | AAPL | Stock | 95.39 | 95.4025 | 95.355 | 95.355 | 13848.0 |
| 2020-07-10 07:35:00 | AAPL | Stock | 95.37 | 95.37 | 95.3125 | 95.325 | 22852.0 |
| 2020-07-10 07:40:00 | AAPL | Stock | 95.35 | 95.4 | 95.35 | 95.375 | 3796.0 |
| 2020-07-10 07:45:00 | AAPL | Stock | 95.3675 | 95.3675 | 95.25 | 95.2575 | 23008.0 |
| 2020-07-10 07:50:00 | AAPL | Stock | 95.2625 | 95.2975 | 95.2625 | 95.2725 | 3976.0 |
| 2020-07-10 07:55:00 | AAPL | Stock | 95.25 | 95.3025 | 95.25 | 95.2975 | 12776.0 |
| 2020-07-10 08:00:00 | AAPL | Stock | 95.4625 | 95.92 | 95.1625 | 95.2 | 94792.0 |
| 2020-07-10 08:05:00 | AAPL | Stock | 95.165 | 95.22 | 95.15 | 95.16 | 16044.0 |
| 2020-07-10 08:10:00 | AAPL | Stock | 95.1725 | 95.1725 | 95.0625 | 95.0625 | 11512.0 |
| 2020-07-10 08:15:00 | AAPL | Stock | 95.1125 | 95.1725 | 95.1125 | 95.1625 | 16980.0 |
| 2020-07-10 08:20:00 | AAPL | Stock | 95.2075 | 95.2075 | 95.16 | 95.2 | 23404.0 |
| 2020-07-10 08:25:00 | AAPL | Stock | 95.22 | 95.2475 | 95.1875 | 95.2475 | 11664.0 |
| 2020-07-10 08:30:00 | AAPL | Stock | 95.25 | 95.3475 | 95.25 | 95.2975 | 15564.0 |
| 2020-07-10 08:35:00 | AAPL | Stock | 95.275 | 95.5438 | 95.268 | 95.5 | 31972.0 |
| 2020-07-10 08:40:00 | AAPL | Stock | 95.5 | 95.5725 | 95.4025 | 95.48 | 55100.0 |
| 2020-07-10 08:45:00 | AAPL | Stock | 95.4625 | 95.545 | 95.45 | 95.4875 | 39828.0 |
| 2020-07-10 08:50:00 | AAPL | Stock | 95.4525 | 95.4625 | 95.4 | 95.4 | 19848.0 |
| 2020-07-10 08:55:00 | AAPL | Stock | 95.425 | 95.5 | 95.425 | 95.475 | 27312.0 |
| 2020-07-10 09:00:00 | AAPL | Stock | 95.4968 | 95.565 | 95.4322 | 95.555 | 124228.0 |
| 2020-07-10 09:05:00 | AAPL | Stock | 95.575 | 95.675 | 95.575 | 95.6088 | 80520.0 |
| 2020-07-10 09:10:00 | AAPL | Stock | 95.6 | 95.6 | 95.5175 | 95.54 | 32880.0 |
| 2020-07-10 09:15:00 | AAPL | Stock | 95.55 | 95.675 | 95.55 | 95.675 | 45228.0 |
| 2020-07-10 09:20:00 | AAPL | Stock | 95.675 | 95.77 | 95.675 | 95.77 | 37112.0 |
| 2020-07-10 09:25:00 | AAPL | Stock | 95.7475 | 95.8125 | 95.225 | 95.235 | 116976.0 |
> showing 50 of 407,883 rows — these rows as CSV