PREVIEW / stock_30min / 2020-09-01
file: by_date/stock_30min/2020/2020-09-01.parquet size: 2.0 MB rows: 98,121 symbols: 2,466
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-09-01 04:00:00 | AAPL | Stock | 132.1 | 132.5 | 131.55 | 131.8 | 169564.0 |
| 2020-09-01 04:30:00 | AAPL | Stock | 131.8 | 132.4 | 131.74 | 132.14 | 93820.0 |
| 2020-09-01 05:00:00 | AAPL | Stock | 132.13 | 132.5 | 131.83 | 132.23 | 70360.0 |
| 2020-09-01 05:30:00 | AAPL | Stock | 132.24 | 132.69 | 132.15 | 132.4 | 72342.0 |
| 2020-09-01 06:00:00 | AAPL | Stock | 132.45 | 132.5 | 132.25 | 132.5 | 51657.0 |
| 2020-09-01 06:30:00 | AAPL | Stock | 132.45 | 132.5 | 132.01 | 132.39 | 59280.0 |
| 2020-09-01 07:00:00 | AAPL | Stock | 132.32 | 132.4 | 131.24 | 131.38 | 518323.0 |
| 2020-09-01 07:30:00 | AAPL | Stock | 131.41 | 131.99 | 131.16 | 131.99 | 368510.0 |
| 2020-09-01 08:00:00 | AAPL | Stock | 131.98 | 132.45 | 131.164 | 132.0 | 1001488.0 |
| 2020-09-01 08:30:00 | AAPL | Stock | 132.0 | 132.54 | 131.18 | 131.4 | 940420.0 |
| 2020-09-01 09:00:00 | AAPL | Stock | 131.42 | 132.9 | 129.04 | 132.78 | 1686202.0 |
| 2020-09-01 09:30:00 | AAPL | Stock | 132.79 | 132.92 | 130.53 | 131.64 | 24018471.0 |
| 2020-09-01 10:00:00 | AAPL | Stock | 131.65 | 132.08 | 130.77 | 131.81 | 11113352.0 |
| 2020-09-01 10:30:00 | AAPL | Stock | 131.81 | 132.2 | 131.51 | 131.77 | 7075437.0 |
| 2020-09-01 11:00:00 | AAPL | Stock | 131.78 | 132.65 | 131.75 | 132.373 | 8821517.0 |
| 2020-09-01 11:30:00 | AAPL | Stock | 132.35 | 132.46 | 131.79 | 132.31 | 5634610.0 |
| 2020-09-01 12:00:00 | AAPL | Stock | 132.31 | 132.68 | 132.247 | 132.525 | 5791193.0 |
| 2020-09-01 12:30:00 | AAPL | Stock | 132.529 | 133.94 | 132.51 | 133.705 | 9297078.0 |
| 2020-09-01 13:00:00 | AAPL | Stock | 133.706 | 133.76 | 133.23 | 133.583 | 5764047.0 |
| 2020-09-01 13:30:00 | AAPL | Stock | 133.57 | 134.8 | 133.57 | 134.67 | 8556026.0 |
| 2020-09-01 14:00:00 | AAPL | Stock | 134.67 | 134.7 | 133.96 | 134.58 | 6756166.0 |
| 2020-09-01 14:30:00 | AAPL | Stock | 134.56 | 134.68 | 133.67 | 133.97 | 6325577.0 |
| 2020-09-01 15:00:00 | AAPL | Stock | 133.95 | 134.38 | 133.78 | 133.83 | 6010306.0 |
| 2020-09-01 15:30:00 | AAPL | Stock | 133.83 | 134.54 | 133.55 | 134.2 | 11765061.0 |
| 2020-09-01 16:00:00 | AAPL | Stock | 134.2 | 134.75 | 134.14 | 134.46 | 7673263.0 |
| 2020-09-01 16:30:00 | AAPL | Stock | 134.43 | 134.51 | 134.36 | 134.45 | 152235.0 |
| 2020-09-01 17:00:00 | AAPL | Stock | 134.45 | 134.58 | 134.41 | 134.58 | 102721.0 |
| 2020-09-01 17:30:00 | AAPL | Stock | 134.59 | 134.6 | 134.25 | 134.34 | 90061.0 |
| 2020-09-01 18:00:00 | AAPL | Stock | 134.34 | 134.34 | 134.23 | 134.26 | 86101.0 |
| 2020-09-01 18:30:00 | AAPL | Stock | 134.25 | 134.26 | 134.12 | 134.12 | 128043.0 |
| 2020-09-01 19:00:00 | AAPL | Stock | 134.12 | 134.5 | 134.1 | 134.42 | 67717.0 |
| 2020-09-01 19:30:00 | AAPL | Stock | 134.42 | 135.0 | 134.4 | 135.0 | 182798.0 |
| 2020-09-01 04:00:00 | MSFT | Stock | 225.88 | 227.42 | 225.88 | 227.18 | 5049.0 |
| 2020-09-01 04:30:00 | MSFT | Stock | 227.19 | 227.2 | 225.81 | 225.93 | 21928.0 |
| 2020-09-01 05:00:00 | MSFT | Stock | 226.0 | 227.2 | 226.0 | 227.0 | 5576.0 |
| 2020-09-01 05:30:00 | MSFT | Stock | 226.98 | 227.2 | 226.8 | 226.82 | 12623.0 |
| 2020-09-01 06:00:00 | MSFT | Stock | 226.73 | 227.14 | 226.51 | 226.91 | 2283.0 |
| 2020-09-01 06:30:00 | MSFT | Stock | 227.03 | 227.48 | 227.0 | 227.48 | 3000.0 |
| 2020-09-01 07:00:00 | MSFT | Stock | 227.33 | 227.45 | 226.7 | 227.45 | 38946.0 |
| 2020-09-01 07:30:00 | MSFT | Stock | 227.45 | 227.45 | 226.81 | 226.91 | 13541.0 |
| 2020-09-01 08:00:00 | MSFT | Stock | 226.958 | 227.45 | 226.45 | 226.71 | 50906.0 |
| 2020-09-01 08:30:00 | MSFT | Stock | 226.795 | 227.34 | 226.5 | 226.7 | 32627.0 |
| 2020-09-01 09:00:00 | MSFT | Stock | 226.7 | 226.7 | 225.51 | 225.51 | 81744.0 |
| 2020-09-01 09:30:00 | MSFT | Stock | 225.51 | 226.53 | 224.43 | 226.03 | 3103888.0 |
| 2020-09-01 10:00:00 | MSFT | Stock | 226.03 | 226.98 | 225.83 | 226.65 | 1704735.0 |
| 2020-09-01 10:30:00 | MSFT | Stock | 226.65 | 226.83 | 225.91 | 226.14 | 1201746.0 |
| 2020-09-01 11:00:00 | MSFT | Stock | 226.125 | 226.72 | 225.29 | 226.695 | 1271231.0 |
| 2020-09-01 11:30:00 | MSFT | Stock | 226.695 | 226.85 | 226.0 | 226.149 | 863508.0 |
| 2020-09-01 12:00:00 | MSFT | Stock | 226.15 | 226.45 | 225.88 | 225.89 | 700323.0 |
| 2020-09-01 12:30:00 | MSFT | Stock | 225.904 | 225.99 | 224.86 | 224.99 | 1127334.0 |
> showing 50 of 98,121 rows — these rows as CSV