PREVIEW / stock_5min / 2015-01-28
file: by_date/stock_5min/2015/2015-01-28.parquet size: 5.5 MB rows: 363,068 symbols: 3,524
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-28 04:00:00 | AAPL | Stock | 28.87 | 29.1 | 28.87 | 29.005 | 50848.0 |
| 2015-01-28 04:05:00 | AAPL | Stock | 29.0925 | 29.1225 | 29.035 | 29.075 | 37744.0 |
| 2015-01-28 04:10:00 | AAPL | Stock | 29.0375 | 29.0625 | 29.0275 | 29.0525 | 40840.0 |
| 2015-01-28 04:15:00 | AAPL | Stock | 29.0625 | 29.1 | 29.025 | 29.0875 | 21120.0 |
| 2015-01-28 04:20:00 | AAPL | Stock | 29.025 | 29.1 | 29.025 | 29.0275 | 30000.0 |
| 2015-01-28 04:25:00 | AAPL | Stock | 29.025 | 29.025 | 29.025 | 29.025 | 1600.0 |
| 2015-01-28 04:30:00 | AAPL | Stock | 29.075 | 29.075 | 29.04 | 29.05 | 34040.0 |
| 2015-01-28 04:35:00 | AAPL | Stock | 29.0375 | 29.05 | 29.025 | 29.0475 | 41816.0 |
| 2015-01-28 04:40:00 | AAPL | Stock | 29.0475 | 29.05 | 29.0275 | 29.0475 | 15600.0 |
| 2015-01-28 04:45:00 | AAPL | Stock | 29.0475 | 29.075 | 29.0475 | 29.075 | 3668.0 |
| 2015-01-28 04:50:00 | AAPL | Stock | 29.075 | 29.0775 | 29.05 | 29.0725 | 7540.0 |
| 2015-01-28 04:55:00 | AAPL | Stock | 29.0525 | 29.1 | 29.05 | 29.05 | 11800.0 |
| 2015-01-28 05:00:00 | AAPL | Stock | 29.0275 | 29.0925 | 29.0275 | 29.05 | 4000.0 |
| 2015-01-28 05:05:00 | AAPL | Stock | 29.075 | 29.075 | 29.05 | 29.05 | 2400.0 |
| 2015-01-28 05:10:00 | AAPL | Stock | 29.05 | 29.085 | 29.05 | 29.05 | 5200.0 |
| 2015-01-28 05:15:00 | AAPL | Stock | 29.05 | 29.0875 | 29.05 | 29.0875 | 4772.0 |
| 2015-01-28 05:20:00 | AAPL | Stock | 29.0875 | 29.0875 | 29.05 | 29.05 | 4676.0 |
| 2015-01-28 05:25:00 | AAPL | Stock | 29.02 | 29.05 | 28.9 | 28.9 | 31544.0 |
| 2015-01-28 05:30:00 | AAPL | Stock | 28.975 | 28.975 | 28.9325 | 28.9325 | 5200.0 |
| 2015-01-28 05:35:00 | AAPL | Stock | 28.9375 | 29.025 | 28.9375 | 29.025 | 13396.0 |
| 2015-01-28 05:40:00 | AAPL | Stock | 29.0225 | 29.025 | 29.0225 | 29.025 | 1840.0 |
| 2015-01-28 05:45:00 | AAPL | Stock | 29.025 | 29.025 | 29.0 | 29.025 | 4840.0 |
| 2015-01-28 05:50:00 | AAPL | Stock | 29.0 | 29.0 | 29.0 | 29.0 | 7224.0 |
| 2015-01-28 05:55:00 | AAPL | Stock | 28.9875 | 28.9875 | 28.975 | 28.975 | 2848.0 |
| 2015-01-28 06:00:00 | AAPL | Stock | 29.0 | 29.17 | 29.0 | 29.125 | 51292.0 |
| 2015-01-28 06:05:00 | AAPL | Stock | 29.175 | 29.25 | 29.16 | 29.16 | 138216.0 |
| 2015-01-28 06:10:00 | AAPL | Stock | 29.175 | 29.225 | 29.15 | 29.1875 | 39440.0 |
| 2015-01-28 06:15:00 | AAPL | Stock | 29.19 | 29.2725 | 29.19 | 29.2375 | 135652.0 |
| 2015-01-28 06:20:00 | AAPL | Stock | 29.225 | 29.2875 | 29.225 | 29.225 | 64872.0 |
| 2015-01-28 06:25:00 | AAPL | Stock | 29.225 | 29.2725 | 29.225 | 29.2625 | 48972.0 |
| 2015-01-28 06:30:00 | AAPL | Stock | 29.25 | 29.3025 | 29.25 | 29.275 | 55740.0 |
| 2015-01-28 06:35:00 | AAPL | Stock | 29.275 | 29.275 | 29.1625 | 29.2125 | 170772.0 |
| 2015-01-28 06:40:00 | AAPL | Stock | 29.2025 | 29.23 | 29.175 | 29.23 | 59744.0 |
| 2015-01-28 06:45:00 | AAPL | Stock | 29.21 | 29.21 | 29.1875 | 29.1975 | 41108.0 |
| 2015-01-28 06:50:00 | AAPL | Stock | 29.2275 | 29.275 | 29.2125 | 29.275 | 227304.0 |
| 2015-01-28 06:55:00 | AAPL | Stock | 29.275 | 29.36 | 29.25 | 29.275 | 256068.0 |
| 2015-01-28 07:00:00 | AAPL | Stock | 29.2875 | 29.4875 | 29.2575 | 29.485 | 462972.0 |
| 2015-01-28 07:05:00 | AAPL | Stock | 29.485 | 29.575 | 29.375 | 29.4275 | 740272.0 |
| 2015-01-28 07:10:00 | AAPL | Stock | 29.425 | 29.57 | 29.425 | 29.545 | 375760.0 |
| 2015-01-28 07:15:00 | AAPL | Stock | 29.5475 | 29.575 | 29.475 | 29.5625 | 345168.0 |
| 2015-01-28 07:20:00 | AAPL | Stock | 29.5675 | 29.6375 | 29.5475 | 29.585 | 387436.0 |
| 2015-01-28 07:25:00 | AAPL | Stock | 29.5825 | 29.72 | 29.5625 | 29.7125 | 511784.0 |
| 2015-01-28 07:30:00 | AAPL | Stock | 29.7125 | 29.75 | 29.6375 | 29.7 | 564660.0 |
| 2015-01-28 07:35:00 | AAPL | Stock | 29.7 | 29.8125 | 29.66 | 29.8075 | 530072.0 |
| 2015-01-28 07:40:00 | AAPL | Stock | 29.8 | 29.8075 | 29.6675 | 29.6725 | 434420.0 |
| 2015-01-28 07:45:00 | AAPL | Stock | 29.6975 | 29.7 | 29.53 | 29.5625 | 462512.0 |
| 2015-01-28 07:50:00 | AAPL | Stock | 29.5675 | 29.65 | 29.525 | 29.6 | 536940.0 |
| 2015-01-28 07:55:00 | AAPL | Stock | 29.5975 | 29.6 | 29.5 | 29.5075 | 489700.0 |
| 2015-01-28 08:00:00 | AAPL | Stock | 29.4875 | 29.81 | 28.575 | 29.45 | 2811416.0 |
| 2015-01-28 08:05:00 | AAPL | Stock | 29.4325 | 29.5625 | 29.33 | 29.385 | 870856.0 |
> showing 50 of 363,068 rows — these rows as CSV