PREVIEW / stock_30min / 2015-03-16

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-16.parquet
  size:    1.6 MB
  rows:    83,242
  symbols: 3,525

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
2015-03-16 04:00:00	AAPL	Stock	30.9075	30.95	30.9075	30.95	7040.0
2015-03-16 04:30:00	AAPL	Stock	30.925	31.0125	30.925	31.0	25440.0
2015-03-16 05:00:00	AAPL	Stock	31.02	31.0425	30.995	30.995	3200.0
2015-03-16 05:30:00	AAPL	Stock	30.985	31.0	30.985	30.995	10400.0
2015-03-16 06:00:00	AAPL	Stock	31.0	31.0	30.9975	30.9975	19312.0
2015-03-16 06:30:00	AAPL	Stock	30.9975	30.9975	30.9625	30.9625	11948.0
2015-03-16 07:00:00	AAPL	Stock	30.98	30.9825	30.95	30.95	4200.0
2015-03-16 07:30:00	AAPL	Stock	30.9575	30.9575	30.9325	30.9325	64204.0
2015-03-16 08:00:00	AAPL	Stock	30.95	30.9825	30.86	30.905	325292.0
2015-03-16 08:30:00	AAPL	Stock	30.9002	30.9275	30.8375	30.8775	401516.0
2015-03-16 09:00:00	AAPL	Stock	30.8775	30.975	30.8775	30.9225	614952.0
2015-03-16 09:30:00	AAPL	Stock	30.97	30.9975	30.7175	30.91	23518900.0
2015-03-16 10:00:00	AAPL	Stock	30.9125	31.1025	30.9075	31.035	14581972.0
2015-03-16 10:30:00	AAPL	Stock	31.0375	31.12	30.9875	31.0225	9939036.0
2015-03-16 11:00:00	AAPL	Stock	31.025	31.11	31.015	31.0925	6756264.0
2015-03-16 11:30:00	AAPL	Stock	31.095	31.125	31.075	31.08	7421548.0
2015-03-16 12:00:00	AAPL	Stock	31.08	31.095	30.9775	31.0275	6290388.0
2015-03-16 12:30:00	AAPL	Stock	31.0272	31.065	31.0175	31.0338	3504916.0
2015-03-16 13:00:00	AAPL	Stock	31.035	31.0475	30.9875	31.045	4339776.0
2015-03-16 13:30:00	AAPL	Stock	31.045	31.0725	31.0188	31.0675	4420932.0
2015-03-16 14:00:00	AAPL	Stock	31.0675	31.1212	31.06	31.1075	5478288.0
2015-03-16 14:30:00	AAPL	Stock	31.11	31.1425	31.0875	31.1225	6338216.0
2015-03-16 15:00:00	AAPL	Stock	31.125	31.19	31.1235	31.165	8810380.0
2015-03-16 15:30:00	AAPL	Stock	31.1675	31.2375	31.165	31.235	16537444.0
2015-03-16 16:00:00	AAPL	Stock	31.2375	31.2405	31.0438	31.2375	13384160.0
2015-03-16 16:30:00	AAPL	Stock	31.175	31.2375	31.1158	31.1575	79104.0
2015-03-16 17:00:00	AAPL	Stock	31.17	31.2375	31.16	31.2375	1184480.0
2015-03-16 17:30:00	AAPL	Stock	31.175	31.2375	31.17	31.17	37720.0
2015-03-16 18:00:00	AAPL	Stock	31.18	31.18	31.15	31.18	20032.0
2015-03-16 18:30:00	AAPL	Stock	31.1825	31.1825	31.1625	31.1675	13000.0
2015-03-16 19:00:00	AAPL	Stock	31.1675	31.18	31.1625	31.175	26436.0
2015-03-16 19:30:00	AAPL	Stock	31.175	31.195	31.15	31.19	107888.0
2015-03-16 06:30:00	MSFT	Stock	41.34	41.39	41.27	41.39	1645.0
2015-03-16 07:00:00	MSFT	Stock	41.48	41.5	41.48	41.5	1050.0
2015-03-16 07:30:00	MSFT	Stock	41.45	41.45	41.4	41.4	200.0
2015-03-16 08:00:00	MSFT	Stock	41.469	41.469	41.25	41.35	4721.0
2015-03-16 08:30:00	MSFT	Stock	41.43	41.49	41.3	41.34	11771.0
2015-03-16 09:00:00	MSFT	Stock	41.34	41.57	41.33	41.47	90581.0
2015-03-16 09:30:00	MSFT	Stock	41.47	41.63	41.355	41.59	4319995.0
2015-03-16 10:00:00	MSFT	Stock	41.58	41.6	41.285	41.33	2539124.0
2015-03-16 10:30:00	MSFT	Stock	41.33	41.39	41.28	41.37	1744968.0
2015-03-16 11:00:00	MSFT	Stock	41.375	41.51	41.35	41.435	1872718.0
2015-03-16 11:30:00	MSFT	Stock	41.44	41.5	41.35	41.38	1790169.0
2015-03-16 12:00:00	MSFT	Stock	41.37	41.405	41.34	41.385	1252706.0
2015-03-16 12:30:00	MSFT	Stock	41.385	41.48	41.37	41.39	1545540.0
2015-03-16 13:00:00	MSFT	Stock	41.39	41.4	41.3	41.34	1548181.0
2015-03-16 13:30:00	MSFT	Stock	41.345	41.41	41.34	41.41	1782930.0
2015-03-16 14:00:00	MSFT	Stock	41.405	41.42	41.35	41.39	1769100.0
2015-03-16 14:30:00	MSFT	Stock	41.4	41.46	41.39	41.444	2351014.0
2015-03-16 15:00:00	MSFT	Stock	41.445	41.49	41.42	41.48	1985525.0

> showing 50 of 83,242 rows — these rows as CSV

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