PREVIEW / stock_30min / 2016-02-24

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-24.parquet
  size:    1.6 MB
  rows:    81,859
  symbols: 3,338

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-02-24 04:00:00	AAPL	Stock	23.55	23.55	23.5	23.5	1800.0
2016-02-24 04:30:00	AAPL	Stock	23.4975	23.4975	23.4975	23.4975	592.0
2016-02-24 05:00:00	AAPL	Stock	23.5075	23.5125	23.4575	23.4575	10840.0
2016-02-24 06:00:00	AAPL	Stock	23.4575	23.475	23.375	23.375	19000.0
2016-02-24 06:30:00	AAPL	Stock	23.375	23.4125	23.35	23.375	24220.0
2016-02-24 07:00:00	AAPL	Stock	23.3725	23.43	23.3625	23.4	89612.0
2016-02-24 07:30:00	AAPL	Stock	23.405	23.445	23.375	23.445	60212.0
2016-02-24 08:00:00	AAPL	Stock	23.4475	23.5	23.375	23.4475	439512.0
2016-02-24 08:30:00	AAPL	Stock	23.4525	23.6725	23.4125	23.495	155892.0
2016-02-24 09:00:00	AAPL	Stock	23.4875	23.4975	23.45	23.495	157648.0
2016-02-24 09:30:00	AAPL	Stock	23.495	23.625	23.38	23.385	21627356.0
2016-02-24 10:00:00	AAPL	Stock	23.385	23.495	23.33	23.4675	12441516.0
2016-02-24 10:30:00	AAPL	Stock	23.47	23.55	23.4175	23.525	9106604.0
2016-02-24 11:00:00	AAPL	Stock	23.5275	23.535	23.3762	23.3975	5917768.0
2016-02-24 11:30:00	AAPL	Stock	23.3952	23.5825	23.3825	23.5575	6935344.0
2016-02-24 12:00:00	AAPL	Stock	23.5575	23.6575	23.555	23.585	6349144.0
2016-02-24 12:30:00	AAPL	Stock	23.585	23.72	23.5525	23.6895	5423748.0
2016-02-24 13:00:00	AAPL	Stock	23.69	23.8	23.6875	23.7625	8755416.0
2016-02-24 13:30:00	AAPL	Stock	23.764	23.8325	23.7338	23.75	6198304.0
2016-02-24 14:00:00	AAPL	Stock	23.75	23.9025	23.7475	23.875	7930308.0
2016-02-24 14:30:00	AAPL	Stock	23.875	23.9375	23.845	23.9325	6868748.0
2016-02-24 15:00:00	AAPL	Stock	23.9325	24.025	23.8975	24.015	12012488.0
2016-02-24 15:30:00	AAPL	Stock	24.0172	24.095	23.9858	24.025	14590388.0
2016-02-24 16:00:00	AAPL	Stock	24.025	24.055	23.6485	24.0375	7296848.0
2016-02-24 16:30:00	AAPL	Stock	24.0375	24.0675	24.035	24.04	28560.0
2016-02-24 17:00:00	AAPL	Stock	24.04	24.0625	24.04	24.0475	36512.0
2016-02-24 17:30:00	AAPL	Stock	24.05	24.06	24.035	24.0525	27072.0
2016-02-24 18:00:00	AAPL	Stock	24.0525	24.0525	24.035	24.035	42432.0
2016-02-24 18:30:00	AAPL	Stock	24.0475	24.0675	24.035	24.0675	38620.0
2016-02-24 19:00:00	AAPL	Stock	24.0625	24.0775	24.0625	24.075	29232.0
2016-02-24 19:30:00	AAPL	Stock	24.075	24.075	24.0525	24.07	58276.0
2016-02-24 06:30:00	MSFT	Stock	50.33	50.5	50.31	50.5	4860.0
2016-02-24 07:00:00	MSFT	Stock	50.5	50.69	50.49	50.69	24146.0
2016-02-24 07:30:00	MSFT	Stock	50.7	50.74	50.67	50.74	24750.0
2016-02-24 08:00:00	MSFT	Stock	50.75	50.75	50.65	50.65	10778.0
2016-02-24 08:30:00	MSFT	Stock	50.61	51.18	50.52	50.53	4165.0
2016-02-24 09:00:00	MSFT	Stock	50.55	50.71	50.47	50.71	49387.0
2016-02-24 09:30:00	MSFT	Stock	50.7	50.73	50.3	50.385	2722048.0
2016-02-24 10:00:00	MSFT	Stock	50.38	50.44	50.2	50.29	1694179.0
2016-02-24 10:30:00	MSFT	Stock	50.3	50.72	50.2	50.66	2484395.0
2016-02-24 11:00:00	MSFT	Stock	50.67	50.7	50.46	50.57	1245067.0
2016-02-24 11:30:00	MSFT	Stock	50.575	51.01	50.55	50.85	1411792.0
2016-02-24 12:00:00	MSFT	Stock	50.85	50.93	50.74	50.78	1383100.0
2016-02-24 12:30:00	MSFT	Stock	50.78	50.9	50.64	50.836	1030181.0
2016-02-24 13:00:00	MSFT	Stock	50.84	50.99	50.73	50.78	1095231.0
2016-02-24 13:30:00	MSFT	Stock	50.778	50.89	50.72	50.789	925319.0
2016-02-24 14:00:00	MSFT	Stock	50.8	51.22	50.735	51.21	3137986.0
2016-02-24 14:30:00	MSFT	Stock	51.213	51.22	51.09	51.213	2447816.0
2016-02-24 15:00:00	MSFT	Stock	51.22	51.46	51.18	51.33	3689723.0
2016-02-24 15:30:00	MSFT	Stock	51.33	51.5	51.19	51.355	5028619.0

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

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