PREVIEW / stock_5min / 2012-07-13
file: by_date/stock_5min/2012/2012-07-13.parquet size: 4.7 MB rows: 316,606 symbols: 3,491
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 |
|---|---|---|---|---|---|---|---|
| 2012-07-13 06:30:00 | AAPL | Stock | 21.4536 | 21.4536 | 21.4536 | 21.4536 | 8400.0 |
| 2012-07-13 06:45:00 | AAPL | Stock | 21.4643 | 21.4643 | 21.4643 | 21.4643 | 5600.0 |
| 2012-07-13 06:55:00 | AAPL | Stock | 21.4843 | 21.4889 | 21.4821 | 21.4821 | 18200.0 |
| 2012-07-13 07:00:00 | AAPL | Stock | 21.4821 | 21.4821 | 21.4732 | 21.475 | 10080.0 |
| 2012-07-13 07:05:00 | AAPL | Stock | 21.4554 | 21.4571 | 21.4329 | 21.4329 | 16800.0 |
| 2012-07-13 07:15:00 | AAPL | Stock | 21.4396 | 21.4529 | 21.4396 | 21.4529 | 11200.0 |
| 2012-07-13 07:20:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 5600.0 |
| 2012-07-13 07:25:00 | AAPL | Stock | 21.4439 | 21.4439 | 21.4286 | 21.4321 | 36400.0 |
| 2012-07-13 07:30:00 | AAPL | Stock | 21.4536 | 21.4639 | 21.4536 | 21.4639 | 7840.0 |
| 2012-07-13 07:35:00 | AAPL | Stock | 21.45 | 21.45 | 21.45 | 21.45 | 2800.0 |
| 2012-07-13 07:40:00 | AAPL | Stock | 21.4461 | 21.4596 | 21.4461 | 21.4554 | 8400.0 |
| 2012-07-13 07:45:00 | AAPL | Stock | 21.4596 | 21.4643 | 21.4486 | 21.4486 | 118384.0 |
| 2012-07-13 07:50:00 | AAPL | Stock | 21.4571 | 21.4571 | 21.4482 | 21.4482 | 26600.0 |
| 2012-07-13 07:55:00 | AAPL | Stock | 21.4504 | 21.4504 | 21.4496 | 21.4504 | 30800.0 |
| 2012-07-13 08:00:00 | AAPL | Stock | 21.4464 | 21.4571 | 21.4464 | 21.4557 | 161308.0 |
| 2012-07-13 08:05:00 | AAPL | Stock | 21.4571 | 21.4768 | 21.4286 | 21.4768 | 148680.0 |
| 2012-07-13 08:10:00 | AAPL | Stock | 21.4732 | 21.4882 | 21.4732 | 21.4821 | 100716.0 |
| 2012-07-13 08:15:00 | AAPL | Stock | 21.4875 | 21.4957 | 21.4786 | 21.48 | 132440.0 |
| 2012-07-13 08:20:00 | AAPL | Stock | 21.48 | 21.4893 | 21.48 | 21.4861 | 69020.0 |
| 2012-07-13 08:25:00 | AAPL | Stock | 21.4929 | 21.4979 | 21.4825 | 21.4979 | 151172.0 |
| 2012-07-13 08:30:00 | AAPL | Stock | 21.5 | 21.51 | 21.4893 | 21.5007 | 282912.0 |
| 2012-07-13 08:35:00 | AAPL | Stock | 21.5007 | 21.5157 | 21.4993 | 21.5157 | 70644.0 |
| 2012-07-13 08:40:00 | AAPL | Stock | 21.5171 | 21.5461 | 21.5161 | 21.5357 | 346528.0 |
| 2012-07-13 08:45:00 | AAPL | Stock | 21.5357 | 21.5446 | 21.5293 | 21.5368 | 106120.0 |
| 2012-07-13 08:50:00 | AAPL | Stock | 21.54 | 21.5425 | 21.4214 | 21.5293 | 290276.0 |
| 2012-07-13 08:55:00 | AAPL | Stock | 21.5321 | 21.5411 | 21.5296 | 21.5357 | 252476.0 |
| 2012-07-13 09:00:00 | AAPL | Stock | 21.5389 | 21.5411 | 21.5182 | 21.5246 | 565796.0 |
| 2012-07-13 09:05:00 | AAPL | Stock | 21.5214 | 21.5286 | 21.5132 | 21.5168 | 269612.0 |
| 2012-07-13 09:10:00 | AAPL | Stock | 21.5218 | 21.54 | 21.5214 | 21.5336 | 124180.0 |
| 2012-07-13 09:15:00 | AAPL | Stock | 21.5329 | 21.5371 | 21.5329 | 21.5339 | 58660.0 |
| 2012-07-13 09:20:00 | AAPL | Stock | 21.5339 | 21.5375 | 21.525 | 21.5289 | 298592.0 |
| 2012-07-13 09:25:00 | AAPL | Stock | 21.5304 | 21.5393 | 21.5143 | 21.5339 | 440776.0 |
| 2012-07-13 09:30:00 | AAPL | Stock | 21.5339 | 21.5893 | 21.5057 | 21.5304 | 13558076.0 |
| 2012-07-13 09:35:00 | AAPL | Stock | 21.5296 | 21.5714 | 21.5139 | 21.5586 | 6969396.0 |
| 2012-07-13 09:40:00 | AAPL | Stock | 21.5621 | 21.5786 | 21.5225 | 21.5557 | 7042868.0 |
| 2012-07-13 09:45:00 | AAPL | Stock | 21.5548 | 21.5693 | 21.5246 | 21.5439 | 5696852.0 |
| 2012-07-13 09:50:00 | AAPL | Stock | 21.5454 | 21.5454 | 21.4286 | 21.4625 | 11586988.0 |
| 2012-07-13 09:55:00 | AAPL | Stock | 21.4675 | 21.5429 | 21.45 | 21.5358 | 8919092.0 |
| 2012-07-13 10:00:00 | AAPL | Stock | 21.5396 | 21.5536 | 21.5129 | 21.55 | 6900992.0 |
| 2012-07-13 10:05:00 | AAPL | Stock | 21.5461 | 21.5679 | 21.5311 | 21.5393 | 6645016.0 |
| 2012-07-13 10:10:00 | AAPL | Stock | 21.5389 | 21.5493 | 21.5225 | 21.5286 | 4800572.0 |
| 2012-07-13 10:15:00 | AAPL | Stock | 21.5286 | 21.5325 | 21.5 | 21.512 | 3550400.0 |
| 2012-07-13 10:20:00 | AAPL | Stock | 21.5164 | 21.5239 | 21.4821 | 21.5089 | 5502896.0 |
| 2012-07-13 10:25:00 | AAPL | Stock | 21.5089 | 21.5143 | 21.4854 | 21.506 | 2231516.0 |
| 2012-07-13 10:30:00 | AAPL | Stock | 21.5071 | 21.5321 | 21.4961 | 21.51 | 3108140.0 |
| 2012-07-13 10:35:00 | AAPL | Stock | 21.5094 | 21.5261 | 21.5071 | 21.5243 | 2115960.0 |
| 2012-07-13 10:40:00 | AAPL | Stock | 21.5243 | 21.55 | 21.5207 | 21.53 | 3319400.0 |
| 2012-07-13 10:45:00 | AAPL | Stock | 21.5343 | 21.5607 | 21.5332 | 21.5479 | 2887556.0 |
| 2012-07-13 10:50:00 | AAPL | Stock | 21.5471 | 21.5532 | 21.5321 | 21.5446 | 2485476.0 |
| 2012-07-13 10:55:00 | AAPL | Stock | 21.5446 | 21.5446 | 21.515 | 21.5221 | 1802696.0 |
> showing 50 of 316,606 rows — these rows as CSV