PREVIEW / stock_5min / 2006-01-27
file: by_date/stock_5min/2006/2006-01-27.parquet size: 3.1 MB rows: 220,546 symbols: 2,189
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-27 04:45:00 | AAPL | Stock | 2.6304 | 2.6304 | 2.6304 | 2.6304 | 2800.0 |
| 2006-01-27 07:00:00 | AAPL | Stock | 2.6268 | 2.6268 | 2.6268 | 2.6268 | 8400.0 |
| 2006-01-27 07:05:00 | AAPL | Stock | 2.625 | 2.6268 | 2.625 | 2.625 | 28000.0 |
| 2006-01-27 07:10:00 | AAPL | Stock | 2.6268 | 2.6268 | 2.6268 | 2.6268 | 25200.0 |
| 2006-01-27 07:15:00 | AAPL | Stock | 2.6304 | 2.6304 | 2.6304 | 2.6304 | 2800.0 |
| 2006-01-27 07:25:00 | AAPL | Stock | 2.6321 | 2.6321 | 2.6321 | 2.6321 | 5600.0 |
| 2006-01-27 07:30:00 | AAPL | Stock | 2.625 | 2.625 | 2.625 | 2.625 | 84000.0 |
| 2006-01-27 07:35:00 | AAPL | Stock | 2.625 | 2.625 | 2.625 | 2.625 | 30800.0 |
| 2006-01-27 07:40:00 | AAPL | Stock | 2.625 | 2.625 | 2.625 | 2.625 | 57400.0 |
| 2006-01-27 07:45:00 | AAPL | Stock | 2.6286 | 2.6286 | 2.625 | 2.625 | 30800.0 |
| 2006-01-27 07:50:00 | AAPL | Stock | 2.625 | 2.625 | 2.6179 | 2.6179 | 26600.0 |
| 2006-01-27 08:00:00 | AAPL | Stock | 2.6179 | 2.625 | 2.6168 | 2.6196 | 235900.0 |
| 2006-01-27 08:05:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6107 | 2.6107 | 442960.0 |
| 2006-01-27 08:10:00 | AAPL | Stock | 2.6125 | 2.6214 | 2.6125 | 2.6207 | 287392.0 |
| 2006-01-27 08:15:00 | AAPL | Stock | 2.6207 | 2.6229 | 2.6207 | 2.6214 | 113792.0 |
| 2006-01-27 08:20:00 | AAPL | Stock | 2.6204 | 2.6207 | 2.6143 | 2.6196 | 54600.0 |
| 2006-01-27 08:25:00 | AAPL | Stock | 2.6207 | 2.6261 | 2.6196 | 2.6196 | 557396.0 |
| 2006-01-27 08:30:00 | AAPL | Stock | 2.6196 | 2.6196 | 2.6071 | 2.6196 | 1010688.0 |
| 2006-01-27 08:35:00 | AAPL | Stock | 2.6196 | 2.6214 | 2.6161 | 2.6161 | 596932.0 |
| 2006-01-27 08:40:00 | AAPL | Stock | 2.6164 | 2.6179 | 2.6143 | 2.6146 | 389620.0 |
| 2006-01-27 08:45:00 | AAPL | Stock | 2.6143 | 2.6196 | 2.6121 | 2.6143 | 344960.0 |
| 2006-01-27 08:50:00 | AAPL | Stock | 2.6179 | 2.6196 | 2.6107 | 2.6143 | 408800.0 |
| 2006-01-27 08:55:00 | AAPL | Stock | 2.6125 | 2.6139 | 2.6071 | 2.6082 | 314720.0 |
| 2006-01-27 09:00:00 | AAPL | Stock | 2.6086 | 2.6125 | 2.6086 | 2.6089 | 736540.0 |
| 2006-01-27 09:05:00 | AAPL | Stock | 2.6125 | 2.6125 | 2.5982 | 2.5982 | 961688.0 |
| 2006-01-27 09:10:00 | AAPL | Stock | 2.6 | 2.6 | 2.5914 | 2.5914 | 714700.0 |
| 2006-01-27 09:15:00 | AAPL | Stock | 2.5914 | 2.5932 | 2.5911 | 2.5929 | 436800.0 |
| 2006-01-27 09:20:00 | AAPL | Stock | 2.5929 | 2.5964 | 2.5911 | 2.5964 | 497420.0 |
| 2006-01-27 09:25:00 | AAPL | Stock | 2.5982 | 2.61 | 2.5964 | 2.6036 | 1117424.0 |
| 2006-01-27 09:30:00 | AAPL | Stock | 2.6054 | 2.6054 | 2.5914 | 2.6011 | 24394916.0 |
| 2006-01-27 09:35:00 | AAPL | Stock | 2.6011 | 2.6011 | 2.5393 | 2.5604 | 41353312.0 |
| 2006-01-27 09:40:00 | AAPL | Stock | 2.5607 | 2.5932 | 2.5511 | 2.5896 | 33282760.0 |
| 2006-01-27 09:45:00 | AAPL | Stock | 2.5896 | 2.6043 | 2.575 | 2.5861 | 30501716.0 |
| 2006-01-27 09:50:00 | AAPL | Stock | 2.5879 | 2.5996 | 2.5814 | 2.5886 | 24506720.0 |
| 2006-01-27 09:55:00 | AAPL | Stock | 2.5886 | 2.5936 | 2.58 | 2.5882 | 23886940.0 |
| 2006-01-27 10:00:00 | AAPL | Stock | 2.5839 | 2.6107 | 2.5839 | 2.6075 | 50485708.0 |
| 2006-01-27 10:05:00 | AAPL | Stock | 2.6075 | 2.625 | 2.6 | 2.6125 | 34112568.0 |
| 2006-01-27 10:10:00 | AAPL | Stock | 2.6129 | 2.6286 | 2.6114 | 2.6161 | 26033112.0 |
| 2006-01-27 10:15:00 | AAPL | Stock | 2.6157 | 2.6286 | 2.6068 | 2.6179 | 18090856.0 |
| 2006-01-27 10:20:00 | AAPL | Stock | 2.6171 | 2.6268 | 2.5871 | 2.59 | 23089108.0 |
| 2006-01-27 10:25:00 | AAPL | Stock | 2.5896 | 2.5939 | 2.5689 | 2.5854 | 25848620.0 |
| 2006-01-27 10:30:00 | AAPL | Stock | 2.5854 | 2.5871 | 2.5668 | 2.5707 | 17050124.0 |
| 2006-01-27 10:35:00 | AAPL | Stock | 2.5707 | 2.58 | 2.5675 | 2.5782 | 10281292.0 |
| 2006-01-27 10:40:00 | AAPL | Stock | 2.5782 | 2.5882 | 2.5771 | 2.5793 | 12919760.0 |
| 2006-01-27 10:45:00 | AAPL | Stock | 2.5793 | 2.5793 | 2.5661 | 2.5711 | 13667752.0 |
| 2006-01-27 10:50:00 | AAPL | Stock | 2.5714 | 2.5804 | 2.57 | 2.5746 | 9661736.0 |
| 2006-01-27 10:55:00 | AAPL | Stock | 2.5746 | 2.5875 | 2.5729 | 2.5832 | 9638804.0 |
| 2006-01-27 11:00:00 | AAPL | Stock | 2.5832 | 2.5857 | 2.5739 | 2.5761 | 7844004.0 |
| 2006-01-27 11:05:00 | AAPL | Stock | 2.5757 | 2.5775 | 2.5729 | 2.5764 | 5618732.0 |
| 2006-01-27 11:10:00 | AAPL | Stock | 2.5768 | 2.5768 | 2.5661 | 2.5718 | 11969804.0 |
> showing 50 of 220,546 rows — these rows as CSV