PREVIEW / stock_30min / 2010-03-05

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-05.parquet
  size:    1.4 MB
  rows:    75,967
  symbols: 3,458

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
2010-03-05 05:00:00	AAPL	Stock	7.5871	7.5871	7.5871	7.5871	2800.0
2010-03-05 05:30:00	AAPL	Stock	7.59	7.6	7.59	7.6	22400.0
2010-03-05 06:00:00	AAPL	Stock	7.5929	7.5932	7.5929	7.5932	16800.0
2010-03-05 07:00:00	AAPL	Stock	7.6061	7.6232	7.5975	7.6179	199976.0
2010-03-05 07:30:00	AAPL	Stock	7.6214	7.6214	7.6029	7.6029	360164.0
2010-03-05 08:00:00	AAPL	Stock	7.6071	7.6211	7.5964	7.5964	2648156.0
2010-03-05 08:30:00	AAPL	Stock	7.5996	7.6975	7.5996	7.6929	14213360.0
2010-03-05 09:00:00	AAPL	Stock	7.6929	7.7018	7.6714	7.6782	6909196.0
2010-03-05 09:30:00	AAPL	Stock	7.6782	7.7661	7.6654	7.7611	202632696.0
2010-03-05 10:00:00	AAPL	Stock	7.7604	7.7671	7.7436	7.7607	86511516.0
2010-03-05 10:30:00	AAPL	Stock	7.7614	7.7818	7.7607	7.7775	58892484.0
2010-03-05 11:00:00	AAPL	Stock	7.7776	7.7964	7.775	7.7896	71815548.0
2010-03-05 11:30:00	AAPL	Stock	7.7896	7.8104	7.7804	7.8068	47519864.0
2010-03-05 12:00:00	AAPL	Stock	7.8065	7.8086	7.7932	7.7982	34342924.0
2010-03-05 12:30:00	AAPL	Stock	7.7986	7.8296	7.7968	7.8296	47092444.0
2010-03-05 13:00:00	AAPL	Stock	7.8296	7.8464	7.8246	7.835	58792944.0
2010-03-05 13:30:00	AAPL	Stock	7.835	7.8382	7.8068	7.8204	43851976.0
2010-03-05 14:00:00	AAPL	Stock	7.8204	7.8275	7.8143	7.825	27066928.0
2010-03-05 14:30:00	AAPL	Stock	7.8243	7.8396	7.8211	7.8239	37952684.0
2010-03-05 15:00:00	AAPL	Stock	7.8236	7.8289	7.8036	7.8121	54145000.0
2010-03-05 15:30:00	AAPL	Stock	7.8125	7.8361	7.8107	7.8214	83527276.0
2010-03-05 16:00:00	AAPL	Stock	7.8214	7.8264	7.5254	7.8207	14570024.0
2010-03-05 16:30:00	AAPL	Stock	7.8232	7.8268	7.8214	7.8261	349272.0
2010-03-05 17:00:00	AAPL	Stock	7.8246	7.8257	7.7484	7.8225	739956.0
2010-03-05 17:30:00	AAPL	Stock	7.8221	7.8229	7.8039	7.8214	290696.0
2010-03-05 18:00:00	AAPL	Stock	7.8214	7.8239	7.8196	7.8239	124152.0
2010-03-05 18:30:00	AAPL	Stock	7.8214	7.8246	7.8214	7.8246	219100.0
2010-03-05 19:00:00	AAPL	Stock	7.8232	7.8246	7.8193	7.8193	194348.0
2010-03-05 19:30:00	AAPL	Stock	7.8211	7.8229	7.8193	7.8207	160440.0
2010-03-05 08:00:00	MSFT	Stock	28.74	28.74	28.69	28.74	8200.0
2010-03-05 08:30:00	MSFT	Stock	28.74	28.9	28.74	28.82	80377.0
2010-03-05 09:00:00	MSFT	Stock	28.81	28.83	28.66	28.66	52803.0
2010-03-05 09:30:00	MSFT	Stock	28.67	28.68	28.46	28.508	7668544.0
2010-03-05 10:00:00	MSFT	Stock	28.51	28.67	28.48	28.56	6515978.0
2010-03-05 10:30:00	MSFT	Stock	28.55	28.62	28.54	28.57	3746965.0
2010-03-05 11:00:00	MSFT	Stock	28.56	28.63	28.52	28.57	4374172.0
2010-03-05 11:30:00	MSFT	Stock	28.565	28.57	28.52	28.52	2760196.0
2010-03-05 12:00:00	MSFT	Stock	28.52	28.57	28.47	28.5	2852148.0
2010-03-05 12:30:00	MSFT	Stock	28.5	28.51	28.42	28.49	2833498.0
2010-03-05 13:00:00	MSFT	Stock	28.49	28.51	28.45	28.48	2061883.0
2010-03-05 13:30:00	MSFT	Stock	28.48	28.51	28.45	28.45	1649101.0
2010-03-05 14:00:00	MSFT	Stock	28.46	28.49	28.43	28.47	2466358.0
2010-03-05 14:30:00	MSFT	Stock	28.47	28.56	28.45	28.531	3079534.0
2010-03-05 15:00:00	MSFT	Stock	28.54	28.6	28.5	28.51	4346591.0
2010-03-05 15:30:00	MSFT	Stock	28.51	28.6	28.51	28.59	7218747.0
2010-03-05 16:00:00	MSFT	Stock	28.59	28.643	28.48	28.643	3019056.0
2010-03-05 16:30:00	MSFT	Stock	28.59	28.59	28.58	28.58	1827.0
2010-03-05 17:00:00	MSFT	Stock	28.567	28.59	28.481	28.59	155236.0
2010-03-05 17:30:00	MSFT	Stock	28.58	28.58	28.481	28.55	18822.0
2010-03-05 18:00:00	MSFT	Stock	28.58	28.58	28.53	28.57	1782.0

> showing 50 of 75,967 rows — these rows as CSV

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