PREVIEW / stock_30min / 2005-11-08
file: by_date/stock_30min/2005/2005-11-08.parquet size: 850 KB rows: 45,676 symbols: 2,110
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-11-08 07:00:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1536 | 2.1536 | 5600.0 |
| 2005-11-08 07:30:00 | AAPL | Stock | 2.1518 | 2.1518 | 2.1511 | 2.1511 | 16800.0 |
| 2005-11-08 08:00:00 | AAPL | Stock | 2.1536 | 2.1536 | 2.1454 | 2.1454 | 586460.0 |
| 2005-11-08 08:30:00 | AAPL | Stock | 2.1436 | 2.1446 | 2.1386 | 2.1393 | 867020.0 |
| 2005-11-08 09:00:00 | AAPL | Stock | 2.1393 | 2.1418 | 2.1361 | 2.1379 | 2044924.0 |
| 2005-11-08 09:30:00 | AAPL | Stock | 2.1411 | 2.1425 | 2.1107 | 2.1189 | 96057612.0 |
| 2005-11-08 10:00:00 | AAPL | Stock | 2.1193 | 2.1243 | 2.1125 | 2.1214 | 44737812.0 |
| 2005-11-08 10:30:00 | AAPL | Stock | 2.1214 | 2.1314 | 2.1179 | 2.1246 | 37272116.0 |
| 2005-11-08 11:00:00 | AAPL | Stock | 2.1246 | 2.1311 | 2.1196 | 2.1271 | 28573160.0 |
| 2005-11-08 11:30:00 | AAPL | Stock | 2.1268 | 2.1496 | 2.1236 | 2.1464 | 43952076.0 |
| 2005-11-08 12:00:00 | AAPL | Stock | 2.1457 | 2.1561 | 2.1436 | 2.1554 | 40722892.0 |
| 2005-11-08 12:30:00 | AAPL | Stock | 2.1553 | 2.1564 | 2.14 | 2.1464 | 34466852.0 |
| 2005-11-08 13:00:00 | AAPL | Stock | 2.1464 | 2.1486 | 2.1339 | 2.1418 | 29844276.0 |
| 2005-11-08 13:30:00 | AAPL | Stock | 2.1417 | 2.1443 | 2.1304 | 2.1325 | 18562572.0 |
| 2005-11-08 14:00:00 | AAPL | Stock | 2.1329 | 2.1421 | 2.1329 | 2.1375 | 16184476.0 |
| 2005-11-08 14:30:00 | AAPL | Stock | 2.1379 | 2.1389 | 2.1332 | 2.1379 | 13261388.0 |
| 2005-11-08 15:00:00 | AAPL | Stock | 2.1375 | 2.1457 | 2.1361 | 2.1414 | 21795088.0 |
| 2005-11-08 15:30:00 | AAPL | Stock | 2.1411 | 2.1418 | 2.1264 | 2.1382 | 37304204.0 |
| 2005-11-08 16:00:00 | AAPL | Stock | 2.1368 | 2.1393 | 2.1361 | 2.1371 | 1133664.0 |
| 2005-11-08 16:30:00 | AAPL | Stock | 2.1375 | 2.1425 | 2.1375 | 2.1404 | 95956.0 |
| 2005-11-08 17:00:00 | AAPL | Stock | 2.1393 | 2.1407 | 2.1364 | 2.1364 | 39200.0 |
| 2005-11-08 17:30:00 | AAPL | Stock | 2.1393 | 2.1393 | 2.1393 | 2.1393 | 233324.0 |
| 2005-11-08 18:00:00 | AAPL | Stock | 2.1364 | 2.1393 | 2.1361 | 2.1368 | 78064.0 |
| 2005-11-08 07:00:00 | MSFT | Stock | 27.03 | 27.03 | 27.03 | 27.03 | 100.0 |
| 2005-11-08 08:00:00 | MSFT | Stock | 27.03 | 27.03 | 26.95 | 26.99 | 7173.0 |
| 2005-11-08 08:30:00 | MSFT | Stock | 26.98 | 27.01 | 26.96 | 27.01 | 61285.0 |
| 2005-11-08 09:00:00 | MSFT | Stock | 26.98 | 26.99 | 26.9 | 26.94 | 69735.0 |
| 2005-11-08 09:30:00 | MSFT | Stock | 26.935 | 26.97 | 26.77 | 26.82 | 8519792.0 |
| 2005-11-08 10:00:00 | MSFT | Stock | 26.82 | 27.04 | 26.81 | 27.03 | 7346358.0 |
| 2005-11-08 10:30:00 | MSFT | Stock | 27.02 | 27.18 | 26.96 | 27.01 | 5728027.0 |
| 2005-11-08 11:00:00 | MSFT | Stock | 27.01 | 27.15 | 27.01 | 27.119 | 4907428.0 |
| 2005-11-08 11:30:00 | MSFT | Stock | 27.11 | 27.18 | 27.05 | 27.15 | 4175535.0 |
| 2005-11-08 12:00:00 | MSFT | Stock | 27.15 | 27.15 | 27.069 | 27.08 | 2236020.0 |
| 2005-11-08 12:30:00 | MSFT | Stock | 27.08 | 27.15 | 27.08 | 27.14 | 2755413.0 |
| 2005-11-08 13:00:00 | MSFT | Stock | 27.14 | 27.15 | 27.04 | 27.09 | 1706643.0 |
| 2005-11-08 13:30:00 | MSFT | Stock | 27.08 | 27.1 | 26.97 | 27.041 | 2547047.0 |
| 2005-11-08 14:00:00 | MSFT | Stock | 27.05 | 27.12 | 27.03 | 27.07 | 2981912.0 |
| 2005-11-08 14:30:00 | MSFT | Stock | 27.07 | 27.11 | 27.03 | 27.05 | 3030835.0 |
| 2005-11-08 15:00:00 | MSFT | Stock | 27.05 | 27.13 | 27.05 | 27.09 | 4092126.0 |
| 2005-11-08 15:30:00 | MSFT | Stock | 27.1 | 27.11 | 27.02 | 27.05 | 8387043.0 |
| 2005-11-08 16:00:00 | MSFT | Stock | 27.04 | 27.07 | 27.03 | 27.06 | 204170.0 |
| 2005-11-08 16:30:00 | MSFT | Stock | 27.028 | 27.147 | 27.028 | 27.07 | 30772.0 |
| 2005-11-08 17:00:00 | MSFT | Stock | 27.075 | 27.075 | 27.04 | 27.04 | 2114.0 |
| 2005-11-08 17:30:00 | MSFT | Stock | 27.05 | 27.08 | 27.04 | 27.08 | 20840.0 |
| 2005-11-08 08:30:00 | NVDA | Stock | 0.2841 | 0.2841 | 0.2841 | 0.2841 | 36000.0 |
| 2005-11-08 09:00:00 | NVDA | Stock | 0.2839 | 0.2839 | 0.2839 | 0.2839 | 120000.0 |
| 2005-11-08 09:30:00 | NVDA | Stock | 0.2837 | 0.2839 | 0.2815 | 0.2817 | 43630560.0 |
| 2005-11-08 10:00:00 | NVDA | Stock | 0.2817 | 0.2825 | 0.2816 | 0.2817 | 22341960.0 |
| 2005-11-08 10:30:00 | NVDA | Stock | 0.2818 | 0.2821 | 0.2785 | 0.2802 | 54739800.0 |
| 2005-11-08 11:00:00 | NVDA | Stock | 0.2802 | 0.2808 | 0.2797 | 0.2797 | 50590440.0 |
> showing 50 of 45,676 rows — these rows as CSV