PREVIEW / stock_30min / 2017-10-31

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-31.parquet
  size:    1.7 MB
  rows:    82,889
  symbols: 2,945

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-10-31 04:00:00	AAPL	Stock	41.75	41.77	41.75	41.77	3272.0
2017-10-31 05:00:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	1984.0
2017-10-31 05:30:00	AAPL	Stock	41.8625	41.8625	41.8625	41.8625	1600.0
2017-10-31 06:00:00	AAPL	Stock	41.87	41.925	41.845	41.9	8148.0
2017-10-31 06:30:00	AAPL	Stock	41.885	41.92	41.775	41.7775	17568.0
2017-10-31 07:00:00	AAPL	Stock	41.775	41.8675	41.775	41.8375	148260.0
2017-10-31 07:30:00	AAPL	Stock	41.8625	41.92	41.8425	41.9175	138204.0
2017-10-31 08:00:00	AAPL	Stock	41.865	42.0175	41.77	41.9725	508360.0
2017-10-31 08:30:00	AAPL	Stock	41.9625	42.0925	41.96	42.0375	522544.0
2017-10-31 09:00:00	AAPL	Stock	42.0225	42.0725	41.965	41.99	816304.0
2017-10-31 09:30:00	AAPL	Stock	41.975	42.1725	41.735	41.8	22556676.0
2017-10-31 10:00:00	AAPL	Stock	41.8025	42.035	41.795	41.945	9177712.0
2017-10-31 10:30:00	AAPL	Stock	41.945	42.1175	41.93	42.0975	8561620.0
2017-10-31 11:00:00	AAPL	Stock	42.095	42.2525	42.09	42.2075	10241600.0
2017-10-31 11:30:00	AAPL	Stock	42.2075	42.2725	42.1375	42.2288	8171752.0
2017-10-31 12:00:00	AAPL	Stock	42.2325	42.2375	42.155	42.205	5700764.0
2017-10-31 12:30:00	AAPL	Stock	42.2038	42.3	42.1675	42.2125	5147560.0
2017-10-31 13:00:00	AAPL	Stock	42.21	42.235	42.1275	42.209	5035600.0
2017-10-31 13:30:00	AAPL	Stock	42.21	42.2925	42.1962	42.2925	5445848.0
2017-10-31 14:00:00	AAPL	Stock	42.2912	42.4125	42.2625	42.3448	8404340.0
2017-10-31 14:30:00	AAPL	Stock	42.3445	42.35	42.21	42.264	6392092.0
2017-10-31 15:00:00	AAPL	Stock	42.265	42.325	42.2588	42.27	5383008.0
2017-10-31 15:30:00	AAPL	Stock	42.2725	42.3	42.2	42.2625	14002100.0
2017-10-31 16:00:00	AAPL	Stock	42.26	42.2875	42.1995	42.2475	14017204.0
2017-10-31 16:30:00	AAPL	Stock	42.2625	42.2625	42.2225	42.2425	351824.0
2017-10-31 17:00:00	AAPL	Stock	42.26	42.26	42.1575	42.1575	72076.0
2017-10-31 17:30:00	AAPL	Stock	42.1625	42.175	42.0625	42.175	197884.0
2017-10-31 18:00:00	AAPL	Stock	42.175	42.2075	42.15	42.175	56120.0
2017-10-31 18:30:00	AAPL	Stock	42.1625	42.2125	42.1625	42.2075	27648.0
2017-10-31 19:00:00	AAPL	Stock	42.2075	42.225	42.195	42.195	9492.0
2017-10-31 19:30:00	AAPL	Stock	42.2225	42.265	42.2225	42.25	47112.0
2017-10-31 04:00:00	MSFT	Stock	84.16	84.16	84.16	84.16	118.0
2017-10-31 07:00:00	MSFT	Stock	83.89	84.03	83.89	84.0	5224.0
2017-10-31 07:30:00	MSFT	Stock	84.0	84.1	83.93	84.1	2591.0
2017-10-31 08:00:00	MSFT	Stock	84.0	84.17	83.92	84.17	16472.0
2017-10-31 08:30:00	MSFT	Stock	84.17	84.19	84.11	84.15	9925.0
2017-10-31 09:00:00	MSFT	Stock	84.12	84.39	84.07	84.33	17877.0
2017-10-31 09:30:00	MSFT	Stock	84.33	84.36	83.56	83.58	2587580.0
2017-10-31 10:00:00	MSFT	Stock	83.58	83.87	83.51	83.75	1997457.0
2017-10-31 10:30:00	MSFT	Stock	83.74	83.84	83.64	83.75	1327212.0
2017-10-31 11:00:00	MSFT	Stock	83.755	83.79	83.61	83.63	1278923.0
2017-10-31 11:30:00	MSFT	Stock	83.635	83.805	83.59	83.745	1314156.0
2017-10-31 12:00:00	MSFT	Stock	83.745	83.76	83.31	83.405	1823929.0
2017-10-31 12:30:00	MSFT	Stock	83.41	83.55	83.41	83.47	919310.0
2017-10-31 13:00:00	MSFT	Stock	83.475	83.6	83.4	83.4	939526.0
2017-10-31 13:30:00	MSFT	Stock	83.395	83.43	83.25	83.43	1163657.0
2017-10-31 14:00:00	MSFT	Stock	83.43	83.565	83.38	83.38	1147011.0
2017-10-31 14:30:00	MSFT	Stock	83.38	83.425	83.29	83.304	1580160.0
2017-10-31 15:00:00	MSFT	Stock	83.305	83.355	83.21	83.314	1828869.0
2017-10-31 15:30:00	MSFT	Stock	83.32	83.45	83.11	83.18	3665402.0

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

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