PREVIEW / stock_30min / 2022-03-14
file: by_date/stock_30min/2022/2022-03-14.parquet size: 2.2 MB rows: 111,228 symbols: 2,493
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-14 04:00:00 | AAPL | Stock | 154.0 | 155.02 | 153.77 | 154.0 | 61648.0 |
| 2022-03-14 04:30:00 | AAPL | Stock | 153.92 | 154.3 | 153.8 | 154.2 | 25386.0 |
| 2022-03-14 05:00:00 | AAPL | Stock | 154.21 | 154.75 | 154.2 | 154.3 | 31007.0 |
| 2022-03-14 05:30:00 | AAPL | Stock | 154.25 | 155.6 | 154.14 | 155.15 | 47532.0 |
| 2022-03-14 06:00:00 | AAPL | Stock | 155.04 | 155.36 | 154.53 | 154.77 | 27170.0 |
| 2022-03-14 06:30:00 | AAPL | Stock | 154.8 | 155.07 | 154.32 | 154.4 | 44973.0 |
| 2022-03-14 07:00:00 | AAPL | Stock | 154.38 | 154.4 | 153.0 | 153.19 | 179961.0 |
| 2022-03-14 07:30:00 | AAPL | Stock | 153.2 | 153.24 | 152.0 | 152.15 | 331213.0 |
| 2022-03-14 08:00:00 | AAPL | Stock | 154.309 | 156.1 | 151.5 | 151.59 | 813523.0 |
| 2022-03-14 08:30:00 | AAPL | Stock | 151.6 | 152.46 | 151.51 | 152.36 | 440731.0 |
| 2022-03-14 09:00:00 | AAPL | Stock | 152.32 | 152.35 | 151.06 | 151.53 | 441161.0 |
| 2022-03-14 09:30:00 | AAPL | Stock | 151.45 | 153.32 | 151.3 | 152.47 | 13660549.0 |
| 2022-03-14 10:00:00 | AAPL | Stock | 152.46 | 153.74 | 152.13 | 153.32 | 6604593.0 |
| 2022-03-14 10:30:00 | AAPL | Stock | 153.315 | 154.0 | 152.63 | 153.99 | 5717704.0 |
| 2022-03-14 11:00:00 | AAPL | Stock | 153.99 | 154.12 | 152.89 | 153.08 | 4152100.0 |
| 2022-03-14 11:30:00 | AAPL | Stock | 153.1 | 153.19 | 152.13 | 152.485 | 3950346.0 |
| 2022-03-14 12:00:00 | AAPL | Stock | 152.475 | 152.53 | 151.5 | 151.96 | 5133829.0 |
| 2022-03-14 12:30:00 | AAPL | Stock | 151.95 | 152.03 | 150.96 | 150.98 | 5592595.0 |
| 2022-03-14 13:00:00 | AAPL | Stock | 150.9841 | 151.05 | 150.5 | 150.8003 | 5236825.0 |
| 2022-03-14 13:30:00 | AAPL | Stock | 150.8 | 151.44 | 150.44 | 151.0021 | 4937638.0 |
| 2022-03-14 14:00:00 | AAPL | Stock | 150.99 | 151.3 | 150.4 | 150.6783 | 4888502.0 |
| 2022-03-14 14:30:00 | AAPL | Stock | 150.675 | 151.35 | 150.58 | 151.1401 | 4864209.0 |
| 2022-03-14 15:00:00 | AAPL | Stock | 151.14 | 151.73 | 150.92 | 151.21 | 4974933.0 |
| 2022-03-14 15:30:00 | AAPL | Stock | 151.2 | 151.28 | 150.1 | 150.64 | 10048162.0 |
| 2022-03-14 16:00:00 | AAPL | Stock | 150.64 | 150.9899 | 150.17 | 150.74 | 10217216.0 |
| 2022-03-14 16:30:00 | AAPL | Stock | 150.77 | 150.84 | 150.62 | 150.84 | 135735.0 |
| 2022-03-14 17:00:00 | AAPL | Stock | 150.8001 | 150.84 | 150.22 | 150.22 | 79393.0 |
| 2022-03-14 17:30:00 | AAPL | Stock | 150.25 | 150.5 | 150.21 | 150.47 | 45549.0 |
| 2022-03-14 18:00:00 | AAPL | Stock | 150.43 | 150.61 | 150.27 | 150.27 | 42164.0 |
| 2022-03-14 18:30:00 | AAPL | Stock | 150.28 | 151.0 | 150.2699 | 150.65 | 64297.0 |
| 2022-03-14 19:00:00 | AAPL | Stock | 150.68 | 150.69 | 150.45 | 150.52 | 27494.0 |
| 2022-03-14 19:30:00 | AAPL | Stock | 150.5001 | 151.0 | 150.5 | 150.9 | 57413.0 |
| 2022-03-14 04:00:00 | MSFT | Stock | 280.78 | 282.34 | 280.4 | 280.97 | 8250.0 |
| 2022-03-14 04:30:00 | MSFT | Stock | 280.5 | 281.68 | 280.5 | 281.28 | 2056.0 |
| 2022-03-14 05:00:00 | MSFT | Stock | 281.55 | 281.98 | 280.43 | 281.0 | 4350.0 |
| 2022-03-14 05:30:00 | MSFT | Stock | 281.19 | 283.5 | 281.19 | 283.2 | 11772.0 |
| 2022-03-14 06:00:00 | MSFT | Stock | 282.89 | 283.32 | 281.73 | 281.73 | 1648.0 |
| 2022-03-14 06:30:00 | MSFT | Stock | 282.4 | 282.59 | 281.91 | 282.23 | 1634.0 |
| 2022-03-14 07:00:00 | MSFT | Stock | 282.06 | 282.21 | 279.75 | 280.08 | 26244.0 |
| 2022-03-14 07:30:00 | MSFT | Stock | 280.0 | 281.0 | 279.34 | 279.53 | 26603.0 |
| 2022-03-14 08:00:00 | MSFT | Stock | 281.8499 | 282.39 | 279.5 | 281.0 | 27735.0 |
| 2022-03-14 08:30:00 | MSFT | Stock | 280.85 | 282.5 | 280.85 | 282.4 | 15359.0 |
| 2022-03-14 09:00:00 | MSFT | Stock | 282.388 | 282.388 | 280.09 | 280.09 | 40421.0 |
| 2022-03-14 09:30:00 | MSFT | Stock | 280.24 | 284.77 | 280.01 | 283.035 | 3116431.0 |
| 2022-03-14 10:00:00 | MSFT | Stock | 283.03 | 285.3992 | 282.0 | 284.3292 | 1513201.0 |
| 2022-03-14 10:30:00 | MSFT | Stock | 284.34 | 285.02 | 283.275 | 284.415 | 1063366.0 |
| 2022-03-14 11:00:00 | MSFT | Stock | 284.43 | 284.55 | 281.71 | 281.915 | 1020139.0 |
| 2022-03-14 11:30:00 | MSFT | Stock | 281.93 | 282.52 | 281.68 | 282.15 | 1043229.0 |
| 2022-03-14 12:00:00 | MSFT | Stock | 282.07 | 282.07 | 280.07 | 280.3 | 1069269.0 |
| 2022-03-14 12:30:00 | MSFT | Stock | 280.24 | 280.54 | 278.68 | 279.085 | 956821.0 |
> showing 50 of 111,228 rows — these rows as CSV