PREVIEW / stock_5min / 2019-09-10
file: by_date/stock_5min/2019/2019-09-10.parquet size: 5.8 MB rows: 367,571 symbols: 2,559
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-09-10 04:00:00 | AAPL | Stock | 53.255 | 53.255 | 53.2175 | 53.25 | 4544.0 |
| 2019-09-10 04:05:00 | AAPL | Stock | 53.25 | 53.2875 | 53.25 | 53.2875 | 1980.0 |
| 2019-09-10 04:10:00 | AAPL | Stock | 53.2275 | 53.2275 | 53.15 | 53.15 | 4712.0 |
| 2019-09-10 04:15:00 | AAPL | Stock | 53.175 | 53.175 | 53.175 | 53.175 | 400.0 |
| 2019-09-10 04:20:00 | AAPL | Stock | 53.22 | 53.2475 | 53.22 | 53.2475 | 4728.0 |
| 2019-09-10 04:25:00 | AAPL | Stock | 53.2 | 53.2 | 53.175 | 53.175 | 1748.0 |
| 2019-09-10 04:35:00 | AAPL | Stock | 53.25 | 53.25 | 53.25 | 53.25 | 400.0 |
| 2019-09-10 04:40:00 | AAPL | Stock | 53.2125 | 53.215 | 53.205 | 53.205 | 3000.0 |
| 2019-09-10 05:00:00 | AAPL | Stock | 53.2875 | 53.2875 | 53.2875 | 53.2875 | 400.0 |
| 2019-09-10 05:05:00 | AAPL | Stock | 53.275 | 53.33 | 53.275 | 53.3275 | 11168.0 |
| 2019-09-10 05:10:00 | AAPL | Stock | 53.3325 | 53.3325 | 53.3325 | 53.3325 | 800.0 |
| 2019-09-10 05:30:00 | AAPL | Stock | 53.3 | 53.3 | 53.3 | 53.3 | 1932.0 |
| 2019-09-10 05:35:00 | AAPL | Stock | 53.3 | 53.3 | 53.25 | 53.25 | 1600.0 |
| 2019-09-10 05:40:00 | AAPL | Stock | 53.23 | 53.2475 | 53.23 | 53.2475 | 800.0 |
| 2019-09-10 05:45:00 | AAPL | Stock | 53.2575 | 53.3 | 53.2575 | 53.3 | 1680.0 |
| 2019-09-10 05:50:00 | AAPL | Stock | 53.3 | 53.35 | 53.3 | 53.35 | 10000.0 |
| 2019-09-10 06:05:00 | AAPL | Stock | 53.35 | 53.35 | 53.35 | 53.35 | 1744.0 |
| 2019-09-10 06:10:00 | AAPL | Stock | 53.35 | 53.35 | 53.35 | 53.35 | 2000.0 |
| 2019-09-10 06:20:00 | AAPL | Stock | 53.395 | 53.4 | 53.395 | 53.395 | 4380.0 |
| 2019-09-10 06:30:00 | AAPL | Stock | 53.395 | 53.4025 | 53.385 | 53.385 | 7116.0 |
| 2019-09-10 06:35:00 | AAPL | Stock | 53.3875 | 53.3875 | 53.385 | 53.385 | 4680.0 |
| 2019-09-10 06:40:00 | AAPL | Stock | 53.4125 | 53.4125 | 53.4 | 53.4 | 10488.0 |
| 2019-09-10 06:45:00 | AAPL | Stock | 53.4 | 53.4175 | 53.4 | 53.4175 | 1200.0 |
| 2019-09-10 06:55:00 | AAPL | Stock | 53.415 | 53.415 | 53.385 | 53.4 | 16212.0 |
| 2019-09-10 07:00:00 | AAPL | Stock | 53.43 | 53.4325 | 53.4 | 53.4125 | 9076.0 |
| 2019-09-10 07:05:00 | AAPL | Stock | 53.4475 | 53.5725 | 53.4475 | 53.5625 | 7488.0 |
| 2019-09-10 07:10:00 | AAPL | Stock | 53.5375 | 53.5375 | 53.5025 | 53.5025 | 1200.0 |
| 2019-09-10 07:15:00 | AAPL | Stock | 53.465 | 53.535 | 53.46 | 53.5125 | 15092.0 |
| 2019-09-10 07:20:00 | AAPL | Stock | 53.5 | 53.5 | 53.47 | 53.47 | 5600.0 |
| 2019-09-10 07:25:00 | AAPL | Stock | 53.4875 | 53.5 | 53.45 | 53.5 | 8112.0 |
| 2019-09-10 07:30:00 | AAPL | Stock | 53.495 | 53.4975 | 53.45 | 53.45 | 8000.0 |
| 2019-09-10 07:35:00 | AAPL | Stock | 53.4275 | 53.4375 | 53.4125 | 53.4325 | 32768.0 |
| 2019-09-10 07:40:00 | AAPL | Stock | 53.425 | 53.4275 | 53.395 | 53.4075 | 7588.0 |
| 2019-09-10 07:45:00 | AAPL | Stock | 53.4 | 53.4 | 53.3625 | 53.3625 | 15968.0 |
| 2019-09-10 07:55:00 | AAPL | Stock | 53.38 | 53.425 | 53.38 | 53.425 | 2400.0 |
| 2019-09-10 08:00:00 | AAPL | Stock | 53.4375 | 53.6 | 53.4002 | 53.495 | 69780.0 |
| 2019-09-10 08:05:00 | AAPL | Stock | 53.4725 | 53.48 | 53.45 | 53.45 | 7200.0 |
| 2019-09-10 08:10:00 | AAPL | Stock | 53.49 | 53.5375 | 53.49 | 53.5 | 6884.0 |
| 2019-09-10 08:15:00 | AAPL | Stock | 53.525 | 53.525 | 53.4875 | 53.4875 | 3600.0 |
| 2019-09-10 08:20:00 | AAPL | Stock | 53.475 | 53.475 | 53.4575 | 53.4575 | 3064.0 |
| 2019-09-10 08:25:00 | AAPL | Stock | 53.455 | 53.4875 | 53.45 | 53.4575 | 6644.0 |
| 2019-09-10 08:30:00 | AAPL | Stock | 53.4425 | 53.475 | 53.4425 | 53.475 | 14396.0 |
| 2019-09-10 08:35:00 | AAPL | Stock | 53.5 | 53.5 | 53.4752 | 53.4752 | 1200.0 |
| 2019-09-10 08:40:00 | AAPL | Stock | 53.4825 | 53.495 | 53.4375 | 53.45 | 63272.0 |
| 2019-09-10 08:45:00 | AAPL | Stock | 53.455 | 53.475 | 53.445 | 53.445 | 7560.0 |
| 2019-09-10 08:50:00 | AAPL | Stock | 53.4975 | 53.5 | 53.45 | 53.45 | 2000.0 |
| 2019-09-10 08:55:00 | AAPL | Stock | 53.45 | 53.45 | 53.4 | 53.4 | 19852.0 |
| 2019-09-10 09:00:00 | AAPL | Stock | 53.405 | 53.45 | 53.395 | 53.4125 | 24376.0 |
| 2019-09-10 09:05:00 | AAPL | Stock | 53.4125 | 53.4125 | 53.3775 | 53.3875 | 44220.0 |
| 2019-09-10 09:10:00 | AAPL | Stock | 53.3875 | 53.3875 | 53.35 | 53.35 | 32172.0 |
> showing 50 of 367,571 rows — these rows as CSV