PREVIEW / stock_30min / 2015-07-22

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-22.parquet
  size:    1.6 MB
  rows:    81,588
  symbols: 3,482

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
2015-07-22 04:00:00	AAPL	Stock	30.425	31.0775	30.425	30.9925	519804.0
2015-07-22 04:30:00	AAPL	Stock	31.0025	31.23	30.86	30.9375	370192.0
2015-07-22 05:00:00	AAPL	Stock	30.9375	30.9975	30.87	30.96	68760.0
2015-07-22 05:30:00	AAPL	Stock	30.96	31.1075	30.8775	30.8775	261164.0
2015-07-22 06:00:00	AAPL	Stock	30.8825	30.9225	30.74	30.8325	569676.0
2015-07-22 06:30:00	AAPL	Stock	30.8425	30.92	30.6425	30.6575	630720.0
2015-07-22 07:00:00	AAPL	Stock	30.6525	30.75	30.625	30.655	622324.0
2015-07-22 07:30:00	AAPL	Stock	30.65	30.715	30.4775	30.61	1777840.0
2015-07-22 08:00:00	AAPL	Stock	30.61	30.9175	30.4125	30.44	4837452.0
2015-07-22 08:30:00	AAPL	Stock	30.4375	30.4625	30.3125	30.405	4498320.0
2015-07-22 09:00:00	AAPL	Stock	30.41	30.695	30.28	30.4975	10830804.0
2015-07-22 09:30:00	AAPL	Stock	30.505	31.2325	30.4975	31.1838	131651192.0
2015-07-22 10:00:00	AAPL	Stock	31.1825	31.235	31.03	31.152	46807560.0
2015-07-22 10:30:00	AAPL	Stock	31.15	31.215	30.98	31.2	32518860.0
2015-07-22 11:00:00	AAPL	Stock	31.205	31.225	30.98	30.9825	21694212.0
2015-07-22 11:30:00	AAPL	Stock	30.9825	31.0475	30.915	30.97	20488124.0
2015-07-22 12:00:00	AAPL	Stock	30.97	31.1475	30.96	31.1475	15229508.0
2015-07-22 12:30:00	AAPL	Stock	31.1462	31.2225	31.085	31.1775	14575908.0
2015-07-22 13:00:00	AAPL	Stock	31.18	31.375	31.165	31.205	23253100.0
2015-07-22 13:30:00	AAPL	Stock	31.2075	31.25	31.1325	31.2225	11358356.0
2015-07-22 14:00:00	AAPL	Stock	31.2212	31.275	31.17	31.2112	12551256.0
2015-07-22 14:30:00	AAPL	Stock	31.2125	31.32	31.18	31.2915	13597292.0
2015-07-22 15:00:00	AAPL	Stock	31.2825	31.305	31.1788	31.2535	14490712.0
2015-07-22 15:30:00	AAPL	Stock	31.2548	31.305	31.1775	31.305	28053140.0
2015-07-22 16:00:00	AAPL	Stock	31.305	31.4375	31.28	31.405	17772448.0
2015-07-22 16:30:00	AAPL	Stock	31.4075	31.425	31.3825	31.4125	207020.0
2015-07-22 17:00:00	AAPL	Stock	31.4125	31.4375	31.3875	31.395	173992.0
2015-07-22 17:30:00	AAPL	Stock	31.4	31.4375	31.3875	31.4025	122324.0
2015-07-22 18:00:00	AAPL	Stock	31.395	31.425	31.395	31.425	96052.0
2015-07-22 18:30:00	AAPL	Stock	31.4275	31.4375	31.4	31.4	71412.0
2015-07-22 19:00:00	AAPL	Stock	31.4008	31.425	31.4008	31.4175	44232.0
2015-07-22 19:30:00	AAPL	Stock	31.4225	31.4375	31.3925	31.4225	132508.0
2015-07-22 04:00:00	MSFT	Stock	45.27	45.27	45.0	45.08	4100.0
2015-07-22 04:30:00	MSFT	Stock	45.2	45.5	45.2	45.5	3100.0
2015-07-22 06:00:00	MSFT	Stock	45.44	45.45	45.44	45.45	500.0
2015-07-22 06:30:00	MSFT	Stock	45.49	45.5	45.25	45.25	6845.0
2015-07-22 07:00:00	MSFT	Stock	45.25	45.45	45.25	45.4	19410.0
2015-07-22 07:30:00	MSFT	Stock	45.35	45.4	45.3	45.39	39285.0
2015-07-22 08:00:00	MSFT	Stock	45.38	45.78	45.3	45.7	76589.0
2015-07-22 08:30:00	MSFT	Stock	45.7	45.8	45.61	45.66	63643.0
2015-07-22 09:00:00	MSFT	Stock	45.67	45.71	45.3	45.4	149958.0
2015-07-22 09:30:00	MSFT	Stock	45.4	46.93	45.351	46.86	9323032.0
2015-07-22 10:00:00	MSFT	Stock	46.87	46.93	46.13	46.15	4910849.0
2015-07-22 10:30:00	MSFT	Stock	46.16	46.2	45.73	45.955	5442442.0
2015-07-22 11:00:00	MSFT	Stock	45.96	46.095	45.83	45.946	5354568.0
2015-07-22 11:30:00	MSFT	Stock	45.94	45.95	45.62	45.83	2923788.0
2015-07-22 12:00:00	MSFT	Stock	45.83	45.9	45.5	45.505	2664844.0
2015-07-22 12:30:00	MSFT	Stock	45.51	45.98	45.43	45.94	3484211.0
2015-07-22 13:00:00	MSFT	Stock	45.94	46.02	45.56	45.57	2829682.0
2015-07-22 13:30:00	MSFT	Stock	45.58	45.62	45.4	45.46	2281089.0

> showing 50 of 81,588 rows — these rows as CSV

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