PREVIEW / stock_5min / 2021-01-19
file: by_date/stock_5min/2021/2021-01-19.parquet size: 8.1 MB rows: 502,046 symbols: 2,715
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 |
|---|---|---|---|---|---|---|---|
| 2021-01-19 04:00:00 | AAPL | Stock | 128.55 | 129.0 | 128.55 | 128.97 | 15969.0 |
| 2021-01-19 04:05:00 | AAPL | Stock | 128.9 | 128.9 | 128.69 | 128.71 | 6262.0 |
| 2021-01-19 04:10:00 | AAPL | Stock | 128.71 | 128.99 | 128.69 | 128.75 | 11843.0 |
| 2021-01-19 04:15:00 | AAPL | Stock | 128.71 | 128.73 | 128.6 | 128.6 | 4307.0 |
| 2021-01-19 04:20:00 | AAPL | Stock | 128.6 | 128.73 | 128.6 | 128.7 | 7131.0 |
| 2021-01-19 04:25:00 | AAPL | Stock | 128.7 | 128.73 | 128.63 | 128.73 | 4320.0 |
| 2021-01-19 04:30:00 | AAPL | Stock | 128.63 | 128.63 | 128.51 | 128.61 | 2302.0 |
| 2021-01-19 04:35:00 | AAPL | Stock | 128.65 | 128.65 | 128.65 | 128.65 | 600.0 |
| 2021-01-19 04:40:00 | AAPL | Stock | 128.65 | 128.65 | 128.65 | 128.65 | 800.0 |
| 2021-01-19 04:45:00 | AAPL | Stock | 128.74 | 128.89 | 128.74 | 128.85 | 3234.0 |
| 2021-01-19 04:50:00 | AAPL | Stock | 128.87 | 128.87 | 128.86 | 128.86 | 408.0 |
| 2021-01-19 04:55:00 | AAPL | Stock | 128.89 | 128.9 | 128.85 | 128.9 | 2669.0 |
| 2021-01-19 05:00:00 | AAPL | Stock | 128.87 | 128.88 | 128.85 | 128.85 | 1168.0 |
| 2021-01-19 05:05:00 | AAPL | Stock | 128.85 | 128.88 | 128.82 | 128.82 | 1686.0 |
| 2021-01-19 05:10:00 | AAPL | Stock | 128.8 | 128.9 | 128.8 | 128.9 | 1699.0 |
| 2021-01-19 05:15:00 | AAPL | Stock | 128.8 | 128.82 | 128.8 | 128.82 | 481.0 |
| 2021-01-19 05:20:00 | AAPL | Stock | 128.89 | 128.9 | 128.89 | 128.9 | 1189.0 |
| 2021-01-19 05:25:00 | AAPL | Stock | 128.87 | 128.87 | 128.82 | 128.83 | 699.0 |
| 2021-01-19 05:30:00 | AAPL | Stock | 128.84 | 128.84 | 128.84 | 128.84 | 100.0 |
| 2021-01-19 05:35:00 | AAPL | Stock | 128.86 | 128.86 | 128.86 | 128.86 | 168.0 |
| 2021-01-19 05:40:00 | AAPL | Stock | 128.9 | 128.9 | 128.9 | 128.9 | 594.0 |
| 2021-01-19 05:45:00 | AAPL | Stock | 128.92 | 128.99 | 128.92 | 128.95 | 5398.0 |
| 2021-01-19 05:50:00 | AAPL | Stock | 128.97 | 128.97 | 128.97 | 128.97 | 806.0 |
| 2021-01-19 05:55:00 | AAPL | Stock | 128.96 | 128.99 | 128.93 | 128.93 | 2442.0 |
| 2021-01-19 06:00:00 | AAPL | Stock | 128.95 | 128.95 | 128.92 | 128.92 | 427.0 |
| 2021-01-19 06:05:00 | AAPL | Stock | 128.95 | 128.99 | 128.95 | 128.99 | 3459.0 |
| 2021-01-19 06:15:00 | AAPL | Stock | 129.0 | 129.0 | 128.92 | 128.92 | 2556.0 |
| 2021-01-19 06:20:00 | AAPL | Stock | 128.84 | 128.87 | 128.72 | 128.72 | 798.0 |
| 2021-01-19 06:25:00 | AAPL | Stock | 128.86 | 128.9 | 128.86 | 128.9 | 572.0 |
| 2021-01-19 06:30:00 | AAPL | Stock | 128.8 | 128.9 | 128.8 | 128.89 | 893.0 |
| 2021-01-19 06:35:00 | AAPL | Stock | 128.81 | 128.81 | 128.77 | 128.8 | 1713.0 |
| 2021-01-19 06:40:00 | AAPL | Stock | 128.78 | 128.81 | 128.74 | 128.75 | 3493.0 |
| 2021-01-19 06:45:00 | AAPL | Stock | 128.74 | 128.8 | 128.7 | 128.8 | 2488.0 |
| 2021-01-19 06:50:00 | AAPL | Stock | 128.84 | 128.97 | 128.82 | 128.82 | 4562.0 |
| 2021-01-19 06:55:00 | AAPL | Stock | 128.9 | 128.93 | 128.89 | 128.89 | 4011.0 |
| 2021-01-19 07:00:00 | AAPL | Stock | 128.91 | 128.93 | 128.43 | 128.56 | 145250.0 |
| 2021-01-19 07:05:00 | AAPL | Stock | 128.55 | 128.56 | 128.36 | 128.4 | 38837.0 |
| 2021-01-19 07:10:00 | AAPL | Stock | 128.4 | 128.46 | 128.31 | 128.4 | 18279.0 |
| 2021-01-19 07:15:00 | AAPL | Stock | 128.36 | 128.44 | 128.3 | 128.44 | 18363.0 |
| 2021-01-19 07:20:00 | AAPL | Stock | 128.43 | 128.5 | 128.43 | 128.49 | 11900.0 |
| 2021-01-19 07:25:00 | AAPL | Stock | 128.49 | 128.49 | 128.4 | 128.42 | 16284.0 |
| 2021-01-19 07:30:00 | AAPL | Stock | 128.43 | 128.43 | 128.26 | 128.28 | 23741.0 |
| 2021-01-19 07:35:00 | AAPL | Stock | 128.34 | 128.34 | 128.26 | 128.26 | 6966.0 |
| 2021-01-19 07:40:00 | AAPL | Stock | 128.26 | 128.3 | 128.25 | 128.29 | 9793.0 |
| 2021-01-19 07:45:00 | AAPL | Stock | 128.28 | 128.29 | 128.1 | 128.24 | 15075.0 |
| 2021-01-19 07:50:00 | AAPL | Stock | 128.25 | 128.29 | 128.249 | 128.29 | 11174.0 |
| 2021-01-19 07:55:00 | AAPL | Stock | 128.27 | 128.41 | 128.27 | 128.35 | 17895.0 |
| 2021-01-19 08:00:00 | AAPL | Stock | 128.36 | 128.9 | 128.2 | 128.31 | 115710.0 |
| 2021-01-19 08:05:00 | AAPL | Stock | 128.31 | 128.34 | 128.18 | 128.2 | 24442.0 |
| 2021-01-19 08:10:00 | AAPL | Stock | 128.2 | 128.29 | 128.2 | 128.28 | 20151.0 |
> showing 50 of 502,046 rows — these rows as CSV