PREVIEW / stock_5min / 2011-05-24
file: by_date/stock_5min/2011/2011-05-24.parquet size: 4.9 MB rows: 337,269 symbols: 3,549
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-05-24 05:15:00 | AAPL | Stock | 11.9643 | 11.9643 | 11.9439 | 11.9439 | 16044.0 |
| 2011-05-24 05:50:00 | AAPL | Stock | 11.9532 | 11.9532 | 11.9532 | 11.9532 | 2800.0 |
| 2011-05-24 05:55:00 | AAPL | Stock | 11.9579 | 11.9579 | 11.9579 | 11.9579 | 2800.0 |
| 2011-05-24 06:50:00 | AAPL | Stock | 11.9475 | 11.9475 | 11.9475 | 11.9475 | 2800.0 |
| 2011-05-24 07:00:00 | AAPL | Stock | 11.9679 | 11.9679 | 11.9679 | 11.9679 | 11200.0 |
| 2011-05-24 07:05:00 | AAPL | Stock | 11.9607 | 11.9607 | 11.9607 | 11.9607 | 13580.0 |
| 2011-05-24 07:25:00 | AAPL | Stock | 11.9629 | 11.9629 | 11.9482 | 11.9482 | 10780.0 |
| 2011-05-24 07:45:00 | AAPL | Stock | 11.9636 | 11.9636 | 11.9636 | 11.9636 | 2800.0 |
| 2011-05-24 07:50:00 | AAPL | Stock | 11.9643 | 11.9686 | 11.9636 | 11.9679 | 114856.0 |
| 2011-05-24 07:55:00 | AAPL | Stock | 11.9643 | 11.9711 | 11.9643 | 11.9643 | 60844.0 |
| 2011-05-24 08:00:00 | AAPL | Stock | 11.9696 | 11.9943 | 11.9696 | 11.9879 | 188916.0 |
| 2011-05-24 08:05:00 | AAPL | Stock | 11.9889 | 12.0075 | 11.9882 | 12.0043 | 256340.0 |
| 2011-05-24 08:10:00 | AAPL | Stock | 12.0 | 12.0043 | 11.9961 | 11.9986 | 136500.0 |
| 2011-05-24 08:15:00 | AAPL | Stock | 11.9993 | 12.0 | 11.9925 | 11.9925 | 126168.0 |
| 2011-05-24 08:20:00 | AAPL | Stock | 11.9982 | 12.0021 | 11.9982 | 12.0 | 73640.0 |
| 2011-05-24 08:25:00 | AAPL | Stock | 12.0 | 12.0036 | 11.9946 | 11.9946 | 72688.0 |
| 2011-05-24 08:30:00 | AAPL | Stock | 11.9904 | 11.9971 | 11.9904 | 11.9946 | 26376.0 |
| 2011-05-24 08:35:00 | AAPL | Stock | 11.9946 | 12.0 | 11.9946 | 12.0 | 75740.0 |
| 2011-05-24 08:40:00 | AAPL | Stock | 12.0 | 12.0089 | 12.0 | 12.0071 | 163520.0 |
| 2011-05-24 08:45:00 | AAPL | Stock | 12.0089 | 12.0089 | 12.0036 | 12.0036 | 63000.0 |
| 2011-05-24 08:50:00 | AAPL | Stock | 12.0082 | 12.0082 | 11.9911 | 12.0029 | 52640.0 |
| 2011-05-24 08:55:00 | AAPL | Stock | 11.9936 | 12.0014 | 11.9936 | 12.0 | 25200.0 |
| 2011-05-24 09:00:00 | AAPL | Stock | 12.0014 | 12.0075 | 12.0014 | 12.0075 | 86772.0 |
| 2011-05-24 09:05:00 | AAPL | Stock | 12.0075 | 12.0075 | 12.0021 | 12.0021 | 44800.0 |
| 2011-05-24 09:10:00 | AAPL | Stock | 12.0036 | 12.0054 | 12.0 | 12.0 | 40768.0 |
| 2011-05-24 09:15:00 | AAPL | Stock | 12.0011 | 12.0014 | 12.0011 | 12.0014 | 5600.0 |
| 2011-05-24 09:20:00 | AAPL | Stock | 12.0021 | 12.0021 | 11.9964 | 11.9964 | 88396.0 |
| 2011-05-24 09:25:00 | AAPL | Stock | 11.9968 | 12.0018 | 11.9607 | 11.9821 | 483952.0 |
| 2011-05-24 09:30:00 | AAPL | Stock | 11.9825 | 11.9964 | 11.9468 | 11.9586 | 11015508.0 |
| 2011-05-24 09:35:00 | AAPL | Stock | 11.9593 | 11.9593 | 11.9289 | 11.9354 | 8761452.0 |
| 2011-05-24 09:40:00 | AAPL | Stock | 11.936 | 11.9454 | 11.905 | 11.9064 | 10371228.0 |
| 2011-05-24 09:45:00 | AAPL | Stock | 11.9068 | 11.9143 | 11.8571 | 11.8612 | 11231444.0 |
| 2011-05-24 09:50:00 | AAPL | Stock | 11.8571 | 11.875 | 11.8336 | 11.8725 | 17901352.0 |
| 2011-05-24 09:55:00 | AAPL | Stock | 11.8714 | 11.8775 | 11.8421 | 11.8571 | 9838892.0 |
| 2011-05-24 10:00:00 | AAPL | Stock | 11.8575 | 11.8768 | 11.8371 | 11.85 | 11062436.0 |
| 2011-05-24 10:05:00 | AAPL | Stock | 11.8489 | 11.8732 | 11.8393 | 11.8596 | 8643712.0 |
| 2011-05-24 10:10:00 | AAPL | Stock | 11.8593 | 11.8982 | 11.8593 | 11.8975 | 11844756.0 |
| 2011-05-24 10:15:00 | AAPL | Stock | 11.8982 | 11.9032 | 11.8804 | 11.8964 | 7329924.0 |
| 2011-05-24 10:20:00 | AAPL | Stock | 11.8964 | 11.9107 | 11.8893 | 11.9018 | 6366556.0 |
| 2011-05-24 10:25:00 | AAPL | Stock | 11.9018 | 11.9216 | 11.8914 | 11.8997 | 8438472.0 |
| 2011-05-24 10:30:00 | AAPL | Stock | 11.9011 | 11.9114 | 11.8918 | 11.8982 | 6111448.0 |
| 2011-05-24 10:35:00 | AAPL | Stock | 11.8979 | 11.8986 | 11.8787 | 11.8824 | 5272736.0 |
| 2011-05-24 10:40:00 | AAPL | Stock | 11.8837 | 11.8904 | 11.875 | 11.8796 | 3443188.0 |
| 2011-05-24 10:45:00 | AAPL | Stock | 11.8795 | 11.9082 | 11.8786 | 11.9012 | 4786740.0 |
| 2011-05-24 10:50:00 | AAPL | Stock | 11.8986 | 11.9089 | 11.8946 | 11.8989 | 3486896.0 |
| 2011-05-24 10:55:00 | AAPL | Stock | 11.8975 | 11.9104 | 11.89 | 11.8929 | 3966340.0 |
| 2011-05-24 11:00:00 | AAPL | Stock | 11.8929 | 11.9279 | 11.8923 | 11.92 | 5295556.0 |
| 2011-05-24 11:05:00 | AAPL | Stock | 11.9193 | 11.923 | 11.9096 | 11.9186 | 1995420.0 |
| 2011-05-24 11:10:00 | AAPL | Stock | 11.9189 | 11.9225 | 11.9107 | 11.9171 | 1597904.0 |
| 2011-05-24 11:15:00 | AAPL | Stock | 11.9181 | 11.9229 | 11.9036 | 11.9079 | 2046520.0 |
> showing 50 of 337,269 rows — these rows as CSV