PREVIEW / stock_5min / 2004-05-18
file: by_date/stock_5min/2004/2004-05-18.parquet size: 2.3 MB rows: 172,682 symbols: 1,774
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-05-18 08:00:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.4821 | 0.4821 | 11200.0 |
| 2004-05-18 08:30:00 | AAPL | Stock | 0.4816 | 0.482 | 0.4816 | 0.482 | 28000.0 |
| 2004-05-18 09:10:00 | AAPL | Stock | 0.4757 | 0.4757 | 0.4757 | 0.4757 | 2856000.0 |
| 2004-05-18 09:15:00 | AAPL | Stock | 0.482 | 0.4821 | 0.4814 | 0.4814 | 25200.0 |
| 2004-05-18 09:25:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.4814 | 0.4814 | 44800.0 |
| 2004-05-18 09:30:00 | AAPL | Stock | 0.4816 | 0.4821 | 0.4795 | 0.4816 | 3849048.0 |
| 2004-05-18 09:35:00 | AAPL | Stock | 0.4814 | 0.4821 | 0.4798 | 0.4807 | 2315096.0 |
| 2004-05-18 09:40:00 | AAPL | Stock | 0.4807 | 0.482 | 0.4788 | 0.4804 | 3442656.0 |
| 2004-05-18 09:45:00 | AAPL | Stock | 0.4804 | 0.4811 | 0.4798 | 0.4804 | 5433400.0 |
| 2004-05-18 09:50:00 | AAPL | Stock | 0.4804 | 0.4807 | 0.4791 | 0.48 | 4191936.0 |
| 2004-05-18 09:55:00 | AAPL | Stock | 0.48 | 0.4811 | 0.4798 | 0.4809 | 3143504.0 |
| 2004-05-18 10:00:00 | AAPL | Stock | 0.4805 | 0.4809 | 0.4789 | 0.4804 | 5528376.0 |
| 2004-05-18 10:05:00 | AAPL | Stock | 0.4802 | 0.4807 | 0.4798 | 0.4804 | 985824.0 |
| 2004-05-18 10:10:00 | AAPL | Stock | 0.4804 | 0.4807 | 0.4796 | 0.4802 | 1106056.0 |
| 2004-05-18 10:15:00 | AAPL | Stock | 0.4802 | 0.4804 | 0.4786 | 0.4796 | 2175096.0 |
| 2004-05-18 10:20:00 | AAPL | Stock | 0.4796 | 0.4804 | 0.4791 | 0.4795 | 2350264.0 |
| 2004-05-18 10:25:00 | AAPL | Stock | 0.4795 | 0.48 | 0.4786 | 0.4795 | 2456608.0 |
| 2004-05-18 10:30:00 | AAPL | Stock | 0.4793 | 0.4795 | 0.4788 | 0.4791 | 2604056.0 |
| 2004-05-18 10:35:00 | AAPL | Stock | 0.4795 | 0.4807 | 0.4791 | 0.4807 | 2915976.0 |
| 2004-05-18 10:40:00 | AAPL | Stock | 0.4804 | 0.482 | 0.4802 | 0.482 | 3115112.0 |
| 2004-05-18 10:45:00 | AAPL | Stock | 0.4818 | 0.4829 | 0.4816 | 0.4829 | 6858880.0 |
| 2004-05-18 10:50:00 | AAPL | Stock | 0.483 | 0.4848 | 0.4823 | 0.4848 | 4816448.0 |
| 2004-05-18 10:55:00 | AAPL | Stock | 0.4845 | 0.4855 | 0.4839 | 0.4843 | 4694312.0 |
| 2004-05-18 11:00:00 | AAPL | Stock | 0.4843 | 0.4846 | 0.4839 | 0.4843 | 2662296.0 |
| 2004-05-18 11:05:00 | AAPL | Stock | 0.4841 | 0.4846 | 0.4838 | 0.4845 | 2370312.0 |
| 2004-05-18 11:10:00 | AAPL | Stock | 0.4845 | 0.4845 | 0.4832 | 0.4843 | 2054024.0 |
| 2004-05-18 11:15:00 | AAPL | Stock | 0.4841 | 0.4848 | 0.4836 | 0.4848 | 2646560.0 |
| 2004-05-18 11:20:00 | AAPL | Stock | 0.4846 | 0.4854 | 0.4836 | 0.4836 | 4000080.0 |
| 2004-05-18 11:25:00 | AAPL | Stock | 0.4838 | 0.4843 | 0.4825 | 0.4834 | 3028816.0 |
| 2004-05-18 11:30:00 | AAPL | Stock | 0.483 | 0.4838 | 0.4829 | 0.483 | 1650880.0 |
| 2004-05-18 11:35:00 | AAPL | Stock | 0.4832 | 0.4834 | 0.4827 | 0.483 | 1729336.0 |
| 2004-05-18 11:40:00 | AAPL | Stock | 0.483 | 0.4832 | 0.4821 | 0.4829 | 2636984.0 |
| 2004-05-18 11:45:00 | AAPL | Stock | 0.4829 | 0.4832 | 0.4823 | 0.483 | 970424.0 |
| 2004-05-18 11:50:00 | AAPL | Stock | 0.483 | 0.4838 | 0.4829 | 0.4834 | 776832.0 |
| 2004-05-18 11:55:00 | AAPL | Stock | 0.4834 | 0.4839 | 0.4829 | 0.4829 | 1507240.0 |
| 2004-05-18 12:00:00 | AAPL | Stock | 0.4829 | 0.4832 | 0.4825 | 0.4829 | 1135904.0 |
| 2004-05-18 12:05:00 | AAPL | Stock | 0.4825 | 0.4832 | 0.4818 | 0.4832 | 4282432.0 |
| 2004-05-18 12:10:00 | AAPL | Stock | 0.4834 | 0.4839 | 0.4834 | 0.4839 | 2231376.0 |
| 2004-05-18 12:15:00 | AAPL | Stock | 0.4836 | 0.4852 | 0.4836 | 0.4839 | 3107552.0 |
| 2004-05-18 12:20:00 | AAPL | Stock | 0.4839 | 0.4852 | 0.4839 | 0.485 | 1469552.0 |
| 2004-05-18 12:25:00 | AAPL | Stock | 0.485 | 0.4866 | 0.485 | 0.4866 | 4132520.0 |
| 2004-05-18 12:30:00 | AAPL | Stock | 0.4866 | 0.4873 | 0.4859 | 0.4861 | 3344488.0 |
| 2004-05-18 12:35:00 | AAPL | Stock | 0.4864 | 0.4866 | 0.4861 | 0.4863 | 1274784.0 |
| 2004-05-18 12:40:00 | AAPL | Stock | 0.4863 | 0.487 | 0.4863 | 0.4864 | 1780800.0 |
| 2004-05-18 12:45:00 | AAPL | Stock | 0.4866 | 0.4873 | 0.4863 | 0.4868 | 3780000.0 |
| 2004-05-18 12:50:00 | AAPL | Stock | 0.4866 | 0.4868 | 0.4863 | 0.4864 | 473200.0 |
| 2004-05-18 12:55:00 | AAPL | Stock | 0.4866 | 0.4866 | 0.4857 | 0.4857 | 1416800.0 |
| 2004-05-18 13:00:00 | AAPL | Stock | 0.4857 | 0.4861 | 0.4841 | 0.4859 | 1192688.0 |
| 2004-05-18 13:05:00 | AAPL | Stock | 0.4861 | 0.4864 | 0.4852 | 0.4859 | 913864.0 |
| 2004-05-18 13:10:00 | AAPL | Stock | 0.4859 | 0.4859 | 0.4846 | 0.485 | 680792.0 |
> showing 50 of 172,682 rows — these rows as CSV