PREVIEW / stock_5min / 2008-08-05
file: by_date/stock_5min/2008/2008-08-05.parquet size: 4.5 MB rows: 320,657 symbols: 3,316
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-05 07:00:00 | AAPL | Stock | 5.5586 | 5.5586 | 5.5357 | 5.5357 | 28000.0 |
| 2008-08-05 07:20:00 | AAPL | Stock | 5.5371 | 5.5579 | 5.5368 | 5.5579 | 42000.0 |
| 2008-08-05 07:25:00 | AAPL | Stock | 5.5389 | 5.5589 | 5.5389 | 5.5589 | 86660.0 |
| 2008-08-05 07:35:00 | AAPL | Stock | 5.5625 | 5.5796 | 5.5625 | 5.5714 | 61320.0 |
| 2008-08-05 07:40:00 | AAPL | Stock | 5.5654 | 5.5654 | 5.5454 | 5.5454 | 84000.0 |
| 2008-08-05 07:45:00 | AAPL | Stock | 5.5446 | 5.5511 | 5.5446 | 5.5511 | 58800.0 |
| 2008-08-05 07:50:00 | AAPL | Stock | 5.5511 | 5.5511 | 5.5511 | 5.5511 | 19600.0 |
| 2008-08-05 07:55:00 | AAPL | Stock | 5.5496 | 5.5511 | 5.5496 | 5.5511 | 84000.0 |
| 2008-08-05 08:00:00 | AAPL | Stock | 5.5504 | 5.5625 | 5.545 | 5.5493 | 439796.0 |
| 2008-08-05 08:05:00 | AAPL | Stock | 5.5475 | 5.5486 | 5.5314 | 5.5325 | 333172.0 |
| 2008-08-05 08:10:00 | AAPL | Stock | 5.5336 | 5.5432 | 5.5318 | 5.5425 | 238784.0 |
| 2008-08-05 08:15:00 | AAPL | Stock | 5.5411 | 5.5432 | 5.5321 | 5.5371 | 172116.0 |
| 2008-08-05 08:20:00 | AAPL | Stock | 5.5346 | 5.5429 | 5.5346 | 5.5368 | 318500.0 |
| 2008-08-05 08:25:00 | AAPL | Stock | 5.5386 | 5.5404 | 5.5361 | 5.5364 | 72800.0 |
| 2008-08-05 08:30:00 | AAPL | Stock | 5.5364 | 5.5393 | 5.5304 | 5.5393 | 170856.0 |
| 2008-08-05 08:35:00 | AAPL | Stock | 5.5414 | 5.5418 | 5.5375 | 5.5411 | 145656.0 |
| 2008-08-05 08:40:00 | AAPL | Stock | 5.5411 | 5.5475 | 5.5375 | 5.5386 | 211400.0 |
| 2008-08-05 08:45:00 | AAPL | Stock | 5.5382 | 5.5479 | 5.5382 | 5.5436 | 267792.0 |
| 2008-08-05 08:50:00 | AAPL | Stock | 5.5457 | 5.5479 | 5.5418 | 5.5461 | 257348.0 |
| 2008-08-05 08:55:00 | AAPL | Stock | 5.5446 | 5.5536 | 5.5432 | 5.5536 | 219296.0 |
| 2008-08-05 09:00:00 | AAPL | Stock | 5.5529 | 5.5536 | 5.5429 | 5.5486 | 205156.0 |
| 2008-08-05 09:05:00 | AAPL | Stock | 5.5489 | 5.5689 | 5.5486 | 5.5625 | 654248.0 |
| 2008-08-05 09:10:00 | AAPL | Stock | 5.5654 | 5.5689 | 5.5575 | 5.5575 | 678720.0 |
| 2008-08-05 09:15:00 | AAPL | Stock | 5.5579 | 5.5625 | 5.55 | 5.5518 | 378952.0 |
| 2008-08-05 09:20:00 | AAPL | Stock | 5.5518 | 5.5536 | 5.5468 | 5.5514 | 120400.0 |
| 2008-08-05 09:25:00 | AAPL | Stock | 5.5493 | 5.5536 | 5.5439 | 5.5518 | 803040.0 |
| 2008-08-05 09:30:00 | AAPL | Stock | 5.5511 | 5.5861 | 5.5421 | 5.5778 | 25371640.0 |
| 2008-08-05 09:35:00 | AAPL | Stock | 5.5786 | 5.5821 | 5.5393 | 5.5503 | 18451384.0 |
| 2008-08-05 09:40:00 | AAPL | Stock | 5.5493 | 5.5707 | 5.5293 | 5.5568 | 16035320.0 |
| 2008-08-05 09:45:00 | AAPL | Stock | 5.5568 | 5.5571 | 5.5346 | 5.5511 | 13151992.0 |
| 2008-08-05 09:50:00 | AAPL | Stock | 5.5514 | 5.5711 | 5.5489 | 5.5661 | 13086668.0 |
| 2008-08-05 09:55:00 | AAPL | Stock | 5.5646 | 5.5796 | 5.5582 | 5.5704 | 10694320.0 |
| 2008-08-05 10:00:00 | AAPL | Stock | 5.5714 | 5.5871 | 5.5686 | 5.5811 | 11618516.0 |
| 2008-08-05 10:05:00 | AAPL | Stock | 5.5811 | 5.5861 | 5.57 | 5.5779 | 8560468.0 |
| 2008-08-05 10:10:00 | AAPL | Stock | 5.5768 | 5.5964 | 5.5704 | 5.5786 | 15440572.0 |
| 2008-08-05 10:15:00 | AAPL | Stock | 5.5786 | 5.5846 | 5.5732 | 5.5804 | 7968436.0 |
| 2008-08-05 10:20:00 | AAPL | Stock | 5.5796 | 5.5871 | 5.5757 | 5.5807 | 6675396.0 |
| 2008-08-05 10:25:00 | AAPL | Stock | 5.5807 | 5.5889 | 5.5761 | 5.585 | 7596568.0 |
| 2008-08-05 10:30:00 | AAPL | Stock | 5.585 | 5.5893 | 5.5732 | 5.575 | 7554316.0 |
| 2008-08-05 10:35:00 | AAPL | Stock | 5.575 | 5.5818 | 5.5729 | 5.5779 | 4893448.0 |
| 2008-08-05 10:40:00 | AAPL | Stock | 5.5782 | 5.5929 | 5.575 | 5.5839 | 7582624.0 |
| 2008-08-05 10:45:00 | AAPL | Stock | 5.5839 | 5.6011 | 5.5818 | 5.5904 | 8093288.0 |
| 2008-08-05 10:50:00 | AAPL | Stock | 5.5904 | 5.6036 | 5.5889 | 5.6011 | 6703060.0 |
| 2008-08-05 10:55:00 | AAPL | Stock | 5.6014 | 5.6036 | 5.5911 | 5.6029 | 5112996.0 |
| 2008-08-05 11:00:00 | AAPL | Stock | 5.6029 | 5.6064 | 5.5982 | 5.6039 | 7232372.0 |
| 2008-08-05 11:05:00 | AAPL | Stock | 5.6046 | 5.6193 | 5.5964 | 5.615 | 10605112.0 |
| 2008-08-05 11:10:00 | AAPL | Stock | 5.6143 | 5.6218 | 5.6143 | 5.6211 | 6027140.0 |
| 2008-08-05 11:15:00 | AAPL | Stock | 5.6204 | 5.6293 | 5.6161 | 5.6174 | 6975752.0 |
| 2008-08-05 11:20:00 | AAPL | Stock | 5.6171 | 5.6346 | 5.6146 | 5.6264 | 7920192.0 |
| 2008-08-05 11:25:00 | AAPL | Stock | 5.6268 | 5.6339 | 5.625 | 5.6275 | 5480972.0 |
> showing 50 of 320,657 rows — these rows as CSV