PREVIEW / stock_5min / 2019-12-04
file: by_date/stock_5min/2019/2019-12-04.parquet size: 5.9 MB rows: 367,861 symbols: 2,503
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-04 04:00:00 | AAPL | Stock | 64.855 | 64.855 | 64.855 | 64.855 | 400.0 |
| 2019-12-04 04:10:00 | AAPL | Stock | 65.0 | 65.35 | 65.0 | 65.35 | 4932.0 |
| 2019-12-04 04:25:00 | AAPL | Stock | 65.25 | 65.25 | 65.25 | 65.25 | 6160.0 |
| 2019-12-04 04:30:00 | AAPL | Stock | 65.2875 | 65.3 | 65.21 | 65.21 | 11824.0 |
| 2019-12-04 04:35:00 | AAPL | Stock | 65.125 | 65.17 | 65.1125 | 65.17 | 15184.0 |
| 2019-12-04 04:40:00 | AAPL | Stock | 65.17 | 65.195 | 65.17 | 65.195 | 800.0 |
| 2019-12-04 04:45:00 | AAPL | Stock | 65.1925 | 65.2175 | 65.175 | 65.1975 | 8980.0 |
| 2019-12-04 04:55:00 | AAPL | Stock | 65.225 | 65.3475 | 65.225 | 65.3475 | 11880.0 |
| 2019-12-04 05:00:00 | AAPL | Stock | 65.3375 | 65.3375 | 65.3175 | 65.32 | 2288.0 |
| 2019-12-04 05:05:00 | AAPL | Stock | 65.3125 | 65.3125 | 65.3125 | 65.3125 | 400.0 |
| 2019-12-04 05:10:00 | AAPL | Stock | 65.3025 | 65.3025 | 65.3025 | 65.3025 | 800.0 |
| 2019-12-04 05:15:00 | AAPL | Stock | 65.3375 | 65.3375 | 65.2825 | 65.2825 | 2940.0 |
| 2019-12-04 05:20:00 | AAPL | Stock | 65.325 | 65.35 | 65.325 | 65.35 | 3760.0 |
| 2019-12-04 05:25:00 | AAPL | Stock | 65.3225 | 65.3225 | 65.3225 | 65.3225 | 1200.0 |
| 2019-12-04 05:30:00 | AAPL | Stock | 65.3375 | 65.3375 | 65.25 | 65.25 | 6400.0 |
| 2019-12-04 05:50:00 | AAPL | Stock | 65.275 | 65.28 | 65.275 | 65.28 | 1912.0 |
| 2019-12-04 06:10:00 | AAPL | Stock | 65.285 | 65.285 | 65.275 | 65.28 | 8984.0 |
| 2019-12-04 06:15:00 | AAPL | Stock | 65.29 | 65.29 | 65.29 | 65.29 | 2000.0 |
| 2019-12-04 06:20:00 | AAPL | Stock | 65.3175 | 65.3175 | 65.2525 | 65.2525 | 2156.0 |
| 2019-12-04 06:25:00 | AAPL | Stock | 65.3225 | 65.3375 | 65.3225 | 65.3375 | 5552.0 |
| 2019-12-04 06:30:00 | AAPL | Stock | 65.335 | 65.3375 | 65.335 | 65.3375 | 1220.0 |
| 2019-12-04 06:35:00 | AAPL | Stock | 65.3025 | 65.325 | 65.3025 | 65.325 | 2400.0 |
| 2019-12-04 06:40:00 | AAPL | Stock | 65.325 | 65.35 | 65.325 | 65.3475 | 2980.0 |
| 2019-12-04 06:45:00 | AAPL | Stock | 65.35 | 65.35 | 65.3475 | 65.35 | 5604.0 |
| 2019-12-04 06:55:00 | AAPL | Stock | 65.345 | 65.35 | 65.345 | 65.35 | 800.0 |
| 2019-12-04 07:00:00 | AAPL | Stock | 65.3525 | 65.4375 | 65.35 | 65.3825 | 69644.0 |
| 2019-12-04 07:05:00 | AAPL | Stock | 65.385 | 65.4325 | 65.3725 | 65.4325 | 9020.0 |
| 2019-12-04 07:10:00 | AAPL | Stock | 65.4325 | 65.485 | 65.425 | 65.475 | 18928.0 |
| 2019-12-04 07:15:00 | AAPL | Stock | 65.475 | 65.495 | 65.475 | 65.4875 | 28388.0 |
| 2019-12-04 07:20:00 | AAPL | Stock | 65.4875 | 65.4875 | 65.425 | 65.45 | 16068.0 |
| 2019-12-04 07:25:00 | AAPL | Stock | 65.46 | 65.545 | 65.46 | 65.4975 | 17868.0 |
| 2019-12-04 07:30:00 | AAPL | Stock | 65.4975 | 65.5 | 65.4675 | 65.4675 | 16760.0 |
| 2019-12-04 07:35:00 | AAPL | Stock | 65.4825 | 65.485 | 65.3 | 65.4125 | 58052.0 |
| 2019-12-04 07:40:00 | AAPL | Stock | 65.4 | 65.4425 | 65.4 | 65.425 | 11448.0 |
| 2019-12-04 07:45:00 | AAPL | Stock | 65.445 | 65.4525 | 65.375 | 65.3825 | 35140.0 |
| 2019-12-04 07:50:00 | AAPL | Stock | 65.385 | 65.4475 | 65.385 | 65.425 | 13720.0 |
| 2019-12-04 07:55:00 | AAPL | Stock | 65.42 | 65.4425 | 65.4 | 65.4125 | 12444.0 |
| 2019-12-04 08:00:00 | AAPL | Stock | 65.3875 | 65.5458 | 65.3125 | 65.48 | 128168.0 |
| 2019-12-04 08:05:00 | AAPL | Stock | 65.48 | 65.4875 | 65.3725 | 65.445 | 43032.0 |
| 2019-12-04 08:10:00 | AAPL | Stock | 65.44 | 65.4825 | 65.44 | 65.4625 | 36908.0 |
| 2019-12-04 08:15:00 | AAPL | Stock | 65.415 | 65.415 | 65.25 | 65.25 | 99484.0 |
| 2019-12-04 08:20:00 | AAPL | Stock | 65.255 | 65.3525 | 65.24 | 65.3525 | 31428.0 |
| 2019-12-04 08:25:00 | AAPL | Stock | 65.325 | 65.3725 | 65.305 | 65.3375 | 30612.0 |
| 2019-12-04 08:30:00 | AAPL | Stock | 65.3125 | 65.325 | 65.275 | 65.2792 | 24184.0 |
| 2019-12-04 08:35:00 | AAPL | Stock | 65.28 | 65.2925 | 65.24 | 65.26 | 17336.0 |
| 2019-12-04 08:40:00 | AAPL | Stock | 65.27 | 65.27 | 65.18 | 65.2175 | 53084.0 |
| 2019-12-04 08:45:00 | AAPL | Stock | 65.235 | 65.3225 | 65.235 | 65.32 | 43860.0 |
| 2019-12-04 08:50:00 | AAPL | Stock | 65.3 | 65.3675 | 65.3 | 65.35 | 22244.0 |
| 2019-12-04 08:55:00 | AAPL | Stock | 65.3475 | 65.3875 | 65.3275 | 65.3875 | 54844.0 |
| 2019-12-04 09:00:00 | AAPL | Stock | 65.375 | 65.3872 | 65.33 | 65.34 | 35596.0 |
> showing 50 of 367,861 rows — these rows as CSV