PREVIEW / stock_5min / 2013-03-15
file: by_date/stock_5min/2013/2013-03-15.parquet size: 5.1 MB rows: 343,376 symbols: 3,466
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-03-15 04:35:00 | AAPL | Stock | 15.4393 | 15.4393 | 15.4393 | 15.4393 | 6720.0 |
| 2013-03-15 05:10:00 | AAPL | Stock | 15.4554 | 15.4636 | 15.4554 | 15.4636 | 17080.0 |
| 2013-03-15 05:35:00 | AAPL | Stock | 15.4546 | 15.4554 | 15.4546 | 15.4554 | 27972.0 |
| 2013-03-15 05:45:00 | AAPL | Stock | 15.4554 | 15.4554 | 15.4554 | 15.4554 | 12292.0 |
| 2013-03-15 05:55:00 | AAPL | Stock | 15.4629 | 15.4629 | 15.4629 | 15.4629 | 2800.0 |
| 2013-03-15 06:00:00 | AAPL | Stock | 15.4643 | 15.4643 | 15.4643 | 15.4643 | 2800.0 |
| 2013-03-15 06:05:00 | AAPL | Stock | 15.4911 | 15.5179 | 15.4911 | 15.5179 | 5852.0 |
| 2013-03-15 06:15:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 14000.0 |
| 2013-03-15 06:20:00 | AAPL | Stock | 15.5639 | 15.5714 | 15.5639 | 15.5714 | 8400.0 |
| 2013-03-15 06:30:00 | AAPL | Stock | 15.5636 | 15.5636 | 15.5636 | 15.5636 | 2800.0 |
| 2013-03-15 06:35:00 | AAPL | Stock | 15.5536 | 15.5536 | 15.5536 | 15.5536 | 2800.0 |
| 2013-03-15 06:40:00 | AAPL | Stock | 15.5564 | 15.5586 | 15.5564 | 15.5586 | 11200.0 |
| 2013-03-15 06:55:00 | AAPL | Stock | 15.5504 | 15.5707 | 15.5504 | 15.5707 | 22176.0 |
| 2013-03-15 07:00:00 | AAPL | Stock | 15.5771 | 15.5982 | 15.5771 | 15.5839 | 99680.0 |
| 2013-03-15 07:05:00 | AAPL | Stock | 15.5846 | 15.6 | 15.5804 | 15.5896 | 105560.0 |
| 2013-03-15 07:10:00 | AAPL | Stock | 15.5979 | 15.6236 | 15.5979 | 15.6232 | 180376.0 |
| 2013-03-15 07:15:00 | AAPL | Stock | 15.6229 | 15.6714 | 15.6229 | 15.6604 | 163128.0 |
| 2013-03-15 07:20:00 | AAPL | Stock | 15.6539 | 15.6539 | 15.625 | 15.6429 | 117320.0 |
| 2013-03-15 07:25:00 | AAPL | Stock | 15.6429 | 15.6643 | 15.6429 | 15.6429 | 201880.0 |
| 2013-03-15 07:30:00 | AAPL | Stock | 15.6514 | 15.6639 | 15.625 | 15.6604 | 374164.0 |
| 2013-03-15 07:35:00 | AAPL | Stock | 15.6607 | 15.6607 | 15.6357 | 15.6479 | 85456.0 |
| 2013-03-15 07:40:00 | AAPL | Stock | 15.6446 | 15.6529 | 15.6339 | 15.6429 | 127400.0 |
| 2013-03-15 07:45:00 | AAPL | Stock | 15.6429 | 15.6464 | 15.6393 | 15.6429 | 50400.0 |
| 2013-03-15 07:50:00 | AAPL | Stock | 15.6339 | 15.6339 | 15.6243 | 15.6321 | 82992.0 |
| 2013-03-15 07:55:00 | AAPL | Stock | 15.6264 | 15.6357 | 15.625 | 15.6304 | 75376.0 |
| 2013-03-15 08:00:00 | AAPL | Stock | 15.6257 | 15.6607 | 15.5804 | 15.6171 | 482020.0 |
| 2013-03-15 08:05:00 | AAPL | Stock | 15.6357 | 15.6357 | 15.5911 | 15.6161 | 285292.0 |
| 2013-03-15 08:10:00 | AAPL | Stock | 15.6161 | 15.6321 | 15.6161 | 15.6321 | 372596.0 |
| 2013-03-15 08:15:00 | AAPL | Stock | 15.6286 | 15.655 | 15.6286 | 15.6536 | 537908.0 |
| 2013-03-15 08:20:00 | AAPL | Stock | 15.6518 | 15.6536 | 15.6343 | 15.6368 | 509320.0 |
| 2013-03-15 08:25:00 | AAPL | Stock | 15.6393 | 15.6464 | 15.6286 | 15.6464 | 247296.0 |
| 2013-03-15 08:30:00 | AAPL | Stock | 15.6496 | 15.6496 | 15.6339 | 15.6429 | 360416.0 |
| 2013-03-15 08:35:00 | AAPL | Stock | 15.6425 | 15.6489 | 15.6375 | 15.6432 | 332948.0 |
| 2013-03-15 08:40:00 | AAPL | Stock | 15.6432 | 15.6911 | 15.6432 | 15.6857 | 844004.0 |
| 2013-03-15 08:45:00 | AAPL | Stock | 15.6875 | 15.6875 | 15.6571 | 15.6721 | 635152.0 |
| 2013-03-15 08:50:00 | AAPL | Stock | 15.6714 | 15.6825 | 15.6689 | 15.6732 | 357420.0 |
| 2013-03-15 08:55:00 | AAPL | Stock | 15.6732 | 15.705 | 15.6732 | 15.705 | 728672.0 |
| 2013-03-15 09:00:00 | AAPL | Stock | 15.7068 | 15.7257 | 15.7064 | 15.7096 | 1759128.0 |
| 2013-03-15 09:05:00 | AAPL | Stock | 15.7107 | 15.7214 | 15.6811 | 15.7 | 1034012.0 |
| 2013-03-15 09:10:00 | AAPL | Stock | 15.7054 | 15.7107 | 15.685 | 15.7086 | 475636.0 |
| 2013-03-15 09:15:00 | AAPL | Stock | 15.7107 | 15.7107 | 15.6943 | 15.7025 | 588532.0 |
| 2013-03-15 09:20:00 | AAPL | Stock | 15.7032 | 15.7143 | 15.6868 | 15.6868 | 678524.0 |
| 2013-03-15 09:25:00 | AAPL | Stock | 15.6886 | 15.7079 | 15.6254 | 15.6432 | 4214980.0 |
| 2013-03-15 09:30:00 | AAPL | Stock | 15.6404 | 15.6904 | 15.6161 | 15.6518 | 88623220.0 |
| 2013-03-15 09:35:00 | AAPL | Stock | 15.6518 | 15.705 | 15.645 | 15.6807 | 21626416.0 |
| 2013-03-15 09:40:00 | AAPL | Stock | 15.6829 | 15.7214 | 15.6739 | 15.7036 | 17275552.0 |
| 2013-03-15 09:45:00 | AAPL | Stock | 15.6993 | 15.7789 | 15.6789 | 15.7782 | 23018548.0 |
| 2013-03-15 09:50:00 | AAPL | Stock | 15.775 | 15.8036 | 15.7393 | 15.7457 | 20631268.0 |
| 2013-03-15 09:55:00 | AAPL | Stock | 15.7511 | 15.7554 | 15.7225 | 15.7411 | 14401884.0 |
| 2013-03-15 10:00:00 | AAPL | Stock | 15.7389 | 15.7511 | 15.695 | 15.7054 | 15597932.0 |
> showing 50 of 343,376 rows — these rows as CSV