PREVIEW / stock_30min / 2009-03-06

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-03-06.parquet
  size:    1.3 MB
  rows:    71,252
  symbols: 3,370

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-06 07:00:00	AAPL	Stock	3.1625	3.1625	3.1625	3.1625	5600.0
2009-03-06 07:30:00	AAPL	Stock	3.1625	3.1625	3.1532	3.1571	61740.0
2009-03-06 08:00:00	AAPL	Stock	3.1536	3.185	3.1532	3.175	661192.0
2009-03-06 08:30:00	AAPL	Stock	3.1732	3.1943	3.1536	3.1789	2002868.0
2009-03-06 09:00:00	AAPL	Stock	3.1818	3.1821	3.1432	3.155	2616320.0
2009-03-06 09:30:00	AAPL	Stock	3.155	3.1571	3.0757	3.0996	118648656.0
2009-03-06 10:00:00	AAPL	Stock	3.0996	3.1089	3.0368	3.0436	110449444.0
2009-03-06 10:30:00	AAPL	Stock	3.0436	3.0479	2.9732	2.9982	112640108.0
2009-03-06 11:00:00	AAPL	Stock	2.9982	3.0046	2.9404	2.95	88425624.0
2009-03-06 11:30:00	AAPL	Stock	2.9507	3.0125	2.9479	3.0071	74769604.0
2009-03-06 12:00:00	AAPL	Stock	3.0068	3.0264	2.9911	3.0036	59727696.0
2009-03-06 12:30:00	AAPL	Stock	3.0036	3.0157	2.9743	3.0132	44277520.0
2009-03-06 13:00:00	AAPL	Stock	3.0136	3.0214	2.9946	3.0093	39060028.0
2009-03-06 13:30:00	AAPL	Stock	3.0082	3.0139	2.9757	3.0096	42075124.0
2009-03-06 14:00:00	AAPL	Stock	3.0104	3.0321	2.9936	3.0179	57730260.0
2009-03-06 14:30:00	AAPL	Stock	3.0183	3.0221	2.9786	2.9839	48060712.0
2009-03-06 15:00:00	AAPL	Stock	2.9839	3.0068	2.9721	2.9829	52314780.0
2009-03-06 15:30:00	AAPL	Stock	2.9832	3.0525	2.9818	3.0507	124725468.0
2009-03-06 16:00:00	AAPL	Stock	3.0507	3.0714	2.9961	3.0464	22251880.0
2009-03-06 16:30:00	AAPL	Stock	3.0571	3.065	3.0464	3.0625	891492.0
2009-03-06 17:00:00	AAPL	Stock	3.0629	3.0629	3.06	3.06	150584.0
2009-03-06 17:30:00	AAPL	Stock	3.0607	3.0618	3.0571	3.0589	130200.0
2009-03-06 18:00:00	AAPL	Stock	3.0575	3.0625	3.0464	3.0604	994812.0
2009-03-06 18:30:00	AAPL	Stock	3.0604	3.0632	3.0604	3.0632	31612.0
2009-03-06 19:00:00	AAPL	Stock	3.0611	3.0611	3.0546	3.0546	33292.0
2009-03-06 19:30:00	AAPL	Stock	3.0554	3.0625	3.0554	3.0593	35588.0
2009-03-06 07:00:00	MSFT	Stock	15.31	15.31	15.3	15.3	400.0
2009-03-06 07:30:00	MSFT	Stock	15.3	15.3	15.3	15.3	100.0
2009-03-06 08:00:00	MSFT	Stock	15.36	15.38	15.28	15.3	29771.0
2009-03-06 08:30:00	MSFT	Stock	15.32	15.5	15.3	15.45	108043.0
2009-03-06 09:00:00	MSFT	Stock	15.45	15.46	15.27	15.36	67870.0
2009-03-06 09:30:00	MSFT	Stock	15.34	15.62	15.31	15.48	8280536.0
2009-03-06 10:00:00	MSFT	Stock	15.48	15.5	15.26	15.31	7579387.0
2009-03-06 10:30:00	MSFT	Stock	15.31	15.33	15.0	15.045	9581428.0
2009-03-06 11:00:00	MSFT	Stock	15.04	15.15	15.0	15.131	5052126.0
2009-03-06 11:30:00	MSFT	Stock	15.14	15.21	15.05	15.132	3265746.0
2009-03-06 12:00:00	MSFT	Stock	15.132	15.29	15.12	15.21	3914151.0
2009-03-06 12:30:00	MSFT	Stock	15.21	15.25	15.09	15.17	3331778.0
2009-03-06 13:00:00	MSFT	Stock	15.17	15.18	14.95	15.002	5348057.0
2009-03-06 13:30:00	MSFT	Stock	15.01	15.06	14.93	15.01	4677667.0
2009-03-06 14:00:00	MSFT	Stock	15.01	15.12	14.97	15.04	5695446.0
2009-03-06 14:30:00	MSFT	Stock	15.032	15.08	14.95	14.968	5302907.0
2009-03-06 15:00:00	MSFT	Stock	14.97	15.04	14.87	14.91	6349209.0
2009-03-06 15:30:00	MSFT	Stock	14.91	15.33	14.91	15.29	16737338.0
2009-03-06 16:00:00	MSFT	Stock	15.3	15.4	15.016	15.28	4155645.0
2009-03-06 16:30:00	MSFT	Stock	15.28	15.36	15.28	15.35	149304.0
2009-03-06 17:00:00	MSFT	Stock	15.35	15.38	15.35	15.35	3179.0
2009-03-06 17:30:00	MSFT	Stock	15.12	15.37	15.12	15.36	18686.0
2009-03-06 18:00:00	MSFT	Stock	15.37	15.38	15.28	15.38	23820.0
2009-03-06 18:30:00	MSFT	Stock	15.38	15.38	15.35	15.36	2800.0

> showing 50 of 71,252 rows — these rows as CSV

> unlock the full archive -- $79 one-time