PREVIEW / stock_30min / 2016-06-02

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-02.parquet
  size:    1.6 MB
  rows:    82,343
  symbols: 3,318

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-02 04:00:00	AAPL	Stock	24.5075	24.5075	24.4975	24.4975	1200.0
2016-06-02 04:30:00	AAPL	Stock	24.4975	24.5	24.4975	24.5	1040.0
2016-06-02 05:00:00	AAPL	Stock	24.48	24.48	24.465	24.465	5280.0
2016-06-02 05:30:00	AAPL	Stock	24.465	24.465	24.465	24.465	2108.0
2016-06-02 06:00:00	AAPL	Stock	24.465	24.5	24.465	24.48	11136.0
2016-06-02 06:30:00	AAPL	Stock	24.4875	24.5	24.4575	24.4925	32296.0
2016-06-02 07:00:00	AAPL	Stock	24.4925	24.5	24.4625	24.47	69324.0
2016-06-02 07:30:00	AAPL	Stock	24.47	24.48	24.45	24.455	39244.0
2016-06-02 08:00:00	AAPL	Stock	24.45	24.4925	24.405	24.4625	403956.0
2016-06-02 08:30:00	AAPL	Stock	24.465	24.47	24.4425	24.45	159676.0
2016-06-02 09:00:00	AAPL	Stock	24.445	24.485	24.3875	24.395	447564.0
2016-06-02 09:30:00	AAPL	Stock	24.3925	24.4325	24.1575	24.257	35122132.0
2016-06-02 10:00:00	AAPL	Stock	24.255	24.3875	24.235	24.3575	15256668.0
2016-06-02 10:30:00	AAPL	Stock	24.36	24.385	24.295	24.38	8023612.0
2016-06-02 11:00:00	AAPL	Stock	24.38	24.46	24.3725	24.3825	9724520.0
2016-06-02 11:30:00	AAPL	Stock	24.3825	24.3875	24.305	24.315	7858968.0
2016-06-02 12:00:00	AAPL	Stock	24.3165	24.33	24.1925	24.236	12028276.0
2016-06-02 12:30:00	AAPL	Stock	24.2375	24.325	24.1975	24.3212	7512872.0
2016-06-02 13:00:00	AAPL	Stock	24.3212	24.345	24.2675	24.31	6782564.0
2016-06-02 13:30:00	AAPL	Stock	24.3075	24.335	24.2775	24.3263	4902496.0
2016-06-02 14:00:00	AAPL	Stock	24.3275	24.39	24.3252	24.3615	6408644.0
2016-06-02 14:30:00	AAPL	Stock	24.3625	24.4425	24.35	24.405	6708732.0
2016-06-02 15:00:00	AAPL	Stock	24.4075	24.4375	24.3825	24.4225	6072588.0
2016-06-02 15:30:00	AAPL	Stock	24.4225	24.4475	24.385	24.425	12023012.0
2016-06-02 16:00:00	AAPL	Stock	24.43	24.4575	24.405	24.4475	9224036.0
2016-06-02 16:30:00	AAPL	Stock	24.45	24.45	24.405	24.4125	78640.0
2016-06-02 17:00:00	AAPL	Stock	24.4125	24.4925	24.41	24.45	567224.0
2016-06-02 17:30:00	AAPL	Stock	24.455	24.455	24.4325	24.4375	29888.0
2016-06-02 18:00:00	AAPL	Stock	24.4325	24.4375	24.4325	24.4325	20392.0
2016-06-02 18:30:00	AAPL	Stock	24.4425	24.45	24.4375	24.4375	12008.0
2016-06-02 19:00:00	AAPL	Stock	24.4475	24.45	24.4475	24.45	4672.0
2016-06-02 19:30:00	AAPL	Stock	24.45	24.46	24.4475	24.4475	9084.0
2016-06-02 07:00:00	MSFT	Stock	52.85	52.85	52.85	52.85	2000.0
2016-06-02 07:30:00	MSFT	Stock	52.85	52.85	52.85	52.85	4800.0
2016-06-02 08:00:00	MSFT	Stock	52.9	52.9	52.85	52.89	2539.0
2016-06-02 08:30:00	MSFT	Stock	52.85	52.87	52.84	52.84	31630.0
2016-06-02 09:00:00	MSFT	Stock	52.81	52.85	52.6	52.6	183285.0
2016-06-02 09:30:00	MSFT	Stock	52.64	52.74	51.85	51.865	3972743.0
2016-06-02 10:00:00	MSFT	Stock	51.86	52.19	51.835	52.17	2154405.0
2016-06-02 10:30:00	MSFT	Stock	52.165	52.315	52.16	52.295	1673654.0
2016-06-02 11:00:00	MSFT	Stock	52.3	52.4	52.175	52.23	1330341.0
2016-06-02 11:30:00	MSFT	Stock	52.235	52.34	52.16	52.27	1036926.0
2016-06-02 12:00:00	MSFT	Stock	52.27	52.3	52.165	52.185	841147.0
2016-06-02 12:30:00	MSFT	Stock	52.19	52.31	52.125	52.3	658538.0
2016-06-02 13:00:00	MSFT	Stock	52.3	52.41	52.28	52.34	567177.0
2016-06-02 13:30:00	MSFT	Stock	52.335	52.44	52.31	52.384	823116.0
2016-06-02 14:00:00	MSFT	Stock	52.39	52.48	52.37	52.41	860053.0
2016-06-02 14:30:00	MSFT	Stock	52.41	52.43	52.35	52.4	653569.0
2016-06-02 15:00:00	MSFT	Stock	52.4	52.45	52.35	52.415	1175478.0
2016-06-02 15:30:00	MSFT	Stock	52.42	52.48	52.32	52.48	3319151.0

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

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