PREVIEW / stock_5min / 2014-01-24
file: by_date/stock_5min/2014/2014-01-24.parquet size: 5.8 MB rows: 374,706 symbols: 3,540
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-24 04:00:00 | AAPL | Stock | 19.8632 | 19.8632 | 19.8343 | 19.8343 | 5600.0 |
| 2014-01-24 04:15:00 | AAPL | Stock | 19.7679 | 19.7679 | 19.7679 | 19.7679 | 2800.0 |
| 2014-01-24 04:20:00 | AAPL | Stock | 19.7579 | 19.7579 | 19.7514 | 19.7514 | 5600.0 |
| 2014-01-24 04:25:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 8400.0 |
| 2014-01-24 04:30:00 | AAPL | Stock | 19.7718 | 19.8439 | 19.7718 | 19.8439 | 50400.0 |
| 2014-01-24 04:35:00 | AAPL | Stock | 19.8439 | 19.85 | 19.8439 | 19.8464 | 22400.0 |
| 2014-01-24 04:40:00 | AAPL | Stock | 19.8368 | 19.8368 | 19.8368 | 19.8368 | 2800.0 |
| 2014-01-24 05:00:00 | AAPL | Stock | 19.8025 | 19.8036 | 19.8025 | 19.8036 | 8400.0 |
| 2014-01-24 05:05:00 | AAPL | Stock | 19.7679 | 19.7679 | 19.7679 | 19.7679 | 5600.0 |
| 2014-01-24 05:10:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 2800.0 |
| 2014-01-24 05:20:00 | AAPL | Stock | 19.7571 | 19.7571 | 19.7361 | 19.7361 | 30800.0 |
| 2014-01-24 05:25:00 | AAPL | Stock | 19.7275 | 19.7379 | 19.7143 | 19.7289 | 42000.0 |
| 2014-01-24 05:30:00 | AAPL | Stock | 19.7146 | 19.7146 | 19.7146 | 19.7146 | 2800.0 |
| 2014-01-24 05:40:00 | AAPL | Stock | 19.7289 | 19.7289 | 19.7171 | 19.7171 | 10248.0 |
| 2014-01-24 05:50:00 | AAPL | Stock | 19.7218 | 19.7271 | 19.7218 | 19.7271 | 5600.0 |
| 2014-01-24 05:55:00 | AAPL | Stock | 19.7271 | 19.7271 | 19.7271 | 19.7271 | 21420.0 |
| 2014-01-24 06:00:00 | AAPL | Stock | 19.7143 | 19.7143 | 19.7143 | 19.7143 | 16520.0 |
| 2014-01-24 06:10:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.725 | 19.7321 | 8400.0 |
| 2014-01-24 06:15:00 | AAPL | Stock | 19.7146 | 19.7161 | 19.7146 | 19.7161 | 5600.0 |
| 2014-01-24 06:20:00 | AAPL | Stock | 19.7082 | 19.7082 | 19.6964 | 19.6964 | 11200.0 |
| 2014-01-24 06:25:00 | AAPL | Stock | 19.6964 | 19.6964 | 19.6964 | 19.6964 | 29400.0 |
| 2014-01-24 06:40:00 | AAPL | Stock | 19.6968 | 19.7004 | 19.6968 | 19.7004 | 11200.0 |
| 2014-01-24 06:50:00 | AAPL | Stock | 19.7211 | 19.7211 | 19.7054 | 19.7054 | 8400.0 |
| 2014-01-24 07:00:00 | AAPL | Stock | 19.7307 | 19.7618 | 19.7143 | 19.7461 | 113176.0 |
| 2014-01-24 07:05:00 | AAPL | Stock | 19.7332 | 19.7429 | 19.7311 | 19.7429 | 22400.0 |
| 2014-01-24 07:10:00 | AAPL | Stock | 19.7361 | 19.7461 | 19.7361 | 19.7461 | 7000.0 |
| 2014-01-24 07:15:00 | AAPL | Stock | 19.75 | 19.75 | 19.7343 | 19.7411 | 15904.0 |
| 2014-01-24 07:20:00 | AAPL | Stock | 19.7411 | 19.7411 | 19.7411 | 19.7411 | 5600.0 |
| 2014-01-24 07:25:00 | AAPL | Stock | 19.7343 | 19.7343 | 19.7232 | 19.7289 | 95452.0 |
| 2014-01-24 07:30:00 | AAPL | Stock | 19.7254 | 19.75 | 19.725 | 19.75 | 67172.0 |
| 2014-01-24 07:35:00 | AAPL | Stock | 19.7329 | 19.75 | 19.7329 | 19.75 | 44800.0 |
| 2014-01-24 07:40:00 | AAPL | Stock | 19.7454 | 19.7521 | 19.7454 | 19.7507 | 64400.0 |
| 2014-01-24 07:45:00 | AAPL | Stock | 19.7561 | 19.775 | 19.7536 | 19.7661 | 114436.0 |
| 2014-01-24 07:50:00 | AAPL | Stock | 19.7521 | 19.7521 | 19.7371 | 19.7371 | 78204.0 |
| 2014-01-24 07:55:00 | AAPL | Stock | 19.7446 | 19.75 | 19.7446 | 19.75 | 11480.0 |
| 2014-01-24 08:00:00 | AAPL | Stock | 19.7582 | 19.7764 | 19.7143 | 19.7711 | 289016.0 |
| 2014-01-24 08:05:00 | AAPL | Stock | 19.7693 | 19.7839 | 19.7643 | 19.7768 | 91756.0 |
| 2014-01-24 08:10:00 | AAPL | Stock | 19.7679 | 19.7839 | 19.7679 | 19.7839 | 95620.0 |
| 2014-01-24 08:15:00 | AAPL | Stock | 19.7785 | 19.7857 | 19.7754 | 19.7857 | 161504.0 |
| 2014-01-24 08:20:00 | AAPL | Stock | 19.7886 | 19.7929 | 19.7768 | 19.7832 | 137760.0 |
| 2014-01-24 08:25:00 | AAPL | Stock | 19.7829 | 19.7943 | 19.7679 | 19.7943 | 34608.0 |
| 2014-01-24 08:30:00 | AAPL | Stock | 19.7818 | 19.7821 | 19.7732 | 19.7775 | 30800.0 |
| 2014-01-24 08:35:00 | AAPL | Stock | 19.7775 | 19.7871 | 19.7775 | 19.7857 | 131600.0 |
| 2014-01-24 08:40:00 | AAPL | Stock | 19.7929 | 19.7954 | 19.7714 | 19.7829 | 102592.0 |
| 2014-01-24 08:45:00 | AAPL | Stock | 19.7821 | 19.7925 | 19.7693 | 19.7804 | 223804.0 |
| 2014-01-24 08:50:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7714 | 19.7714 | 280308.0 |
| 2014-01-24 08:55:00 | AAPL | Stock | 19.7764 | 19.7768 | 19.75 | 19.7696 | 128660.0 |
| 2014-01-24 09:00:00 | AAPL | Stock | 19.7629 | 19.7757 | 19.7575 | 19.775 | 193760.0 |
| 2014-01-24 09:05:00 | AAPL | Stock | 19.7779 | 19.7779 | 19.7614 | 19.77 | 148400.0 |
| 2014-01-24 09:10:00 | AAPL | Stock | 19.7711 | 19.7743 | 19.7571 | 19.7714 | 159404.0 |
> showing 50 of 374,706 rows — these rows as CSV