PREVIEW / stock_5min / 2012-05-02
file: by_date/stock_5min/2012/2012-05-02.parquet size: 4.9 MB rows: 333,801 symbols: 3,552
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-02 04:00:00 | AAPL | Stock | 20.8214 | 20.8214 | 20.7768 | 20.7768 | 19600.0 |
| 2012-05-02 04:25:00 | AAPL | Stock | 20.7768 | 20.7839 | 20.7643 | 20.7839 | 18200.0 |
| 2012-05-02 04:30:00 | AAPL | Stock | 20.7861 | 20.7861 | 20.7857 | 20.7857 | 14000.0 |
| 2012-05-02 04:50:00 | AAPL | Stock | 20.7611 | 20.7611 | 20.7611 | 20.7611 | 2800.0 |
| 2012-05-02 05:10:00 | AAPL | Stock | 20.7939 | 20.7939 | 20.7939 | 20.7939 | 2800.0 |
| 2012-05-02 05:25:00 | AAPL | Stock | 20.7679 | 20.7679 | 20.7679 | 20.7679 | 5600.0 |
| 2012-05-02 05:40:00 | AAPL | Stock | 20.7571 | 20.7571 | 20.7571 | 20.7571 | 2800.0 |
| 2012-05-02 06:30:00 | AAPL | Stock | 20.75 | 20.7704 | 20.75 | 20.7704 | 11200.0 |
| 2012-05-02 07:00:00 | AAPL | Stock | 20.7268 | 20.775 | 20.7268 | 20.775 | 11200.0 |
| 2012-05-02 07:10:00 | AAPL | Stock | 20.7607 | 20.7857 | 20.7607 | 20.7857 | 47600.0 |
| 2012-05-02 07:15:00 | AAPL | Stock | 20.7857 | 20.7861 | 20.7854 | 20.7861 | 16212.0 |
| 2012-05-02 07:20:00 | AAPL | Stock | 20.7911 | 20.8 | 20.7911 | 20.8 | 5600.0 |
| 2012-05-02 07:25:00 | AAPL | Stock | 20.83 | 20.83 | 20.8214 | 20.8214 | 8400.0 |
| 2012-05-02 07:30:00 | AAPL | Stock | 20.8161 | 20.8161 | 20.8154 | 20.8154 | 5600.0 |
| 2012-05-02 07:35:00 | AAPL | Stock | 20.8125 | 20.83 | 20.8 | 20.8275 | 43736.0 |
| 2012-05-02 07:40:00 | AAPL | Stock | 20.8054 | 20.8054 | 20.8054 | 20.8054 | 2800.0 |
| 2012-05-02 07:45:00 | AAPL | Stock | 20.8096 | 20.8096 | 20.8096 | 20.8096 | 2800.0 |
| 2012-05-02 07:50:00 | AAPL | Stock | 20.8214 | 20.8214 | 20.8079 | 20.8079 | 11200.0 |
| 2012-05-02 07:55:00 | AAPL | Stock | 20.7875 | 20.8179 | 20.7768 | 20.8179 | 60480.0 |
| 2012-05-02 08:00:00 | AAPL | Stock | 20.8196 | 20.8214 | 20.7857 | 20.8004 | 247996.0 |
| 2012-05-02 08:05:00 | AAPL | Stock | 20.8036 | 20.8082 | 20.7793 | 20.7793 | 120820.0 |
| 2012-05-02 08:10:00 | AAPL | Stock | 20.7789 | 20.8 | 20.7721 | 20.7857 | 113820.0 |
| 2012-05-02 08:15:00 | AAPL | Stock | 20.7857 | 20.7857 | 20.7232 | 20.7321 | 587188.0 |
| 2012-05-02 08:20:00 | AAPL | Stock | 20.7393 | 20.7696 | 20.7393 | 20.7429 | 293636.0 |
| 2012-05-02 08:25:00 | AAPL | Stock | 20.7321 | 20.7857 | 20.7321 | 20.7857 | 211316.0 |
| 2012-05-02 08:30:00 | AAPL | Stock | 20.7821 | 20.8214 | 20.7796 | 20.7929 | 302708.0 |
| 2012-05-02 08:35:00 | AAPL | Stock | 20.795 | 20.8171 | 20.7946 | 20.8089 | 266868.0 |
| 2012-05-02 08:40:00 | AAPL | Stock | 20.8089 | 20.8139 | 20.7857 | 20.7868 | 146608.0 |
| 2012-05-02 08:45:00 | AAPL | Stock | 20.7882 | 20.8032 | 20.7696 | 20.7696 | 153860.0 |
| 2012-05-02 08:50:00 | AAPL | Stock | 20.7714 | 20.7714 | 20.7511 | 20.7514 | 157136.0 |
| 2012-05-02 08:55:00 | AAPL | Stock | 20.7504 | 20.7507 | 20.7375 | 20.7446 | 548716.0 |
| 2012-05-02 09:00:00 | AAPL | Stock | 20.7446 | 20.75 | 20.705 | 20.705 | 411488.0 |
| 2012-05-02 09:05:00 | AAPL | Stock | 20.7032 | 20.7168 | 20.6861 | 20.6982 | 537432.0 |
| 2012-05-02 09:10:00 | AAPL | Stock | 20.69 | 20.7096 | 20.6814 | 20.6968 | 314692.0 |
| 2012-05-02 09:15:00 | AAPL | Stock | 20.6964 | 20.7 | 20.67 | 20.6804 | 560672.0 |
| 2012-05-02 09:20:00 | AAPL | Stock | 20.6846 | 20.7107 | 20.6789 | 20.6964 | 407456.0 |
| 2012-05-02 09:25:00 | AAPL | Stock | 20.6964 | 20.7382 | 20.6964 | 20.7318 | 879480.0 |
| 2012-05-02 09:30:00 | AAPL | Stock | 20.7229 | 20.8654 | 20.6736 | 20.8439 | 29560832.0 |
| 2012-05-02 09:35:00 | AAPL | Stock | 20.85 | 20.9625 | 20.8 | 20.9357 | 18655588.0 |
| 2012-05-02 09:40:00 | AAPL | Stock | 20.9468 | 20.9786 | 20.8936 | 20.9029 | 15416884.0 |
| 2012-05-02 09:45:00 | AAPL | Stock | 20.9021 | 20.9286 | 20.8486 | 20.8732 | 12226424.0 |
| 2012-05-02 09:50:00 | AAPL | Stock | 20.869 | 20.8821 | 20.8307 | 20.8732 | 9278360.0 |
| 2012-05-02 09:55:00 | AAPL | Stock | 20.8755 | 20.9243 | 20.8718 | 20.8929 | 8081836.0 |
| 2012-05-02 10:00:00 | AAPL | Stock | 20.8918 | 20.9121 | 20.7393 | 20.75 | 15309280.0 |
| 2012-05-02 10:05:00 | AAPL | Stock | 20.7479 | 20.8314 | 20.7452 | 20.7857 | 10622612.0 |
| 2012-05-02 10:10:00 | AAPL | Stock | 20.7918 | 20.8086 | 20.75 | 20.79 | 7513184.0 |
| 2012-05-02 10:15:00 | AAPL | Stock | 20.7914 | 20.7914 | 20.7261 | 20.7554 | 8723680.0 |
| 2012-05-02 10:20:00 | AAPL | Stock | 20.7557 | 20.7932 | 20.7475 | 20.7479 | 6595764.0 |
| 2012-05-02 10:25:00 | AAPL | Stock | 20.7504 | 20.7736 | 20.7143 | 20.7307 | 7039228.0 |
| 2012-05-02 10:30:00 | AAPL | Stock | 20.7307 | 20.7764 | 20.6964 | 20.7568 | 9191644.0 |
> showing 50 of 333,801 rows — these rows as CSV