PREVIEW / stock_30min / 2021-06-18
file: by_date/stock_30min/2021/2021-06-18.parquet size: 2.3 MB rows: 113,553 symbols: 2,966
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-06-18 04:00:00 | AAPL | Stock | 131.99 | 131.99 | 131.8 | 131.81 | 5028.0 |
| 2021-06-18 04:30:00 | AAPL | Stock | 131.87 | 131.87 | 131.8 | 131.83 | 2096.0 |
| 2021-06-18 05:00:00 | AAPL | Stock | 131.84 | 131.95 | 131.82 | 131.89 | 1951.0 |
| 2021-06-18 05:30:00 | AAPL | Stock | 131.94 | 131.95 | 131.87 | 131.95 | 4819.0 |
| 2021-06-18 06:00:00 | AAPL | Stock | 131.96 | 131.96 | 131.8 | 131.9 | 5366.0 |
| 2021-06-18 06:30:00 | AAPL | Stock | 131.87 | 131.94 | 131.8 | 131.94 | 13218.0 |
| 2021-06-18 07:00:00 | AAPL | Stock | 131.95 | 131.99 | 131.48 | 131.69 | 65971.0 |
| 2021-06-18 07:30:00 | AAPL | Stock | 131.69 | 131.7 | 131.44 | 131.6 | 52500.0 |
| 2021-06-18 08:00:00 | AAPL | Stock | 131.9699 | 131.99 | 130.8 | 130.98 | 416497.0 |
| 2021-06-18 08:30:00 | AAPL | Stock | 130.97 | 131.22 | 130.79 | 131.14 | 273920.0 |
| 2021-06-18 09:00:00 | AAPL | Stock | 131.15 | 131.5 | 130.65 | 130.65 | 686679.0 |
| 2021-06-18 09:30:00 | AAPL | Stock | 130.65 | 131.51 | 130.59 | 131.24 | 19182949.0 |
| 2021-06-18 10:00:00 | AAPL | Stock | 131.23 | 131.42 | 130.88 | 131.05 | 6204832.0 |
| 2021-06-18 10:30:00 | AAPL | Stock | 131.04 | 131.29 | 130.61 | 130.73 | 5966719.0 |
| 2021-06-18 11:00:00 | AAPL | Stock | 130.725 | 130.94 | 130.32 | 130.3275 | 5470028.0 |
| 2021-06-18 11:30:00 | AAPL | Stock | 130.3226 | 130.81 | 130.29 | 130.69 | 3877225.0 |
| 2021-06-18 12:00:00 | AAPL | Stock | 130.69 | 131.0 | 130.68 | 130.99 | 2917162.0 |
| 2021-06-18 12:30:00 | AAPL | Stock | 130.9899 | 131.137 | 130.76 | 130.95 | 2193887.0 |
| 2021-06-18 13:00:00 | AAPL | Stock | 130.95 | 131.22 | 130.81 | 130.81 | 2598996.0 |
| 2021-06-18 13:30:00 | AAPL | Stock | 130.8101 | 131.07 | 130.76 | 130.915 | 2315771.0 |
| 2021-06-18 14:00:00 | AAPL | Stock | 130.91 | 131.15 | 130.8 | 130.96 | 2591813.0 |
| 2021-06-18 14:30:00 | AAPL | Stock | 130.96 | 131.03 | 130.69 | 130.8075 | 2765143.0 |
| 2021-06-18 15:00:00 | AAPL | Stock | 130.8 | 130.98 | 130.57 | 130.905 | 3591096.0 |
| 2021-06-18 15:30:00 | AAPL | Stock | 130.9 | 131.15 | 130.24 | 130.4 | 9843045.0 |
| 2021-06-18 16:00:00 | AAPL | Stock | 130.42 | 130.8336 | 130.3 | 130.37 | 25272248.0 |
| 2021-06-18 16:30:00 | AAPL | Stock | 130.39 | 130.46 | 130.2 | 130.25 | 80006.0 |
| 2021-06-18 17:00:00 | AAPL | Stock | 130.2 | 130.26 | 130.16 | 130.2 | 26090.0 |
| 2021-06-18 17:30:00 | AAPL | Stock | 130.17 | 130.26 | 130.15 | 130.2099 | 16963.0 |
| 2021-06-18 18:00:00 | AAPL | Stock | 130.2 | 130.46 | 130.19 | 130.25 | 79329.0 |
| 2021-06-18 18:30:00 | AAPL | Stock | 130.22 | 130.26 | 130.195 | 130.2 | 10708.0 |
| 2021-06-18 19:00:00 | AAPL | Stock | 130.21 | 130.24 | 130.18 | 130.22 | 9487.0 |
| 2021-06-18 19:30:00 | AAPL | Stock | 130.2 | 130.25 | 130.18 | 130.2 | 17237.0 |
| 2021-06-18 04:00:00 | MSFT | Stock | 261.0 | 261.0 | 261.0 | 261.0 | 2385.0 |
| 2021-06-18 04:30:00 | MSFT | Stock | 261.0 | 261.0 | 260.88 | 260.88 | 474.0 |
| 2021-06-18 05:00:00 | MSFT | Stock | 261.0 | 261.0 | 261.0 | 261.0 | 1367.0 |
| 2021-06-18 05:30:00 | MSFT | Stock | 261.0 | 261.0 | 261.0 | 261.0 | 1000.0 |
| 2021-06-18 06:00:00 | MSFT | Stock | 260.9 | 260.99 | 260.9 | 260.99 | 1030.0 |
| 2021-06-18 06:30:00 | MSFT | Stock | 260.9 | 261.0 | 260.9 | 261.0 | 307.0 |
| 2021-06-18 07:00:00 | MSFT | Stock | 261.0 | 261.0 | 260.23 | 260.41 | 2937.0 |
| 2021-06-18 07:30:00 | MSFT | Stock | 260.63 | 260.83 | 260.25 | 260.44 | 7556.0 |
| 2021-06-18 08:00:00 | MSFT | Stock | 260.5 | 260.71 | 258.75 | 259.15 | 52278.0 |
| 2021-06-18 08:30:00 | MSFT | Stock | 259.1 | 259.8 | 258.84 | 259.8 | 23037.0 |
| 2021-06-18 09:00:00 | MSFT | Stock | 259.79 | 260.95 | 259.25 | 259.48 | 158101.0 |
| 2021-06-18 09:30:00 | MSFT | Stock | 259.48 | 261.17 | 258.75 | 260.17 | 6118533.0 |
| 2021-06-18 10:00:00 | MSFT | Stock | 260.18 | 261.6 | 260.015 | 261.45 | 1713024.0 |
| 2021-06-18 10:30:00 | MSFT | Stock | 261.44 | 262.3 | 260.52 | 260.52 | 1574588.0 |
| 2021-06-18 11:00:00 | MSFT | Stock | 260.52 | 260.88 | 259.59 | 259.6 | 1373069.0 |
| 2021-06-18 11:30:00 | MSFT | Stock | 259.58 | 260.3 | 259.48 | 259.98 | 1056068.0 |
| 2021-06-18 12:00:00 | MSFT | Stock | 259.9861 | 260.81 | 259.79 | 260.8 | 752695.0 |
| 2021-06-18 12:30:00 | MSFT | Stock | 260.81 | 261.1 | 260.39 | 260.87 | 762837.0 |
> showing 50 of 113,553 rows — these rows as CSV