PREVIEW / stock_5min / 2010-05-20
file: by_date/stock_5min/2010/2010-05-20.parquet size: 5.4 MB rows: 361,932 symbols: 3,513
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-05-20 04:35:00 | AAPL | Stock | 8.8571 | 8.8571 | 8.8571 | 8.8571 | 2800.0 |
| 2010-05-20 04:40:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 16800.0 |
| 2010-05-20 05:10:00 | AAPL | Stock | 8.8804 | 8.8804 | 8.8804 | 8.8804 | 11200.0 |
| 2010-05-20 05:25:00 | AAPL | Stock | 8.8536 | 8.8536 | 8.8536 | 8.8536 | 2800.0 |
| 2010-05-20 05:35:00 | AAPL | Stock | 8.8536 | 8.8536 | 8.8536 | 8.8536 | 8400.0 |
| 2010-05-20 05:40:00 | AAPL | Stock | 8.8536 | 8.8536 | 8.8536 | 8.8536 | 2800.0 |
| 2010-05-20 05:50:00 | AAPL | Stock | 8.8536 | 8.8536 | 8.8536 | 8.8536 | 2800.0 |
| 2010-05-20 06:00:00 | AAPL | Stock | 8.8411 | 8.8411 | 8.8411 | 8.8411 | 3108.0 |
| 2010-05-20 07:00:00 | AAPL | Stock | 8.8036 | 8.8304 | 8.8036 | 8.8304 | 5600.0 |
| 2010-05-20 07:10:00 | AAPL | Stock | 8.8093 | 8.8093 | 8.8004 | 8.8004 | 14000.0 |
| 2010-05-20 07:15:00 | AAPL | Stock | 8.8004 | 8.8018 | 8.8004 | 8.8004 | 28000.0 |
| 2010-05-20 07:20:00 | AAPL | Stock | 8.8036 | 8.8039 | 8.8036 | 8.8039 | 14000.0 |
| 2010-05-20 07:25:00 | AAPL | Stock | 8.8039 | 8.8039 | 8.7575 | 8.7679 | 60900.0 |
| 2010-05-20 07:30:00 | AAPL | Stock | 8.7629 | 8.7682 | 8.7064 | 8.7064 | 250600.0 |
| 2010-05-20 07:35:00 | AAPL | Stock | 8.7261 | 8.7496 | 8.7143 | 8.7411 | 65632.0 |
| 2010-05-20 07:40:00 | AAPL | Stock | 8.7411 | 8.7411 | 8.7089 | 8.7139 | 77952.0 |
| 2010-05-20 07:45:00 | AAPL | Stock | 8.7275 | 8.7321 | 8.7075 | 8.71 | 134400.0 |
| 2010-05-20 07:50:00 | AAPL | Stock | 8.7143 | 8.72 | 8.6993 | 8.7139 | 179200.0 |
| 2010-05-20 07:55:00 | AAPL | Stock | 8.7057 | 8.7143 | 8.7021 | 8.7143 | 155400.0 |
| 2010-05-20 08:00:00 | AAPL | Stock | 8.71 | 8.7268 | 8.6921 | 8.715 | 742672.0 |
| 2010-05-20 08:05:00 | AAPL | Stock | 8.7154 | 8.7375 | 8.7125 | 8.7321 | 659288.0 |
| 2010-05-20 08:10:00 | AAPL | Stock | 8.7318 | 8.7318 | 8.7107 | 8.7161 | 853076.0 |
| 2010-05-20 08:15:00 | AAPL | Stock | 8.7143 | 8.7196 | 8.7064 | 8.7111 | 455308.0 |
| 2010-05-20 08:20:00 | AAPL | Stock | 8.7111 | 8.7171 | 8.7021 | 8.7021 | 438928.0 |
| 2010-05-20 08:25:00 | AAPL | Stock | 8.7036 | 8.7193 | 8.7029 | 8.7143 | 337288.0 |
| 2010-05-20 08:30:00 | AAPL | Stock | 8.71 | 8.7125 | 8.6521 | 8.6589 | 1564360.0 |
| 2010-05-20 08:35:00 | AAPL | Stock | 8.6589 | 8.6604 | 8.6154 | 8.6429 | 1636460.0 |
| 2010-05-20 08:40:00 | AAPL | Stock | 8.6432 | 8.6475 | 8.6321 | 8.6321 | 851592.0 |
| 2010-05-20 08:45:00 | AAPL | Stock | 8.6379 | 8.6479 | 8.6379 | 8.6393 | 532420.0 |
| 2010-05-20 08:50:00 | AAPL | Stock | 8.6393 | 8.6643 | 8.6357 | 8.6607 | 768516.0 |
| 2010-05-20 08:55:00 | AAPL | Stock | 8.662 | 8.6696 | 8.6514 | 8.6536 | 415072.0 |
| 2010-05-20 09:00:00 | AAPL | Stock | 8.6536 | 8.6736 | 8.6429 | 8.6736 | 411180.0 |
| 2010-05-20 09:05:00 | AAPL | Stock | 8.6714 | 8.6754 | 8.6564 | 8.6754 | 400428.0 |
| 2010-05-20 09:10:00 | AAPL | Stock | 8.67 | 8.6921 | 8.67 | 8.6825 | 607544.0 |
| 2010-05-20 09:15:00 | AAPL | Stock | 8.6832 | 8.6871 | 8.6693 | 8.6768 | 354172.0 |
| 2010-05-20 09:20:00 | AAPL | Stock | 8.6714 | 8.6757 | 8.6664 | 8.6689 | 240436.0 |
| 2010-05-20 09:25:00 | AAPL | Stock | 8.6689 | 8.675 | 8.6318 | 8.6321 | 1396388.0 |
| 2010-05-20 09:30:00 | AAPL | Stock | 8.6386 | 8.6689 | 8.5893 | 8.6377 | 38967208.0 |
| 2010-05-20 09:35:00 | AAPL | Stock | 8.6389 | 8.6714 | 8.6207 | 8.6607 | 22564024.0 |
| 2010-05-20 09:40:00 | AAPL | Stock | 8.6589 | 8.665 | 8.5989 | 8.6239 | 24317524.0 |
| 2010-05-20 09:45:00 | AAPL | Stock | 8.6239 | 8.6586 | 8.6093 | 8.6586 | 24314500.0 |
| 2010-05-20 09:50:00 | AAPL | Stock | 8.6575 | 8.685 | 8.6382 | 8.6611 | 24570420.0 |
| 2010-05-20 09:55:00 | AAPL | Stock | 8.6621 | 8.6786 | 8.6382 | 8.6404 | 14560112.0 |
| 2010-05-20 10:00:00 | AAPL | Stock | 8.6393 | 8.6668 | 8.6175 | 8.6343 | 19697048.0 |
| 2010-05-20 10:05:00 | AAPL | Stock | 8.6343 | 8.6739 | 8.6204 | 8.6379 | 17753736.0 |
| 2010-05-20 10:10:00 | AAPL | Stock | 8.6393 | 8.6607 | 8.6107 | 8.6139 | 18313680.0 |
| 2010-05-20 10:15:00 | AAPL | Stock | 8.6157 | 8.6286 | 8.6021 | 8.6189 | 22566852.0 |
| 2010-05-20 10:20:00 | AAPL | Stock | 8.6186 | 8.6196 | 8.5196 | 8.525 | 40583228.0 |
| 2010-05-20 10:25:00 | AAPL | Stock | 8.5229 | 8.5707 | 8.5018 | 8.5689 | 28363692.0 |
| 2010-05-20 10:30:00 | AAPL | Stock | 8.5661 | 8.5893 | 8.5511 | 8.5736 | 20445880.0 |
> showing 50 of 361,932 rows — these rows as CSV