PREVIEW / stock_5min / 2018-11-30
file: by_date/stock_5min/2018/2018-11-30.parquet size: 5.7 MB rows: 364,097 symbols: 2,785
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-11-30 04:05:00 | AAPL | Stock | 44.8025 | 44.8025 | 44.8025 | 44.8025 | 400.0 |
| 2018-11-30 04:15:00 | AAPL | Stock | 44.7525 | 44.7525 | 44.75 | 44.75 | 1908.0 |
| 2018-11-30 04:20:00 | AAPL | Stock | 44.77 | 44.77 | 44.7475 | 44.7475 | 2864.0 |
| 2018-11-30 04:50:00 | AAPL | Stock | 44.625 | 44.625 | 44.625 | 44.625 | 544.0 |
| 2018-11-30 05:05:00 | AAPL | Stock | 44.685 | 44.6875 | 44.685 | 44.6875 | 2000.0 |
| 2018-11-30 05:10:00 | AAPL | Stock | 44.64 | 44.64 | 44.64 | 44.64 | 400.0 |
| 2018-11-30 05:20:00 | AAPL | Stock | 44.7 | 44.7 | 44.7 | 44.7 | 480.0 |
| 2018-11-30 05:25:00 | AAPL | Stock | 44.7225 | 44.7225 | 44.7225 | 44.7225 | 600.0 |
| 2018-11-30 05:50:00 | AAPL | Stock | 44.69 | 44.69 | 44.69 | 44.69 | 2000.0 |
| 2018-11-30 05:55:00 | AAPL | Stock | 44.6725 | 44.7 | 44.6725 | 44.7 | 4396.0 |
| 2018-11-30 06:30:00 | AAPL | Stock | 44.695 | 44.695 | 44.695 | 44.695 | 480.0 |
| 2018-11-30 06:45:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 400.0 |
| 2018-11-30 06:50:00 | AAPL | Stock | 44.64 | 44.64 | 44.64 | 44.64 | 400.0 |
| 2018-11-30 06:55:00 | AAPL | Stock | 44.625 | 44.6425 | 44.4025 | 44.515 | 13320.0 |
| 2018-11-30 07:00:00 | AAPL | Stock | 44.61 | 44.61 | 44.475 | 44.495 | 20792.0 |
| 2018-11-30 07:05:00 | AAPL | Stock | 44.5375 | 44.575 | 44.5175 | 44.5375 | 7980.0 |
| 2018-11-30 07:10:00 | AAPL | Stock | 44.5375 | 44.575 | 44.5375 | 44.575 | 7880.0 |
| 2018-11-30 07:20:00 | AAPL | Stock | 44.5625 | 44.5725 | 44.5125 | 44.5125 | 18856.0 |
| 2018-11-30 07:25:00 | AAPL | Stock | 44.55 | 44.6 | 44.55 | 44.6 | 5468.0 |
| 2018-11-30 07:30:00 | AAPL | Stock | 44.625 | 44.635 | 44.59 | 44.61 | 11708.0 |
| 2018-11-30 07:35:00 | AAPL | Stock | 44.6125 | 44.635 | 44.6125 | 44.6125 | 6732.0 |
| 2018-11-30 07:40:00 | AAPL | Stock | 44.6 | 44.6175 | 44.6 | 44.615 | 13400.0 |
| 2018-11-30 07:45:00 | AAPL | Stock | 44.6025 | 44.6575 | 44.6025 | 44.65 | 34808.0 |
| 2018-11-30 07:50:00 | AAPL | Stock | 44.635 | 44.66 | 44.62 | 44.66 | 15328.0 |
| 2018-11-30 07:55:00 | AAPL | Stock | 44.6275 | 44.655 | 44.6125 | 44.6475 | 7400.0 |
| 2018-11-30 08:00:00 | AAPL | Stock | 44.5025 | 44.7125 | 44.47 | 44.6875 | 72672.0 |
| 2018-11-30 08:05:00 | AAPL | Stock | 44.7075 | 44.7125 | 44.628 | 44.6375 | 10812.0 |
| 2018-11-30 08:10:00 | AAPL | Stock | 44.645 | 44.645 | 44.625 | 44.625 | 2800.0 |
| 2018-11-30 08:15:00 | AAPL | Stock | 44.6275 | 44.7 | 44.6275 | 44.7 | 11784.0 |
| 2018-11-30 08:20:00 | AAPL | Stock | 44.7125 | 44.8725 | 44.7125 | 44.825 | 69804.0 |
| 2018-11-30 08:25:00 | AAPL | Stock | 44.825 | 44.87 | 44.8125 | 44.84 | 43816.0 |
| 2018-11-30 08:30:00 | AAPL | Stock | 44.8425 | 44.933 | 44.8425 | 44.9168 | 47056.0 |
| 2018-11-30 08:35:00 | AAPL | Stock | 44.9075 | 44.9375 | 44.875 | 44.8825 | 97168.0 |
| 2018-11-30 08:40:00 | AAPL | Stock | 44.91 | 44.925 | 44.8875 | 44.9125 | 27300.0 |
| 2018-11-30 08:45:00 | AAPL | Stock | 44.9025 | 44.925 | 44.895 | 44.925 | 19372.0 |
| 2018-11-30 08:50:00 | AAPL | Stock | 44.935 | 45.0 | 44.9 | 44.95 | 57924.0 |
| 2018-11-30 08:55:00 | AAPL | Stock | 44.95 | 45.0225 | 44.94 | 45.0 | 54336.0 |
| 2018-11-30 09:00:00 | AAPL | Stock | 45.0025 | 45.0025 | 44.975 | 44.975 | 50728.0 |
| 2018-11-30 09:05:00 | AAPL | Stock | 44.9525 | 44.975 | 44.9375 | 44.96 | 44780.0 |
| 2018-11-30 09:10:00 | AAPL | Stock | 44.945 | 44.97 | 44.94 | 44.9625 | 14440.0 |
| 2018-11-30 09:15:00 | AAPL | Stock | 44.9525 | 44.9875 | 44.9525 | 44.9625 | 25208.0 |
| 2018-11-30 09:20:00 | AAPL | Stock | 44.97 | 44.9775 | 44.9525 | 44.9775 | 8860.0 |
| 2018-11-30 09:25:00 | AAPL | Stock | 44.9725 | 45.0725 | 44.9725 | 45.0725 | 100864.0 |
| 2018-11-30 09:30:00 | AAPL | Stock | 45.0725 | 45.0825 | 44.725 | 44.73 | 3312356.0 |
| 2018-11-30 09:35:00 | AAPL | Stock | 44.725 | 44.8325 | 44.6675 | 44.7275 | 1683300.0 |
| 2018-11-30 09:40:00 | AAPL | Stock | 44.7275 | 44.7275 | 44.5958 | 44.6575 | 1844672.0 |
| 2018-11-30 09:45:00 | AAPL | Stock | 44.655 | 44.735 | 44.62 | 44.6835 | 1830840.0 |
| 2018-11-30 09:50:00 | AAPL | Stock | 44.685 | 44.69 | 44.5475 | 44.6125 | 1785300.0 |
| 2018-11-30 09:55:00 | AAPL | Stock | 44.6125 | 44.64 | 44.5325 | 44.5925 | 1294932.0 |
| 2018-11-30 10:00:00 | AAPL | Stock | 44.5962 | 44.5975 | 44.4775 | 44.525 | 2306104.0 |
> showing 50 of 364,097 rows — these rows as CSV