PREVIEW / stock_30min / 2008-07-15
file: by_date/stock_30min/2008/2008-07-15.parquet size: 1.3 MB rows: 70,867 symbols: 3,365
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-07-15 04:00:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.1786 | 6.1786 | 2800.0 |
| 2008-07-15 05:00:00 | AAPL | Stock | 6.1607 | 6.1607 | 6.1607 | 6.1607 | 2800.0 |
| 2008-07-15 06:30:00 | AAPL | Stock | 6.1325 | 6.1325 | 6.0911 | 6.0911 | 288400.0 |
| 2008-07-15 07:00:00 | AAPL | Stock | 6.1161 | 6.1225 | 6.0661 | 6.1029 | 382200.0 |
| 2008-07-15 07:30:00 | AAPL | Stock | 6.1029 | 6.1054 | 6.0821 | 6.1054 | 396760.0 |
| 2008-07-15 08:00:00 | AAPL | Stock | 6.0868 | 6.1175 | 6.0854 | 6.1089 | 2367708.0 |
| 2008-07-15 08:30:00 | AAPL | Stock | 6.1089 | 6.1357 | 6.1018 | 6.1275 | 2020312.0 |
| 2008-07-15 09:00:00 | AAPL | Stock | 6.1286 | 6.1643 | 6.1107 | 6.1596 | 3176992.0 |
| 2008-07-15 09:30:00 | AAPL | Stock | 6.16 | 6.1782 | 6.0393 | 6.0821 | 132416704.0 |
| 2008-07-15 10:00:00 | AAPL | Stock | 6.0821 | 6.0854 | 5.9425 | 6.0096 | 146665820.0 |
| 2008-07-15 10:30:00 | AAPL | Stock | 6.0089 | 6.0757 | 5.9568 | 6.0471 | 88971820.0 |
| 2008-07-15 11:00:00 | AAPL | Stock | 6.0479 | 6.1525 | 6.0472 | 6.0593 | 101658620.0 |
| 2008-07-15 11:30:00 | AAPL | Stock | 6.0516 | 6.0975 | 5.9829 | 6.0729 | 70748076.0 |
| 2008-07-15 12:00:00 | AAPL | Stock | 6.0739 | 6.1557 | 6.0557 | 6.15 | 68280800.0 |
| 2008-07-15 12:30:00 | AAPL | Stock | 6.1489 | 6.205 | 6.1236 | 6.1714 | 76702220.0 |
| 2008-07-15 13:00:00 | AAPL | Stock | 6.1711 | 6.1957 | 6.0907 | 6.1104 | 52457776.0 |
| 2008-07-15 13:30:00 | AAPL | Stock | 6.1104 | 6.1429 | 6.0893 | 6.1229 | 34850172.0 |
| 2008-07-15 14:00:00 | AAPL | Stock | 6.1225 | 6.14 | 6.0929 | 6.1282 | 38787084.0 |
| 2008-07-15 14:30:00 | AAPL | Stock | 6.1286 | 6.1607 | 6.1043 | 6.1489 | 48694380.0 |
| 2008-07-15 15:00:00 | AAPL | Stock | 6.1489 | 6.1882 | 6.1157 | 6.1207 | 65174004.0 |
| 2008-07-15 15:30:00 | AAPL | Stock | 6.1211 | 6.1421 | 6.0564 | 6.0564 | 77966280.0 |
| 2008-07-15 16:00:00 | AAPL | Stock | 6.0586 | 6.1286 | 6.05 | 6.0896 | 14890008.0 |
| 2008-07-15 16:30:00 | AAPL | Stock | 6.0929 | 6.1171 | 6.0586 | 6.1161 | 2089416.0 |
| 2008-07-15 17:00:00 | AAPL | Stock | 6.1161 | 6.1256 | 6.0921 | 6.1071 | 482720.0 |
| 2008-07-15 17:30:00 | AAPL | Stock | 6.0946 | 6.0946 | 6.0929 | 6.0929 | 30380.0 |
| 2008-07-15 18:00:00 | AAPL | Stock | 6.0929 | 6.1107 | 6.0896 | 6.1075 | 108920.0 |
| 2008-07-15 18:30:00 | AAPL | Stock | 6.1071 | 6.1118 | 6.1 | 6.1 | 226100.0 |
| 2008-07-15 19:00:00 | AAPL | Stock | 6.1 | 6.125 | 6.1 | 6.1161 | 120008.0 |
| 2008-07-15 19:30:00 | AAPL | Stock | 6.1082 | 6.1157 | 6.1004 | 6.1064 | 138208.0 |
| 2008-07-15 07:00:00 | MSFT | Stock | 24.92 | 25.04 | 24.92 | 25.04 | 500.0 |
| 2008-07-15 07:30:00 | MSFT | Stock | 24.97 | 24.97 | 24.92 | 24.92 | 600.0 |
| 2008-07-15 08:00:00 | MSFT | Stock | 25.0 | 25.12 | 24.92 | 25.0 | 25948.0 |
| 2008-07-15 08:30:00 | MSFT | Stock | 24.99 | 25.15 | 24.95 | 25.15 | 16932.0 |
| 2008-07-15 09:00:00 | MSFT | Stock | 25.1 | 25.1 | 24.92 | 24.94 | 49175.0 |
| 2008-07-15 09:30:00 | MSFT | Stock | 24.93 | 25.48 | 24.92 | 25.41 | 8339980.0 |
| 2008-07-15 10:00:00 | MSFT | Stock | 25.42 | 25.7 | 25.18 | 25.62 | 11050385.0 |
| 2008-07-15 10:30:00 | MSFT | Stock | 25.61 | 25.9 | 25.58 | 25.793 | 7072467.0 |
| 2008-07-15 11:00:00 | MSFT | Stock | 25.8 | 26.4 | 25.795 | 26.07 | 11616586.0 |
| 2008-07-15 11:30:00 | MSFT | Stock | 26.07 | 26.14 | 25.76 | 26.04 | 5159798.0 |
| 2008-07-15 12:00:00 | MSFT | Stock | 26.05 | 26.25 | 25.95 | 26.21 | 4489190.0 |
| 2008-07-15 12:30:00 | MSFT | Stock | 26.22 | 26.34 | 26.11 | 26.219 | 4329018.0 |
| 2008-07-15 13:00:00 | MSFT | Stock | 26.21 | 26.35 | 26.04 | 26.091 | 5217961.0 |
| 2008-07-15 13:30:00 | MSFT | Stock | 26.1 | 26.32 | 26.06 | 26.29 | 3863810.0 |
| 2008-07-15 14:00:00 | MSFT | Stock | 26.3 | 26.52 | 26.21 | 26.5 | 5765638.0 |
| 2008-07-15 14:30:00 | MSFT | Stock | 26.51 | 26.56 | 26.41 | 26.492 | 4399732.0 |
| 2008-07-15 15:00:00 | MSFT | Stock | 26.5 | 26.64 | 26.25 | 26.28 | 6373859.0 |
| 2008-07-15 15:30:00 | MSFT | Stock | 26.29 | 26.37 | 26.1 | 26.14 | 10150150.0 |
| 2008-07-15 16:00:00 | MSFT | Stock | 26.149 | 26.35 | 25.297 | 26.2 | 3216976.0 |
| 2008-07-15 16:30:00 | MSFT | Stock | 26.15 | 26.2 | 26.15 | 26.15 | 222385.0 |
| 2008-07-15 17:00:00 | MSFT | Stock | 26.25 | 26.25 | 26.2 | 26.2 | 3550.0 |
> showing 50 of 70,867 rows — these rows as CSV