PREVIEW / stock_5min / 2011-03-14
file: by_date/stock_5min/2011/2011-03-14.parquet size: 4.9 MB rows: 330,893 symbols: 3,516
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-14 04:20:00 | AAPL | Stock | 12.25 | 12.2679 | 12.25 | 12.2679 | 22400.0 |
| 2011-03-14 04:30:00 | AAPL | Stock | 12.2961 | 12.3104 | 12.2961 | 12.3104 | 19600.0 |
| 2011-03-14 04:35:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.3036 | 12.3036 | 13300.0 |
| 2011-03-14 04:45:00 | AAPL | Stock | 12.295 | 12.3364 | 12.295 | 12.3364 | 14000.0 |
| 2011-03-14 04:50:00 | AAPL | Stock | 12.3418 | 12.3418 | 12.3418 | 12.3418 | 19600.0 |
| 2011-03-14 04:55:00 | AAPL | Stock | 12.3589 | 12.3589 | 12.3571 | 12.3571 | 5600.0 |
| 2011-03-14 05:05:00 | AAPL | Stock | 12.3482 | 12.3482 | 12.3482 | 12.3482 | 2800.0 |
| 2011-03-14 05:10:00 | AAPL | Stock | 12.365 | 12.3857 | 12.365 | 12.3857 | 16800.0 |
| 2011-03-14 05:15:00 | AAPL | Stock | 12.385 | 12.385 | 12.385 | 12.385 | 5600.0 |
| 2011-03-14 05:20:00 | AAPL | Stock | 12.3754 | 12.3754 | 12.3754 | 12.3754 | 2800.0 |
| 2011-03-14 05:25:00 | AAPL | Stock | 12.3879 | 12.3879 | 12.3879 | 12.3879 | 2800.0 |
| 2011-03-14 05:30:00 | AAPL | Stock | 12.3879 | 12.3879 | 12.3879 | 12.3879 | 2800.0 |
| 2011-03-14 05:40:00 | AAPL | Stock | 12.3786 | 12.3786 | 12.3786 | 12.3786 | 2800.0 |
| 2011-03-14 05:50:00 | AAPL | Stock | 12.4179 | 12.4214 | 12.4179 | 12.4214 | 123564.0 |
| 2011-03-14 05:55:00 | AAPL | Stock | 12.43 | 12.4321 | 12.43 | 12.4321 | 8400.0 |
| 2011-03-14 06:05:00 | AAPL | Stock | 12.4107 | 12.4464 | 12.4107 | 12.4464 | 11200.0 |
| 2011-03-14 06:10:00 | AAPL | Stock | 12.4625 | 12.4714 | 12.4625 | 12.4714 | 8400.0 |
| 2011-03-14 06:15:00 | AAPL | Stock | 12.4821 | 12.4821 | 12.4761 | 12.4761 | 11200.0 |
| 2011-03-14 06:20:00 | AAPL | Stock | 12.4796 | 12.4796 | 12.4796 | 12.4796 | 11200.0 |
| 2011-03-14 06:25:00 | AAPL | Stock | 12.4664 | 12.4679 | 12.4643 | 12.4643 | 16800.0 |
| 2011-03-14 06:45:00 | AAPL | Stock | 12.4629 | 12.4661 | 12.4629 | 12.4661 | 14000.0 |
| 2011-03-14 06:55:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 5600.0 |
| 2011-03-14 07:00:00 | AAPL | Stock | 12.4682 | 12.4821 | 12.4682 | 12.4821 | 5600.0 |
| 2011-03-14 07:05:00 | AAPL | Stock | 12.4821 | 12.5339 | 12.4821 | 12.5189 | 109760.0 |
| 2011-03-14 07:10:00 | AAPL | Stock | 12.5089 | 12.5336 | 12.5089 | 12.5089 | 97076.0 |
| 2011-03-14 07:15:00 | AAPL | Stock | 12.5211 | 12.5336 | 12.5007 | 12.5007 | 152516.0 |
| 2011-03-14 07:20:00 | AAPL | Stock | 12.5 | 12.5286 | 12.5 | 12.5175 | 65604.0 |
| 2011-03-14 07:25:00 | AAPL | Stock | 12.5089 | 12.5111 | 12.5 | 12.5111 | 61600.0 |
| 2011-03-14 07:30:00 | AAPL | Stock | 12.5 | 12.5179 | 12.4946 | 12.5071 | 93800.0 |
| 2011-03-14 07:35:00 | AAPL | Stock | 12.5179 | 12.5179 | 12.5107 | 12.5107 | 16800.0 |
| 2011-03-14 07:40:00 | AAPL | Stock | 12.515 | 12.5604 | 12.5107 | 12.5286 | 89992.0 |
| 2011-03-14 07:45:00 | AAPL | Stock | 12.5339 | 12.5354 | 12.5161 | 12.5161 | 194124.0 |
| 2011-03-14 07:50:00 | AAPL | Stock | 12.5093 | 12.5107 | 12.5036 | 12.5036 | 125524.0 |
| 2011-03-14 07:55:00 | AAPL | Stock | 12.5036 | 12.5089 | 12.5036 | 12.5071 | 22400.0 |
| 2011-03-14 08:00:00 | AAPL | Stock | 12.5064 | 12.5357 | 12.5036 | 12.5182 | 589736.0 |
| 2011-03-14 08:05:00 | AAPL | Stock | 12.5146 | 12.5286 | 12.5139 | 12.5286 | 187208.0 |
| 2011-03-14 08:10:00 | AAPL | Stock | 12.5268 | 12.5314 | 12.5232 | 12.5314 | 203560.0 |
| 2011-03-14 08:15:00 | AAPL | Stock | 12.5304 | 12.5854 | 12.5282 | 12.5796 | 464884.0 |
| 2011-03-14 08:20:00 | AAPL | Stock | 12.5889 | 12.5893 | 12.55 | 12.5843 | 524608.0 |
| 2011-03-14 08:25:00 | AAPL | Stock | 12.5846 | 12.6007 | 12.5839 | 12.5918 | 468804.0 |
| 2011-03-14 08:30:00 | AAPL | Stock | 12.5893 | 12.5918 | 12.58 | 12.5854 | 188272.0 |
| 2011-03-14 08:35:00 | AAPL | Stock | 12.5857 | 12.5857 | 12.5714 | 12.5721 | 145096.0 |
| 2011-03-14 08:40:00 | AAPL | Stock | 12.5786 | 12.5846 | 12.5714 | 12.5821 | 100100.0 |
| 2011-03-14 08:45:00 | AAPL | Stock | 12.5793 | 12.585 | 12.5757 | 12.5779 | 75516.0 |
| 2011-03-14 08:50:00 | AAPL | Stock | 12.5754 | 12.6036 | 12.5714 | 12.5996 | 292712.0 |
| 2011-03-14 08:55:00 | AAPL | Stock | 12.595 | 12.6161 | 12.5946 | 12.6161 | 179760.0 |
| 2011-03-14 09:00:00 | AAPL | Stock | 12.6143 | 12.6304 | 12.6093 | 12.6157 | 267064.0 |
| 2011-03-14 09:05:00 | AAPL | Stock | 12.6157 | 12.6396 | 12.6111 | 12.6393 | 448784.0 |
| 2011-03-14 09:10:00 | AAPL | Stock | 12.6389 | 12.6589 | 12.6339 | 12.6393 | 583380.0 |
| 2011-03-14 09:15:00 | AAPL | Stock | 12.6425 | 12.6482 | 12.6407 | 12.6429 | 225008.0 |
> showing 50 of 330,893 rows — these rows as CSV