PREVIEW / stock_5min / 2013-05-22
file: by_date/stock_5min/2013/2013-05-22.parquet size: 5.3 MB rows: 345,792 symbols: 3,523
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-05-22 04:15:00 | AAPL | Stock | 15.7246 | 15.7246 | 15.7246 | 15.7246 | 5600.0 |
| 2013-05-22 04:25:00 | AAPL | Stock | 15.7246 | 15.7246 | 15.7246 | 15.7246 | 2800.0 |
| 2013-05-22 05:05:00 | AAPL | Stock | 15.725 | 15.725 | 15.725 | 15.725 | 2800.0 |
| 2013-05-22 05:40:00 | AAPL | Stock | 15.7818 | 15.7818 | 15.7818 | 15.7818 | 2800.0 |
| 2013-05-22 05:50:00 | AAPL | Stock | 15.7271 | 15.7271 | 15.7271 | 15.7271 | 2800.0 |
| 2013-05-22 07:05:00 | AAPL | Stock | 15.7729 | 15.7768 | 15.7729 | 15.7768 | 11200.0 |
| 2013-05-22 07:10:00 | AAPL | Stock | 15.785 | 15.785 | 15.7786 | 15.7786 | 8400.0 |
| 2013-05-22 07:15:00 | AAPL | Stock | 15.7857 | 15.79 | 15.7793 | 15.7846 | 84000.0 |
| 2013-05-22 07:20:00 | AAPL | Stock | 15.7789 | 15.7789 | 15.7768 | 15.7768 | 34524.0 |
| 2013-05-22 07:25:00 | AAPL | Stock | 15.7768 | 15.7771 | 15.7768 | 15.7771 | 7476.0 |
| 2013-05-22 07:30:00 | AAPL | Stock | 15.7768 | 15.7768 | 15.7768 | 15.7768 | 2800.0 |
| 2013-05-22 07:40:00 | AAPL | Stock | 15.7714 | 15.7714 | 15.7714 | 15.7714 | 2800.0 |
| 2013-05-22 07:45:00 | AAPL | Stock | 15.7621 | 15.7643 | 15.7621 | 15.7643 | 19600.0 |
| 2013-05-22 07:50:00 | AAPL | Stock | 15.7593 | 15.7746 | 15.7593 | 15.7746 | 44800.0 |
| 2013-05-22 07:55:00 | AAPL | Stock | 15.7714 | 15.7946 | 15.7714 | 15.7946 | 87920.0 |
| 2013-05-22 08:00:00 | AAPL | Stock | 15.785 | 15.8729 | 15.7679 | 15.8571 | 448952.0 |
| 2013-05-22 08:05:00 | AAPL | Stock | 15.6536 | 15.8814 | 15.6536 | 15.8571 | 386120.0 |
| 2013-05-22 08:10:00 | AAPL | Stock | 15.8568 | 15.8929 | 15.8468 | 15.875 | 536396.0 |
| 2013-05-22 08:15:00 | AAPL | Stock | 15.8746 | 15.8754 | 15.8571 | 15.8664 | 356300.0 |
| 2013-05-22 08:20:00 | AAPL | Stock | 15.8668 | 15.8732 | 15.8482 | 15.8568 | 236936.0 |
| 2013-05-22 08:25:00 | AAPL | Stock | 15.8489 | 15.85 | 15.8171 | 15.8214 | 205016.0 |
| 2013-05-22 08:30:00 | AAPL | Stock | 15.8161 | 15.8214 | 15.8021 | 15.8161 | 103600.0 |
| 2013-05-22 08:35:00 | AAPL | Stock | 15.8179 | 15.8232 | 15.8125 | 15.8232 | 70812.0 |
| 2013-05-22 08:40:00 | AAPL | Stock | 15.8196 | 15.8304 | 15.8168 | 15.82 | 61600.0 |
| 2013-05-22 08:45:00 | AAPL | Stock | 15.8214 | 15.8304 | 15.8179 | 15.8286 | 99568.0 |
| 2013-05-22 08:50:00 | AAPL | Stock | 15.8268 | 15.8482 | 15.8268 | 15.8482 | 216076.0 |
| 2013-05-22 08:55:00 | AAPL | Stock | 15.8464 | 15.8682 | 15.8464 | 15.8682 | 189084.0 |
| 2013-05-22 09:00:00 | AAPL | Stock | 15.8668 | 15.8714 | 15.8575 | 15.8593 | 466032.0 |
| 2013-05-22 09:05:00 | AAPL | Stock | 15.865 | 15.8657 | 15.8446 | 15.8589 | 247772.0 |
| 2013-05-22 09:10:00 | AAPL | Stock | 15.8589 | 15.8607 | 15.8482 | 15.8536 | 338688.0 |
| 2013-05-22 09:15:00 | AAPL | Stock | 15.8607 | 15.865 | 15.8571 | 15.8589 | 144480.0 |
| 2013-05-22 09:20:00 | AAPL | Stock | 15.8675 | 15.875 | 15.86 | 15.8629 | 141092.0 |
| 2013-05-22 09:25:00 | AAPL | Stock | 15.8679 | 15.8804 | 15.8521 | 15.8589 | 772100.0 |
| 2013-05-22 09:30:00 | AAPL | Stock | 15.8575 | 15.9821 | 15.8496 | 15.9389 | 28000476.0 |
| 2013-05-22 09:35:00 | AAPL | Stock | 15.9375 | 16.0 | 15.9332 | 15.9493 | 16221800.0 |
| 2013-05-22 09:40:00 | AAPL | Stock | 15.9493 | 15.9964 | 15.9232 | 15.9606 | 11826444.0 |
| 2013-05-22 09:45:00 | AAPL | Stock | 15.958 | 16.0075 | 15.93 | 15.9764 | 12875156.0 |
| 2013-05-22 09:50:00 | AAPL | Stock | 15.9764 | 15.9996 | 15.9496 | 15.9857 | 7166348.0 |
| 2013-05-22 09:55:00 | AAPL | Stock | 15.9857 | 16.0125 | 15.955 | 15.9661 | 8816136.0 |
| 2013-05-22 10:00:00 | AAPL | Stock | 15.9696 | 16.0064 | 15.9386 | 15.96 | 9243920.0 |
| 2013-05-22 10:05:00 | AAPL | Stock | 15.9643 | 15.9646 | 15.915 | 15.9304 | 7363048.0 |
| 2013-05-22 10:10:00 | AAPL | Stock | 15.9289 | 15.9871 | 15.9286 | 15.9701 | 7252196.0 |
| 2013-05-22 10:15:00 | AAPL | Stock | 15.975 | 15.9875 | 15.9179 | 15.9464 | 6872460.0 |
| 2013-05-22 10:20:00 | AAPL | Stock | 15.9482 | 15.9693 | 15.9121 | 15.9281 | 6361488.0 |
| 2013-05-22 10:25:00 | AAPL | Stock | 15.9273 | 15.9593 | 15.9193 | 15.9421 | 5831840.0 |
| 2013-05-22 10:30:00 | AAPL | Stock | 15.9464 | 15.9536 | 15.8769 | 15.8825 | 7743960.0 |
| 2013-05-22 10:35:00 | AAPL | Stock | 15.8818 | 15.8868 | 15.8061 | 15.8346 | 13520836.0 |
| 2013-05-22 10:40:00 | AAPL | Stock | 15.8336 | 15.9032 | 15.8214 | 15.8884 | 7576324.0 |
| 2013-05-22 10:45:00 | AAPL | Stock | 15.8836 | 15.8896 | 15.8482 | 15.8621 | 3824352.0 |
| 2013-05-22 10:50:00 | AAPL | Stock | 15.8661 | 15.8836 | 15.8232 | 15.8307 | 5755260.0 |
> showing 50 of 345,792 rows — these rows as CSV