PREVIEW / stock_1min / 2019-07-30
file: by_date/stock_1min/2019/2019-07-30.parquet size: 15.8 MB rows: 1,115,796 symbols: 2,178
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 |
|---|---|---|---|---|---|---|---|
| 2019-07-30 04:00:00 | AAPL | Stock | 52.35 | 52.35 | 52.35 | 52.35 | 400.0 |
| 2019-07-30 04:03:00 | AAPL | Stock | 52.3625 | 52.3625 | 52.3625 | 52.3625 | 400.0 |
| 2019-07-30 04:04:00 | AAPL | Stock | 52.3725 | 52.3725 | 52.3625 | 52.3625 | 2760.0 |
| 2019-07-30 04:08:00 | AAPL | Stock | 52.3625 | 52.3625 | 52.3625 | 52.3625 | 1200.0 |
| 2019-07-30 04:09:00 | AAPL | Stock | 52.35 | 52.35 | 52.35 | 52.35 | 1200.0 |
| 2019-07-30 04:12:00 | AAPL | Stock | 52.375 | 52.375 | 52.3725 | 52.3725 | 1200.0 |
| 2019-07-30 04:14:00 | AAPL | Stock | 52.3775 | 52.3775 | 52.3775 | 52.3775 | 2580.0 |
| 2019-07-30 04:15:00 | AAPL | Stock | 52.4 | 52.4 | 52.4 | 52.4 | 2000.0 |
| 2019-07-30 04:24:00 | AAPL | Stock | 52.345 | 52.345 | 52.295 | 52.295 | 8276.0 |
| 2019-07-30 04:30:00 | AAPL | Stock | 52.27 | 52.27 | 52.27 | 52.27 | 412.0 |
| 2019-07-30 04:36:00 | AAPL | Stock | 52.25 | 52.25 | 52.25 | 52.25 | 400.0 |
| 2019-07-30 04:37:00 | AAPL | Stock | 52.225 | 52.2275 | 52.205 | 52.2275 | 3200.0 |
| 2019-07-30 04:51:00 | AAPL | Stock | 52.18 | 52.18 | 52.18 | 52.18 | 3416.0 |
| 2019-07-30 04:56:00 | AAPL | Stock | 52.1925 | 52.1925 | 52.1925 | 52.1925 | 1216.0 |
| 2019-07-30 04:57:00 | AAPL | Stock | 52.18 | 52.195 | 52.18 | 52.195 | 2800.0 |
| 2019-07-30 05:03:00 | AAPL | Stock | 52.195 | 52.195 | 52.195 | 52.195 | 892.0 |
| 2019-07-30 05:04:00 | AAPL | Stock | 52.1975 | 52.1975 | 52.1975 | 52.1975 | 2292.0 |
| 2019-07-30 05:10:00 | AAPL | Stock | 52.1975 | 52.1975 | 52.1975 | 52.1975 | 400.0 |
| 2019-07-30 05:12:00 | AAPL | Stock | 52.2 | 52.2 | 52.2 | 52.2 | 800.0 |
| 2019-07-30 05:24:00 | AAPL | Stock | 52.15 | 52.15 | 52.15 | 52.15 | 400.0 |
| 2019-07-30 05:29:00 | AAPL | Stock | 52.1375 | 52.1375 | 52.1375 | 52.1375 | 400.0 |
| 2019-07-30 05:31:00 | AAPL | Stock | 52.16 | 52.165 | 52.16 | 52.165 | 2000.0 |
| 2019-07-30 05:37:00 | AAPL | Stock | 52.1275 | 52.1275 | 52.1275 | 52.1275 | 920.0 |
| 2019-07-30 05:39:00 | AAPL | Stock | 52.14 | 52.14 | 52.14 | 52.14 | 400.0 |
| 2019-07-30 06:05:00 | AAPL | Stock | 52.13 | 52.13 | 52.1275 | 52.1275 | 1740.0 |
| 2019-07-30 06:07:00 | AAPL | Stock | 52.1375 | 52.1375 | 52.1375 | 52.1375 | 12000.0 |
| 2019-07-30 06:13:00 | AAPL | Stock | 52.17 | 52.17 | 52.17 | 52.17 | 400.0 |
| 2019-07-30 06:14:00 | AAPL | Stock | 52.175 | 52.175 | 52.175 | 52.175 | 1860.0 |
| 2019-07-30 06:18:00 | AAPL | Stock | 52.125 | 52.125 | 52.1 | 52.1 | 4132.0 |
| 2019-07-30 06:21:00 | AAPL | Stock | 52.0825 | 52.0825 | 52.0825 | 52.0825 | 412.0 |
| 2019-07-30 06:51:00 | AAPL | Stock | 52.2225 | 52.225 | 52.2225 | 52.225 | 6088.0 |
| 2019-07-30 07:00:00 | AAPL | Stock | 52.22 | 52.275 | 52.22 | 52.25 | 8388.0 |
| 2019-07-30 07:01:00 | AAPL | Stock | 52.2525 | 52.2525 | 52.25 | 52.25 | 8564.0 |
| 2019-07-30 07:02:00 | AAPL | Stock | 52.25 | 52.25 | 52.25 | 52.25 | 400.0 |
| 2019-07-30 07:03:00 | AAPL | Stock | 52.25 | 52.25 | 52.22 | 52.22 | 4468.0 |
| 2019-07-30 07:05:00 | AAPL | Stock | 52.225 | 52.225 | 52.22 | 52.22 | 1872.0 |
| 2019-07-30 07:06:00 | AAPL | Stock | 52.2375 | 52.2375 | 52.205 | 52.205 | 4580.0 |
| 2019-07-30 07:07:00 | AAPL | Stock | 52.225 | 52.225 | 52.225 | 52.225 | 400.0 |
| 2019-07-30 07:08:00 | AAPL | Stock | 52.2225 | 52.2225 | 52.2225 | 52.2225 | 4400.0 |
| 2019-07-30 07:09:00 | AAPL | Stock | 52.2225 | 52.245 | 52.2225 | 52.245 | 2100.0 |
| 2019-07-30 07:10:00 | AAPL | Stock | 52.2075 | 52.2075 | 52.1875 | 52.1875 | 21140.0 |
| 2019-07-30 07:11:00 | AAPL | Stock | 52.225 | 52.225 | 52.175 | 52.175 | 5600.0 |
| 2019-07-30 07:12:00 | AAPL | Stock | 52.2 | 52.2 | 52.2 | 52.2 | 2000.0 |
| 2019-07-30 07:13:00 | AAPL | Stock | 52.15 | 52.15 | 52.1425 | 52.1425 | 9084.0 |
| 2019-07-30 07:14:00 | AAPL | Stock | 52.15 | 52.15 | 52.1375 | 52.15 | 4400.0 |
| 2019-07-30 07:16:00 | AAPL | Stock | 52.15 | 52.15 | 52.1225 | 52.125 | 18592.0 |
| 2019-07-30 07:17:00 | AAPL | Stock | 52.125 | 52.125 | 52.125 | 52.125 | 400.0 |
| 2019-07-30 07:18:00 | AAPL | Stock | 52.11 | 52.11 | 52.1075 | 52.1075 | 4640.0 |
| 2019-07-30 07:20:00 | AAPL | Stock | 52.08 | 52.13 | 52.08 | 52.1075 | 11008.0 |
| 2019-07-30 07:21:00 | AAPL | Stock | 52.115 | 52.115 | 52.1125 | 52.1125 | 1200.0 |
> showing 50 of 1,115,796 rows — these rows as CSV