PREVIEW / stock_5min / 2020-03-05
file: by_date/stock_5min/2020/2020-03-05.parquet size: 6.3 MB rows: 387,433 symbols: 2,432
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.3 | 18276.0 |
| 2020-03-05 04:05:00 | AAPL | Stock | 74.1325 | 74.1325 | 74.0 | 74.0 | 7320.0 |
| 2020-03-05 04:10:00 | AAPL | Stock | 74.075 | 74.1875 | 74.075 | 74.1625 | 4000.0 |
| 2020-03-05 04:15:00 | AAPL | Stock | 74.13 | 74.495 | 74.125 | 74.495 | 13388.0 |
| 2020-03-05 04:20:00 | AAPL | Stock | 74.3025 | 74.43 | 74.2975 | 74.2975 | 13988.0 |
| 2020-03-05 04:25:00 | AAPL | Stock | 74.3575 | 74.3575 | 74.18 | 74.18 | 2396.0 |
| 2020-03-05 04:30:00 | AAPL | Stock | 74.1275 | 74.205 | 74.1125 | 74.18 | 6724.0 |
| 2020-03-05 04:35:00 | AAPL | Stock | 74.25 | 74.25 | 74.25 | 74.25 | 2000.0 |
| 2020-03-05 04:40:00 | AAPL | Stock | 74.1375 | 74.1375 | 74.1375 | 74.1375 | 400.0 |
| 2020-03-05 04:45:00 | AAPL | Stock | 74.175 | 74.375 | 74.175 | 74.375 | 4400.0 |
| 2020-03-05 04:50:00 | AAPL | Stock | 74.325 | 74.36 | 74.325 | 74.3275 | 4152.0 |
| 2020-03-05 04:55:00 | AAPL | Stock | 74.325 | 74.3975 | 74.2575 | 74.2575 | 2600.0 |
| 2020-03-05 05:00:00 | AAPL | Stock | 74.255 | 74.255 | 74.15 | 74.245 | 5072.0 |
| 2020-03-05 05:05:00 | AAPL | Stock | 74.25 | 74.25 | 74.0625 | 74.0625 | 13780.0 |
| 2020-03-05 05:10:00 | AAPL | Stock | 74.0275 | 74.075 | 73.8875 | 74.075 | 8176.0 |
| 2020-03-05 05:15:00 | AAPL | Stock | 74.0 | 74.0075 | 73.9025 | 74.0075 | 5408.0 |
| 2020-03-05 05:20:00 | AAPL | Stock | 73.95 | 73.965 | 73.8975 | 73.9 | 6800.0 |
| 2020-03-05 05:25:00 | AAPL | Stock | 73.9475 | 73.9725 | 73.8575 | 73.95 | 34436.0 |
| 2020-03-05 05:30:00 | AAPL | Stock | 74.0075 | 74.0075 | 74.0075 | 74.0075 | 1912.0 |
| 2020-03-05 05:35:00 | AAPL | Stock | 74.0325 | 74.065 | 73.9875 | 74.0575 | 5536.0 |
| 2020-03-05 05:40:00 | AAPL | Stock | 73.9875 | 73.9875 | 73.905 | 73.905 | 6184.0 |
| 2020-03-05 05:45:00 | AAPL | Stock | 74.0 | 74.0625 | 74.0 | 74.0625 | 1200.0 |
| 2020-03-05 05:50:00 | AAPL | Stock | 74.0275 | 74.0825 | 73.9275 | 73.9275 | 10340.0 |
| 2020-03-05 05:55:00 | AAPL | Stock | 73.95 | 73.95 | 73.8375 | 73.8375 | 4604.0 |
| 2020-03-05 06:00:00 | AAPL | Stock | 73.875 | 74.0325 | 73.875 | 74.0325 | 1200.0 |
| 2020-03-05 06:05:00 | AAPL | Stock | 74.0275 | 74.0975 | 73.98 | 74.0725 | 28352.0 |
| 2020-03-05 06:10:00 | AAPL | Stock | 74.055 | 74.1725 | 74.055 | 74.1725 | 10116.0 |
| 2020-03-05 06:15:00 | AAPL | Stock | 74.1 | 74.1 | 74.0475 | 74.075 | 2504.0 |
| 2020-03-05 06:20:00 | AAPL | Stock | 74.05 | 74.05 | 73.8275 | 73.9 | 4112.0 |
| 2020-03-05 06:25:00 | AAPL | Stock | 73.9025 | 73.9475 | 73.8 | 73.8025 | 3252.0 |
| 2020-03-05 06:30:00 | AAPL | Stock | 73.875 | 73.9225 | 73.785 | 73.785 | 6604.0 |
| 2020-03-05 06:35:00 | AAPL | Stock | 73.9 | 73.9625 | 73.7425 | 73.825 | 39840.0 |
| 2020-03-05 06:40:00 | AAPL | Stock | 73.85 | 73.895 | 73.775 | 73.895 | 20896.0 |
| 2020-03-05 06:45:00 | AAPL | Stock | 73.88 | 73.9 | 73.875 | 73.9 | 3208.0 |
| 2020-03-05 06:50:00 | AAPL | Stock | 73.855 | 73.9625 | 73.8275 | 73.8275 | 2120.0 |
| 2020-03-05 06:55:00 | AAPL | Stock | 73.85 | 73.9025 | 73.85 | 73.9025 | 1200.0 |
| 2020-03-05 07:00:00 | AAPL | Stock | 73.985 | 74.075 | 73.8625 | 74.0 | 143344.0 |
| 2020-03-05 07:05:00 | AAPL | Stock | 74.045 | 74.2375 | 74.0425 | 74.15 | 74172.0 |
| 2020-03-05 07:10:00 | AAPL | Stock | 74.1525 | 74.2025 | 74.0825 | 74.2 | 27844.0 |
| 2020-03-05 07:15:00 | AAPL | Stock | 74.215 | 74.215 | 74.0775 | 74.135 | 35880.0 |
| 2020-03-05 07:20:00 | AAPL | Stock | 74.1025 | 74.225 | 74.1025 | 74.225 | 30228.0 |
| 2020-03-05 07:25:00 | AAPL | Stock | 74.2125 | 74.3475 | 74.185 | 74.2875 | 37520.0 |
| 2020-03-05 07:30:00 | AAPL | Stock | 74.3125 | 74.35 | 74.175 | 74.2225 | 118752.0 |
| 2020-03-05 07:35:00 | AAPL | Stock | 74.1875 | 74.2375 | 74.0775 | 74.2 | 64640.0 |
| 2020-03-05 07:40:00 | AAPL | Stock | 74.235 | 74.3 | 74.21 | 74.2575 | 29472.0 |
| 2020-03-05 07:45:00 | AAPL | Stock | 74.255 | 74.325 | 74.1875 | 74.1875 | 26340.0 |
| 2020-03-05 07:50:00 | AAPL | Stock | 74.125 | 74.2 | 74.05 | 74.2 | 23668.0 |
| 2020-03-05 07:55:00 | AAPL | Stock | 74.2 | 74.235 | 74.1 | 74.1275 | 117128.0 |
| 2020-03-05 08:00:00 | AAPL | Stock | 74.2 | 74.35 | 73.9125 | 74.0722 | 279068.0 |
| 2020-03-05 08:05:00 | AAPL | Stock | 74.0175 | 74.1215 | 73.985 | 74.0475 | 66552.0 |
> showing 50 of 387,433 rows — these rows as CSV