PREVIEW / stock_5min / 2010-06-10
file: by_date/stock_5min/2010/2010-06-10.parquet size: 4.7 MB rows: 324,139 symbols: 3,460
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-10 04:50:00 | AAPL | Stock | 8.7746 | 8.7746 | 8.7746 | 8.7746 | 2800.0 |
| 2010-06-10 05:15:00 | AAPL | Stock | 8.8114 | 8.8114 | 8.8114 | 8.8114 | 7644.0 |
| 2010-06-10 05:20:00 | AAPL | Stock | 8.8114 | 8.8114 | 8.7979 | 8.7979 | 14756.0 |
| 2010-06-10 05:25:00 | AAPL | Stock | 8.8018 | 8.8018 | 8.8018 | 8.8018 | 2800.0 |
| 2010-06-10 05:35:00 | AAPL | Stock | 8.7911 | 8.7911 | 8.7911 | 8.7911 | 2800.0 |
| 2010-06-10 05:40:00 | AAPL | Stock | 8.8018 | 8.8018 | 8.8018 | 8.8018 | 2800.0 |
| 2010-06-10 05:45:00 | AAPL | Stock | 8.8018 | 8.8018 | 8.8018 | 8.8018 | 2800.0 |
| 2010-06-10 06:25:00 | AAPL | Stock | 8.7857 | 8.7857 | 8.7857 | 8.7857 | 42000.0 |
| 2010-06-10 07:00:00 | AAPL | Stock | 8.7857 | 8.7857 | 8.7407 | 8.7857 | 22400.0 |
| 2010-06-10 07:05:00 | AAPL | Stock | 8.7857 | 8.7929 | 8.7786 | 8.7786 | 40180.0 |
| 2010-06-10 07:10:00 | AAPL | Stock | 8.7839 | 8.7839 | 8.7839 | 8.7839 | 2800.0 |
| 2010-06-10 07:15:00 | AAPL | Stock | 8.775 | 8.775 | 8.775 | 8.775 | 2800.0 |
| 2010-06-10 07:20:00 | AAPL | Stock | 8.7761 | 8.7914 | 8.7761 | 8.7857 | 84000.0 |
| 2010-06-10 07:25:00 | AAPL | Stock | 8.7761 | 8.7821 | 8.7757 | 8.7821 | 67872.0 |
| 2010-06-10 07:30:00 | AAPL | Stock | 8.7814 | 8.7857 | 8.7814 | 8.7814 | 68600.0 |
| 2010-06-10 07:35:00 | AAPL | Stock | 8.7721 | 8.7721 | 8.7571 | 8.7607 | 101556.0 |
| 2010-06-10 07:40:00 | AAPL | Stock | 8.7507 | 8.7607 | 8.7296 | 8.7296 | 208040.0 |
| 2010-06-10 07:45:00 | AAPL | Stock | 8.7304 | 8.7318 | 8.7096 | 8.7304 | 117600.0 |
| 2010-06-10 07:50:00 | AAPL | Stock | 8.7239 | 8.7239 | 8.6929 | 8.7143 | 159040.0 |
| 2010-06-10 07:55:00 | AAPL | Stock | 8.7421 | 8.7421 | 8.7161 | 8.7179 | 55552.0 |
| 2010-06-10 08:00:00 | AAPL | Stock | 8.7143 | 8.7411 | 8.7064 | 8.7257 | 700196.0 |
| 2010-06-10 08:05:00 | AAPL | Stock | 8.725 | 8.7468 | 8.725 | 8.7386 | 714896.0 |
| 2010-06-10 08:10:00 | AAPL | Stock | 8.7411 | 8.7457 | 8.7332 | 8.7432 | 241724.0 |
| 2010-06-10 08:15:00 | AAPL | Stock | 8.7454 | 8.7511 | 8.7418 | 8.7493 | 306124.0 |
| 2010-06-10 08:20:00 | AAPL | Stock | 8.7486 | 8.7489 | 8.7346 | 8.7443 | 293916.0 |
| 2010-06-10 08:25:00 | AAPL | Stock | 8.7446 | 8.75 | 8.7446 | 8.75 | 69440.0 |
| 2010-06-10 08:30:00 | AAPL | Stock | 8.75 | 8.7655 | 8.7464 | 8.7571 | 392084.0 |
| 2010-06-10 08:35:00 | AAPL | Stock | 8.7593 | 8.7604 | 8.7393 | 8.7393 | 302512.0 |
| 2010-06-10 08:40:00 | AAPL | Stock | 8.7396 | 8.7396 | 8.7143 | 8.7143 | 524832.0 |
| 2010-06-10 08:45:00 | AAPL | Stock | 8.715 | 8.7211 | 8.7036 | 8.7211 | 285656.0 |
| 2010-06-10 08:50:00 | AAPL | Stock | 8.72 | 8.7232 | 8.7179 | 8.7232 | 303660.0 |
| 2010-06-10 08:55:00 | AAPL | Stock | 8.7232 | 8.7232 | 8.7187 | 8.7221 | 328832.0 |
| 2010-06-10 09:00:00 | AAPL | Stock | 8.7189 | 8.7393 | 8.7189 | 8.7357 | 537684.0 |
| 2010-06-10 09:05:00 | AAPL | Stock | 8.7379 | 8.755 | 8.7357 | 8.7493 | 228788.0 |
| 2010-06-10 09:10:00 | AAPL | Stock | 8.7482 | 8.7586 | 8.7411 | 8.7496 | 395528.0 |
| 2010-06-10 09:15:00 | AAPL | Stock | 8.7496 | 8.7557 | 8.7482 | 8.7543 | 907704.0 |
| 2010-06-10 09:20:00 | AAPL | Stock | 8.7511 | 8.7657 | 8.75 | 8.7629 | 762888.0 |
| 2010-06-10 09:25:00 | AAPL | Stock | 8.7625 | 8.7679 | 8.7339 | 8.7379 | 742840.0 |
| 2010-06-10 09:30:00 | AAPL | Stock | 8.7382 | 8.7857 | 8.7268 | 8.7539 | 24282440.0 |
| 2010-06-10 09:35:00 | AAPL | Stock | 8.7507 | 8.7607 | 8.6529 | 8.6786 | 27845720.0 |
| 2010-06-10 09:40:00 | AAPL | Stock | 8.6739 | 8.7021 | 8.65 | 8.6732 | 19421192.0 |
| 2010-06-10 09:45:00 | AAPL | Stock | 8.6754 | 8.7311 | 8.6643 | 8.7303 | 19110112.0 |
| 2010-06-10 09:50:00 | AAPL | Stock | 8.7282 | 8.7679 | 8.7257 | 8.7454 | 23577372.0 |
| 2010-06-10 09:55:00 | AAPL | Stock | 8.7475 | 8.7568 | 8.715 | 8.7546 | 12807480.0 |
| 2010-06-10 10:00:00 | AAPL | Stock | 8.7539 | 8.7836 | 8.75 | 8.7732 | 21106148.0 |
| 2010-06-10 10:05:00 | AAPL | Stock | 8.7732 | 8.7946 | 8.7654 | 8.7743 | 17977568.0 |
| 2010-06-10 10:10:00 | AAPL | Stock | 8.7737 | 8.7857 | 8.7525 | 8.7846 | 11174856.0 |
| 2010-06-10 10:15:00 | AAPL | Stock | 8.7854 | 8.8014 | 8.7643 | 8.7989 | 13395060.0 |
| 2010-06-10 10:20:00 | AAPL | Stock | 8.7993 | 8.8161 | 8.7793 | 8.8004 | 13776700.0 |
| 2010-06-10 10:25:00 | AAPL | Stock | 8.8018 | 8.8061 | 8.7679 | 8.7804 | 13485416.0 |
> showing 50 of 324,139 rows — these rows as CSV