PREVIEW / stock_5min / 2013-04-24
file: by_date/stock_5min/2013/2013-04-24.parquet size: 4.9 MB rows: 328,430 symbols: 3,487
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 |
|---|---|---|---|---|---|---|---|
| 2013-04-24 04:00:00 | AAPL | Stock | 14.4829 | 14.6075 | 14.4829 | 14.5539 | 79800.0 |
| 2013-04-24 04:05:00 | AAPL | Stock | 14.5811 | 14.5811 | 14.5811 | 14.5811 | 2800.0 |
| 2013-04-24 04:10:00 | AAPL | Stock | 14.5793 | 14.5793 | 14.5793 | 14.5793 | 2800.0 |
| 2013-04-24 04:20:00 | AAPL | Stock | 14.5714 | 14.5714 | 14.5714 | 14.5714 | 8400.0 |
| 2013-04-24 04:25:00 | AAPL | Stock | 14.5539 | 14.5539 | 14.5539 | 14.5539 | 14000.0 |
| 2013-04-24 04:45:00 | AAPL | Stock | 14.585 | 14.585 | 14.585 | 14.585 | 2800.0 |
| 2013-04-24 04:55:00 | AAPL | Stock | 14.5632 | 14.5632 | 14.5596 | 14.5632 | 11200.0 |
| 2013-04-24 05:05:00 | AAPL | Stock | 14.5554 | 14.5554 | 14.5429 | 14.5429 | 27440.0 |
| 2013-04-24 05:10:00 | AAPL | Stock | 14.5393 | 14.5425 | 14.5393 | 14.5425 | 16800.0 |
| 2013-04-24 05:15:00 | AAPL | Stock | 14.5393 | 14.5393 | 14.5393 | 14.5393 | 56000.0 |
| 2013-04-24 05:20:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 25200.0 |
| 2013-04-24 05:25:00 | AAPL | Stock | 14.5364 | 14.5364 | 14.5364 | 14.5364 | 2800.0 |
| 2013-04-24 05:30:00 | AAPL | Stock | 14.5357 | 14.55 | 14.5357 | 14.5357 | 19600.0 |
| 2013-04-24 05:35:00 | AAPL | Stock | 14.5364 | 14.5364 | 14.5357 | 14.5357 | 11200.0 |
| 2013-04-24 05:40:00 | AAPL | Stock | 14.5225 | 14.5325 | 14.5225 | 14.5286 | 28000.0 |
| 2013-04-24 05:45:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5204 | 14.5204 | 14000.0 |
| 2013-04-24 05:50:00 | AAPL | Stock | 14.5179 | 14.5321 | 14.5179 | 14.5321 | 8400.0 |
| 2013-04-24 06:00:00 | AAPL | Stock | 14.5346 | 14.5346 | 14.5318 | 14.5318 | 8400.0 |
| 2013-04-24 06:05:00 | AAPL | Stock | 14.5196 | 14.5196 | 14.5196 | 14.5196 | 2800.0 |
| 2013-04-24 06:10:00 | AAPL | Stock | 14.5296 | 14.5296 | 14.5204 | 14.5204 | 10276.0 |
| 2013-04-24 06:15:00 | AAPL | Stock | 14.5004 | 14.5236 | 14.4832 | 14.4911 | 86632.0 |
| 2013-04-24 06:20:00 | AAPL | Stock | 14.47 | 14.47 | 14.4639 | 14.4643 | 22232.0 |
| 2013-04-24 06:25:00 | AAPL | Stock | 14.4443 | 14.4893 | 14.4429 | 14.4893 | 88284.0 |
| 2013-04-24 06:30:00 | AAPL | Stock | 14.4464 | 14.4632 | 14.3929 | 14.3979 | 120484.0 |
| 2013-04-24 06:35:00 | AAPL | Stock | 14.3989 | 14.3989 | 14.3986 | 14.3986 | 16800.0 |
| 2013-04-24 06:40:00 | AAPL | Stock | 14.3793 | 14.3793 | 14.3482 | 14.3571 | 101136.0 |
| 2013-04-24 06:45:00 | AAPL | Stock | 14.3746 | 14.3932 | 14.3571 | 14.3575 | 90580.0 |
| 2013-04-24 06:50:00 | AAPL | Stock | 14.3718 | 14.3911 | 14.3718 | 14.3911 | 31416.0 |
| 2013-04-24 06:55:00 | AAPL | Stock | 14.3911 | 14.3911 | 14.3911 | 14.3911 | 5600.0 |
| 2013-04-24 07:00:00 | AAPL | Stock | 14.4154 | 14.4571 | 14.3929 | 14.4229 | 149128.0 |
| 2013-04-24 07:05:00 | AAPL | Stock | 14.4254 | 14.4536 | 14.4254 | 14.4329 | 45248.0 |
| 2013-04-24 07:10:00 | AAPL | Stock | 14.4439 | 14.4893 | 14.4375 | 14.45 | 149296.0 |
| 2013-04-24 07:15:00 | AAPL | Stock | 14.4357 | 14.5 | 14.4325 | 14.4993 | 531832.0 |
| 2013-04-24 07:20:00 | AAPL | Stock | 14.4929 | 14.4993 | 14.4725 | 14.4889 | 324408.0 |
| 2013-04-24 07:25:00 | AAPL | Stock | 14.4825 | 14.4825 | 14.4482 | 14.4482 | 236936.0 |
| 2013-04-24 07:30:00 | AAPL | Stock | 14.4507 | 14.4507 | 14.4029 | 14.4093 | 228564.0 |
| 2013-04-24 07:35:00 | AAPL | Stock | 14.4057 | 14.4179 | 14.3393 | 14.3464 | 769692.0 |
| 2013-04-24 07:40:00 | AAPL | Stock | 14.3371 | 14.3371 | 14.1525 | 14.25 | 2601088.0 |
| 2013-04-24 07:45:00 | AAPL | Stock | 14.25 | 14.25 | 14.1829 | 14.1875 | 873236.0 |
| 2013-04-24 07:50:00 | AAPL | Stock | 14.1786 | 14.1861 | 14.0893 | 14.1154 | 3087364.0 |
| 2013-04-24 07:55:00 | AAPL | Stock | 14.1586 | 14.1889 | 14.1304 | 14.1661 | 758604.0 |
| 2013-04-24 08:00:00 | AAPL | Stock | 14.1696 | 14.25 | 14.1071 | 14.1232 | 2667056.0 |
| 2013-04-24 08:05:00 | AAPL | Stock | 14.1082 | 14.1189 | 14.0086 | 14.0314 | 3558632.0 |
| 2013-04-24 08:10:00 | AAPL | Stock | 14.0296 | 14.045 | 13.9668 | 13.9929 | 4348260.0 |
| 2013-04-24 08:15:00 | AAPL | Stock | 13.9929 | 14.0336 | 13.975 | 14.0318 | 2801204.0 |
| 2013-04-24 08:20:00 | AAPL | Stock | 14.0286 | 14.0893 | 14.0179 | 14.0857 | 3469816.0 |
| 2013-04-24 08:25:00 | AAPL | Stock | 14.0857 | 14.1071 | 14.0739 | 14.0964 | 1989344.0 |
| 2013-04-24 08:30:00 | AAPL | Stock | 14.0964 | 14.4595 | 14.0661 | 14.0664 | 1701952.0 |
| 2013-04-24 08:35:00 | AAPL | Stock | 14.065 | 14.0761 | 14.0357 | 14.0661 | 2058588.0 |
| 2013-04-24 08:40:00 | AAPL | Stock | 14.065 | 14.065 | 14.0179 | 14.0221 | 2529520.0 |
> showing 50 of 328,430 rows — these rows as CSV