PREVIEW / stock_5min / 2010-04-06
file: by_date/stock_5min/2010/2010-04-06.parquet size: 4.7 MB rows: 325,945 symbols: 3,462
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-06 04:15:00 | AAPL | Stock | 8.5089 | 8.5089 | 8.5089 | 8.5089 | 8400.0 |
| 2010-04-06 04:25:00 | AAPL | Stock | 8.5346 | 8.5346 | 8.5346 | 8.5346 | 11200.0 |
| 2010-04-06 04:40:00 | AAPL | Stock | 8.5375 | 8.5393 | 8.5375 | 8.5393 | 6440.0 |
| 2010-04-06 05:05:00 | AAPL | Stock | 8.5393 | 8.5393 | 8.5393 | 8.5393 | 3920.0 |
| 2010-04-06 05:30:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5307 | 8.5307 | 14000.0 |
| 2010-04-06 05:40:00 | AAPL | Stock | 8.525 | 8.525 | 8.525 | 8.525 | 2800.0 |
| 2010-04-06 05:45:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5357 | 8.5357 | 8400.0 |
| 2010-04-06 05:55:00 | AAPL | Stock | 8.5393 | 8.5393 | 8.5393 | 8.5393 | 2800.0 |
| 2010-04-06 06:05:00 | AAPL | Stock | 8.5361 | 8.5361 | 8.5361 | 8.5361 | 2800.0 |
| 2010-04-06 06:10:00 | AAPL | Stock | 8.5393 | 8.5393 | 8.5393 | 8.5393 | 2800.0 |
| 2010-04-06 06:15:00 | AAPL | Stock | 8.5382 | 8.5386 | 8.5382 | 8.5382 | 8400.0 |
| 2010-04-06 06:55:00 | AAPL | Stock | 8.5386 | 8.5386 | 8.5386 | 8.5386 | 5040.0 |
| 2010-04-06 07:00:00 | AAPL | Stock | 8.5293 | 8.5357 | 8.5293 | 8.5357 | 30800.0 |
| 2010-04-06 07:05:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5321 | 8.5321 | 63000.0 |
| 2010-04-06 07:10:00 | AAPL | Stock | 8.5354 | 8.5361 | 8.5354 | 8.5354 | 36540.0 |
| 2010-04-06 07:15:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5357 | 8.5357 | 4452.0 |
| 2010-04-06 07:20:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5314 | 8.5314 | 44240.0 |
| 2010-04-06 07:25:00 | AAPL | Stock | 8.5314 | 8.5314 | 8.5239 | 8.525 | 114800.0 |
| 2010-04-06 07:30:00 | AAPL | Stock | 8.5239 | 8.5239 | 8.5196 | 8.5196 | 40628.0 |
| 2010-04-06 07:35:00 | AAPL | Stock | 8.5214 | 8.5264 | 8.5196 | 8.5264 | 44408.0 |
| 2010-04-06 07:40:00 | AAPL | Stock | 8.5336 | 8.5339 | 8.5336 | 8.5339 | 25200.0 |
| 2010-04-06 07:45:00 | AAPL | Stock | 8.5336 | 8.5339 | 8.5268 | 8.5268 | 28000.0 |
| 2010-04-06 07:50:00 | AAPL | Stock | 8.5321 | 8.5354 | 8.5321 | 8.5354 | 22400.0 |
| 2010-04-06 07:55:00 | AAPL | Stock | 8.5304 | 8.5304 | 8.5304 | 8.5304 | 2800.0 |
| 2010-04-06 08:00:00 | AAPL | Stock | 8.5304 | 8.5304 | 8.5089 | 8.5132 | 567280.0 |
| 2010-04-06 08:05:00 | AAPL | Stock | 8.5132 | 8.5143 | 8.5025 | 8.5025 | 428540.0 |
| 2010-04-06 08:10:00 | AAPL | Stock | 8.5007 | 8.5107 | 8.4979 | 8.5043 | 495684.0 |
| 2010-04-06 08:15:00 | AAPL | Stock | 8.5071 | 8.5071 | 8.4961 | 8.4964 | 460964.0 |
| 2010-04-06 08:20:00 | AAPL | Stock | 8.4971 | 8.4982 | 8.4829 | 8.4975 | 215264.0 |
| 2010-04-06 08:25:00 | AAPL | Stock | 8.4961 | 8.4979 | 8.4911 | 8.4964 | 313936.0 |
| 2010-04-06 08:30:00 | AAPL | Stock | 8.4975 | 8.4979 | 8.4929 | 8.4961 | 182000.0 |
| 2010-04-06 08:35:00 | AAPL | Stock | 8.4948 | 8.4982 | 8.4904 | 8.4907 | 228060.0 |
| 2010-04-06 08:40:00 | AAPL | Stock | 8.4907 | 8.4961 | 8.4907 | 8.4946 | 275744.0 |
| 2010-04-06 08:45:00 | AAPL | Stock | 8.4943 | 8.4996 | 8.4943 | 8.4993 | 166264.0 |
| 2010-04-06 08:50:00 | AAPL | Stock | 8.4982 | 8.505 | 8.4979 | 8.5036 | 159040.0 |
| 2010-04-06 08:55:00 | AAPL | Stock | 8.5029 | 8.5036 | 8.5011 | 8.5021 | 120400.0 |
| 2010-04-06 09:00:00 | AAPL | Stock | 8.5025 | 8.5025 | 8.495 | 8.5 | 202860.0 |
| 2010-04-06 09:05:00 | AAPL | Stock | 8.5 | 8.5014 | 8.4964 | 8.4996 | 110152.0 |
| 2010-04-06 09:10:00 | AAPL | Stock | 8.4996 | 8.5039 | 8.4996 | 8.5036 | 90328.0 |
| 2010-04-06 09:15:00 | AAPL | Stock | 8.5021 | 8.5175 | 8.5 | 8.5175 | 158536.0 |
| 2010-04-06 09:20:00 | AAPL | Stock | 8.5039 | 8.5068 | 8.5036 | 8.5043 | 93856.0 |
| 2010-04-06 09:25:00 | AAPL | Stock | 8.5029 | 8.5068 | 8.4975 | 8.5066 | 118720.0 |
| 2010-04-06 09:30:00 | AAPL | Stock | 8.5061 | 8.5164 | 8.4821 | 8.4911 | 15799392.0 |
| 2010-04-06 09:35:00 | AAPL | Stock | 8.4911 | 8.4925 | 8.4775 | 8.4804 | 13015968.0 |
| 2010-04-06 09:40:00 | AAPL | Stock | 8.4804 | 8.4839 | 8.4646 | 8.4725 | 14989548.0 |
| 2010-04-06 09:45:00 | AAPL | Stock | 8.4729 | 8.4932 | 8.4643 | 8.4929 | 15572872.0 |
| 2010-04-06 09:50:00 | AAPL | Stock | 8.4929 | 8.4943 | 8.4771 | 8.4811 | 9903824.0 |
| 2010-04-06 09:55:00 | AAPL | Stock | 8.4818 | 8.4939 | 8.4804 | 8.4846 | 6685336.0 |
| 2010-04-06 10:00:00 | AAPL | Stock | 8.4846 | 8.4846 | 8.4732 | 8.4785 | 7843892.0 |
| 2010-04-06 10:05:00 | AAPL | Stock | 8.4786 | 8.4875 | 8.4679 | 8.475 | 10692304.0 |
> showing 50 of 325,945 rows — these rows as CSV