PREVIEW / stock_30min / 2020-12-21
file: by_date/stock_30min/2020/2020-12-21.parquet size: 2.3 MB rows: 116,146 symbols: 2,693
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-12-21 04:00:00 | AAPL | Stock | 127.1 | 127.5 | 126.0 | 127.06 | 51223.0 |
| 2020-12-21 04:30:00 | AAPL | Stock | 127.06 | 127.28 | 125.62 | 126.0 | 44461.0 |
| 2020-12-21 05:00:00 | AAPL | Stock | 125.95 | 125.99 | 124.41 | 124.49 | 100671.0 |
| 2020-12-21 05:30:00 | AAPL | Stock | 124.43 | 124.7 | 124.01 | 124.28 | 76409.0 |
| 2020-12-21 06:00:00 | AAPL | Stock | 124.28 | 124.8 | 124.0 | 124.5 | 45874.0 |
| 2020-12-21 06:30:00 | AAPL | Stock | 124.62 | 125.0 | 124.5 | 124.85 | 18748.0 |
| 2020-12-21 07:00:00 | AAPL | Stock | 124.75 | 125.48 | 123.84 | 124.3 | 831436.0 |
| 2020-12-21 07:30:00 | AAPL | Stock | 124.32 | 125.01 | 124.24 | 124.69 | 400640.0 |
| 2020-12-21 08:00:00 | AAPL | Stock | 124.7 | 125.45 | 123.85 | 124.86 | 624279.0 |
| 2020-12-21 08:30:00 | AAPL | Stock | 124.86 | 125.25 | 124.77 | 125.15 | 337304.0 |
| 2020-12-21 09:00:00 | AAPL | Stock | 125.15 | 126.655 | 124.68 | 125.05 | 364270.0 |
| 2020-12-21 09:30:00 | AAPL | Stock | 125.04 | 126.618 | 124.77 | 125.91 | 13212580.0 |
| 2020-12-21 10:00:00 | AAPL | Stock | 125.91 | 126.025 | 123.89 | 124.02 | 10356125.0 |
| 2020-12-21 10:30:00 | AAPL | Stock | 124.01 | 124.35 | 123.449 | 123.85 | 8370267.0 |
| 2020-12-21 11:00:00 | AAPL | Stock | 123.85 | 124.79 | 123.81 | 124.575 | 5816424.0 |
| 2020-12-21 11:30:00 | AAPL | Stock | 124.58 | 125.155 | 124.57 | 124.94 | 4537696.0 |
| 2020-12-21 12:00:00 | AAPL | Stock | 124.94 | 125.72 | 124.89 | 125.696 | 3895877.0 |
| 2020-12-21 12:30:00 | AAPL | Stock | 125.695 | 126.05 | 125.578 | 126.041 | 3636902.0 |
| 2020-12-21 13:00:00 | AAPL | Stock | 126.05 | 126.45 | 125.84 | 126.415 | 3683158.0 |
| 2020-12-21 13:30:00 | AAPL | Stock | 126.41 | 127.28 | 126.4 | 126.74 | 5291609.0 |
| 2020-12-21 14:00:00 | AAPL | Stock | 126.73 | 127.03 | 126.49 | 126.99 | 4006076.0 |
| 2020-12-21 14:30:00 | AAPL | Stock | 126.99 | 127.06 | 126.6 | 126.748 | 3488945.0 |
| 2020-12-21 15:00:00 | AAPL | Stock | 126.75 | 126.81 | 126.27 | 126.481 | 4168721.0 |
| 2020-12-21 15:30:00 | AAPL | Stock | 126.48 | 128.31 | 126.14 | 128.24 | 17183310.0 |
| 2020-12-21 16:00:00 | AAPL | Stock | 128.23 | 129.48 | 127.98 | 129.25 | 13748879.0 |
| 2020-12-21 16:30:00 | AAPL | Stock | 129.25 | 130.0 | 129.2 | 129.99 | 950681.0 |
| 2020-12-21 17:00:00 | AAPL | Stock | 129.99 | 132.0 | 129.78 | 131.56 | 1571892.0 |
| 2020-12-21 17:30:00 | AAPL | Stock | 131.56 | 131.62 | 130.12 | 130.65 | 1031232.0 |
| 2020-12-21 18:00:00 | AAPL | Stock | 130.63 | 131.38 | 130.6 | 131.21 | 441375.0 |
| 2020-12-21 18:30:00 | AAPL | Stock | 131.21 | 131.45 | 130.91 | 131.12 | 388982.0 |
| 2020-12-21 19:00:00 | AAPL | Stock | 131.11 | 131.15 | 130.9 | 130.92 | 151601.0 |
| 2020-12-21 19:30:00 | AAPL | Stock | 130.94 | 131.0 | 130.5 | 130.62 | 309319.0 |
| 2020-12-21 04:00:00 | MSFT | Stock | 220.29 | 220.29 | 218.0 | 219.2 | 11799.0 |
| 2020-12-21 04:30:00 | MSFT | Stock | 218.84 | 219.17 | 218.01 | 218.13 | 3941.0 |
| 2020-12-21 05:00:00 | MSFT | Stock | 218.05 | 218.05 | 216.02 | 216.1 | 9229.0 |
| 2020-12-21 05:30:00 | MSFT | Stock | 216.1 | 217.02 | 215.55 | 216.0 | 15743.0 |
| 2020-12-21 06:00:00 | MSFT | Stock | 216.01 | 217.5 | 216.01 | 216.68 | 9246.0 |
| 2020-12-21 06:30:00 | MSFT | Stock | 216.7 | 217.2 | 216.52 | 216.95 | 17951.0 |
| 2020-12-21 07:00:00 | MSFT | Stock | 217.16 | 217.24 | 216.5 | 217.0 | 47539.0 |
| 2020-12-21 07:30:00 | MSFT | Stock | 217.0 | 217.9 | 217.0 | 217.11 | 37995.0 |
| 2020-12-21 08:00:00 | MSFT | Stock | 216.98 | 217.83 | 216.5 | 217.28 | 72763.0 |
| 2020-12-21 08:30:00 | MSFT | Stock | 217.28 | 217.65 | 217.04 | 217.49 | 51528.0 |
| 2020-12-21 09:00:00 | MSFT | Stock | 217.6 | 218.59 | 217.1 | 217.55 | 114721.0 |
| 2020-12-21 09:30:00 | MSFT | Stock | 217.55 | 220.24 | 217.5 | 218.57 | 3505722.0 |
| 2020-12-21 10:00:00 | MSFT | Stock | 218.55 | 219.24 | 217.425 | 217.9 | 2074193.0 |
| 2020-12-21 10:30:00 | MSFT | Stock | 217.83 | 218.73 | 217.28 | 218.604 | 1812598.0 |
| 2020-12-21 11:00:00 | MSFT | Stock | 218.605 | 219.5 | 218.55 | 219.4 | 1249858.0 |
| 2020-12-21 11:30:00 | MSFT | Stock | 219.39 | 220.438 | 219.38 | 220.14 | 1360369.0 |
| 2020-12-21 12:00:00 | MSFT | Stock | 220.14 | 220.94 | 220.0 | 220.758 | 1340837.0 |
| 2020-12-21 12:30:00 | MSFT | Stock | 220.76 | 222.72 | 220.73 | 222.712 | 2399962.0 |
> showing 50 of 116,146 rows — these rows as CSV