PREVIEW / stock_5min / 2014-07-15
file: by_date/stock_5min/2014/2014-07-15.parquet size: 5.3 MB rows: 356,271 symbols: 3,586
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-15 04:00:00 | AAPL | Stock | 24.1875 | 24.2025 | 24.1875 | 24.2025 | 12416.0 |
| 2014-07-15 04:10:00 | AAPL | Stock | 24.2 | 24.2 | 24.2 | 24.2 | 400.0 |
| 2014-07-15 04:15:00 | AAPL | Stock | 24.195 | 24.195 | 24.195 | 24.195 | 400.0 |
| 2014-07-15 04:30:00 | AAPL | Stock | 24.18 | 24.18 | 24.18 | 24.18 | 4000.0 |
| 2014-07-15 04:35:00 | AAPL | Stock | 24.18 | 24.18 | 24.18 | 24.18 | 3200.0 |
| 2014-07-15 04:45:00 | AAPL | Stock | 24.1675 | 24.1675 | 24.1675 | 24.1675 | 2000.0 |
| 2014-07-15 04:50:00 | AAPL | Stock | 24.1675 | 24.1675 | 24.1675 | 24.1675 | 3136.0 |
| 2014-07-15 05:15:00 | AAPL | Stock | 24.1675 | 24.1675 | 24.1675 | 24.1675 | 400.0 |
| 2014-07-15 05:35:00 | AAPL | Stock | 24.1675 | 24.1675 | 24.1675 | 24.1675 | 2180.0 |
| 2014-07-15 06:00:00 | AAPL | Stock | 24.1775 | 24.1775 | 24.1775 | 24.1775 | 2200.0 |
| 2014-07-15 06:05:00 | AAPL | Stock | 24.17 | 24.17 | 24.17 | 24.17 | 1540.0 |
| 2014-07-15 06:10:00 | AAPL | Stock | 24.175 | 24.175 | 24.175 | 24.175 | 1600.0 |
| 2014-07-15 06:20:00 | AAPL | Stock | 24.17 | 24.17 | 24.17 | 24.17 | 1100.0 |
| 2014-07-15 06:30:00 | AAPL | Stock | 24.175 | 24.175 | 24.175 | 24.175 | 412.0 |
| 2014-07-15 06:35:00 | AAPL | Stock | 24.1625 | 24.1625 | 24.16 | 24.16 | 19244.0 |
| 2014-07-15 06:45:00 | AAPL | Stock | 24.1525 | 24.155 | 24.15 | 24.155 | 2000.0 |
| 2014-07-15 07:00:00 | AAPL | Stock | 24.1625 | 24.165 | 24.1625 | 24.165 | 10640.0 |
| 2014-07-15 07:05:00 | AAPL | Stock | 24.1625 | 24.175 | 24.16 | 24.175 | 14068.0 |
| 2014-07-15 07:10:00 | AAPL | Stock | 24.18 | 24.2 | 24.18 | 24.2 | 10200.0 |
| 2014-07-15 07:15:00 | AAPL | Stock | 24.2175 | 24.225 | 24.215 | 24.2175 | 25488.0 |
| 2014-07-15 07:20:00 | AAPL | Stock | 24.225 | 24.2375 | 24.225 | 24.2375 | 11000.0 |
| 2014-07-15 07:25:00 | AAPL | Stock | 24.2325 | 24.2325 | 24.2275 | 24.2275 | 3600.0 |
| 2014-07-15 07:30:00 | AAPL | Stock | 24.2275 | 24.2275 | 24.2125 | 24.2125 | 14552.0 |
| 2014-07-15 07:35:00 | AAPL | Stock | 24.2025 | 24.2125 | 24.2025 | 24.2125 | 9016.0 |
| 2014-07-15 07:40:00 | AAPL | Stock | 24.225 | 24.23 | 24.2125 | 24.2225 | 14920.0 |
| 2014-07-15 07:45:00 | AAPL | Stock | 24.2075 | 24.2075 | 24.2075 | 24.2075 | 6000.0 |
| 2014-07-15 07:50:00 | AAPL | Stock | 24.2175 | 24.2175 | 24.2075 | 24.2125 | 9200.0 |
| 2014-07-15 07:55:00 | AAPL | Stock | 24.2125 | 24.2125 | 24.2125 | 24.2125 | 4000.0 |
| 2014-07-15 08:00:00 | AAPL | Stock | 24.2075 | 24.2375 | 24.075 | 24.2 | 163096.0 |
| 2014-07-15 08:05:00 | AAPL | Stock | 24.21 | 24.21 | 24.1875 | 24.1875 | 47368.0 |
| 2014-07-15 08:10:00 | AAPL | Stock | 24.1975 | 24.1975 | 24.1775 | 24.1925 | 40184.0 |
| 2014-07-15 08:15:00 | AAPL | Stock | 24.1925 | 24.1925 | 24.18 | 24.19 | 96596.0 |
| 2014-07-15 08:20:00 | AAPL | Stock | 24.1975 | 24.2 | 24.1925 | 24.195 | 28052.0 |
| 2014-07-15 08:25:00 | AAPL | Stock | 24.195 | 24.2 | 24.18 | 24.1875 | 41480.0 |
| 2014-07-15 08:30:00 | AAPL | Stock | 24.1875 | 24.1875 | 24.18 | 24.1825 | 33452.0 |
| 2014-07-15 08:35:00 | AAPL | Stock | 24.1875 | 24.1975 | 24.1825 | 24.1975 | 30848.0 |
| 2014-07-15 08:40:00 | AAPL | Stock | 24.1975 | 24.2025 | 24.19 | 24.2 | 38840.0 |
| 2014-07-15 08:45:00 | AAPL | Stock | 24.2 | 24.2 | 24.19 | 24.1925 | 16764.0 |
| 2014-07-15 08:50:00 | AAPL | Stock | 24.1925 | 24.2 | 24.1925 | 24.1975 | 24360.0 |
| 2014-07-15 08:55:00 | AAPL | Stock | 24.2 | 24.2 | 24.1975 | 24.2 | 17160.0 |
| 2014-07-15 09:00:00 | AAPL | Stock | 24.2 | 24.205 | 24.19 | 24.205 | 46144.0 |
| 2014-07-15 09:05:00 | AAPL | Stock | 24.205 | 24.2225 | 24.2025 | 24.2175 | 75000.0 |
| 2014-07-15 09:10:00 | AAPL | Stock | 24.215 | 24.2175 | 24.2025 | 24.21 | 25068.0 |
| 2014-07-15 09:15:00 | AAPL | Stock | 24.2125 | 24.22 | 24.2025 | 24.2175 | 45416.0 |
| 2014-07-15 09:20:00 | AAPL | Stock | 24.21 | 24.2175 | 24.2025 | 24.2125 | 27920.0 |
| 2014-07-15 09:25:00 | AAPL | Stock | 24.2125 | 24.225 | 24.195 | 24.195 | 102828.0 |
| 2014-07-15 09:30:00 | AAPL | Stock | 24.2 | 24.2125 | 24.1425 | 24.165 | 7810892.0 |
| 2014-07-15 09:35:00 | AAPL | Stock | 24.165 | 24.185 | 24.1025 | 24.1175 | 3959820.0 |
| 2014-07-15 09:40:00 | AAPL | Stock | 24.115 | 24.175 | 24.115 | 24.17 | 3162072.0 |
| 2014-07-15 09:45:00 | AAPL | Stock | 24.17 | 24.1925 | 24.165 | 24.17 | 2497316.0 |
> showing 50 of 356,271 rows — these rows as CSV