PREVIEW / stock_30min / 2016-10-14

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-14.parquet
  size:    1.5 MB
  rows:    79,438
  symbols: 3,188

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-10-14 05:30:00	AAPL	Stock	29.3125	29.325	29.3125	29.325	6500.0
2016-10-14 06:00:00	AAPL	Stock	29.3225	29.3725	29.3225	29.36	13820.0
2016-10-14 06:30:00	AAPL	Stock	29.36	29.425	29.36	29.4	24756.0
2016-10-14 07:00:00	AAPL	Stock	29.415	29.415	29.38	29.3975	64084.0
2016-10-14 07:30:00	AAPL	Stock	29.3975	29.43	29.3975	29.43	85480.0
2016-10-14 08:00:00	AAPL	Stock	29.435	29.4375	29.1875	29.405	353636.0
2016-10-14 08:30:00	AAPL	Stock	29.4125	29.4975	29.4125	29.445	285824.0
2016-10-14 09:00:00	AAPL	Stock	29.45	29.5075	29.4425	29.4775	751856.0
2016-10-14 09:30:00	AAPL	Stock	29.47	29.5425	29.3725	29.3912	23435520.0
2016-10-14 10:00:00	AAPL	Stock	29.3925	29.45	29.31	29.3938	11208716.0
2016-10-14 10:30:00	AAPL	Stock	29.395	29.4575	29.3925	29.4125	8384672.0
2016-10-14 11:00:00	AAPL	Stock	29.415	29.42	29.36	29.3775	8750432.0
2016-10-14 11:30:00	AAPL	Stock	29.3752	29.3752	29.2825	29.335	8397680.0
2016-10-14 12:00:00	AAPL	Stock	29.335	29.4225	29.3225	29.42	6887132.0
2016-10-14 12:30:00	AAPL	Stock	29.4198	29.4275	29.3725	29.3975	4688168.0
2016-10-14 13:00:00	AAPL	Stock	29.395	29.4025	29.3538	29.36	4031448.0
2016-10-14 13:30:00	AAPL	Stock	29.3575	29.475	29.345	29.3862	8058912.0
2016-10-14 14:00:00	AAPL	Stock	29.385	29.4225	29.3362	29.41	6227168.0
2016-10-14 14:30:00	AAPL	Stock	29.4125	29.42	29.37	29.38	5107464.0
2016-10-14 15:00:00	AAPL	Stock	29.38	29.445	29.38	29.4025	6412060.0
2016-10-14 15:30:00	AAPL	Stock	29.4038	29.47	29.3875	29.4075	15223808.0
2016-10-14 16:00:00	AAPL	Stock	29.4075	29.4275	29.395	29.41	10147232.0
2016-10-14 16:30:00	AAPL	Stock	29.4225	29.4225	29.4075	29.4125	302880.0
2016-10-14 17:00:00	AAPL	Stock	29.415	29.42	29.405	29.4075	33084.0
2016-10-14 17:30:00	AAPL	Stock	29.41	29.41	29.405	29.405	30700.0
2016-10-14 18:00:00	AAPL	Stock	29.405	29.41	29.39	29.3925	21236.0
2016-10-14 18:30:00	AAPL	Stock	29.4	29.41	29.395	29.41	8852.0
2016-10-14 19:00:00	AAPL	Stock	29.4125	29.4125	29.4	29.4	3580.0
2016-10-14 19:30:00	AAPL	Stock	29.4125	29.4125	29.4075	29.4075	20720.0
2016-10-14 07:00:00	MSFT	Stock	57.2	57.2	57.2	57.2	1000.0
2016-10-14 07:30:00	MSFT	Stock	57.2	57.2	57.2	57.2	800.0
2016-10-14 08:00:00	MSFT	Stock	57.2	57.2	57.2	57.2	200.0
2016-10-14 08:30:00	MSFT	Stock	57.16	57.18	57.16	57.17	4300.0
2016-10-14 09:00:00	MSFT	Stock	57.17	57.18	57.12	57.12	37605.0
2016-10-14 09:30:00	MSFT	Stock	57.12	57.57	57.12	57.49	4067287.0
2016-10-14 10:00:00	MSFT	Stock	57.49	57.63	57.43	57.589	2109012.0
2016-10-14 10:30:00	MSFT	Stock	57.59	57.74	57.56	57.58	1754101.0
2016-10-14 11:00:00	MSFT	Stock	57.585	57.67	57.465	57.562	1686564.0
2016-10-14 11:30:00	MSFT	Stock	57.565	57.565	57.285	57.32	1364564.0
2016-10-14 12:00:00	MSFT	Stock	57.32	57.42	57.24	57.335	1356913.0
2016-10-14 12:30:00	MSFT	Stock	57.336	57.48	57.335	57.455	1166783.0
2016-10-14 13:00:00	MSFT	Stock	57.45	57.54	57.39	57.51	1028699.0
2016-10-14 13:30:00	MSFT	Stock	57.515	57.64	57.39	57.43	1367942.0
2016-10-14 14:00:00	MSFT	Stock	57.43	57.51	57.33	57.51	1061159.0
2016-10-14 14:30:00	MSFT	Stock	57.51	57.53	57.43	57.46	992621.0
2016-10-14 15:00:00	MSFT	Stock	57.461	57.575	57.46	57.505	1386942.0
2016-10-14 15:30:00	MSFT	Stock	57.505	57.62	57.42	57.43	3783027.0
2016-10-14 16:00:00	MSFT	Stock	57.42	57.53	57.42	57.47	2923787.0
2016-10-14 16:30:00	MSFT	Stock	57.42	57.46	57.42	57.43	113561.0
2016-10-14 17:00:00	MSFT	Stock	57.43	57.43	57.43	57.43	180.0

> showing 50 of 79,438 rows — these rows as CSV

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