PREVIEW / stock_30min / 2009-10-09
file: by_date/stock_30min/2009/2009-10-09.parquet size: 1.3 MB rows: 70,326 symbols: 3,381
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-10-09 04:30:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 2800.0 |
| 2009-10-09 06:00:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 6020.0 |
| 2009-10-09 06:30:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 2800.0 |
| 2009-10-09 07:00:00 | AAPL | Stock | 6.7714 | 6.7714 | 6.7714 | 6.7714 | 2800.0 |
| 2009-10-09 07:30:00 | AAPL | Stock | 6.7711 | 6.7721 | 6.7679 | 6.7714 | 28000.0 |
| 2009-10-09 08:00:00 | AAPL | Stock | 6.7718 | 6.7732 | 6.7375 | 6.7446 | 638316.0 |
| 2009-10-09 08:30:00 | AAPL | Stock | 6.7414 | 6.7482 | 6.7332 | 6.7429 | 454384.0 |
| 2009-10-09 09:00:00 | AAPL | Stock | 6.7429 | 6.7604 | 6.7325 | 6.7464 | 617708.0 |
| 2009-10-09 09:30:00 | AAPL | Stock | 6.7489 | 6.8107 | 6.7364 | 6.7929 | 60958044.0 |
| 2009-10-09 10:00:00 | AAPL | Stock | 6.7929 | 6.8054 | 6.7757 | 6.7943 | 31308116.0 |
| 2009-10-09 10:30:00 | AAPL | Stock | 6.7946 | 6.8032 | 6.7821 | 6.7829 | 17675448.0 |
| 2009-10-09 11:00:00 | AAPL | Stock | 6.7829 | 6.7968 | 6.78 | 6.7904 | 16813552.0 |
| 2009-10-09 11:30:00 | AAPL | Stock | 6.79 | 6.7911 | 6.7679 | 6.7679 | 15457932.0 |
| 2009-10-09 12:00:00 | AAPL | Stock | 6.7679 | 6.775 | 6.7629 | 6.771 | 15436568.0 |
| 2009-10-09 12:30:00 | AAPL | Stock | 6.7709 | 6.78 | 6.7614 | 6.7789 | 12777940.0 |
| 2009-10-09 13:00:00 | AAPL | Stock | 6.7782 | 6.7929 | 6.7768 | 6.7893 | 12558168.0 |
| 2009-10-09 13:30:00 | AAPL | Stock | 6.79 | 6.7925 | 6.7771 | 6.7849 | 11786768.0 |
| 2009-10-09 14:00:00 | AAPL | Stock | 6.785 | 6.7929 | 6.775 | 6.7879 | 14640052.0 |
| 2009-10-09 14:30:00 | AAPL | Stock | 6.7879 | 6.7979 | 6.7821 | 6.7925 | 11659256.0 |
| 2009-10-09 15:00:00 | AAPL | Stock | 6.7925 | 6.7986 | 6.7864 | 6.7915 | 20096944.0 |
| 2009-10-09 15:30:00 | AAPL | Stock | 6.7918 | 6.8021 | 6.7821 | 6.8018 | 34187020.0 |
| 2009-10-09 16:00:00 | AAPL | Stock | 6.8011 | 6.8026 | 6.7596 | 6.8007 | 10774484.0 |
| 2009-10-09 16:30:00 | AAPL | Stock | 6.8018 | 6.8018 | 6.7866 | 6.8007 | 133560.0 |
| 2009-10-09 17:00:00 | AAPL | Stock | 6.7802 | 6.8007 | 6.7802 | 6.8007 | 96432.0 |
| 2009-10-09 17:30:00 | AAPL | Stock | 6.7996 | 6.8025 | 6.7996 | 6.7996 | 109032.0 |
| 2009-10-09 18:00:00 | AAPL | Stock | 6.7982 | 6.8036 | 6.7982 | 6.8032 | 224056.0 |
| 2009-10-09 18:30:00 | AAPL | Stock | 6.8025 | 6.8032 | 6.8018 | 6.8018 | 38304.0 |
| 2009-10-09 19:00:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.8036 | 6.8036 | 4004.0 |
| 2009-10-09 19:30:00 | AAPL | Stock | 6.8036 | 6.805 | 6.8018 | 6.805 | 61208.0 |
| 2009-10-09 07:00:00 | MSFT | Stock | 25.85 | 25.85 | 25.78 | 25.8 | 400.0 |
| 2009-10-09 07:30:00 | MSFT | Stock | 25.8 | 25.8 | 25.77 | 25.77 | 1300.0 |
| 2009-10-09 08:00:00 | MSFT | Stock | 25.77 | 25.8 | 25.66 | 25.66 | 47926.0 |
| 2009-10-09 08:30:00 | MSFT | Stock | 25.66 | 25.68 | 25.6 | 25.6 | 12436.0 |
| 2009-10-09 09:00:00 | MSFT | Stock | 25.62 | 25.63 | 25.54 | 25.57 | 15040.0 |
| 2009-10-09 09:30:00 | MSFT | Stock | 25.57 | 25.79 | 25.53 | 25.733 | 4476056.0 |
| 2009-10-09 10:00:00 | MSFT | Stock | 25.73 | 25.74 | 25.58 | 25.59 | 3303193.0 |
| 2009-10-09 10:30:00 | MSFT | Stock | 25.59 | 25.6 | 25.47 | 25.54 | 4057993.0 |
| 2009-10-09 11:00:00 | MSFT | Stock | 25.54 | 25.67 | 25.52 | 25.643 | 2618359.0 |
| 2009-10-09 11:30:00 | MSFT | Stock | 25.64 | 25.69 | 25.61 | 25.665 | 1843209.0 |
| 2009-10-09 12:00:00 | MSFT | Stock | 25.67 | 25.68 | 25.57 | 25.57 | 1578805.0 |
| 2009-10-09 12:30:00 | MSFT | Stock | 25.58 | 25.6 | 25.53 | 25.545 | 1264274.0 |
| 2009-10-09 13:00:00 | MSFT | Stock | 25.545 | 25.6 | 25.54 | 25.59 | 1058225.0 |
| 2009-10-09 13:30:00 | MSFT | Stock | 25.58 | 25.59 | 25.47 | 25.492 | 1842953.0 |
| 2009-10-09 14:00:00 | MSFT | Stock | 25.5 | 25.52 | 25.46 | 25.5 | 1391699.0 |
| 2009-10-09 14:30:00 | MSFT | Stock | 25.49 | 25.56 | 25.49 | 25.557 | 1746871.0 |
| 2009-10-09 15:00:00 | MSFT | Stock | 25.55 | 25.6 | 25.54 | 25.56 | 3325551.0 |
| 2009-10-09 15:30:00 | MSFT | Stock | 25.55 | 25.58 | 25.52 | 25.58 | 4464870.0 |
| 2009-10-09 16:00:00 | MSFT | Stock | 25.57 | 25.67 | 25.5 | 25.57 | 4847207.0 |
| 2009-10-09 16:30:00 | MSFT | Stock | 25.6 | 25.6 | 25.56 | 25.56 | 2395.0 |
| 2009-10-09 17:00:00 | MSFT | Stock | 25.56 | 25.56 | 25.56 | 25.56 | 140.0 |
> showing 50 of 70,326 rows — these rows as CSV