PREVIEW / stock_5min / 2018-07-19
file: by_date/stock_5min/2018/2018-07-19.parquet size: 5.5 MB rows: 353,190 symbols: 2,812
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 |
|---|---|---|---|---|---|---|---|
| 2018-07-19 06:00:00 | AAPL | Stock | 47.55 | 47.55 | 47.55 | 47.55 | 400.0 |
| 2018-07-19 06:05:00 | AAPL | Stock | 47.5525 | 47.5525 | 47.55 | 47.55 | 10764.0 |
| 2018-07-19 06:15:00 | AAPL | Stock | 47.545 | 47.55 | 47.5375 | 47.5375 | 4064.0 |
| 2018-07-19 06:20:00 | AAPL | Stock | 47.5325 | 47.5325 | 47.475 | 47.475 | 8328.0 |
| 2018-07-19 06:25:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 2400.0 |
| 2018-07-19 06:50:00 | AAPL | Stock | 47.4875 | 47.4875 | 47.4875 | 47.4875 | 3400.0 |
| 2018-07-19 07:00:00 | AAPL | Stock | 47.5375 | 47.5575 | 47.5375 | 47.55 | 3704.0 |
| 2018-07-19 07:05:00 | AAPL | Stock | 47.575 | 47.6 | 47.575 | 47.6 | 25072.0 |
| 2018-07-19 07:10:00 | AAPL | Stock | 47.6225 | 47.625 | 47.5975 | 47.5975 | 19560.0 |
| 2018-07-19 07:15:00 | AAPL | Stock | 47.5775 | 47.5775 | 47.575 | 47.575 | 57864.0 |
| 2018-07-19 07:20:00 | AAPL | Stock | 47.55 | 47.5525 | 47.55 | 47.5525 | 1200.0 |
| 2018-07-19 07:25:00 | AAPL | Stock | 47.5525 | 47.5625 | 47.55 | 47.5625 | 11276.0 |
| 2018-07-19 07:30:00 | AAPL | Stock | 47.55 | 47.5975 | 47.55 | 47.5975 | 12648.0 |
| 2018-07-19 07:40:00 | AAPL | Stock | 47.5775 | 47.5775 | 47.5775 | 47.5775 | 400.0 |
| 2018-07-19 07:45:00 | AAPL | Stock | 47.575 | 47.575 | 47.5425 | 47.5425 | 7200.0 |
| 2018-07-19 07:50:00 | AAPL | Stock | 47.545 | 47.5625 | 47.5375 | 47.5375 | 7568.0 |
| 2018-07-19 07:55:00 | AAPL | Stock | 47.54 | 47.54 | 47.5 | 47.5 | 128756.0 |
| 2018-07-19 08:00:00 | AAPL | Stock | 47.5188 | 47.5975 | 47.475 | 47.475 | 26268.0 |
| 2018-07-19 08:05:00 | AAPL | Stock | 47.4925 | 47.4925 | 47.4925 | 47.4925 | 1600.0 |
| 2018-07-19 08:10:00 | AAPL | Stock | 47.495 | 47.5 | 47.495 | 47.5 | 2580.0 |
| 2018-07-19 08:15:00 | AAPL | Stock | 47.5 | 47.5025 | 47.5 | 47.5 | 10400.0 |
| 2018-07-19 08:20:00 | AAPL | Stock | 47.5025 | 47.5025 | 47.47 | 47.47 | 7420.0 |
| 2018-07-19 08:25:00 | AAPL | Stock | 47.47 | 47.475 | 47.4375 | 47.4375 | 7180.0 |
| 2018-07-19 08:30:00 | AAPL | Stock | 47.4725 | 47.49 | 47.45 | 47.4575 | 17120.0 |
| 2018-07-19 08:35:00 | AAPL | Stock | 47.4625 | 47.5 | 47.46 | 47.5 | 18104.0 |
| 2018-07-19 08:40:00 | AAPL | Stock | 47.5025 | 47.5025 | 47.485 | 47.5 | 12976.0 |
| 2018-07-19 08:45:00 | AAPL | Stock | 47.5 | 47.5 | 47.4875 | 47.5 | 12864.0 |
| 2018-07-19 08:50:00 | AAPL | Stock | 47.5 | 47.5 | 47.4375 | 47.45 | 31028.0 |
| 2018-07-19 08:55:00 | AAPL | Stock | 47.45 | 47.4575 | 47.445 | 47.4525 | 6200.0 |
| 2018-07-19 09:00:00 | AAPL | Stock | 47.445 | 47.4725 | 47.445 | 47.4725 | 12444.0 |
| 2018-07-19 09:05:00 | AAPL | Stock | 47.475 | 47.475 | 47.475 | 47.475 | 1720.0 |
| 2018-07-19 09:10:00 | AAPL | Stock | 47.4625 | 47.4825 | 47.4625 | 47.475 | 29504.0 |
| 2018-07-19 09:15:00 | AAPL | Stock | 47.4675 | 47.4825 | 47.4675 | 47.48 | 2068.0 |
| 2018-07-19 09:20:00 | AAPL | Stock | 47.48 | 47.4925 | 47.4625 | 47.4825 | 13660.0 |
| 2018-07-19 09:25:00 | AAPL | Stock | 47.4825 | 47.4825 | 47.425 | 47.425 | 31220.0 |
| 2018-07-19 09:30:00 | AAPL | Stock | 47.425 | 47.73 | 47.4225 | 47.73 | 2712932.0 |
| 2018-07-19 09:35:00 | AAPL | Stock | 47.73 | 47.88 | 47.73 | 47.8575 | 2240748.0 |
| 2018-07-19 09:40:00 | AAPL | Stock | 47.8575 | 47.8612 | 47.785 | 47.8382 | 1427220.0 |
| 2018-07-19 09:45:00 | AAPL | Stock | 47.8425 | 48.045 | 47.8375 | 47.91 | 2666824.0 |
| 2018-07-19 09:50:00 | AAPL | Stock | 47.905 | 47.9325 | 47.81 | 47.8575 | 1495652.0 |
| 2018-07-19 09:55:00 | AAPL | Stock | 47.8528 | 47.89 | 47.7838 | 47.8847 | 1309716.0 |
| 2018-07-19 10:00:00 | AAPL | Stock | 47.885 | 47.885 | 47.775 | 47.7825 | 919288.0 |
| 2018-07-19 10:05:00 | AAPL | Stock | 47.7825 | 47.8225 | 47.755 | 47.7575 | 726480.0 |
| 2018-07-19 10:10:00 | AAPL | Stock | 47.755 | 47.855 | 47.7525 | 47.85 | 803260.0 |
| 2018-07-19 10:15:00 | AAPL | Stock | 47.8525 | 47.865 | 47.7975 | 47.8575 | 602576.0 |
| 2018-07-19 10:20:00 | AAPL | Stock | 47.8598 | 47.8612 | 47.8125 | 47.835 | 731492.0 |
| 2018-07-19 10:25:00 | AAPL | Stock | 47.8362 | 47.8625 | 47.8025 | 47.8475 | 396432.0 |
| 2018-07-19 10:30:00 | AAPL | Stock | 47.845 | 47.8488 | 47.765 | 47.815 | 714772.0 |
| 2018-07-19 10:35:00 | AAPL | Stock | 47.815 | 47.8525 | 47.77 | 47.795 | 574104.0 |
| 2018-07-19 10:40:00 | AAPL | Stock | 47.795 | 47.825 | 47.755 | 47.7975 | 624664.0 |
> showing 50 of 353,190 rows — these rows as CSV