PREVIEW / stock_30min / 2010-07-22
file: by_date/stock_30min/2010/2010-07-22.parquet size: 1.3 MB rows: 72,712 symbols: 3,464
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-22 04:00:00 | AAPL | Stock | 9.1075 | 9.1075 | 9.1075 | 9.1075 | 5600.0 |
| 2010-07-22 04:30:00 | AAPL | Stock | 9.1607 | 9.1782 | 9.1607 | 9.1782 | 19600.0 |
| 2010-07-22 05:00:00 | AAPL | Stock | 9.1957 | 9.1957 | 9.1846 | 9.1846 | 16800.0 |
| 2010-07-22 05:30:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 8400.0 |
| 2010-07-22 06:00:00 | AAPL | Stock | 9.1711 | 9.1786 | 9.1711 | 9.1714 | 50568.0 |
| 2010-07-22 06:30:00 | AAPL | Stock | 9.1754 | 9.1939 | 9.1754 | 9.1839 | 143500.0 |
| 2010-07-22 07:00:00 | AAPL | Stock | 9.1864 | 9.1864 | 9.1425 | 9.1425 | 252448.0 |
| 2010-07-22 07:30:00 | AAPL | Stock | 9.1529 | 9.1889 | 9.1518 | 9.1875 | 709884.0 |
| 2010-07-22 08:00:00 | AAPL | Stock | 9.1836 | 9.1893 | 9.1554 | 9.1679 | 2689876.0 |
| 2010-07-22 08:30:00 | AAPL | Stock | 9.1657 | 9.1861 | 9.1454 | 9.1861 | 2465484.0 |
| 2010-07-22 09:00:00 | AAPL | Stock | 9.1857 | 9.2125 | 9.1857 | 9.1996 | 2341836.0 |
| 2010-07-22 09:30:00 | AAPL | Stock | 9.1993 | 9.2143 | 9.1182 | 9.1321 | 104658764.0 |
| 2010-07-22 10:00:00 | AAPL | Stock | 9.1321 | 9.2268 | 9.1264 | 9.2118 | 89424468.0 |
| 2010-07-22 10:30:00 | AAPL | Stock | 9.2121 | 9.2857 | 9.2021 | 9.2614 | 83121584.0 |
| 2010-07-22 11:00:00 | AAPL | Stock | 9.2621 | 9.2786 | 9.2404 | 9.2711 | 33535404.0 |
| 2010-07-22 11:30:00 | AAPL | Stock | 9.2699 | 9.2771 | 9.2146 | 9.2321 | 31039680.0 |
| 2010-07-22 12:00:00 | AAPL | Stock | 9.2329 | 9.2746 | 9.2282 | 9.2725 | 28158088.0 |
| 2010-07-22 12:30:00 | AAPL | Stock | 9.2725 | 9.2736 | 9.25 | 9.2593 | 17950352.0 |
| 2010-07-22 13:00:00 | AAPL | Stock | 9.2607 | 9.2821 | 9.255 | 9.2557 | 24651928.0 |
| 2010-07-22 13:30:00 | AAPL | Stock | 9.2579 | 9.2768 | 9.2321 | 9.2464 | 24112200.0 |
| 2010-07-22 14:00:00 | AAPL | Stock | 9.2475 | 9.2821 | 9.2464 | 9.28 | 30296000.0 |
| 2010-07-22 14:30:00 | AAPL | Stock | 9.2786 | 9.2821 | 9.2525 | 9.2684 | 23812908.0 |
| 2010-07-22 15:00:00 | AAPL | Stock | 9.2679 | 9.2857 | 9.2429 | 9.265 | 42988204.0 |
| 2010-07-22 15:30:00 | AAPL | Stock | 9.265 | 9.2693 | 9.2075 | 9.2604 | 78291164.0 |
| 2010-07-22 16:00:00 | AAPL | Stock | 9.26 | 9.2622 | 9.2064 | 9.2207 | 14053424.0 |
| 2010-07-22 16:30:00 | AAPL | Stock | 9.215 | 9.2384 | 9.2079 | 9.2196 | 425320.0 |
| 2010-07-22 17:00:00 | AAPL | Stock | 9.2157 | 9.2604 | 9.2154 | 9.2254 | 358876.0 |
| 2010-07-22 17:30:00 | AAPL | Stock | 9.2293 | 9.2304 | 9.2239 | 9.2239 | 111020.0 |
| 2010-07-22 18:00:00 | AAPL | Stock | 9.2232 | 9.2507 | 9.2196 | 9.2196 | 210168.0 |
| 2010-07-22 18:30:00 | AAPL | Stock | 9.2221 | 9.225 | 9.2189 | 9.225 | 145992.0 |
| 2010-07-22 19:00:00 | AAPL | Stock | 9.2186 | 9.2321 | 9.2186 | 9.2271 | 109760.0 |
| 2010-07-22 19:30:00 | AAPL | Stock | 9.235 | 9.2429 | 9.2232 | 9.2429 | 159516.0 |
| 2010-07-22 05:30:00 | MSFT | Stock | 25.42 | 25.42 | 25.42 | 25.42 | 500.0 |
| 2010-07-22 06:00:00 | MSFT | Stock | 25.5 | 25.65 | 25.46 | 25.65 | 700.0 |
| 2010-07-22 06:30:00 | MSFT | Stock | 25.53 | 25.64 | 25.53 | 25.55 | 2400.0 |
| 2010-07-22 07:00:00 | MSFT | Stock | 25.54 | 25.57 | 25.46 | 25.46 | 2125.0 |
| 2010-07-22 07:30:00 | MSFT | Stock | 25.52 | 25.55 | 25.46 | 25.52 | 24970.0 |
| 2010-07-22 08:00:00 | MSFT | Stock | 25.52 | 25.57 | 25.45 | 25.55 | 250659.0 |
| 2010-07-22 08:30:00 | MSFT | Stock | 25.49 | 25.59 | 25.49 | 25.57 | 132793.0 |
| 2010-07-22 09:00:00 | MSFT | Stock | 25.57 | 25.6 | 25.5 | 25.51 | 245891.0 |
| 2010-07-22 09:30:00 | MSFT | Stock | 25.51 | 25.85 | 25.47 | 25.69 | 8909416.0 |
| 2010-07-22 10:00:00 | MSFT | Stock | 25.69 | 25.85 | 25.68 | 25.72 | 5721137.0 |
| 2010-07-22 10:30:00 | MSFT | Stock | 25.71 | 25.82 | 25.68 | 25.795 | 4946954.0 |
| 2010-07-22 11:00:00 | MSFT | Stock | 25.8 | 25.9 | 25.74 | 25.87 | 3801282.0 |
| 2010-07-22 11:30:00 | MSFT | Stock | 25.86 | 25.9 | 25.74 | 25.81 | 4186409.0 |
| 2010-07-22 12:00:00 | MSFT | Stock | 25.81 | 25.87 | 25.75 | 25.79 | 2728702.0 |
| 2010-07-22 12:30:00 | MSFT | Stock | 25.79 | 25.9 | 25.78 | 25.9 | 2983899.0 |
| 2010-07-22 13:00:00 | MSFT | Stock | 25.9 | 25.99 | 25.85 | 25.97 | 3918535.0 |
| 2010-07-22 13:30:00 | MSFT | Stock | 25.97 | 25.985 | 25.83 | 25.832 | 2899361.0 |
| 2010-07-22 14:00:00 | MSFT | Stock | 25.84 | 25.95 | 25.806 | 25.95 | 3544823.0 |
> showing 50 of 72,712 rows — these rows as CSV