PREVIEW / stock_30min / 2015-08-20

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-20.parquet
  size:    1.6 MB
  rows:    82,615
  symbols: 3,454

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-08-20 04:00:00	AAPL	Stock	28.6775	28.6775	28.6025	28.615	14000.0
2015-08-20 04:30:00	AAPL	Stock	28.6125	28.6175	28.58	28.58	21292.0
2015-08-20 05:00:00	AAPL	Stock	28.5875	28.5875	28.5325	28.5325	34156.0
2015-08-20 05:30:00	AAPL	Stock	28.56	28.61	28.56	28.59	24992.0
2015-08-20 06:00:00	AAPL	Stock	28.605	28.6225	28.5775	28.5875	40316.0
2015-08-20 06:30:00	AAPL	Stock	28.5875	28.615	28.5375	28.555	61244.0
2015-08-20 07:00:00	AAPL	Stock	28.565	28.575	28.5375	28.5725	101964.0
2015-08-20 07:30:00	AAPL	Stock	28.565	28.59	28.5325	28.575	129564.0
2015-08-20 08:00:00	AAPL	Stock	28.5825	28.585	28.5025	28.535	436224.0
2015-08-20 08:30:00	AAPL	Stock	28.535	28.605	28.535	28.57	289576.0
2015-08-20 09:00:00	AAPL	Stock	28.57	28.5825	28.4975	28.5125	438632.0
2015-08-20 09:30:00	AAPL	Stock	28.52	28.5875	28.3	28.3325	31282316.0
2015-08-20 10:00:00	AAPL	Stock	28.3225	28.4412	27.9375	28.02	34183192.0
2015-08-20 10:30:00	AAPL	Stock	28.02	28.22	28.0038	28.1452	23380996.0
2015-08-20 11:00:00	AAPL	Stock	28.145	28.1975	28.015	28.03	17992648.0
2015-08-20 11:30:00	AAPL	Stock	28.0275	28.15	27.9075	28.1475	18219788.0
2015-08-20 12:00:00	AAPL	Stock	28.1475	28.16	28.06	28.0948	12079580.0
2015-08-20 12:30:00	AAPL	Stock	28.0925	28.1625	28.0625	28.0852	12612240.0
2015-08-20 13:00:00	AAPL	Stock	28.085	28.2375	28.055	28.1975	12732108.0
2015-08-20 13:30:00	AAPL	Stock	28.1975	28.295	28.12	28.265	13528968.0
2015-08-20 14:00:00	AAPL	Stock	28.265	28.2675	28.1725	28.1915	14114492.0
2015-08-20 14:30:00	AAPL	Stock	28.1925	28.2075	28.1175	28.1675	11780160.0
2015-08-20 15:00:00	AAPL	Stock	28.1675	28.2975	28.125	28.28	14282460.0
2015-08-20 15:30:00	AAPL	Stock	28.2775	28.3088	28.1625	28.1625	29260940.0
2015-08-20 16:00:00	AAPL	Stock	28.1625	28.5625	28.0925	28.0975	10994556.0
2015-08-20 16:30:00	AAPL	Stock	28.1	28.1375	28.0975	28.11	134892.0
2015-08-20 17:00:00	AAPL	Stock	28.1175	28.1225	28.0625	28.08	78688.0
2015-08-20 17:30:00	AAPL	Stock	28.075	28.075	28.0	28.05	95588.0
2015-08-20 18:00:00	AAPL	Stock	28.06	28.1625	28.06	28.0875	736744.0
2015-08-20 18:30:00	AAPL	Stock	28.0675	28.0825	28.0625	28.075	23552.0
2015-08-20 19:00:00	AAPL	Stock	28.0625	28.075	28.05	28.075	24848.0
2015-08-20 19:30:00	AAPL	Stock	28.065	28.085	28.065	28.0775	65896.0
2015-08-20 07:00:00	MSFT	Stock	46.22	46.22	46.21	46.21	3800.0
2015-08-20 08:00:00	MSFT	Stock	46.26	46.3	46.26	46.3	500.0
2015-08-20 08:30:00	MSFT	Stock	46.28	46.37	46.28	46.33	3080.0
2015-08-20 09:00:00	MSFT	Stock	46.293	46.293	46.06	46.08	25172.0
2015-08-20 09:30:00	MSFT	Stock	46.07	46.47	45.94	46.02	3721481.0
2015-08-20 10:00:00	MSFT	Stock	46.02	46.06	45.75	45.82	3667372.0
2015-08-20 10:30:00	MSFT	Stock	45.82	46.09	45.77	45.99	2920145.0
2015-08-20 11:00:00	MSFT	Stock	45.99	46.095	45.84	46.0	1352498.0
2015-08-20 11:30:00	MSFT	Stock	46.0	46.04	45.85	46.02	1266292.0
2015-08-20 12:00:00	MSFT	Stock	46.02	46.03	45.85	45.925	1395356.0
2015-08-20 12:30:00	MSFT	Stock	45.92	45.995	45.8	45.89	1763237.0
2015-08-20 13:00:00	MSFT	Stock	45.884	45.95	45.82	45.885	1349014.0
2015-08-20 13:30:00	MSFT	Stock	45.89	46.01	45.81	45.975	1431676.0
2015-08-20 14:00:00	MSFT	Stock	45.975	46.1	45.92	45.98	1808993.0
2015-08-20 14:30:00	MSFT	Stock	45.98	46.01	45.81	45.921	1224253.0
2015-08-20 15:00:00	MSFT	Stock	45.925	46.05	45.88	46.03	2233557.0
2015-08-20 15:30:00	MSFT	Stock	46.03	46.09	45.67	45.77	6486828.0
2015-08-20 16:00:00	MSFT	Stock	45.67	45.85	45.66	45.7	3568427.0

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

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