PREVIEW / stock_5min / 2004-04-01
file: by_date/stock_5min/2004/2004-04-01.parquet size: 2.4 MB rows: 176,477 symbols: 1,760
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-01 08:00:00 | AAPL | Stock | 0.483 | 0.4839 | 0.483 | 0.4839 | 28392.0 |
| 2004-04-01 08:05:00 | AAPL | Stock | 0.4811 | 0.4811 | 0.4811 | 0.4811 | 112000.0 |
| 2004-04-01 08:30:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.4821 | 0.4821 | 16800.0 |
| 2004-04-01 08:55:00 | AAPL | Stock | 0.4821 | 0.483 | 0.4821 | 0.483 | 156800.0 |
| 2004-04-01 09:00:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.4821 | 0.4821 | 5600.0 |
| 2004-04-01 09:20:00 | AAPL | Stock | 0.4827 | 0.4827 | 0.4827 | 0.4827 | 5600.0 |
| 2004-04-01 09:25:00 | AAPL | Stock | 0.4827 | 0.4827 | 0.4804 | 0.4814 | 425600.0 |
| 2004-04-01 09:30:00 | AAPL | Stock | 0.4802 | 0.4829 | 0.4754 | 0.4805 | 10784368.0 |
| 2004-04-01 09:35:00 | AAPL | Stock | 0.4807 | 0.483 | 0.4795 | 0.4804 | 9588488.0 |
| 2004-04-01 09:40:00 | AAPL | Stock | 0.4804 | 0.4832 | 0.4802 | 0.4829 | 5473216.0 |
| 2004-04-01 09:45:00 | AAPL | Stock | 0.483 | 0.487 | 0.4829 | 0.4846 | 8009008.0 |
| 2004-04-01 09:50:00 | AAPL | Stock | 0.4843 | 0.485 | 0.482 | 0.482 | 4464880.0 |
| 2004-04-01 09:55:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.4813 | 0.4814 | 3625664.0 |
| 2004-04-01 10:00:00 | AAPL | Stock | 0.4816 | 0.4821 | 0.4789 | 0.4798 | 8396584.0 |
| 2004-04-01 10:05:00 | AAPL | Stock | 0.4802 | 0.4807 | 0.4795 | 0.4798 | 9948960.0 |
| 2004-04-01 10:10:00 | AAPL | Stock | 0.48 | 0.4807 | 0.4798 | 0.4804 | 6414072.0 |
| 2004-04-01 10:15:00 | AAPL | Stock | 0.4804 | 0.4821 | 0.4804 | 0.4821 | 3735144.0 |
| 2004-04-01 10:20:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.4813 | 0.4818 | 4400536.0 |
| 2004-04-01 10:25:00 | AAPL | Stock | 0.4816 | 0.4816 | 0.4805 | 0.4814 | 3942512.0 |
| 2004-04-01 10:30:00 | AAPL | Stock | 0.4814 | 0.482 | 0.4813 | 0.4816 | 5373480.0 |
| 2004-04-01 10:35:00 | AAPL | Stock | 0.4816 | 0.4818 | 0.4813 | 0.4813 | 3115728.0 |
| 2004-04-01 10:40:00 | AAPL | Stock | 0.4811 | 0.4814 | 0.4809 | 0.4813 | 6858600.0 |
| 2004-04-01 10:45:00 | AAPL | Stock | 0.4813 | 0.483 | 0.4811 | 0.483 | 8086064.0 |
| 2004-04-01 10:50:00 | AAPL | Stock | 0.483 | 0.4855 | 0.4829 | 0.4848 | 6727784.0 |
| 2004-04-01 10:55:00 | AAPL | Stock | 0.4848 | 0.4848 | 0.4832 | 0.4832 | 3509632.0 |
| 2004-04-01 11:00:00 | AAPL | Stock | 0.4834 | 0.4834 | 0.4795 | 0.4798 | 6058248.0 |
| 2004-04-01 11:05:00 | AAPL | Stock | 0.4795 | 0.4807 | 0.4795 | 0.48 | 7456456.0 |
| 2004-04-01 11:10:00 | AAPL | Stock | 0.4798 | 0.48 | 0.4793 | 0.4796 | 1800792.0 |
| 2004-04-01 11:15:00 | AAPL | Stock | 0.4796 | 0.4796 | 0.4793 | 0.4795 | 4372816.0 |
| 2004-04-01 11:20:00 | AAPL | Stock | 0.4793 | 0.4798 | 0.4793 | 0.4796 | 1656536.0 |
| 2004-04-01 11:25:00 | AAPL | Stock | 0.4796 | 0.4796 | 0.4791 | 0.4795 | 1643376.0 |
| 2004-04-01 11:30:00 | AAPL | Stock | 0.4793 | 0.4796 | 0.4793 | 0.4796 | 2599576.0 |
| 2004-04-01 11:35:00 | AAPL | Stock | 0.4796 | 0.4805 | 0.4795 | 0.48 | 6081488.0 |
| 2004-04-01 11:40:00 | AAPL | Stock | 0.48 | 0.4809 | 0.48 | 0.48 | 2004240.0 |
| 2004-04-01 11:45:00 | AAPL | Stock | 0.48 | 0.48 | 0.4795 | 0.4796 | 1765008.0 |
| 2004-04-01 11:50:00 | AAPL | Stock | 0.4795 | 0.4805 | 0.4795 | 0.4802 | 839720.0 |
| 2004-04-01 11:55:00 | AAPL | Stock | 0.4804 | 0.4805 | 0.4802 | 0.4804 | 833560.0 |
| 2004-04-01 12:00:00 | AAPL | Stock | 0.4805 | 0.4807 | 0.4804 | 0.4804 | 1068480.0 |
| 2004-04-01 12:05:00 | AAPL | Stock | 0.4804 | 0.4804 | 0.4793 | 0.4802 | 1824592.0 |
| 2004-04-01 12:10:00 | AAPL | Stock | 0.48 | 0.4804 | 0.48 | 0.4802 | 893144.0 |
| 2004-04-01 12:15:00 | AAPL | Stock | 0.4802 | 0.4804 | 0.48 | 0.4804 | 2127776.0 |
| 2004-04-01 12:20:00 | AAPL | Stock | 0.4804 | 0.4804 | 0.4795 | 0.4796 | 968632.0 |
| 2004-04-01 12:25:00 | AAPL | Stock | 0.4796 | 0.4809 | 0.4795 | 0.4805 | 1591520.0 |
| 2004-04-01 12:30:00 | AAPL | Stock | 0.4809 | 0.4809 | 0.4804 | 0.4804 | 1519000.0 |
| 2004-04-01 12:35:00 | AAPL | Stock | 0.4804 | 0.4805 | 0.4795 | 0.4798 | 940072.0 |
| 2004-04-01 12:40:00 | AAPL | Stock | 0.4796 | 0.4804 | 0.4795 | 0.4795 | 1562960.0 |
| 2004-04-01 12:45:00 | AAPL | Stock | 0.4795 | 0.4795 | 0.4789 | 0.4791 | 2680608.0 |
| 2004-04-01 12:50:00 | AAPL | Stock | 0.4796 | 0.4805 | 0.4789 | 0.4793 | 2378824.0 |
| 2004-04-01 12:55:00 | AAPL | Stock | 0.4789 | 0.4793 | 0.4786 | 0.4789 | 3488800.0 |
| 2004-04-01 13:00:00 | AAPL | Stock | 0.4788 | 0.48 | 0.4786 | 0.48 | 2000936.0 |
> showing 50 of 176,477 rows — these rows as CSV