PREVIEW / stock_30min / 2009-10-20
file: by_date/stock_30min/2009/2009-10-20.parquet size: 1.3 MB rows: 72,439 symbols: 3,394
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-20 04:00:00 | AAPL | Stock | 7.1429 | 7.1718 | 7.1357 | 7.1357 | 47264.0 |
| 2009-10-20 04:30:00 | AAPL | Stock | 7.1464 | 7.1521 | 7.12 | 7.1293 | 33152.0 |
| 2009-10-20 05:00:00 | AAPL | Stock | 7.1257 | 7.1632 | 7.125 | 7.1632 | 166236.0 |
| 2009-10-20 05:30:00 | AAPL | Stock | 7.1607 | 7.1786 | 7.1607 | 7.1786 | 67508.0 |
| 2009-10-20 06:00:00 | AAPL | Stock | 7.1796 | 7.1857 | 7.1786 | 7.1857 | 211904.0 |
| 2009-10-20 06:30:00 | AAPL | Stock | 7.175 | 7.2 | 7.175 | 7.2 | 359324.0 |
| 2009-10-20 07:00:00 | AAPL | Stock | 7.1929 | 7.2304 | 7.1929 | 7.2279 | 1814176.0 |
| 2009-10-20 07:30:00 | AAPL | Stock | 7.2207 | 7.2496 | 7.2036 | 7.2393 | 2365132.0 |
| 2009-10-20 08:00:00 | AAPL | Stock | 7.2107 | 7.2582 | 7.2054 | 7.2232 | 13867700.0 |
| 2009-10-20 08:30:00 | AAPL | Stock | 7.2232 | 7.2304 | 7.1996 | 7.2125 | 10124044.0 |
| 2009-10-20 09:00:00 | AAPL | Stock | 7.2143 | 7.2246 | 7.1629 | 7.1646 | 20085912.0 |
| 2009-10-20 09:30:00 | AAPL | Stock | 7.1643 | 7.2054 | 7.0893 | 7.1129 | 315972300.0 |
| 2009-10-20 10:00:00 | AAPL | Stock | 7.1125 | 7.1421 | 7.0757 | 7.0998 | 124776652.0 |
| 2009-10-20 10:30:00 | AAPL | Stock | 7.0997 | 7.1554 | 7.0904 | 7.1461 | 84210448.0 |
| 2009-10-20 11:00:00 | AAPL | Stock | 7.1461 | 7.1675 | 7.1314 | 7.1389 | 66155460.0 |
| 2009-10-20 11:30:00 | AAPL | Stock | 7.1386 | 7.1404 | 7.1111 | 7.1225 | 45813432.0 |
| 2009-10-20 12:00:00 | AAPL | Stock | 7.1232 | 7.1311 | 7.0921 | 7.1032 | 57448468.0 |
| 2009-10-20 12:30:00 | AAPL | Stock | 7.1039 | 7.1064 | 7.0661 | 7.0904 | 45508092.0 |
| 2009-10-20 13:00:00 | AAPL | Stock | 7.0904 | 7.1139 | 7.0876 | 7.1014 | 30289672.0 |
| 2009-10-20 13:30:00 | AAPL | Stock | 7.1025 | 7.1261 | 7.0993 | 7.1032 | 35021252.0 |
| 2009-10-20 14:00:00 | AAPL | Stock | 7.1021 | 7.1357 | 7.0982 | 7.115 | 41176100.0 |
| 2009-10-20 14:30:00 | AAPL | Stock | 7.1146 | 7.1236 | 7.0986 | 7.1146 | 41682704.0 |
| 2009-10-20 15:00:00 | AAPL | Stock | 7.1153 | 7.1196 | 7.0857 | 7.11 | 39622800.0 |
| 2009-10-20 15:30:00 | AAPL | Stock | 7.1093 | 7.1207 | 7.0986 | 7.1 | 59005072.0 |
| 2009-10-20 16:00:00 | AAPL | Stock | 7.0993 | 7.1282 | 7.0714 | 7.0779 | 13555780.0 |
| 2009-10-20 16:30:00 | AAPL | Stock | 7.0804 | 7.0969 | 7.0804 | 7.0857 | 1172668.0 |
| 2009-10-20 17:00:00 | AAPL | Stock | 7.0829 | 7.0986 | 7.065 | 7.0986 | 1315076.0 |
| 2009-10-20 17:30:00 | AAPL | Stock | 7.0675 | 7.0707 | 7.0661 | 7.0696 | 256508.0 |
| 2009-10-20 18:00:00 | AAPL | Stock | 7.0693 | 7.1518 | 7.0679 | 7.1286 | 6483680.0 |
| 2009-10-20 18:30:00 | AAPL | Stock | 7.1286 | 7.1321 | 7.1179 | 7.1243 | 889056.0 |
| 2009-10-20 19:00:00 | AAPL | Stock | 7.1214 | 7.1268 | 7.1211 | 7.1229 | 279244.0 |
| 2009-10-20 19:30:00 | AAPL | Stock | 7.1229 | 7.1321 | 7.1214 | 7.1307 | 408940.0 |
| 2009-10-20 05:30:00 | MSFT | Stock | 26.52 | 26.58 | 26.52 | 26.58 | 372.0 |
| 2009-10-20 07:00:00 | MSFT | Stock | 26.52 | 26.52 | 26.52 | 26.52 | 100.0 |
| 2009-10-20 07:30:00 | MSFT | Stock | 26.47 | 26.57 | 26.46 | 26.46 | 2900.0 |
| 2009-10-20 08:00:00 | MSFT | Stock | 26.47 | 26.5 | 26.44 | 26.47 | 38809.0 |
| 2009-10-20 08:30:00 | MSFT | Stock | 26.44 | 26.45 | 26.38 | 26.38 | 7769.0 |
| 2009-10-20 09:00:00 | MSFT | Stock | 26.4 | 26.43 | 26.36 | 26.42 | 80131.0 |
| 2009-10-20 09:30:00 | MSFT | Stock | 26.42 | 26.43 | 26.03 | 26.2 | 7171892.0 |
| 2009-10-20 10:00:00 | MSFT | Stock | 26.19 | 26.23 | 26.1 | 26.13 | 3272604.0 |
| 2009-10-20 10:30:00 | MSFT | Stock | 26.132 | 26.23 | 26.1 | 26.22 | 2192035.0 |
| 2009-10-20 11:00:00 | MSFT | Stock | 26.229 | 26.229 | 26.05 | 26.06 | 3448411.0 |
| 2009-10-20 11:30:00 | MSFT | Stock | 26.07 | 26.1 | 25.94 | 26.01 | 4846253.0 |
| 2009-10-20 12:00:00 | MSFT | Stock | 26.005 | 26.09 | 25.95 | 26.07 | 2399264.0 |
| 2009-10-20 12:30:00 | MSFT | Stock | 26.07 | 26.08 | 25.96 | 26.04 | 2727288.0 |
| 2009-10-20 13:00:00 | MSFT | Stock | 26.05 | 26.09 | 26.03 | 26.08 | 1665020.0 |
| 2009-10-20 13:30:00 | MSFT | Stock | 26.08 | 26.17 | 26.07 | 26.14 | 2772022.0 |
| 2009-10-20 14:00:00 | MSFT | Stock | 26.144 | 26.23 | 26.13 | 26.197 | 2918130.0 |
| 2009-10-20 14:30:00 | MSFT | Stock | 26.197 | 26.28 | 26.17 | 26.28 | 3112177.0 |
| 2009-10-20 15:00:00 | MSFT | Stock | 26.27 | 26.33 | 26.21 | 26.31 | 4331229.0 |
> showing 50 of 72,439 rows — these rows as CSV