PREVIEW / stock_30min / 2017-02-21

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-21.parquet
  size:    1.6 MB
  rows:    84,079
  symbols: 3,122

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
2017-02-21 04:00:00	AAPL	Stock	34.005	34.0775	34.0025	34.075	56128.0
2017-02-21 04:30:00	AAPL	Stock	34.085	34.0875	34.08	34.0875	5328.0
2017-02-21 05:00:00	AAPL	Stock	34.15	34.15	34.1125	34.1125	1236.0
2017-02-21 05:30:00	AAPL	Stock	34.1125	34.1125	34.1125	34.1125	1200.0
2017-02-21 06:00:00	AAPL	Stock	34.1125	34.1225	34.0675	34.1225	11096.0
2017-02-21 06:30:00	AAPL	Stock	34.1175	34.15	34.1175	34.125	27948.0
2017-02-21 07:00:00	AAPL	Stock	34.1225	34.145	34.0975	34.1175	90252.0
2017-02-21 07:30:00	AAPL	Stock	34.1175	34.1225	34.0975	34.0975	62488.0
2017-02-21 08:00:00	AAPL	Stock	34.0975	34.1375	33.85	34.0575	309564.0
2017-02-21 08:30:00	AAPL	Stock	34.0525	34.1075	34.05	34.105	174180.0
2017-02-21 09:00:00	AAPL	Stock	34.11	34.1375	34.06	34.06	416840.0
2017-02-21 09:30:00	AAPL	Stock	34.06	34.155	33.995	34.0513	18739012.0
2017-02-21 10:00:00	AAPL	Stock	34.055	34.0878	34.0425	34.065	6479724.0
2017-02-21 10:30:00	AAPL	Stock	34.0675	34.1225	34.0625	34.1075	6096524.0
2017-02-21 11:00:00	AAPL	Stock	34.1075	34.125	34.04	34.05	5004700.0
2017-02-21 11:30:00	AAPL	Stock	34.0475	34.0915	34.0175	34.0775	4099668.0
2017-02-21 12:00:00	AAPL	Stock	34.0775	34.08	34.02	34.0628	3146460.0
2017-02-21 12:30:00	AAPL	Stock	34.0625	34.0825	34.05	34.07	2492276.0
2017-02-21 13:00:00	AAPL	Stock	34.0675	34.1225	34.055	34.1162	3414372.0
2017-02-21 13:30:00	AAPL	Stock	34.115	34.115	34.0825	34.095	2329080.0
2017-02-21 14:00:00	AAPL	Stock	34.095	34.14	34.0875	34.1275	3584224.0
2017-02-21 14:30:00	AAPL	Stock	34.1275	34.15	34.115	34.1412	2864668.0
2017-02-21 15:00:00	AAPL	Stock	34.14	34.175	34.13	34.1715	4168612.0
2017-02-21 15:30:00	AAPL	Stock	34.1712	34.1875	34.1475	34.1725	8527568.0
2017-02-21 16:00:00	AAPL	Stock	34.175	34.175	34.145	34.15	12889440.0
2017-02-21 16:30:00	AAPL	Stock	34.15	34.175	34.15	34.1725	28216.0
2017-02-21 17:00:00	AAPL	Stock	34.1675	34.1675	34.15	34.1675	37560.0
2017-02-21 17:30:00	AAPL	Stock	34.17	34.17	34.1575	34.1575	7860.0
2017-02-21 18:00:00	AAPL	Stock	34.1725	34.1725	34.1575	34.165	19760.0
2017-02-21 18:30:00	AAPL	Stock	34.165	34.1675	34.1625	34.1675	8876.0
2017-02-21 19:00:00	AAPL	Stock	34.17	34.1725	34.1575	34.1675	24424.0
2017-02-21 19:30:00	AAPL	Stock	34.1675	34.1725	34.1675	34.17	9852.0
2017-02-21 05:30:00	MSFT	Stock	64.94	64.94	64.94	64.94	2360.0
2017-02-21 06:00:00	MSFT	Stock	64.88	64.88	64.8	64.8	4000.0
2017-02-21 07:00:00	MSFT	Stock	64.84	64.85	64.84	64.85	3500.0
2017-02-21 08:00:00	MSFT	Stock	64.86	64.87	64.65	64.73	1769.0
2017-02-21 08:30:00	MSFT	Stock	64.73	64.73	64.67	64.73	6415.0
2017-02-21 09:00:00	MSFT	Stock	64.7	64.73	64.58	64.66	29287.0
2017-02-21 09:30:00	MSFT	Stock	64.64	64.69	64.5	64.631	1916683.0
2017-02-21 10:00:00	MSFT	Stock	64.64	64.75	64.57	64.74	917012.0
2017-02-21 10:30:00	MSFT	Stock	64.745	64.95	64.72	64.87	984232.0
2017-02-21 11:00:00	MSFT	Stock	64.866	64.89	64.73	64.735	723130.0
2017-02-21 11:30:00	MSFT	Stock	64.735	64.79	64.64	64.74	789245.0
2017-02-21 12:00:00	MSFT	Stock	64.74	64.78	64.64	64.71	703092.0
2017-02-21 12:30:00	MSFT	Stock	64.71	64.73	64.65	64.65	577206.0
2017-02-21 13:00:00	MSFT	Stock	64.65	64.685	64.62	64.635	639198.0
2017-02-21 13:30:00	MSFT	Stock	64.64	64.64	64.5	64.52	765431.0
2017-02-21 14:00:00	MSFT	Stock	64.52	64.59	64.5	64.55	929458.0
2017-02-21 14:30:00	MSFT	Stock	64.54	64.575	64.48	64.5	973026.0
2017-02-21 15:00:00	MSFT	Stock	64.49	64.54	64.465	64.525	918013.0

> showing 50 of 84,079 rows — these rows as CSV

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