PREVIEW / stock_30min / 2009-01-23
file: by_date/stock_30min/2009/2009-01-23.parquet size: 1.3 MB rows: 72,488 symbols: 3,312
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-01-23 04:00:00 | AAPL | Stock | 3.1161 | 3.1161 | 3.1161 | 3.1161 | 11480.0 |
| 2009-01-23 04:30:00 | AAPL | Stock | 3.1071 | 3.1071 | 3.1071 | 3.1071 | 5600.0 |
| 2009-01-23 06:30:00 | AAPL | Stock | 3.1018 | 3.1018 | 3.1018 | 3.1018 | 5600.0 |
| 2009-01-23 07:00:00 | AAPL | Stock | 3.1071 | 3.1071 | 3.1071 | 3.1071 | 9772.0 |
| 2009-01-23 07:30:00 | AAPL | Stock | 3.1079 | 3.1214 | 3.1071 | 3.1075 | 120568.0 |
| 2009-01-23 08:00:00 | AAPL | Stock | 3.1079 | 3.1264 | 3.1079 | 3.1125 | 449932.0 |
| 2009-01-23 08:30:00 | AAPL | Stock | 3.1132 | 3.1179 | 3.0893 | 3.0932 | 1830304.0 |
| 2009-01-23 09:00:00 | AAPL | Stock | 3.0932 | 3.1054 | 3.0907 | 3.1014 | 1415848.0 |
| 2009-01-23 09:30:00 | AAPL | Stock | 3.1007 | 3.1382 | 3.0893 | 3.0896 | 118719804.0 |
| 2009-01-23 10:00:00 | AAPL | Stock | 3.0911 | 3.1429 | 3.0896 | 3.1396 | 69368124.0 |
| 2009-01-23 10:30:00 | AAPL | Stock | 3.1396 | 3.1429 | 3.1179 | 3.1189 | 43587376.0 |
| 2009-01-23 11:00:00 | AAPL | Stock | 3.1189 | 3.1561 | 3.1189 | 3.1539 | 70408548.0 |
| 2009-01-23 11:30:00 | AAPL | Stock | 3.1532 | 3.1664 | 3.1357 | 3.1404 | 45805536.0 |
| 2009-01-23 12:00:00 | AAPL | Stock | 3.14 | 3.1943 | 3.1393 | 3.1886 | 52263792.0 |
| 2009-01-23 12:30:00 | AAPL | Stock | 3.1879 | 3.1929 | 3.1629 | 3.175 | 35083188.0 |
| 2009-01-23 13:00:00 | AAPL | Stock | 3.1746 | 3.1982 | 3.1679 | 3.18 | 41690012.0 |
| 2009-01-23 13:30:00 | AAPL | Stock | 3.1804 | 3.2004 | 3.1786 | 3.1939 | 44480996.0 |
| 2009-01-23 14:00:00 | AAPL | Stock | 3.1946 | 3.2096 | 3.1775 | 3.1871 | 46021948.0 |
| 2009-01-23 14:30:00 | AAPL | Stock | 3.1871 | 3.1904 | 3.1575 | 3.1632 | 50373540.0 |
| 2009-01-23 15:00:00 | AAPL | Stock | 3.1632 | 3.1696 | 3.1429 | 3.1529 | 49035028.0 |
| 2009-01-23 15:30:00 | AAPL | Stock | 3.1529 | 3.1696 | 3.15 | 3.1561 | 68298692.0 |
| 2009-01-23 16:00:00 | AAPL | Stock | 3.1561 | 3.194 | 3.1429 | 3.1481 | 15750224.0 |
| 2009-01-23 16:30:00 | AAPL | Stock | 3.1557 | 3.1557 | 3.1486 | 3.1486 | 1456700.0 |
| 2009-01-23 17:00:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1482 | 3.1482 | 2800.0 |
| 2009-01-23 17:30:00 | AAPL | Stock | 3.1507 | 3.1507 | 3.1507 | 3.1507 | 4480.0 |
| 2009-01-23 18:00:00 | AAPL | Stock | 3.1557 | 3.1557 | 3.1486 | 3.1546 | 3749200.0 |
| 2009-01-23 18:30:00 | AAPL | Stock | 3.1546 | 3.1557 | 3.1543 | 3.1546 | 554456.0 |
| 2009-01-23 19:00:00 | AAPL | Stock | 3.1546 | 3.1546 | 3.1546 | 3.1546 | 2800.0 |
| 2009-01-23 19:30:00 | AAPL | Stock | 3.1504 | 3.1504 | 3.1457 | 3.15 | 89404.0 |
| 2009-01-23 04:00:00 | MSFT | Stock | 17.11 | 17.11 | 17.11 | 17.11 | 200.0 |
| 2009-01-23 04:30:00 | MSFT | Stock | 17.01 | 17.01 | 16.85 | 16.85 | 700.0 |
| 2009-01-23 06:30:00 | MSFT | Stock | 16.88 | 16.88 | 16.88 | 16.88 | 100.0 |
| 2009-01-23 07:00:00 | MSFT | Stock | 17.0 | 17.07 | 17.0 | 17.05 | 4700.0 |
| 2009-01-23 07:30:00 | MSFT | Stock | 17.05 | 17.05 | 16.97 | 16.97 | 14915.0 |
| 2009-01-23 08:00:00 | MSFT | Stock | 16.97 | 17.05 | 16.84 | 16.86 | 138328.0 |
| 2009-01-23 08:30:00 | MSFT | Stock | 16.86 | 16.87 | 16.77 | 16.8 | 261666.0 |
| 2009-01-23 09:00:00 | MSFT | Stock | 16.8 | 16.98 | 16.72 | 16.98 | 561467.0 |
| 2009-01-23 09:30:00 | MSFT | Stock | 16.98 | 17.48 | 16.75 | 17.37 | 18796668.0 |
| 2009-01-23 10:00:00 | MSFT | Stock | 17.38 | 17.49 | 17.19 | 17.46 | 12082487.0 |
| 2009-01-23 10:30:00 | MSFT | Stock | 17.45 | 17.46 | 17.21 | 17.21 | 9670750.0 |
| 2009-01-23 11:00:00 | MSFT | Stock | 17.22 | 17.43 | 17.21 | 17.34 | 8199235.0 |
| 2009-01-23 11:30:00 | MSFT | Stock | 17.34 | 17.37 | 17.25 | 17.28 | 5430816.0 |
| 2009-01-23 12:00:00 | MSFT | Stock | 17.28 | 17.33 | 17.16 | 17.29 | 7561438.0 |
| 2009-01-23 12:30:00 | MSFT | Stock | 17.29 | 17.39 | 17.18 | 17.28 | 7315271.0 |
| 2009-01-23 13:00:00 | MSFT | Stock | 17.28 | 17.45 | 17.23 | 17.36 | 6888013.0 |
| 2009-01-23 13:30:00 | MSFT | Stock | 17.37 | 17.49 | 17.35 | 17.47 | 5527015.0 |
| 2009-01-23 14:00:00 | MSFT | Stock | 17.471 | 17.49 | 17.36 | 17.44 | 4926772.0 |
| 2009-01-23 14:30:00 | MSFT | Stock | 17.44 | 17.47 | 17.26 | 17.27 | 5331502.0 |
| 2009-01-23 15:00:00 | MSFT | Stock | 17.27 | 17.34 | 17.22 | 17.24 | 6856165.0 |
| 2009-01-23 15:30:00 | MSFT | Stock | 17.24 | 17.37 | 17.16 | 17.19 | 10194468.0 |
> showing 50 of 72,488 rows — these rows as CSV