PREVIEW / stock_5min / 2011-09-15
file: by_date/stock_5min/2011/2011-09-15.parquet size: 4.7 MB rows: 322,112 symbols: 3,507
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-09-15 04:00:00 | AAPL | Stock | 13.9482 | 13.9482 | 13.9482 | 13.9482 | 2800.0 |
| 2011-09-15 04:05:00 | AAPL | Stock | 13.9571 | 13.9571 | 13.9571 | 13.9571 | 2800.0 |
| 2011-09-15 04:50:00 | AAPL | Stock | 13.9696 | 13.975 | 13.9696 | 13.975 | 5600.0 |
| 2011-09-15 05:35:00 | AAPL | Stock | 13.9757 | 13.9907 | 13.9757 | 13.9907 | 53200.0 |
| 2011-09-15 05:40:00 | AAPL | Stock | 13.9907 | 14.0036 | 13.9907 | 14.0036 | 16800.0 |
| 2011-09-15 05:45:00 | AAPL | Stock | 14.0064 | 14.0064 | 14.0064 | 14.0064 | 84000.0 |
| 2011-09-15 05:55:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 2800.0 |
| 2011-09-15 06:00:00 | AAPL | Stock | 13.9968 | 13.9968 | 13.9968 | 13.9968 | 2800.0 |
| 2011-09-15 06:30:00 | AAPL | Stock | 13.9907 | 13.9907 | 13.9907 | 13.9907 | 2800.0 |
| 2011-09-15 06:50:00 | AAPL | Stock | 13.9907 | 13.9907 | 13.9907 | 13.9907 | 2800.0 |
| 2011-09-15 07:00:00 | AAPL | Stock | 14.0 | 14.0 | 13.9964 | 14.0 | 99400.0 |
| 2011-09-15 07:05:00 | AAPL | Stock | 14.0007 | 14.0007 | 13.9968 | 13.9968 | 11200.0 |
| 2011-09-15 07:10:00 | AAPL | Stock | 14.0 | 14.0054 | 13.9914 | 13.9914 | 72828.0 |
| 2011-09-15 07:15:00 | AAPL | Stock | 13.9914 | 13.9996 | 13.9904 | 13.995 | 37520.0 |
| 2011-09-15 07:20:00 | AAPL | Stock | 13.9904 | 13.9904 | 13.9846 | 13.9893 | 123536.0 |
| 2011-09-15 07:25:00 | AAPL | Stock | 13.9893 | 13.9893 | 13.9875 | 13.9893 | 44800.0 |
| 2011-09-15 07:30:00 | AAPL | Stock | 13.9929 | 13.9929 | 13.9911 | 13.9911 | 11200.0 |
| 2011-09-15 07:35:00 | AAPL | Stock | 13.9989 | 13.9989 | 13.975 | 13.9782 | 36400.0 |
| 2011-09-15 07:40:00 | AAPL | Stock | 13.9775 | 13.9818 | 13.9643 | 13.9732 | 56000.0 |
| 2011-09-15 07:45:00 | AAPL | Stock | 13.9768 | 13.9911 | 13.9768 | 13.9911 | 64400.0 |
| 2011-09-15 07:50:00 | AAPL | Stock | 13.9911 | 14.0089 | 13.9857 | 14.0054 | 153328.0 |
| 2011-09-15 07:55:00 | AAPL | Stock | 14.0 | 14.0 | 13.9889 | 13.9957 | 51240.0 |
| 2011-09-15 08:00:00 | AAPL | Stock | 13.9821 | 14.0036 | 13.9643 | 13.9779 | 379484.0 |
| 2011-09-15 08:05:00 | AAPL | Stock | 13.9714 | 13.9714 | 13.9643 | 13.9643 | 88480.0 |
| 2011-09-15 08:10:00 | AAPL | Stock | 13.9643 | 13.9643 | 13.95 | 13.9593 | 103656.0 |
| 2011-09-15 08:15:00 | AAPL | Stock | 13.9571 | 13.9643 | 13.9571 | 13.9625 | 193004.0 |
| 2011-09-15 08:20:00 | AAPL | Stock | 13.9625 | 13.9711 | 13.9575 | 13.9643 | 115416.0 |
| 2011-09-15 08:25:00 | AAPL | Stock | 13.9639 | 13.9646 | 13.9539 | 13.9557 | 307048.0 |
| 2011-09-15 08:30:00 | AAPL | Stock | 13.9496 | 13.9496 | 13.9179 | 13.9339 | 983500.0 |
| 2011-09-15 08:35:00 | AAPL | Stock | 13.9321 | 13.9475 | 13.9286 | 13.9454 | 561652.0 |
| 2011-09-15 08:40:00 | AAPL | Stock | 13.9443 | 13.9514 | 13.9321 | 13.9339 | 533736.0 |
| 2011-09-15 08:45:00 | AAPL | Stock | 13.9321 | 13.9371 | 13.9107 | 13.9179 | 329028.0 |
| 2011-09-15 08:50:00 | AAPL | Stock | 13.9175 | 13.9246 | 13.9175 | 13.9196 | 94388.0 |
| 2011-09-15 08:55:00 | AAPL | Stock | 13.9196 | 13.9254 | 13.9089 | 13.9143 | 384496.0 |
| 2011-09-15 09:00:00 | AAPL | Stock | 13.9182 | 13.9861 | 13.9157 | 13.9539 | 2105516.0 |
| 2011-09-15 09:05:00 | AAPL | Stock | 13.9539 | 13.9814 | 13.9507 | 13.9679 | 668276.0 |
| 2011-09-15 09:10:00 | AAPL | Stock | 13.9682 | 13.9789 | 13.9682 | 13.9714 | 285852.0 |
| 2011-09-15 09:15:00 | AAPL | Stock | 13.9707 | 13.9975 | 13.9689 | 13.9861 | 984564.0 |
| 2011-09-15 09:20:00 | AAPL | Stock | 13.9839 | 13.9839 | 13.9682 | 13.9682 | 394044.0 |
| 2011-09-15 09:25:00 | AAPL | Stock | 13.9686 | 13.9904 | 13.9686 | 13.9814 | 637672.0 |
| 2011-09-15 09:30:00 | AAPL | Stock | 13.9814 | 13.9907 | 13.9518 | 13.9696 | 14126756.0 |
| 2011-09-15 09:35:00 | AAPL | Stock | 13.9664 | 13.9682 | 13.9375 | 13.9472 | 9006564.0 |
| 2011-09-15 09:40:00 | AAPL | Stock | 13.943 | 13.955 | 13.925 | 13.943 | 9822988.0 |
| 2011-09-15 09:45:00 | AAPL | Stock | 13.9464 | 13.9643 | 13.9389 | 13.9604 | 6869408.0 |
| 2011-09-15 09:50:00 | AAPL | Stock | 13.96 | 13.9714 | 13.9464 | 13.95 | 6690264.0 |
| 2011-09-15 09:55:00 | AAPL | Stock | 13.9516 | 13.9679 | 13.9482 | 13.9536 | 4128516.0 |
| 2011-09-15 10:00:00 | AAPL | Stock | 13.9593 | 14.0179 | 13.9482 | 14.0136 | 13781768.0 |
| 2011-09-15 10:05:00 | AAPL | Stock | 14.0139 | 14.0311 | 13.9879 | 14.0279 | 10701096.0 |
| 2011-09-15 10:10:00 | AAPL | Stock | 14.0264 | 14.0475 | 14.0118 | 14.0271 | 11777388.0 |
| 2011-09-15 10:15:00 | AAPL | Stock | 14.0268 | 14.0286 | 14.0 | 14.0061 | 10429216.0 |
> showing 50 of 322,112 rows — these rows as CSV