PREVIEW / stock_30min / 2003-10-24
file: by_date/stock_30min/2003/2003-10-24.parquet size: 714 KB rows: 37,601 symbols: 1,635
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-24 09:00:00 | AAPL | Stock | 0.4105 | 0.4105 | 0.4027 | 0.4027 | 599200.0 |
| 2003-10-24 09:30:00 | AAPL | Stock | 0.4023 | 0.408 | 0.3988 | 0.4063 | 28379400.0 |
| 2003-10-24 10:00:00 | AAPL | Stock | 0.4064 | 0.4066 | 0.4018 | 0.4023 | 14279888.0 |
| 2003-10-24 10:30:00 | AAPL | Stock | 0.4021 | 0.4025 | 0.4002 | 0.4025 | 14054992.0 |
| 2003-10-24 11:00:00 | AAPL | Stock | 0.4025 | 0.4034 | 0.4007 | 0.4009 | 7533960.0 |
| 2003-10-24 11:30:00 | AAPL | Stock | 0.4007 | 0.4009 | 0.3979 | 0.3991 | 15061536.0 |
| 2003-10-24 12:00:00 | AAPL | Stock | 0.399 | 0.3996 | 0.3984 | 0.3991 | 6242600.0 |
| 2003-10-24 12:30:00 | AAPL | Stock | 0.3988 | 0.3996 | 0.3978 | 0.3989 | 12707632.0 |
| 2003-10-24 13:00:00 | AAPL | Stock | 0.3991 | 0.4 | 0.3982 | 0.3986 | 6341496.0 |
| 2003-10-24 13:30:00 | AAPL | Stock | 0.3986 | 0.3991 | 0.397 | 0.3973 | 15456784.0 |
| 2003-10-24 14:00:00 | AAPL | Stock | 0.3973 | 0.4005 | 0.3971 | 0.4004 | 14957208.0 |
| 2003-10-24 14:30:00 | AAPL | Stock | 0.4004 | 0.4013 | 0.3986 | 0.3995 | 13776952.0 |
| 2003-10-24 15:00:00 | AAPL | Stock | 0.3991 | 0.4018 | 0.3989 | 0.4009 | 19143936.0 |
| 2003-10-24 15:30:00 | AAPL | Stock | 0.4009 | 0.4039 | 0.4004 | 0.4036 | 23914968.0 |
| 2003-10-24 16:00:00 | AAPL | Stock | 0.4036 | 0.4052 | 0.4017 | 0.4017 | 6031200.0 |
| 2003-10-24 16:30:00 | AAPL | Stock | 0.4036 | 0.4055 | 0.4036 | 0.4045 | 67200.0 |
| 2003-10-24 17:00:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.4036 | 0.4036 | 5600.0 |
| 2003-10-24 08:00:00 | MSFT | Stock | 27.56 | 28.91 | 27.19 | 27.42 | 2558109.0 |
| 2003-10-24 08:30:00 | MSFT | Stock | 27.42 | 28.91 | 27.2 | 27.33 | 2091174.0 |
| 2003-10-24 09:00:00 | MSFT | Stock | 27.33 | 28.9 | 27.23 | 27.28 | 4302660.0 |
| 2003-10-24 09:30:00 | MSFT | Stock | 27.27 | 27.37 | 26.83 | 27.08 | 36155280.0 |
| 2003-10-24 10:00:00 | MSFT | Stock | 27.08 | 27.14 | 27.01 | 27.089 | 15813107.0 |
| 2003-10-24 10:30:00 | MSFT | Stock | 27.099 | 27.12 | 27.01 | 27.09 | 10892348.0 |
| 2003-10-24 11:00:00 | MSFT | Stock | 27.08 | 27.101 | 26.99 | 27.0 | 9068772.0 |
| 2003-10-24 11:30:00 | MSFT | Stock | 27.01 | 27.01 | 26.86 | 26.89 | 10529010.0 |
| 2003-10-24 12:00:00 | MSFT | Stock | 26.89 | 26.94 | 26.72 | 26.77 | 12226374.0 |
| 2003-10-24 12:30:00 | MSFT | Stock | 26.77 | 26.85 | 26.67 | 26.73 | 7974961.0 |
| 2003-10-24 13:00:00 | MSFT | Stock | 26.73 | 26.8 | 26.68 | 26.77 | 8053022.0 |
| 2003-10-24 13:30:00 | MSFT | Stock | 26.77 | 26.78 | 26.52 | 26.55 | 8499604.0 |
| 2003-10-24 14:00:00 | MSFT | Stock | 26.55 | 26.61 | 26.49 | 26.6 | 21638855.0 |
| 2003-10-24 14:30:00 | MSFT | Stock | 26.6 | 26.62 | 26.52 | 26.55 | 9005119.0 |
| 2003-10-24 15:00:00 | MSFT | Stock | 26.541 | 26.73 | 26.42 | 26.59 | 14180510.0 |
| 2003-10-24 15:30:00 | MSFT | Stock | 26.59 | 26.69 | 26.548 | 26.62 | 18752136.0 |
| 2003-10-24 16:00:00 | MSFT | Stock | 26.62 | 26.69 | 26.58 | 26.65 | 1962337.0 |
| 2003-10-24 16:30:00 | MSFT | Stock | 26.65 | 26.9443 | 26.62 | 26.68 | 50410.0 |
| 2003-10-24 17:00:00 | MSFT | Stock | 26.68 | 27.0919 | 26.61 | 26.66 | 365910.0 |
| 2003-10-24 17:30:00 | MSFT | Stock | 26.66 | 26.66 | 26.63 | 26.64 | 24478.0 |
| 2003-10-24 18:00:00 | MSFT | Stock | 26.64 | 26.66 | 26.64 | 26.66 | 36757.0 |
| 2003-10-24 09:00:00 | NVDA | Stock | 0.1431 | 0.1431 | 0.141 | 0.141 | 1512000.0 |
| 2003-10-24 09:30:00 | NVDA | Stock | 0.1417 | 0.1438 | 0.1406 | 0.1435 | 47832600.0 |
| 2003-10-24 10:00:00 | NVDA | Stock | 0.1433 | 0.1435 | 0.1417 | 0.1427 | 22691040.0 |
| 2003-10-24 10:30:00 | NVDA | Stock | 0.1426 | 0.1427 | 0.1417 | 0.1426 | 19322040.0 |
| 2003-10-24 11:00:00 | NVDA | Stock | 0.1426 | 0.1434 | 0.1423 | 0.1425 | 34635120.0 |
| 2003-10-24 11:30:00 | NVDA | Stock | 0.1424 | 0.1424 | 0.141 | 0.1421 | 55690200.0 |
| 2003-10-24 12:00:00 | NVDA | Stock | 0.1419 | 0.1425 | 0.1419 | 0.142 | 26049120.0 |
| 2003-10-24 12:30:00 | NVDA | Stock | 0.1421 | 0.1421 | 0.1408 | 0.1416 | 38679720.0 |
| 2003-10-24 13:00:00 | NVDA | Stock | 0.1416 | 0.1417 | 0.141 | 0.1412 | 23421720.0 |
| 2003-10-24 13:30:00 | NVDA | Stock | 0.141 | 0.1417 | 0.1406 | 0.1407 | 14767920.0 |
| 2003-10-24 14:00:00 | NVDA | Stock | 0.1408 | 0.1417 | 0.1406 | 0.1413 | 15550440.0 |
| 2003-10-24 14:30:00 | NVDA | Stock | 0.1414 | 0.1414 | 0.1406 | 0.1407 | 15971280.0 |
> showing 50 of 37,601 rows — these rows as CSV