PREVIEW / stock_30min / 2017-05-18

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-18.parquet
  size:    1.6 MB
  rows:    82,050
  symbols: 3,030

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-05-18 04:00:00	AAPL	Stock	37.625	37.625	37.5925	37.6175	5500.0
2017-05-18 04:30:00	AAPL	Stock	37.6175	37.655	37.6175	37.655	6344.0
2017-05-18 05:00:00	AAPL	Stock	37.655	37.655	37.5	37.5	7052.0
2017-05-18 05:30:00	AAPL	Stock	37.475	37.5175	37.43	37.45	29932.0
2017-05-18 06:00:00	AAPL	Stock	37.4625	37.4825	37.4275	37.4375	64892.0
2017-05-18 06:30:00	AAPL	Stock	37.475	37.4925	37.4025	37.425	37180.0
2017-05-18 07:00:00	AAPL	Stock	37.425	37.5625	37.425	37.5575	66868.0
2017-05-18 07:30:00	AAPL	Stock	37.5575	37.685	37.5575	37.645	78804.0
2017-05-18 08:00:00	AAPL	Stock	37.6275	37.7275	37.4025	37.635	379008.0
2017-05-18 08:30:00	AAPL	Stock	37.6225	37.815	37.6225	37.765	370336.0
2017-05-18 09:00:00	AAPL	Stock	37.775	37.9125	37.735	37.8175	423468.0
2017-05-18 09:30:00	AAPL	Stock	37.8175	38.1875	37.7825	38.08	24891712.0
2017-05-18 10:00:00	AAPL	Stock	38.0825	38.335	38.0812	38.2662	15500596.0
2017-05-18 10:30:00	AAPL	Stock	38.265	38.2975	38.1	38.1525	9689616.0
2017-05-18 11:00:00	AAPL	Stock	38.1525	38.215	38.0775	38.165	6012060.0
2017-05-18 11:30:00	AAPL	Stock	38.165	38.1888	37.9275	37.9338	6761648.0
2017-05-18 12:00:00	AAPL	Stock	37.9375	38.075	37.8925	38.0525	5974204.0
2017-05-18 12:30:00	AAPL	Stock	38.0543	38.1325	37.9875	38.0575	4425608.0
2017-05-18 13:00:00	AAPL	Stock	38.0575	38.0775	37.975	38.055	3999496.0
2017-05-18 13:30:00	AAPL	Stock	38.055	38.1775	38.0275	38.105	5504888.0
2017-05-18 14:00:00	AAPL	Stock	38.1075	38.26	38.1042	38.2512	8058480.0
2017-05-18 14:30:00	AAPL	Stock	38.2512	38.305	38.1475	38.155	5962180.0
2017-05-18 15:00:00	AAPL	Stock	38.1575	38.2075	38.1075	38.135	5526976.0
2017-05-18 15:30:00	AAPL	Stock	38.1375	38.24	38.1025	38.1275	11971992.0
2017-05-18 16:00:00	AAPL	Stock	38.1325	38.1525	38.105	38.12	7611068.0
2017-05-18 16:30:00	AAPL	Stock	38.1125	38.135	38.1	38.1125	188896.0
2017-05-18 17:00:00	AAPL	Stock	38.13	38.13	38.1125	38.12	34000.0
2017-05-18 17:30:00	AAPL	Stock	38.12	38.135	38.1125	38.1125	27128.0
2017-05-18 18:00:00	AAPL	Stock	38.125	38.145	38.1125	38.135	34460.0
2017-05-18 18:30:00	AAPL	Stock	38.135	38.1425	38.125	38.1425	20612.0
2017-05-18 19:00:00	AAPL	Stock	38.1425	38.15	38.1425	38.145	20676.0
2017-05-18 19:30:00	AAPL	Stock	38.16	38.1625	38.145	38.1625	55360.0
2017-05-18 04:00:00	MSFT	Stock	67.5	67.5	67.5	67.5	141.0
2017-05-18 05:00:00	MSFT	Stock	67.4	67.4	67.4	67.4	100.0
2017-05-18 05:30:00	MSFT	Stock	67.4	67.4	67.12	67.12	5859.0
2017-05-18 06:00:00	MSFT	Stock	67.2	67.25	67.2	67.25	4865.0
2017-05-18 06:30:00	MSFT	Stock	67.24	67.25	67.21	67.25	2098.0
2017-05-18 07:00:00	MSFT	Stock	67.28	67.35	67.26	67.35	1000.0
2017-05-18 07:30:00	MSFT	Stock	67.35	67.35	67.35	67.35	100.0
2017-05-18 08:00:00	MSFT	Stock	67.4	67.5	67.25	67.5	9663.0
2017-05-18 08:30:00	MSFT	Stock	67.5	67.6	67.4	67.4	12926.0
2017-05-18 09:00:00	MSFT	Stock	67.41	67.5	67.28	67.36	17978.0
2017-05-18 09:30:00	MSFT	Stock	67.39	67.9	67.14	67.47	3166438.0
2017-05-18 10:00:00	MSFT	Stock	67.48	67.93	67.45	67.83	2033964.0
2017-05-18 10:30:00	MSFT	Stock	67.83	68.06	67.78	67.842	2324187.0
2017-05-18 11:00:00	MSFT	Stock	67.85	68.13	67.77	68.065	1645665.0
2017-05-18 11:30:00	MSFT	Stock	68.075	68.1	67.66	67.66	966185.0
2017-05-18 12:00:00	MSFT	Stock	67.67	67.805	67.59	67.76	1166385.0
2017-05-18 12:30:00	MSFT	Stock	67.75	67.84	67.64	67.645	891301.0
2017-05-18 13:00:00	MSFT	Stock	67.64	67.66	67.505	67.52	1154827.0

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

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