PREVIEW / stock_30min / 2008-10-21
file: by_date/stock_30min/2008/2008-10-21.parquet size: 1.2 MB rows: 69,174 symbols: 3,339
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-21 04:30:00 | AAPL | Stock | 3.4675 | 3.4675 | 3.4675 | 3.4675 | 5600.0 |
| 2008-10-21 05:30:00 | AAPL | Stock | 3.4768 | 3.4768 | 3.4768 | 3.4768 | 2800.0 |
| 2008-10-21 06:00:00 | AAPL | Stock | 3.4846 | 3.5118 | 3.4846 | 3.5118 | 26600.0 |
| 2008-10-21 07:00:00 | AAPL | Stock | 3.5 | 3.5107 | 3.4571 | 3.4804 | 107436.0 |
| 2008-10-21 07:30:00 | AAPL | Stock | 3.4814 | 3.4814 | 3.4643 | 3.4786 | 466900.0 |
| 2008-10-21 08:00:00 | AAPL | Stock | 3.4786 | 3.5204 | 3.4686 | 3.4836 | 2426424.0 |
| 2008-10-21 08:30:00 | AAPL | Stock | 3.4836 | 3.4993 | 3.4386 | 3.4557 | 3478384.0 |
| 2008-10-21 09:00:00 | AAPL | Stock | 3.4593 | 3.4786 | 3.4407 | 3.4618 | 2823548.0 |
| 2008-10-21 09:30:00 | AAPL | Stock | 3.4593 | 3.4643 | 3.4107 | 3.4607 | 176761508.0 |
| 2008-10-21 10:00:00 | AAPL | Stock | 3.4604 | 3.4964 | 3.4375 | 3.4379 | 137287976.0 |
| 2008-10-21 10:30:00 | AAPL | Stock | 3.4393 | 3.4432 | 3.3939 | 3.3971 | 116378304.0 |
| 2008-10-21 11:00:00 | AAPL | Stock | 3.3975 | 3.4211 | 3.375 | 3.3864 | 101135944.0 |
| 2008-10-21 11:30:00 | AAPL | Stock | 3.3864 | 3.4161 | 3.3511 | 3.3546 | 105806176.0 |
| 2008-10-21 12:00:00 | AAPL | Stock | 3.3546 | 3.3621 | 3.3071 | 3.3143 | 131362168.0 |
| 2008-10-21 12:30:00 | AAPL | Stock | 3.315 | 3.3375 | 3.2896 | 3.2936 | 107999416.0 |
| 2008-10-21 13:00:00 | AAPL | Stock | 3.2936 | 3.3571 | 3.2932 | 3.3414 | 83892228.0 |
| 2008-10-21 13:30:00 | AAPL | Stock | 3.3418 | 3.3646 | 3.3229 | 3.3375 | 81794468.0 |
| 2008-10-21 14:00:00 | AAPL | Stock | 3.3368 | 3.3746 | 3.3361 | 3.3654 | 108226888.0 |
| 2008-10-21 14:30:00 | AAPL | Stock | 3.3646 | 3.3675 | 3.3286 | 3.3375 | 128619204.0 |
| 2008-10-21 15:00:00 | AAPL | Stock | 3.3371 | 3.3632 | 3.2875 | 3.3007 | 195703200.0 |
| 2008-10-21 15:30:00 | AAPL | Stock | 3.3006 | 3.3118 | 3.2557 | 3.2632 | 258248648.0 |
| 2008-10-21 16:00:00 | AAPL | Stock | 3.2639 | 3.3643 | 3.25 | 3.3096 | 29309588.0 |
| 2008-10-21 16:30:00 | AAPL | Stock | 3.31 | 3.3746 | 3.3039 | 3.3329 | 3073756.0 |
| 2008-10-21 17:00:00 | AAPL | Stock | 3.2143 | 3.5161 | 3.0357 | 3.5046 | 202794004.0 |
| 2008-10-21 17:30:00 | AAPL | Stock | 3.5071 | 3.6846 | 3.3446 | 3.6468 | 117502756.0 |
| 2008-10-21 18:00:00 | AAPL | Stock | 3.65 | 3.6911 | 3.6339 | 3.6771 | 35171808.0 |
| 2008-10-21 18:30:00 | AAPL | Stock | 3.6764 | 3.7132 | 3.6518 | 3.7107 | 17973536.0 |
| 2008-10-21 19:00:00 | AAPL | Stock | 3.7086 | 3.7461 | 3.7018 | 3.7332 | 8310624.0 |
| 2008-10-21 19:30:00 | AAPL | Stock | 3.7357 | 3.7493 | 3.6971 | 3.7004 | 6139812.0 |
| 2008-10-21 07:30:00 | MSFT | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 1000.0 |
| 2008-10-21 08:00:00 | MSFT | Stock | 24.55 | 24.67 | 24.35 | 24.35 | 7607.0 |
| 2008-10-21 08:30:00 | MSFT | Stock | 24.38 | 24.38 | 24.35 | 24.35 | 2370.0 |
| 2008-10-21 09:00:00 | MSFT | Stock | 24.3 | 24.39 | 24.22 | 24.31 | 50369.0 |
| 2008-10-21 09:30:00 | MSFT | Stock | 24.31 | 24.58 | 24.3 | 24.54 | 7061862.0 |
| 2008-10-21 10:00:00 | MSFT | Stock | 24.53 | 25.01 | 24.52 | 24.78 | 8973658.0 |
| 2008-10-21 10:30:00 | MSFT | Stock | 24.77 | 24.77 | 24.51 | 24.52 | 6073263.0 |
| 2008-10-21 11:00:00 | MSFT | Stock | 24.52 | 24.591 | 24.38 | 24.58 | 5717727.0 |
| 2008-10-21 11:30:00 | MSFT | Stock | 24.58 | 24.82 | 24.2 | 24.23 | 7263246.0 |
| 2008-10-21 12:00:00 | MSFT | Stock | 24.23 | 24.55 | 23.91 | 24.05 | 7832249.0 |
| 2008-10-21 12:30:00 | MSFT | Stock | 24.05 | 24.24 | 23.83 | 23.84 | 4567043.0 |
| 2008-10-21 13:00:00 | MSFT | Stock | 23.84 | 24.22 | 23.83 | 24.11 | 4809074.0 |
| 2008-10-21 13:30:00 | MSFT | Stock | 24.118 | 24.18 | 23.94 | 24.06 | 4265752.0 |
| 2008-10-21 14:00:00 | MSFT | Stock | 24.065 | 24.242 | 24.03 | 24.21 | 4274267.0 |
| 2008-10-21 14:30:00 | MSFT | Stock | 24.217 | 24.4 | 24.05 | 24.18 | 7894103.0 |
| 2008-10-21 15:00:00 | MSFT | Stock | 24.18 | 24.44 | 23.83 | 23.84 | 9064861.0 |
| 2008-10-21 15:30:00 | MSFT | Stock | 23.84 | 23.92 | 23.27 | 23.34 | 17909287.0 |
| 2008-10-21 16:00:00 | MSFT | Stock | 23.34 | 24.739 | 23.31 | 23.36 | 3342229.0 |
| 2008-10-21 16:30:00 | MSFT | Stock | 23.52 | 23.55 | 23.2 | 23.25 | 99860.0 |
| 2008-10-21 17:00:00 | MSFT | Stock | 23.25 | 23.75 | 23.21 | 23.74 | 186632.0 |
| 2008-10-21 17:30:00 | MSFT | Stock | 23.75 | 23.99 | 23.65 | 23.85 | 52220.0 |
> showing 50 of 69,174 rows — these rows as CSV