PREVIEW / stock_30min / 2005-10-19
file: by_date/stock_30min/2005/2005-10-19.parquet size: 880 KB rows: 46,638 symbols: 2,099
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-19 07:30:00 | AAPL | Stock | 1.8461 | 1.8464 | 1.8461 | 1.8464 | 43680.0 |
| 2005-10-19 08:00:00 | AAPL | Stock | 1.845 | 1.8571 | 1.8357 | 1.8393 | 1908452.0 |
| 2005-10-19 08:30:00 | AAPL | Stock | 1.8393 | 1.8521 | 1.8393 | 1.8514 | 1117788.0 |
| 2005-10-19 09:00:00 | AAPL | Stock | 1.8518 | 1.8625 | 1.8496 | 1.8596 | 1359064.0 |
| 2005-10-19 09:30:00 | AAPL | Stock | 1.8596 | 1.8632 | 1.8375 | 1.8518 | 64197168.0 |
| 2005-10-19 10:00:00 | AAPL | Stock | 1.8518 | 1.8661 | 1.8457 | 1.8457 | 50852648.0 |
| 2005-10-19 10:30:00 | AAPL | Stock | 1.8461 | 1.8639 | 1.8461 | 1.8557 | 41576668.0 |
| 2005-10-19 11:00:00 | AAPL | Stock | 1.8554 | 1.8586 | 1.8339 | 1.8346 | 34677160.0 |
| 2005-10-19 11:30:00 | AAPL | Stock | 1.8346 | 1.8436 | 1.8289 | 1.8314 | 36118096.0 |
| 2005-10-19 12:00:00 | AAPL | Stock | 1.8318 | 1.8475 | 1.8314 | 1.8461 | 26907972.0 |
| 2005-10-19 12:30:00 | AAPL | Stock | 1.8454 | 1.8504 | 1.8414 | 1.8443 | 30357012.0 |
| 2005-10-19 13:00:00 | AAPL | Stock | 1.8439 | 1.86 | 1.8382 | 1.8579 | 37694020.0 |
| 2005-10-19 13:30:00 | AAPL | Stock | 1.8579 | 1.9043 | 1.8579 | 1.8975 | 125012524.0 |
| 2005-10-19 14:00:00 | AAPL | Stock | 1.8975 | 1.9246 | 1.8929 | 1.9229 | 131548816.0 |
| 2005-10-19 14:30:00 | AAPL | Stock | 1.9232 | 1.9264 | 1.9121 | 1.9204 | 88613896.0 |
| 2005-10-19 15:00:00 | AAPL | Stock | 1.92 | 1.9457 | 1.9171 | 1.9425 | 137523092.0 |
| 2005-10-19 15:30:00 | AAPL | Stock | 1.9425 | 1.9629 | 1.9343 | 1.9596 | 176206660.0 |
| 2005-10-19 16:00:00 | AAPL | Stock | 1.9596 | 1.9907 | 1.9564 | 1.9661 | 7958132.0 |
| 2005-10-19 16:30:00 | AAPL | Stock | 1.9671 | 1.9696 | 1.9607 | 1.9625 | 1431416.0 |
| 2005-10-19 17:00:00 | AAPL | Stock | 1.9607 | 1.9621 | 1.9589 | 1.9604 | 1974140.0 |
| 2005-10-19 17:30:00 | AAPL | Stock | 1.9614 | 1.9636 | 1.9593 | 1.9636 | 413952.0 |
| 2005-10-19 18:00:00 | AAPL | Stock | 1.9625 | 1.9625 | 1.9579 | 1.9625 | 385924.0 |
| 2005-10-19 07:30:00 | MSFT | Stock | 24.41 | 24.41 | 24.41 | 24.41 | 5000.0 |
| 2005-10-19 08:00:00 | MSFT | Stock | 24.43 | 24.48 | 24.43 | 24.45 | 12650.0 |
| 2005-10-19 08:30:00 | MSFT | Stock | 24.47 | 24.57 | 24.45 | 24.48 | 61049.0 |
| 2005-10-19 09:00:00 | MSFT | Stock | 24.48 | 24.55 | 24.47 | 24.55 | 105206.0 |
| 2005-10-19 09:30:00 | MSFT | Stock | 24.56 | 24.76 | 24.5 | 24.74 | 7565883.0 |
| 2005-10-19 10:00:00 | MSFT | Stock | 24.74 | 24.851 | 24.73 | 24.85 | 5529651.0 |
| 2005-10-19 10:30:00 | MSFT | Stock | 24.85 | 24.94 | 24.83 | 24.86 | 6240478.0 |
| 2005-10-19 11:00:00 | MSFT | Stock | 24.85 | 24.93 | 24.8 | 24.86 | 4554030.0 |
| 2005-10-19 11:30:00 | MSFT | Stock | 24.852 | 24.94 | 24.8 | 24.83 | 4422888.0 |
| 2005-10-19 12:00:00 | MSFT | Stock | 24.83 | 24.9 | 24.81 | 24.89 | 2608275.0 |
| 2005-10-19 12:30:00 | MSFT | Stock | 24.89 | 24.93 | 24.81 | 24.84 | 3171471.0 |
| 2005-10-19 13:00:00 | MSFT | Stock | 24.85 | 24.87 | 24.8 | 24.83 | 2829368.0 |
| 2005-10-19 13:30:00 | MSFT | Stock | 24.83 | 24.86 | 24.8 | 24.81 | 1966948.0 |
| 2005-10-19 14:00:00 | MSFT | Stock | 24.8 | 24.95 | 24.78 | 24.95 | 5797474.0 |
| 2005-10-19 14:30:00 | MSFT | Stock | 24.95 | 24.98 | 24.88 | 24.95 | 4525850.0 |
| 2005-10-19 15:00:00 | MSFT | Stock | 24.95 | 25.0 | 24.94 | 24.971 | 5114436.0 |
| 2005-10-19 15:30:00 | MSFT | Stock | 24.98 | 25.09 | 24.93 | 25.07 | 9584169.0 |
| 2005-10-19 16:00:00 | MSFT | Stock | 25.08 | 25.1 | 25.04 | 25.08 | 811810.0 |
| 2005-10-19 16:30:00 | MSFT | Stock | 25.08 | 25.09 | 25.06 | 25.07 | 1900.0 |
| 2005-10-19 17:00:00 | MSFT | Stock | 25.06 | 25.08 | 25.06 | 25.06 | 18100.0 |
| 2005-10-19 17:30:00 | MSFT | Stock | 25.09 | 25.09 | 25.07 | 25.08 | 14435.0 |
| 2005-10-19 18:00:00 | MSFT | Stock | 25.1 | 25.1 | 24.865 | 25.06 | 32180.0 |
| 2005-10-19 08:00:00 | NVDA | Stock | 0.2625 | 0.2625 | 0.2625 | 0.2625 | 48000.0 |
| 2005-10-19 08:30:00 | NVDA | Stock | 0.2633 | 0.2633 | 0.2612 | 0.2612 | 180000.0 |
| 2005-10-19 09:00:00 | NVDA | Stock | 0.2624 | 0.2625 | 0.2621 | 0.2623 | 384000.0 |
| 2005-10-19 09:30:00 | NVDA | Stock | 0.2617 | 0.2625 | 0.2542 | 0.2575 | 74714040.0 |
| 2005-10-19 10:00:00 | NVDA | Stock | 0.2575 | 0.2583 | 0.2554 | 0.2557 | 56349960.0 |
| 2005-10-19 10:30:00 | NVDA | Stock | 0.2557 | 0.258 | 0.2557 | 0.2564 | 31978560.0 |
> showing 50 of 46,638 rows — these rows as CSV