PREVIEW / stock_30min / 2016-05-11

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-11.parquet
  size:    1.6 MB
  rows:    81,406
  symbols: 3,288

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-05-11 04:30:00	AAPL	Stock	23.2775	23.28	23.2775	23.28	1600.0
2016-05-11 05:00:00	AAPL	Stock	23.2125	23.2375	23.2125	23.2375	2400.0
2016-05-11 05:30:00	AAPL	Stock	23.2375	23.2375	23.2225	23.2225	1200.0
2016-05-11 06:00:00	AAPL	Stock	23.2375	23.275	23.2375	23.275	804.0
2016-05-11 06:30:00	AAPL	Stock	23.2525	23.2525	23.2525	23.2525	540.0
2016-05-11 07:00:00	AAPL	Stock	23.285	23.295	23.2775	23.295	8280.0
2016-05-11 07:30:00	AAPL	Stock	23.295	23.295	23.2875	23.29	7172.0
2016-05-11 08:00:00	AAPL	Stock	23.3	23.3125	23.25	23.3125	57012.0
2016-05-11 08:30:00	AAPL	Stock	23.315	23.3475	23.3075	23.3125	52724.0
2016-05-11 09:00:00	AAPL	Stock	23.305	23.3675	23.2725	23.3675	402948.0
2016-05-11 09:30:00	AAPL	Stock	23.365	23.375	23.165	23.2575	15808276.0
2016-05-11 10:00:00	AAPL	Stock	23.2575	23.3225	23.2	23.2962	8887728.0
2016-05-11 10:30:00	AAPL	Stock	23.2975	23.3925	23.2825	23.305	9474388.0
2016-05-11 11:00:00	AAPL	Stock	23.3025	23.3275	23.2125	23.2325	9092980.0
2016-05-11 11:30:00	AAPL	Stock	23.2338	23.2925	23.2025	23.2725	7690652.0
2016-05-11 12:00:00	AAPL	Stock	23.2725	23.33	23.2525	23.3005	4135800.0
2016-05-11 12:30:00	AAPL	Stock	23.3022	23.3025	23.235	23.2525	3468012.0
2016-05-11 13:00:00	AAPL	Stock	23.2525	23.255	23.2052	23.2218	4244988.0
2016-05-11 13:30:00	AAPL	Stock	23.22	23.25	23.1925	23.1925	4086252.0
2016-05-11 14:00:00	AAPL	Stock	23.1925	23.2228	23.1825	23.2013	4504384.0
2016-05-11 14:30:00	AAPL	Stock	23.2	23.2075	23.15	23.16	5327752.0
2016-05-11 15:00:00	AAPL	Stock	23.1625	23.2025	23.1575	23.1775	6506440.0
2016-05-11 15:30:00	AAPL	Stock	23.175	23.2	23.115	23.1275	13551660.0
2016-05-11 16:00:00	AAPL	Stock	23.1275	23.1375	23.1125	23.115	8546912.0
2016-05-11 16:30:00	AAPL	Stock	23.115	23.1225	23.095	23.1125	63232.0
2016-05-11 17:00:00	AAPL	Stock	23.1075	23.115	23.0575	23.0875	108960.0
2016-05-11 17:30:00	AAPL	Stock	23.0675	23.1	23.065	23.0775	72384.0
2016-05-11 18:00:00	AAPL	Stock	23.08	23.095	23.07	23.0875	26868.0
2016-05-11 18:30:00	AAPL	Stock	23.0875	23.095	23.075	23.095	17416.0
2016-05-11 19:00:00	AAPL	Stock	23.095	23.095	23.08	23.085	15328.0
2016-05-11 19:30:00	AAPL	Stock	23.0825	23.095	23.0825	23.09	29308.0
2016-05-11 08:00:00	MSFT	Stock	50.84	50.84	50.84	50.84	438.0
2016-05-11 08:30:00	MSFT	Stock	50.89	51.02	50.86	51.02	4254.0
2016-05-11 09:00:00	MSFT	Stock	50.86	51.13	50.86	51.13	98928.0
2016-05-11 09:30:00	MSFT	Stock	51.13	51.56	51.02	51.52	3222241.0
2016-05-11 10:00:00	MSFT	Stock	51.514	51.6	51.25	51.59	1638118.0
2016-05-11 10:30:00	MSFT	Stock	51.6	51.78	51.58	51.74	2308515.0
2016-05-11 11:00:00	MSFT	Stock	51.745	51.745	51.34	51.565	1590176.0
2016-05-11 11:30:00	MSFT	Stock	51.567	51.59	51.34	51.37	1342177.0
2016-05-11 12:00:00	MSFT	Stock	51.36	51.495	51.305	51.37	757892.0
2016-05-11 12:30:00	MSFT	Stock	51.37	51.41	51.26	51.27	763858.0
2016-05-11 13:00:00	MSFT	Stock	51.27	51.343	51.2	51.259	805124.0
2016-05-11 13:30:00	MSFT	Stock	51.255	51.28	51.07	51.08	797256.0
2016-05-11 14:00:00	MSFT	Stock	51.08	51.14	51.015	51.13	929193.0
2016-05-11 14:30:00	MSFT	Stock	51.13	51.16	51.0	51.03	1031508.0
2016-05-11 15:00:00	MSFT	Stock	51.04	51.13	51.0	51.06	1099435.0
2016-05-11 15:30:00	MSFT	Stock	51.06	51.13	51.04	51.05	2646410.0
2016-05-11 16:00:00	MSFT	Stock	51.05	51.06	50.95	50.95	2881579.0
2016-05-11 16:30:00	MSFT	Stock	50.96	51.06	50.96	51.06	2177.0
2016-05-11 17:00:00	MSFT	Stock	51.06	51.1	51.06	51.1	1900.0

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

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