PREVIEW / stock_5min / 2019-03-26
file: by_date/stock_5min/2019/2019-03-26.parquet size: 5.7 MB rows: 360,550 symbols: 2,652
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-03-26 04:00:00 | AAPL | Stock | 47.445 | 47.4625 | 47.44 | 47.44 | 14688.0 |
| 2019-03-26 04:05:00 | AAPL | Stock | 47.38 | 47.38 | 47.0 | 47.125 | 42592.0 |
| 2019-03-26 04:10:00 | AAPL | Stock | 47.125 | 47.13 | 47.125 | 47.125 | 12676.0 |
| 2019-03-26 04:15:00 | AAPL | Stock | 47.165 | 47.17 | 47.165 | 47.17 | 6772.0 |
| 2019-03-26 04:30:00 | AAPL | Stock | 47.1625 | 47.1625 | 47.1625 | 47.1625 | 600.0 |
| 2019-03-26 05:05:00 | AAPL | Stock | 47.25 | 47.25 | 47.25 | 47.25 | 800.0 |
| 2019-03-26 05:10:00 | AAPL | Stock | 47.2475 | 47.2475 | 47.2475 | 47.2475 | 9272.0 |
| 2019-03-26 05:30:00 | AAPL | Stock | 47.335 | 47.335 | 47.335 | 47.335 | 2000.0 |
| 2019-03-26 05:35:00 | AAPL | Stock | 47.335 | 47.375 | 47.335 | 47.375 | 7500.0 |
| 2019-03-26 05:40:00 | AAPL | Stock | 47.38 | 47.38 | 47.375 | 47.375 | 2448.0 |
| 2019-03-26 06:00:00 | AAPL | Stock | 47.485 | 47.4875 | 47.3975 | 47.4875 | 9080.0 |
| 2019-03-26 06:20:00 | AAPL | Stock | 47.45 | 47.4875 | 47.45 | 47.45 | 3600.0 |
| 2019-03-26 06:25:00 | AAPL | Stock | 47.44 | 47.4625 | 47.425 | 47.4625 | 1600.0 |
| 2019-03-26 06:30:00 | AAPL | Stock | 47.4925 | 47.525 | 47.4925 | 47.525 | 9200.0 |
| 2019-03-26 06:35:00 | AAPL | Stock | 47.505 | 47.5475 | 47.5025 | 47.5475 | 4400.0 |
| 2019-03-26 06:40:00 | AAPL | Stock | 47.56 | 47.56 | 47.5 | 47.5 | 7984.0 |
| 2019-03-26 06:45:00 | AAPL | Stock | 47.5 | 47.5325 | 47.5 | 47.5325 | 7752.0 |
| 2019-03-26 06:50:00 | AAPL | Stock | 47.5 | 47.5625 | 47.5 | 47.5625 | 4188.0 |
| 2019-03-26 06:55:00 | AAPL | Stock | 47.57 | 47.58 | 47.57 | 47.575 | 10920.0 |
| 2019-03-26 07:00:00 | AAPL | Stock | 47.5475 | 47.6975 | 47.515 | 47.6825 | 51716.0 |
| 2019-03-26 07:05:00 | AAPL | Stock | 47.695 | 47.745 | 47.645 | 47.7125 | 70840.0 |
| 2019-03-26 07:10:00 | AAPL | Stock | 47.735 | 47.805 | 47.6375 | 47.6725 | 110664.0 |
| 2019-03-26 07:15:00 | AAPL | Stock | 47.6725 | 47.6875 | 47.635 | 47.65 | 42020.0 |
| 2019-03-26 07:20:00 | AAPL | Stock | 47.65 | 47.6825 | 47.635 | 47.6625 | 23512.0 |
| 2019-03-26 07:25:00 | AAPL | Stock | 47.6375 | 47.7375 | 47.625 | 47.725 | 64956.0 |
| 2019-03-26 07:30:00 | AAPL | Stock | 47.7025 | 47.75 | 47.7 | 47.725 | 36880.0 |
| 2019-03-26 07:35:00 | AAPL | Stock | 47.7 | 47.7225 | 47.635 | 47.65 | 26092.0 |
| 2019-03-26 07:40:00 | AAPL | Stock | 47.66 | 47.7125 | 47.655 | 47.655 | 22748.0 |
| 2019-03-26 07:45:00 | AAPL | Stock | 47.675 | 47.685 | 47.6125 | 47.6725 | 30560.0 |
| 2019-03-26 07:50:00 | AAPL | Stock | 47.6525 | 47.735 | 47.65 | 47.735 | 66236.0 |
| 2019-03-26 07:55:00 | AAPL | Stock | 47.725 | 47.735 | 47.6875 | 47.6925 | 23228.0 |
| 2019-03-26 08:00:00 | AAPL | Stock | 47.5625 | 47.8625 | 47.5425 | 47.8625 | 279828.0 |
| 2019-03-26 08:05:00 | AAPL | Stock | 47.8375 | 47.8725 | 47.825 | 47.8475 | 72620.0 |
| 2019-03-26 08:10:00 | AAPL | Stock | 47.85 | 47.8725 | 47.8375 | 47.85 | 85676.0 |
| 2019-03-26 08:15:00 | AAPL | Stock | 47.85 | 47.8725 | 47.8 | 47.8 | 85464.0 |
| 2019-03-26 08:20:00 | AAPL | Stock | 47.8125 | 47.85 | 47.805 | 47.85 | 50056.0 |
| 2019-03-26 08:25:00 | AAPL | Stock | 47.85 | 47.85 | 47.83 | 47.85 | 59044.0 |
| 2019-03-26 08:30:00 | AAPL | Stock | 47.8475 | 47.85 | 47.7375 | 47.745 | 136128.0 |
| 2019-03-26 08:35:00 | AAPL | Stock | 47.74 | 47.845 | 47.725 | 47.8425 | 88016.0 |
| 2019-03-26 08:40:00 | AAPL | Stock | 47.86 | 48.0325 | 47.775 | 47.9375 | 226812.0 |
| 2019-03-26 08:45:00 | AAPL | Stock | 47.905 | 47.905 | 47.75 | 47.7875 | 84636.0 |
| 2019-03-26 08:50:00 | AAPL | Stock | 47.7875 | 47.825 | 47.7875 | 47.8 | 77608.0 |
| 2019-03-26 08:55:00 | AAPL | Stock | 47.8075 | 47.8625 | 47.7725 | 47.7725 | 52424.0 |
| 2019-03-26 09:00:00 | AAPL | Stock | 47.775 | 47.875 | 47.775 | 47.87 | 100256.0 |
| 2019-03-26 09:05:00 | AAPL | Stock | 47.87 | 47.9 | 47.81 | 47.875 | 192596.0 |
| 2019-03-26 09:10:00 | AAPL | Stock | 47.8675 | 47.875 | 47.7525 | 47.875 | 134124.0 |
| 2019-03-26 09:15:00 | AAPL | Stock | 47.84 | 47.89 | 47.825 | 47.865 | 104680.0 |
| 2019-03-26 09:20:00 | AAPL | Stock | 47.85 | 47.9 | 47.84 | 47.8625 | 67560.0 |
| 2019-03-26 09:25:00 | AAPL | Stock | 47.85 | 47.925 | 47.77 | 47.875 | 68876.0 |
| 2019-03-26 09:30:00 | AAPL | Stock | 47.8725 | 48.0925 | 47.75 | 47.825 | 7403584.0 |
> showing 50 of 360,550 rows — these rows as CSV