PREVIEW / stock_30min / 2008-12-01
file: by_date/stock_30min/2008/2008-12-01.parquet size: 1.2 MB rows: 70,274 symbols: 3,346
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-12-01 07:00:00 | AAPL | Stock | 3.25 | 3.25 | 3.2261 | 3.2261 | 19628.0 |
| 2008-12-01 07:30:00 | AAPL | Stock | 3.2532 | 3.26 | 3.2414 | 3.2582 | 32200.0 |
| 2008-12-01 08:00:00 | AAPL | Stock | 3.25 | 3.3096 | 3.2411 | 3.25 | 758492.0 |
| 2008-12-01 08:30:00 | AAPL | Stock | 3.2464 | 3.2554 | 3.2321 | 3.2514 | 661416.0 |
| 2008-12-01 09:00:00 | AAPL | Stock | 3.2514 | 3.2729 | 3.2464 | 3.2632 | 1324484.0 |
| 2008-12-01 09:30:00 | AAPL | Stock | 3.2618 | 3.2954 | 3.2204 | 3.2231 | 143087840.0 |
| 2008-12-01 10:00:00 | AAPL | Stock | 3.2221 | 3.2464 | 3.2143 | 3.2182 | 81461660.0 |
| 2008-12-01 10:30:00 | AAPL | Stock | 3.2182 | 3.2339 | 3.1861 | 3.1861 | 72672908.0 |
| 2008-12-01 11:00:00 | AAPL | Stock | 3.1871 | 3.2064 | 3.1786 | 3.1889 | 50446732.0 |
| 2008-12-01 11:30:00 | AAPL | Stock | 3.1889 | 3.225 | 3.1871 | 3.2171 | 45419500.0 |
| 2008-12-01 12:00:00 | AAPL | Stock | 3.2179 | 3.2268 | 3.2025 | 3.2054 | 42926688.0 |
| 2008-12-01 12:30:00 | AAPL | Stock | 3.2054 | 3.2268 | 3.1961 | 3.2157 | 42886228.0 |
| 2008-12-01 13:00:00 | AAPL | Stock | 3.2157 | 3.2357 | 3.2154 | 3.225 | 29779820.0 |
| 2008-12-01 13:30:00 | AAPL | Stock | 3.225 | 3.2414 | 3.2129 | 3.2329 | 45982692.0 |
| 2008-12-01 14:00:00 | AAPL | Stock | 3.2332 | 3.2586 | 3.2261 | 3.2493 | 62268920.0 |
| 2008-12-01 14:30:00 | AAPL | Stock | 3.2496 | 3.2707 | 3.2375 | 3.2607 | 62471640.0 |
| 2008-12-01 15:00:00 | AAPL | Stock | 3.26 | 3.2696 | 3.2254 | 3.2357 | 65723308.0 |
| 2008-12-01 15:30:00 | AAPL | Stock | 3.2357 | 3.2379 | 3.1786 | 3.1786 | 116952724.0 |
| 2008-12-01 16:00:00 | AAPL | Stock | 3.1786 | 3.3096 | 3.1746 | 3.185 | 33512808.0 |
| 2008-12-01 16:30:00 | AAPL | Stock | 3.185 | 3.227 | 3.1761 | 3.1846 | 658392.0 |
| 2008-12-01 17:00:00 | AAPL | Stock | 3.1864 | 3.2253 | 3.1761 | 3.1786 | 14565908.0 |
| 2008-12-01 17:30:00 | AAPL | Stock | 3.1789 | 3.1839 | 3.1786 | 3.1839 | 49140.0 |
| 2008-12-01 18:00:00 | AAPL | Stock | 3.1786 | 3.1964 | 3.1786 | 3.1811 | 224140.0 |
| 2008-12-01 18:30:00 | AAPL | Stock | 3.1939 | 3.1943 | 3.1821 | 3.1839 | 109424.0 |
| 2008-12-01 19:00:00 | AAPL | Stock | 3.1957 | 3.1964 | 3.1811 | 3.1946 | 192724.0 |
| 2008-12-01 19:30:00 | AAPL | Stock | 3.185 | 3.1964 | 3.185 | 3.1964 | 72100.0 |
| 2008-12-01 07:00:00 | MSFT | Stock | 19.75 | 19.76 | 19.75 | 19.76 | 1000.0 |
| 2008-12-01 07:30:00 | MSFT | Stock | 19.76 | 19.76 | 19.76 | 19.76 | 1000.0 |
| 2008-12-01 08:00:00 | MSFT | Stock | 19.87 | 20.22 | 19.82 | 19.95 | 22383.0 |
| 2008-12-01 08:30:00 | MSFT | Stock | 19.95 | 20.22 | 19.87 | 19.87 | 4089.0 |
| 2008-12-01 09:00:00 | MSFT | Stock | 19.87 | 19.93 | 19.84 | 19.86 | 14257.0 |
| 2008-12-01 09:30:00 | MSFT | Stock | 19.875 | 19.95 | 19.59 | 19.64 | 6894471.0 |
| 2008-12-01 10:00:00 | MSFT | Stock | 19.64 | 19.74 | 19.58 | 19.64 | 4672316.0 |
| 2008-12-01 10:30:00 | MSFT | Stock | 19.64 | 19.68 | 19.488 | 19.538 | 4833033.0 |
| 2008-12-01 11:00:00 | MSFT | Stock | 19.53 | 19.57 | 19.44 | 19.475 | 4144074.0 |
| 2008-12-01 11:30:00 | MSFT | Stock | 19.47 | 19.6 | 19.46 | 19.5 | 3371123.0 |
| 2008-12-01 12:00:00 | MSFT | Stock | 19.5 | 19.54 | 19.4 | 19.44 | 2321433.0 |
| 2008-12-01 12:30:00 | MSFT | Stock | 19.44 | 19.47 | 19.33 | 19.34 | 2699701.0 |
| 2008-12-01 13:00:00 | MSFT | Stock | 19.35 | 19.36 | 19.24 | 19.31 | 3979066.0 |
| 2008-12-01 13:30:00 | MSFT | Stock | 19.301 | 19.38 | 19.1 | 19.17 | 5073190.0 |
| 2008-12-01 14:00:00 | MSFT | Stock | 19.17 | 19.17 | 19.03 | 19.14 | 4809261.0 |
| 2008-12-01 14:30:00 | MSFT | Stock | 19.14 | 19.289 | 19.03 | 19.17 | 5493138.0 |
| 2008-12-01 15:00:00 | MSFT | Stock | 19.18 | 19.25 | 19.0 | 19.02 | 4883915.0 |
| 2008-12-01 15:30:00 | MSFT | Stock | 19.01 | 19.06 | 18.61 | 18.62 | 14053022.0 |
| 2008-12-01 16:00:00 | MSFT | Stock | 18.62 | 20.22 | 18.61 | 18.67 | 7769023.0 |
| 2008-12-01 16:30:00 | MSFT | Stock | 18.67 | 19.222 | 18.61 | 18.62 | 89501.0 |
| 2008-12-01 17:00:00 | MSFT | Stock | 18.66 | 18.66 | 18.61 | 18.64 | 2366941.0 |
| 2008-12-01 17:30:00 | MSFT | Stock | 18.64 | 18.66 | 18.62 | 18.66 | 14898.0 |
| 2008-12-01 18:00:00 | MSFT | Stock | 18.68 | 20.16 | 18.63 | 20.16 | 221538.0 |
| 2008-12-01 18:30:00 | MSFT | Stock | 18.7 | 18.78 | 18.7 | 18.78 | 1330.0 |
> showing 50 of 70,274 rows — these rows as CSV