PREVIEW / stock_30min / 2022-01-05
file: by_date/stock_30min/2022/2022-01-05.parquet size: 2.3 MB rows: 111,285 symbols: 2,626
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-05 04:00:00 | AAPL | Stock | 179.52 | 179.8 | 179.32 | 179.71 | 11286.0 |
| 2022-01-05 04:30:00 | AAPL | Stock | 179.74 | 179.74 | 179.57 | 179.64 | 5312.0 |
| 2022-01-05 05:00:00 | AAPL | Stock | 179.76 | 179.97 | 179.76 | 179.85 | 5004.0 |
| 2022-01-05 05:30:00 | AAPL | Stock | 180.0 | 180.24 | 179.59 | 179.6 | 4191.0 |
| 2022-01-05 06:00:00 | AAPL | Stock | 179.6 | 179.6 | 179.37 | 179.4 | 5093.0 |
| 2022-01-05 06:30:00 | AAPL | Stock | 179.45 | 179.45 | 179.34 | 179.4 | 5399.0 |
| 2022-01-05 07:00:00 | AAPL | Stock | 179.47 | 179.67 | 179.25 | 179.25 | 48553.0 |
| 2022-01-05 07:30:00 | AAPL | Stock | 179.4 | 179.42 | 179.13 | 179.26 | 21098.0 |
| 2022-01-05 08:00:00 | AAPL | Stock | 179.34 | 179.65 | 178.77 | 179.14 | 203302.0 |
| 2022-01-05 08:30:00 | AAPL | Stock | 179.1202 | 179.7958 | 178.99 | 179.35 | 118469.0 |
| 2022-01-05 09:00:00 | AAPL | Stock | 179.4 | 179.64 | 179.05 | 179.62 | 159626.0 |
| 2022-01-05 09:30:00 | AAPL | Stock | 179.62 | 180.17 | 177.56 | 179.29 | 8745944.0 |
| 2022-01-05 10:00:00 | AAPL | Stock | 179.28 | 179.48 | 177.97 | 178.93 | 5796516.0 |
| 2022-01-05 10:30:00 | AAPL | Stock | 178.92 | 178.93 | 178.1 | 178.725 | 3509190.0 |
| 2022-01-05 11:00:00 | AAPL | Stock | 178.74 | 179.33 | 178.53 | 179.305 | 3054410.0 |
| 2022-01-05 11:30:00 | AAPL | Stock | 179.31 | 179.431 | 178.56 | 178.81 | 3080868.0 |
| 2022-01-05 12:00:00 | AAPL | Stock | 178.801 | 179.25 | 178.6 | 179.13 | 2481486.0 |
| 2022-01-05 12:30:00 | AAPL | Stock | 179.12 | 179.1299 | 178.25 | 178.3472 | 3277600.0 |
| 2022-01-05 13:00:00 | AAPL | Stock | 178.3345 | 178.44 | 177.67 | 178.27 | 3827687.0 |
| 2022-01-05 13:30:00 | AAPL | Stock | 178.27 | 178.55 | 178.0 | 178.04 | 2030704.0 |
| 2022-01-05 14:00:00 | AAPL | Stock | 178.0482 | 178.72 | 176.9 | 177.09 | 6556794.0 |
| 2022-01-05 14:30:00 | AAPL | Stock | 177.09 | 177.4 | 176.1 | 176.505 | 5226978.0 |
| 2022-01-05 15:00:00 | AAPL | Stock | 176.51 | 176.62 | 175.26 | 176.3403 | 7428277.0 |
| 2022-01-05 15:30:00 | AAPL | Stock | 176.35 | 176.84 | 174.64 | 174.835 | 13098286.0 |
| 2022-01-05 16:00:00 | AAPL | Stock | 174.93 | 179.7958 | 174.5 | 174.85 | 10586854.0 |
| 2022-01-05 16:30:00 | AAPL | Stock | 174.85 | 174.92 | 174.43 | 174.43 | 100572.0 |
| 2022-01-05 17:00:00 | AAPL | Stock | 174.92 | 174.92 | 174.4 | 174.7 | 107247.0 |
| 2022-01-05 17:30:00 | AAPL | Stock | 174.71 | 174.73 | 174.6 | 174.7 | 29880.0 |
| 2022-01-05 18:00:00 | AAPL | Stock | 174.69 | 174.72 | 174.08 | 174.72 | 95834.0 |
| 2022-01-05 18:30:00 | AAPL | Stock | 174.75 | 175.08 | 174.68 | 175.06 | 49371.0 |
| 2022-01-05 19:00:00 | AAPL | Stock | 175.07 | 175.28 | 175.0501 | 175.2 | 37538.0 |
| 2022-01-05 19:30:00 | AAPL | Stock | 175.22 | 175.35 | 174.75 | 175.07 | 73315.0 |
| 2022-01-05 04:00:00 | MSFT | Stock | 328.21 | 328.5 | 327.9 | 328.5 | 3204.0 |
| 2022-01-05 04:30:00 | MSFT | Stock | 328.58 | 328.62 | 328.3 | 328.62 | 2775.0 |
| 2022-01-05 05:30:00 | MSFT | Stock | 328.7 | 328.7 | 328.7 | 328.7 | 100.0 |
| 2022-01-05 06:00:00 | MSFT | Stock | 328.33 | 328.33 | 328.2 | 328.2 | 1035.0 |
| 2022-01-05 06:30:00 | MSFT | Stock | 328.12 | 328.96 | 328.09 | 328.59 | 5589.0 |
| 2022-01-05 07:00:00 | MSFT | Stock | 328.32 | 328.4 | 328.1 | 328.35 | 4803.0 |
| 2022-01-05 07:30:00 | MSFT | Stock | 328.23 | 328.3 | 327.31 | 327.7 | 7224.0 |
| 2022-01-05 08:00:00 | MSFT | Stock | 327.4 | 328.49 | 327.0 | 327.4 | 17416.0 |
| 2022-01-05 08:30:00 | MSFT | Stock | 327.48 | 328.0 | 327.0 | 327.8 | 17345.0 |
| 2022-01-05 09:00:00 | MSFT | Stock | 327.78 | 327.78 | 325.74 | 325.75 | 41027.0 |
| 2022-01-05 09:30:00 | MSFT | Stock | 325.75 | 326.07 | 320.81 | 322.84 | 4605173.0 |
| 2022-01-05 10:00:00 | MSFT | Stock | 322.83 | 323.58 | 322.0 | 323.23 | 1771070.0 |
| 2022-01-05 10:30:00 | MSFT | Stock | 323.2 | 323.21 | 321.58 | 322.75 | 1625835.0 |
| 2022-01-05 11:00:00 | MSFT | Stock | 322.74 | 323.05 | 321.79 | 322.974 | 1044935.0 |
| 2022-01-05 11:30:00 | MSFT | Stock | 322.99 | 323.2499 | 321.75 | 321.81 | 901317.0 |
| 2022-01-05 12:00:00 | MSFT | Stock | 321.79 | 322.4 | 321.5859 | 321.64 | 814939.0 |
| 2022-01-05 12:30:00 | MSFT | Stock | 321.645 | 321.68 | 320.15 | 320.58 | 1406516.0 |
| 2022-01-05 13:00:00 | MSFT | Stock | 320.52 | 321.5183 | 320.342 | 321.355 | 1029413.0 |
> showing 50 of 111,285 rows — these rows as CSV