PREVIEW / stock_30min / 2015-06-22

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-22.parquet
  size:    1.6 MB
  rows:    83,849
  symbols: 3,531

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-06-22 04:00:00	AAPL	Stock	31.845	31.925	31.845	31.9	56380.0
2015-06-22 04:30:00	AAPL	Stock	31.9	31.9725	31.9	31.9725	17900.0
2015-06-22 05:00:00	AAPL	Stock	31.9725	31.985	31.925	31.9625	24504.0
2015-06-22 05:30:00	AAPL	Stock	31.9725	31.975	31.95	31.97	9700.0
2015-06-22 06:00:00	AAPL	Stock	31.9275	31.9275	31.855	31.8775	48492.0
2015-06-22 06:30:00	AAPL	Stock	31.8775	31.9325	31.8675	31.8675	35852.0
2015-06-22 07:00:00	AAPL	Stock	31.8875	31.9275	31.875	31.92	180104.0
2015-06-22 07:30:00	AAPL	Stock	31.915	31.915	31.875	31.8875	116968.0
2015-06-22 08:00:00	AAPL	Stock	31.8875	31.9075	31.8175	31.8225	603960.0
2015-06-22 08:30:00	AAPL	Stock	31.8232	31.84	31.8125	31.83	238156.0
2015-06-22 09:00:00	AAPL	Stock	31.8325	31.915	31.83	31.8675	588876.0
2015-06-22 09:30:00	AAPL	Stock	31.8725	31.925	31.805	31.8448	20827344.0
2015-06-22 10:00:00	AAPL	Stock	31.8438	31.9	31.8275	31.8378	9953556.0
2015-06-22 10:30:00	AAPL	Stock	31.8425	31.8875	31.815	31.865	7880632.0
2015-06-22 11:00:00	AAPL	Stock	31.865	31.9775	31.835	31.9775	9968636.0
2015-06-22 11:30:00	AAPL	Stock	31.975	32.015	31.965	31.9925	10831196.0
2015-06-22 12:00:00	AAPL	Stock	31.9925	32.0	31.87	31.8875	8147248.0
2015-06-22 12:30:00	AAPL	Stock	31.8875	31.925	31.88	31.91	4605432.0
2015-06-22 13:00:00	AAPL	Stock	31.91	31.91	31.825	31.825	5952388.0
2015-06-22 13:30:00	AAPL	Stock	31.8275	31.885	31.77	31.885	6757796.0
2015-06-22 14:00:00	AAPL	Stock	31.8875	31.8875	31.85	31.86	3917364.0
2015-06-22 14:30:00	AAPL	Stock	31.86	31.915	31.8325	31.8935	5639128.0
2015-06-22 15:00:00	AAPL	Stock	31.8948	31.91	31.875	31.8875	4277548.0
2015-06-22 15:30:00	AAPL	Stock	31.8888	31.91	31.86	31.9025	8390696.0
2015-06-22 16:00:00	AAPL	Stock	31.9	31.9125	31.8175	31.8725	19563100.0
2015-06-22 16:30:00	AAPL	Stock	31.87	31.9025	31.8632	31.8775	20504.0
2015-06-22 17:00:00	AAPL	Stock	31.8775	31.9525	31.875	31.8875	541488.0
2015-06-22 17:30:00	AAPL	Stock	31.88	31.88	31.88	31.88	4296.0
2015-06-22 18:00:00	AAPL	Stock	31.8875	31.9	31.8875	31.9	32360.0
2015-06-22 18:30:00	AAPL	Stock	31.8925	31.9025	31.89	31.8975	30720.0
2015-06-22 19:00:00	AAPL	Stock	31.9	31.9125	31.8992	31.9075	36076.0
2015-06-22 19:30:00	AAPL	Stock	31.9075	31.9125	31.8925	31.895	50508.0
2015-06-22 04:00:00	MSFT	Stock	46.4	46.43	46.4	46.43	290.0
2015-06-22 06:30:00	MSFT	Stock	46.38	46.38	46.33	46.33	3600.0
2015-06-22 07:00:00	MSFT	Stock	46.34	46.4	46.34	46.4	300.0
2015-06-22 07:30:00	MSFT	Stock	46.41	46.41	46.4	46.4	700.0
2015-06-22 08:00:00	MSFT	Stock	46.4	46.4	46.31	46.37	13829.0
2015-06-22 08:30:00	MSFT	Stock	46.32	46.33	46.31	46.33	5110.0
2015-06-22 09:00:00	MSFT	Stock	46.36	46.45	46.22	46.25	39084.0
2015-06-22 09:30:00	MSFT	Stock	46.23	46.567	46.23	46.48	2847186.0
2015-06-22 10:00:00	MSFT	Stock	46.48	46.515	46.41	46.46	1053177.0
2015-06-22 10:30:00	MSFT	Stock	46.46	46.59	46.45	46.564	1262607.0
2015-06-22 11:00:00	MSFT	Stock	46.56	46.72	46.515	46.71	1178896.0
2015-06-22 11:30:00	MSFT	Stock	46.705	46.705	46.48	46.485	889771.0
2015-06-22 12:00:00	MSFT	Stock	46.49	46.52	46.33	46.36	988176.0
2015-06-22 12:30:00	MSFT	Stock	46.36	46.42	46.31	46.35	617721.0
2015-06-22 13:00:00	MSFT	Stock	46.346	46.36	46.235	46.29	600671.0
2015-06-22 13:30:00	MSFT	Stock	46.29	46.36	46.26	46.36	687111.0
2015-06-22 14:00:00	MSFT	Stock	46.36	46.37	46.25	46.266	595056.0
2015-06-22 14:30:00	MSFT	Stock	46.26	46.37	46.21	46.36	960776.0

> showing 50 of 83,849 rows — these rows as CSV

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