PREVIEW / stock_30min / 2010-01-29

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-29.parquet
  size:    1.4 MB
  rows:    72,891
  symbols: 3,431

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-01-29 04:00:00	AAPL	Stock	7.1279	7.1279	7.1279	7.1279	3500.0
2010-01-29 05:00:00	AAPL	Stock	7.125	7.125	7.125	7.125	5600.0
2010-01-29 06:30:00	AAPL	Stock	7.1425	7.1425	7.1425	7.1425	33600.0
2010-01-29 07:00:00	AAPL	Stock	7.15	7.15	7.1389	7.1414	63868.0
2010-01-29 07:30:00	AAPL	Stock	7.1404	7.1621	7.1404	7.1621	342328.0
2010-01-29 08:00:00	AAPL	Stock	7.1554	7.1757	7.1389	7.1696	2118032.0
2010-01-29 08:30:00	AAPL	Stock	7.1714	7.2411	7.1704	7.1929	6585040.0
2010-01-29 09:00:00	AAPL	Stock	7.1921	7.1921	7.1711	7.1807	3449320.0
2010-01-29 09:30:00	AAPL	Stock	7.1811	7.2214	7.1389	7.1696	130983300.0
2010-01-29 10:00:00	AAPL	Stock	7.1711	7.1825	7.0829	7.1487	106901788.0
2010-01-29 10:30:00	AAPL	Stock	7.1489	7.1636	7.0754	7.08	66756872.0
2010-01-29 11:00:00	AAPL	Stock	7.0799	7.0854	6.9321	6.9675	169044036.0
2010-01-29 11:30:00	AAPL	Stock	6.9675	7.0025	6.9482	6.9647	73500728.0
2010-01-29 12:00:00	AAPL	Stock	6.9646	6.9989	6.9516	6.9907	57554364.0
2010-01-29 12:30:00	AAPL	Stock	6.9911	6.9929	6.9607	6.9718	34879908.0
2010-01-29 13:00:00	AAPL	Stock	6.9718	6.9854	6.9611	6.9632	24493616.0
2010-01-29 13:30:00	AAPL	Stock	6.9632	6.9643	6.8614	6.8836	112399056.0
2010-01-29 14:00:00	AAPL	Stock	6.8839	6.8943	6.8482	6.8654	72794484.0
2010-01-29 14:30:00	AAPL	Stock	6.865	6.8696	6.7946	6.8154	115938200.0
2010-01-29 15:00:00	AAPL	Stock	6.815	6.8457	6.8018	6.8443	94436944.0
2010-01-29 15:30:00	AAPL	Stock	6.8439	6.9014	6.8182	6.8614	141815800.0
2010-01-29 16:00:00	AAPL	Stock	6.8564	6.9832	6.8429	6.8564	17700956.0
2010-01-29 16:30:00	AAPL	Stock	6.8425	7.1525	6.8361	6.8375	2210096.0
2010-01-29 17:00:00	AAPL	Stock	7.1175	7.1275	6.8371	6.8418	617848.0
2010-01-29 17:30:00	AAPL	Stock	6.8432	6.8473	6.8386	6.8386	207368.0
2010-01-29 18:00:00	AAPL	Stock	6.8393	6.8593	6.8236	6.8357	656432.0
2010-01-29 18:30:00	AAPL	Stock	6.835	6.835	6.8214	6.8321	381276.0
2010-01-29 19:00:00	AAPL	Stock	6.8282	6.8354	6.8239	6.8239	179732.0
2010-01-29 19:30:00	AAPL	Stock	6.8243	6.8371	6.8243	6.8357	283136.0
2010-01-29 05:30:00	MSFT	Stock	29.44	29.44	29.44	29.44	100.0
2010-01-29 06:00:00	MSFT	Stock	29.56	29.56	29.56	29.56	200.0
2010-01-29 06:30:00	MSFT	Stock	29.45	29.75	29.45	29.7	8505.0
2010-01-29 07:00:00	MSFT	Stock	29.62	29.62	29.38	29.5	71700.0
2010-01-29 07:30:00	MSFT	Stock	29.45	29.8	29.45	29.7	149289.0
2010-01-29 08:00:00	MSFT	Stock	29.7	30.0	29.55	29.94	1546719.0
2010-01-29 08:30:00	MSFT	Stock	29.94	30.14	29.88	29.95	1450046.0
2010-01-29 09:00:00	MSFT	Stock	29.95	29.96	29.16	29.89	909660.0
2010-01-29 09:30:00	MSFT	Stock	29.89	29.92	28.88	28.9	29289624.0
2010-01-29 10:00:00	MSFT	Stock	28.9	29.2	28.55	29.19	26606431.0
2010-01-29 10:30:00	MSFT	Stock	29.19	29.23	28.86	28.87	9805690.0
2010-01-29 11:00:00	MSFT	Stock	28.87	28.88	28.41	28.41	15512082.0
2010-01-29 11:30:00	MSFT	Stock	28.41	28.685	28.26	28.57	12319750.0
2010-01-29 12:00:00	MSFT	Stock	28.57	28.66	28.42	28.56	8564458.0
2010-01-29 12:30:00	MSFT	Stock	28.565	28.72	28.46	28.661	4834956.0
2010-01-29 13:00:00	MSFT	Stock	28.67	28.75	28.59	28.6	4100370.0
2010-01-29 13:30:00	MSFT	Stock	28.592	28.6	28.18	28.23	9613050.0
2010-01-29 14:00:00	MSFT	Stock	28.23	28.32	28.13	28.16	7964006.0
2010-01-29 14:30:00	MSFT	Stock	28.16	28.175	27.66	27.82	21101450.0
2010-01-29 15:00:00	MSFT	Stock	27.81	27.99	27.72	27.93	12141428.0
2010-01-29 15:30:00	MSFT	Stock	27.93	28.25	27.78	28.14	18654317.0

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

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