PREVIEW / stock_5min / 2004-04-27
file: by_date/stock_5min/2004/2004-04-27.parquet size: 2.5 MB rows: 179,856 symbols: 1,763
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 |
|---|---|---|---|---|---|---|---|
| 2004-04-27 08:00:00 | AAPL | Stock | 0.4846 | 0.4846 | 0.4846 | 0.4846 | 16800.0 |
| 2004-04-27 08:05:00 | AAPL | Stock | 0.4857 | 0.4857 | 0.4857 | 0.4857 | 5600.0 |
| 2004-04-27 08:40:00 | AAPL | Stock | 0.4857 | 0.4857 | 0.4854 | 0.4854 | 112000.0 |
| 2004-04-27 09:00:00 | AAPL | Stock | 0.4854 | 0.4854 | 0.4848 | 0.4848 | 39200.0 |
| 2004-04-27 09:15:00 | AAPL | Stock | 0.4843 | 0.4843 | 0.4843 | 0.4843 | 112000.0 |
| 2004-04-27 09:20:00 | AAPL | Stock | 0.4845 | 0.4845 | 0.4845 | 0.4845 | 476112.0 |
| 2004-04-27 09:25:00 | AAPL | Stock | 0.4846 | 0.4866 | 0.4846 | 0.4866 | 685552.0 |
| 2004-04-27 09:30:00 | AAPL | Stock | 0.4864 | 0.4882 | 0.4832 | 0.4875 | 5652864.0 |
| 2004-04-27 09:35:00 | AAPL | Stock | 0.4875 | 0.4875 | 0.4838 | 0.4839 | 3165624.0 |
| 2004-04-27 09:40:00 | AAPL | Stock | 0.4838 | 0.4839 | 0.4811 | 0.4821 | 12894224.0 |
| 2004-04-27 09:45:00 | AAPL | Stock | 0.4821 | 0.4823 | 0.4766 | 0.4779 | 12672688.0 |
| 2004-04-27 09:50:00 | AAPL | Stock | 0.4779 | 0.4795 | 0.4773 | 0.4784 | 10584000.0 |
| 2004-04-27 09:55:00 | AAPL | Stock | 0.4784 | 0.4798 | 0.478 | 0.4795 | 5467840.0 |
| 2004-04-27 10:00:00 | AAPL | Stock | 0.4793 | 0.4813 | 0.4786 | 0.4788 | 7098560.0 |
| 2004-04-27 10:05:00 | AAPL | Stock | 0.4788 | 0.4796 | 0.4779 | 0.4788 | 14673176.0 |
| 2004-04-27 10:10:00 | AAPL | Stock | 0.4788 | 0.4827 | 0.4786 | 0.4814 | 9533216.0 |
| 2004-04-27 10:15:00 | AAPL | Stock | 0.4816 | 0.4827 | 0.4814 | 0.4818 | 2548168.0 |
| 2004-04-27 10:20:00 | AAPL | Stock | 0.482 | 0.482 | 0.4796 | 0.4798 | 3202360.0 |
| 2004-04-27 10:25:00 | AAPL | Stock | 0.48 | 0.4818 | 0.4798 | 0.4809 | 1489768.0 |
| 2004-04-27 10:30:00 | AAPL | Stock | 0.4811 | 0.482 | 0.4796 | 0.4818 | 2539544.0 |
| 2004-04-27 10:35:00 | AAPL | Stock | 0.4816 | 0.4821 | 0.4807 | 0.4818 | 1189664.0 |
| 2004-04-27 10:40:00 | AAPL | Stock | 0.4818 | 0.4825 | 0.4814 | 0.482 | 1288112.0 |
| 2004-04-27 10:45:00 | AAPL | Stock | 0.4821 | 0.4825 | 0.4805 | 0.4811 | 2775752.0 |
| 2004-04-27 10:50:00 | AAPL | Stock | 0.4813 | 0.482 | 0.4807 | 0.4807 | 2736720.0 |
| 2004-04-27 10:55:00 | AAPL | Stock | 0.4807 | 0.4807 | 0.4786 | 0.48 | 4430048.0 |
| 2004-04-27 11:00:00 | AAPL | Stock | 0.48 | 0.48 | 0.478 | 0.479 | 2408504.0 |
| 2004-04-27 11:05:00 | AAPL | Stock | 0.4791 | 0.4809 | 0.4789 | 0.4804 | 1109808.0 |
| 2004-04-27 11:10:00 | AAPL | Stock | 0.4802 | 0.4805 | 0.4796 | 0.4796 | 644336.0 |
| 2004-04-27 11:15:00 | AAPL | Stock | 0.48 | 0.4814 | 0.48 | 0.48 | 1849064.0 |
| 2004-04-27 11:20:00 | AAPL | Stock | 0.4802 | 0.4811 | 0.4788 | 0.4789 | 3639664.0 |
| 2004-04-27 11:25:00 | AAPL | Stock | 0.4789 | 0.4804 | 0.4788 | 0.4788 | 3107720.0 |
| 2004-04-27 11:30:00 | AAPL | Stock | 0.4789 | 0.4795 | 0.4788 | 0.4788 | 2571296.0 |
| 2004-04-27 11:35:00 | AAPL | Stock | 0.479 | 0.4796 | 0.4788 | 0.4796 | 4445112.0 |
| 2004-04-27 11:40:00 | AAPL | Stock | 0.4796 | 0.4802 | 0.4795 | 0.48 | 1340248.0 |
| 2004-04-27 11:45:00 | AAPL | Stock | 0.4802 | 0.4809 | 0.4795 | 0.4805 | 1726368.0 |
| 2004-04-27 11:50:00 | AAPL | Stock | 0.4802 | 0.4821 | 0.48 | 0.4818 | 1969408.0 |
| 2004-04-27 11:55:00 | AAPL | Stock | 0.482 | 0.4829 | 0.4817 | 0.4821 | 1754480.0 |
| 2004-04-27 12:00:00 | AAPL | Stock | 0.4821 | 0.4825 | 0.4818 | 0.4818 | 1159872.0 |
| 2004-04-27 12:05:00 | AAPL | Stock | 0.482 | 0.4827 | 0.482 | 0.4825 | 2083928.0 |
| 2004-04-27 12:10:00 | AAPL | Stock | 0.4825 | 0.4836 | 0.4825 | 0.4836 | 1901368.0 |
| 2004-04-27 12:15:00 | AAPL | Stock | 0.4834 | 0.4839 | 0.4829 | 0.4838 | 3948392.0 |
| 2004-04-27 12:20:00 | AAPL | Stock | 0.4838 | 0.4839 | 0.483 | 0.4832 | 1236424.0 |
| 2004-04-27 12:25:00 | AAPL | Stock | 0.4832 | 0.4832 | 0.4829 | 0.483 | 2397752.0 |
| 2004-04-27 12:30:00 | AAPL | Stock | 0.483 | 0.483 | 0.4829 | 0.4829 | 630112.0 |
| 2004-04-27 12:35:00 | AAPL | Stock | 0.4829 | 0.4834 | 0.4829 | 0.483 | 3018008.0 |
| 2004-04-27 12:40:00 | AAPL | Stock | 0.483 | 0.483 | 0.4825 | 0.4825 | 432656.0 |
| 2004-04-27 12:45:00 | AAPL | Stock | 0.4825 | 0.4825 | 0.4821 | 0.4825 | 213528.0 |
| 2004-04-27 12:50:00 | AAPL | Stock | 0.4823 | 0.4823 | 0.482 | 0.4821 | 215992.0 |
| 2004-04-27 12:55:00 | AAPL | Stock | 0.4821 | 0.4827 | 0.482 | 0.4825 | 1932112.0 |
| 2004-04-27 13:00:00 | AAPL | Stock | 0.4827 | 0.4832 | 0.482 | 0.4821 | 1682296.0 |
> showing 50 of 179,856 rows — these rows as CSV