PREVIEW / stock_30min / 2008-12-31
file: by_date/stock_30min/2008/2008-12-31.parquet size: 1.3 MB rows: 71,801 symbols: 3,409
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-31 07:30:00 | AAPL | Stock | 3.1068 | 3.1143 | 3.0893 | 3.0893 | 47600.0 |
| 2008-12-31 08:00:00 | AAPL | Stock | 3.0832 | 3.0968 | 3.0789 | 3.0857 | 348768.0 |
| 2008-12-31 08:30:00 | AAPL | Stock | 3.0857 | 3.0911 | 3.0679 | 3.075 | 996352.0 |
| 2008-12-31 09:00:00 | AAPL | Stock | 3.075 | 3.0804 | 3.0679 | 3.0679 | 765604.0 |
| 2008-12-31 09:30:00 | AAPL | Stock | 3.0657 | 3.1154 | 3.0632 | 3.0993 | 63510720.0 |
| 2008-12-31 10:00:00 | AAPL | Stock | 3.0989 | 3.1064 | 3.08 | 3.0896 | 46418876.0 |
| 2008-12-31 10:30:00 | AAPL | Stock | 3.0893 | 3.1011 | 3.0829 | 3.095 | 32371444.0 |
| 2008-12-31 11:00:00 | AAPL | Stock | 3.095 | 3.1111 | 3.09 | 3.1096 | 27505856.0 |
| 2008-12-31 11:30:00 | AAPL | Stock | 3.1096 | 3.1171 | 3.1068 | 3.1125 | 37907268.0 |
| 2008-12-31 12:00:00 | AAPL | Stock | 3.1125 | 3.1196 | 3.1004 | 3.1079 | 30276764.0 |
| 2008-12-31 12:30:00 | AAPL | Stock | 3.1082 | 3.1336 | 3.1064 | 3.1282 | 40895176.0 |
| 2008-12-31 13:00:00 | AAPL | Stock | 3.1279 | 3.1314 | 3.1054 | 3.1071 | 37404640.0 |
| 2008-12-31 13:30:00 | AAPL | Stock | 3.1068 | 3.1139 | 3.1 | 3.11 | 30335228.0 |
| 2008-12-31 14:00:00 | AAPL | Stock | 3.11 | 3.1168 | 3.0879 | 3.0968 | 41020840.0 |
| 2008-12-31 14:30:00 | AAPL | Stock | 3.0971 | 3.1036 | 3.0864 | 3.1004 | 31756536.0 |
| 2008-12-31 15:00:00 | AAPL | Stock | 3.1004 | 3.1071 | 3.0846 | 3.0939 | 47909624.0 |
| 2008-12-31 15:30:00 | AAPL | Stock | 3.094 | 3.0982 | 3.0479 | 3.0479 | 91628068.0 |
| 2008-12-31 16:00:00 | AAPL | Stock | 3.0482 | 3.0981 | 3.0371 | 3.0482 | 34743828.0 |
| 2008-12-31 16:30:00 | AAPL | Stock | 3.0482 | 3.0525 | 3.0464 | 3.05 | 2213148.0 |
| 2008-12-31 17:00:00 | AAPL | Stock | 3.0482 | 3.0529 | 3.0479 | 3.0493 | 305480.0 |
| 2008-12-31 17:30:00 | AAPL | Stock | 3.05 | 3.0514 | 3.0482 | 3.05 | 210784.0 |
| 2008-12-31 18:00:00 | AAPL | Stock | 3.0493 | 3.05 | 3.0489 | 3.05 | 14756.0 |
| 2008-12-31 18:30:00 | AAPL | Stock | 3.0493 | 3.05 | 3.0482 | 3.0482 | 144284.0 |
| 2008-12-31 19:00:00 | AAPL | Stock | 3.0496 | 3.05 | 3.0486 | 3.0486 | 75740.0 |
| 2008-12-31 19:30:00 | AAPL | Stock | 3.05 | 3.0536 | 3.05 | 3.0532 | 60732.0 |
| 2008-12-31 08:00:00 | MSFT | Stock | 19.3 | 19.3 | 19.2 | 19.2 | 5460.0 |
| 2008-12-31 08:30:00 | MSFT | Stock | 19.26 | 19.3 | 19.26 | 19.3 | 1780.0 |
| 2008-12-31 09:00:00 | MSFT | Stock | 19.3 | 19.33 | 19.3 | 19.33 | 10875.0 |
| 2008-12-31 09:30:00 | MSFT | Stock | 19.31 | 19.55 | 19.27 | 19.49 | 4097760.0 |
| 2008-12-31 10:00:00 | MSFT | Stock | 19.49 | 19.55 | 19.44 | 19.49 | 2341463.0 |
| 2008-12-31 10:30:00 | MSFT | Stock | 19.49 | 19.5 | 19.38 | 19.482 | 2543561.0 |
| 2008-12-31 11:00:00 | MSFT | Stock | 19.48 | 19.59 | 19.48 | 19.59 | 2656806.0 |
| 2008-12-31 11:30:00 | MSFT | Stock | 19.59 | 19.62 | 19.55 | 19.57 | 2111343.0 |
| 2008-12-31 12:00:00 | MSFT | Stock | 19.57 | 19.65 | 19.55 | 19.589 | 2088446.0 |
| 2008-12-31 12:30:00 | MSFT | Stock | 19.585 | 19.65 | 19.56 | 19.602 | 1682324.0 |
| 2008-12-31 13:00:00 | MSFT | Stock | 19.61 | 19.62 | 19.55 | 19.58 | 1950686.0 |
| 2008-12-31 13:30:00 | MSFT | Stock | 19.58 | 19.61 | 19.53 | 19.6 | 1608577.0 |
| 2008-12-31 14:00:00 | MSFT | Stock | 19.6 | 19.68 | 19.56 | 19.6 | 2455014.0 |
| 2008-12-31 14:30:00 | MSFT | Stock | 19.61 | 19.66 | 19.53 | 19.64 | 2360263.0 |
| 2008-12-31 15:00:00 | MSFT | Stock | 19.64 | 19.67 | 19.45 | 19.53 | 3956748.0 |
| 2008-12-31 15:30:00 | MSFT | Stock | 19.52 | 19.62 | 19.4 | 19.44 | 8171438.0 |
| 2008-12-31 16:00:00 | MSFT | Stock | 19.45 | 19.596 | 19.3 | 19.4 | 6136883.0 |
| 2008-12-31 16:30:00 | MSFT | Stock | 19.4 | 19.442 | 19.33 | 19.44 | 525825.0 |
| 2008-12-31 17:00:00 | MSFT | Stock | 19.35 | 19.35 | 19.33 | 19.35 | 4750.0 |
| 2008-12-31 17:30:00 | MSFT | Stock | 19.37 | 19.39 | 19.37 | 19.39 | 1750.0 |
| 2008-12-31 18:00:00 | MSFT | Stock | 19.38 | 19.38 | 19.38 | 19.38 | 200.0 |
| 2008-12-31 18:30:00 | MSFT | Stock | 19.38 | 19.38 | 19.35 | 19.35 | 957.0 |
| 2008-12-31 19:00:00 | MSFT | Stock | 19.38 | 19.38 | 19.36 | 19.36 | 1100.0 |
| 2008-12-31 19:30:00 | MSFT | Stock | 19.35 | 19.35 | 19.34 | 19.34 | 3667.0 |
| 2008-12-31 08:00:00 | NVDA | Stock | 0.201 | 0.201 | 0.201 | 0.201 | 4000.0 |
> showing 50 of 71,801 rows — these rows as CSV