PREVIEW / stock_5min / 2007-08-01
file: by_date/stock_5min/2007/2007-08-01.parquet size: 4.4 MB rows: 313,462 symbols: 3,100
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-01 09:30:00 | AAPL | Stock | 4.7729 | 4.7732 | 4.6982 | 4.6993 | 62124272.0 |
| 2007-08-01 09:35:00 | AAPL | Stock | 4.6989 | 4.7539 | 4.6982 | 4.7086 | 45684212.0 |
| 2007-08-01 09:40:00 | AAPL | Stock | 4.7093 | 4.7129 | 4.5632 | 4.6161 | 97157676.0 |
| 2007-08-01 09:45:00 | AAPL | Stock | 4.6164 | 4.6375 | 4.5714 | 4.5875 | 45421544.0 |
| 2007-08-01 09:50:00 | AAPL | Stock | 4.5875 | 4.6429 | 4.5821 | 4.6413 | 35568624.0 |
| 2007-08-01 09:55:00 | AAPL | Stock | 4.6407 | 4.6454 | 4.6089 | 4.6161 | 32116000.0 |
| 2007-08-01 10:00:00 | AAPL | Stock | 4.6168 | 4.6568 | 4.6125 | 4.6207 | 35478968.0 |
| 2007-08-01 10:05:00 | AAPL | Stock | 4.6218 | 4.6539 | 4.5979 | 4.6335 | 34692168.0 |
| 2007-08-01 10:10:00 | AAPL | Stock | 4.6321 | 4.7143 | 4.6086 | 4.6893 | 37777264.0 |
| 2007-08-01 10:15:00 | AAPL | Stock | 4.6893 | 4.7125 | 4.6643 | 4.7021 | 28828632.0 |
| 2007-08-01 10:20:00 | AAPL | Stock | 4.7021 | 4.7179 | 4.6643 | 4.6746 | 26209036.0 |
| 2007-08-01 10:25:00 | AAPL | Stock | 4.6743 | 4.6854 | 4.6389 | 4.6461 | 26192096.0 |
| 2007-08-01 10:30:00 | AAPL | Stock | 4.6414 | 4.6557 | 4.625 | 4.6429 | 20623820.0 |
| 2007-08-01 10:35:00 | AAPL | Stock | 4.6432 | 4.6586 | 4.6207 | 4.6308 | 18156376.0 |
| 2007-08-01 10:40:00 | AAPL | Stock | 4.6318 | 4.6446 | 4.6304 | 4.6379 | 16220904.0 |
| 2007-08-01 10:45:00 | AAPL | Stock | 4.6371 | 4.6704 | 4.6304 | 4.6668 | 20810580.0 |
| 2007-08-01 10:50:00 | AAPL | Stock | 4.6679 | 4.6825 | 4.6482 | 4.6579 | 17217732.0 |
| 2007-08-01 10:55:00 | AAPL | Stock | 4.6568 | 4.67 | 4.6396 | 4.6396 | 17231452.0 |
| 2007-08-01 11:00:00 | AAPL | Stock | 4.6396 | 4.6421 | 4.6214 | 4.6286 | 20228124.0 |
| 2007-08-01 11:05:00 | AAPL | Stock | 4.6296 | 4.6436 | 4.6243 | 4.6357 | 14387856.0 |
| 2007-08-01 11:10:00 | AAPL | Stock | 4.6357 | 4.6881 | 4.6321 | 4.6814 | 21121912.0 |
| 2007-08-01 11:15:00 | AAPL | Stock | 4.68 | 4.7089 | 4.6632 | 4.7 | 17324160.0 |
| 2007-08-01 11:20:00 | AAPL | Stock | 4.6993 | 4.7018 | 4.6725 | 4.6875 | 13225464.0 |
| 2007-08-01 11:25:00 | AAPL | Stock | 4.6875 | 4.7 | 4.6693 | 4.6732 | 16069424.0 |
| 2007-08-01 11:30:00 | AAPL | Stock | 4.6739 | 4.7086 | 4.6739 | 4.7061 | 11871076.0 |
| 2007-08-01 11:35:00 | AAPL | Stock | 4.7046 | 4.7321 | 4.6921 | 4.7318 | 23830072.0 |
| 2007-08-01 11:40:00 | AAPL | Stock | 4.7318 | 4.755 | 4.7186 | 4.7525 | 26657372.0 |
| 2007-08-01 11:45:00 | AAPL | Stock | 4.7529 | 4.775 | 4.7439 | 4.7475 | 31551016.0 |
| 2007-08-01 11:50:00 | AAPL | Stock | 4.7479 | 4.7625 | 4.7361 | 4.7576 | 15561560.0 |
| 2007-08-01 11:55:00 | AAPL | Stock | 4.7571 | 4.7854 | 4.7571 | 4.7839 | 28475272.0 |
| 2007-08-01 12:00:00 | AAPL | Stock | 4.7846 | 4.785 | 4.7589 | 4.7589 | 19242244.0 |
| 2007-08-01 12:05:00 | AAPL | Stock | 4.7593 | 4.8 | 4.7557 | 4.8 | 26376392.0 |
| 2007-08-01 12:10:00 | AAPL | Stock | 4.7996 | 4.8125 | 4.7957 | 4.8061 | 29004304.0 |
| 2007-08-01 12:15:00 | AAPL | Stock | 4.8071 | 4.835 | 4.8056 | 4.8286 | 25245668.0 |
| 2007-08-01 12:20:00 | AAPL | Stock | 4.8275 | 4.8304 | 4.8032 | 4.8043 | 24457412.0 |
| 2007-08-01 12:25:00 | AAPL | Stock | 4.805 | 4.8257 | 4.7954 | 4.8193 | 16542232.0 |
| 2007-08-01 12:30:00 | AAPL | Stock | 4.8196 | 4.8268 | 4.8107 | 4.82 | 15318100.0 |
| 2007-08-01 12:35:00 | AAPL | Stock | 4.8189 | 4.8268 | 4.7879 | 4.7975 | 18066356.0 |
| 2007-08-01 12:40:00 | AAPL | Stock | 4.7964 | 4.7982 | 4.7786 | 4.7793 | 13868400.0 |
| 2007-08-01 12:45:00 | AAPL | Stock | 4.7804 | 4.7939 | 4.7796 | 4.7857 | 9923424.0 |
| 2007-08-01 12:50:00 | AAPL | Stock | 4.7857 | 4.7879 | 4.7557 | 4.7629 | 17931256.0 |
| 2007-08-01 12:55:00 | AAPL | Stock | 4.7628 | 4.7714 | 4.7579 | 4.7596 | 7270284.0 |
| 2007-08-01 13:00:00 | AAPL | Stock | 4.7593 | 4.76 | 4.7239 | 4.7246 | 20253352.0 |
| 2007-08-01 13:05:00 | AAPL | Stock | 4.7246 | 4.7386 | 4.7179 | 4.7354 | 15414084.0 |
| 2007-08-01 13:10:00 | AAPL | Stock | 4.7354 | 4.7604 | 4.7325 | 4.735 | 14654192.0 |
| 2007-08-01 13:15:00 | AAPL | Stock | 4.7354 | 4.7554 | 4.7214 | 4.7427 | 13514200.0 |
| 2007-08-01 13:20:00 | AAPL | Stock | 4.7421 | 4.7539 | 4.7143 | 4.7232 | 15719760.0 |
| 2007-08-01 13:25:00 | AAPL | Stock | 4.7239 | 4.7421 | 4.7204 | 4.7361 | 11613280.0 |
| 2007-08-01 13:30:00 | AAPL | Stock | 4.735 | 4.76 | 4.7346 | 4.7582 | 13644988.0 |
| 2007-08-01 13:35:00 | AAPL | Stock | 4.7579 | 4.7582 | 4.7429 | 4.7473 | 10599064.0 |
> showing 50 of 313,462 rows — these rows as CSV