PREVIEW / stock_5min / 2004-06-18
file: by_date/stock_5min/2004/2004-06-18.parquet size: 2.5 MB rows: 180,063 symbols: 1,786
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-06-18 08:00:00 | AAPL | Stock | 0.5839 | 0.5839 | 0.5839 | 0.5839 | 56000.0 |
| 2004-06-18 08:15:00 | AAPL | Stock | 0.5839 | 0.5839 | 0.5839 | 0.5839 | 39200.0 |
| 2004-06-18 08:30:00 | AAPL | Stock | 0.5813 | 0.5813 | 0.5813 | 0.5813 | 56000.0 |
| 2004-06-18 08:45:00 | AAPL | Stock | 0.5821 | 0.5821 | 0.5821 | 0.5821 | 112000.0 |
| 2004-06-18 08:50:00 | AAPL | Stock | 0.5821 | 0.5821 | 0.5821 | 0.5821 | 168000.0 |
| 2004-06-18 09:10:00 | AAPL | Stock | 0.5839 | 0.5839 | 0.5839 | 0.5839 | 56000.0 |
| 2004-06-18 09:15:00 | AAPL | Stock | 0.5856 | 0.5856 | 0.5856 | 0.5856 | 78400.0 |
| 2004-06-18 09:20:00 | AAPL | Stock | 0.5856 | 0.5856 | 0.5856 | 0.5856 | 78400.0 |
| 2004-06-18 09:25:00 | AAPL | Stock | 0.583 | 0.583 | 0.5809 | 0.5821 | 948640.0 |
| 2004-06-18 09:30:00 | AAPL | Stock | 0.5818 | 0.5839 | 0.5791 | 0.5813 | 16729440.0 |
| 2004-06-18 09:35:00 | AAPL | Stock | 0.5816 | 0.5836 | 0.5814 | 0.5832 | 4029368.0 |
| 2004-06-18 09:40:00 | AAPL | Stock | 0.5832 | 0.5832 | 0.5814 | 0.5823 | 2721096.0 |
| 2004-06-18 09:45:00 | AAPL | Stock | 0.5823 | 0.5823 | 0.5811 | 0.582 | 5920488.0 |
| 2004-06-18 09:50:00 | AAPL | Stock | 0.582 | 0.5832 | 0.5816 | 0.5827 | 3484992.0 |
| 2004-06-18 09:55:00 | AAPL | Stock | 0.5825 | 0.5827 | 0.5805 | 0.5805 | 2993480.0 |
| 2004-06-18 10:00:00 | AAPL | Stock | 0.5807 | 0.583 | 0.5805 | 0.583 | 4094496.0 |
| 2004-06-18 10:05:00 | AAPL | Stock | 0.5829 | 0.5888 | 0.5829 | 0.5861 | 10589208.0 |
| 2004-06-18 10:10:00 | AAPL | Stock | 0.5861 | 0.5868 | 0.5845 | 0.5864 | 4945192.0 |
| 2004-06-18 10:15:00 | AAPL | Stock | 0.5859 | 0.5875 | 0.5855 | 0.5861 | 4992680.0 |
| 2004-06-18 10:20:00 | AAPL | Stock | 0.5859 | 0.5868 | 0.585 | 0.5863 | 2745344.0 |
| 2004-06-18 10:25:00 | AAPL | Stock | 0.5863 | 0.587 | 0.5863 | 0.587 | 3294480.0 |
| 2004-06-18 10:30:00 | AAPL | Stock | 0.587 | 0.5904 | 0.587 | 0.59 | 9283848.0 |
| 2004-06-18 10:35:00 | AAPL | Stock | 0.59 | 0.5902 | 0.5875 | 0.5888 | 3331104.0 |
| 2004-06-18 10:40:00 | AAPL | Stock | 0.5885 | 0.5893 | 0.5879 | 0.5888 | 3170440.0 |
| 2004-06-18 10:45:00 | AAPL | Stock | 0.5886 | 0.5888 | 0.5879 | 0.5882 | 1432760.0 |
| 2004-06-18 10:50:00 | AAPL | Stock | 0.5882 | 0.5893 | 0.5875 | 0.5889 | 3834096.0 |
| 2004-06-18 10:55:00 | AAPL | Stock | 0.5888 | 0.5888 | 0.5875 | 0.5882 | 1781192.0 |
| 2004-06-18 11:00:00 | AAPL | Stock | 0.588 | 0.5891 | 0.5879 | 0.5888 | 1569904.0 |
| 2004-06-18 11:05:00 | AAPL | Stock | 0.5888 | 0.5888 | 0.5886 | 0.5886 | 1528016.0 |
| 2004-06-18 11:10:00 | AAPL | Stock | 0.5888 | 0.5889 | 0.588 | 0.5882 | 2238320.0 |
| 2004-06-18 11:15:00 | AAPL | Stock | 0.5882 | 0.5889 | 0.588 | 0.5889 | 2656528.0 |
| 2004-06-18 11:20:00 | AAPL | Stock | 0.5889 | 0.5911 | 0.5888 | 0.5893 | 11876760.0 |
| 2004-06-18 11:25:00 | AAPL | Stock | 0.5893 | 0.5893 | 0.5888 | 0.5889 | 2367736.0 |
| 2004-06-18 11:30:00 | AAPL | Stock | 0.5889 | 0.5907 | 0.5889 | 0.5891 | 4668496.0 |
| 2004-06-18 11:35:00 | AAPL | Stock | 0.5895 | 0.5911 | 0.5893 | 0.5904 | 2913120.0 |
| 2004-06-18 11:40:00 | AAPL | Stock | 0.5906 | 0.5913 | 0.59 | 0.5905 | 8219288.0 |
| 2004-06-18 11:45:00 | AAPL | Stock | 0.5904 | 0.5904 | 0.5891 | 0.5895 | 3779608.0 |
| 2004-06-18 11:50:00 | AAPL | Stock | 0.5893 | 0.59 | 0.5891 | 0.5893 | 1854496.0 |
| 2004-06-18 11:55:00 | AAPL | Stock | 0.5893 | 0.5893 | 0.5886 | 0.5886 | 3008320.0 |
| 2004-06-18 12:00:00 | AAPL | Stock | 0.5888 | 0.5891 | 0.5886 | 0.5887 | 964320.0 |
| 2004-06-18 12:05:00 | AAPL | Stock | 0.5886 | 0.5888 | 0.5884 | 0.5884 | 2246328.0 |
| 2004-06-18 12:10:00 | AAPL | Stock | 0.5886 | 0.5896 | 0.5884 | 0.5893 | 4044544.0 |
| 2004-06-18 12:15:00 | AAPL | Stock | 0.5893 | 0.5893 | 0.5884 | 0.5889 | 1424024.0 |
| 2004-06-18 12:20:00 | AAPL | Stock | 0.5888 | 0.5893 | 0.5884 | 0.5889 | 1622488.0 |
| 2004-06-18 12:25:00 | AAPL | Stock | 0.5891 | 0.5893 | 0.5888 | 0.5893 | 4015704.0 |
| 2004-06-18 12:30:00 | AAPL | Stock | 0.5891 | 0.5895 | 0.5888 | 0.5893 | 4127984.0 |
| 2004-06-18 12:35:00 | AAPL | Stock | 0.5893 | 0.5896 | 0.5893 | 0.5894 | 2717680.0 |
| 2004-06-18 12:40:00 | AAPL | Stock | 0.5895 | 0.5896 | 0.5893 | 0.5895 | 1724520.0 |
| 2004-06-18 12:45:00 | AAPL | Stock | 0.5893 | 0.5895 | 0.5889 | 0.5891 | 3949568.0 |
| 2004-06-18 12:50:00 | AAPL | Stock | 0.5891 | 0.5893 | 0.5889 | 0.5891 | 1417024.0 |
> showing 50 of 180,063 rows — these rows as CSV