PREVIEW / stock_30min / 2021-03-01
file: by_date/stock_30min/2021/2021-03-01.parquet size: 2.4 MB rows: 121,285 symbols: 2,864
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-03-01 04:00:00 | AAPL | Stock | 124.3 | 124.6 | 123.7 | 123.82 | 79485.0 |
| 2021-03-01 04:30:00 | AAPL | Stock | 123.9 | 124.19 | 123.8 | 124.18 | 16309.0 |
| 2021-03-01 05:00:00 | AAPL | Stock | 124.11 | 124.34 | 123.93 | 123.94 | 26917.0 |
| 2021-03-01 05:30:00 | AAPL | Stock | 124.0 | 124.1 | 123.9 | 124.0 | 41488.0 |
| 2021-03-01 06:00:00 | AAPL | Stock | 124.0 | 124.16 | 123.56 | 123.63 | 36820.0 |
| 2021-03-01 06:30:00 | AAPL | Stock | 123.66 | 124.02 | 123.43 | 123.63 | 41129.0 |
| 2021-03-01 07:00:00 | AAPL | Stock | 123.6 | 123.76 | 123.34 | 123.55 | 250126.0 |
| 2021-03-01 07:30:00 | AAPL | Stock | 123.55 | 123.56 | 123.17 | 123.52 | 166823.0 |
| 2021-03-01 08:00:00 | AAPL | Stock | 123.59 | 123.7 | 121.563 | 123.54 | 390110.0 |
| 2021-03-01 08:30:00 | AAPL | Stock | 123.511 | 123.68 | 123.34 | 123.65 | 250147.0 |
| 2021-03-01 09:00:00 | AAPL | Stock | 123.6599 | 123.9 | 123.4 | 123.76 | 289081.0 |
| 2021-03-01 09:30:00 | AAPL | Stock | 123.74 | 124.84 | 122.79 | 124.8101 | 16216364.0 |
| 2021-03-01 10:00:00 | AAPL | Stock | 124.82 | 125.25 | 124.5001 | 125.085 | 8799235.0 |
| 2021-03-01 10:30:00 | AAPL | Stock | 125.085 | 125.72 | 124.8801 | 125.6122 | 6655326.0 |
| 2021-03-01 11:00:00 | AAPL | Stock | 125.63 | 126.155 | 125.425 | 125.8799 | 6711311.0 |
| 2021-03-01 11:30:00 | AAPL | Stock | 125.88 | 126.6 | 125.7899 | 126.54 | 5785067.0 |
| 2021-03-01 12:00:00 | AAPL | Stock | 126.54 | 126.62 | 125.83 | 126.23 | 5550879.0 |
| 2021-03-01 12:30:00 | AAPL | Stock | 126.24 | 126.4 | 125.94 | 126.1601 | 3373777.0 |
| 2021-03-01 13:00:00 | AAPL | Stock | 126.17 | 126.27 | 125.67 | 126.205 | 3864125.0 |
| 2021-03-01 13:30:00 | AAPL | Stock | 126.2 | 126.555 | 126.09 | 126.35 | 3437453.0 |
| 2021-03-01 14:00:00 | AAPL | Stock | 126.36 | 127.23 | 126.2701 | 127.105 | 6025011.0 |
| 2021-03-01 14:30:00 | AAPL | Stock | 127.11 | 127.75 | 126.91 | 127.575 | 5675291.0 |
| 2021-03-01 15:00:00 | AAPL | Stock | 127.585 | 127.72 | 127.29 | 127.56 | 4939609.0 |
| 2021-03-01 15:30:00 | AAPL | Stock | 127.565 | 127.93 | 127.27 | 127.79 | 10498444.0 |
| 2021-03-01 16:00:00 | AAPL | Stock | 127.79 | 128.69 | 127.79 | 128.28 | 10611534.0 |
| 2021-03-01 16:30:00 | AAPL | Stock | 128.3 | 128.5 | 127.79 | 128.36 | 167631.0 |
| 2021-03-01 17:00:00 | AAPL | Stock | 128.34 | 128.4 | 128.25 | 128.31 | 60650.0 |
| 2021-03-01 17:30:00 | AAPL | Stock | 128.31 | 128.62 | 128.3 | 128.44 | 75548.0 |
| 2021-03-01 18:00:00 | AAPL | Stock | 128.46 | 128.68 | 127.79 | 128.47 | 155399.0 |
| 2021-03-01 18:30:00 | AAPL | Stock | 128.5 | 128.55 | 128.3 | 128.4 | 55355.0 |
| 2021-03-01 19:00:00 | AAPL | Stock | 128.4 | 128.48 | 128.3 | 128.46 | 74966.0 |
| 2021-03-01 19:30:00 | AAPL | Stock | 128.49 | 128.75 | 128.45 | 128.75 | 102521.0 |
| 2021-03-01 04:00:00 | MSFT | Stock | 235.87 | 236.17 | 235.6 | 235.73 | 5766.0 |
| 2021-03-01 04:30:00 | MSFT | Stock | 235.54 | 235.7 | 235.54 | 235.7 | 588.0 |
| 2021-03-01 05:00:00 | MSFT | Stock | 235.89 | 236.16 | 235.76 | 235.9 | 3099.0 |
| 2021-03-01 05:30:00 | MSFT | Stock | 236.0 | 236.24 | 235.76 | 235.76 | 784.0 |
| 2021-03-01 06:00:00 | MSFT | Stock | 235.8 | 235.9 | 234.76 | 235.13 | 6157.0 |
| 2021-03-01 06:30:00 | MSFT | Stock | 235.3 | 235.55 | 234.73 | 234.78 | 4757.0 |
| 2021-03-01 07:00:00 | MSFT | Stock | 235.25 | 235.64 | 234.9 | 235.31 | 20805.0 |
| 2021-03-01 07:30:00 | MSFT | Stock | 235.32 | 235.32 | 234.75 | 234.8 | 5496.0 |
| 2021-03-01 08:00:00 | MSFT | Stock | 235.3 | 235.6514 | 231.8 | 234.93 | 24454.0 |
| 2021-03-01 08:30:00 | MSFT | Stock | 234.55 | 235.44 | 234.13 | 235.15 | 21436.0 |
| 2021-03-01 09:00:00 | MSFT | Stock | 235.39 | 236.21 | 234.78 | 236.0 | 51072.0 |
| 2021-03-01 09:30:00 | MSFT | Stock | 235.9 | 236.3 | 233.15 | 235.54 | 2800541.0 |
| 2021-03-01 10:00:00 | MSFT | Stock | 235.59 | 236.67 | 234.8 | 235.78 | 1787921.0 |
| 2021-03-01 10:30:00 | MSFT | Stock | 235.77 | 236.5794 | 235.65 | 236.5794 | 1063556.0 |
| 2021-03-01 11:00:00 | MSFT | Stock | 236.58 | 236.7 | 236.17 | 236.45 | 805250.0 |
| 2021-03-01 11:30:00 | MSFT | Stock | 236.455 | 237.25 | 236.28 | 236.94 | 1029608.0 |
| 2021-03-01 12:00:00 | MSFT | Stock | 236.95 | 237.135 | 236.57 | 236.94 | 808358.0 |
| 2021-03-01 12:30:00 | MSFT | Stock | 236.95 | 237.06 | 236.13 | 236.28 | 607268.0 |
> showing 50 of 121,285 rows — these rows as CSV