PREVIEW / stock_30min / 2017-04-17

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-17.parquet
  size:    1.6 MB
  rows:    80,397
  symbols: 3,063

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-04-17 06:30:00	AAPL	Stock	35.2775	35.3575	35.2775	35.3575	1600.0
2017-04-17 07:00:00	AAPL	Stock	35.325	35.355	35.325	35.355	2720.0
2017-04-17 07:30:00	AAPL	Stock	35.3725	35.41	35.3725	35.41	6708.0
2017-04-17 08:00:00	AAPL	Stock	35.405	35.445	35.325	35.43	97296.0
2017-04-17 08:30:00	AAPL	Stock	35.4375	35.4825	35.4275	35.4825	72152.0
2017-04-17 09:00:00	AAPL	Stock	35.475	35.4825	35.2875	35.295	339420.0
2017-04-17 09:30:00	AAPL	Stock	35.295	35.425	35.2768	35.3075	11532684.0
2017-04-17 10:00:00	AAPL	Stock	35.305	35.3875	35.2625	35.2625	5956404.0
2017-04-17 10:30:00	AAPL	Stock	35.2625	35.3	35.2175	35.28	5113596.0
2017-04-17 11:00:00	AAPL	Stock	35.28	35.3388	35.235	35.325	3198436.0
2017-04-17 11:30:00	AAPL	Stock	35.3235	35.33	35.2662	35.275	2172248.0
2017-04-17 12:00:00	AAPL	Stock	35.275	35.34	35.2725	35.3212	2237788.0
2017-04-17 12:30:00	AAPL	Stock	35.3212	35.3525	35.31	35.344	2363964.0
2017-04-17 13:00:00	AAPL	Stock	35.345	35.3725	35.3275	35.3675	2679388.0
2017-04-17 13:30:00	AAPL	Stock	35.37	35.3812	35.3438	35.3535	1706124.0
2017-04-17 14:00:00	AAPL	Stock	35.3525	35.38	35.3325	35.3625	2589592.0
2017-04-17 14:30:00	AAPL	Stock	35.361	35.3875	35.3315	35.3425	2074524.0
2017-04-17 15:00:00	AAPL	Stock	35.3425	35.43	35.3275	35.41	3485380.0
2017-04-17 15:30:00	AAPL	Stock	35.4075	35.4675	35.3875	35.4575	8067220.0
2017-04-17 16:00:00	AAPL	Stock	35.47	35.47	35.445	35.4525	4277036.0
2017-04-17 16:30:00	AAPL	Stock	35.4625	35.4625	35.445	35.4625	49340.0
2017-04-17 17:00:00	AAPL	Stock	35.4525	35.475	35.4525	35.47	66188.0
2017-04-17 17:30:00	AAPL	Stock	35.47	35.475	35.46	35.475	13852.0
2017-04-17 18:00:00	AAPL	Stock	35.4625	35.4725	35.4625	35.4625	10692.0
2017-04-17 18:30:00	AAPL	Stock	35.4725	35.4725	35.465	35.4675	5236.0
2017-04-17 19:00:00	AAPL	Stock	35.4675	35.475	35.46	35.46	19536.0
2017-04-17 19:30:00	AAPL	Stock	35.475	35.475	35.45	35.45	23172.0
2017-04-17 07:30:00	MSFT	Stock	64.81	65.12	64.8	65.12	300.0
2017-04-17 08:00:00	MSFT	Stock	65.17	65.17	65.09	65.09	700.0
2017-04-17 08:30:00	MSFT	Stock	65.13	65.13	65.1	65.1	2100.0
2017-04-17 09:00:00	MSFT	Stock	65.1	65.15	65.04	65.07	13367.0
2017-04-17 09:30:00	MSFT	Stock	65.04	65.4	65.01	65.27	1535676.0
2017-04-17 10:00:00	MSFT	Stock	65.265	65.45	65.2	65.355	814818.0
2017-04-17 10:30:00	MSFT	Stock	65.36	65.4	65.29	65.325	670330.0
2017-04-17 11:00:00	MSFT	Stock	65.325	65.47	65.32	65.35	893470.0
2017-04-17 11:30:00	MSFT	Stock	65.36	65.44	65.333	65.36	871941.0
2017-04-17 12:00:00	MSFT	Stock	65.36	65.46	65.36	65.415	531334.0
2017-04-17 12:30:00	MSFT	Stock	65.42	65.42	65.32	65.345	382008.0
2017-04-17 13:00:00	MSFT	Stock	65.34	65.42	65.31	65.396	365598.0
2017-04-17 13:30:00	MSFT	Stock	65.395	65.44	65.33	65.39	458480.0
2017-04-17 14:00:00	MSFT	Stock	65.4	65.43	65.34	65.37	592919.0
2017-04-17 14:30:00	MSFT	Stock	65.365	65.42	65.31	65.335	786008.0
2017-04-17 15:00:00	MSFT	Stock	65.33	65.49	65.3	65.473	1268602.0
2017-04-17 15:30:00	MSFT	Stock	65.475	65.49	65.36	65.47	2804378.0
2017-04-17 16:00:00	MSFT	Stock	65.48	65.48	65.4	65.4	2137098.0
2017-04-17 16:30:00	MSFT	Stock	65.5	65.5	65.5	65.5	825.0
2017-04-17 17:00:00	MSFT	Stock	65.5	65.5	65.5	65.5	300.0
2017-04-17 17:30:00	MSFT	Stock	65.45	65.45	65.45	65.45	360.0
2017-04-17 18:00:00	MSFT	Stock	65.49	65.49	65.49	65.49	100.0
2017-04-17 19:00:00	MSFT	Stock	65.5	65.5	65.5	65.5	2873.0

> showing 50 of 80,397 rows — these rows as CSV

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