PREVIEW / stock_5min / 2005-04-14
file: by_date/stock_5min/2005/2005-04-14.parquet size: 2.7 MB rows: 194,048 symbols: 1,960
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-14 05:50:00 | AAPL | Stock | 1.4518 | 1.4518 | 1.4518 | 1.4518 | 140000.0 |
| 2005-04-14 05:55:00 | AAPL | Stock | 1.4518 | 1.4518 | 1.4518 | 1.4518 | 39200.0 |
| 2005-04-14 06:50:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4482 | 1.4482 | 28000.0 |
| 2005-04-14 06:55:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4482 | 1.4482 | 28000.0 |
| 2005-04-14 07:30:00 | AAPL | Stock | 1.4286 | 1.4286 | 1.4286 | 1.4286 | 92400.0 |
| 2005-04-14 07:35:00 | AAPL | Stock | 1.4357 | 1.4389 | 1.4357 | 1.4364 | 39200.0 |
| 2005-04-14 07:40:00 | AAPL | Stock | 1.4375 | 1.4375 | 1.4375 | 1.4375 | 8400.0 |
| 2005-04-14 07:45:00 | AAPL | Stock | 1.4429 | 1.4429 | 1.4429 | 1.4429 | 28000.0 |
| 2005-04-14 07:50:00 | AAPL | Stock | 1.4393 | 1.4393 | 1.4393 | 1.4393 | 28000.0 |
| 2005-04-14 07:55:00 | AAPL | Stock | 1.4429 | 1.4429 | 1.4261 | 1.4286 | 349580.0 |
| 2005-04-14 08:00:00 | AAPL | Stock | 1.4286 | 1.4429 | 1.4268 | 1.4375 | 5949300.0 |
| 2005-04-14 08:05:00 | AAPL | Stock | 1.4364 | 1.4375 | 1.4254 | 1.4282 | 2364208.0 |
| 2005-04-14 08:10:00 | AAPL | Stock | 1.4293 | 1.4357 | 1.4214 | 1.4221 | 3759084.0 |
| 2005-04-14 08:15:00 | AAPL | Stock | 1.4236 | 1.4264 | 1.4161 | 1.4214 | 5287464.0 |
| 2005-04-14 08:20:00 | AAPL | Stock | 1.4214 | 1.4264 | 1.4207 | 1.4243 | 9769480.0 |
| 2005-04-14 08:25:00 | AAPL | Stock | 1.4243 | 1.4264 | 1.4232 | 1.4239 | 4108552.0 |
| 2005-04-14 08:30:00 | AAPL | Stock | 1.4239 | 1.4254 | 1.415 | 1.4182 | 5207692.0 |
| 2005-04-14 08:35:00 | AAPL | Stock | 1.4179 | 1.4196 | 1.4082 | 1.4082 | 7825972.0 |
| 2005-04-14 08:40:00 | AAPL | Stock | 1.4089 | 1.4089 | 1.3989 | 1.3993 | 7220948.0 |
| 2005-04-14 08:45:00 | AAPL | Stock | 1.3996 | 1.4025 | 1.3975 | 1.3993 | 6976228.0 |
| 2005-04-14 08:50:00 | AAPL | Stock | 1.3993 | 1.3996 | 1.3929 | 1.3929 | 8853236.0 |
| 2005-04-14 08:55:00 | AAPL | Stock | 1.3929 | 1.4268 | 1.3839 | 1.3868 | 11889752.0 |
| 2005-04-14 09:00:00 | AAPL | Stock | 1.3868 | 1.3871 | 1.3757 | 1.3786 | 13282332.0 |
| 2005-04-14 09:05:00 | AAPL | Stock | 1.3789 | 1.3839 | 1.3686 | 1.3689 | 16777180.0 |
| 2005-04-14 09:10:00 | AAPL | Stock | 1.3689 | 1.3757 | 1.3643 | 1.375 | 12505668.0 |
| 2005-04-14 09:15:00 | AAPL | Stock | 1.375 | 1.3786 | 1.3686 | 1.3761 | 7762944.0 |
| 2005-04-14 09:20:00 | AAPL | Stock | 1.3771 | 1.38 | 1.3732 | 1.3786 | 10430756.0 |
| 2005-04-14 09:25:00 | AAPL | Stock | 1.3786 | 1.3879 | 1.3764 | 1.3857 | 21421568.0 |
| 2005-04-14 09:30:00 | AAPL | Stock | 1.3861 | 1.3879 | 1.3596 | 1.3746 | 166449024.0 |
| 2005-04-14 09:35:00 | AAPL | Stock | 1.3746 | 1.3989 | 1.3729 | 1.3961 | 118452068.0 |
| 2005-04-14 09:40:00 | AAPL | Stock | 1.3964 | 1.4082 | 1.3961 | 1.4054 | 105190932.0 |
| 2005-04-14 09:45:00 | AAPL | Stock | 1.4043 | 1.4129 | 1.4007 | 1.4096 | 73672424.0 |
| 2005-04-14 09:50:00 | AAPL | Stock | 1.4104 | 1.4107 | 1.4021 | 1.4054 | 56261016.0 |
| 2005-04-14 09:55:00 | AAPL | Stock | 1.4054 | 1.4057 | 1.3993 | 1.4036 | 50725864.0 |
| 2005-04-14 10:00:00 | AAPL | Stock | 1.4032 | 1.4057 | 1.3989 | 1.3993 | 34138356.0 |
| 2005-04-14 10:05:00 | AAPL | Stock | 1.3993 | 1.4279 | 1.3893 | 1.3904 | 60533368.0 |
| 2005-04-14 10:10:00 | AAPL | Stock | 1.3904 | 1.3904 | 1.3825 | 1.3861 | 50013208.0 |
| 2005-04-14 10:15:00 | AAPL | Stock | 1.3864 | 1.3889 | 1.3739 | 1.3739 | 40855164.0 |
| 2005-04-14 10:20:00 | AAPL | Stock | 1.3739 | 1.3829 | 1.3729 | 1.3811 | 38645040.0 |
| 2005-04-14 10:25:00 | AAPL | Stock | 1.3811 | 1.3854 | 1.3754 | 1.3836 | 28535948.0 |
| 2005-04-14 10:30:00 | AAPL | Stock | 1.3839 | 1.3843 | 1.375 | 1.3789 | 25768372.0 |
| 2005-04-14 10:35:00 | AAPL | Stock | 1.3789 | 1.3825 | 1.3768 | 1.3804 | 22336272.0 |
| 2005-04-14 10:40:00 | AAPL | Stock | 1.38 | 1.3871 | 1.38 | 1.3871 | 23262512.0 |
| 2005-04-14 10:45:00 | AAPL | Stock | 1.3871 | 1.3911 | 1.3839 | 1.3875 | 26685960.0 |
| 2005-04-14 10:50:00 | AAPL | Stock | 1.3881 | 1.3914 | 1.3857 | 1.3893 | 16712220.0 |
| 2005-04-14 10:55:00 | AAPL | Stock | 1.39 | 1.3971 | 1.3889 | 1.3939 | 31939656.0 |
| 2005-04-14 11:00:00 | AAPL | Stock | 1.394 | 1.3943 | 1.3868 | 1.39 | 20539932.0 |
| 2005-04-14 11:05:00 | AAPL | Stock | 1.39 | 1.3968 | 1.3889 | 1.3954 | 20476708.0 |
| 2005-04-14 11:10:00 | AAPL | Stock | 1.395 | 1.3961 | 1.3918 | 1.3918 | 16177644.0 |
| 2005-04-14 11:15:00 | AAPL | Stock | 1.3918 | 1.3929 | 1.3889 | 1.3907 | 12427576.0 |
> showing 50 of 194,048 rows — these rows as CSV