PREVIEW / stock_30min / 2010-04-23

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-23.parquet
  size:    1.4 MB
  rows:    74,587
  symbols: 3,494

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-04-23 04:00:00	AAPL	Stock	9.5264	9.5268	9.5121	9.5121	50400.0
2010-04-23 04:30:00	AAPL	Stock	9.5157	9.5714	9.5143	9.5221	135240.0
2010-04-23 05:00:00	AAPL	Stock	9.5464	9.5586	9.5429	9.5586	11200.0
2010-04-23 05:30:00	AAPL	Stock	9.5571	9.5589	9.5571	9.5589	59752.0
2010-04-23 06:00:00	AAPL	Stock	9.5607	9.5607	9.5589	9.5589	41048.0
2010-04-23 06:30:00	AAPL	Stock	9.5589	9.5589	9.5457	9.55	21224.0
2010-04-23 07:00:00	AAPL	Stock	9.5625	9.5625	9.5411	9.5411	213640.0
2010-04-23 07:30:00	AAPL	Stock	9.545	9.5586	9.5357	9.5586	156520.0
2010-04-23 08:00:00	AAPL	Stock	9.55	9.6036	9.55	9.5929	3271632.0
2010-04-23 08:30:00	AAPL	Stock	9.5936	9.6018	9.575	9.6	3072524.0
2010-04-23 09:00:00	AAPL	Stock	9.5982	9.6107	9.5686	9.5714	4614344.0
2010-04-23 09:30:00	AAPL	Stock	9.5711	9.7207	9.5357	9.6991	213679368.0
2010-04-23 10:00:00	AAPL	Stock	9.6993	9.7129	9.6539	9.6604	97060460.0
2010-04-23 10:30:00	AAPL	Stock	9.6604	9.6875	9.6329	9.6514	73618972.0
2010-04-23 11:00:00	AAPL	Stock	9.6514	9.6714	9.6214	9.6382	57521212.0
2010-04-23 11:30:00	AAPL	Stock	9.6375	9.6518	9.6071	9.6207	46207952.0
2010-04-23 12:00:00	AAPL	Stock	9.6207	9.6357	9.6036	9.6186	30600836.0
2010-04-23 12:30:00	AAPL	Stock	9.6196	9.6707	9.6104	9.6671	30621500.0
2010-04-23 13:00:00	AAPL	Stock	9.6668	9.6675	9.6429	9.6439	22489712.0
2010-04-23 13:30:00	AAPL	Stock	9.6443	9.6536	9.6254	9.6449	20729492.0
2010-04-23 14:00:00	AAPL	Stock	9.6439	9.6668	9.6314	9.6623	24135244.0
2010-04-23 14:30:00	AAPL	Stock	9.6618	9.7025	9.6568	9.6992	47418028.0
2010-04-23 15:00:00	AAPL	Stock	9.6989	9.7029	9.6696	9.6709	29836856.0
2010-04-23 15:30:00	AAPL	Stock	9.6704	9.6789	9.6518	9.6732	59236996.0
2010-04-23 16:00:00	AAPL	Stock	9.6714	9.6754	9.5129	9.6714	14999600.0
2010-04-23 16:30:00	AAPL	Stock	9.6693	9.675	9.6074	9.6714	2170756.0
2010-04-23 17:00:00	AAPL	Stock	9.5126	9.6818	9.5126	9.6804	335944.0
2010-04-23 17:30:00	AAPL	Stock	9.6818	9.6839	9.6786	9.6786	214732.0
2010-04-23 18:00:00	AAPL	Stock	9.6757	9.6786	9.6711	9.6721	333676.0
2010-04-23 18:30:00	AAPL	Stock	9.6696	9.6757	9.6696	9.6746	397768.0
2010-04-23 19:00:00	AAPL	Stock	9.6732	9.675	9.6732	9.6746	184464.0
2010-04-23 19:30:00	AAPL	Stock	9.675	9.6775	9.6732	9.6775	172396.0
2010-04-23 04:00:00	MSFT	Stock	30.48	30.48	30.37	30.37	400.0
2010-04-23 04:30:00	MSFT	Stock	30.4	30.46	30.4	30.46	750.0
2010-04-23 05:00:00	MSFT	Stock	30.46	30.49	30.46	30.49	1650.0
2010-04-23 05:30:00	MSFT	Stock	30.49	30.49	30.49	30.49	700.0
2010-04-23 06:00:00	MSFT	Stock	30.51	30.52	30.51	30.52	1200.0
2010-04-23 06:30:00	MSFT	Stock	30.55	30.55	30.39	30.55	11079.0
2010-04-23 07:00:00	MSFT	Stock	30.56	30.89	30.56	30.81	276933.0
2010-04-23 07:30:00	MSFT	Stock	30.84	31.05	30.82	30.85	793799.0
2010-04-23 08:00:00	MSFT	Stock	31.0	31.1	30.7	31.06	1381917.0
2010-04-23 08:30:00	MSFT	Stock	31.05	31.29	30.88	30.95	2300985.0
2010-04-23 09:00:00	MSFT	Stock	30.99	31.14	30.96	31.12	1008707.0
2010-04-23 09:30:00	MSFT	Stock	31.12	31.58	30.95	31.0	28629660.0
2010-04-23 10:00:00	MSFT	Stock	31.01	31.22	30.92	30.99	15281235.0
2010-04-23 10:30:00	MSFT	Stock	30.985	31.03	30.79	30.829	10368857.0
2010-04-23 11:00:00	MSFT	Stock	30.82	30.91	30.74	30.82	6418609.0
2010-04-23 11:30:00	MSFT	Stock	30.819	30.94	30.7	30.902	6330382.0
2010-04-23 12:00:00	MSFT	Stock	30.9	31.0	30.86	30.87	5498930.0
2010-04-23 12:30:00	MSFT	Stock	30.87	30.95	30.82	30.895	3996761.0

> showing 50 of 74,587 rows — these rows as CSV

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