PREVIEW / stock_30min / 2010-06-23

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-23.parquet
  size:    1.3 MB
  rows:    74,476
  symbols: 3,437

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-06-23 04:00:00	AAPL	Stock	9.8393	9.8393	9.8393	9.8393	2800.0
2010-06-23 05:00:00	AAPL	Stock	9.8393	9.8571	9.8393	9.8571	23800.0
2010-06-23 05:30:00	AAPL	Stock	9.8571	9.8929	9.8571	9.8929	33768.0
2010-06-23 06:00:00	AAPL	Stock	9.8929	9.8929	9.8929	9.8929	8400.0
2010-06-23 06:30:00	AAPL	Stock	9.8857	9.8929	9.8857	9.8929	14000.0
2010-06-23 07:00:00	AAPL	Stock	9.8575	9.8575	9.8	9.8304	884436.0
2010-06-23 07:30:00	AAPL	Stock	9.8243	9.8389	9.8129	9.8354	638120.0
2010-06-23 08:00:00	AAPL	Stock	9.8357	9.8482	9.8146	9.8282	2843120.0
2010-06-23 08:30:00	AAPL	Stock	9.8304	9.8411	9.8221	9.8261	1904868.0
2010-06-23 09:00:00	AAPL	Stock	9.8264	9.8307	9.7975	9.805	2715524.0
2010-06-23 09:30:00	AAPL	Stock	9.8064	9.8093	9.625	9.6474	144339552.0
2010-06-23 10:00:00	AAPL	Stock	9.6475	9.6475	9.5679	9.58	109688348.0
2010-06-23 10:30:00	AAPL	Stock	9.5796	9.6818	9.5796	9.67	67776940.0
2010-06-23 11:00:00	AAPL	Stock	9.6698	9.6857	9.6393	9.6775	37944060.0
2010-06-23 11:30:00	AAPL	Stock	9.6775	9.6832	9.6339	9.655	26096364.0
2010-06-23 12:00:00	AAPL	Stock	9.6546	9.6693	9.6186	9.6464	24438400.0
2010-06-23 12:30:00	AAPL	Stock	9.6468	9.7311	9.6357	9.6882	30971864.0
2010-06-23 13:00:00	AAPL	Stock	9.6861	9.7196	9.6536	9.6889	31310636.0
2010-06-23 13:30:00	AAPL	Stock	9.6879	9.7125	9.6782	9.7125	18759916.0
2010-06-23 14:00:00	AAPL	Stock	9.7111	9.7114	9.6364	9.6771	43090376.0
2010-06-23 14:30:00	AAPL	Stock	9.6771	9.7539	9.6296	9.6532	83613740.0
2010-06-23 15:00:00	AAPL	Stock	9.655	9.725	9.6071	9.6546	60386676.0
2010-06-23 15:30:00	AAPL	Stock	9.6543	9.7054	9.6264	9.6779	61031292.0
2010-06-23 16:00:00	AAPL	Stock	9.6761	9.6875	9.6601	9.6602	5573288.0
2010-06-23 16:30:00	AAPL	Stock	9.6843	9.8007	9.6436	9.6607	1282876.0
2010-06-23 17:00:00	AAPL	Stock	9.6636	9.6775	9.6464	9.6464	639996.0
2010-06-23 17:30:00	AAPL	Stock	9.6457	9.6518	9.6418	9.6418	305452.0
2010-06-23 18:00:00	AAPL	Stock	9.6429	9.6775	9.6375	9.6518	304220.0
2010-06-23 18:30:00	AAPL	Stock	9.6554	9.6625	9.6536	9.6536	162596.0
2010-06-23 19:00:00	AAPL	Stock	9.6604	9.6604	9.6464	9.6464	77868.0
2010-06-23 19:30:00	AAPL	Stock	9.6539	9.6571	9.6479	9.6482	219044.0
2010-06-23 08:00:00	MSFT	Stock	25.95	25.95	25.9	25.9	3425.0
2010-06-23 08:30:00	MSFT	Stock	25.86	25.9	25.85	25.9	1423.0
2010-06-23 09:00:00	MSFT	Stock	25.85	25.88	25.74	25.77	80127.0
2010-06-23 09:30:00	MSFT	Stock	25.76	25.78	25.45	25.54	6031309.0
2010-06-23 10:00:00	MSFT	Stock	25.53	25.53	25.25	25.29	6901204.0
2010-06-23 10:30:00	MSFT	Stock	25.285	25.43	25.28	25.36	3877343.0
2010-06-23 11:00:00	MSFT	Stock	25.36	25.46	25.33	25.45	2849251.0
2010-06-23 11:30:00	MSFT	Stock	25.45	25.45	25.3	25.34	2134843.0
2010-06-23 12:00:00	MSFT	Stock	25.348	25.42	25.322	25.41	1516876.0
2010-06-23 12:30:00	MSFT	Stock	25.41	25.48	25.36	25.45	1516925.0
2010-06-23 13:00:00	MSFT	Stock	25.45	25.52	25.37	25.422	2237873.0
2010-06-23 13:30:00	MSFT	Stock	25.43	25.46	25.37	25.44	2740079.0
2010-06-23 14:00:00	MSFT	Stock	25.43	25.49	25.3	25.44	4492574.0
2010-06-23 14:30:00	MSFT	Stock	25.43	25.58	25.31	25.352	5839470.0
2010-06-23 15:00:00	MSFT	Stock	25.36	25.4	25.22	25.35	6012358.0
2010-06-23 15:30:00	MSFT	Stock	25.35	25.42	25.27	25.32	10842241.0
2010-06-23 16:00:00	MSFT	Stock	25.33	25.399	25.25	25.34	2342856.0
2010-06-23 16:30:00	MSFT	Stock	25.384	25.384	25.3	25.31	139375.0
2010-06-23 17:00:00	MSFT	Stock	25.33	25.385	25.32	25.385	127872.0

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

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