PREVIEW / stock_30min / 2016-06-16

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-16.parquet
  size:    1.6 MB
  rows:    81,990
  symbols: 3,284

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-06-16 04:00:00	AAPL	Stock	24.285	24.285	24.075	24.075	9768.0
2016-06-16 04:30:00	AAPL	Stock	24.0375	24.04	24.025	24.0375	15276.0
2016-06-16 05:30:00	AAPL	Stock	24.0725	24.11	24.0725	24.11	9860.0
2016-06-16 06:00:00	AAPL	Stock	24.12	24.12	24.075	24.075	10864.0
2016-06-16 06:30:00	AAPL	Stock	24.1225	24.1375	24.1075	24.1225	14496.0
2016-06-16 07:00:00	AAPL	Stock	24.1475	24.1475	24.0875	24.0925	51108.0
2016-06-16 07:30:00	AAPL	Stock	24.0875	24.105	24.075	24.085	54900.0
2016-06-16 08:00:00	AAPL	Stock	24.145	24.145	24.075	24.075	251520.0
2016-06-16 08:30:00	AAPL	Stock	24.0825	24.1025	24.075	24.08	189552.0
2016-06-16 09:00:00	AAPL	Stock	24.075	24.1225	24.075	24.1075	314576.0
2016-06-16 09:30:00	AAPL	Stock	24.11	24.1792	24.05	24.11	17159920.0
2016-06-16 10:00:00	AAPL	Stock	24.1078	24.19	24.065	24.08	10970344.0
2016-06-16 10:30:00	AAPL	Stock	24.0788	24.0975	24.0175	24.075	9041480.0
2016-06-16 11:00:00	AAPL	Stock	24.0725	24.1375	24.0462	24.13	6783476.0
2016-06-16 11:30:00	AAPL	Stock	24.13	24.1475	24.0835	24.1	5280564.0
2016-06-16 12:00:00	AAPL	Stock	24.1	24.2125	24.085	24.1925	6468596.0
2016-06-16 12:30:00	AAPL	Stock	24.195	24.275	24.16	24.2697	7552744.0
2016-06-16 13:00:00	AAPL	Stock	24.2697	24.37	24.2635	24.336	7252632.0
2016-06-16 13:30:00	AAPL	Stock	24.3375	24.3825	24.2775	24.2888	8490128.0
2016-06-16 14:00:00	AAPL	Stock	24.29	24.3675	24.275	24.326	6628100.0
2016-06-16 14:30:00	AAPL	Stock	24.3275	24.3968	24.3175	24.375	4967724.0
2016-06-16 15:00:00	AAPL	Stock	24.375	24.42	24.355	24.4025	6363924.0
2016-06-16 15:30:00	AAPL	Stock	24.4025	24.4375	24.375	24.3925	11913616.0
2016-06-16 16:00:00	AAPL	Stock	24.39	24.435	24.365	24.3875	5337472.0
2016-06-16 16:30:00	AAPL	Stock	24.39	24.3925	24.3875	24.3875	37640.0
2016-06-16 17:00:00	AAPL	Stock	24.3875	24.39	24.375	24.3875	20036.0
2016-06-16 17:30:00	AAPL	Stock	24.3875	24.3875	24.37	24.3875	16596.0
2016-06-16 18:00:00	AAPL	Stock	24.3925	24.3925	24.375	24.3875	27436.0
2016-06-16 18:30:00	AAPL	Stock	24.3875	24.395	24.3875	24.3875	21588.0
2016-06-16 19:00:00	AAPL	Stock	24.3875	24.3875	24.3875	24.3875	14172.0
2016-06-16 19:30:00	AAPL	Stock	24.385	24.4025	24.385	24.4025	58780.0
2016-06-16 04:00:00	MSFT	Stock	49.73	49.73	49.73	49.73	100.0
2016-06-16 08:00:00	MSFT	Stock	49.64	49.64	49.5	49.57	9530.0
2016-06-16 08:30:00	MSFT	Stock	49.52	49.55	49.51	49.52	2400.0
2016-06-16 09:00:00	MSFT	Stock	49.53	49.56	49.5	49.5	26912.0
2016-06-16 09:30:00	MSFT	Stock	49.52	49.77	49.507	49.64	3040134.0
2016-06-16 10:00:00	MSFT	Stock	49.645	49.76	49.6	49.7	2147742.0
2016-06-16 10:30:00	MSFT	Stock	49.7	49.74	49.63	49.685	2296720.0
2016-06-16 11:00:00	MSFT	Stock	49.68	49.97	49.66	49.94	2136529.0
2016-06-16 11:30:00	MSFT	Stock	49.95	49.99	49.87	49.9	1858676.0
2016-06-16 12:00:00	MSFT	Stock	49.9	50.19	49.87	50.14	1683692.0
2016-06-16 12:30:00	MSFT	Stock	50.15	50.3	50.12	50.2	1542049.0
2016-06-16 13:00:00	MSFT	Stock	50.21	50.35	50.125	50.26	1612931.0
2016-06-16 13:30:00	MSFT	Stock	50.26	50.34	50.1	50.127	1308447.0
2016-06-16 14:00:00	MSFT	Stock	50.13	50.38	50.1	50.14	1740961.0
2016-06-16 14:30:00	MSFT	Stock	50.15	50.26	50.08	50.203	2102306.0
2016-06-16 15:00:00	MSFT	Stock	50.21	50.47	50.17	50.44	1918399.0
2016-06-16 15:30:00	MSFT	Stock	50.45	50.46	50.29	50.39	4414008.0
2016-06-16 16:00:00	MSFT	Stock	50.39	50.44	50.37	50.37	1819290.0
2016-06-16 16:30:00	MSFT	Stock	50.37	50.39	50.37	50.39	1485.0

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

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