PREVIEW / stock_5min / 2009-08-11
file: by_date/stock_5min/2009/2009-08-11.parquet size: 4.6 MB rows: 319,539 symbols: 3,357
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-11 06:15:00 | AAPL | Stock | 5.8932 | 5.8932 | 5.8932 | 5.8932 | 14000.0 |
| 2009-08-11 08:00:00 | AAPL | Stock | 5.8875 | 5.8875 | 5.8761 | 5.8761 | 31668.0 |
| 2009-08-11 08:05:00 | AAPL | Stock | 5.8757 | 5.8757 | 5.8757 | 5.8757 | 5068.0 |
| 2009-08-11 08:10:00 | AAPL | Stock | 5.8757 | 5.8757 | 5.875 | 5.875 | 18900.0 |
| 2009-08-11 08:15:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 26796.0 |
| 2009-08-11 08:20:00 | AAPL | Stock | 5.8782 | 5.8782 | 5.8782 | 5.8782 | 2800.0 |
| 2009-08-11 08:35:00 | AAPL | Stock | 5.8804 | 5.8804 | 5.8757 | 5.8757 | 33460.0 |
| 2009-08-11 08:40:00 | AAPL | Stock | 5.8761 | 5.8761 | 5.8757 | 5.8757 | 12040.0 |
| 2009-08-11 08:45:00 | AAPL | Stock | 5.88 | 5.88 | 5.875 | 5.875 | 71960.0 |
| 2009-08-11 08:50:00 | AAPL | Stock | 5.875 | 5.8782 | 5.875 | 5.8782 | 27664.0 |
| 2009-08-11 08:55:00 | AAPL | Stock | 5.8714 | 5.8714 | 5.8579 | 5.8579 | 52360.0 |
| 2009-08-11 09:00:00 | AAPL | Stock | 5.8579 | 5.8625 | 5.8536 | 5.8625 | 1033396.0 |
| 2009-08-11 09:05:00 | AAPL | Stock | 5.8579 | 5.8579 | 5.85 | 5.85 | 952952.0 |
| 2009-08-11 09:10:00 | AAPL | Stock | 5.8496 | 5.8496 | 5.8457 | 5.8457 | 1024520.0 |
| 2009-08-11 09:15:00 | AAPL | Stock | 5.8461 | 5.8711 | 5.8432 | 5.8557 | 909496.0 |
| 2009-08-11 09:20:00 | AAPL | Stock | 5.8586 | 5.8607 | 5.8532 | 5.8571 | 61936.0 |
| 2009-08-11 09:25:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8361 | 5.8446 | 422604.0 |
| 2009-08-11 09:30:00 | AAPL | Stock | 5.8461 | 5.8639 | 5.8311 | 5.8629 | 11470284.0 |
| 2009-08-11 09:35:00 | AAPL | Stock | 5.8629 | 5.8686 | 5.8361 | 5.8529 | 9955008.0 |
| 2009-08-11 09:40:00 | AAPL | Stock | 5.8539 | 5.8643 | 5.8471 | 5.8557 | 7744268.0 |
| 2009-08-11 09:45:00 | AAPL | Stock | 5.8539 | 5.8586 | 5.8421 | 5.8461 | 8495844.0 |
| 2009-08-11 09:50:00 | AAPL | Stock | 5.8461 | 5.855 | 5.8425 | 5.8543 | 4266948.0 |
| 2009-08-11 09:55:00 | AAPL | Stock | 5.855 | 5.8707 | 5.8525 | 5.8686 | 7163016.0 |
| 2009-08-11 10:00:00 | AAPL | Stock | 5.8679 | 5.8679 | 5.8439 | 5.8525 | 8382192.0 |
| 2009-08-11 10:05:00 | AAPL | Stock | 5.8529 | 5.8571 | 5.8414 | 5.8482 | 6352276.0 |
| 2009-08-11 10:10:00 | AAPL | Stock | 5.8493 | 5.8607 | 5.8493 | 5.8607 | 5578664.0 |
| 2009-08-11 10:15:00 | AAPL | Stock | 5.8607 | 5.8621 | 5.8518 | 5.8525 | 4948552.0 |
| 2009-08-11 10:20:00 | AAPL | Stock | 5.8529 | 5.8561 | 5.8471 | 5.8493 | 4039952.0 |
| 2009-08-11 10:25:00 | AAPL | Stock | 5.8489 | 5.8514 | 5.8393 | 5.8393 | 5642364.0 |
| 2009-08-11 10:30:00 | AAPL | Stock | 5.8393 | 5.8432 | 5.8329 | 5.8395 | 4380488.0 |
| 2009-08-11 10:35:00 | AAPL | Stock | 5.8396 | 5.8407 | 5.8186 | 5.8232 | 11019148.0 |
| 2009-08-11 10:40:00 | AAPL | Stock | 5.8229 | 5.825 | 5.8143 | 5.8164 | 5868100.0 |
| 2009-08-11 10:45:00 | AAPL | Stock | 5.8161 | 5.8168 | 5.8061 | 5.8104 | 5674172.0 |
| 2009-08-11 10:50:00 | AAPL | Stock | 5.81 | 5.8168 | 5.8057 | 5.8068 | 6110748.0 |
| 2009-08-11 10:55:00 | AAPL | Stock | 5.8068 | 5.8121 | 5.7946 | 5.8096 | 8935836.0 |
| 2009-08-11 11:00:00 | AAPL | Stock | 5.8094 | 5.8129 | 5.8032 | 5.8068 | 4361924.0 |
| 2009-08-11 11:05:00 | AAPL | Stock | 5.8068 | 5.8129 | 5.8036 | 5.8071 | 3728592.0 |
| 2009-08-11 11:10:00 | AAPL | Stock | 5.8072 | 5.8146 | 5.8014 | 5.8025 | 3478636.0 |
| 2009-08-11 11:15:00 | AAPL | Stock | 5.8022 | 5.805 | 5.7954 | 5.8039 | 5295640.0 |
| 2009-08-11 11:20:00 | AAPL | Stock | 5.8039 | 5.8107 | 5.8032 | 5.8039 | 2234372.0 |
| 2009-08-11 11:25:00 | AAPL | Stock | 5.8046 | 5.8093 | 5.8007 | 5.8093 | 2700516.0 |
| 2009-08-11 11:30:00 | AAPL | Stock | 5.8086 | 5.8089 | 5.7993 | 5.8018 | 2738176.0 |
| 2009-08-11 11:35:00 | AAPL | Stock | 5.8007 | 5.8028 | 5.7961 | 5.7971 | 2713956.0 |
| 2009-08-11 11:40:00 | AAPL | Stock | 5.7964 | 5.8036 | 5.7964 | 5.8011 | 2428524.0 |
| 2009-08-11 11:45:00 | AAPL | Stock | 5.8018 | 5.8018 | 5.7918 | 5.7935 | 3093244.0 |
| 2009-08-11 11:50:00 | AAPL | Stock | 5.7935 | 5.7943 | 5.785 | 5.7857 | 7106288.0 |
| 2009-08-11 11:55:00 | AAPL | Stock | 5.7861 | 5.7932 | 5.785 | 5.7875 | 4544736.0 |
| 2009-08-11 12:00:00 | AAPL | Stock | 5.7868 | 5.7925 | 5.7821 | 5.7907 | 3404716.0 |
| 2009-08-11 12:05:00 | AAPL | Stock | 5.7911 | 5.7921 | 5.7861 | 5.7896 | 2709728.0 |
| 2009-08-11 12:10:00 | AAPL | Stock | 5.7904 | 5.7964 | 5.7868 | 5.7946 | 3439800.0 |
> showing 50 of 319,539 rows — these rows as CSV