PREVIEW / stock_30min / 2009-03-12
file: by_date/stock_30min/2009/2009-03-12.parquet size: 1.3 MB rows: 71,406 symbols: 3,318
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-03-12 04:00:00 | AAPL | Stock | 3.3186 | 3.3236 | 3.3186 | 3.3236 | 22400.0 |
| 2009-03-12 04:30:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.2946 | 3.2946 | 22400.0 |
| 2009-03-12 07:00:00 | AAPL | Stock | 3.2814 | 3.2839 | 3.2814 | 3.2839 | 18760.0 |
| 2009-03-12 07:30:00 | AAPL | Stock | 3.2929 | 3.2943 | 3.2886 | 3.2893 | 32788.0 |
| 2009-03-12 08:00:00 | AAPL | Stock | 3.3068 | 3.3107 | 3.2904 | 3.3107 | 253400.0 |
| 2009-03-12 08:30:00 | AAPL | Stock | 3.31 | 3.3321 | 3.3071 | 3.3139 | 825552.0 |
| 2009-03-12 09:00:00 | AAPL | Stock | 3.3161 | 3.3286 | 3.3125 | 3.3182 | 786968.0 |
| 2009-03-12 09:30:00 | AAPL | Stock | 3.3179 | 3.3661 | 3.2857 | 3.3107 | 101708152.0 |
| 2009-03-12 10:00:00 | AAPL | Stock | 3.3114 | 3.3518 | 3.2971 | 3.3296 | 70649684.0 |
| 2009-03-12 10:30:00 | AAPL | Stock | 3.3296 | 3.3536 | 3.3201 | 3.3496 | 35836052.0 |
| 2009-03-12 11:00:00 | AAPL | Stock | 3.35 | 3.36 | 3.3361 | 3.345 | 35500836.0 |
| 2009-03-12 11:30:00 | AAPL | Stock | 3.3457 | 3.3857 | 3.3371 | 3.3764 | 50715000.0 |
| 2009-03-12 12:00:00 | AAPL | Stock | 3.3764 | 3.4018 | 3.3704 | 3.3975 | 64020992.0 |
| 2009-03-12 12:30:00 | AAPL | Stock | 3.3971 | 3.4196 | 3.3907 | 3.4168 | 51776172.0 |
| 2009-03-12 13:00:00 | AAPL | Stock | 3.4171 | 3.4275 | 3.4 | 3.4121 | 43084580.0 |
| 2009-03-12 13:30:00 | AAPL | Stock | 3.4121 | 3.4286 | 3.41 | 3.4143 | 32739896.0 |
| 2009-03-12 14:00:00 | AAPL | Stock | 3.4141 | 3.4279 | 3.3982 | 3.4154 | 51164120.0 |
| 2009-03-12 14:30:00 | AAPL | Stock | 3.415 | 3.4321 | 3.4114 | 3.4144 | 43681708.0 |
| 2009-03-12 15:00:00 | AAPL | Stock | 3.4146 | 3.4196 | 3.3961 | 3.4168 | 54871852.0 |
| 2009-03-12 15:30:00 | AAPL | Stock | 3.4161 | 3.4493 | 3.4143 | 3.4407 | 103224800.0 |
| 2009-03-12 16:00:00 | AAPL | Stock | 3.44 | 3.4598 | 3.3388 | 3.4296 | 20539820.0 |
| 2009-03-12 16:30:00 | AAPL | Stock | 3.43 | 3.4411 | 3.4279 | 3.4411 | 570360.0 |
| 2009-03-12 17:00:00 | AAPL | Stock | 3.4289 | 3.445 | 3.4286 | 3.4343 | 79576.0 |
| 2009-03-12 17:30:00 | AAPL | Stock | 3.4375 | 3.4432 | 3.4375 | 3.4393 | 164500.0 |
| 2009-03-12 18:00:00 | AAPL | Stock | 3.4393 | 3.4411 | 3.4339 | 3.4393 | 689332.0 |
| 2009-03-12 18:30:00 | AAPL | Stock | 3.4411 | 3.4439 | 3.4393 | 3.4393 | 34580.0 |
| 2009-03-12 19:00:00 | AAPL | Stock | 3.4375 | 3.4443 | 3.4311 | 3.4414 | 262892.0 |
| 2009-03-12 19:30:00 | AAPL | Stock | 3.4414 | 3.4414 | 3.4293 | 3.4293 | 47544.0 |
| 2009-03-12 06:00:00 | MSFT | Stock | 16.91 | 16.91 | 16.91 | 16.91 | 300.0 |
| 2009-03-12 08:00:00 | MSFT | Stock | 17.0 | 17.0 | 16.86 | 16.91 | 36180.0 |
| 2009-03-12 08:30:00 | MSFT | Stock | 16.91 | 17.03 | 16.91 | 17.03 | 18550.0 |
| 2009-03-12 09:00:00 | MSFT | Stock | 17.03 | 17.09 | 16.96 | 17.02 | 76699.0 |
| 2009-03-12 09:30:00 | MSFT | Stock | 17.02 | 17.04 | 16.55 | 16.6 | 8010524.0 |
| 2009-03-12 10:00:00 | MSFT | Stock | 16.6 | 16.74 | 16.6 | 16.62 | 7932863.0 |
| 2009-03-12 10:30:00 | MSFT | Stock | 16.63 | 16.7 | 16.5 | 16.66 | 7511527.0 |
| 2009-03-12 11:00:00 | MSFT | Stock | 16.66 | 16.66 | 16.56 | 16.6 | 3423150.0 |
| 2009-03-12 11:30:00 | MSFT | Stock | 16.595 | 16.63 | 16.54 | 16.57 | 4227722.0 |
| 2009-03-12 12:00:00 | MSFT | Stock | 16.57 | 16.61 | 16.48 | 16.52 | 4501214.0 |
| 2009-03-12 12:30:00 | MSFT | Stock | 16.52 | 16.72 | 16.5 | 16.69 | 4411417.0 |
| 2009-03-12 13:00:00 | MSFT | Stock | 16.69 | 16.76 | 16.65 | 16.68 | 5533843.0 |
| 2009-03-12 13:30:00 | MSFT | Stock | 16.68 | 16.72 | 16.66 | 16.69 | 3305010.0 |
| 2009-03-12 14:00:00 | MSFT | Stock | 16.68 | 16.9 | 16.65 | 16.79 | 4691960.0 |
| 2009-03-12 14:30:00 | MSFT | Stock | 16.78 | 16.95 | 16.76 | 16.84 | 5641927.0 |
| 2009-03-12 15:00:00 | MSFT | Stock | 16.84 | 16.91 | 16.76 | 16.91 | 10784455.0 |
| 2009-03-12 15:30:00 | MSFT | Stock | 16.91 | 17.01 | 16.88 | 17.01 | 18834814.0 |
| 2009-03-12 16:00:00 | MSFT | Stock | 17.01 | 17.01 | 16.555 | 16.7 | 2951451.0 |
| 2009-03-12 16:30:00 | MSFT | Stock | 16.77 | 17.01 | 16.77 | 17.01 | 224211.0 |
| 2009-03-12 17:00:00 | MSFT | Stock | 16.93 | 16.98 | 16.52 | 16.97 | 75609.0 |
| 2009-03-12 17:30:00 | MSFT | Stock | 16.97 | 17.0 | 16.97 | 16.98 | 21510.0 |
| 2009-03-12 18:00:00 | MSFT | Stock | 16.98 | 17.01 | 16.97 | 16.97 | 60154.0 |
> showing 50 of 71,406 rows — these rows as CSV