PREVIEW / stock_30min / 2007-02-22
file: by_date/stock_30min/2007/2007-02-22.parquet size: 996 KB rows: 54,125 symbols: 2,525
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-22 04:00:00 | AAPL | Stock | 3.1964 | 3.2 | 3.1964 | 3.2 | 27440.0 |
| 2007-02-22 04:30:00 | AAPL | Stock | 3.2 | 3.2 | 3.2 | 3.2 | 39200.0 |
| 2007-02-22 05:00:00 | AAPL | Stock | 3.2007 | 3.2007 | 3.2 | 3.2 | 14000.0 |
| 2007-02-22 06:30:00 | AAPL | Stock | 3.2036 | 3.2071 | 3.2036 | 3.2071 | 98000.0 |
| 2007-02-22 07:00:00 | AAPL | Stock | 3.2071 | 3.2139 | 3.2018 | 3.2071 | 236880.0 |
| 2007-02-22 07:30:00 | AAPL | Stock | 3.2007 | 3.2211 | 3.2 | 3.2071 | 1339940.0 |
| 2007-02-22 08:00:00 | AAPL | Stock | 3.2082 | 3.2429 | 3.2036 | 3.235 | 11354812.0 |
| 2007-02-22 08:30:00 | AAPL | Stock | 3.235 | 3.2375 | 3.2254 | 3.2304 | 5008220.0 |
| 2007-02-22 09:00:00 | AAPL | Stock | 3.2304 | 3.2432 | 3.2293 | 3.2429 | 6415164.0 |
| 2007-02-22 09:30:00 | AAPL | Stock | 3.2429 | 3.2432 | 3.1996 | 3.2021 | 196170576.0 |
| 2007-02-22 10:00:00 | AAPL | Stock | 3.2025 | 3.2225 | 3.1946 | 3.2029 | 114999528.0 |
| 2007-02-22 10:30:00 | AAPL | Stock | 3.2029 | 3.2225 | 3.1893 | 3.2082 | 75525940.0 |
| 2007-02-22 11:00:00 | AAPL | Stock | 3.2079 | 3.2082 | 3.1646 | 3.1714 | 82843432.0 |
| 2007-02-22 11:30:00 | AAPL | Stock | 3.1711 | 3.1857 | 3.1618 | 3.1825 | 72442356.0 |
| 2007-02-22 12:00:00 | AAPL | Stock | 3.1825 | 3.1925 | 3.1811 | 3.1914 | 42126476.0 |
| 2007-02-22 12:30:00 | AAPL | Stock | 3.1918 | 3.2214 | 3.1886 | 3.1939 | 32803624.0 |
| 2007-02-22 13:00:00 | AAPL | Stock | 3.1954 | 3.1982 | 3.185 | 3.1932 | 23757776.0 |
| 2007-02-22 13:30:00 | AAPL | Stock | 3.1929 | 3.1954 | 3.1861 | 3.1886 | 16186324.0 |
| 2007-02-22 14:00:00 | AAPL | Stock | 3.1886 | 3.195 | 3.1864 | 3.1936 | 16993564.0 |
| 2007-02-22 14:30:00 | AAPL | Stock | 3.1936 | 3.1946 | 3.175 | 3.1757 | 41281492.0 |
| 2007-02-22 15:00:00 | AAPL | Stock | 3.1754 | 3.1918 | 3.175 | 3.1875 | 32141480.0 |
| 2007-02-22 15:30:00 | AAPL | Stock | 3.1879 | 3.1968 | 3.1871 | 3.1968 | 55343008.0 |
| 2007-02-22 16:00:00 | AAPL | Stock | 3.1968 | 3.2054 | 3.1904 | 3.2054 | 3726688.0 |
| 2007-02-22 16:30:00 | AAPL | Stock | 3.2054 | 3.2054 | 3.1943 | 3.2 | 643552.0 |
| 2007-02-22 17:00:00 | AAPL | Stock | 3.1986 | 3.1996 | 3.1968 | 3.1996 | 180600.0 |
| 2007-02-22 17:30:00 | AAPL | Stock | 3.1968 | 3.2 | 3.1968 | 3.2 | 30520.0 |
| 2007-02-22 18:00:00 | AAPL | Stock | 3.2 | 3.2029 | 3.1989 | 3.2 | 139720.0 |
| 2007-02-22 18:30:00 | AAPL | Stock | 3.1982 | 3.2 | 3.1971 | 3.1971 | 104888.0 |
| 2007-02-22 19:00:00 | AAPL | Stock | 3.1982 | 3.1982 | 3.1975 | 3.1982 | 62720.0 |
| 2007-02-22 19:30:00 | AAPL | Stock | 3.1982 | 3.1982 | 3.1968 | 3.1968 | 74256.0 |
| 2007-02-22 07:30:00 | MSFT | Stock | 29.31 | 29.34 | 29.31 | 29.34 | 7300.0 |
| 2007-02-22 08:00:00 | MSFT | Stock | 29.3 | 29.31 | 29.23 | 29.25 | 54750.0 |
| 2007-02-22 08:30:00 | MSFT | Stock | 29.26 | 29.31 | 29.26 | 29.31 | 31170.0 |
| 2007-02-22 09:00:00 | MSFT | Stock | 29.31 | 29.32 | 29.28 | 29.3 | 38695.0 |
| 2007-02-22 09:30:00 | MSFT | Stock | 29.305 | 29.54 | 29.24 | 29.495 | 10328336.0 |
| 2007-02-22 10:00:00 | MSFT | Stock | 29.5 | 29.54 | 29.35 | 29.4 | 5819117.0 |
| 2007-02-22 10:30:00 | MSFT | Stock | 29.4 | 29.455 | 29.32 | 29.38 | 3670753.0 |
| 2007-02-22 11:00:00 | MSFT | Stock | 29.37 | 29.38 | 29.25 | 29.32 | 4476535.0 |
| 2007-02-22 11:30:00 | MSFT | Stock | 29.33 | 29.4 | 29.25 | 29.37 | 2670990.0 |
| 2007-02-22 12:00:00 | MSFT | Stock | 29.37 | 29.4 | 29.31 | 29.36 | 2043067.0 |
| 2007-02-22 12:30:00 | MSFT | Stock | 29.35 | 29.38 | 29.3 | 29.31 | 2481063.0 |
| 2007-02-22 13:00:00 | MSFT | Stock | 29.3 | 29.36 | 29.28 | 29.33 | 2985587.0 |
| 2007-02-22 13:30:00 | MSFT | Stock | 29.34 | 29.34 | 29.29 | 29.3 | 1572747.0 |
| 2007-02-22 14:00:00 | MSFT | Stock | 29.3 | 29.36 | 29.28 | 29.28 | 2295906.0 |
| 2007-02-22 14:30:00 | MSFT | Stock | 29.28 | 29.31 | 29.16 | 29.26 | 7716231.0 |
| 2007-02-22 15:00:00 | MSFT | Stock | 29.26 | 29.33 | 29.25 | 29.28 | 3235362.0 |
| 2007-02-22 15:30:00 | MSFT | Stock | 29.28 | 29.39 | 29.27 | 29.38 | 4314273.0 |
| 2007-02-22 16:00:00 | MSFT | Stock | 29.39 | 29.4 | 29.32 | 29.32 | 53751.0 |
| 2007-02-22 16:30:00 | MSFT | Stock | 29.32 | 29.39 | 29.32 | 29.32 | 429614.0 |
| 2007-02-22 17:00:00 | MSFT | Stock | 29.32 | 29.33 | 29.3 | 29.31 | 3705.0 |
> showing 50 of 54,125 rows — these rows as CSV