PREVIEW / stock_30min / 2016-07-29

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-29.parquet
  size:    1.6 MB
  rows:    82,060
  symbols: 3,286

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
2016-07-29 04:00:00	AAPL	Stock	26.0	26.11	26.0	26.11	800.0
2016-07-29 04:30:00	AAPL	Stock	26.035	26.0375	26.035	26.0375	4000.0
2016-07-29 05:30:00	AAPL	Stock	26.015	26.015	26.015	26.015	1600.0
2016-07-29 06:00:00	AAPL	Stock	26.045	26.0525	26.045	26.0525	9816.0
2016-07-29 06:30:00	AAPL	Stock	26.065	26.1125	26.05	26.1125	4200.0
2016-07-29 07:00:00	AAPL	Stock	26.055	26.1	26.05	26.1	26768.0
2016-07-29 07:30:00	AAPL	Stock	26.0975	26.12	26.0925	26.0925	18516.0
2016-07-29 08:00:00	AAPL	Stock	26.065	26.125	26.04	26.125	125676.0
2016-07-29 08:30:00	AAPL	Stock	26.125	26.125	26.065	26.0875	167672.0
2016-07-29 09:00:00	AAPL	Stock	26.09	26.1025	26.0325	26.06	188792.0
2016-07-29 09:30:00	AAPL	Stock	26.0475	26.1375	25.92	26.0325	21396976.0
2016-07-29 10:00:00	AAPL	Stock	26.0325	26.035	25.9475	25.97	7686100.0
2016-07-29 10:30:00	AAPL	Stock	25.9675	26.003	25.95	25.9852	6122944.0
2016-07-29 11:00:00	AAPL	Stock	25.9875	26.032	25.9725	25.985	5570384.0
2016-07-29 11:30:00	AAPL	Stock	25.985	26.0512	25.985	26.0175	4964836.0
2016-07-29 12:00:00	AAPL	Stock	26.015	26.045	26.015	26.03	3941556.0
2016-07-29 12:30:00	AAPL	Stock	26.03	26.0525	26.01	26.0112	3466708.0
2016-07-29 13:00:00	AAPL	Stock	26.0125	26.0825	26.0	26.08	4863760.0
2016-07-29 13:30:00	AAPL	Stock	26.08	26.1	26.0628	26.09	4149008.0
2016-07-29 14:00:00	AAPL	Stock	26.09	26.0925	26.0588	26.0888	3714856.0
2016-07-29 14:30:00	AAPL	Stock	26.0888	26.0888	26.02	26.0575	4931784.0
2016-07-29 15:00:00	AAPL	Stock	26.0575	26.0625	26.0275	26.0335	4504320.0
2016-07-29 15:30:00	AAPL	Stock	26.0325	26.0825	26.025	26.0487	12704752.0
2016-07-29 16:00:00	AAPL	Stock	26.0475	26.0575	26.0425	26.055	10537472.0
2016-07-29 16:30:00	AAPL	Stock	26.055	26.07	26.0525	26.055	98352.0
2016-07-29 17:00:00	AAPL	Stock	26.0525	26.06	26.0525	26.06	430212.0
2016-07-29 17:30:00	AAPL	Stock	26.055	26.06	26.0475	26.06	20972.0
2016-07-29 18:00:00	AAPL	Stock	26.055	26.0575	26.0525	26.055	7008.0
2016-07-29 18:30:00	AAPL	Stock	26.055	26.06	26.0525	26.0575	22200.0
2016-07-29 19:00:00	AAPL	Stock	26.0575	26.065	26.05	26.065	47944.0
2016-07-29 19:30:00	AAPL	Stock	26.065	26.075	26.0625	26.0625	27256.0
2016-07-29 06:30:00	MSFT	Stock	55.94	56.35	55.94	56.35	1100.0
2016-07-29 07:30:00	MSFT	Stock	56.0	56.01	56.0	56.01	400.0
2016-07-29 08:00:00	MSFT	Stock	56.0	56.0	55.9	55.9	4320.0
2016-07-29 08:30:00	MSFT	Stock	55.92	55.99	55.81	55.81	12012.0
2016-07-29 09:00:00	MSFT	Stock	55.86	56.26	55.86	56.25	181516.0
2016-07-29 09:30:00	MSFT	Stock	56.16	56.66	56.05	56.5	3391108.0
2016-07-29 10:00:00	MSFT	Stock	56.51	56.575	56.46	56.495	2930647.0
2016-07-29 10:30:00	MSFT	Stock	56.5	56.67	56.46	56.6	1544837.0
2016-07-29 11:00:00	MSFT	Stock	56.6	56.68	56.58	56.585	1112038.0
2016-07-29 11:30:00	MSFT	Stock	56.59	56.61	56.485	56.492	915507.0
2016-07-29 12:00:00	MSFT	Stock	56.495	56.53	56.42	56.45	891801.0
2016-07-29 12:30:00	MSFT	Stock	56.46	56.51	56.442	56.495	999478.0
2016-07-29 13:00:00	MSFT	Stock	56.495	56.52	56.44	56.52	1039243.0
2016-07-29 13:30:00	MSFT	Stock	56.52	56.525	56.432	56.435	1001019.0
2016-07-29 14:00:00	MSFT	Stock	56.435	56.52	56.431	56.5	1282144.0
2016-07-29 14:30:00	MSFT	Stock	56.5	56.58	56.45	56.558	1586718.0
2016-07-29 15:00:00	MSFT	Stock	56.55	56.57	56.48	56.51	2041925.0
2016-07-29 15:30:00	MSFT	Stock	56.52	56.76	56.5	56.69	5598246.0
2016-07-29 16:00:00	MSFT	Stock	56.69	56.7	56.62	56.68	4176770.0

> showing 50 of 82,060 rows — these rows as CSV

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