PREVIEW / stock_30min / 2016-08-04

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-04.parquet
  size:    1.6 MB
  rows:    81,997
  symbols: 3,250

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-08-04 04:00:00	AAPL	Stock	26.355	26.355	26.355	26.355	4000.0
2016-08-04 04:30:00	AAPL	Stock	26.36	26.395	26.36	26.375	14800.0
2016-08-04 05:00:00	AAPL	Stock	26.3725	26.3725	26.3425	26.345	9200.0
2016-08-04 05:30:00	AAPL	Stock	26.3275	26.3375	26.325	26.3375	6400.0
2016-08-04 06:00:00	AAPL	Stock	26.3325	26.375	26.3325	26.3725	42080.0
2016-08-04 06:30:00	AAPL	Stock	26.3725	26.3725	26.36	26.36	1200.0
2016-08-04 07:00:00	AAPL	Stock	26.36	26.375	26.35	26.375	86276.0
2016-08-04 07:30:00	AAPL	Stock	26.3625	26.4125	26.3575	26.38	62724.0
2016-08-04 08:00:00	AAPL	Stock	26.3825	26.4125	26.3325	26.375	304336.0
2016-08-04 08:30:00	AAPL	Stock	26.3725	26.4225	26.37	26.385	262756.0
2016-08-04 09:00:00	AAPL	Stock	26.385	26.4075	26.37	26.385	254272.0
2016-08-04 09:30:00	AAPL	Stock	26.3925	26.5	26.3275	26.38	20877752.0
2016-08-04 10:00:00	AAPL	Stock	26.3775	26.4075	26.32	26.389	10725152.0
2016-08-04 10:30:00	AAPL	Stock	26.39	26.465	26.3775	26.45	7384180.0
2016-08-04 11:00:00	AAPL	Stock	26.45	26.48	26.4175	26.4325	5573148.0
2016-08-04 11:30:00	AAPL	Stock	26.4325	26.4438	26.38	26.4275	5686960.0
2016-08-04 12:00:00	AAPL	Stock	26.4285	26.45	26.395	26.41	3375120.0
2016-08-04 12:30:00	AAPL	Stock	26.411	26.4375	26.3925	26.4065	3058408.0
2016-08-04 13:00:00	AAPL	Stock	26.405	26.415	26.385	26.4075	3377028.0
2016-08-04 13:30:00	AAPL	Stock	26.4075	26.455	26.4	26.4462	3670892.0
2016-08-04 14:00:00	AAPL	Stock	26.4462	26.475	26.3925	26.436	5645828.0
2016-08-04 14:30:00	AAPL	Stock	26.4375	26.4675	26.425	26.4622	3507848.0
2016-08-04 15:00:00	AAPL	Stock	26.46	26.4612	26.425	26.4572	3561680.0
2016-08-04 15:30:00	AAPL	Stock	26.4575	26.5	26.4575	26.4725	11391984.0
2016-08-04 16:00:00	AAPL	Stock	26.4675	26.4775	26.4575	26.4575	4163232.0
2016-08-04 16:30:00	AAPL	Stock	26.465	26.47	26.4575	26.4575	16820.0
2016-08-04 17:00:00	AAPL	Stock	26.4625	26.4675	26.455	26.4575	738116.0
2016-08-04 17:30:00	AAPL	Stock	26.4575	26.4675	26.395	26.455	23440.0
2016-08-04 18:00:00	AAPL	Stock	26.455	26.475	26.455	26.475	43248.0
2016-08-04 18:30:00	AAPL	Stock	26.47	26.47	26.4625	26.4625	10000.0
2016-08-04 19:00:00	AAPL	Stock	26.47	26.47	26.47	26.47	3920.0
2016-08-04 19:30:00	AAPL	Stock	26.4675	26.47	26.4625	26.47	33012.0
2016-08-04 07:00:00	MSFT	Stock	56.99	57.03	56.92	56.96	1520.0
2016-08-04 08:00:00	MSFT	Stock	56.95	56.99	56.92	56.92	1900.0
2016-08-04 09:00:00	MSFT	Stock	56.96	56.96	56.96	56.96	240.0
2016-08-04 09:30:00	MSFT	Stock	56.8	56.97	56.67	56.81	1919772.0
2016-08-04 10:00:00	MSFT	Stock	56.815	56.96	56.79	56.89	1356426.0
2016-08-04 10:30:00	MSFT	Stock	56.885	57.13	56.88	57.12	1190727.0
2016-08-04 11:00:00	MSFT	Stock	57.12	57.17	57.07	57.15	1140162.0
2016-08-04 11:30:00	MSFT	Stock	57.15	57.29	57.14	57.27	1650615.0
2016-08-04 12:00:00	MSFT	Stock	57.27	57.44	57.26	57.4	1756784.0
2016-08-04 12:30:00	MSFT	Stock	57.41	57.519	57.395	57.42	1572315.0
2016-08-04 13:00:00	MSFT	Stock	57.425	57.46	57.35	57.425	1550403.0
2016-08-04 13:30:00	MSFT	Stock	57.43	57.43	57.305	57.36	1209049.0
2016-08-04 14:00:00	MSFT	Stock	57.37	57.43	57.34	57.4	1479290.0
2016-08-04 14:30:00	MSFT	Stock	57.4	57.48	57.355	57.465	1675660.0
2016-08-04 15:00:00	MSFT	Stock	57.465	57.48	57.38	57.41	1353567.0
2016-08-04 15:30:00	MSFT	Stock	57.42	57.51	57.34	57.39	4672503.0
2016-08-04 16:00:00	MSFT	Stock	57.39	57.52	57.39	57.481	1742752.0
2016-08-04 16:30:00	MSFT	Stock	57.39	57.54	57.39	57.54	8157.0

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

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