PREVIEW / stock_5min / 2013-11-05
file: by_date/stock_5min/2013/2013-11-05.parquet size: 5.2 MB rows: 343,875 symbols: 3,546
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-11-05 04:00:00 | AAPL | Stock | 18.7786 | 18.7786 | 18.7786 | 18.7786 | 2800.0 |
| 2013-11-05 04:40:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 5600.0 |
| 2013-11-05 04:45:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 14000.0 |
| 2013-11-05 04:50:00 | AAPL | Stock | 18.7264 | 18.7321 | 18.7264 | 18.7321 | 14000.0 |
| 2013-11-05 05:00:00 | AAPL | Stock | 18.7254 | 18.7329 | 18.7254 | 18.7329 | 14000.0 |
| 2013-11-05 05:15:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 10584.0 |
| 2013-11-05 05:50:00 | AAPL | Stock | 18.7339 | 18.7339 | 18.7339 | 18.7339 | 4200.0 |
| 2013-11-05 06:05:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 10528.0 |
| 2013-11-05 06:20:00 | AAPL | Stock | 18.7411 | 18.7411 | 18.7411 | 18.7411 | 2800.0 |
| 2013-11-05 06:40:00 | AAPL | Stock | 18.7357 | 18.7357 | 18.7357 | 18.7357 | 2800.0 |
| 2013-11-05 06:45:00 | AAPL | Stock | 18.7357 | 18.7357 | 18.7357 | 18.7357 | 2800.0 |
| 2013-11-05 06:50:00 | AAPL | Stock | 18.7518 | 18.7518 | 18.7518 | 18.7518 | 2800.0 |
| 2013-11-05 07:00:00 | AAPL | Stock | 18.7464 | 18.7536 | 18.7464 | 18.7536 | 12600.0 |
| 2013-11-05 07:05:00 | AAPL | Stock | 18.7607 | 18.7843 | 18.7607 | 18.7843 | 106596.0 |
| 2013-11-05 07:10:00 | AAPL | Stock | 18.7786 | 18.7793 | 18.7679 | 18.7679 | 16800.0 |
| 2013-11-05 07:15:00 | AAPL | Stock | 18.7536 | 18.7779 | 18.7536 | 18.7779 | 7560.0 |
| 2013-11-05 07:20:00 | AAPL | Stock | 18.7786 | 18.7839 | 18.7786 | 18.7839 | 12852.0 |
| 2013-11-05 07:25:00 | AAPL | Stock | 18.7739 | 18.7739 | 18.7714 | 18.7714 | 6832.0 |
| 2013-11-05 07:35:00 | AAPL | Stock | 18.7804 | 18.7804 | 18.7804 | 18.7804 | 2800.0 |
| 2013-11-05 07:40:00 | AAPL | Stock | 18.7736 | 18.7736 | 18.7736 | 18.7736 | 5600.0 |
| 2013-11-05 07:45:00 | AAPL | Stock | 18.7736 | 18.7736 | 18.7736 | 18.7736 | 16800.0 |
| 2013-11-05 07:50:00 | AAPL | Stock | 18.7739 | 18.7739 | 18.7718 | 18.7718 | 16800.0 |
| 2013-11-05 07:55:00 | AAPL | Stock | 18.7643 | 18.7643 | 18.7589 | 18.7589 | 12880.0 |
| 2013-11-05 08:00:00 | AAPL | Stock | 18.7643 | 18.8036 | 18.75 | 18.7679 | 199444.0 |
| 2013-11-05 08:05:00 | AAPL | Stock | 18.7696 | 18.775 | 18.7696 | 18.7696 | 41636.0 |
| 2013-11-05 08:10:00 | AAPL | Stock | 18.775 | 18.7768 | 18.7714 | 18.7768 | 51912.0 |
| 2013-11-05 08:15:00 | AAPL | Stock | 18.7768 | 18.7843 | 18.7768 | 18.7843 | 52976.0 |
| 2013-11-05 08:20:00 | AAPL | Stock | 18.7936 | 18.7946 | 18.7875 | 18.7946 | 68320.0 |
| 2013-11-05 08:25:00 | AAPL | Stock | 18.7964 | 18.7964 | 18.7771 | 18.7857 | 61600.0 |
| 2013-11-05 08:30:00 | AAPL | Stock | 18.7821 | 18.7857 | 18.7768 | 18.7789 | 24052.0 |
| 2013-11-05 08:35:00 | AAPL | Stock | 18.7793 | 18.7821 | 18.7786 | 18.7821 | 80360.0 |
| 2013-11-05 08:40:00 | AAPL | Stock | 18.7818 | 18.7818 | 18.7714 | 18.7714 | 460768.0 |
| 2013-11-05 08:45:00 | AAPL | Stock | 18.7771 | 18.7771 | 18.7321 | 18.7461 | 317660.0 |
| 2013-11-05 08:50:00 | AAPL | Stock | 18.7336 | 18.7425 | 18.725 | 18.7393 | 109200.0 |
| 2013-11-05 08:55:00 | AAPL | Stock | 18.7464 | 18.7564 | 18.7393 | 18.7393 | 140868.0 |
| 2013-11-05 09:00:00 | AAPL | Stock | 18.7393 | 18.7496 | 18.7239 | 18.7446 | 173852.0 |
| 2013-11-05 09:05:00 | AAPL | Stock | 18.7432 | 18.7436 | 18.7271 | 18.7393 | 151564.0 |
| 2013-11-05 09:10:00 | AAPL | Stock | 18.7457 | 18.75 | 18.7411 | 18.7475 | 78960.0 |
| 2013-11-05 09:15:00 | AAPL | Stock | 18.7493 | 18.7518 | 18.7461 | 18.7518 | 39144.0 |
| 2013-11-05 09:20:00 | AAPL | Stock | 18.7539 | 18.7629 | 18.75 | 18.7511 | 212968.0 |
| 2013-11-05 09:25:00 | AAPL | Stock | 18.7525 | 18.7525 | 18.7257 | 18.7286 | 203420.0 |
| 2013-11-05 09:30:00 | AAPL | Stock | 18.735 | 18.8104 | 18.7286 | 18.7946 | 10654728.0 |
| 2013-11-05 09:35:00 | AAPL | Stock | 18.7946 | 18.8811 | 18.7946 | 18.8525 | 11637164.0 |
| 2013-11-05 09:40:00 | AAPL | Stock | 18.8511 | 18.8887 | 18.8032 | 18.8129 | 7880012.0 |
| 2013-11-05 09:45:00 | AAPL | Stock | 18.8118 | 18.8207 | 18.7575 | 18.79 | 7590352.0 |
| 2013-11-05 09:50:00 | AAPL | Stock | 18.7907 | 18.8196 | 18.7679 | 18.7929 | 4584748.0 |
| 2013-11-05 09:55:00 | AAPL | Stock | 18.7929 | 18.8096 | 18.7693 | 18.7743 | 3681328.0 |
| 2013-11-05 10:00:00 | AAPL | Stock | 18.7811 | 18.7946 | 18.7321 | 18.7739 | 6471136.0 |
| 2013-11-05 10:05:00 | AAPL | Stock | 18.7736 | 18.7829 | 18.7411 | 18.7821 | 3840648.0 |
| 2013-11-05 10:10:00 | AAPL | Stock | 18.7768 | 18.7771 | 18.7429 | 18.7471 | 2542736.0 |
> showing 50 of 343,875 rows — these rows as CSV