PREVIEW / stock_30min / 2009-05-14
file: by_date/stock_30min/2009/2009-05-14.parquet size: 1.3 MB rows: 71,262 symbols: 3,312
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-05-14 07:00:00 | AAPL | Stock | 4.2532 | 4.2532 | 4.2496 | 4.2496 | 36400.0 |
| 2009-05-14 07:30:00 | AAPL | Stock | 4.2496 | 4.2857 | 4.2496 | 4.2857 | 142100.0 |
| 2009-05-14 08:00:00 | AAPL | Stock | 4.2707 | 4.2768 | 4.2589 | 4.2607 | 447440.0 |
| 2009-05-14 08:30:00 | AAPL | Stock | 4.2636 | 4.2761 | 4.25 | 4.2643 | 1406524.0 |
| 2009-05-14 09:00:00 | AAPL | Stock | 4.2654 | 4.2921 | 4.2614 | 4.2768 | 1688848.0 |
| 2009-05-14 09:30:00 | AAPL | Stock | 4.2768 | 4.3168 | 4.275 | 4.3109 | 68453112.0 |
| 2009-05-14 10:00:00 | AAPL | Stock | 4.3118 | 4.35 | 4.31 | 4.3361 | 55343988.0 |
| 2009-05-14 10:30:00 | AAPL | Stock | 4.3361 | 4.3482 | 4.3296 | 4.3461 | 26328456.0 |
| 2009-05-14 11:00:00 | AAPL | Stock | 4.3461 | 4.3739 | 4.3439 | 4.3629 | 29894452.0 |
| 2009-05-14 11:30:00 | AAPL | Stock | 4.3625 | 4.3696 | 4.3464 | 4.3696 | 20451536.0 |
| 2009-05-14 12:00:00 | AAPL | Stock | 4.3689 | 4.3914 | 4.3661 | 4.3804 | 25412968.0 |
| 2009-05-14 12:30:00 | AAPL | Stock | 4.3804 | 4.3889 | 4.3779 | 4.3814 | 14512400.0 |
| 2009-05-14 13:00:00 | AAPL | Stock | 4.3811 | 4.3875 | 4.3464 | 4.3775 | 17895220.0 |
| 2009-05-14 13:30:00 | AAPL | Stock | 4.3775 | 4.3896 | 4.3746 | 4.3789 | 13014036.0 |
| 2009-05-14 14:00:00 | AAPL | Stock | 4.3786 | 4.3946 | 4.3779 | 4.39 | 21153356.0 |
| 2009-05-14 14:30:00 | AAPL | Stock | 4.3907 | 4.4118 | 4.3886 | 4.4004 | 30154684.0 |
| 2009-05-14 15:00:00 | AAPL | Stock | 4.4007 | 4.41 | 4.3907 | 4.4032 | 30359756.0 |
| 2009-05-14 15:30:00 | AAPL | Stock | 4.4032 | 4.4068 | 4.3796 | 4.3911 | 58065252.0 |
| 2009-05-14 16:00:00 | AAPL | Stock | 4.3875 | 4.3979 | 4.3592 | 4.3889 | 22644048.0 |
| 2009-05-14 16:30:00 | AAPL | Stock | 4.3911 | 4.395 | 4.3911 | 4.3911 | 429352.0 |
| 2009-05-14 17:00:00 | AAPL | Stock | 4.3911 | 4.3929 | 4.3893 | 4.3893 | 44800.0 |
| 2009-05-14 17:30:00 | AAPL | Stock | 4.3889 | 4.3929 | 4.3886 | 4.3904 | 64400.0 |
| 2009-05-14 18:00:00 | AAPL | Stock | 4.3904 | 4.395 | 4.3904 | 4.3946 | 1510852.0 |
| 2009-05-14 18:30:00 | AAPL | Stock | 4.3932 | 4.3961 | 4.3932 | 4.3961 | 12600.0 |
| 2009-05-14 19:00:00 | AAPL | Stock | 4.3946 | 4.3946 | 4.3911 | 4.3911 | 16800.0 |
| 2009-05-14 19:30:00 | AAPL | Stock | 4.3907 | 4.3911 | 4.3907 | 4.3911 | 54740.0 |
| 2009-05-14 08:00:00 | MSFT | Stock | 19.7 | 19.75 | 19.7 | 19.75 | 2941.0 |
| 2009-05-14 08:30:00 | MSFT | Stock | 19.7 | 19.75 | 19.65 | 19.75 | 8383.0 |
| 2009-05-14 09:00:00 | MSFT | Stock | 19.74 | 19.85 | 19.68 | 19.83 | 34776.0 |
| 2009-05-14 09:30:00 | MSFT | Stock | 19.83 | 20.0 | 19.8 | 19.93 | 5564720.0 |
| 2009-05-14 10:00:00 | MSFT | Stock | 19.93 | 19.99 | 19.9 | 19.92 | 3083272.0 |
| 2009-05-14 10:30:00 | MSFT | Stock | 19.93 | 19.97 | 19.83 | 19.878 | 3837714.0 |
| 2009-05-14 11:00:00 | MSFT | Stock | 19.88 | 20.0 | 19.87 | 19.98 | 3795627.0 |
| 2009-05-14 11:30:00 | MSFT | Stock | 19.98 | 20.04 | 19.96 | 20.008 | 2459937.0 |
| 2009-05-14 12:00:00 | MSFT | Stock | 20.01 | 20.06 | 19.97 | 19.99 | 1826585.0 |
| 2009-05-14 12:30:00 | MSFT | Stock | 19.99 | 20.03 | 19.97 | 20.0 | 1565672.0 |
| 2009-05-14 13:00:00 | MSFT | Stock | 20.01 | 20.03 | 19.95 | 19.97 | 1540703.0 |
| 2009-05-14 13:30:00 | MSFT | Stock | 19.98 | 20.03 | 19.94 | 19.98 | 1416102.0 |
| 2009-05-14 14:00:00 | MSFT | Stock | 19.99 | 20.13 | 19.98 | 20.11 | 3777467.0 |
| 2009-05-14 14:30:00 | MSFT | Stock | 20.12 | 20.22 | 20.07 | 20.202 | 5604150.0 |
| 2009-05-14 15:00:00 | MSFT | Stock | 20.21 | 20.23 | 20.18 | 20.19 | 4169640.0 |
| 2009-05-14 15:30:00 | MSFT | Stock | 20.195 | 20.21 | 20.02 | 20.02 | 8963262.0 |
| 2009-05-14 16:00:00 | MSFT | Stock | 20.02 | 20.08 | 19.98 | 20.0 | 5974150.0 |
| 2009-05-14 16:30:00 | MSFT | Stock | 20.09 | 20.09 | 20.01 | 20.06 | 52198.0 |
| 2009-05-14 17:00:00 | MSFT | Stock | 20.01 | 20.01 | 20.01 | 20.01 | 1785.0 |
| 2009-05-14 17:30:00 | MSFT | Stock | 20.02 | 20.02 | 20.02 | 20.02 | 100.0 |
| 2009-05-14 18:00:00 | MSFT | Stock | 20.06 | 20.06 | 20.06 | 20.06 | 48173.0 |
| 2009-05-14 18:30:00 | MSFT | Stock | 20.05 | 20.05 | 20.05 | 20.05 | 1000.0 |
| 2009-05-14 19:00:00 | MSFT | Stock | 20.06 | 20.06 | 20.02 | 20.02 | 1300.0 |
| 2009-05-14 19:30:00 | MSFT | Stock | 20.03 | 20.04 | 20.02 | 20.02 | 3150.0 |
> showing 50 of 71,262 rows — these rows as CSV