PREVIEW / stock_30min / 2017-09-22

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-22.parquet
  size:    1.6 MB
  rows:    79,895
  symbols: 2,958

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-09-22 04:00:00	AAPL	Stock	38.3125	38.325	38.275	38.3075	13076.0
2017-09-22 04:30:00	AAPL	Stock	38.275	38.3075	38.255	38.3075	6140.0
2017-09-22 05:00:00	AAPL	Stock	38.255	38.255	38.12	38.1275	21552.0
2017-09-22 05:30:00	AAPL	Stock	38.075	38.135	38.0375	38.135	45120.0
2017-09-22 06:00:00	AAPL	Stock	38.1	38.1425	38.0625	38.135	14280.0
2017-09-22 06:30:00	AAPL	Stock	38.1	38.1625	38.1	38.1	26520.0
2017-09-22 07:00:00	AAPL	Stock	38.125	38.125	38.075	38.1	129816.0
2017-09-22 07:30:00	AAPL	Stock	38.1025	38.2	38.1025	38.125	253408.0
2017-09-22 08:00:00	AAPL	Stock	38.1188	38.165	38.065	38.0725	334636.0
2017-09-22 08:30:00	AAPL	Stock	38.08	38.2125	38.0725	38.16	406568.0
2017-09-22 09:00:00	AAPL	Stock	38.16	38.175	38.0025	38.03	639912.0
2017-09-22 09:30:00	AAPL	Stock	38.02	38.0675	37.6925	37.767	36455044.0
2017-09-22 10:00:00	AAPL	Stock	37.7675	37.955	37.675	37.8475	18315260.0
2017-09-22 10:30:00	AAPL	Stock	37.8488	37.89	37.6425	37.6488	13673452.0
2017-09-22 11:00:00	AAPL	Stock	37.65	37.7525	37.64	37.69	11267200.0
2017-09-22 11:30:00	AAPL	Stock	37.6925	37.785	37.6425	37.7725	9377920.0
2017-09-22 12:00:00	AAPL	Stock	37.7675	37.84	37.7175	37.8325	9301868.0
2017-09-22 12:30:00	AAPL	Stock	37.8302	37.915	37.7775	37.7845	8131948.0
2017-09-22 13:00:00	AAPL	Stock	37.785	37.87	37.7275	37.859	7922580.0
2017-09-22 13:30:00	AAPL	Stock	37.859	37.8962	37.815	37.866	6321612.0
2017-09-22 14:00:00	AAPL	Stock	37.8645	37.98	37.7195	37.9487	7061756.0
2017-09-22 14:30:00	AAPL	Stock	37.95	37.955	37.87	37.9175	6926424.0
2017-09-22 15:00:00	AAPL	Stock	37.915	37.9625	37.8352	37.8725	6887116.0
2017-09-22 15:30:00	AAPL	Stock	37.8722	38.0025	37.8375	37.94	17095400.0
2017-09-22 16:00:00	AAPL	Stock	37.94	37.985	37.9275	37.9725	7466960.0
2017-09-22 16:30:00	AAPL	Stock	37.96	37.9725	37.9375	37.955	92904.0
2017-09-22 17:00:00	AAPL	Stock	37.9625	37.975	37.9525	37.9725	57344.0
2017-09-22 17:30:00	AAPL	Stock	37.9675	37.9975	37.965	37.9975	65472.0
2017-09-22 18:00:00	AAPL	Stock	37.995	37.9975	37.9875	37.99	46972.0
2017-09-22 18:30:00	AAPL	Stock	37.99	37.9975	37.99	37.9975	20420.0
2017-09-22 19:00:00	AAPL	Stock	37.9975	38.0	37.995	38.0	32616.0
2017-09-22 19:30:00	AAPL	Stock	38.0	38.0	37.9925	37.9925	54384.0
2017-09-22 04:00:00	MSFT	Stock	74.25	74.25	74.18	74.18	300.0
2017-09-22 07:00:00	MSFT	Stock	74.22	74.22	74.15	74.15	1372.0
2017-09-22 07:30:00	MSFT	Stock	74.15	74.15	74.15	74.15	1000.0
2017-09-22 08:00:00	MSFT	Stock	74.13	74.13	74.12	74.12	200.0
2017-09-22 08:30:00	MSFT	Stock	74.07	74.13	74.07	74.08	2692.0
2017-09-22 09:00:00	MSFT	Stock	74.07	74.07	73.95	73.99	23131.0
2017-09-22 09:30:00	MSFT	Stock	73.99	74.29	73.85	74.12	1771972.0
2017-09-22 10:00:00	MSFT	Stock	74.125	74.45	74.11	74.295	1081520.0
2017-09-22 10:30:00	MSFT	Stock	74.298	74.41	74.21	74.22	828179.0
2017-09-22 11:00:00	MSFT	Stock	74.22	74.31	74.18	74.22	528486.0
2017-09-22 11:30:00	MSFT	Stock	74.22	74.31	74.2	74.27	546410.0
2017-09-22 12:00:00	MSFT	Stock	74.275	74.35	74.23	74.28	522567.0
2017-09-22 12:30:00	MSFT	Stock	74.27	74.39	74.24	74.325	418623.0
2017-09-22 13:00:00	MSFT	Stock	74.33	74.37	74.095	74.185	443684.0
2017-09-22 13:30:00	MSFT	Stock	74.185	74.23	74.14	74.15	448430.0
2017-09-22 14:00:00	MSFT	Stock	74.15	74.22	74.11	74.2	500776.0
2017-09-22 14:30:00	MSFT	Stock	74.19	74.22	74.135	74.15	563077.0
2017-09-22 15:00:00	MSFT	Stock	74.155	74.25	74.14	74.24	704307.0

> showing 50 of 79,895 rows — these rows as CSV

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