PREVIEW / stock_30min / 2022-01-24
file: by_date/stock_30min/2022/2022-01-24.parquet size: 2.4 MB rows: 120,619 symbols: 2,718
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-24 04:00:00 | AAPL | Stock | 162.27 | 163.17 | 162.27 | 162.7 | 26212.0 |
| 2022-01-24 04:30:00 | AAPL | Stock | 162.79 | 162.99 | 162.35 | 162.52 | 26532.0 |
| 2022-01-24 05:00:00 | AAPL | Stock | 162.33 | 162.33 | 160.5 | 160.72 | 54453.0 |
| 2022-01-24 05:30:00 | AAPL | Stock | 160.8 | 161.49 | 160.12 | 161.4 | 105762.0 |
| 2022-01-24 06:00:00 | AAPL | Stock | 161.36 | 162.25 | 161.02 | 161.02 | 44398.0 |
| 2022-01-24 06:30:00 | AAPL | Stock | 160.96 | 161.85 | 160.7 | 161.71 | 28720.0 |
| 2022-01-24 07:00:00 | AAPL | Stock | 161.62 | 162.11 | 160.43 | 160.7 | 169176.0 |
| 2022-01-24 07:30:00 | AAPL | Stock | 160.6 | 160.84 | 160.01 | 160.27 | 167037.0 |
| 2022-01-24 08:00:00 | AAPL | Stock | 160.5201 | 161.7 | 159.48 | 159.48 | 803070.0 |
| 2022-01-24 08:30:00 | AAPL | Stock | 159.46 | 160.03 | 158.9 | 159.4001 | 691401.0 |
| 2022-01-24 09:00:00 | AAPL | Stock | 159.37 | 160.62 | 158.5 | 160.05 | 1285439.0 |
| 2022-01-24 09:30:00 | AAPL | Stock | 160.04 | 161.08 | 159.1 | 159.28 | 17513399.0 |
| 2022-01-24 10:00:00 | AAPL | Stock | 159.29 | 160.1303 | 158.07 | 158.9 | 11020093.0 |
| 2022-01-24 10:30:00 | AAPL | Stock | 158.9003 | 159.4 | 157.64 | 158.47 | 8432625.0 |
| 2022-01-24 11:00:00 | AAPL | Stock | 158.46 | 158.72 | 157.58 | 158.35 | 6983284.0 |
| 2022-01-24 11:30:00 | AAPL | Stock | 158.36 | 158.5 | 156.38 | 157.2 | 8996630.0 |
| 2022-01-24 12:00:00 | AAPL | Stock | 157.19 | 157.2586 | 154.7 | 155.65 | 10020928.0 |
| 2022-01-24 12:30:00 | AAPL | Stock | 155.64 | 157.42 | 155.27 | 156.95 | 7617248.0 |
| 2022-01-24 13:00:00 | AAPL | Stock | 156.95 | 158.3399 | 156.78 | 157.03 | 7509800.0 |
| 2022-01-24 13:30:00 | AAPL | Stock | 157.031 | 158.89 | 156.96 | 158.83 | 5772644.0 |
| 2022-01-24 14:00:00 | AAPL | Stock | 158.83 | 159.58 | 156.98 | 157.2 | 7438870.0 |
| 2022-01-24 14:30:00 | AAPL | Stock | 157.19 | 157.96 | 156.02 | 157.84 | 6202640.0 |
| 2022-01-24 15:00:00 | AAPL | Stock | 157.84 | 159.17 | 157.39 | 158.5 | 6313250.0 |
| 2022-01-24 15:30:00 | AAPL | Stock | 158.5 | 162.3 | 158.03 | 162.19 | 12750726.0 |
| 2022-01-24 16:00:00 | AAPL | Stock | 162.25 | 162.25 | 160.81 | 161.41 | 15589509.0 |
| 2022-01-24 16:30:00 | AAPL | Stock | 161.4 | 161.79 | 161.3 | 161.73 | 88944.0 |
| 2022-01-24 17:00:00 | AAPL | Stock | 161.75 | 161.79 | 161.57 | 161.69 | 21219.0 |
| 2022-01-24 17:30:00 | AAPL | Stock | 161.65 | 161.65 | 160.98 | 161.44 | 43514.0 |
| 2022-01-24 18:00:00 | AAPL | Stock | 161.4399 | 161.4399 | 160.87 | 160.91 | 38310.0 |
| 2022-01-24 18:30:00 | AAPL | Stock | 160.81 | 161.13 | 160.52 | 161.07 | 52653.0 |
| 2022-01-24 19:00:00 | AAPL | Stock | 161.13 | 161.25 | 160.52 | 160.6 | 26339.0 |
| 2022-01-24 19:30:00 | AAPL | Stock | 160.65 | 161.62 | 159.32 | 159.75 | 174560.0 |
| 2022-01-24 04:00:00 | MSFT | Stock | 297.01 | 298.34 | 297.01 | 297.77 | 12310.0 |
| 2022-01-24 04:30:00 | MSFT | Stock | 297.75 | 298.61 | 296.91 | 297.58 | 10917.0 |
| 2022-01-24 05:00:00 | MSFT | Stock | 297.27 | 297.49 | 294.66 | 294.9 | 22994.0 |
| 2022-01-24 05:30:00 | MSFT | Stock | 295.13 | 296.12 | 294.52 | 295.24 | 28863.0 |
| 2022-01-24 06:00:00 | MSFT | Stock | 295.1 | 297.18 | 295.03 | 296.33 | 25144.0 |
| 2022-01-24 06:30:00 | MSFT | Stock | 296.0 | 297.0 | 295.71 | 296.92 | 9963.0 |
| 2022-01-24 07:00:00 | MSFT | Stock | 296.77 | 297.39 | 295.16 | 295.99 | 45832.0 |
| 2022-01-24 07:30:00 | MSFT | Stock | 295.99 | 296.33 | 295.13 | 295.43 | 36634.0 |
| 2022-01-24 08:00:00 | MSFT | Stock | 296.0198 | 297.5 | 293.35 | 294.93 | 121189.0 |
| 2022-01-24 08:30:00 | MSFT | Stock | 294.96 | 295.0 | 292.9 | 292.9 | 110242.0 |
| 2022-01-24 09:00:00 | MSFT | Stock | 292.82 | 294.0 | 291.66 | 292.2 | 194200.0 |
| 2022-01-24 09:30:00 | MSFT | Stock | 292.2 | 292.8 | 289.12 | 290.47 | 7054918.0 |
| 2022-01-24 10:00:00 | MSFT | Stock | 290.46 | 292.25 | 286.0 | 287.37 | 4200316.0 |
| 2022-01-24 10:30:00 | MSFT | Stock | 287.3 | 288.83 | 284.56 | 286.29 | 4040275.0 |
| 2022-01-24 11:00:00 | MSFT | Stock | 286.285 | 286.48 | 283.59 | 284.67 | 3187176.0 |
| 2022-01-24 11:30:00 | MSFT | Stock | 284.635 | 285.05 | 280.0 | 282.0 | 4426821.0 |
| 2022-01-24 12:00:00 | MSFT | Stock | 282.025 | 282.14 | 276.05 | 280.23 | 4170181.0 |
| 2022-01-24 12:30:00 | MSFT | Stock | 280.17 | 285.98 | 279.87 | 284.78 | 3711304.0 |
> showing 50 of 120,619 rows — these rows as CSV