PREVIEW / stock_30min / 2009-03-16
file: by_date/stock_30min/2009/2009-03-16.parquet size: 1.2 MB rows: 68,336 symbols: 3,329
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-16 05:30:00 | AAPL | Stock | 3.4768 | 3.4768 | 3.4768 | 3.4768 | 25200.0 |
| 2009-03-16 06:00:00 | AAPL | Stock | 3.4768 | 3.4821 | 3.4768 | 3.4821 | 50400.0 |
| 2009-03-16 07:00:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4779 | 3.4779 | 8400.0 |
| 2009-03-16 07:30:00 | AAPL | Stock | 3.4821 | 3.4904 | 3.4821 | 3.4904 | 5600.0 |
| 2009-03-16 08:00:00 | AAPL | Stock | 3.4836 | 3.4904 | 3.4589 | 3.4589 | 299012.0 |
| 2009-03-16 08:30:00 | AAPL | Stock | 3.4625 | 3.4682 | 3.4571 | 3.4589 | 619696.0 |
| 2009-03-16 09:00:00 | AAPL | Stock | 3.4593 | 3.4643 | 3.4343 | 3.4446 | 1337896.0 |
| 2009-03-16 09:30:00 | AAPL | Stock | 3.4475 | 3.4589 | 3.3957 | 3.4114 | 81115104.0 |
| 2009-03-16 10:00:00 | AAPL | Stock | 3.4104 | 3.4211 | 3.3693 | 3.3761 | 56901208.0 |
| 2009-03-16 10:30:00 | AAPL | Stock | 3.3764 | 3.3975 | 3.3636 | 3.3668 | 46033204.0 |
| 2009-03-16 11:00:00 | AAPL | Stock | 3.3671 | 3.42 | 3.3657 | 3.4143 | 42100492.0 |
| 2009-03-16 11:30:00 | AAPL | Stock | 3.4143 | 3.4421 | 3.4107 | 3.4311 | 38123540.0 |
| 2009-03-16 12:00:00 | AAPL | Stock | 3.4318 | 3.4571 | 3.4225 | 3.4559 | 36191316.0 |
| 2009-03-16 12:30:00 | AAPL | Stock | 3.4558 | 3.4782 | 3.4554 | 3.4675 | 47284496.0 |
| 2009-03-16 13:00:00 | AAPL | Stock | 3.4675 | 3.4704 | 3.3822 | 3.3918 | 108457076.0 |
| 2009-03-16 13:30:00 | AAPL | Stock | 3.3927 | 3.4257 | 3.3918 | 3.4096 | 61049520.0 |
| 2009-03-16 14:00:00 | AAPL | Stock | 3.4096 | 3.4346 | 3.3996 | 3.4171 | 43635284.0 |
| 2009-03-16 14:30:00 | AAPL | Stock | 3.4179 | 3.4411 | 3.4046 | 3.4289 | 44808288.0 |
| 2009-03-16 15:00:00 | AAPL | Stock | 3.4286 | 3.4332 | 3.4004 | 3.4214 | 48963180.0 |
| 2009-03-16 15:30:00 | AAPL | Stock | 3.4214 | 3.4454 | 3.4036 | 3.41 | 77326228.0 |
| 2009-03-16 16:00:00 | AAPL | Stock | 3.4061 | 3.4368 | 3.4057 | 3.4111 | 17644284.0 |
| 2009-03-16 16:30:00 | AAPL | Stock | 3.4125 | 3.4154 | 3.3946 | 3.4136 | 36904112.0 |
| 2009-03-16 17:00:00 | AAPL | Stock | 3.4136 | 3.4136 | 3.4136 | 3.4136 | 64400.0 |
| 2009-03-16 18:00:00 | AAPL | Stock | 3.4164 | 3.4164 | 3.4079 | 3.4154 | 151312.0 |
| 2009-03-16 18:30:00 | AAPL | Stock | 3.4154 | 3.4161 | 3.4154 | 3.4161 | 19600.0 |
| 2009-03-16 19:00:00 | AAPL | Stock | 3.4154 | 3.4171 | 3.4154 | 3.4171 | 5600.0 |
| 2009-03-16 19:30:00 | AAPL | Stock | 3.4171 | 3.425 | 3.4171 | 3.4232 | 236936.0 |
| 2009-03-16 04:00:00 | MSFT | Stock | 16.8 | 16.8 | 16.8 | 16.8 | 200.0 |
| 2009-03-16 07:30:00 | MSFT | Stock | 16.89 | 16.89 | 16.79 | 16.84 | 18600.0 |
| 2009-03-16 08:00:00 | MSFT | Stock | 16.85 | 16.85 | 16.75 | 16.8 | 20042.0 |
| 2009-03-16 08:30:00 | MSFT | Stock | 16.8 | 16.83 | 16.75 | 16.81 | 42488.0 |
| 2009-03-16 09:00:00 | MSFT | Stock | 16.78 | 16.85 | 16.75 | 16.81 | 31436.0 |
| 2009-03-16 09:30:00 | MSFT | Stock | 16.82 | 16.96 | 16.54 | 16.65 | 6257634.0 |
| 2009-03-16 10:00:00 | MSFT | Stock | 16.65 | 16.67 | 16.33 | 16.39 | 6833288.0 |
| 2009-03-16 10:30:00 | MSFT | Stock | 16.398 | 16.49 | 16.37 | 16.382 | 3607976.0 |
| 2009-03-16 11:00:00 | MSFT | Stock | 16.38 | 16.63 | 16.38 | 16.628 | 4435088.0 |
| 2009-03-16 11:30:00 | MSFT | Stock | 16.62 | 16.72 | 16.58 | 16.69 | 3659575.0 |
| 2009-03-16 12:00:00 | MSFT | Stock | 16.69 | 16.83 | 16.66 | 16.81 | 3496816.0 |
| 2009-03-16 12:30:00 | MSFT | Stock | 16.801 | 16.94 | 16.801 | 16.92 | 4988524.0 |
| 2009-03-16 13:00:00 | MSFT | Stock | 16.91 | 16.93 | 16.8 | 16.82 | 2618881.0 |
| 2009-03-16 13:30:00 | MSFT | Stock | 16.815 | 16.85 | 16.7 | 16.725 | 3093466.0 |
| 2009-03-16 14:00:00 | MSFT | Stock | 16.72 | 16.74 | 16.61 | 16.62 | 3805619.0 |
| 2009-03-16 14:30:00 | MSFT | Stock | 16.62 | 16.66 | 16.44 | 16.46 | 4780321.0 |
| 2009-03-16 15:00:00 | MSFT | Stock | 16.46 | 16.48 | 16.31 | 16.359 | 5371473.0 |
| 2009-03-16 15:30:00 | MSFT | Stock | 16.35 | 16.37 | 16.24 | 16.28 | 9474674.0 |
| 2009-03-16 16:00:00 | MSFT | Stock | 16.28 | 16.576 | 16.23 | 16.25 | 3427355.0 |
| 2009-03-16 16:30:00 | MSFT | Stock | 16.25 | 16.431 | 16.25 | 16.28 | 108623.0 |
| 2009-03-16 17:00:00 | MSFT | Stock | 16.28 | 16.28 | 16.25 | 16.27 | 3350.0 |
| 2009-03-16 17:30:00 | MSFT | Stock | 16.28 | 16.28 | 16.26 | 16.26 | 4000.0 |
| 2009-03-16 18:00:00 | MSFT | Stock | 16.28 | 16.29 | 16.25 | 16.29 | 143211.0 |
> showing 50 of 68,336 rows — these rows as CSV