PREVIEW / stock_5min / 2004-06-02
file: by_date/stock_5min/2004/2004-06-02.parquet size: 2.3 MB rows: 174,021 symbols: 1,776
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-02 09:10:00 | AAPL | Stock | 0.5011 | 0.5011 | 0.5 | 0.5 | 3724000.0 |
| 2004-06-02 09:20:00 | AAPL | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 100800.0 |
| 2004-06-02 09:25:00 | AAPL | Stock | 0.4998 | 0.5005 | 0.4995 | 0.4995 | 179200.0 |
| 2004-06-02 09:30:00 | AAPL | Stock | 0.5005 | 0.5018 | 0.4995 | 0.5007 | 6041168.0 |
| 2004-06-02 09:35:00 | AAPL | Stock | 0.5007 | 0.5007 | 0.4975 | 0.5 | 4344424.0 |
| 2004-06-02 09:40:00 | AAPL | Stock | 0.4998 | 0.4998 | 0.4964 | 0.4996 | 2608984.0 |
| 2004-06-02 09:45:00 | AAPL | Stock | 0.4996 | 0.4998 | 0.4966 | 0.4982 | 2274496.0 |
| 2004-06-02 09:50:00 | AAPL | Stock | 0.4986 | 0.4998 | 0.4982 | 0.4993 | 2561888.0 |
| 2004-06-02 09:55:00 | AAPL | Stock | 0.4993 | 0.5011 | 0.4991 | 0.5 | 3851512.0 |
| 2004-06-02 10:00:00 | AAPL | Stock | 0.5002 | 0.5005 | 0.4984 | 0.4984 | 2015048.0 |
| 2004-06-02 10:05:00 | AAPL | Stock | 0.4986 | 0.5002 | 0.4984 | 0.5 | 2484888.0 |
| 2004-06-02 10:10:00 | AAPL | Stock | 0.5 | 0.5 | 0.4995 | 0.4998 | 1113000.0 |
| 2004-06-02 10:15:00 | AAPL | Stock | 0.4998 | 0.4998 | 0.4988 | 0.4988 | 619808.0 |
| 2004-06-02 10:20:00 | AAPL | Stock | 0.4988 | 0.4988 | 0.4984 | 0.4986 | 313600.0 |
| 2004-06-02 10:25:00 | AAPL | Stock | 0.4988 | 0.5016 | 0.4988 | 0.4995 | 3851568.0 |
| 2004-06-02 10:30:00 | AAPL | Stock | 0.4995 | 0.5025 | 0.4993 | 0.5025 | 4446680.0 |
| 2004-06-02 10:35:00 | AAPL | Stock | 0.5025 | 0.5043 | 0.5025 | 0.5028 | 3803968.0 |
| 2004-06-02 10:40:00 | AAPL | Stock | 0.5027 | 0.5041 | 0.5027 | 0.5027 | 3259088.0 |
| 2004-06-02 10:45:00 | AAPL | Stock | 0.5029 | 0.5043 | 0.5027 | 0.5038 | 3122112.0 |
| 2004-06-02 10:50:00 | AAPL | Stock | 0.5038 | 0.5043 | 0.5036 | 0.5039 | 1738576.0 |
| 2004-06-02 10:55:00 | AAPL | Stock | 0.5039 | 0.5041 | 0.503 | 0.503 | 2145360.0 |
| 2004-06-02 11:00:00 | AAPL | Stock | 0.503 | 0.5032 | 0.5025 | 0.5027 | 2589888.0 |
| 2004-06-02 11:05:00 | AAPL | Stock | 0.5027 | 0.5036 | 0.5027 | 0.5029 | 2881928.0 |
| 2004-06-02 11:10:00 | AAPL | Stock | 0.5032 | 0.5034 | 0.5027 | 0.5029 | 498400.0 |
| 2004-06-02 11:15:00 | AAPL | Stock | 0.5029 | 0.5029 | 0.5021 | 0.5025 | 1288000.0 |
| 2004-06-02 11:20:00 | AAPL | Stock | 0.5025 | 0.5027 | 0.5021 | 0.5023 | 995904.0 |
| 2004-06-02 11:25:00 | AAPL | Stock | 0.5021 | 0.5025 | 0.5013 | 0.5016 | 1596000.0 |
| 2004-06-02 11:30:00 | AAPL | Stock | 0.5016 | 0.5032 | 0.5013 | 0.5026 | 2292584.0 |
| 2004-06-02 11:35:00 | AAPL | Stock | 0.5027 | 0.5032 | 0.5027 | 0.5027 | 756952.0 |
| 2004-06-02 11:40:00 | AAPL | Stock | 0.5027 | 0.5034 | 0.5021 | 0.503 | 2350320.0 |
| 2004-06-02 11:45:00 | AAPL | Stock | 0.503 | 0.5038 | 0.5029 | 0.5032 | 1154608.0 |
| 2004-06-02 11:50:00 | AAPL | Stock | 0.5034 | 0.5036 | 0.5027 | 0.5032 | 777392.0 |
| 2004-06-02 11:55:00 | AAPL | Stock | 0.5032 | 0.5034 | 0.503 | 0.503 | 804440.0 |
| 2004-06-02 12:00:00 | AAPL | Stock | 0.503 | 0.5036 | 0.5027 | 0.5029 | 541352.0 |
| 2004-06-02 12:05:00 | AAPL | Stock | 0.503 | 0.5039 | 0.5027 | 0.5039 | 1037680.0 |
| 2004-06-02 12:10:00 | AAPL | Stock | 0.5039 | 0.5059 | 0.5039 | 0.5059 | 2665992.0 |
| 2004-06-02 12:15:00 | AAPL | Stock | 0.5059 | 0.5059 | 0.5046 | 0.5054 | 1442000.0 |
| 2004-06-02 12:20:00 | AAPL | Stock | 0.5054 | 0.5057 | 0.5052 | 0.5052 | 1736392.0 |
| 2004-06-02 12:25:00 | AAPL | Stock | 0.5052 | 0.5057 | 0.5052 | 0.5057 | 1108800.0 |
| 2004-06-02 12:30:00 | AAPL | Stock | 0.5059 | 0.5082 | 0.5059 | 0.5079 | 4380208.0 |
| 2004-06-02 12:35:00 | AAPL | Stock | 0.508 | 0.5086 | 0.5071 | 0.508 | 3248784.0 |
| 2004-06-02 12:40:00 | AAPL | Stock | 0.5079 | 0.5082 | 0.5073 | 0.5075 | 1199800.0 |
| 2004-06-02 12:45:00 | AAPL | Stock | 0.5075 | 0.5077 | 0.5064 | 0.5071 | 2072280.0 |
| 2004-06-02 12:50:00 | AAPL | Stock | 0.5071 | 0.5077 | 0.507 | 0.5071 | 834736.0 |
| 2004-06-02 12:55:00 | AAPL | Stock | 0.5071 | 0.5073 | 0.5071 | 0.5071 | 610176.0 |
| 2004-06-02 13:00:00 | AAPL | Stock | 0.5071 | 0.5073 | 0.5064 | 0.507 | 1223432.0 |
| 2004-06-02 13:05:00 | AAPL | Stock | 0.507 | 0.5077 | 0.5067 | 0.5077 | 763224.0 |
| 2004-06-02 13:10:00 | AAPL | Stock | 0.5077 | 0.508 | 0.5075 | 0.5075 | 985936.0 |
| 2004-06-02 13:15:00 | AAPL | Stock | 0.5075 | 0.5077 | 0.5071 | 0.5073 | 647024.0 |
| 2004-06-02 13:20:00 | AAPL | Stock | 0.5073 | 0.5089 | 0.5073 | 0.5089 | 2435328.0 |
> showing 50 of 174,021 rows — these rows as CSV