PREVIEW / stock_30min / 2010-10-12

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-12.parquet
  size:    1.4 MB
  rows:    72,763
  symbols: 3,480

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-10-12 04:00:00	AAPL	Stock	10.5393	10.5393	10.4821	10.4821	8400.0
2010-10-12 05:00:00	AAPL	Stock	10.4286	10.4464	10.4286	10.4461	47600.0
2010-10-12 05:30:00	AAPL	Stock	10.4818	10.4818	10.4661	10.4689	14952.0
2010-10-12 07:00:00	AAPL	Stock	10.4961	10.4982	10.4646	10.4911	148400.0
2010-10-12 07:30:00	AAPL	Stock	10.4911	10.5371	10.4893	10.5357	367024.0
2010-10-12 08:00:00	AAPL	Stock	10.5375	10.5611	10.5229	10.5304	2158156.0
2010-10-12 08:30:00	AAPL	Stock	10.5307	10.5786	10.5282	10.5743	1487024.0
2010-10-12 09:00:00	AAPL	Stock	10.5721	10.5786	10.5486	10.5504	1666560.0
2010-10-12 09:30:00	AAPL	Stock	10.5504	10.5961	10.4461	10.485	106126524.0
2010-10-12 10:00:00	AAPL	Stock	10.485	10.5625	10.4821	10.5482	56877940.0
2010-10-12 10:30:00	AAPL	Stock	10.5482	10.6143	10.5475	10.6036	50290100.0
2010-10-12 11:00:00	AAPL	Stock	10.6032	10.6333	10.5921	10.6111	41006448.0
2010-10-12 11:30:00	AAPL	Stock	10.6111	10.6186	10.5914	10.6086	18731580.0
2010-10-12 12:00:00	AAPL	Stock	10.6082	10.6204	10.6007	10.6011	18337760.0
2010-10-12 12:30:00	AAPL	Stock	10.6029	10.6107	10.5975	10.6046	11827284.0
2010-10-12 13:00:00	AAPL	Stock	10.6052	10.6089	10.5993	10.6068	7991956.0
2010-10-12 13:30:00	AAPL	Stock	10.6057	10.6071	10.5932	10.6043	10141320.0
2010-10-12 14:00:00	AAPL	Stock	10.6057	10.6464	10.5893	10.6161	60861780.0
2010-10-12 14:30:00	AAPL	Stock	10.6178	10.6307	10.5918	10.6293	27472592.0
2010-10-12 15:00:00	AAPL	Stock	10.6282	10.6779	10.6071	10.6746	52227364.0
2010-10-12 15:30:00	AAPL	Stock	10.6754	10.6964	10.6586	10.6693	67923324.0
2010-10-12 16:00:00	AAPL	Stock	10.6693	10.6886	10.625	10.6793	15783684.0
2010-10-12 16:30:00	AAPL	Stock	10.6768	10.6854	10.5399	10.6736	853104.0
2010-10-12 17:00:00	AAPL	Stock	10.6746	10.6782	10.6693	10.6775	179228.0
2010-10-12 17:30:00	AAPL	Stock	10.6693	10.675	10.6693	10.675	539560.0
2010-10-12 18:00:00	AAPL	Stock	10.6725	10.6786	10.6621	10.6732	573888.0
2010-10-12 18:30:00	AAPL	Stock	10.6721	10.6782	10.6721	10.6761	142044.0
2010-10-12 19:00:00	AAPL	Stock	10.6761	10.6843	10.6754	10.6843	530572.0
2010-10-12 19:30:00	AAPL	Stock	10.6843	10.6871	10.6807	10.6868	281344.0
2010-10-12 07:00:00	MSFT	Stock	24.43	24.55	24.43	24.55	2100.0
2010-10-12 07:30:00	MSFT	Stock	24.58	24.58	24.58	24.58	500.0
2010-10-12 08:00:00	MSFT	Stock	24.56	24.58	24.5	24.55	18390.0
2010-10-12 08:30:00	MSFT	Stock	24.51	24.6	24.51	24.57	10272.0
2010-10-12 09:00:00	MSFT	Stock	24.57	24.69	24.54	24.64	20782.0
2010-10-12 09:30:00	MSFT	Stock	24.64	24.68	24.43	24.45	6756245.0
2010-10-12 10:00:00	MSFT	Stock	24.45	24.55	24.44	24.5	3275552.0
2010-10-12 10:30:00	MSFT	Stock	24.5	24.65	24.46	24.6	3389302.0
2010-10-12 11:00:00	MSFT	Stock	24.605	24.65	24.6	24.615	2183654.0
2010-10-12 11:30:00	MSFT	Stock	24.61	24.63	24.58	24.626	1938202.0
2010-10-12 12:00:00	MSFT	Stock	24.63	24.67	24.59	24.623	2060326.0
2010-10-12 12:30:00	MSFT	Stock	24.623	24.63	24.61	24.62	598885.0
2010-10-12 13:00:00	MSFT	Stock	24.61	24.65	24.6	24.64	1162104.0
2010-10-12 13:30:00	MSFT	Stock	24.639	24.67	24.61	24.67	1538911.0
2010-10-12 14:00:00	MSFT	Stock	24.67	24.79	24.65	24.73	3914556.0
2010-10-12 14:30:00	MSFT	Stock	24.725	24.77	24.64	24.76	3714467.0
2010-10-12 15:00:00	MSFT	Stock	24.76	24.93	24.72	24.925	5780014.0
2010-10-12 15:30:00	MSFT	Stock	24.925	24.93	24.83	24.83	8829977.0
2010-10-12 16:00:00	MSFT	Stock	24.83	24.97	24.684	24.95	3518401.0
2010-10-12 16:30:00	MSFT	Stock	24.95	24.99	24.92	24.94	142108.0
2010-10-12 17:00:00	MSFT	Stock	24.93	25.01	24.93	25.0	53117.0

> showing 50 of 72,763 rows — these rows as CSV

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