PREVIEW / stock_1min / 2020-03-05
file: by_date/stock_1min/2020/2020-03-05.parquet size: 19.6 MB rows: 1,271,073 symbols: 2,059
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 |
|---|---|---|---|---|---|---|---|
| 2020-03-05 04:00:00 | AAPL | Stock | 74.215 | 74.3225 | 74.165 | 74.165 | 13360.0 |
| 2020-03-05 04:01:00 | AAPL | Stock | 74.25 | 74.25 | 74.175 | 74.175 | 3120.0 |
| 2020-03-05 04:04:00 | AAPL | Stock | 74.3 | 74.3 | 74.3 | 74.3 | 1796.0 |
| 2020-03-05 04:06:00 | AAPL | Stock | 74.1325 | 74.1325 | 74.0 | 74.0075 | 4720.0 |
| 2020-03-05 04:08:00 | AAPL | Stock | 74.0875 | 74.0875 | 74.075 | 74.075 | 1200.0 |
| 2020-03-05 04:09:00 | AAPL | Stock | 74.085 | 74.085 | 74.0 | 74.0 | 1400.0 |
| 2020-03-05 04:11:00 | AAPL | Stock | 74.075 | 74.12 | 74.075 | 74.12 | 2800.0 |
| 2020-03-05 04:12:00 | AAPL | Stock | 74.1875 | 74.1875 | 74.1875 | 74.1875 | 400.0 |
| 2020-03-05 04:14:00 | AAPL | Stock | 74.15 | 74.1625 | 74.15 | 74.1625 | 800.0 |
| 2020-03-05 04:16:00 | AAPL | Stock | 74.13 | 74.13 | 74.125 | 74.125 | 1196.0 |
| 2020-03-05 04:17:00 | AAPL | Stock | 74.125 | 74.125 | 74.125 | 74.125 | 500.0 |
| 2020-03-05 04:18:00 | AAPL | Stock | 74.2 | 74.435 | 74.2 | 74.435 | 9856.0 |
| 2020-03-05 04:19:00 | AAPL | Stock | 74.415 | 74.495 | 74.415 | 74.495 | 1836.0 |
| 2020-03-05 04:22:00 | AAPL | Stock | 74.3025 | 74.43 | 74.3025 | 74.425 | 13420.0 |
| 2020-03-05 04:23:00 | AAPL | Stock | 74.2975 | 74.2975 | 74.2975 | 74.2975 | 568.0 |
| 2020-03-05 04:26:00 | AAPL | Stock | 74.3575 | 74.3575 | 74.345 | 74.345 | 1200.0 |
| 2020-03-05 04:28:00 | AAPL | Stock | 74.2275 | 74.2275 | 74.2275 | 74.2275 | 400.0 |
| 2020-03-05 04:29:00 | AAPL | Stock | 74.18 | 74.18 | 74.18 | 74.18 | 796.0 |
| 2020-03-05 04:33:00 | AAPL | Stock | 74.1275 | 74.15 | 74.1125 | 74.15 | 4200.0 |
| 2020-03-05 04:34:00 | AAPL | Stock | 74.2 | 74.205 | 74.18 | 74.18 | 2524.0 |
| 2020-03-05 04:39:00 | AAPL | Stock | 74.25 | 74.25 | 74.25 | 74.25 | 2000.0 |
| 2020-03-05 04:43:00 | AAPL | Stock | 74.1375 | 74.1375 | 74.1375 | 74.1375 | 400.0 |
| 2020-03-05 04:45:00 | AAPL | Stock | 74.175 | 74.275 | 74.175 | 74.275 | 2400.0 |
| 2020-03-05 04:47:00 | AAPL | Stock | 74.275 | 74.325 | 74.275 | 74.325 | 1600.0 |
| 2020-03-05 04:48:00 | AAPL | Stock | 74.375 | 74.375 | 74.375 | 74.375 | 400.0 |
| 2020-03-05 04:50:00 | AAPL | Stock | 74.325 | 74.325 | 74.325 | 74.325 | 1600.0 |
| 2020-03-05 04:52:00 | AAPL | Stock | 74.35 | 74.35 | 74.325 | 74.325 | 1600.0 |
| 2020-03-05 04:54:00 | AAPL | Stock | 74.36 | 74.36 | 74.3275 | 74.3275 | 952.0 |
| 2020-03-05 04:56:00 | AAPL | Stock | 74.325 | 74.3975 | 74.325 | 74.3975 | 1400.0 |
| 2020-03-05 04:57:00 | AAPL | Stock | 74.3125 | 74.3125 | 74.3125 | 74.3125 | 800.0 |
| 2020-03-05 04:58:00 | AAPL | Stock | 74.2575 | 74.2575 | 74.2575 | 74.2575 | 400.0 |
| 2020-03-05 05:00:00 | AAPL | Stock | 74.255 | 74.255 | 74.25 | 74.25 | 2028.0 |
| 2020-03-05 05:01:00 | AAPL | Stock | 74.15 | 74.15 | 74.15 | 74.15 | 768.0 |
| 2020-03-05 05:02:00 | AAPL | Stock | 74.15 | 74.15 | 74.15 | 74.15 | 1508.0 |
| 2020-03-05 05:04:00 | AAPL | Stock | 74.245 | 74.245 | 74.245 | 74.245 | 768.0 |
| 2020-03-05 05:06:00 | AAPL | Stock | 74.25 | 74.25 | 74.25 | 74.25 | 832.0 |
| 2020-03-05 05:07:00 | AAPL | Stock | 74.155 | 74.155 | 74.0825 | 74.0825 | 9192.0 |
| 2020-03-05 05:08:00 | AAPL | Stock | 74.0825 | 74.0825 | 74.0625 | 74.0625 | 3756.0 |
| 2020-03-05 05:10:00 | AAPL | Stock | 74.0275 | 74.0275 | 74.0 | 74.0 | 3568.0 |
| 2020-03-05 05:11:00 | AAPL | Stock | 73.9225 | 73.9225 | 73.9 | 73.91 | 1968.0 |
| 2020-03-05 05:12:00 | AAPL | Stock | 73.9 | 73.9 | 73.9 | 73.9 | 800.0 |
| 2020-03-05 05:13:00 | AAPL | Stock | 73.8875 | 74.075 | 73.8875 | 74.075 | 1840.0 |
| 2020-03-05 05:15:00 | AAPL | Stock | 74.0 | 74.0 | 74.0 | 74.0 | 400.0 |
| 2020-03-05 05:16:00 | AAPL | Stock | 73.905 | 73.9975 | 73.9025 | 73.9075 | 2104.0 |
| 2020-03-05 05:17:00 | AAPL | Stock | 74.0 | 74.0 | 73.9725 | 73.995 | 1200.0 |
| 2020-03-05 05:18:00 | AAPL | Stock | 73.9925 | 74.0025 | 73.9925 | 74.0025 | 904.0 |
| 2020-03-05 05:19:00 | AAPL | Stock | 73.9525 | 74.0075 | 73.9525 | 74.0075 | 800.0 |
| 2020-03-05 05:20:00 | AAPL | Stock | 73.95 | 73.9575 | 73.8975 | 73.9575 | 1200.0 |
| 2020-03-05 05:21:00 | AAPL | Stock | 73.965 | 73.965 | 73.95 | 73.95 | 3600.0 |
| 2020-03-05 05:24:00 | AAPL | Stock | 73.9 | 73.9475 | 73.9 | 73.9 | 2000.0 |
> showing 50 of 1,271,073 rows — these rows as CSV