PREVIEW / stock_30min / 2009-08-03
file: by_date/stock_30min/2009/2009-08-03.parquet size: 1.4 MB rows: 74,365 symbols: 3,367
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-08-03 05:30:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 5600.0 |
| 2009-08-03 07:00:00 | AAPL | Stock | 5.9 | 5.9 | 5.8907 | 5.8911 | 21840.0 |
| 2009-08-03 07:30:00 | AAPL | Stock | 5.8929 | 5.9143 | 5.8929 | 5.9143 | 138880.0 |
| 2009-08-03 08:00:00 | AAPL | Stock | 5.9071 | 5.9193 | 5.8354 | 5.9193 | 1136184.0 |
| 2009-08-03 08:30:00 | AAPL | Stock | 5.9193 | 5.9268 | 5.8875 | 5.9068 | 1524572.0 |
| 2009-08-03 09:00:00 | AAPL | Stock | 5.9036 | 5.9143 | 5.8961 | 5.9025 | 1434776.0 |
| 2009-08-03 09:30:00 | AAPL | Stock | 5.9004 | 5.9464 | 5.8929 | 5.9264 | 76288100.0 |
| 2009-08-03 10:00:00 | AAPL | Stock | 5.9264 | 5.9514 | 5.9143 | 5.9289 | 52464160.0 |
| 2009-08-03 10:30:00 | AAPL | Stock | 5.9296 | 5.9411 | 5.9054 | 5.9096 | 36288448.0 |
| 2009-08-03 11:00:00 | AAPL | Stock | 5.9086 | 5.9186 | 5.8882 | 5.8996 | 32496436.0 |
| 2009-08-03 11:30:00 | AAPL | Stock | 5.9 | 5.9196 | 5.8932 | 5.9171 | 20466572.0 |
| 2009-08-03 12:00:00 | AAPL | Stock | 5.9161 | 5.9321 | 5.9154 | 5.9225 | 21044464.0 |
| 2009-08-03 12:30:00 | AAPL | Stock | 5.9225 | 5.9304 | 5.9146 | 5.9171 | 14491148.0 |
| 2009-08-03 13:00:00 | AAPL | Stock | 5.9179 | 5.9293 | 5.9179 | 5.9226 | 11054316.0 |
| 2009-08-03 13:30:00 | AAPL | Stock | 5.9232 | 5.9286 | 5.9211 | 5.9247 | 12638668.0 |
| 2009-08-03 14:00:00 | AAPL | Stock | 5.925 | 5.9414 | 5.9246 | 5.9311 | 21370076.0 |
| 2009-08-03 14:30:00 | AAPL | Stock | 5.9311 | 5.9354 | 5.9225 | 5.9261 | 15988644.0 |
| 2009-08-03 15:00:00 | AAPL | Stock | 5.9261 | 5.9389 | 5.9229 | 5.9304 | 16929948.0 |
| 2009-08-03 15:30:00 | AAPL | Stock | 5.93 | 5.9446 | 5.925 | 5.9436 | 42844620.0 |
| 2009-08-03 16:00:00 | AAPL | Stock | 5.9436 | 5.9493 | 5.9246 | 5.9421 | 9903824.0 |
| 2009-08-03 16:30:00 | AAPL | Stock | 5.9247 | 5.9446 | 5.9247 | 5.9446 | 450324.0 |
| 2009-08-03 17:00:00 | AAPL | Stock | 5.9195 | 5.9464 | 5.9195 | 5.9439 | 291564.0 |
| 2009-08-03 17:30:00 | AAPL | Stock | 5.9446 | 5.9446 | 5.9404 | 5.9443 | 122332.0 |
| 2009-08-03 18:00:00 | AAPL | Stock | 5.9439 | 5.9496 | 5.9411 | 5.9482 | 471912.0 |
| 2009-08-03 18:30:00 | AAPL | Stock | 5.945 | 5.9482 | 5.9436 | 5.9454 | 88368.0 |
| 2009-08-03 19:00:00 | AAPL | Stock | 5.9436 | 5.9464 | 5.9436 | 5.9457 | 92092.0 |
| 2009-08-03 19:30:00 | AAPL | Stock | 5.9461 | 5.9496 | 5.9457 | 5.9482 | 145096.0 |
| 2009-08-03 20:00:00 | AAPL | Stock | 5.8986 | 5.8986 | 5.8986 | 5.8986 | 70000.0 |
| 2009-08-03 06:00:00 | MSFT | Stock | 23.9 | 23.9 | 23.9 | 23.9 | 4600.0 |
| 2009-08-03 06:30:00 | MSFT | Stock | 23.83 | 23.9 | 23.83 | 23.9 | 1300.0 |
| 2009-08-03 07:00:00 | MSFT | Stock | 23.89 | 23.9 | 23.8 | 23.9 | 3707.0 |
| 2009-08-03 07:30:00 | MSFT | Stock | 23.89 | 23.89 | 23.86 | 23.86 | 9400.0 |
| 2009-08-03 08:00:00 | MSFT | Stock | 23.84 | 23.89 | 23.52 | 23.87 | 41652.0 |
| 2009-08-03 08:30:00 | MSFT | Stock | 23.87 | 23.87 | 23.8 | 23.81 | 33092.0 |
| 2009-08-03 09:00:00 | MSFT | Stock | 23.82 | 23.88 | 23.51 | 23.8 | 57960.0 |
| 2009-08-03 09:30:00 | MSFT | Stock | 23.81 | 23.85 | 23.5 | 23.62 | 7144239.0 |
| 2009-08-03 10:00:00 | MSFT | Stock | 23.62 | 23.805 | 23.61 | 23.8 | 5238069.0 |
| 2009-08-03 10:30:00 | MSFT | Stock | 23.8 | 23.86 | 23.73 | 23.82 | 3659243.0 |
| 2009-08-03 11:00:00 | MSFT | Stock | 23.82 | 23.838 | 23.71 | 23.75 | 2378031.0 |
| 2009-08-03 11:30:00 | MSFT | Stock | 23.75 | 23.79 | 23.71 | 23.764 | 2572823.0 |
| 2009-08-03 12:00:00 | MSFT | Stock | 23.77 | 23.802 | 23.72 | 23.737 | 2141252.0 |
| 2009-08-03 12:30:00 | MSFT | Stock | 23.74 | 23.77 | 23.7 | 23.75 | 1707205.0 |
| 2009-08-03 13:00:00 | MSFT | Stock | 23.742 | 23.83 | 23.74 | 23.76 | 1951156.0 |
| 2009-08-03 13:30:00 | MSFT | Stock | 23.75 | 23.82 | 23.75 | 23.77 | 1764621.0 |
| 2009-08-03 14:00:00 | MSFT | Stock | 23.762 | 23.815 | 23.74 | 23.76 | 2691610.0 |
| 2009-08-03 14:30:00 | MSFT | Stock | 23.76 | 23.81 | 23.74 | 23.78 | 1373954.0 |
| 2009-08-03 15:00:00 | MSFT | Stock | 23.78 | 23.81 | 23.76 | 23.76 | 2336649.0 |
| 2009-08-03 15:30:00 | MSFT | Stock | 23.77 | 23.82 | 23.72 | 23.82 | 7784815.0 |
| 2009-08-03 16:00:00 | MSFT | Stock | 23.82 | 23.84 | 23.757 | 23.8 | 2608113.0 |
| 2009-08-03 16:30:00 | MSFT | Stock | 23.76 | 23.83 | 23.76 | 23.83 | 13413.0 |
> showing 50 of 74,365 rows — these rows as CSV