PREVIEW / stock_30min / 2009-08-12
file: by_date/stock_30min/2009/2009-08-12.parquet size: 1.3 MB rows: 71,748 symbols: 3,373
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-12 06:00:00 | AAPL | Stock | 5.8093 | 5.8107 | 5.8093 | 5.8107 | 22400.0 |
| 2009-08-12 07:00:00 | AAPL | Stock | 5.8214 | 5.8282 | 5.8214 | 5.8282 | 7000.0 |
| 2009-08-12 08:00:00 | AAPL | Stock | 5.8189 | 5.8214 | 5.8071 | 5.8214 | 211736.0 |
| 2009-08-12 08:30:00 | AAPL | Stock | 5.8107 | 5.8125 | 5.8 | 5.8 | 422324.0 |
| 2009-08-12 09:00:00 | AAPL | Stock | 5.7986 | 5.8125 | 5.7986 | 5.8029 | 186648.0 |
| 2009-08-12 09:30:00 | AAPL | Stock | 5.8054 | 5.895 | 5.8021 | 5.8932 | 61769596.0 |
| 2009-08-12 10:00:00 | AAPL | Stock | 5.8936 | 5.9143 | 5.8868 | 5.9079 | 45622948.0 |
| 2009-08-12 10:30:00 | AAPL | Stock | 5.9064 | 5.9171 | 5.8964 | 5.9164 | 25862956.0 |
| 2009-08-12 11:00:00 | AAPL | Stock | 5.9164 | 5.9286 | 5.9107 | 5.9239 | 25457320.0 |
| 2009-08-12 11:30:00 | AAPL | Stock | 5.9246 | 5.93 | 5.9107 | 5.9157 | 21242340.0 |
| 2009-08-12 12:00:00 | AAPL | Stock | 5.9157 | 5.9257 | 5.9143 | 5.9208 | 15497440.0 |
| 2009-08-12 12:30:00 | AAPL | Stock | 5.9214 | 5.9275 | 5.9164 | 5.9268 | 13245204.0 |
| 2009-08-12 13:00:00 | AAPL | Stock | 5.9261 | 5.9286 | 5.92 | 5.9214 | 12853092.0 |
| 2009-08-12 13:30:00 | AAPL | Stock | 5.9218 | 5.9236 | 5.9089 | 5.9121 | 15379952.0 |
| 2009-08-12 14:00:00 | AAPL | Stock | 5.9125 | 5.9246 | 5.9036 | 5.9068 | 23869412.0 |
| 2009-08-12 14:30:00 | AAPL | Stock | 5.9068 | 5.9386 | 5.8875 | 5.9386 | 50254148.0 |
| 2009-08-12 15:00:00 | AAPL | Stock | 5.9379 | 5.9539 | 5.9371 | 5.9393 | 52853556.0 |
| 2009-08-12 15:30:00 | AAPL | Stock | 5.9404 | 5.9457 | 5.9018 | 5.9096 | 58392936.0 |
| 2009-08-12 16:00:00 | AAPL | Stock | 5.9057 | 5.9102 | 5.9 | 5.9039 | 12949384.0 |
| 2009-08-12 16:30:00 | AAPL | Stock | 5.9036 | 5.9086 | 5.9011 | 5.9086 | 172816.0 |
| 2009-08-12 17:00:00 | AAPL | Stock | 5.9093 | 5.9132 | 5.9086 | 5.9086 | 159040.0 |
| 2009-08-12 17:30:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9086 | 5.9104 | 29372.0 |
| 2009-08-12 18:00:00 | AAPL | Stock | 5.91 | 5.9136 | 5.9039 | 5.9136 | 1022924.0 |
| 2009-08-12 18:30:00 | AAPL | Stock | 5.9143 | 5.9168 | 5.9064 | 5.9071 | 49840.0 |
| 2009-08-12 19:00:00 | AAPL | Stock | 5.9107 | 5.9143 | 5.9107 | 5.9143 | 28140.0 |
| 2009-08-12 19:30:00 | AAPL | Stock | 5.9168 | 5.9179 | 5.9161 | 5.9161 | 33964.0 |
| 2009-08-12 07:30:00 | MSFT | Stock | 23.2 | 23.2 | 23.2 | 23.2 | 470.0 |
| 2009-08-12 08:00:00 | MSFT | Stock | 23.25 | 23.25 | 23.2 | 23.23 | 10636.0 |
| 2009-08-12 08:30:00 | MSFT | Stock | 23.25 | 23.27 | 23.2 | 23.2 | 6497.0 |
| 2009-08-12 09:00:00 | MSFT | Stock | 23.2 | 23.25 | 23.11 | 23.12 | 15802.0 |
| 2009-08-12 09:30:00 | MSFT | Stock | 23.13 | 23.4 | 23.03 | 23.37 | 6387629.0 |
| 2009-08-12 10:00:00 | MSFT | Stock | 23.37 | 23.51 | 23.36 | 23.49 | 5565311.0 |
| 2009-08-12 10:30:00 | MSFT | Stock | 23.49 | 23.53 | 23.42 | 23.49 | 3705283.0 |
| 2009-08-12 11:00:00 | MSFT | Stock | 23.49 | 23.6 | 23.46 | 23.59 | 3505083.0 |
| 2009-08-12 11:30:00 | MSFT | Stock | 23.59 | 23.65 | 23.56 | 23.58 | 2289828.0 |
| 2009-08-12 12:00:00 | MSFT | Stock | 23.58 | 23.63 | 23.58 | 23.62 | 1299526.0 |
| 2009-08-12 12:30:00 | MSFT | Stock | 23.63 | 23.68 | 23.57 | 23.68 | 1976688.0 |
| 2009-08-12 13:00:00 | MSFT | Stock | 23.68 | 23.73 | 23.62 | 23.69 | 2223776.0 |
| 2009-08-12 13:30:00 | MSFT | Stock | 23.69 | 23.69 | 23.61 | 23.62 | 1550840.0 |
| 2009-08-12 14:00:00 | MSFT | Stock | 23.62 | 23.7 | 23.58 | 23.61 | 2592248.0 |
| 2009-08-12 14:30:00 | MSFT | Stock | 23.617 | 23.84 | 23.53 | 23.84 | 5865989.0 |
| 2009-08-12 15:00:00 | MSFT | Stock | 23.84 | 23.9 | 23.76 | 23.82 | 5186701.0 |
| 2009-08-12 15:30:00 | MSFT | Stock | 23.82 | 23.83 | 23.53 | 23.58 | 9598015.0 |
| 2009-08-12 16:00:00 | MSFT | Stock | 23.57 | 23.6 | 23.16 | 23.55 | 6738987.0 |
| 2009-08-12 16:30:00 | MSFT | Stock | 23.53 | 23.61 | 23.53 | 23.56 | 411825.0 |
| 2009-08-12 17:00:00 | MSFT | Stock | 23.15 | 23.65 | 23.15 | 23.64 | 13471.0 |
| 2009-08-12 17:30:00 | MSFT | Stock | 23.63 | 23.67 | 23.63 | 23.67 | 3800.0 |
| 2009-08-12 18:00:00 | MSFT | Stock | 23.56 | 23.59 | 23.53 | 23.56 | 3822.0 |
| 2009-08-12 18:30:00 | MSFT | Stock | 23.56 | 23.56 | 23.53 | 23.54 | 3543.0 |
| 2009-08-12 19:00:00 | MSFT | Stock | 23.53 | 23.53 | 23.52 | 23.52 | 6800.0 |
> showing 50 of 71,748 rows — these rows as CSV