PREVIEW / stock_1min / 2007-08-27
file: by_date/stock_1min/2007/2007-08-27.parquet size: 10.8 MB rows: 892,061 symbols: 2,549
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-27 09:30:00 | AAPL | Stock | 4.764 | 4.78 | 4.7625 | 4.7643 | 7605444.0 |
| 2007-08-27 09:31:00 | AAPL | Stock | 4.7654 | 4.7696 | 4.7529 | 4.7596 | 7175112.0 |
| 2007-08-27 09:32:00 | AAPL | Stock | 4.7596 | 4.7607 | 4.7429 | 4.7429 | 10609508.0 |
| 2007-08-27 09:33:00 | AAPL | Stock | 4.7429 | 4.7543 | 4.74 | 4.7471 | 6141800.0 |
| 2007-08-27 09:34:00 | AAPL | Stock | 4.7471 | 4.7554 | 4.7421 | 4.7543 | 7111244.0 |
| 2007-08-27 09:35:00 | AAPL | Stock | 4.7546 | 4.7625 | 4.7506 | 4.7614 | 6231988.0 |
| 2007-08-27 09:36:00 | AAPL | Stock | 4.7607 | 4.7625 | 4.7571 | 4.761 | 4349296.0 |
| 2007-08-27 09:37:00 | AAPL | Stock | 4.7611 | 4.7704 | 4.7597 | 4.7654 | 6222104.0 |
| 2007-08-27 09:38:00 | AAPL | Stock | 4.7646 | 4.7696 | 4.7625 | 4.765 | 4780664.0 |
| 2007-08-27 09:39:00 | AAPL | Stock | 4.7657 | 4.7657 | 4.7532 | 4.7554 | 4752468.0 |
| 2007-08-27 09:40:00 | AAPL | Stock | 4.755 | 4.755 | 4.7429 | 4.7464 | 7807688.0 |
| 2007-08-27 09:41:00 | AAPL | Stock | 4.7468 | 4.7507 | 4.7446 | 4.7471 | 4114852.0 |
| 2007-08-27 09:42:00 | AAPL | Stock | 4.7468 | 4.7586 | 4.7464 | 4.7532 | 3858820.0 |
| 2007-08-27 09:43:00 | AAPL | Stock | 4.7529 | 4.7571 | 4.7518 | 4.7539 | 2527392.0 |
| 2007-08-27 09:44:00 | AAPL | Stock | 4.7543 | 4.755 | 4.7476 | 4.7532 | 1562932.0 |
| 2007-08-27 09:45:00 | AAPL | Stock | 4.7529 | 4.7536 | 4.7461 | 4.7532 | 3193344.0 |
| 2007-08-27 09:46:00 | AAPL | Stock | 4.7532 | 4.7552 | 4.7514 | 4.7518 | 2337720.0 |
| 2007-08-27 09:47:00 | AAPL | Stock | 4.7522 | 4.7546 | 4.75 | 4.7507 | 2540804.0 |
| 2007-08-27 09:48:00 | AAPL | Stock | 4.7507 | 4.7561 | 4.7504 | 4.7546 | 2344972.0 |
| 2007-08-27 09:49:00 | AAPL | Stock | 4.7539 | 4.7589 | 4.7536 | 4.7568 | 2488080.0 |
| 2007-08-27 09:50:00 | AAPL | Stock | 4.7561 | 4.7571 | 4.75 | 4.7518 | 2659384.0 |
| 2007-08-27 09:51:00 | AAPL | Stock | 4.7511 | 4.7521 | 4.7479 | 4.75 | 1936844.0 |
| 2007-08-27 09:52:00 | AAPL | Stock | 4.75 | 4.755 | 4.7489 | 4.7546 | 2209172.0 |
| 2007-08-27 09:53:00 | AAPL | Stock | 4.755 | 4.7579 | 4.7532 | 4.7575 | 2013592.0 |
| 2007-08-27 09:54:00 | AAPL | Stock | 4.7571 | 4.7618 | 4.7571 | 4.76 | 2853620.0 |
| 2007-08-27 09:55:00 | AAPL | Stock | 4.76 | 4.7618 | 4.7591 | 4.76 | 2222668.0 |
| 2007-08-27 09:56:00 | AAPL | Stock | 4.7604 | 4.7654 | 4.7604 | 4.7643 | 3172400.0 |
| 2007-08-27 09:57:00 | AAPL | Stock | 4.7646 | 4.7704 | 4.7643 | 4.7671 | 3130232.0 |
| 2007-08-27 09:58:00 | AAPL | Stock | 4.7671 | 4.7779 | 4.7671 | 4.7775 | 3898048.0 |
| 2007-08-27 09:59:00 | AAPL | Stock | 4.7775 | 4.7786 | 4.7732 | 4.7743 | 5039300.0 |
| 2007-08-27 10:00:00 | AAPL | Stock | 4.7746 | 4.7875 | 4.7736 | 4.7804 | 6586832.0 |
| 2007-08-27 10:01:00 | AAPL | Stock | 4.7807 | 4.7807 | 4.7686 | 4.77 | 4948636.0 |
| 2007-08-27 10:02:00 | AAPL | Stock | 4.7693 | 4.77 | 4.7646 | 4.765 | 3967124.0 |
| 2007-08-27 10:03:00 | AAPL | Stock | 4.7654 | 4.7757 | 4.7643 | 4.7752 | 3516492.0 |
| 2007-08-27 10:04:00 | AAPL | Stock | 4.7743 | 4.7804 | 4.7679 | 4.7704 | 3387412.0 |
| 2007-08-27 10:05:00 | AAPL | Stock | 4.7707 | 4.7736 | 4.7625 | 4.7632 | 2584652.0 |
| 2007-08-27 10:06:00 | AAPL | Stock | 4.7639 | 4.7671 | 4.7618 | 4.7643 | 2476796.0 |
| 2007-08-27 10:07:00 | AAPL | Stock | 4.7643 | 4.7704 | 4.7629 | 4.765 | 1977220.0 |
| 2007-08-27 10:08:00 | AAPL | Stock | 4.7654 | 4.7693 | 4.7654 | 4.7675 | 1413020.0 |
| 2007-08-27 10:09:00 | AAPL | Stock | 4.7664 | 4.7671 | 4.7611 | 4.7611 | 2975924.0 |
| 2007-08-27 10:10:00 | AAPL | Stock | 4.7618 | 4.7632 | 4.7564 | 4.7611 | 2401812.0 |
| 2007-08-27 10:11:00 | AAPL | Stock | 4.7614 | 4.77 | 4.7611 | 4.77 | 1602832.0 |
| 2007-08-27 10:12:00 | AAPL | Stock | 4.77 | 4.7768 | 4.7689 | 4.7732 | 2103388.0 |
| 2007-08-27 10:13:00 | AAPL | Stock | 4.7729 | 4.7739 | 4.7661 | 4.7661 | 1714440.0 |
| 2007-08-27 10:14:00 | AAPL | Stock | 4.7661 | 4.77 | 4.765 | 4.7686 | 700980.0 |
| 2007-08-27 10:15:00 | AAPL | Stock | 4.7679 | 4.7695 | 4.7679 | 4.7695 | 1044596.0 |
| 2007-08-27 10:16:00 | AAPL | Stock | 4.7689 | 4.7714 | 4.7689 | 4.7707 | 900704.0 |
| 2007-08-27 10:17:00 | AAPL | Stock | 4.7707 | 4.7786 | 4.7707 | 4.7743 | 1799392.0 |
| 2007-08-27 10:18:00 | AAPL | Stock | 4.775 | 4.7814 | 4.7743 | 4.78 | 2311036.0 |
| 2007-08-27 10:19:00 | AAPL | Stock | 4.78 | 4.7879 | 4.78 | 4.7857 | 4014220.0 |
> showing 50 of 892,061 rows — these rows as CSV