PREVIEW / stock_30min / 2005-10-04
file: by_date/stock_30min/2005/2005-10-04.parquet size: 858 KB rows: 46,327 symbols: 2,089
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-04 08:00:00 | AAPL | Stock | 1.9482 | 1.96 | 1.9482 | 1.9518 | 461972.0 |
| 2005-10-04 08:30:00 | AAPL | Stock | 1.9536 | 1.9625 | 1.9521 | 1.9621 | 953540.0 |
| 2005-10-04 09:00:00 | AAPL | Stock | 1.9621 | 1.9639 | 1.9589 | 1.9604 | 779660.0 |
| 2005-10-04 09:30:00 | AAPL | Stock | 1.9625 | 1.9643 | 1.9496 | 1.9554 | 58859332.0 |
| 2005-10-04 10:00:00 | AAPL | Stock | 1.9554 | 1.9764 | 1.9554 | 1.975 | 68960696.0 |
| 2005-10-04 10:30:00 | AAPL | Stock | 1.9754 | 1.9768 | 1.9686 | 1.9707 | 38159072.0 |
| 2005-10-04 11:00:00 | AAPL | Stock | 1.9707 | 1.9725 | 1.9579 | 1.9696 | 44988160.0 |
| 2005-10-04 11:30:00 | AAPL | Stock | 1.9693 | 1.9729 | 1.9679 | 1.9718 | 23918580.0 |
| 2005-10-04 12:00:00 | AAPL | Stock | 1.9718 | 1.9732 | 1.9693 | 1.9707 | 12375944.0 |
| 2005-10-04 12:30:00 | AAPL | Stock | 1.9707 | 1.9711 | 1.9639 | 1.9646 | 25143916.0 |
| 2005-10-04 13:00:00 | AAPL | Stock | 1.9654 | 1.9675 | 1.9611 | 1.9621 | 17973676.0 |
| 2005-10-04 13:30:00 | AAPL | Stock | 1.9621 | 1.9636 | 1.9418 | 1.9457 | 52137540.0 |
| 2005-10-04 14:00:00 | AAPL | Stock | 1.9454 | 1.9514 | 1.935 | 1.9364 | 41725712.0 |
| 2005-10-04 14:30:00 | AAPL | Stock | 1.9361 | 1.9624 | 1.9271 | 1.9271 | 43331204.0 |
| 2005-10-04 15:00:00 | AAPL | Stock | 1.9271 | 1.9321 | 1.9214 | 1.9254 | 43322804.0 |
| 2005-10-04 15:30:00 | AAPL | Stock | 1.9254 | 1.9307 | 1.9157 | 1.9175 | 53298084.0 |
| 2005-10-04 16:00:00 | AAPL | Stock | 1.9171 | 1.9228 | 1.9146 | 1.9179 | 1513092.0 |
| 2005-10-04 16:30:00 | AAPL | Stock | 1.9179 | 1.9258 | 1.9164 | 1.9189 | 177716.0 |
| 2005-10-04 17:00:00 | AAPL | Stock | 1.9193 | 1.9196 | 1.9179 | 1.9196 | 6933696.0 |
| 2005-10-04 17:30:00 | AAPL | Stock | 1.9196 | 1.9196 | 1.9164 | 1.9164 | 136920.0 |
| 2005-10-04 18:00:00 | AAPL | Stock | 1.9193 | 1.9204 | 1.9164 | 1.9196 | 2020256.0 |
| 2005-10-04 07:00:00 | MSFT | Stock | 25.48 | 25.49 | 25.48 | 25.49 | 3650.0 |
| 2005-10-04 07:30:00 | MSFT | Stock | 25.49 | 25.49 | 25.49 | 25.49 | 9950.0 |
| 2005-10-04 08:00:00 | MSFT | Stock | 25.45 | 25.48 | 25.43 | 25.43 | 20250.0 |
| 2005-10-04 08:30:00 | MSFT | Stock | 25.46 | 25.46 | 25.4 | 25.44 | 141150.0 |
| 2005-10-04 09:00:00 | MSFT | Stock | 25.42 | 25.43 | 25.36 | 25.36 | 138811.0 |
| 2005-10-04 09:30:00 | MSFT | Stock | 25.36 | 25.39 | 24.75 | 24.96 | 30440887.0 |
| 2005-10-04 10:00:00 | MSFT | Stock | 24.951 | 25.03 | 24.81 | 24.88 | 18802530.0 |
| 2005-10-04 10:30:00 | MSFT | Stock | 24.88 | 25.0 | 24.85 | 24.97 | 8689897.0 |
| 2005-10-04 11:00:00 | MSFT | Stock | 24.98 | 25.01 | 24.9 | 24.94 | 7830753.0 |
| 2005-10-04 11:30:00 | MSFT | Stock | 24.94 | 25.06 | 24.94 | 25.02 | 9507790.0 |
| 2005-10-04 12:00:00 | MSFT | Stock | 25.01 | 25.04 | 24.98 | 25.03 | 5357918.0 |
| 2005-10-04 12:30:00 | MSFT | Stock | 25.02 | 25.19 | 24.94 | 25.17 | 13577985.0 |
| 2005-10-04 13:00:00 | MSFT | Stock | 25.17 | 25.24 | 25.0 | 25.11 | 12329393.0 |
| 2005-10-04 13:30:00 | MSFT | Stock | 25.11 | 25.17 | 25.04 | 25.07 | 7993097.0 |
| 2005-10-04 14:00:00 | MSFT | Stock | 25.07 | 25.08 | 24.96 | 24.97 | 7736107.0 |
| 2005-10-04 14:30:00 | MSFT | Stock | 24.96 | 25.01 | 24.86 | 24.87 | 6160012.0 |
| 2005-10-04 15:00:00 | MSFT | Stock | 24.88 | 24.96 | 24.87 | 24.96 | 7322607.0 |
| 2005-10-04 15:30:00 | MSFT | Stock | 24.96 | 25.01 | 24.94 | 24.97 | 12525944.0 |
| 2005-10-04 16:00:00 | MSFT | Stock | 24.97 | 25.0 | 24.94 | 24.95 | 393536.0 |
| 2005-10-04 16:30:00 | MSFT | Stock | 24.95 | 24.97 | 24.94 | 24.94 | 100418.0 |
| 2005-10-04 17:00:00 | MSFT | Stock | 24.96 | 24.98 | 24.95 | 24.96 | 1096213.0 |
| 2005-10-04 17:30:00 | MSFT | Stock | 24.98 | 24.99 | 24.97 | 24.98 | 16743.0 |
| 2005-10-04 18:00:00 | MSFT | Stock | 24.95 | 24.97 | 24.95 | 24.97 | 1500.0 |
| 2005-10-04 08:30:00 | NVDA | Stock | 0.2954 | 0.2954 | 0.2949 | 0.2949 | 192000.0 |
| 2005-10-04 09:00:00 | NVDA | Stock | 0.2949 | 0.295 | 0.2924 | 0.2925 | 1308000.0 |
| 2005-10-04 09:30:00 | NVDA | Stock | 0.2947 | 0.2977 | 0.2927 | 0.2956 | 118826040.0 |
| 2005-10-04 10:00:00 | NVDA | Stock | 0.2954 | 0.2996 | 0.2952 | 0.2977 | 76790400.0 |
| 2005-10-04 10:30:00 | NVDA | Stock | 0.2977 | 0.2979 | 0.2959 | 0.2971 | 29575680.0 |
| 2005-10-04 11:00:00 | NVDA | Stock | 0.2971 | 0.2976 | 0.2955 | 0.2964 | 28830120.0 |
> showing 50 of 46,327 rows — these rows as CSV