PREVIEW / stock_5min / 2015-11-09
file: by_date/stock_5min/2015/2015-11-09.parquet size: 5.5 MB rows: 362,976 symbols: 3,418
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-11-09 04:00:00 | AAPL | Stock | 30.255 | 30.255 | 30.255 | 30.255 | 800.0 |
| 2015-11-09 04:20:00 | AAPL | Stock | 30.2325 | 30.2325 | 30.2325 | 30.2325 | 800.0 |
| 2015-11-09 04:55:00 | AAPL | Stock | 30.2475 | 30.255 | 30.225 | 30.225 | 4352.0 |
| 2015-11-09 05:10:00 | AAPL | Stock | 30.2125 | 30.2125 | 30.2125 | 30.2125 | 1200.0 |
| 2015-11-09 05:50:00 | AAPL | Stock | 30.175 | 30.175 | 30.175 | 30.175 | 2000.0 |
| 2015-11-09 06:05:00 | AAPL | Stock | 30.175 | 30.175 | 30.175 | 30.175 | 404.0 |
| 2015-11-09 06:10:00 | AAPL | Stock | 30.15 | 30.15 | 30.15 | 30.15 | 944.0 |
| 2015-11-09 06:25:00 | AAPL | Stock | 30.175 | 30.1875 | 30.175 | 30.1875 | 1200.0 |
| 2015-11-09 06:35:00 | AAPL | Stock | 30.15 | 30.15 | 30.15 | 30.15 | 800.0 |
| 2015-11-09 06:40:00 | AAPL | Stock | 30.15 | 30.15 | 30.1375 | 30.1375 | 4636.0 |
| 2015-11-09 06:45:00 | AAPL | Stock | 30.1375 | 30.1375 | 30.1375 | 30.1375 | 1600.0 |
| 2015-11-09 06:55:00 | AAPL | Stock | 30.1475 | 30.1475 | 30.1475 | 30.1475 | 3600.0 |
| 2015-11-09 07:00:00 | AAPL | Stock | 30.1625 | 30.1625 | 30.1625 | 30.1625 | 1376.0 |
| 2015-11-09 07:05:00 | AAPL | Stock | 30.145 | 30.15 | 30.145 | 30.15 | 3400.0 |
| 2015-11-09 07:10:00 | AAPL | Stock | 30.15 | 30.15 | 30.15 | 30.15 | 400.0 |
| 2015-11-09 07:15:00 | AAPL | Stock | 30.1675 | 30.1675 | 30.155 | 30.155 | 2800.0 |
| 2015-11-09 07:25:00 | AAPL | Stock | 30.165 | 30.165 | 30.1625 | 30.1625 | 2364.0 |
| 2015-11-09 07:30:00 | AAPL | Stock | 30.17 | 30.17 | 30.17 | 30.17 | 800.0 |
| 2015-11-09 07:35:00 | AAPL | Stock | 30.1575 | 30.1575 | 30.1575 | 30.1575 | 4960.0 |
| 2015-11-09 07:40:00 | AAPL | Stock | 30.1625 | 30.1625 | 30.1625 | 30.1625 | 1400.0 |
| 2015-11-09 07:45:00 | AAPL | Stock | 30.1625 | 30.1625 | 30.1625 | 30.1625 | 4100.0 |
| 2015-11-09 07:50:00 | AAPL | Stock | 30.17 | 30.1725 | 30.17 | 30.1725 | 3556.0 |
| 2015-11-09 07:55:00 | AAPL | Stock | 30.165 | 30.165 | 30.1625 | 30.1625 | 12000.0 |
| 2015-11-09 08:00:00 | AAPL | Stock | 30.1625 | 30.2 | 30.1475 | 30.1625 | 48532.0 |
| 2015-11-09 08:05:00 | AAPL | Stock | 30.1625 | 30.1825 | 30.1625 | 30.1825 | 17208.0 |
| 2015-11-09 08:10:00 | AAPL | Stock | 30.1875 | 30.225 | 30.1875 | 30.225 | 23868.0 |
| 2015-11-09 08:15:00 | AAPL | Stock | 30.2175 | 30.225 | 30.215 | 30.225 | 29332.0 |
| 2015-11-09 08:20:00 | AAPL | Stock | 30.22 | 30.225 | 30.2125 | 30.2185 | 30084.0 |
| 2015-11-09 08:25:00 | AAPL | Stock | 30.2175 | 30.26 | 30.2175 | 30.245 | 128216.0 |
| 2015-11-09 08:30:00 | AAPL | Stock | 30.2475 | 30.255 | 30.2325 | 30.2325 | 35204.0 |
| 2015-11-09 08:35:00 | AAPL | Stock | 30.2225 | 30.25 | 30.2225 | 30.25 | 19272.0 |
| 2015-11-09 08:40:00 | AAPL | Stock | 30.2525 | 30.305 | 30.25 | 30.3 | 67836.0 |
| 2015-11-09 08:45:00 | AAPL | Stock | 30.3075 | 30.325 | 30.3 | 30.3025 | 81720.0 |
| 2015-11-09 08:50:00 | AAPL | Stock | 30.3 | 30.3025 | 30.285 | 30.29 | 21544.0 |
| 2015-11-09 08:55:00 | AAPL | Stock | 30.2925 | 30.3125 | 30.2675 | 30.27 | 58572.0 |
| 2015-11-09 09:00:00 | AAPL | Stock | 30.27 | 30.285 | 30.27 | 30.285 | 3200.0 |
| 2015-11-09 09:05:00 | AAPL | Stock | 30.2775 | 30.2975 | 30.2675 | 30.27 | 24052.0 |
| 2015-11-09 09:10:00 | AAPL | Stock | 30.275 | 30.2775 | 30.27 | 30.27 | 6004.0 |
| 2015-11-09 09:15:00 | AAPL | Stock | 30.2725 | 30.275 | 30.2625 | 30.2725 | 13160.0 |
| 2015-11-09 09:20:00 | AAPL | Stock | 30.2675 | 30.3 | 30.265 | 30.2925 | 22052.0 |
| 2015-11-09 09:25:00 | AAPL | Stock | 30.2825 | 30.2875 | 30.1975 | 30.1975 | 126692.0 |
| 2015-11-09 09:30:00 | AAPL | Stock | 30.24 | 30.275 | 30.1225 | 30.2725 | 5883684.0 |
| 2015-11-09 09:35:00 | AAPL | Stock | 30.27 | 30.435 | 30.265 | 30.4 | 4541352.0 |
| 2015-11-09 09:40:00 | AAPL | Stock | 30.4 | 30.415 | 30.3175 | 30.3275 | 2096672.0 |
| 2015-11-09 09:45:00 | AAPL | Stock | 30.3238 | 30.4525 | 30.3225 | 30.3875 | 3194292.0 |
| 2015-11-09 09:50:00 | AAPL | Stock | 30.385 | 30.3975 | 30.335 | 30.3875 | 2389432.0 |
| 2015-11-09 09:55:00 | AAPL | Stock | 30.39 | 30.4175 | 30.3078 | 30.3225 | 2578044.0 |
| 2015-11-09 10:00:00 | AAPL | Stock | 30.3225 | 30.3475 | 30.255 | 30.285 | 2291308.0 |
| 2015-11-09 10:05:00 | AAPL | Stock | 30.285 | 30.37 | 30.2625 | 30.3425 | 2535016.0 |
| 2015-11-09 10:10:00 | AAPL | Stock | 30.3475 | 30.36 | 30.315 | 30.3325 | 1502196.0 |
> showing 50 of 362,976 rows — these rows as CSV