PREVIEW / stock_30min / 2021-12-07
file: by_date/stock_30min/2021/2021-12-07.parquet size: 2.3 MB rows: 114,283 symbols: 2,682
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-12-07 04:00:00 | AAPL | Stock | 168.22 | 168.63 | 166.14 | 168.15 | 65640.0 |
| 2021-12-07 04:30:00 | AAPL | Stock | 168.15 | 168.38 | 167.9 | 168.08 | 25353.0 |
| 2021-12-07 05:00:00 | AAPL | Stock | 168.15 | 168.53 | 168.15 | 168.43 | 11337.0 |
| 2021-12-07 05:30:00 | AAPL | Stock | 168.46 | 168.9 | 168.29 | 168.85 | 49463.0 |
| 2021-12-07 06:00:00 | AAPL | Stock | 168.85 | 168.91 | 168.06 | 168.08 | 48101.0 |
| 2021-12-07 06:30:00 | AAPL | Stock | 168.11 | 168.6 | 168.06 | 168.4 | 23508.0 |
| 2021-12-07 07:00:00 | AAPL | Stock | 168.35 | 168.61 | 168.12 | 168.37 | 167778.0 |
| 2021-12-07 07:30:00 | AAPL | Stock | 168.36 | 168.8 | 168.24 | 168.52 | 92200.0 |
| 2021-12-07 08:00:00 | AAPL | Stock | 168.2999 | 169.15 | 164.907 | 169.02 | 373237.0 |
| 2021-12-07 08:30:00 | AAPL | Stock | 169.01 | 169.45 | 168.95 | 168.95 | 251296.0 |
| 2021-12-07 09:00:00 | AAPL | Stock | 168.94 | 169.3 | 168.76 | 169.1 | 348305.0 |
| 2021-12-07 09:30:00 | AAPL | Stock | 169.06 | 170.78 | 168.34 | 170.1552 | 18098773.0 |
| 2021-12-07 10:00:00 | AAPL | Stock | 170.15 | 170.95 | 169.97 | 170.39 | 9309556.0 |
| 2021-12-07 10:30:00 | AAPL | Stock | 170.4 | 171.28 | 170.28 | 170.745 | 7907185.0 |
| 2021-12-07 11:00:00 | AAPL | Stock | 170.74 | 171.225 | 170.49 | 170.585 | 5469720.0 |
| 2021-12-07 11:30:00 | AAPL | Stock | 170.5851 | 171.4773 | 170.48 | 171.0666 | 6146017.0 |
| 2021-12-07 12:00:00 | AAPL | Stock | 171.0711 | 171.5767 | 170.81 | 171.5125 | 4622220.0 |
| 2021-12-07 12:30:00 | AAPL | Stock | 171.52 | 171.58 | 170.91 | 171.11 | 3744906.0 |
| 2021-12-07 13:00:00 | AAPL | Stock | 171.1 | 171.14 | 170.635 | 170.86 | 3219492.0 |
| 2021-12-07 13:30:00 | AAPL | Stock | 170.87 | 170.915 | 170.321 | 170.45 | 3879088.0 |
| 2021-12-07 14:00:00 | AAPL | Stock | 170.44 | 170.445 | 169.7 | 169.9285 | 4420267.0 |
| 2021-12-07 14:30:00 | AAPL | Stock | 169.93 | 170.11 | 169.45 | 169.93 | 3892603.0 |
| 2021-12-07 15:00:00 | AAPL | Stock | 169.93 | 170.335 | 169.8101 | 170.11 | 4319208.0 |
| 2021-12-07 15:30:00 | AAPL | Stock | 170.105 | 171.27 | 169.9124 | 171.2 | 11171221.0 |
| 2021-12-07 16:00:00 | AAPL | Stock | 171.2 | 173.8799 | 170.84 | 172.65 | 12765782.0 |
| 2021-12-07 16:30:00 | AAPL | Stock | 172.65 | 173.22 | 171.18 | 172.8 | 350094.0 |
| 2021-12-07 17:00:00 | AAPL | Stock | 172.75 | 173.29 | 172.59 | 173.1 | 142725.0 |
| 2021-12-07 17:30:00 | AAPL | Stock | 173.07 | 173.2 | 171.18 | 172.6 | 68502.0 |
| 2021-12-07 18:00:00 | AAPL | Stock | 172.6 | 172.6 | 172.11 | 172.27 | 93809.0 |
| 2021-12-07 18:30:00 | AAPL | Stock | 172.31 | 172.49 | 172.26 | 172.35 | 41532.0 |
| 2021-12-07 19:00:00 | AAPL | Stock | 172.37 | 172.41 | 172.07 | 172.21 | 67405.0 |
| 2021-12-07 19:30:00 | AAPL | Stock | 172.21 | 172.6 | 172.21 | 172.58 | 113089.0 |
| 2021-12-07 04:00:00 | MSFT | Stock | 330.19 | 333.5 | 330.19 | 333.37 | 8891.0 |
| 2021-12-07 04:30:00 | MSFT | Stock | 333.0 | 333.0 | 332.01 | 332.45 | 1382.0 |
| 2021-12-07 05:00:00 | MSFT | Stock | 332.32 | 332.45 | 332.3 | 332.45 | 3037.0 |
| 2021-12-07 05:30:00 | MSFT | Stock | 332.45 | 332.86 | 332.0 | 332.36 | 5349.0 |
| 2021-12-07 06:00:00 | MSFT | Stock | 332.7 | 332.75 | 331.7 | 331.81 | 2675.0 |
| 2021-12-07 06:30:00 | MSFT | Stock | 332.0 | 332.17 | 331.95 | 332.12 | 3491.0 |
| 2021-12-07 07:00:00 | MSFT | Stock | 331.81 | 331.81 | 331.11 | 331.35 | 14746.0 |
| 2021-12-07 07:30:00 | MSFT | Stock | 331.46 | 331.69 | 331.0 | 331.4 | 18805.0 |
| 2021-12-07 08:00:00 | MSFT | Stock | 331.69 | 331.75 | 331.0 | 331.33 | 31270.0 |
| 2021-12-07 08:30:00 | MSFT | Stock | 331.58 | 331.66 | 331.2 | 331.25 | 15084.0 |
| 2021-12-07 09:00:00 | MSFT | Stock | 331.43 | 332.38 | 330.46 | 331.61 | 63482.0 |
| 2021-12-07 09:30:00 | MSFT | Stock | 331.57 | 332.76 | 330.1 | 332.5 | 2980829.0 |
| 2021-12-07 10:00:00 | MSFT | Stock | 332.54 | 335.27 | 332.08 | 334.29 | 1795193.0 |
| 2021-12-07 10:30:00 | MSFT | Stock | 334.3 | 335.6 | 334.3 | 335.29 | 1434837.0 |
| 2021-12-07 11:00:00 | MSFT | Stock | 335.3 | 335.8 | 334.831 | 334.91 | 1101613.0 |
| 2021-12-07 11:30:00 | MSFT | Stock | 334.905 | 335.78 | 334.67 | 335.01 | 1124493.0 |
| 2021-12-07 12:00:00 | MSFT | Stock | 335.01 | 335.24 | 334.67 | 334.81 | 740965.0 |
| 2021-12-07 12:30:00 | MSFT | Stock | 334.83 | 335.78 | 334.75 | 335.4637 | 836317.0 |
> showing 50 of 114,283 rows — these rows as CSV