PREVIEW / stock_5min / 2015-05-18
file: by_date/stock_5min/2015/2015-05-18.parquet size: 5.5 MB rows: 363,188 symbols: 3,502
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-05-18 04:00:00 | AAPL | Stock | 32.195 | 32.2 | 32.195 | 32.2 | 3700.0 |
| 2015-05-18 04:05:00 | AAPL | Stock | 32.175 | 32.175 | 32.175 | 32.175 | 3024.0 |
| 2015-05-18 04:20:00 | AAPL | Stock | 32.1875 | 32.1875 | 32.1875 | 32.1875 | 12000.0 |
| 2015-05-18 05:15:00 | AAPL | Stock | 32.175 | 32.175 | 32.175 | 32.175 | 800.0 |
| 2015-05-18 05:30:00 | AAPL | Stock | 32.2125 | 32.2125 | 32.2125 | 32.2125 | 800.0 |
| 2015-05-18 05:50:00 | AAPL | Stock | 32.2125 | 32.22 | 32.205 | 32.205 | 5376.0 |
| 2015-05-18 05:55:00 | AAPL | Stock | 32.22 | 32.22 | 32.215 | 32.215 | 1200.0 |
| 2015-05-18 06:05:00 | AAPL | Stock | 32.19 | 32.19 | 32.19 | 32.19 | 400.0 |
| 2015-05-18 06:10:00 | AAPL | Stock | 32.17 | 32.17 | 32.1625 | 32.1625 | 2800.0 |
| 2015-05-18 06:15:00 | AAPL | Stock | 32.1525 | 32.1525 | 32.15 | 32.15 | 5600.0 |
| 2015-05-18 06:20:00 | AAPL | Stock | 32.1025 | 32.1125 | 32.1025 | 32.1125 | 8400.0 |
| 2015-05-18 06:30:00 | AAPL | Stock | 32.08 | 32.08 | 32.0775 | 32.0775 | 2572.0 |
| 2015-05-18 06:35:00 | AAPL | Stock | 32.0875 | 32.0875 | 32.0875 | 32.0875 | 1000.0 |
| 2015-05-18 06:45:00 | AAPL | Stock | 32.0975 | 32.1 | 32.0975 | 32.1 | 9560.0 |
| 2015-05-18 07:00:00 | AAPL | Stock | 32.1075 | 32.11 | 32.1075 | 32.11 | 1400.0 |
| 2015-05-18 07:05:00 | AAPL | Stock | 32.095 | 32.095 | 32.095 | 32.095 | 2000.0 |
| 2015-05-18 07:10:00 | AAPL | Stock | 32.11 | 32.1225 | 32.11 | 32.1225 | 2200.0 |
| 2015-05-18 07:15:00 | AAPL | Stock | 32.125 | 32.1275 | 32.1125 | 32.125 | 19200.0 |
| 2015-05-18 07:20:00 | AAPL | Stock | 32.1175 | 32.1175 | 32.1175 | 32.1175 | 2800.0 |
| 2015-05-18 07:30:00 | AAPL | Stock | 32.11 | 32.11 | 32.11 | 32.11 | 800.0 |
| 2015-05-18 07:35:00 | AAPL | Stock | 32.0975 | 32.0975 | 32.0925 | 32.0925 | 2516.0 |
| 2015-05-18 07:40:00 | AAPL | Stock | 32.0925 | 32.0925 | 32.085 | 32.085 | 9228.0 |
| 2015-05-18 07:45:00 | AAPL | Stock | 32.0775 | 32.085 | 32.0775 | 32.0775 | 20120.0 |
| 2015-05-18 07:50:00 | AAPL | Stock | 32.0775 | 32.0775 | 32.0775 | 32.0775 | 11496.0 |
| 2015-05-18 07:55:00 | AAPL | Stock | 32.105 | 32.11 | 32.105 | 32.1075 | 4400.0 |
| 2015-05-18 08:00:00 | AAPL | Stock | 32.1025 | 32.1625 | 32.005 | 32.05 | 106480.0 |
| 2015-05-18 08:05:00 | AAPL | Stock | 32.0625 | 32.085 | 32.0625 | 32.085 | 31800.0 |
| 2015-05-18 08:10:00 | AAPL | Stock | 32.085 | 32.0925 | 32.07 | 32.07 | 32260.0 |
| 2015-05-18 08:15:00 | AAPL | Stock | 32.075 | 32.08 | 32.0748 | 32.08 | 18276.0 |
| 2015-05-18 08:20:00 | AAPL | Stock | 32.0825 | 32.0875 | 32.075 | 32.0875 | 23064.0 |
| 2015-05-18 08:25:00 | AAPL | Stock | 32.0875 | 32.0875 | 32.0725 | 32.0725 | 35660.0 |
| 2015-05-18 08:30:00 | AAPL | Stock | 32.075 | 32.0875 | 32.055 | 32.0825 | 40460.0 |
| 2015-05-18 08:35:00 | AAPL | Stock | 32.08 | 32.09 | 32.0752 | 32.0852 | 25444.0 |
| 2015-05-18 08:40:00 | AAPL | Stock | 32.0925 | 32.095 | 32.085 | 32.095 | 6888.0 |
| 2015-05-18 08:45:00 | AAPL | Stock | 32.1 | 32.125 | 32.1 | 32.125 | 29156.0 |
| 2015-05-18 08:50:00 | AAPL | Stock | 32.125 | 32.13 | 32.1125 | 32.1225 | 55080.0 |
| 2015-05-18 08:55:00 | AAPL | Stock | 32.115 | 32.1175 | 32.115 | 32.1175 | 10708.0 |
| 2015-05-18 09:00:00 | AAPL | Stock | 32.1125 | 32.1275 | 32.105 | 32.125 | 37724.0 |
| 2015-05-18 09:05:00 | AAPL | Stock | 32.125 | 32.1325 | 32.1075 | 32.1175 | 30892.0 |
| 2015-05-18 09:10:00 | AAPL | Stock | 32.1175 | 32.1775 | 32.1175 | 32.17 | 105692.0 |
| 2015-05-18 09:15:00 | AAPL | Stock | 32.1625 | 32.1625 | 32.135 | 32.1625 | 32364.0 |
| 2015-05-18 09:20:00 | AAPL | Stock | 32.1625 | 32.1625 | 32.1475 | 32.16 | 32436.0 |
| 2015-05-18 09:25:00 | AAPL | Stock | 32.1625 | 32.1625 | 32.095 | 32.095 | 144356.0 |
| 2015-05-18 09:30:00 | AAPL | Stock | 32.095 | 32.2875 | 32.09 | 32.28 | 5649308.0 |
| 2015-05-18 09:35:00 | AAPL | Stock | 32.2775 | 32.2925 | 32.23 | 32.2475 | 3685152.0 |
| 2015-05-18 09:40:00 | AAPL | Stock | 32.2475 | 32.3875 | 32.2475 | 32.3475 | 4846408.0 |
| 2015-05-18 09:45:00 | AAPL | Stock | 32.349 | 32.38 | 32.29 | 32.3175 | 3904224.0 |
| 2015-05-18 09:50:00 | AAPL | Stock | 32.3175 | 32.35 | 32.275 | 32.315 | 2518256.0 |
| 2015-05-18 09:55:00 | AAPL | Stock | 32.3155 | 32.3375 | 32.2975 | 32.3075 | 1507196.0 |
| 2015-05-18 10:00:00 | AAPL | Stock | 32.3125 | 32.3625 | 32.29 | 32.2965 | 2577364.0 |
> showing 50 of 363,188 rows — these rows as CSV