PREVIEW / stock_5min / 2015-03-03
file: by_date/stock_5min/2015/2015-03-03.parquet size: 5.5 MB rows: 362,797 symbols: 3,517
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-03-03 04:00:00 | AAPL | Stock | 32.225 | 32.225 | 32.225 | 32.225 | 400.0 |
| 2015-03-03 04:15:00 | AAPL | Stock | 32.275 | 32.275 | 32.275 | 32.275 | 600.0 |
| 2015-03-03 05:00:00 | AAPL | Stock | 32.2725 | 32.2725 | 32.25 | 32.25 | 2260.0 |
| 2015-03-03 05:05:00 | AAPL | Stock | 32.25 | 32.2725 | 32.25 | 32.2725 | 2260.0 |
| 2015-03-03 05:10:00 | AAPL | Stock | 32.2725 | 32.275 | 32.2725 | 32.2725 | 4800.0 |
| 2015-03-03 05:20:00 | AAPL | Stock | 32.2725 | 32.2725 | 32.2725 | 32.2725 | 400.0 |
| 2015-03-03 05:25:00 | AAPL | Stock | 32.2725 | 32.2725 | 32.2725 | 32.2725 | 1200.0 |
| 2015-03-03 05:30:00 | AAPL | Stock | 32.2525 | 32.275 | 32.25 | 32.275 | 7908.0 |
| 2015-03-03 05:35:00 | AAPL | Stock | 32.295 | 32.295 | 32.295 | 32.295 | 1644.0 |
| 2015-03-03 05:45:00 | AAPL | Stock | 32.295 | 32.295 | 32.295 | 32.295 | 1200.0 |
| 2015-03-03 05:50:00 | AAPL | Stock | 32.295 | 32.295 | 32.295 | 32.295 | 400.0 |
| 2015-03-03 05:55:00 | AAPL | Stock | 32.295 | 32.295 | 32.295 | 32.295 | 1600.0 |
| 2015-03-03 06:00:00 | AAPL | Stock | 32.295 | 32.295 | 32.295 | 32.295 | 400.0 |
| 2015-03-03 06:05:00 | AAPL | Stock | 32.2825 | 32.2975 | 32.2825 | 32.295 | 5056.0 |
| 2015-03-03 06:10:00 | AAPL | Stock | 32.275 | 32.2975 | 32.275 | 32.2975 | 1200.0 |
| 2015-03-03 06:15:00 | AAPL | Stock | 32.295 | 32.2975 | 32.295 | 32.2975 | 4980.0 |
| 2015-03-03 06:20:00 | AAPL | Stock | 32.3075 | 32.325 | 32.3075 | 32.325 | 1600.0 |
| 2015-03-03 06:35:00 | AAPL | Stock | 32.325 | 32.325 | 32.325 | 32.325 | 1780.0 |
| 2015-03-03 06:40:00 | AAPL | Stock | 32.325 | 32.325 | 32.325 | 32.325 | 1496.0 |
| 2015-03-03 06:45:00 | AAPL | Stock | 32.325 | 32.325 | 32.325 | 32.325 | 2876.0 |
| 2015-03-03 06:55:00 | AAPL | Stock | 32.3225 | 32.3225 | 32.3125 | 32.3125 | 2000.0 |
| 2015-03-03 07:00:00 | AAPL | Stock | 32.3025 | 32.3125 | 32.3025 | 32.3125 | 11600.0 |
| 2015-03-03 07:05:00 | AAPL | Stock | 32.3125 | 32.3125 | 32.3125 | 32.3125 | 10468.0 |
| 2015-03-03 07:10:00 | AAPL | Stock | 32.3075 | 32.3125 | 32.3075 | 32.3125 | 4000.0 |
| 2015-03-03 07:15:00 | AAPL | Stock | 32.3125 | 32.3125 | 32.3125 | 32.3125 | 1412.0 |
| 2015-03-03 07:20:00 | AAPL | Stock | 32.3225 | 32.325 | 32.3225 | 32.325 | 4760.0 |
| 2015-03-03 07:25:00 | AAPL | Stock | 32.33 | 32.3325 | 32.33 | 32.3325 | 1600.0 |
| 2015-03-03 07:30:00 | AAPL | Stock | 32.3325 | 32.3375 | 32.315 | 32.3175 | 13812.0 |
| 2015-03-03 07:35:00 | AAPL | Stock | 32.3025 | 32.325 | 32.3025 | 32.325 | 3200.0 |
| 2015-03-03 07:40:00 | AAPL | Stock | 32.3075 | 32.315 | 32.3 | 32.3 | 4980.0 |
| 2015-03-03 07:50:00 | AAPL | Stock | 32.315 | 32.3175 | 32.3 | 32.3125 | 12400.0 |
| 2015-03-03 07:55:00 | AAPL | Stock | 32.305 | 32.3125 | 32.2925 | 32.3 | 15464.0 |
| 2015-03-03 08:00:00 | AAPL | Stock | 32.2975 | 32.3325 | 32.2375 | 32.245 | 137760.0 |
| 2015-03-03 08:05:00 | AAPL | Stock | 32.2475 | 32.265 | 32.2475 | 32.2575 | 60236.0 |
| 2015-03-03 08:10:00 | AAPL | Stock | 32.2575 | 32.2675 | 32.255 | 32.2625 | 33528.0 |
| 2015-03-03 08:15:00 | AAPL | Stock | 32.265 | 32.265 | 32.245 | 32.25 | 10360.0 |
| 2015-03-03 08:20:00 | AAPL | Stock | 32.2575 | 32.2575 | 32.2175 | 32.2175 | 46060.0 |
| 2015-03-03 08:25:00 | AAPL | Stock | 32.225 | 32.235 | 32.195 | 32.2025 | 44760.0 |
| 2015-03-03 08:30:00 | AAPL | Stock | 32.205 | 32.215 | 32.1625 | 32.175 | 45324.0 |
| 2015-03-03 08:35:00 | AAPL | Stock | 32.175 | 32.195 | 32.175 | 32.1825 | 25612.0 |
| 2015-03-03 08:40:00 | AAPL | Stock | 32.1775 | 32.2 | 32.175 | 32.2 | 17440.0 |
| 2015-03-03 08:45:00 | AAPL | Stock | 32.1975 | 32.2 | 32.1875 | 32.2 | 13276.0 |
| 2015-03-03 08:50:00 | AAPL | Stock | 32.2 | 32.2275 | 32.1675 | 32.2275 | 41200.0 |
| 2015-03-03 08:55:00 | AAPL | Stock | 32.2125 | 32.2375 | 32.21 | 32.2275 | 54412.0 |
| 2015-03-03 09:00:00 | AAPL | Stock | 32.225 | 32.2275 | 32.195 | 32.2 | 18300.0 |
| 2015-03-03 09:05:00 | AAPL | Stock | 32.21 | 32.215 | 32.1975 | 32.215 | 15900.0 |
| 2015-03-03 09:10:00 | AAPL | Stock | 32.21 | 32.2125 | 32.1975 | 32.2125 | 47952.0 |
| 2015-03-03 09:15:00 | AAPL | Stock | 32.2225 | 32.225 | 32.1975 | 32.2075 | 50284.0 |
| 2015-03-03 09:20:00 | AAPL | Stock | 32.2025 | 32.2125 | 32.1975 | 32.205 | 33808.0 |
| 2015-03-03 09:25:00 | AAPL | Stock | 32.2125 | 32.285 | 32.2125 | 32.24 | 230052.0 |
> showing 50 of 362,797 rows — these rows as CSV