PREVIEW / stock_30min / 2009-01-08
file: by_date/stock_30min/2009/2009-01-08.parquet size: 1.2 MB rows: 67,981 symbols: 3,295
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-01-08 07:00:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 11760.0 |
| 2009-01-08 07:30:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2161 | 3.2282 | 27692.0 |
| 2009-01-08 08:00:00 | AAPL | Stock | 3.2304 | 3.2304 | 3.2143 | 3.2157 | 899472.0 |
| 2009-01-08 08:30:00 | AAPL | Stock | 3.2168 | 3.2318 | 3.2161 | 3.2261 | 617904.0 |
| 2009-01-08 09:00:00 | AAPL | Stock | 3.2236 | 3.2396 | 3.2236 | 3.2321 | 294084.0 |
| 2009-01-08 09:30:00 | AAPL | Stock | 3.2321 | 3.2757 | 3.2286 | 3.2439 | 80751860.0 |
| 2009-01-08 10:00:00 | AAPL | Stock | 3.2439 | 3.2529 | 3.2157 | 3.2321 | 56030184.0 |
| 2009-01-08 10:30:00 | AAPL | Stock | 3.2318 | 3.26 | 3.2232 | 3.2564 | 52370024.0 |
| 2009-01-08 11:00:00 | AAPL | Stock | 3.2571 | 3.2679 | 3.2454 | 3.2457 | 37548140.0 |
| 2009-01-08 11:30:00 | AAPL | Stock | 3.2461 | 3.255 | 3.2339 | 3.2421 | 33562564.0 |
| 2009-01-08 12:00:00 | AAPL | Stock | 3.2425 | 3.2568 | 3.2379 | 3.2475 | 20248648.0 |
| 2009-01-08 12:30:00 | AAPL | Stock | 3.2475 | 3.2793 | 3.2439 | 3.2721 | 36084412.0 |
| 2009-01-08 13:00:00 | AAPL | Stock | 3.2716 | 3.2746 | 3.2446 | 3.2532 | 35727860.0 |
| 2009-01-08 13:30:00 | AAPL | Stock | 3.2539 | 3.2732 | 3.2468 | 3.2661 | 30599940.0 |
| 2009-01-08 14:00:00 | AAPL | Stock | 3.2657 | 3.3014 | 3.2611 | 3.2946 | 54143040.0 |
| 2009-01-08 14:30:00 | AAPL | Stock | 3.2946 | 3.3236 | 3.28 | 3.3157 | 67301556.0 |
| 2009-01-08 15:00:00 | AAPL | Stock | 3.3157 | 3.3268 | 3.2929 | 3.3025 | 61156732.0 |
| 2009-01-08 15:30:00 | AAPL | Stock | 3.3025 | 3.3164 | 3.2871 | 3.3143 | 79514316.0 |
| 2009-01-08 16:00:00 | AAPL | Stock | 3.3143 | 3.3207 | 3.2708 | 3.3179 | 7395304.0 |
| 2009-01-08 16:30:00 | AAPL | Stock | 3.2774 | 3.32 | 3.2774 | 3.32 | 399896.0 |
| 2009-01-08 17:00:00 | AAPL | Stock | 3.3186 | 3.3186 | 3.3164 | 3.3168 | 175728.0 |
| 2009-01-08 17:30:00 | AAPL | Stock | 3.3186 | 3.3186 | 3.3107 | 3.3175 | 6789860.0 |
| 2009-01-08 18:00:00 | AAPL | Stock | 3.3164 | 3.3164 | 3.3107 | 3.3161 | 3650388.0 |
| 2009-01-08 18:30:00 | AAPL | Stock | 3.3157 | 3.3161 | 3.3157 | 3.3161 | 57456.0 |
| 2009-01-08 19:00:00 | AAPL | Stock | 3.3143 | 3.3171 | 3.3139 | 3.3171 | 87780.0 |
| 2009-01-08 19:30:00 | AAPL | Stock | 3.3179 | 3.3211 | 3.3179 | 3.3196 | 110880.0 |
| 2009-01-08 07:30:00 | MSFT | Stock | 19.44 | 19.45 | 19.44 | 19.45 | 800.0 |
| 2009-01-08 08:00:00 | MSFT | Stock | 19.49 | 19.57 | 19.36 | 19.37 | 33321.0 |
| 2009-01-08 08:30:00 | MSFT | Stock | 19.44 | 19.6 | 19.42 | 19.52 | 100092.0 |
| 2009-01-08 09:00:00 | MSFT | Stock | 19.55 | 19.75 | 19.53 | 19.64 | 117036.0 |
| 2009-01-08 09:30:00 | MSFT | Stock | 19.64 | 19.8 | 19.55 | 19.66 | 7822566.0 |
| 2009-01-08 10:00:00 | MSFT | Stock | 19.66 | 19.94 | 19.65 | 19.82 | 10115020.0 |
| 2009-01-08 10:30:00 | MSFT | Stock | 19.82 | 19.99 | 19.82 | 19.93 | 4913162.0 |
| 2009-01-08 11:00:00 | MSFT | Stock | 19.93 | 19.99 | 19.88 | 19.9 | 3337340.0 |
| 2009-01-08 11:30:00 | MSFT | Stock | 19.9 | 19.99 | 19.86 | 19.93 | 2326627.0 |
| 2009-01-08 12:00:00 | MSFT | Stock | 19.93 | 20.07 | 19.7 | 20.018 | 3370041.0 |
| 2009-01-08 12:30:00 | MSFT | Stock | 20.028 | 20.11 | 19.9 | 20.01 | 3094348.0 |
| 2009-01-08 13:00:00 | MSFT | Stock | 20.01 | 20.02 | 19.8 | 19.85 | 2841816.0 |
| 2009-01-08 13:30:00 | MSFT | Stock | 19.84 | 19.97 | 19.81 | 19.88 | 1571349.0 |
| 2009-01-08 14:00:00 | MSFT | Stock | 19.88 | 20.06 | 19.87 | 19.98 | 2639345.0 |
| 2009-01-08 14:30:00 | MSFT | Stock | 19.98 | 20.16 | 19.94 | 20.13 | 3976190.0 |
| 2009-01-08 15:00:00 | MSFT | Stock | 20.13 | 20.16 | 19.91 | 19.92 | 5732765.0 |
| 2009-01-08 15:30:00 | MSFT | Stock | 19.92 | 20.19 | 19.87 | 20.12 | 12133656.0 |
| 2009-01-08 16:00:00 | MSFT | Stock | 20.12 | 20.12 | 19.79 | 20.05 | 4911781.0 |
| 2009-01-08 16:30:00 | MSFT | Stock | 20.05 | 20.12 | 19.97 | 20.05 | 149565.0 |
| 2009-01-08 17:00:00 | MSFT | Stock | 20.09 | 20.12 | 20.09 | 20.12 | 2200.0 |
| 2009-01-08 17:30:00 | MSFT | Stock | 20.12 | 20.13 | 20.12 | 20.13 | 593900.0 |
| 2009-01-08 18:00:00 | MSFT | Stock | 19.9 | 20.13 | 19.9 | 20.1 | 20562.0 |
| 2009-01-08 18:30:00 | MSFT | Stock | 20.12 | 20.12 | 20.05 | 20.11 | 1729.0 |
| 2009-01-08 19:00:00 | MSFT | Stock | 20.12 | 20.13 | 20.06 | 20.06 | 483.0 |
> showing 50 of 67,981 rows — these rows as CSV