PREVIEW / stock_30min / 2003-10-31
file: by_date/stock_30min/2003/2003-10-31.parquet size: 710 KB rows: 37,869 symbols: 1,657
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-31 08:00:00 | AAPL | Stock | 0.4125 | 0.4125 | 0.4125 | 0.4125 | 28000.0 |
| 2003-10-31 09:00:00 | AAPL | Stock | 0.4139 | 0.4163 | 0.4125 | 0.4155 | 1691200.0 |
| 2003-10-31 09:30:00 | AAPL | Stock | 0.4161 | 0.417 | 0.4125 | 0.415 | 12920824.0 |
| 2003-10-31 10:00:00 | AAPL | Stock | 0.415 | 0.415 | 0.4075 | 0.4084 | 14931112.0 |
| 2003-10-31 10:30:00 | AAPL | Stock | 0.4081 | 0.412 | 0.4068 | 0.4107 | 16137632.0 |
| 2003-10-31 11:00:00 | AAPL | Stock | 0.4107 | 0.4113 | 0.4096 | 0.4107 | 9834048.0 |
| 2003-10-31 11:30:00 | AAPL | Stock | 0.4104 | 0.4111 | 0.4089 | 0.4107 | 3537912.0 |
| 2003-10-31 12:00:00 | AAPL | Stock | 0.4107 | 0.4118 | 0.4107 | 0.4109 | 14931616.0 |
| 2003-10-31 12:30:00 | AAPL | Stock | 0.4111 | 0.4114 | 0.4103 | 0.4107 | 6288240.0 |
| 2003-10-31 13:00:00 | AAPL | Stock | 0.4107 | 0.4116 | 0.4105 | 0.4113 | 7359408.0 |
| 2003-10-31 13:30:00 | AAPL | Stock | 0.4111 | 0.4113 | 0.4095 | 0.4098 | 5497184.0 |
| 2003-10-31 14:00:00 | AAPL | Stock | 0.4102 | 0.4116 | 0.4102 | 0.4114 | 10735592.0 |
| 2003-10-31 14:30:00 | AAPL | Stock | 0.4114 | 0.4116 | 0.4093 | 0.4109 | 27010592.0 |
| 2003-10-31 15:00:00 | AAPL | Stock | 0.4109 | 0.4116 | 0.4095 | 0.41 | 12995752.0 |
| 2003-10-31 15:30:00 | AAPL | Stock | 0.41 | 0.4109 | 0.4079 | 0.4088 | 12706680.0 |
| 2003-10-31 16:00:00 | AAPL | Stock | 0.4086 | 0.4091 | 0.4054 | 0.4088 | 2668288.0 |
| 2003-10-31 16:30:00 | AAPL | Stock | 0.4088 | 0.4088 | 0.4078 | 0.4088 | 655200.0 |
| 2003-10-31 17:00:00 | AAPL | Stock | 0.4098 | 0.4098 | 0.4098 | 0.4098 | 67200.0 |
| 2003-10-31 18:00:00 | AAPL | Stock | 0.4075 | 0.4075 | 0.4054 | 0.4054 | 128800.0 |
| 2003-10-31 08:00:00 | MSFT | Stock | 26.33 | 26.43 | 26.11 | 26.38 | 118130.0 |
| 2003-10-31 08:30:00 | MSFT | Stock | 26.37 | 26.4 | 26.26 | 26.4 | 100771.0 |
| 2003-10-31 09:00:00 | MSFT | Stock | 26.39 | 26.4 | 26.35 | 26.37 | 335073.0 |
| 2003-10-31 09:30:00 | MSFT | Stock | 26.37 | 26.4 | 26.15 | 26.29 | 11217284.0 |
| 2003-10-31 10:00:00 | MSFT | Stock | 26.29 | 26.38 | 26.18 | 26.2 | 7407942.0 |
| 2003-10-31 10:30:00 | MSFT | Stock | 26.2 | 26.27 | 26.11 | 26.17 | 6046295.0 |
| 2003-10-31 11:00:00 | MSFT | Stock | 26.16 | 26.2 | 26.12 | 26.15 | 3940709.0 |
| 2003-10-31 11:30:00 | MSFT | Stock | 26.15 | 26.2 | 26.11 | 26.19 | 3730735.0 |
| 2003-10-31 12:00:00 | MSFT | Stock | 26.2 | 26.24 | 26.15 | 26.19 | 3656923.0 |
| 2003-10-31 12:30:00 | MSFT | Stock | 26.188 | 26.19 | 26.13 | 26.15 | 1635188.0 |
| 2003-10-31 13:00:00 | MSFT | Stock | 26.15 | 26.24 | 26.149 | 26.19 | 2857091.0 |
| 2003-10-31 13:30:00 | MSFT | Stock | 26.188 | 26.201 | 26.128 | 26.14 | 2141621.0 |
| 2003-10-31 14:00:00 | MSFT | Stock | 26.13 | 26.21 | 26.13 | 26.188 | 2718768.0 |
| 2003-10-31 14:30:00 | MSFT | Stock | 26.19 | 26.21 | 26.12 | 26.14 | 3283714.0 |
| 2003-10-31 15:00:00 | MSFT | Stock | 26.15 | 26.27 | 26.14 | 26.26 | 3827039.0 |
| 2003-10-31 15:30:00 | MSFT | Stock | 26.27 | 26.29 | 26.12 | 26.13 | 6601332.0 |
| 2003-10-31 16:00:00 | MSFT | Stock | 26.13 | 26.3 | 26.13 | 26.15 | 1496669.0 |
| 2003-10-31 16:30:00 | MSFT | Stock | 26.22 | 26.24 | 26.15 | 26.2 | 217200.0 |
| 2003-10-31 17:00:00 | MSFT | Stock | 26.18 | 26.23 | 26.05 | 26.18 | 23100.0 |
| 2003-10-31 17:30:00 | MSFT | Stock | 26.18 | 26.2 | 26.17 | 26.19 | 9500.0 |
| 2003-10-31 18:00:00 | MSFT | Stock | 26.18 | 26.18 | 26.15 | 26.17 | 23900.0 |
| 2003-10-31 08:00:00 | NVDA | Stock | 0.15 | 0.15 | 0.15 | 0.15 | 288000.0 |
| 2003-10-31 08:30:00 | NVDA | Stock | 0.15 | 0.1501 | 0.15 | 0.1501 | 180000.0 |
| 2003-10-31 09:00:00 | NVDA | Stock | 0.1501 | 0.1518 | 0.1501 | 0.151 | 1748760.0 |
| 2003-10-31 09:30:00 | NVDA | Stock | 0.1508 | 0.1521 | 0.1492 | 0.1502 | 65598000.0 |
| 2003-10-31 10:00:00 | NVDA | Stock | 0.1502 | 0.1502 | 0.1476 | 0.1479 | 62068560.0 |
| 2003-10-31 10:30:00 | NVDA | Stock | 0.1479 | 0.148 | 0.1467 | 0.1475 | 54029520.0 |
| 2003-10-31 11:00:00 | NVDA | Stock | 0.1473 | 0.1474 | 0.1454 | 0.1461 | 58398360.0 |
| 2003-10-31 11:30:00 | NVDA | Stock | 0.1461 | 0.1462 | 0.145 | 0.146 | 44064480.0 |
| 2003-10-31 12:00:00 | NVDA | Stock | 0.146 | 0.1472 | 0.1459 | 0.1468 | 42300360.0 |
| 2003-10-31 12:30:00 | NVDA | Stock | 0.1468 | 0.1468 | 0.1456 | 0.1461 | 19242720.0 |
> showing 50 of 37,869 rows — these rows as CSV