PREVIEW / stock_5min / 2015-03-13
file: by_date/stock_5min/2015/2015-03-13.parquet size: 5.4 MB rows: 356,102 symbols: 3,489
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-13 04:00:00 | AAPL | Stock | 31.2 | 31.2 | 31.2 | 31.2 | 2000.0 |
| 2015-03-13 04:20:00 | AAPL | Stock | 31.1875 | 31.1875 | 31.17 | 31.17 | 6400.0 |
| 2015-03-13 04:30:00 | AAPL | Stock | 31.21 | 31.2125 | 31.21 | 31.2125 | 4000.0 |
| 2015-03-13 04:35:00 | AAPL | Stock | 31.2 | 31.2 | 31.17 | 31.17 | 3200.0 |
| 2015-03-13 04:40:00 | AAPL | Stock | 31.17 | 31.17 | 31.17 | 31.17 | 1200.0 |
| 2015-03-13 04:50:00 | AAPL | Stock | 31.175 | 31.1875 | 31.175 | 31.1875 | 4400.0 |
| 2015-03-13 05:05:00 | AAPL | Stock | 31.1925 | 31.1925 | 31.1925 | 31.1925 | 400.0 |
| 2015-03-13 05:15:00 | AAPL | Stock | 31.1875 | 31.1875 | 31.1875 | 31.1875 | 2000.0 |
| 2015-03-13 05:30:00 | AAPL | Stock | 31.1975 | 31.1975 | 31.195 | 31.195 | 800.0 |
| 2015-03-13 05:35:00 | AAPL | Stock | 31.215 | 31.215 | 31.215 | 31.215 | 3600.0 |
| 2015-03-13 05:40:00 | AAPL | Stock | 31.23 | 31.23 | 31.23 | 31.23 | 3600.0 |
| 2015-03-13 05:45:00 | AAPL | Stock | 31.225 | 31.225 | 31.225 | 31.225 | 800.0 |
| 2015-03-13 05:55:00 | AAPL | Stock | 31.225 | 31.3 | 31.2125 | 31.3 | 26720.0 |
| 2015-03-13 06:00:00 | AAPL | Stock | 31.2325 | 31.2325 | 31.2325 | 31.2325 | 800.0 |
| 2015-03-13 06:05:00 | AAPL | Stock | 31.2325 | 31.2475 | 31.2325 | 31.2475 | 4000.0 |
| 2015-03-13 06:10:00 | AAPL | Stock | 31.235 | 31.245 | 31.2275 | 31.245 | 9252.0 |
| 2015-03-13 06:15:00 | AAPL | Stock | 31.23 | 31.23 | 31.2 | 31.2125 | 12640.0 |
| 2015-03-13 06:20:00 | AAPL | Stock | 31.2 | 31.2 | 31.185 | 31.2 | 13076.0 |
| 2015-03-13 06:30:00 | AAPL | Stock | 31.215 | 31.25 | 31.215 | 31.25 | 19600.0 |
| 2015-03-13 06:40:00 | AAPL | Stock | 31.245 | 31.25 | 31.215 | 31.215 | 4800.0 |
| 2015-03-13 06:45:00 | AAPL | Stock | 31.2225 | 31.225 | 31.215 | 31.225 | 6800.0 |
| 2015-03-13 06:50:00 | AAPL | Stock | 31.2275 | 31.2275 | 31.225 | 31.225 | 4400.0 |
| 2015-03-13 06:55:00 | AAPL | Stock | 31.2275 | 31.2275 | 31.225 | 31.225 | 8800.0 |
| 2015-03-13 07:00:00 | AAPL | Stock | 31.225 | 31.25 | 31.225 | 31.225 | 45600.0 |
| 2015-03-13 07:05:00 | AAPL | Stock | 31.225 | 31.225 | 31.225 | 31.225 | 4396.0 |
| 2015-03-13 07:10:00 | AAPL | Stock | 31.225 | 31.2375 | 31.225 | 31.225 | 11232.0 |
| 2015-03-13 07:15:00 | AAPL | Stock | 31.2125 | 31.2125 | 31.2125 | 31.2125 | 400.0 |
| 2015-03-13 07:20:00 | AAPL | Stock | 31.2225 | 31.2225 | 31.2225 | 31.2225 | 2000.0 |
| 2015-03-13 07:25:00 | AAPL | Stock | 31.2125 | 31.2125 | 31.2125 | 31.2125 | 800.0 |
| 2015-03-13 07:30:00 | AAPL | Stock | 31.2125 | 31.225 | 31.2125 | 31.225 | 7508.0 |
| 2015-03-13 07:35:00 | AAPL | Stock | 31.2225 | 31.2275 | 31.2125 | 31.2125 | 11800.0 |
| 2015-03-13 07:40:00 | AAPL | Stock | 31.2125 | 31.2125 | 31.2075 | 31.2075 | 4380.0 |
| 2015-03-13 07:45:00 | AAPL | Stock | 31.2025 | 31.205 | 31.1875 | 31.1875 | 18436.0 |
| 2015-03-13 07:50:00 | AAPL | Stock | 31.185 | 31.19 | 31.155 | 31.155 | 34284.0 |
| 2015-03-13 07:55:00 | AAPL | Stock | 31.165 | 31.165 | 31.135 | 31.1375 | 21084.0 |
| 2015-03-13 08:00:00 | AAPL | Stock | 31.1625 | 31.25 | 31.125 | 31.17 | 140132.0 |
| 2015-03-13 08:05:00 | AAPL | Stock | 31.165 | 31.18 | 31.155 | 31.155 | 23464.0 |
| 2015-03-13 08:10:00 | AAPL | Stock | 31.15 | 31.1525 | 31.1375 | 31.14 | 27944.0 |
| 2015-03-13 08:15:00 | AAPL | Stock | 31.14 | 31.14 | 31.085 | 31.085 | 83020.0 |
| 2015-03-13 08:20:00 | AAPL | Stock | 31.09 | 31.1175 | 31.0825 | 31.0825 | 63412.0 |
| 2015-03-13 08:25:00 | AAPL | Stock | 31.0775 | 31.0825 | 31.0575 | 31.08 | 44932.0 |
| 2015-03-13 08:30:00 | AAPL | Stock | 31.0575 | 31.11 | 31.0575 | 31.0875 | 21556.0 |
| 2015-03-13 08:35:00 | AAPL | Stock | 31.1 | 31.125 | 31.1 | 31.1125 | 22000.0 |
| 2015-03-13 08:40:00 | AAPL | Stock | 31.1075 | 31.1125 | 31.1 | 31.1125 | 27076.0 |
| 2015-03-13 08:45:00 | AAPL | Stock | 31.1025 | 31.12 | 31.05 | 31.05 | 43320.0 |
| 2015-03-13 08:50:00 | AAPL | Stock | 31.0525 | 31.0625 | 31.0375 | 31.05 | 35440.0 |
| 2015-03-13 08:55:00 | AAPL | Stock | 31.05 | 31.0925 | 31.05 | 31.07 | 61880.0 |
| 2015-03-13 09:00:00 | AAPL | Stock | 31.0775 | 31.105 | 31.0725 | 31.075 | 17200.0 |
| 2015-03-13 09:05:00 | AAPL | Stock | 31.07 | 31.075 | 31.0275 | 31.055 | 156236.0 |
| 2015-03-13 09:10:00 | AAPL | Stock | 31.05 | 31.0575 | 31.0325 | 31.0575 | 49972.0 |
> showing 50 of 356,102 rows — these rows as CSV