PREVIEW / stock_30min / 2015-01-15

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-15.parquet
  size:    1.6 MB
  rows:    83,773
  symbols: 3,517

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-01-15 04:00:00	AAPL	Stock	27.645	27.665	27.53	27.5575	25600.0
2015-01-15 04:30:00	AAPL	Stock	27.5775	27.58	27.1875	27.425	59880.0
2015-01-15 05:00:00	AAPL	Stock	27.3875	27.4625	27.255	27.425	19996.0
2015-01-15 05:30:00	AAPL	Stock	27.425	27.455	27.31	27.31	23996.0
2015-01-15 06:00:00	AAPL	Stock	27.3125	27.3375	27.155	27.175	92836.0
2015-01-15 06:30:00	AAPL	Stock	27.19	27.25	27.1825	27.25	34040.0
2015-01-15 07:00:00	AAPL	Stock	27.2375	27.3775	27.215	27.3675	177664.0
2015-01-15 07:30:00	AAPL	Stock	27.37	27.41	27.25	27.3	262068.0
2015-01-15 08:00:00	AAPL	Stock	27.31	27.4125	27.1775	27.3875	549476.0
2015-01-15 08:30:00	AAPL	Stock	27.3875	27.5825	27.3875	27.5075	712748.0
2015-01-15 09:00:00	AAPL	Stock	27.485	27.54	27.45	27.5	453836.0
2015-01-15 09:30:00	AAPL	Stock	27.5	27.515	26.94	26.95	34235868.0
2015-01-15 10:00:00	AAPL	Stock	26.9425	27.195	26.885	27.1225	23945104.0
2015-01-15 10:30:00	AAPL	Stock	27.1225	27.21	27.0025	27.0125	14467428.0
2015-01-15 11:00:00	AAPL	Stock	27.015	27.0575	26.7325	26.76	20206468.0
2015-01-15 11:30:00	AAPL	Stock	26.7622	26.885	26.6875	26.7825	17210672.0
2015-01-15 12:00:00	AAPL	Stock	26.7825	26.8675	26.7525	26.7998	8971984.0
2015-01-15 12:30:00	AAPL	Stock	26.8	26.8225	26.665	26.75	14181280.0
2015-01-15 13:00:00	AAPL	Stock	26.75	26.86	26.7425	26.7975	10775656.0
2015-01-15 13:30:00	AAPL	Stock	26.795	26.835	26.7425	26.775	8115904.0
2015-01-15 14:00:00	AAPL	Stock	26.7728	26.8425	26.7425	26.825	7975444.0
2015-01-15 14:30:00	AAPL	Stock	26.824	26.9738	26.79	26.9375	11798400.0
2015-01-15 15:00:00	AAPL	Stock	26.9375	26.9675	26.7925	26.8725	12228144.0
2015-01-15 15:30:00	AAPL	Stock	26.8725	26.915	26.7025	26.7075	21580868.0
2015-01-15 16:00:00	AAPL	Stock	26.705	27.4955	26.7018	26.7425	10747672.0
2015-01-15 16:30:00	AAPL	Stock	26.7425	26.75	26.7	26.705	269352.0
2015-01-15 17:00:00	AAPL	Stock	26.72	26.7275	26.7	26.7075	93696.0
2015-01-15 17:30:00	AAPL	Stock	26.7075	26.715	26.675	26.705	158096.0
2015-01-15 18:00:00	AAPL	Stock	26.715	26.7175	26.665	26.6775	108368.0
2015-01-15 18:30:00	AAPL	Stock	26.685	26.685	26.65	26.665	56588.0
2015-01-15 19:00:00	AAPL	Stock	26.665	26.675	26.625	26.625	199472.0
2015-01-15 19:30:00	AAPL	Stock	26.625	26.645	26.54	26.55	241104.0
2015-01-15 04:30:00	MSFT	Stock	46.2	46.2	46.1	46.1	2100.0
2015-01-15 05:30:00	MSFT	Stock	45.91	45.91	45.9	45.9	2300.0
2015-01-15 06:30:00	MSFT	Stock	45.79	45.79	45.79	45.79	1200.0
2015-01-15 07:00:00	MSFT	Stock	46.0	46.19	46.0	46.19	1750.0
2015-01-15 07:30:00	MSFT	Stock	46.0	46.0	45.95	45.95	500.0
2015-01-15 08:30:00	MSFT	Stock	46.19	46.2	46.19	46.2	615.0
2015-01-15 09:00:00	MSFT	Stock	46.16	46.27	46.1	46.27	25574.0
2015-01-15 09:30:00	MSFT	Stock	46.26	46.38	45.53	45.75	3773662.0
2015-01-15 10:00:00	MSFT	Stock	45.74	46.0	45.6	45.93	2312974.0
2015-01-15 10:30:00	MSFT	Stock	45.935	46.05	45.75	45.81	2269250.0
2015-01-15 11:00:00	MSFT	Stock	45.81	45.905	45.57	45.6	1491416.0
2015-01-15 11:30:00	MSFT	Stock	45.6	45.7	45.52	45.65	1935255.0
2015-01-15 12:00:00	MSFT	Stock	45.65	45.81	45.61	45.68	1349117.0
2015-01-15 12:30:00	MSFT	Stock	45.68	45.68	45.44	45.595	1398937.0
2015-01-15 13:00:00	MSFT	Stock	45.6	45.825	45.535	45.65	1124450.0
2015-01-15 13:30:00	MSFT	Stock	45.655	45.68	45.52	45.52	1172389.0
2015-01-15 14:00:00	MSFT	Stock	45.525	45.66	45.46	45.565	1433963.0
2015-01-15 14:30:00	MSFT	Stock	45.564	45.735	45.523	45.69	1469754.0

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

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