PREVIEW / stock_5min / 2008-09-16
file: by_date/stock_5min/2008/2008-09-16.parquet size: 4.8 MB rows: 337,854 symbols: 3,356
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-16 06:30:00 | AAPL | Stock | 5.0 | 5.0 | 4.9929 | 4.9929 | 5600.0 |
| 2008-09-16 06:40:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9821 | 4.9821 | 2800.0 |
| 2008-09-16 06:45:00 | AAPL | Stock | 4.9446 | 4.9446 | 4.9446 | 4.9446 | 18424.0 |
| 2008-09-16 07:00:00 | AAPL | Stock | 4.9643 | 4.9643 | 4.9296 | 4.9643 | 22400.0 |
| 2008-09-16 07:05:00 | AAPL | Stock | 4.9643 | 4.9771 | 4.9643 | 4.9643 | 128800.0 |
| 2008-09-16 07:10:00 | AAPL | Stock | 4.9639 | 4.9639 | 4.9639 | 4.9639 | 14000.0 |
| 2008-09-16 07:15:00 | AAPL | Stock | 4.9796 | 4.9804 | 4.9607 | 4.9804 | 82208.0 |
| 2008-09-16 07:20:00 | AAPL | Stock | 4.9779 | 4.9779 | 4.9779 | 4.9779 | 5600.0 |
| 2008-09-16 07:30:00 | AAPL | Stock | 4.9643 | 4.9643 | 4.9486 | 4.9486 | 12600.0 |
| 2008-09-16 07:35:00 | AAPL | Stock | 4.9493 | 4.9804 | 4.9493 | 4.9614 | 156716.0 |
| 2008-09-16 07:40:00 | AAPL | Stock | 4.9629 | 4.9629 | 4.9286 | 4.9293 | 145600.0 |
| 2008-09-16 07:45:00 | AAPL | Stock | 4.9325 | 4.9604 | 4.9068 | 4.9286 | 150416.0 |
| 2008-09-16 07:50:00 | AAPL | Stock | 4.9157 | 4.9286 | 4.9107 | 4.9286 | 35000.0 |
| 2008-09-16 07:55:00 | AAPL | Stock | 4.9614 | 4.9643 | 4.9614 | 4.9639 | 19600.0 |
| 2008-09-16 08:00:00 | AAPL | Stock | 4.9393 | 4.9554 | 4.9393 | 4.9429 | 144536.0 |
| 2008-09-16 08:05:00 | AAPL | Stock | 4.9429 | 4.95 | 4.9107 | 4.9107 | 315812.0 |
| 2008-09-16 08:10:00 | AAPL | Stock | 4.9107 | 4.9379 | 4.9068 | 4.9282 | 571284.0 |
| 2008-09-16 08:15:00 | AAPL | Stock | 4.9282 | 4.9282 | 4.8821 | 4.8829 | 422212.0 |
| 2008-09-16 08:20:00 | AAPL | Stock | 4.8821 | 4.8821 | 4.8486 | 4.8518 | 443744.0 |
| 2008-09-16 08:25:00 | AAPL | Stock | 4.8536 | 4.8571 | 4.8354 | 4.8536 | 518952.0 |
| 2008-09-16 08:30:00 | AAPL | Stock | 4.8536 | 4.8796 | 4.8525 | 4.86 | 630672.0 |
| 2008-09-16 08:35:00 | AAPL | Stock | 4.8518 | 4.8643 | 4.8518 | 4.8571 | 315308.0 |
| 2008-09-16 08:40:00 | AAPL | Stock | 4.8593 | 4.8636 | 4.8529 | 4.8536 | 286300.0 |
| 2008-09-16 08:45:00 | AAPL | Stock | 4.8525 | 4.875 | 4.8525 | 4.8636 | 786940.0 |
| 2008-09-16 08:50:00 | AAPL | Stock | 4.8636 | 4.8636 | 4.8504 | 4.8518 | 1016848.0 |
| 2008-09-16 08:55:00 | AAPL | Stock | 4.8518 | 4.8525 | 4.825 | 4.8254 | 869764.0 |
| 2008-09-16 09:00:00 | AAPL | Stock | 4.825 | 4.8286 | 4.8125 | 4.8125 | 1203944.0 |
| 2008-09-16 09:05:00 | AAPL | Stock | 4.8161 | 4.8161 | 4.7979 | 4.8 | 1219148.0 |
| 2008-09-16 09:10:00 | AAPL | Stock | 4.8036 | 4.8036 | 4.7732 | 4.7768 | 1412208.0 |
| 2008-09-16 09:15:00 | AAPL | Stock | 4.78 | 4.7964 | 4.7768 | 4.7857 | 1057084.0 |
| 2008-09-16 09:20:00 | AAPL | Stock | 4.7821 | 4.7986 | 4.7768 | 4.7961 | 1299060.0 |
| 2008-09-16 09:25:00 | AAPL | Stock | 4.7961 | 4.7996 | 4.7618 | 4.7807 | 1309756.0 |
| 2008-09-16 09:30:00 | AAPL | Stock | 4.7739 | 4.8211 | 4.7196 | 4.81 | 53178664.0 |
| 2008-09-16 09:35:00 | AAPL | Stock | 4.8114 | 4.8214 | 4.7632 | 4.7718 | 32251408.0 |
| 2008-09-16 09:40:00 | AAPL | Stock | 4.7696 | 4.8286 | 4.7654 | 4.8104 | 31220476.0 |
| 2008-09-16 09:45:00 | AAPL | Stock | 4.8107 | 4.8357 | 4.8064 | 4.8143 | 28954716.0 |
| 2008-09-16 09:50:00 | AAPL | Stock | 4.8143 | 4.8225 | 4.7918 | 4.7932 | 21953820.0 |
| 2008-09-16 09:55:00 | AAPL | Stock | 4.7921 | 4.7932 | 4.7554 | 4.7568 | 22230964.0 |
| 2008-09-16 10:00:00 | AAPL | Stock | 4.7546 | 4.8457 | 4.7393 | 4.83 | 30831584.0 |
| 2008-09-16 10:05:00 | AAPL | Stock | 4.83 | 4.8729 | 4.8254 | 4.865 | 29320340.0 |
| 2008-09-16 10:10:00 | AAPL | Stock | 4.8643 | 4.9096 | 4.8304 | 4.9091 | 21818804.0 |
| 2008-09-16 10:15:00 | AAPL | Stock | 4.9093 | 4.9286 | 4.8893 | 4.8914 | 24576916.0 |
| 2008-09-16 10:20:00 | AAPL | Stock | 4.8916 | 4.9214 | 4.88 | 4.9139 | 22603280.0 |
| 2008-09-16 10:25:00 | AAPL | Stock | 4.9132 | 4.9143 | 4.8671 | 4.9097 | 16673524.0 |
| 2008-09-16 10:30:00 | AAPL | Stock | 4.9097 | 4.9286 | 4.88 | 4.8818 | 15745772.0 |
| 2008-09-16 10:35:00 | AAPL | Stock | 4.8818 | 4.8882 | 4.85 | 4.8536 | 14573440.0 |
| 2008-09-16 10:40:00 | AAPL | Stock | 4.8534 | 4.8575 | 4.8354 | 4.8475 | 11859764.0 |
| 2008-09-16 10:45:00 | AAPL | Stock | 4.8475 | 4.8732 | 4.8468 | 4.8714 | 7849240.0 |
| 2008-09-16 10:50:00 | AAPL | Stock | 4.8714 | 4.8843 | 4.835 | 4.8739 | 20617436.0 |
| 2008-09-16 10:55:00 | AAPL | Stock | 4.8743 | 4.955 | 4.8739 | 4.9444 | 28808304.0 |
> showing 50 of 337,854 rows — these rows as CSV