PREVIEW / stock_30min / 2010-07-28
file: by_date/stock_30min/2010/2010-07-28.parquet size: 1.3 MB rows: 71,427 symbols: 3,445
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-28 05:30:00 | AAPL | Stock | 9.4489 | 9.4489 | 9.4489 | 9.4489 | 2800.0 |
| 2010-07-28 07:00:00 | AAPL | Stock | 9.4071 | 9.425 | 9.3993 | 9.425 | 37800.0 |
| 2010-07-28 07:30:00 | AAPL | Stock | 9.4246 | 9.4464 | 9.4246 | 9.4461 | 216188.0 |
| 2010-07-28 08:00:00 | AAPL | Stock | 9.4457 | 9.4536 | 9.4296 | 9.4386 | 1880732.0 |
| 2010-07-28 08:30:00 | AAPL | Stock | 9.4321 | 9.4321 | 9.4 | 9.425 | 2049404.0 |
| 2010-07-28 09:00:00 | AAPL | Stock | 9.425 | 9.4261 | 9.4089 | 9.4157 | 852292.0 |
| 2010-07-28 09:30:00 | AAPL | Stock | 9.4164 | 9.4916 | 9.4107 | 9.4896 | 95317656.0 |
| 2010-07-28 10:00:00 | AAPL | Stock | 9.4889 | 9.4996 | 9.4314 | 9.4486 | 59500756.0 |
| 2010-07-28 10:30:00 | AAPL | Stock | 9.4482 | 9.4532 | 9.4139 | 9.4282 | 36211980.0 |
| 2010-07-28 11:00:00 | AAPL | Stock | 9.4265 | 9.435 | 9.3982 | 9.4154 | 30900212.0 |
| 2010-07-28 11:30:00 | AAPL | Stock | 9.4161 | 9.4329 | 9.3786 | 9.3907 | 29110340.0 |
| 2010-07-28 12:00:00 | AAPL | Stock | 9.3907 | 9.4071 | 9.3825 | 9.3918 | 16425472.0 |
| 2010-07-28 12:30:00 | AAPL | Stock | 9.3914 | 9.4036 | 9.3604 | 9.3779 | 22764924.0 |
| 2010-07-28 13:00:00 | AAPL | Stock | 9.3796 | 9.3875 | 9.3329 | 9.3439 | 28693112.0 |
| 2010-07-28 13:30:00 | AAPL | Stock | 9.3436 | 9.3436 | 9.3 | 9.3179 | 40408760.0 |
| 2010-07-28 14:00:00 | AAPL | Stock | 9.3179 | 9.3463 | 9.3 | 9.3234 | 41572440.0 |
| 2010-07-28 14:30:00 | AAPL | Stock | 9.3232 | 9.3389 | 9.3111 | 9.317 | 23076172.0 |
| 2010-07-28 15:00:00 | AAPL | Stock | 9.3232 | 9.3343 | 9.2946 | 9.3293 | 30969652.0 |
| 2010-07-28 15:30:00 | AAPL | Stock | 9.3293 | 9.3421 | 9.3204 | 9.3207 | 39187288.0 |
| 2010-07-28 16:00:00 | AAPL | Stock | 9.3243 | 9.4349 | 9.3143 | 9.3348 | 14285460.0 |
| 2010-07-28 16:30:00 | AAPL | Stock | 9.3143 | 9.3328 | 9.2857 | 9.2975 | 482580.0 |
| 2010-07-28 17:00:00 | AAPL | Stock | 9.426 | 9.426 | 9.2768 | 9.2857 | 506240.0 |
| 2010-07-28 17:30:00 | AAPL | Stock | 9.2857 | 9.2893 | 9.2782 | 9.2893 | 352044.0 |
| 2010-07-28 18:00:00 | AAPL | Stock | 9.2929 | 9.32 | 9.2929 | 9.3036 | 386708.0 |
| 2010-07-28 18:30:00 | AAPL | Stock | 9.3 | 9.3036 | 9.3 | 9.3036 | 6300.0 |
| 2010-07-28 19:00:00 | AAPL | Stock | 9.3064 | 9.3071 | 9.3004 | 9.3071 | 81648.0 |
| 2010-07-28 19:30:00 | AAPL | Stock | 9.3061 | 9.3061 | 9.2861 | 9.2961 | 163212.0 |
| 2010-07-28 07:30:00 | MSFT | Stock | 26.1 | 26.1 | 26.1 | 26.1 | 300.0 |
| 2010-07-28 08:00:00 | MSFT | Stock | 26.21 | 26.26 | 26.16 | 26.17 | 19824.0 |
| 2010-07-28 08:30:00 | MSFT | Stock | 26.16 | 26.16 | 26.0 | 26.03 | 22114.0 |
| 2010-07-28 09:00:00 | MSFT | Stock | 26.07 | 26.12 | 26.03 | 26.07 | 6508.0 |
| 2010-07-28 09:30:00 | MSFT | Stock | 26.09 | 26.14 | 26.02 | 26.04 | 4135485.0 |
| 2010-07-28 10:00:00 | MSFT | Stock | 26.04 | 26.06 | 25.83 | 25.89 | 6084008.0 |
| 2010-07-28 10:30:00 | MSFT | Stock | 25.89 | 25.91 | 25.83 | 25.88 | 4689173.0 |
| 2010-07-28 11:00:00 | MSFT | Stock | 25.88 | 25.995 | 25.84 | 25.942 | 3823846.0 |
| 2010-07-28 11:30:00 | MSFT | Stock | 25.95 | 26.06 | 25.91 | 26.05 | 5658126.0 |
| 2010-07-28 12:00:00 | MSFT | Stock | 26.05 | 26.06 | 26.0 | 26.045 | 2331937.0 |
| 2010-07-28 12:30:00 | MSFT | Stock | 26.045 | 26.15 | 26.01 | 26.145 | 2996140.0 |
| 2010-07-28 13:00:00 | MSFT | Stock | 26.145 | 26.19 | 26.01 | 26.03 | 3765721.0 |
| 2010-07-28 13:30:00 | MSFT | Stock | 26.021 | 26.04 | 25.95 | 26.02 | 2647766.0 |
| 2010-07-28 14:00:00 | MSFT | Stock | 26.011 | 26.08 | 25.97 | 26.0 | 2441223.0 |
| 2010-07-28 14:30:00 | MSFT | Stock | 25.99 | 26.03 | 25.95 | 25.98 | 3219067.0 |
| 2010-07-28 15:00:00 | MSFT | Stock | 25.98 | 25.98 | 25.87 | 25.95 | 6545563.0 |
| 2010-07-28 15:30:00 | MSFT | Stock | 25.95 | 26.02 | 25.9 | 25.95 | 7784799.0 |
| 2010-07-28 16:00:00 | MSFT | Stock | 25.948 | 25.99 | 25.89 | 25.98 | 12886969.0 |
| 2010-07-28 16:30:00 | MSFT | Stock | 25.95 | 26.03 | 25.93 | 26.03 | 86564.0 |
| 2010-07-28 17:00:00 | MSFT | Stock | 26.042 | 26.042 | 25.95 | 25.98 | 3318.0 |
| 2010-07-28 17:30:00 | MSFT | Stock | 25.98 | 25.98 | 25.95 | 25.95 | 4145.0 |
| 2010-07-28 18:00:00 | MSFT | Stock | 25.97 | 25.97 | 25.95 | 25.97 | 9803.0 |
| 2010-07-28 18:30:00 | MSFT | Stock | 25.97 | 25.97 | 25.97 | 25.97 | 1382.0 |
> showing 50 of 71,427 rows — these rows as CSV