PREVIEW / stock_5min / 2013-10-16
file: by_date/stock_5min/2013/2013-10-16.parquet size: 5.3 MB rows: 347,153 symbols: 3,558
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-16 04:00:00 | AAPL | Stock | 17.7514 | 17.8611 | 17.7514 | 17.7857 | 105756.0 |
| 2013-10-16 04:05:00 | AAPL | Stock | 17.7743 | 17.7743 | 17.7743 | 17.7743 | 22400.0 |
| 2013-10-16 04:10:00 | AAPL | Stock | 17.7661 | 17.7661 | 17.7661 | 17.7661 | 2800.0 |
| 2013-10-16 04:15:00 | AAPL | Stock | 17.7211 | 17.7636 | 17.7211 | 17.75 | 59472.0 |
| 2013-10-16 04:20:00 | AAPL | Stock | 17.7321 | 17.7321 | 17.7321 | 17.7321 | 4200.0 |
| 2013-10-16 04:25:00 | AAPL | Stock | 17.7232 | 17.7232 | 17.7232 | 17.7232 | 30240.0 |
| 2013-10-16 04:30:00 | AAPL | Stock | 17.7318 | 17.7321 | 17.7232 | 17.7232 | 33600.0 |
| 2013-10-16 04:35:00 | AAPL | Stock | 17.7239 | 17.7239 | 17.7239 | 17.7239 | 2800.0 |
| 2013-10-16 04:45:00 | AAPL | Stock | 17.7286 | 17.7286 | 17.7239 | 17.7239 | 39200.0 |
| 2013-10-16 04:50:00 | AAPL | Stock | 17.7286 | 17.7286 | 17.7286 | 17.7286 | 6580.0 |
| 2013-10-16 04:55:00 | AAPL | Stock | 17.7357 | 17.7404 | 17.7321 | 17.7404 | 8400.0 |
| 2013-10-16 05:00:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 2800.0 |
| 2013-10-16 05:10:00 | AAPL | Stock | 17.7429 | 17.7593 | 17.7429 | 17.75 | 71400.0 |
| 2013-10-16 05:15:00 | AAPL | Stock | 17.7593 | 17.7736 | 17.75 | 17.75 | 30800.0 |
| 2013-10-16 05:20:00 | AAPL | Stock | 17.7661 | 17.7782 | 17.75 | 17.7782 | 67200.0 |
| 2013-10-16 05:25:00 | AAPL | Stock | 17.7554 | 17.7764 | 17.7525 | 17.7564 | 32508.0 |
| 2013-10-16 05:35:00 | AAPL | Stock | 17.7746 | 17.7843 | 17.75 | 17.7536 | 42000.0 |
| 2013-10-16 05:40:00 | AAPL | Stock | 17.7536 | 17.7536 | 17.7482 | 17.7493 | 44800.0 |
| 2013-10-16 05:50:00 | AAPL | Stock | 17.7364 | 17.7429 | 17.7357 | 17.7357 | 30800.0 |
| 2013-10-16 05:55:00 | AAPL | Stock | 17.7429 | 17.7429 | 17.7325 | 17.7325 | 22624.0 |
| 2013-10-16 06:05:00 | AAPL | Stock | 17.75 | 17.7761 | 17.7379 | 17.7379 | 47600.0 |
| 2013-10-16 06:10:00 | AAPL | Stock | 17.7482 | 17.7482 | 17.7321 | 17.7321 | 30212.0 |
| 2013-10-16 06:15:00 | AAPL | Stock | 17.7321 | 17.7321 | 17.7321 | 17.7321 | 38248.0 |
| 2013-10-16 06:20:00 | AAPL | Stock | 17.7446 | 17.7568 | 17.7446 | 17.75 | 36904.0 |
| 2013-10-16 06:25:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 2800.0 |
| 2013-10-16 06:30:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 11312.0 |
| 2013-10-16 06:35:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 2800.0 |
| 2013-10-16 06:40:00 | AAPL | Stock | 17.7396 | 17.7396 | 17.7321 | 17.7321 | 27272.0 |
| 2013-10-16 06:45:00 | AAPL | Stock | 17.7321 | 17.7321 | 17.7275 | 17.7275 | 10192.0 |
| 2013-10-16 06:50:00 | AAPL | Stock | 17.7296 | 17.7296 | 17.7236 | 17.7236 | 17556.0 |
| 2013-10-16 06:55:00 | AAPL | Stock | 17.7457 | 17.7979 | 17.7457 | 17.7979 | 208040.0 |
| 2013-10-16 07:00:00 | AAPL | Stock | 17.7989 | 17.8571 | 17.7914 | 17.8036 | 326200.0 |
| 2013-10-16 07:05:00 | AAPL | Stock | 17.8125 | 17.8836 | 17.8054 | 17.8571 | 166796.0 |
| 2013-10-16 07:10:00 | AAPL | Stock | 17.8671 | 17.9286 | 17.8568 | 17.9232 | 247576.0 |
| 2013-10-16 07:15:00 | AAPL | Stock | 17.9236 | 17.9286 | 17.875 | 17.8929 | 271460.0 |
| 2013-10-16 07:20:00 | AAPL | Stock | 17.8857 | 17.8989 | 17.8857 | 17.8857 | 28000.0 |
| 2013-10-16 07:25:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8857 | 17.8929 | 44800.0 |
| 2013-10-16 07:30:00 | AAPL | Stock | 17.9029 | 17.9107 | 17.8929 | 17.9021 | 143864.0 |
| 2013-10-16 07:35:00 | AAPL | Stock | 17.9 | 17.9068 | 17.8989 | 17.8989 | 84000.0 |
| 2013-10-16 07:40:00 | AAPL | Stock | 17.8968 | 17.8968 | 17.8825 | 17.8825 | 370692.0 |
| 2013-10-16 07:45:00 | AAPL | Stock | 17.8893 | 17.9043 | 17.8839 | 17.9043 | 247548.0 |
| 2013-10-16 07:50:00 | AAPL | Stock | 17.9043 | 17.9096 | 17.8964 | 17.9029 | 176540.0 |
| 2013-10-16 07:55:00 | AAPL | Stock | 17.8946 | 17.8964 | 17.8807 | 17.8868 | 43848.0 |
| 2013-10-16 08:00:00 | AAPL | Stock | 17.8829 | 17.9318 | 17.75 | 17.8807 | 844676.0 |
| 2013-10-16 08:05:00 | AAPL | Stock | 17.8811 | 17.8886 | 17.8807 | 17.8846 | 142212.0 |
| 2013-10-16 08:10:00 | AAPL | Stock | 17.8868 | 17.9057 | 17.8857 | 17.9021 | 234584.0 |
| 2013-10-16 08:15:00 | AAPL | Stock | 17.9021 | 17.9054 | 17.9 | 17.9004 | 90412.0 |
| 2013-10-16 08:20:00 | AAPL | Stock | 17.9036 | 17.9171 | 17.9018 | 17.9171 | 156660.0 |
| 2013-10-16 08:25:00 | AAPL | Stock | 17.9161 | 17.9196 | 17.9125 | 17.9129 | 233968.0 |
| 2013-10-16 08:30:00 | AAPL | Stock | 17.9129 | 17.9204 | 17.9125 | 17.9146 | 184324.0 |
> showing 50 of 347,153 rows — these rows as CSV