PREVIEW / stock_30min / 2017-11-13

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-13.parquet
  size:    1.7 MB
  rows:    83,453
  symbols: 2,956

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
2017-11-13 04:00:00	AAPL	Stock	43.675	43.69	43.675	43.69	4400.0
2017-11-13 04:30:00	AAPL	Stock	43.675	43.75	43.65	43.65	2400.0
2017-11-13 06:00:00	AAPL	Stock	43.625	43.625	43.5625	43.5625	1600.0
2017-11-13 07:00:00	AAPL	Stock	43.5625	43.5825	43.4925	43.5025	77396.0
2017-11-13 07:30:00	AAPL	Stock	43.4825	43.515	43.475	43.475	69060.0
2017-11-13 08:00:00	AAPL	Stock	43.595	43.6025	43.47	43.4725	191260.0
2017-11-13 08:30:00	AAPL	Stock	43.475	43.4775	43.425	43.4375	152808.0
2017-11-13 09:00:00	AAPL	Stock	43.43	43.455	43.365	43.3775	161232.0
2017-11-13 09:30:00	AAPL	Stock	43.375	43.5375	43.35	43.4675	12953136.0
2017-11-13 10:00:00	AAPL	Stock	43.4675	43.625	43.4675	43.5688	6807460.0
2017-11-13 10:30:00	AAPL	Stock	43.57	43.595	43.44	43.55	5224472.0
2017-11-13 11:00:00	AAPL	Stock	43.5488	43.605	43.52	43.5725	3511892.0
2017-11-13 11:30:00	AAPL	Stock	43.5725	43.5962	43.5325	43.56	2337264.0
2017-11-13 12:00:00	AAPL	Stock	43.5612	43.5925	43.515	43.5825	3298496.0
2017-11-13 12:30:00	AAPL	Stock	43.5838	43.5975	43.5525	43.585	1844520.0
2017-11-13 13:00:00	AAPL	Stock	43.5825	43.6	43.5285	43.5625	1887328.0
2017-11-13 13:30:00	AAPL	Stock	43.5603	43.5965	43.535	43.5925	2056748.0
2017-11-13 14:00:00	AAPL	Stock	43.5948	43.5975	43.5625	43.575	2072208.0
2017-11-13 14:30:00	AAPL	Stock	43.5762	43.58	43.5148	43.5275	2365572.0
2017-11-13 15:00:00	AAPL	Stock	43.5275	43.565	43.4925	43.5	2990612.0
2017-11-13 15:30:00	AAPL	Stock	43.4988	43.515	43.43	43.495	7483240.0
2017-11-13 16:00:00	AAPL	Stock	43.4925	43.495	43.4625	43.475	4105104.0
2017-11-13 16:30:00	AAPL	Stock	43.6675	43.6675	43.4625	43.4625	71308.0
2017-11-13 17:00:00	AAPL	Stock	43.4725	43.4825	43.455	43.4775	26616.0
2017-11-13 17:30:00	AAPL	Stock	43.475	43.4825	43.47	43.47	25564.0
2017-11-13 18:00:00	AAPL	Stock	43.47	43.485	43.45	43.45	26608.0
2017-11-13 18:30:00	AAPL	Stock	43.4525	43.4725	43.4525	43.4725	6400.0
2017-11-13 19:00:00	AAPL	Stock	43.47	43.47	43.45	43.45	18560.0
2017-11-13 19:30:00	AAPL	Stock	43.45	43.465	43.45	43.455	12444.0
2017-11-13 05:00:00	MSFT	Stock	83.8	83.8	83.8	83.8	179.0
2017-11-13 07:30:00	MSFT	Stock	83.61	83.61	83.6	83.6	2193.0
2017-11-13 08:00:00	MSFT	Stock	83.75	83.8	83.6	83.67	9425.0
2017-11-13 08:30:00	MSFT	Stock	83.61	83.68	83.61	83.61	4160.0
2017-11-13 09:00:00	MSFT	Stock	83.61	83.7	83.54	83.7	10047.0
2017-11-13 09:30:00	MSFT	Stock	83.66	83.75	83.46	83.53	1479970.0
2017-11-13 10:00:00	MSFT	Stock	83.535	83.76	83.53	83.735	821809.0
2017-11-13 10:30:00	MSFT	Stock	83.74	83.76	83.57	83.61	604483.0
2017-11-13 11:00:00	MSFT	Stock	83.61	83.68	83.58	83.63	662675.0
2017-11-13 11:30:00	MSFT	Stock	83.63	83.64	83.53	83.564	528217.0
2017-11-13 12:00:00	MSFT	Stock	83.57	83.63	83.51	83.61	434190.0
2017-11-13 12:30:00	MSFT	Stock	83.615	83.655	83.53	83.605	366055.0
2017-11-13 13:00:00	MSFT	Stock	83.6	83.64	83.53	83.62	382585.0
2017-11-13 13:30:00	MSFT	Stock	83.62	83.72	83.6	83.71	446701.0
2017-11-13 14:00:00	MSFT	Stock	83.705	83.86	83.68	83.815	542649.0
2017-11-13 14:30:00	MSFT	Stock	83.815	83.87	83.63	83.653	614728.0
2017-11-13 15:00:00	MSFT	Stock	83.66	83.86	83.66	83.855	697223.0
2017-11-13 15:30:00	MSFT	Stock	83.855	83.94	83.67	83.93	1517224.0
2017-11-13 16:00:00	MSFT	Stock	83.93	83.97	83.81	83.93	3839157.0
2017-11-13 16:30:00	MSFT	Stock	83.9	83.9	83.9	83.9	500.0
2017-11-13 17:00:00	MSFT	Stock	83.9	83.92	83.85	83.85	2000.0

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

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