PREVIEW / stock_5min / 2007-03-28
file: by_date/stock_5min/2007/2007-03-28.parquet size: 3.5 MB rows: 252,821 symbols: 2,550
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-03-28 07:10:00 | AAPL | Stock | 3.405 | 3.4057 | 3.405 | 3.405 | 19600.0 |
| 2007-03-28 07:15:00 | AAPL | Stock | 3.405 | 3.405 | 3.4036 | 3.4036 | 39200.0 |
| 2007-03-28 07:35:00 | AAPL | Stock | 3.4018 | 3.4018 | 3.4018 | 3.4018 | 2800.0 |
| 2007-03-28 07:40:00 | AAPL | Stock | 3.3964 | 3.3964 | 3.3964 | 3.3964 | 16800.0 |
| 2007-03-28 07:45:00 | AAPL | Stock | 3.3964 | 3.3964 | 3.3964 | 3.3964 | 11200.0 |
| 2007-03-28 07:50:00 | AAPL | Stock | 3.3964 | 3.3964 | 3.3964 | 3.3964 | 56000.0 |
| 2007-03-28 07:55:00 | AAPL | Stock | 3.3971 | 3.3971 | 3.3964 | 3.3964 | 11200.0 |
| 2007-03-28 08:00:00 | AAPL | Stock | 3.3982 | 3.4036 | 3.3914 | 3.4036 | 1369144.0 |
| 2007-03-28 08:05:00 | AAPL | Stock | 3.4036 | 3.4036 | 3.3993 | 3.4021 | 202580.0 |
| 2007-03-28 08:10:00 | AAPL | Stock | 3.4021 | 3.4021 | 3.3964 | 3.3993 | 398636.0 |
| 2007-03-28 08:15:00 | AAPL | Stock | 3.3993 | 3.3993 | 3.3936 | 3.3946 | 257600.0 |
| 2007-03-28 08:20:00 | AAPL | Stock | 3.3954 | 3.3979 | 3.3946 | 3.3979 | 98000.0 |
| 2007-03-28 08:25:00 | AAPL | Stock | 3.3979 | 3.3979 | 3.3979 | 3.3979 | 26600.0 |
| 2007-03-28 08:30:00 | AAPL | Stock | 3.3961 | 3.3964 | 3.3936 | 3.3964 | 441392.0 |
| 2007-03-28 08:35:00 | AAPL | Stock | 3.3946 | 3.3993 | 3.3929 | 3.3964 | 341180.0 |
| 2007-03-28 08:40:00 | AAPL | Stock | 3.3939 | 3.3946 | 3.3936 | 3.3943 | 124600.0 |
| 2007-03-28 08:45:00 | AAPL | Stock | 3.3946 | 3.3957 | 3.3936 | 3.3936 | 256424.0 |
| 2007-03-28 08:50:00 | AAPL | Stock | 3.3929 | 3.3946 | 3.3929 | 3.3929 | 263088.0 |
| 2007-03-28 08:55:00 | AAPL | Stock | 3.3929 | 3.3932 | 3.3893 | 3.3929 | 273308.0 |
| 2007-03-28 09:00:00 | AAPL | Stock | 3.3896 | 3.3929 | 3.3893 | 3.3893 | 421988.0 |
| 2007-03-28 09:05:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.3893 | 3.3907 | 422016.0 |
| 2007-03-28 09:10:00 | AAPL | Stock | 3.3911 | 3.3918 | 3.3896 | 3.3896 | 156800.0 |
| 2007-03-28 09:15:00 | AAPL | Stock | 3.3918 | 3.3929 | 3.3896 | 3.3907 | 47320.0 |
| 2007-03-28 09:20:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.3911 | 3.3911 | 48720.0 |
| 2007-03-28 09:25:00 | AAPL | Stock | 3.3914 | 3.3925 | 3.3875 | 3.3875 | 1023232.0 |
| 2007-03-28 09:30:00 | AAPL | Stock | 3.3886 | 3.4036 | 3.3868 | 3.4032 | 23802576.0 |
| 2007-03-28 09:35:00 | AAPL | Stock | 3.4032 | 3.4068 | 3.3843 | 3.3857 | 26771892.0 |
| 2007-03-28 09:40:00 | AAPL | Stock | 3.3846 | 3.4029 | 3.3846 | 3.3979 | 19434492.0 |
| 2007-03-28 09:45:00 | AAPL | Stock | 3.4007 | 3.4036 | 3.395 | 3.3996 | 15253476.0 |
| 2007-03-28 09:50:00 | AAPL | Stock | 3.3991 | 3.4021 | 3.3911 | 3.3925 | 13617296.0 |
| 2007-03-28 09:55:00 | AAPL | Stock | 3.3925 | 3.3946 | 3.3893 | 3.3896 | 11860772.0 |
| 2007-03-28 10:00:00 | AAPL | Stock | 3.39 | 3.3961 | 3.3879 | 3.3961 | 11789904.0 |
| 2007-03-28 10:05:00 | AAPL | Stock | 3.3957 | 3.4007 | 3.3925 | 3.4007 | 12946136.0 |
| 2007-03-28 10:10:00 | AAPL | Stock | 3.4004 | 3.4014 | 3.3964 | 3.3993 | 8617140.0 |
| 2007-03-28 10:15:00 | AAPL | Stock | 3.3993 | 3.4071 | 3.3986 | 3.4054 | 14488152.0 |
| 2007-03-28 10:20:00 | AAPL | Stock | 3.4057 | 3.4068 | 3.3929 | 3.3939 | 11019904.0 |
| 2007-03-28 10:25:00 | AAPL | Stock | 3.3942 | 3.3975 | 3.3929 | 3.3968 | 5806304.0 |
| 2007-03-28 10:30:00 | AAPL | Stock | 3.3968 | 3.3968 | 3.3857 | 3.3882 | 17208576.0 |
| 2007-03-28 10:35:00 | AAPL | Stock | 3.3886 | 3.3921 | 3.38 | 3.3839 | 17858428.0 |
| 2007-03-28 10:40:00 | AAPL | Stock | 3.3839 | 3.3875 | 3.3818 | 3.3836 | 12264616.0 |
| 2007-03-28 10:45:00 | AAPL | Stock | 3.3836 | 3.3929 | 3.3786 | 3.3825 | 12635896.0 |
| 2007-03-28 10:50:00 | AAPL | Stock | 3.3821 | 3.3929 | 3.38 | 3.3875 | 12308212.0 |
| 2007-03-28 10:55:00 | AAPL | Stock | 3.3875 | 3.3921 | 3.3857 | 3.3886 | 10680824.0 |
| 2007-03-28 11:00:00 | AAPL | Stock | 3.3882 | 3.3925 | 3.3857 | 3.3914 | 7525084.0 |
| 2007-03-28 11:05:00 | AAPL | Stock | 3.3914 | 3.3975 | 3.3911 | 3.3957 | 11527796.0 |
| 2007-03-28 11:10:00 | AAPL | Stock | 3.3956 | 3.3975 | 3.3921 | 3.3936 | 9808260.0 |
| 2007-03-28 11:15:00 | AAPL | Stock | 3.3936 | 3.3957 | 3.3921 | 3.3957 | 4488736.0 |
| 2007-03-28 11:20:00 | AAPL | Stock | 3.3957 | 3.3957 | 3.3889 | 3.3904 | 8768536.0 |
| 2007-03-28 11:25:00 | AAPL | Stock | 3.3904 | 3.3925 | 3.3875 | 3.3914 | 5288024.0 |
| 2007-03-28 11:30:00 | AAPL | Stock | 3.3918 | 3.3946 | 3.3911 | 3.3925 | 4447772.0 |
> showing 50 of 252,821 rows — these rows as CSV