PREVIEW / stock_30min / 2009-11-10
file: by_date/stock_30min/2009/2009-11-10.parquet size: 1.3 MB rows: 71,504 symbols: 3,411
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-11-10 05:00:00 | AAPL | Stock | 7.1918 | 7.1918 | 7.1811 | 7.1811 | 5600.0 |
| 2009-11-10 07:00:00 | AAPL | Stock | 7.1825 | 7.1925 | 7.1811 | 7.1925 | 25200.0 |
| 2009-11-10 07:30:00 | AAPL | Stock | 7.1982 | 7.1982 | 7.1807 | 7.1807 | 45836.0 |
| 2009-11-10 08:00:00 | AAPL | Stock | 7.1929 | 7.1948 | 7.1721 | 7.1925 | 606508.0 |
| 2009-11-10 08:30:00 | AAPL | Stock | 7.1832 | 7.1911 | 7.18 | 7.1829 | 362376.0 |
| 2009-11-10 09:00:00 | AAPL | Stock | 7.1829 | 7.1943 | 7.175 | 7.1811 | 782516.0 |
| 2009-11-10 09:30:00 | AAPL | Stock | 7.1818 | 7.3207 | 7.1789 | 7.2539 | 90805260.0 |
| 2009-11-10 10:00:00 | AAPL | Stock | 7.2532 | 7.2668 | 7.2279 | 7.2643 | 39502596.0 |
| 2009-11-10 10:30:00 | AAPL | Stock | 7.2654 | 7.2679 | 7.1982 | 7.2129 | 45046428.0 |
| 2009-11-10 11:00:00 | AAPL | Stock | 7.2126 | 7.2221 | 7.1789 | 7.205 | 31411184.0 |
| 2009-11-10 11:30:00 | AAPL | Stock | 7.2036 | 7.2086 | 7.1836 | 7.2018 | 16032436.0 |
| 2009-11-10 12:00:00 | AAPL | Stock | 7.2018 | 7.2139 | 7.1886 | 7.1904 | 17365320.0 |
| 2009-11-10 12:30:00 | AAPL | Stock | 7.1889 | 7.2193 | 7.1886 | 7.2189 | 13059760.0 |
| 2009-11-10 13:00:00 | AAPL | Stock | 7.2186 | 7.2361 | 7.2154 | 7.2357 | 16953356.0 |
| 2009-11-10 13:30:00 | AAPL | Stock | 7.2349 | 7.2482 | 7.2289 | 7.248 | 17460772.0 |
| 2009-11-10 14:00:00 | AAPL | Stock | 7.2468 | 7.2554 | 7.2382 | 7.2504 | 20790196.0 |
| 2009-11-10 14:30:00 | AAPL | Stock | 7.2514 | 7.2607 | 7.2411 | 7.2493 | 19787236.0 |
| 2009-11-10 15:00:00 | AAPL | Stock | 7.2496 | 7.26 | 7.2432 | 7.2561 | 18376008.0 |
| 2009-11-10 15:30:00 | AAPL | Stock | 7.2555 | 7.2564 | 7.2221 | 7.2493 | 38551464.0 |
| 2009-11-10 16:00:00 | AAPL | Stock | 7.2493 | 7.2498 | 7.2338 | 7.2496 | 4579596.0 |
| 2009-11-10 16:30:00 | AAPL | Stock | 7.2471 | 7.25 | 7.2457 | 7.2464 | 150948.0 |
| 2009-11-10 17:00:00 | AAPL | Stock | 7.2464 | 7.2493 | 7.245 | 7.2493 | 82516.0 |
| 2009-11-10 17:30:00 | AAPL | Stock | 7.25 | 7.2521 | 7.25 | 7.25 | 77812.0 |
| 2009-11-10 18:00:00 | AAPL | Stock | 7.25 | 7.2518 | 7.2493 | 7.2518 | 319228.0 |
| 2009-11-10 18:30:00 | AAPL | Stock | 7.2518 | 7.2536 | 7.2504 | 7.2504 | 34496.0 |
| 2009-11-10 19:00:00 | AAPL | Stock | 7.2529 | 7.2614 | 7.2529 | 7.2614 | 230412.0 |
| 2009-11-10 19:30:00 | AAPL | Stock | 7.26 | 7.2625 | 7.2589 | 7.26 | 98980.0 |
| 2009-11-10 07:00:00 | MSFT | Stock | 28.85 | 28.85 | 28.85 | 28.85 | 740.0 |
| 2009-11-10 07:30:00 | MSFT | Stock | 28.85 | 28.97 | 28.85 | 28.87 | 2041.0 |
| 2009-11-10 08:00:00 | MSFT | Stock | 28.9 | 28.97 | 28.81 | 28.9 | 7119.0 |
| 2009-11-10 08:30:00 | MSFT | Stock | 28.9 | 28.9 | 28.89 | 28.89 | 944.0 |
| 2009-11-10 09:00:00 | MSFT | Stock | 28.9 | 28.9 | 28.84 | 28.89 | 16256.0 |
| 2009-11-10 09:30:00 | MSFT | Stock | 28.89 | 29.25 | 28.84 | 29.243 | 11135806.0 |
| 2009-11-10 10:00:00 | MSFT | Stock | 29.241 | 29.28 | 29.1 | 29.12 | 5532911.0 |
| 2009-11-10 10:30:00 | MSFT | Stock | 29.122 | 29.16 | 28.98 | 28.993 | 6056126.0 |
| 2009-11-10 11:00:00 | MSFT | Stock | 28.993 | 29.1 | 28.97 | 29.1 | 3863106.0 |
| 2009-11-10 11:30:00 | MSFT | Stock | 29.09 | 29.12 | 28.94 | 28.95 | 3435971.0 |
| 2009-11-10 12:00:00 | MSFT | Stock | 28.95 | 29.0 | 28.87 | 28.87 | 3965210.0 |
| 2009-11-10 12:30:00 | MSFT | Stock | 28.87 | 28.94 | 28.81 | 28.938 | 2704100.0 |
| 2009-11-10 13:00:00 | MSFT | Stock | 28.94 | 28.96 | 28.87 | 28.9 | 2467831.0 |
| 2009-11-10 13:30:00 | MSFT | Stock | 28.9 | 29.02 | 28.89 | 28.995 | 4331611.0 |
| 2009-11-10 14:00:00 | MSFT | Stock | 28.992 | 29.04 | 28.96 | 29.02 | 4170869.0 |
| 2009-11-10 14:30:00 | MSFT | Stock | 29.01 | 29.05 | 28.97 | 28.998 | 3280994.0 |
| 2009-11-10 15:00:00 | MSFT | Stock | 28.99 | 29.01 | 28.95 | 28.97 | 4729883.0 |
| 2009-11-10 15:30:00 | MSFT | Stock | 28.98 | 29.0 | 28.9 | 29.0 | 6662985.0 |
| 2009-11-10 16:00:00 | MSFT | Stock | 29.0 | 29.024 | 28.9 | 28.96 | 1774938.0 |
| 2009-11-10 16:30:00 | MSFT | Stock | 28.98 | 29.023 | 28.868 | 28.98 | 743050.0 |
| 2009-11-10 17:00:00 | MSFT | Stock | 28.99 | 29.044 | 28.97 | 29.01 | 41217.0 |
| 2009-11-10 17:30:00 | MSFT | Stock | 28.98 | 29.0 | 28.97 | 29.0 | 6695.0 |
| 2009-11-10 18:00:00 | MSFT | Stock | 28.98 | 29.02 | 28.98 | 29.01 | 26450.0 |
> showing 50 of 71,504 rows — these rows as CSV