PREVIEW / stock_30min / 2022-01-21
file: by_date/stock_30min/2022/2022-01-21.parquet size: 2.3 MB rows: 115,088 symbols: 2,695
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-21 04:00:00 | AAPL | Stock | 163.52 | 163.92 | 162.65 | 163.32 | 68898.0 |
| 2022-01-21 04:30:00 | AAPL | Stock | 163.4 | 163.97 | 163.26 | 163.87 | 40721.0 |
| 2022-01-21 05:00:00 | AAPL | Stock | 163.89 | 164.5 | 163.79 | 164.34 | 29409.0 |
| 2022-01-21 05:30:00 | AAPL | Stock | 164.31 | 164.31 | 164.0 | 164.28 | 23502.0 |
| 2022-01-21 06:00:00 | AAPL | Stock | 164.28 | 164.28 | 163.19 | 163.37 | 41220.0 |
| 2022-01-21 06:30:00 | AAPL | Stock | 163.34 | 163.83 | 163.27 | 163.7 | 35125.0 |
| 2022-01-21 07:00:00 | AAPL | Stock | 163.67 | 163.9 | 162.83 | 163.37 | 115489.0 |
| 2022-01-21 07:30:00 | AAPL | Stock | 163.37 | 163.51 | 162.89 | 163.03 | 94783.0 |
| 2022-01-21 08:00:00 | AAPL | Stock | 163.46 | 163.795 | 162.73 | 163.29 | 518035.0 |
| 2022-01-21 08:30:00 | AAPL | Stock | 163.2801 | 163.5 | 162.85 | 163.3 | 224485.0 |
| 2022-01-21 09:00:00 | AAPL | Stock | 163.32 | 165.01 | 162.85 | 164.49 | 632493.0 |
| 2022-01-21 09:30:00 | AAPL | Stock | 164.415 | 166.0 | 163.18 | 163.53 | 14889374.0 |
| 2022-01-21 10:00:00 | AAPL | Stock | 163.54 | 164.6 | 162.96 | 164.31 | 9217693.0 |
| 2022-01-21 10:30:00 | AAPL | Stock | 164.31 | 165.84 | 164.13 | 165.16 | 8263842.0 |
| 2022-01-21 11:00:00 | AAPL | Stock | 165.17 | 166.33 | 164.65 | 165.95 | 6511975.0 |
| 2022-01-21 11:30:00 | AAPL | Stock | 165.94 | 165.95 | 164.02 | 164.44 | 5462287.0 |
| 2022-01-21 12:00:00 | AAPL | Stock | 164.42 | 164.67 | 163.52 | 163.73 | 4703137.0 |
| 2022-01-21 12:30:00 | AAPL | Stock | 163.73 | 164.03 | 163.25 | 163.96 | 4012301.0 |
| 2022-01-21 13:00:00 | AAPL | Stock | 163.95 | 164.78 | 163.35 | 163.75 | 4395470.0 |
| 2022-01-21 13:30:00 | AAPL | Stock | 163.75 | 164.53 | 163.57 | 163.765 | 3995145.0 |
| 2022-01-21 14:00:00 | AAPL | Stock | 163.765 | 164.3299 | 163.3 | 163.37 | 4503486.0 |
| 2022-01-21 14:30:00 | AAPL | Stock | 163.365 | 163.92 | 163.06 | 163.11 | 4680259.0 |
| 2022-01-21 15:00:00 | AAPL | Stock | 163.1195 | 163.45 | 162.405 | 162.86 | 7851070.0 |
| 2022-01-21 15:30:00 | AAPL | Stock | 162.86 | 163.885 | 162.3 | 162.41 | 12494445.0 |
| 2022-01-21 16:00:00 | AAPL | Stock | 162.41 | 162.69 | 162.33 | 162.49 | 10987947.0 |
| 2022-01-21 16:30:00 | AAPL | Stock | 162.49 | 162.56 | 162.41 | 162.45 | 527754.0 |
| 2022-01-21 17:00:00 | AAPL | Stock | 162.48 | 162.5 | 162.36 | 162.36 | 77018.0 |
| 2022-01-21 17:30:00 | AAPL | Stock | 162.36 | 162.36 | 161.81 | 162.14 | 75986.0 |
| 2022-01-21 18:00:00 | AAPL | Stock | 162.1 | 162.1001 | 161.9 | 161.98 | 34114.0 |
| 2022-01-21 18:30:00 | AAPL | Stock | 161.95 | 161.95 | 161.62 | 161.77 | 47332.0 |
| 2022-01-21 19:00:00 | AAPL | Stock | 161.66 | 161.76 | 161.57 | 161.64 | 57911.0 |
| 2022-01-21 19:30:00 | AAPL | Stock | 161.6 | 161.72 | 161.5 | 161.62 | 44008.0 |
| 2022-01-21 04:00:00 | MSFT | Stock | 302.46 | 302.94 | 301.26 | 302.94 | 13724.0 |
| 2022-01-21 04:30:00 | MSFT | Stock | 303.08 | 304.0 | 303.0 | 303.7 | 9554.0 |
| 2022-01-21 05:00:00 | MSFT | Stock | 303.47 | 304.0 | 303.47 | 304.0 | 5007.0 |
| 2022-01-21 05:30:00 | MSFT | Stock | 303.76 | 303.9 | 303.55 | 303.55 | 1006.0 |
| 2022-01-21 06:00:00 | MSFT | Stock | 303.24 | 303.24 | 301.97 | 302.06 | 11585.0 |
| 2022-01-21 06:30:00 | MSFT | Stock | 302.06 | 303.0 | 301.83 | 303.0 | 7156.0 |
| 2022-01-21 07:00:00 | MSFT | Stock | 303.0 | 303.01 | 301.16 | 301.73 | 58195.0 |
| 2022-01-21 07:30:00 | MSFT | Stock | 301.75 | 301.8 | 300.96 | 301.0 | 32135.0 |
| 2022-01-21 08:00:00 | MSFT | Stock | 301.7866 | 303.16 | 300.99 | 301.97 | 113406.0 |
| 2022-01-21 08:30:00 | MSFT | Stock | 301.7 | 302.0 | 301.55 | 301.75 | 51621.0 |
| 2022-01-21 09:00:00 | MSFT | Stock | 301.75 | 303.0 | 300.06 | 302.99 | 147766.0 |
| 2022-01-21 09:30:00 | MSFT | Stock | 302.85 | 303.2488 | 297.74 | 299.08 | 6320669.0 |
| 2022-01-21 10:00:00 | MSFT | Stock | 299.11 | 300.85 | 297.62 | 299.128 | 2976433.0 |
| 2022-01-21 10:30:00 | MSFT | Stock | 299.13 | 302.6 | 298.8897 | 301.2 | 3258127.0 |
| 2022-01-21 11:00:00 | MSFT | Stock | 301.2 | 303.91 | 301.04 | 303.8 | 2407322.0 |
| 2022-01-21 11:30:00 | MSFT | Stock | 303.82 | 304.11 | 301.17 | 302.41 | 2214373.0 |
| 2022-01-21 12:00:00 | MSFT | Stock | 302.39 | 303.33 | 300.91 | 301.725 | 1490065.0 |
| 2022-01-21 12:30:00 | MSFT | Stock | 301.75 | 302.79 | 300.55 | 301.32 | 1165697.0 |
> showing 50 of 115,088 rows — these rows as CSV