PREVIEW / stock_30min / 2022-03-11
file: by_date/stock_30min/2022/2022-03-11.parquet size: 2.2 MB rows: 107,982 symbols: 2,495
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-03-11 04:00:00 | AAPL | Stock | 158.4 | 159.35 | 158.4 | 159.15 | 10855.0 |
| 2022-03-11 04:30:00 | AAPL | Stock | 159.1 | 159.39 | 158.97 | 159.37 | 9268.0 |
| 2022-03-11 05:00:00 | AAPL | Stock | 159.39 | 159.54 | 159.2 | 159.35 | 6268.0 |
| 2022-03-11 05:30:00 | AAPL | Stock | 159.45 | 159.45 | 159.0 | 159.22 | 5340.0 |
| 2022-03-11 06:00:00 | AAPL | Stock | 159.22 | 162.0 | 159.1 | 161.49 | 40378.0 |
| 2022-03-11 06:30:00 | AAPL | Stock | 161.2 | 161.5 | 160.56 | 161.1 | 48876.0 |
| 2022-03-11 07:00:00 | AAPL | Stock | 161.14 | 161.29 | 160.48 | 160.68 | 179287.0 |
| 2022-03-11 07:30:00 | AAPL | Stock | 160.67 | 160.95 | 160.17 | 160.19 | 111415.0 |
| 2022-03-11 08:00:00 | AAPL | Stock | 160.5421 | 161.01 | 158.6 | 160.26 | 505914.0 |
| 2022-03-11 08:30:00 | AAPL | Stock | 160.3 | 160.32 | 158.52 | 159.94 | 305986.0 |
| 2022-03-11 09:00:00 | AAPL | Stock | 159.92 | 160.0 | 158.52 | 158.95 | 259954.0 |
| 2022-03-11 09:30:00 | AAPL | Stock | 158.97 | 159.28 | 156.97 | 157.65 | 10662094.0 |
| 2022-03-11 10:00:00 | AAPL | Stock | 157.66 | 157.95 | 156.93 | 157.66 | 5389474.0 |
| 2022-03-11 10:30:00 | AAPL | Stock | 157.655 | 158.125 | 157.32 | 157.865 | 4193844.0 |
| 2022-03-11 11:00:00 | AAPL | Stock | 157.861 | 157.89 | 155.87 | 155.89 | 5378304.0 |
| 2022-03-11 11:30:00 | AAPL | Stock | 155.885 | 155.92 | 154.78 | 155.5 | 8268610.0 |
| 2022-03-11 12:00:00 | AAPL | Stock | 155.5 | 155.605 | 154.9 | 154.9276 | 5218522.0 |
| 2022-03-11 12:30:00 | AAPL | Stock | 154.93 | 155.57 | 154.74 | 155.3833 | 4429076.0 |
| 2022-03-11 13:00:00 | AAPL | Stock | 155.39 | 156.59 | 155.28 | 156.5001 | 4336743.0 |
| 2022-03-11 13:30:00 | AAPL | Stock | 156.5 | 156.795 | 156.05 | 156.09 | 4183843.0 |
| 2022-03-11 14:00:00 | AAPL | Stock | 156.09 | 156.61 | 155.88 | 156.5399 | 3646402.0 |
| 2022-03-11 14:30:00 | AAPL | Stock | 156.535 | 156.54 | 155.62 | 155.9 | 3458887.0 |
| 2022-03-11 15:00:00 | AAPL | Stock | 155.91 | 156.02 | 155.01 | 155.085 | 3731571.0 |
| 2022-03-11 15:30:00 | AAPL | Stock | 155.08 | 155.36 | 154.5 | 154.73 | 10705765.0 |
| 2022-03-11 16:00:00 | AAPL | Stock | 154.75 | 154.96 | 154.44 | 154.8038 | 8532035.0 |
| 2022-03-11 16:30:00 | AAPL | Stock | 154.87 | 154.95 | 154.42 | 154.42 | 214603.0 |
| 2022-03-11 17:00:00 | AAPL | Stock | 154.48 | 154.61 | 154.41 | 154.6 | 32512.0 |
| 2022-03-11 17:30:00 | AAPL | Stock | 154.59 | 154.72 | 154.57 | 154.62 | 16225.0 |
| 2022-03-11 18:00:00 | AAPL | Stock | 154.67 | 154.68 | 154.35 | 154.38 | 16781.0 |
| 2022-03-11 18:30:00 | AAPL | Stock | 154.35 | 154.49 | 154.33 | 154.49 | 24848.0 |
| 2022-03-11 19:00:00 | AAPL | Stock | 154.49 | 154.59 | 154.45 | 154.51 | 23093.0 |
| 2022-03-11 19:30:00 | AAPL | Stock | 154.52 | 154.55 | 154.44 | 154.44 | 49756.0 |
| 2022-03-11 04:00:00 | MSFT | Stock | 285.24 | 285.97 | 285.24 | 285.97 | 1224.0 |
| 2022-03-11 04:30:00 | MSFT | Stock | 285.63 | 286.67 | 285.63 | 286.67 | 3643.0 |
| 2022-03-11 05:00:00 | MSFT | Stock | 286.8 | 286.8 | 286.8 | 286.8 | 154.0 |
| 2022-03-11 05:30:00 | MSFT | Stock | 287.41 | 287.41 | 286.71 | 286.71 | 1870.0 |
| 2022-03-11 06:00:00 | MSFT | Stock | 286.3 | 293.0 | 286.0 | 290.2 | 7688.0 |
| 2022-03-11 06:30:00 | MSFT | Stock | 290.26 | 291.2 | 289.5 | 290.0 | 4853.0 |
| 2022-03-11 07:00:00 | MSFT | Stock | 289.89 | 290.77 | 289.4 | 290.5 | 26830.0 |
| 2022-03-11 07:30:00 | MSFT | Stock | 290.66 | 291.51 | 289.4 | 289.5 | 17324.0 |
| 2022-03-11 08:00:00 | MSFT | Stock | 290.0 | 291.5 | 288.5 | 289.52 | 55433.0 |
| 2022-03-11 08:30:00 | MSFT | Stock | 289.68 | 289.68 | 288.54 | 288.88 | 16417.0 |
| 2022-03-11 09:00:00 | MSFT | Stock | 288.85 | 289.47 | 287.96 | 287.96 | 12896.0 |
| 2022-03-11 09:30:00 | MSFT | Stock | 287.97 | 289.51 | 286.11 | 286.8676 | 2131249.0 |
| 2022-03-11 10:00:00 | MSFT | Stock | 286.79 | 286.815 | 284.93 | 285.76 | 1247110.0 |
| 2022-03-11 10:30:00 | MSFT | Stock | 285.78 | 288.08 | 285.5 | 287.28 | 1305228.0 |
| 2022-03-11 11:00:00 | MSFT | Stock | 287.27 | 287.3 | 285.38 | 285.48 | 925228.0 |
| 2022-03-11 11:30:00 | MSFT | Stock | 285.43 | 285.54 | 283.84 | 284.5 | 793030.0 |
| 2022-03-11 12:00:00 | MSFT | Stock | 284.46 | 285.21 | 283.75 | 283.75 | 753551.0 |
| 2022-03-11 12:30:00 | MSFT | Stock | 283.765 | 284.51 | 283.25 | 284.24 | 654804.0 |
> showing 50 of 107,982 rows — these rows as CSV