PREVIEW / stock_5min / 2015-01-05
file: by_date/stock_5min/2015/2015-01-05.parquet size: 5.6 MB rows: 371,224 symbols: 3,543
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-05 04:20:00 | AAPL | Stock | 27.3225 | 27.3225 | 27.3225 | 27.3225 | 400.0 |
| 2015-01-05 04:25:00 | AAPL | Stock | 27.305 | 27.305 | 27.305 | 27.305 | 1400.0 |
| 2015-01-05 04:55:00 | AAPL | Stock | 27.3 | 27.3 | 27.28 | 27.28 | 2800.0 |
| 2015-01-05 05:00:00 | AAPL | Stock | 27.3 | 27.3 | 27.295 | 27.2975 | 1600.0 |
| 2015-01-05 05:10:00 | AAPL | Stock | 27.28 | 27.28 | 27.28 | 27.28 | 676.0 |
| 2015-01-05 05:30:00 | AAPL | Stock | 27.2825 | 27.2825 | 27.2825 | 27.2825 | 1200.0 |
| 2015-01-05 05:35:00 | AAPL | Stock | 27.3 | 27.3 | 27.1375 | 27.1375 | 38000.0 |
| 2015-01-05 05:40:00 | AAPL | Stock | 27.28 | 27.28 | 27.28 | 27.28 | 400.0 |
| 2015-01-05 05:45:00 | AAPL | Stock | 27.2825 | 27.2825 | 27.275 | 27.2825 | 2400.0 |
| 2015-01-05 05:50:00 | AAPL | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 2000.0 |
| 2015-01-05 05:55:00 | AAPL | Stock | 27.2825 | 27.2825 | 27.28 | 27.28 | 13600.0 |
| 2015-01-05 06:00:00 | AAPL | Stock | 27.2875 | 27.3 | 27.275 | 27.275 | 5216.0 |
| 2015-01-05 06:05:00 | AAPL | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 14400.0 |
| 2015-01-05 06:10:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 1360.0 |
| 2015-01-05 06:30:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.2625 | 27.2625 | 400.0 |
| 2015-01-05 06:35:00 | AAPL | Stock | 27.275 | 27.275 | 27.275 | 27.275 | 2412.0 |
| 2015-01-05 06:45:00 | AAPL | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 400.0 |
| 2015-01-05 06:50:00 | AAPL | Stock | 27.3 | 27.3 | 27.275 | 27.275 | 6188.0 |
| 2015-01-05 06:55:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.225 | 27.225 | 3080.0 |
| 2015-01-05 07:00:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 4400.0 |
| 2015-01-05 07:05:00 | AAPL | Stock | 27.275 | 27.275 | 27.275 | 27.275 | 400.0 |
| 2015-01-05 07:10:00 | AAPL | Stock | 27.2575 | 27.2575 | 27.2525 | 27.2525 | 3600.0 |
| 2015-01-05 07:20:00 | AAPL | Stock | 27.25 | 27.2575 | 27.25 | 27.2575 | 4800.0 |
| 2015-01-05 07:25:00 | AAPL | Stock | 27.2575 | 27.2725 | 27.2575 | 27.2725 | 3200.0 |
| 2015-01-05 07:30:00 | AAPL | Stock | 27.29 | 27.3 | 27.29 | 27.3 | 5088.0 |
| 2015-01-05 07:35:00 | AAPL | Stock | 27.295 | 27.295 | 27.295 | 27.295 | 400.0 |
| 2015-01-05 07:40:00 | AAPL | Stock | 27.285 | 27.285 | 27.285 | 27.285 | 800.0 |
| 2015-01-05 07:45:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.28 | 27.28 | 800.0 |
| 2015-01-05 07:50:00 | AAPL | Stock | 27.28 | 27.28 | 27.28 | 27.28 | 400.0 |
| 2015-01-05 07:55:00 | AAPL | Stock | 27.275 | 27.2875 | 27.275 | 27.2875 | 11360.0 |
| 2015-01-05 08:00:00 | AAPL | Stock | 27.29 | 27.3 | 27.2575 | 27.2825 | 59252.0 |
| 2015-01-05 08:05:00 | AAPL | Stock | 27.2825 | 27.3 | 27.275 | 27.28 | 72712.0 |
| 2015-01-05 08:10:00 | AAPL | Stock | 27.28 | 27.28 | 27.2625 | 27.2625 | 30400.0 |
| 2015-01-05 08:15:00 | AAPL | Stock | 27.2725 | 27.2725 | 27.2625 | 27.2625 | 19896.0 |
| 2015-01-05 08:20:00 | AAPL | Stock | 27.255 | 27.255 | 27.25 | 27.255 | 2924.0 |
| 2015-01-05 08:25:00 | AAPL | Stock | 27.25 | 27.26 | 27.25 | 27.25 | 20108.0 |
| 2015-01-05 08:30:00 | AAPL | Stock | 27.25 | 27.26 | 27.2275 | 27.2275 | 41824.0 |
| 2015-01-05 08:35:00 | AAPL | Stock | 27.2275 | 27.2275 | 27.1875 | 27.1925 | 82872.0 |
| 2015-01-05 08:40:00 | AAPL | Stock | 27.1975 | 27.2 | 27.18 | 27.1875 | 42956.0 |
| 2015-01-05 08:45:00 | AAPL | Stock | 27.18 | 27.1825 | 27.175 | 27.175 | 16100.0 |
| 2015-01-05 08:50:00 | AAPL | Stock | 27.16 | 27.175 | 27.155 | 27.155 | 48252.0 |
| 2015-01-05 08:55:00 | AAPL | Stock | 27.155 | 27.155 | 27.1375 | 27.1475 | 83364.0 |
| 2015-01-05 09:00:00 | AAPL | Stock | 27.155 | 27.175 | 27.1475 | 27.1625 | 75440.0 |
| 2015-01-05 09:05:00 | AAPL | Stock | 27.1525 | 27.175 | 27.1525 | 27.1625 | 115740.0 |
| 2015-01-05 09:10:00 | AAPL | Stock | 27.16 | 27.16 | 27.1275 | 27.1425 | 66100.0 |
| 2015-01-05 09:15:00 | AAPL | Stock | 27.1375 | 27.1375 | 27.1 | 27.1125 | 24188.0 |
| 2015-01-05 09:20:00 | AAPL | Stock | 27.1325 | 27.1375 | 27.1 | 27.12 | 89044.0 |
| 2015-01-05 09:25:00 | AAPL | Stock | 27.12 | 27.13 | 27.05 | 27.0725 | 116232.0 |
| 2015-01-05 09:30:00 | AAPL | Stock | 27.0725 | 27.1625 | 26.955 | 27.1388 | 9155468.0 |
| 2015-01-05 09:35:00 | AAPL | Stock | 27.1375 | 27.1575 | 26.905 | 26.9175 | 5265724.0 |
> showing 50 of 371,224 rows — these rows as CSV