PREVIEW / stock_30min / 2009-07-15
file: by_date/stock_30min/2009/2009-07-15.parquet size: 1.3 MB rows: 73,518 symbols: 3,364
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-07-15 06:00:00 | AAPL | Stock | 5.1607 | 5.1607 | 5.1607 | 5.1607 | 2800.0 |
| 2009-07-15 07:00:00 | AAPL | Stock | 5.1686 | 5.1686 | 5.1507 | 5.1604 | 38864.0 |
| 2009-07-15 07:30:00 | AAPL | Stock | 5.1604 | 5.1607 | 5.1361 | 5.1368 | 205996.0 |
| 2009-07-15 08:00:00 | AAPL | Stock | 5.1496 | 5.1679 | 5.1429 | 5.1554 | 660044.0 |
| 2009-07-15 08:30:00 | AAPL | Stock | 5.1604 | 5.1689 | 5.1561 | 5.1679 | 711508.0 |
| 2009-07-15 09:00:00 | AAPL | Stock | 5.1661 | 5.1871 | 5.1661 | 5.1718 | 2889432.0 |
| 2009-07-15 09:30:00 | AAPL | Stock | 5.18 | 5.1982 | 5.1543 | 5.175 | 89729192.0 |
| 2009-07-15 10:00:00 | AAPL | Stock | 5.175 | 5.1911 | 5.1704 | 5.1832 | 39266080.0 |
| 2009-07-15 10:30:00 | AAPL | Stock | 5.1836 | 5.1914 | 5.1796 | 5.1843 | 24008376.0 |
| 2009-07-15 11:00:00 | AAPL | Stock | 5.1839 | 5.2168 | 5.1829 | 5.2161 | 41792464.0 |
| 2009-07-15 11:30:00 | AAPL | Stock | 5.2157 | 5.2214 | 5.2086 | 5.2182 | 23387168.0 |
| 2009-07-15 12:00:00 | AAPL | Stock | 5.2182 | 5.2307 | 5.2129 | 5.2293 | 23186352.0 |
| 2009-07-15 12:30:00 | AAPL | Stock | 5.2296 | 5.2396 | 5.2271 | 5.2306 | 19958344.0 |
| 2009-07-15 13:00:00 | AAPL | Stock | 5.2311 | 5.2321 | 5.2211 | 5.2304 | 18382756.0 |
| 2009-07-15 13:30:00 | AAPL | Stock | 5.23 | 5.2454 | 5.2289 | 5.235 | 24041584.0 |
| 2009-07-15 14:00:00 | AAPL | Stock | 5.235 | 5.2411 | 5.2225 | 5.2275 | 29001308.0 |
| 2009-07-15 14:30:00 | AAPL | Stock | 5.2275 | 5.2482 | 5.2268 | 5.2443 | 28765604.0 |
| 2009-07-15 15:00:00 | AAPL | Stock | 5.2446 | 5.2475 | 5.2361 | 5.2407 | 34344464.0 |
| 2009-07-15 15:30:00 | AAPL | Stock | 5.2409 | 5.25 | 5.2264 | 5.2436 | 61861576.0 |
| 2009-07-15 16:00:00 | AAPL | Stock | 5.2454 | 5.25 | 5.2129 | 5.2457 | 15797180.0 |
| 2009-07-15 16:30:00 | AAPL | Stock | 5.2457 | 5.2457 | 5.2321 | 5.2321 | 795704.0 |
| 2009-07-15 17:00:00 | AAPL | Stock | 5.2321 | 5.2411 | 5.2286 | 5.2404 | 137648.0 |
| 2009-07-15 17:30:00 | AAPL | Stock | 5.2418 | 5.2457 | 5.2411 | 5.2429 | 158340.0 |
| 2009-07-15 18:00:00 | AAPL | Stock | 5.2429 | 5.2457 | 5.2321 | 5.2443 | 1428476.0 |
| 2009-07-15 18:30:00 | AAPL | Stock | 5.2443 | 5.2443 | 5.2339 | 5.2357 | 135660.0 |
| 2009-07-15 19:00:00 | AAPL | Stock | 5.2343 | 5.2375 | 5.2321 | 5.2357 | 122136.0 |
| 2009-07-15 19:30:00 | AAPL | Stock | 5.2307 | 5.2446 | 5.2307 | 5.2446 | 170100.0 |
| 2009-07-15 06:00:00 | MSFT | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 150.0 |
| 2009-07-15 06:30:00 | MSFT | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 550.0 |
| 2009-07-15 07:00:00 | MSFT | Stock | 23.75 | 23.75 | 23.7 | 23.71 | 1600.0 |
| 2009-07-15 07:30:00 | MSFT | Stock | 23.71 | 23.71 | 23.65 | 23.65 | 15300.0 |
| 2009-07-15 08:00:00 | MSFT | Stock | 23.69 | 23.85 | 23.69 | 23.77 | 65050.0 |
| 2009-07-15 08:30:00 | MSFT | Stock | 23.76 | 23.76 | 23.73 | 23.74 | 22068.0 |
| 2009-07-15 09:00:00 | MSFT | Stock | 23.73 | 23.76 | 23.7 | 23.7 | 79132.0 |
| 2009-07-15 09:30:00 | MSFT | Stock | 23.74 | 23.81 | 23.56 | 23.77 | 9333764.0 |
| 2009-07-15 10:00:00 | MSFT | Stock | 23.773 | 23.86 | 23.74 | 23.84 | 4498780.0 |
| 2009-07-15 10:30:00 | MSFT | Stock | 23.85 | 23.86 | 23.73 | 23.77 | 3518776.0 |
| 2009-07-15 11:00:00 | MSFT | Stock | 23.77 | 23.97 | 23.76 | 23.89 | 4698412.0 |
| 2009-07-15 11:30:00 | MSFT | Stock | 23.892 | 23.9 | 23.78 | 23.823 | 2588374.0 |
| 2009-07-15 12:00:00 | MSFT | Stock | 23.83 | 23.83 | 23.77 | 23.8 | 1863207.0 |
| 2009-07-15 12:30:00 | MSFT | Stock | 23.8 | 23.86 | 23.8 | 23.8 | 1956473.0 |
| 2009-07-15 13:00:00 | MSFT | Stock | 23.81 | 23.84 | 23.77 | 23.8 | 2603996.0 |
| 2009-07-15 13:30:00 | MSFT | Stock | 23.81 | 23.86 | 23.8 | 23.829 | 2020494.0 |
| 2009-07-15 14:00:00 | MSFT | Stock | 23.83 | 23.895 | 23.8 | 23.86 | 4372629.0 |
| 2009-07-15 14:30:00 | MSFT | Stock | 23.87 | 23.99 | 23.85 | 23.98 | 4380371.0 |
| 2009-07-15 15:00:00 | MSFT | Stock | 23.97 | 24.05 | 23.93 | 23.96 | 6955295.0 |
| 2009-07-15 15:30:00 | MSFT | Stock | 23.95 | 24.12 | 23.95 | 24.12 | 11440458.0 |
| 2009-07-15 16:00:00 | MSFT | Stock | 24.12 | 24.29 | 23.877 | 24.0 | 4439641.0 |
| 2009-07-15 16:30:00 | MSFT | Stock | 24.02 | 24.12 | 23.99 | 24.0 | 390906.0 |
| 2009-07-15 17:00:00 | MSFT | Stock | 24.02 | 24.04 | 24.02 | 24.04 | 5974.0 |
> showing 50 of 73,518 rows — these rows as CSV