PREVIEW / stock_5min / 2008-07-30
file: by_date/stock_5min/2008/2008-07-30.parquet size: 4.5 MB rows: 316,544 symbols: 3,318
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-07-30 08:00:00 | AAPL | Stock | 5.6161 | 5.6357 | 5.6089 | 5.6354 | 170100.0 |
| 2008-07-30 08:05:00 | AAPL | Stock | 5.6354 | 5.6425 | 5.6321 | 5.6357 | 163240.0 |
| 2008-07-30 08:10:00 | AAPL | Stock | 5.6321 | 5.6354 | 5.6271 | 5.6271 | 29260.0 |
| 2008-07-30 08:15:00 | AAPL | Stock | 5.6346 | 5.6582 | 5.6254 | 5.6582 | 396480.0 |
| 2008-07-30 08:20:00 | AAPL | Stock | 5.6504 | 5.6589 | 5.6429 | 5.6443 | 215516.0 |
| 2008-07-30 08:25:00 | AAPL | Stock | 5.6443 | 5.6486 | 5.6411 | 5.6429 | 240800.0 |
| 2008-07-30 08:30:00 | AAPL | Stock | 5.6486 | 5.6496 | 5.6429 | 5.6464 | 159040.0 |
| 2008-07-30 08:35:00 | AAPL | Stock | 5.6475 | 5.6507 | 5.6464 | 5.6464 | 184380.0 |
| 2008-07-30 08:40:00 | AAPL | Stock | 5.6457 | 5.6489 | 5.6429 | 5.6464 | 200424.0 |
| 2008-07-30 08:45:00 | AAPL | Stock | 5.6464 | 5.6511 | 5.6464 | 5.6504 | 300272.0 |
| 2008-07-30 08:50:00 | AAPL | Stock | 5.6493 | 5.6532 | 5.6479 | 5.6489 | 405384.0 |
| 2008-07-30 08:55:00 | AAPL | Stock | 5.6493 | 5.6518 | 5.61 | 5.6486 | 319956.0 |
| 2008-07-30 09:00:00 | AAPL | Stock | 5.6496 | 5.6518 | 5.6496 | 5.6518 | 104300.0 |
| 2008-07-30 09:05:00 | AAPL | Stock | 5.6525 | 5.6607 | 5.6518 | 5.6607 | 221368.0 |
| 2008-07-30 09:10:00 | AAPL | Stock | 5.6607 | 5.6607 | 5.6536 | 5.6575 | 218680.0 |
| 2008-07-30 09:15:00 | AAPL | Stock | 5.6582 | 5.6582 | 5.6539 | 5.6579 | 215124.0 |
| 2008-07-30 09:20:00 | AAPL | Stock | 5.6579 | 5.6593 | 5.6518 | 5.6518 | 243992.0 |
| 2008-07-30 09:25:00 | AAPL | Stock | 5.6518 | 5.6518 | 5.6325 | 5.6325 | 1115016.0 |
| 2008-07-30 09:30:00 | AAPL | Stock | 5.6339 | 5.6489 | 5.6089 | 5.6261 | 20048812.0 |
| 2008-07-30 09:35:00 | AAPL | Stock | 5.6254 | 5.6364 | 5.5971 | 5.6193 | 20785016.0 |
| 2008-07-30 09:40:00 | AAPL | Stock | 5.6189 | 5.6743 | 5.6171 | 5.6632 | 20194468.0 |
| 2008-07-30 09:45:00 | AAPL | Stock | 5.6625 | 5.6639 | 5.6368 | 5.6425 | 11428424.0 |
| 2008-07-30 09:50:00 | AAPL | Stock | 5.6429 | 5.6521 | 5.6325 | 5.6375 | 10786216.0 |
| 2008-07-30 09:55:00 | AAPL | Stock | 5.6379 | 5.6693 | 5.6357 | 5.6521 | 11974732.0 |
| 2008-07-30 10:00:00 | AAPL | Stock | 5.6518 | 5.6929 | 5.6514 | 5.68 | 15394708.0 |
| 2008-07-30 10:05:00 | AAPL | Stock | 5.68 | 5.6893 | 5.6761 | 5.6886 | 11805640.0 |
| 2008-07-30 10:10:00 | AAPL | Stock | 5.6882 | 5.7036 | 5.6825 | 5.6993 | 17136952.0 |
| 2008-07-30 10:15:00 | AAPL | Stock | 5.6993 | 5.71 | 5.6907 | 5.6946 | 14571004.0 |
| 2008-07-30 10:20:00 | AAPL | Stock | 5.6946 | 5.7025 | 5.6925 | 5.7014 | 5794740.0 |
| 2008-07-30 10:25:00 | AAPL | Stock | 5.7014 | 5.7107 | 5.6971 | 5.7004 | 7267036.0 |
| 2008-07-30 10:30:00 | AAPL | Stock | 5.7 | 5.7079 | 5.6889 | 5.6889 | 6276788.0 |
| 2008-07-30 10:35:00 | AAPL | Stock | 5.6889 | 5.7143 | 5.6886 | 5.7061 | 15828736.0 |
| 2008-07-30 10:40:00 | AAPL | Stock | 5.7064 | 5.7143 | 5.6929 | 5.7011 | 10933552.0 |
| 2008-07-30 10:45:00 | AAPL | Stock | 5.7004 | 5.7311 | 5.6936 | 5.7229 | 19190612.0 |
| 2008-07-30 10:50:00 | AAPL | Stock | 5.7229 | 5.7318 | 5.6975 | 5.7036 | 13436752.0 |
| 2008-07-30 10:55:00 | AAPL | Stock | 5.7039 | 5.7132 | 5.6982 | 5.7007 | 9322320.0 |
| 2008-07-30 11:00:00 | AAPL | Stock | 5.7007 | 5.7079 | 5.6964 | 5.7014 | 5138420.0 |
| 2008-07-30 11:05:00 | AAPL | Stock | 5.7007 | 5.7068 | 5.6893 | 5.7018 | 6477100.0 |
| 2008-07-30 11:10:00 | AAPL | Stock | 5.7014 | 5.7071 | 5.6954 | 5.7004 | 5901728.0 |
| 2008-07-30 11:15:00 | AAPL | Stock | 5.7004 | 5.7057 | 5.6911 | 5.6939 | 3836700.0 |
| 2008-07-30 11:20:00 | AAPL | Stock | 5.6936 | 5.7004 | 5.6875 | 5.6932 | 5770688.0 |
| 2008-07-30 11:25:00 | AAPL | Stock | 5.6932 | 5.7036 | 5.6904 | 5.7018 | 5106388.0 |
| 2008-07-30 11:30:00 | AAPL | Stock | 5.7014 | 5.7032 | 5.6893 | 5.6918 | 4627168.0 |
| 2008-07-30 11:35:00 | AAPL | Stock | 5.6907 | 5.6939 | 5.6754 | 5.6876 | 5804008.0 |
| 2008-07-30 11:40:00 | AAPL | Stock | 5.6886 | 5.6964 | 5.6879 | 5.6929 | 3552360.0 |
| 2008-07-30 11:45:00 | AAPL | Stock | 5.6929 | 5.6964 | 5.6875 | 5.6914 | 4616164.0 |
| 2008-07-30 11:50:00 | AAPL | Stock | 5.6914 | 5.7036 | 5.6911 | 5.7032 | 5847184.0 |
| 2008-07-30 11:55:00 | AAPL | Stock | 5.7032 | 5.7107 | 5.7025 | 5.7054 | 5634636.0 |
| 2008-07-30 12:00:00 | AAPL | Stock | 5.7054 | 5.7089 | 5.7004 | 5.7021 | 3420368.0 |
| 2008-07-30 12:05:00 | AAPL | Stock | 5.7021 | 5.7057 | 5.6875 | 5.6896 | 6134408.0 |
> showing 50 of 316,544 rows — these rows as CSV