PREVIEW / stock_5min / 2013-12-31
file: by_date/stock_5min/2013/2013-12-31.parquet size: 5.5 MB rows: 365,552 symbols: 3,551
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-12-31 07:10:00 | AAPL | Stock | 19.805 | 19.805 | 19.805 | 19.805 | 2800.0 |
| 2013-12-31 07:20:00 | AAPL | Stock | 19.81 | 19.81 | 19.81 | 19.81 | 8400.0 |
| 2013-12-31 07:25:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.8036 | 19.8036 | 2800.0 |
| 2013-12-31 07:45:00 | AAPL | Stock | 19.7868 | 19.7868 | 19.7679 | 19.7679 | 17080.0 |
| 2013-12-31 07:50:00 | AAPL | Stock | 19.7557 | 19.7557 | 19.75 | 19.75 | 18200.0 |
| 2013-12-31 07:55:00 | AAPL | Stock | 19.75 | 19.7507 | 19.7482 | 19.75 | 114800.0 |
| 2013-12-31 08:00:00 | AAPL | Stock | 19.75 | 19.7514 | 19.75 | 19.7514 | 14560.0 |
| 2013-12-31 08:05:00 | AAPL | Stock | 19.7679 | 19.7679 | 19.7525 | 19.7525 | 75656.0 |
| 2013-12-31 08:10:00 | AAPL | Stock | 19.7482 | 19.7714 | 19.7482 | 19.7714 | 24836.0 |
| 2013-12-31 08:20:00 | AAPL | Stock | 19.7696 | 19.7714 | 19.7696 | 19.7696 | 15400.0 |
| 2013-12-31 08:25:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7696 | 19.7854 | 28560.0 |
| 2013-12-31 08:35:00 | AAPL | Stock | 19.7854 | 19.8196 | 19.7854 | 19.8096 | 30492.0 |
| 2013-12-31 08:40:00 | AAPL | Stock | 19.805 | 19.8082 | 19.805 | 19.8082 | 11200.0 |
| 2013-12-31 08:45:00 | AAPL | Stock | 19.7982 | 19.7982 | 19.7829 | 19.7864 | 40600.0 |
| 2013-12-31 08:50:00 | AAPL | Stock | 19.8018 | 19.8018 | 19.7857 | 19.7857 | 16716.0 |
| 2013-12-31 08:55:00 | AAPL | Stock | 19.7789 | 19.7839 | 19.7789 | 19.7839 | 5600.0 |
| 2013-12-31 09:05:00 | AAPL | Stock | 19.7957 | 19.8114 | 19.7957 | 19.8114 | 64400.0 |
| 2013-12-31 09:10:00 | AAPL | Stock | 19.8054 | 19.81 | 19.7946 | 19.8054 | 65800.0 |
| 2013-12-31 09:15:00 | AAPL | Stock | 19.8036 | 19.8079 | 19.8036 | 19.8043 | 22876.0 |
| 2013-12-31 09:20:00 | AAPL | Stock | 19.8036 | 19.8078 | 19.8018 | 19.8064 | 108864.0 |
| 2013-12-31 09:25:00 | AAPL | Stock | 19.7936 | 19.8071 | 19.7857 | 19.7957 | 103992.0 |
| 2013-12-31 09:30:00 | AAPL | Stock | 19.7904 | 19.9236 | 19.7857 | 19.8929 | 9244536.0 |
| 2013-12-31 09:35:00 | AAPL | Stock | 19.8929 | 19.9432 | 19.8929 | 19.9068 | 8390340.0 |
| 2013-12-31 09:40:00 | AAPL | Stock | 19.9061 | 19.9579 | 19.8993 | 19.9317 | 4942588.0 |
| 2013-12-31 09:45:00 | AAPL | Stock | 19.93 | 19.9432 | 19.9196 | 19.9314 | 6003620.0 |
| 2013-12-31 09:50:00 | AAPL | Stock | 19.9329 | 19.9368 | 19.9071 | 19.926 | 4386872.0 |
| 2013-12-31 09:55:00 | AAPL | Stock | 19.9254 | 19.9725 | 19.9189 | 19.9629 | 6592096.0 |
| 2013-12-31 10:00:00 | AAPL | Stock | 19.9661 | 19.9814 | 19.9504 | 19.9661 | 4034352.0 |
| 2013-12-31 10:05:00 | AAPL | Stock | 19.9679 | 19.99 | 19.9646 | 19.9886 | 4568200.0 |
| 2013-12-31 10:10:00 | AAPL | Stock | 19.99 | 19.9993 | 19.9746 | 19.9886 | 4202380.0 |
| 2013-12-31 10:15:00 | AAPL | Stock | 19.9886 | 20.0157 | 19.98 | 19.9946 | 4532444.0 |
| 2013-12-31 10:20:00 | AAPL | Stock | 19.995 | 20.0264 | 19.9832 | 20.0121 | 2584596.0 |
| 2013-12-31 10:25:00 | AAPL | Stock | 20.0154 | 20.0282 | 20.0111 | 20.0246 | 1817760.0 |
| 2013-12-31 10:30:00 | AAPL | Stock | 20.027 | 20.0386 | 20.0029 | 20.0286 | 4003328.0 |
| 2013-12-31 10:35:00 | AAPL | Stock | 20.0304 | 20.0321 | 20.0004 | 20.0089 | 2570036.0 |
| 2013-12-31 10:40:00 | AAPL | Stock | 20.0075 | 20.0193 | 20.0004 | 20.0121 | 3861116.0 |
| 2013-12-31 10:45:00 | AAPL | Stock | 20.0125 | 20.0164 | 19.9804 | 19.9896 | 2854404.0 |
| 2013-12-31 10:50:00 | AAPL | Stock | 19.99 | 20.0036 | 19.9857 | 19.9957 | 3065524.0 |
| 2013-12-31 10:55:00 | AAPL | Stock | 19.9954 | 20.0129 | 19.9954 | 20.007 | 2023560.0 |
| 2013-12-31 11:00:00 | AAPL | Stock | 20.0071 | 20.015 | 20.0036 | 20.0089 | 1702120.0 |
| 2013-12-31 11:05:00 | AAPL | Stock | 20.01 | 20.0155 | 20.0064 | 20.0129 | 1498812.0 |
| 2013-12-31 11:10:00 | AAPL | Stock | 20.0118 | 20.0286 | 20.0107 | 20.0273 | 2740164.0 |
| 2013-12-31 11:15:00 | AAPL | Stock | 20.0279 | 20.0346 | 20.0107 | 20.02 | 1164212.0 |
| 2013-12-31 11:20:00 | AAPL | Stock | 20.0207 | 20.0307 | 20.0182 | 20.0286 | 1170456.0 |
| 2013-12-31 11:25:00 | AAPL | Stock | 20.0286 | 20.0317 | 20.0243 | 20.0289 | 1182048.0 |
| 2013-12-31 11:30:00 | AAPL | Stock | 20.0289 | 20.0457 | 20.0264 | 20.0318 | 2901444.0 |
| 2013-12-31 11:35:00 | AAPL | Stock | 20.0325 | 20.0329 | 20.0143 | 20.0204 | 2450952.0 |
| 2013-12-31 11:40:00 | AAPL | Stock | 20.018 | 20.0268 | 20.0154 | 20.0261 | 1147048.0 |
| 2013-12-31 11:45:00 | AAPL | Stock | 20.0239 | 20.0332 | 20.0218 | 20.0279 | 1515332.0 |
| 2013-12-31 11:50:00 | AAPL | Stock | 20.0296 | 20.0421 | 20.0264 | 20.0334 | 1650684.0 |
> showing 50 of 365,552 rows — these rows as CSV