PREVIEW / stock_30min / 2012-11-20

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-20.parquet
  size:    1.4 MB
  rows:    74,684
  symbols: 3,472

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
2012-11-20 04:00:00	AAPL	Stock	20.2764	20.2786	20.2554	20.2643	62300.0
2012-11-20 04:30:00	AAPL	Stock	20.2607	20.2607	20.2257	20.2386	45640.0
2012-11-20 05:00:00	AAPL	Stock	20.2268	20.2529	20.2268	20.2529	38220.0
2012-11-20 05:30:00	AAPL	Stock	20.2554	20.3	20.2554	20.2779	81368.0
2012-11-20 06:00:00	AAPL	Stock	20.2714	20.2714	20.2432	20.2536	187264.0
2012-11-20 06:30:00	AAPL	Stock	20.2446	20.25	20.2321	20.2321	51800.0
2012-11-20 07:00:00	AAPL	Stock	20.2407	20.25	20.2286	20.2336	486416.0
2012-11-20 07:30:00	AAPL	Stock	20.2286	20.2286	20.1814	20.1839	733068.0
2012-11-20 08:00:00	AAPL	Stock	20.1857	20.2554	20.1021	20.1861	1600060.0
2012-11-20 08:30:00	AAPL	Stock	20.1846	20.2961	20.1661	20.2857	2346288.0
2012-11-20 09:00:00	AAPL	Stock	20.2857	20.4411	20.2682	20.4154	9013648.0
2012-11-20 09:30:00	AAPL	Stock	20.425	20.4268	20.0446	20.1425	142788688.0
2012-11-20 10:00:00	AAPL	Stock	20.1393	20.2596	20.1089	20.1671	54033588.0
2012-11-20 10:30:00	AAPL	Stock	20.1671	20.1904	19.9496	19.9586	57550248.0
2012-11-20 11:00:00	AAPL	Stock	19.9589	20.1375	19.8739	20.1089	47903380.0
2012-11-20 11:30:00	AAPL	Stock	20.1079	20.1568	20.0318	20.1271	33141304.0
2012-11-20 12:00:00	AAPL	Stock	20.13	20.1375	20.0218	20.0571	20302968.0
2012-11-20 12:30:00	AAPL	Stock	20.0564	20.0714	19.9414	20.0446	30875012.0
2012-11-20 13:00:00	AAPL	Stock	20.0464	20.0604	19.8064	19.815	49055720.0
2012-11-20 13:30:00	AAPL	Stock	19.8171	19.9439	19.8121	19.9277	33700268.0
2012-11-20 14:00:00	AAPL	Stock	19.9279	20.0321	19.8629	20.0167	28108248.0
2012-11-20 14:30:00	AAPL	Stock	20.0184	20.0564	19.9643	19.9982	27761552.0
2012-11-20 15:00:00	AAPL	Stock	19.9973	20.0714	19.9286	19.9818	28161840.0
2012-11-20 15:30:00	AAPL	Stock	19.9832	20.0443	19.9332	20.0407	45544212.0
2012-11-20 16:00:00	AAPL	Stock	20.0221	20.0964	20.0221	20.0325	16097760.0
2012-11-20 16:30:00	AAPL	Stock	20.0411	20.0643	20.0411	20.0614	277564.0
2012-11-20 17:00:00	AAPL	Stock	20.0593	21.2597	20.0436	20.05	135520.0
2012-11-20 17:30:00	AAPL	Stock	20.05	20.0625	20.05	20.0625	206892.0
2012-11-20 18:00:00	AAPL	Stock	20.0607	20.0629	20.0571	20.0618	36540.0
2012-11-20 18:30:00	AAPL	Stock	20.0607	20.0786	20.0607	20.0782	130900.0
2012-11-20 19:00:00	AAPL	Stock	20.075	20.0836	20.0714	20.0829	62132.0
2012-11-20 19:30:00	AAPL	Stock	20.0889	20.1032	20.0825	20.0982	162064.0
2012-11-20 07:00:00	MSFT	Stock	26.73	26.73	26.72	26.72	1800.0
2012-11-20 07:30:00	MSFT	Stock	26.71	26.75	26.65	26.65	4700.0
2012-11-20 08:00:00	MSFT	Stock	26.7	26.75	26.7	26.7	12199.0
2012-11-20 08:30:00	MSFT	Stock	26.75	26.82	26.72	26.8	37196.0
2012-11-20 09:00:00	MSFT	Stock	26.77	26.83	26.72	26.72	188907.0
2012-11-20 09:30:00	MSFT	Stock	26.76	26.8	26.47	26.62	6519290.0
2012-11-20 10:00:00	MSFT	Stock	26.62	26.67	26.54	26.645	4241294.0
2012-11-20 10:30:00	MSFT	Stock	26.645	26.65	26.55	26.57	5156656.0
2012-11-20 11:00:00	MSFT	Stock	26.57	26.64	26.55	26.625	2588983.0
2012-11-20 11:30:00	MSFT	Stock	26.62	26.69	26.6	26.69	1807846.0
2012-11-20 12:00:00	MSFT	Stock	26.68	26.69	26.59	26.61	1733407.0
2012-11-20 12:30:00	MSFT	Stock	26.615	26.62	26.58	26.6	1612662.0
2012-11-20 13:00:00	MSFT	Stock	26.61	26.61	26.46	26.52	6187870.0
2012-11-20 13:30:00	MSFT	Stock	26.52	26.59	26.52	26.585	2034433.0
2012-11-20 14:00:00	MSFT	Stock	26.58	26.62	26.57	26.57	1741409.0
2012-11-20 14:30:00	MSFT	Stock	26.58	26.58	26.545	26.58	1854120.0
2012-11-20 15:00:00	MSFT	Stock	26.572	26.61	26.56	26.605	2546152.0
2012-11-20 15:30:00	MSFT	Stock	26.6	26.71	26.59	26.71	6117900.0

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

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