PREVIEW / stock_5min / 2012-11-16
file: by_date/stock_5min/2012/2012-11-16.parquet size: 5.0 MB rows: 339,024 symbols: 3,473
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-11-16 04:05:00 | AAPL | Stock | 18.7179 | 18.75 | 18.7179 | 18.75 | 6580.0 |
| 2012-11-16 04:25:00 | AAPL | Stock | 18.7054 | 18.7054 | 18.7054 | 18.7054 | 2800.0 |
| 2012-11-16 04:30:00 | AAPL | Stock | 18.7054 | 18.7054 | 18.7 | 18.7 | 5600.0 |
| 2012-11-16 04:35:00 | AAPL | Stock | 18.6964 | 18.6964 | 18.6964 | 18.6964 | 2800.0 |
| 2012-11-16 04:45:00 | AAPL | Stock | 18.6789 | 18.6789 | 18.6789 | 18.6789 | 2800.0 |
| 2012-11-16 04:50:00 | AAPL | Stock | 18.6786 | 18.6786 | 18.6786 | 18.6786 | 5600.0 |
| 2012-11-16 05:10:00 | AAPL | Stock | 18.6614 | 18.6614 | 18.6611 | 18.6611 | 5600.0 |
| 2012-11-16 05:15:00 | AAPL | Stock | 18.65 | 18.65 | 18.6432 | 18.6432 | 15400.0 |
| 2012-11-16 05:25:00 | AAPL | Stock | 18.6329 | 18.6329 | 18.6329 | 18.6329 | 2800.0 |
| 2012-11-16 05:30:00 | AAPL | Stock | 18.6343 | 18.6429 | 18.6304 | 18.6429 | 23464.0 |
| 2012-11-16 05:35:00 | AAPL | Stock | 18.6307 | 18.6421 | 18.6304 | 18.6421 | 10220.0 |
| 2012-11-16 05:45:00 | AAPL | Stock | 18.6321 | 18.6321 | 18.6304 | 18.6304 | 16156.0 |
| 2012-11-16 05:50:00 | AAPL | Stock | 18.6393 | 18.6393 | 18.6393 | 18.6393 | 2800.0 |
| 2012-11-16 05:55:00 | AAPL | Stock | 18.6411 | 18.6429 | 18.6411 | 18.6429 | 16772.0 |
| 2012-11-16 06:10:00 | AAPL | Stock | 18.6243 | 18.6396 | 18.6243 | 18.6396 | 9800.0 |
| 2012-11-16 06:15:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 5600.0 |
| 2012-11-16 06:20:00 | AAPL | Stock | 18.6696 | 18.6696 | 18.6696 | 18.6696 | 2800.0 |
| 2012-11-16 06:30:00 | AAPL | Stock | 18.655 | 18.655 | 18.655 | 18.655 | 5600.0 |
| 2012-11-16 06:40:00 | AAPL | Stock | 18.6593 | 18.6714 | 18.6593 | 18.6607 | 40600.0 |
| 2012-11-16 06:45:00 | AAPL | Stock | 18.6607 | 18.6607 | 18.6607 | 18.6607 | 19600.0 |
| 2012-11-16 06:50:00 | AAPL | Stock | 18.6607 | 18.6714 | 18.6607 | 18.6714 | 11200.0 |
| 2012-11-16 06:55:00 | AAPL | Stock | 18.6786 | 18.695 | 18.6732 | 18.695 | 47432.0 |
| 2012-11-16 07:00:00 | AAPL | Stock | 18.7068 | 18.7418 | 18.7068 | 18.7418 | 45836.0 |
| 2012-11-16 07:05:00 | AAPL | Stock | 18.7446 | 18.76 | 18.7336 | 18.75 | 56000.0 |
| 2012-11-16 07:10:00 | AAPL | Stock | 18.7486 | 18.7711 | 18.7486 | 18.75 | 38388.0 |
| 2012-11-16 07:15:00 | AAPL | Stock | 18.7232 | 18.7475 | 18.7214 | 18.7475 | 22232.0 |
| 2012-11-16 07:20:00 | AAPL | Stock | 18.7293 | 18.7389 | 18.7179 | 18.7389 | 32200.0 |
| 2012-11-16 07:25:00 | AAPL | Stock | 18.7296 | 18.75 | 18.7296 | 18.7411 | 152880.0 |
| 2012-11-16 07:30:00 | AAPL | Stock | 18.7639 | 18.7639 | 18.7639 | 18.7639 | 2800.0 |
| 2012-11-16 07:35:00 | AAPL | Stock | 18.7536 | 18.8036 | 18.7536 | 18.8036 | 203252.0 |
| 2012-11-16 07:40:00 | AAPL | Stock | 18.8029 | 18.8393 | 18.7993 | 18.8214 | 87808.0 |
| 2012-11-16 07:45:00 | AAPL | Stock | 18.8214 | 18.8389 | 18.8211 | 18.8325 | 101752.0 |
| 2012-11-16 07:50:00 | AAPL | Stock | 18.8229 | 18.8229 | 18.8086 | 18.8086 | 44800.0 |
| 2012-11-16 07:55:00 | AAPL | Stock | 18.8164 | 18.8232 | 18.8107 | 18.8214 | 80752.0 |
| 2012-11-16 08:00:00 | AAPL | Stock | 18.8079 | 18.8175 | 18.7146 | 18.8175 | 114436.0 |
| 2012-11-16 08:05:00 | AAPL | Stock | 18.7768 | 18.9118 | 18.7768 | 18.9046 | 442372.0 |
| 2012-11-16 08:10:00 | AAPL | Stock | 18.91 | 18.9679 | 18.8993 | 18.9125 | 942564.0 |
| 2012-11-16 08:15:00 | AAPL | Stock | 18.9114 | 18.9286 | 18.9046 | 18.9107 | 385224.0 |
| 2012-11-16 08:20:00 | AAPL | Stock | 18.905 | 18.9107 | 18.8839 | 18.9043 | 219660.0 |
| 2012-11-16 08:25:00 | AAPL | Stock | 18.9021 | 18.9104 | 18.8939 | 18.9 | 116928.0 |
| 2012-11-16 08:30:00 | AAPL | Stock | 18.9 | 18.9246 | 18.9 | 18.92 | 187824.0 |
| 2012-11-16 08:35:00 | AAPL | Stock | 18.9214 | 18.9286 | 18.8929 | 18.8946 | 322644.0 |
| 2012-11-16 08:40:00 | AAPL | Stock | 18.8975 | 18.9096 | 18.8786 | 18.8793 | 209748.0 |
| 2012-11-16 08:45:00 | AAPL | Stock | 18.8804 | 18.8893 | 18.8571 | 18.8625 | 292880.0 |
| 2012-11-16 08:50:00 | AAPL | Stock | 18.8575 | 18.8604 | 18.8325 | 18.8414 | 307356.0 |
| 2012-11-16 08:55:00 | AAPL | Stock | 18.8396 | 18.8554 | 18.7875 | 18.8361 | 201348.0 |
| 2012-11-16 09:00:00 | AAPL | Stock | 18.8368 | 18.8661 | 18.8357 | 18.85 | 264096.0 |
| 2012-11-16 09:05:00 | AAPL | Stock | 18.85 | 18.8571 | 18.8293 | 18.8571 | 232820.0 |
| 2012-11-16 09:10:00 | AAPL | Stock | 18.8629 | 18.8629 | 18.7721 | 18.7721 | 355488.0 |
| 2012-11-16 09:15:00 | AAPL | Stock | 18.8389 | 18.8429 | 18.8143 | 18.8168 | 467852.0 |
> showing 50 of 339,024 rows — these rows as CSV