PREVIEW / stock_30min / 2017-09-21

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-21.parquet
  size:    1.6 MB
  rows:    79,862
  symbols: 2,944

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-21 04:00:00	AAPL	Stock	39.0125	39.05	39.0	39.02	4316.0
2017-09-21 05:00:00	AAPL	Stock	39.0	39.01	39.0	39.0	3560.0
2017-09-21 05:30:00	AAPL	Stock	38.9625	38.9825	38.9625	38.9825	1644.0
2017-09-21 06:00:00	AAPL	Stock	38.9625	39.025	38.9625	38.975	13332.0
2017-09-21 06:30:00	AAPL	Stock	38.975	39.0	38.9375	39.0	20504.0
2017-09-21 07:00:00	AAPL	Stock	39.0	39.0125	38.9625	38.9625	20736.0
2017-09-21 07:30:00	AAPL	Stock	38.95	38.975	38.9375	38.975	17696.0
2017-09-21 08:00:00	AAPL	Stock	38.965	39.0375	38.955	39.0025	112088.0
2017-09-21 08:30:00	AAPL	Stock	39.0025	39.0225	39.0	39.0125	62580.0
2017-09-21 09:00:00	AAPL	Stock	39.0075	39.01	38.9	38.9575	283384.0
2017-09-21 09:30:00	AAPL	Stock	38.955	38.955	38.4	38.4625	25555904.0
2017-09-21 10:00:00	AAPL	Stock	38.46	38.465	38.1875	38.24	21837584.0
2017-09-21 10:30:00	AAPL	Stock	38.25	38.5175	38.2225	38.485	16346408.0
2017-09-21 11:00:00	AAPL	Stock	38.4875	38.575	38.41	38.515	8024064.0
2017-09-21 11:30:00	AAPL	Stock	38.5175	38.56	38.465	38.51	5500172.0
2017-09-21 12:00:00	AAPL	Stock	38.5125	38.55	38.4578	38.4975	4514328.0
2017-09-21 12:30:00	AAPL	Stock	38.4975	38.5025	38.39	38.4725	4197252.0
2017-09-21 13:00:00	AAPL	Stock	38.4725	38.6375	38.4575	38.6075	5693876.0
2017-09-21 13:30:00	AAPL	Stock	38.6088	38.615	38.5075	38.5325	4262800.0
2017-09-21 14:00:00	AAPL	Stock	38.535	38.59	38.4725	38.4925	4364980.0
2017-09-21 14:30:00	AAPL	Stock	38.4925	38.5	38.44	38.4888	4124312.0
2017-09-21 15:00:00	AAPL	Stock	38.4885	38.5	38.405	38.4755	5190884.0
2017-09-21 15:30:00	AAPL	Stock	38.475	38.5	38.335	38.3525	12058432.0
2017-09-21 16:00:00	AAPL	Stock	38.3475	38.3575	38.305	38.325	12159336.0
2017-09-21 16:30:00	AAPL	Stock	38.325	38.345	38.315	38.3325	51512.0
2017-09-21 17:00:00	AAPL	Stock	38.325	38.3475	38.2525	38.2575	311588.0
2017-09-21 17:30:00	AAPL	Stock	38.2625	38.265	38.2425	38.2525	70740.0
2017-09-21 18:00:00	AAPL	Stock	38.2525	38.28	38.2525	38.275	34376.0
2017-09-21 18:30:00	AAPL	Stock	38.275	38.275	38.2525	38.2725	28696.0
2017-09-21 19:00:00	AAPL	Stock	38.2725	38.275	38.2575	38.2575	31756.0
2017-09-21 19:30:00	AAPL	Stock	38.2575	38.285	38.25	38.255	70620.0
2017-09-21 07:00:00	MSFT	Stock	75.26	75.26	75.26	75.26	125.0
2017-09-21 08:30:00	MSFT	Stock	74.95	75.07	74.92	75.07	2800.0
2017-09-21 09:00:00	MSFT	Stock	75.05	75.14	74.92	75.11	5899.0
2017-09-21 09:30:00	MSFT	Stock	75.11	75.24	74.76	74.786	2037838.0
2017-09-21 10:00:00	MSFT	Stock	74.785	74.84	74.28	74.351	1348672.0
2017-09-21 10:30:00	MSFT	Stock	74.36	74.55	74.11	74.505	1362714.0
2017-09-21 11:00:00	MSFT	Stock	74.51	74.62	74.4	74.543	831759.0
2017-09-21 11:30:00	MSFT	Stock	74.54	74.66	74.538	74.61	499994.0
2017-09-21 12:00:00	MSFT	Stock	74.61	74.724	74.6	74.665	476353.0
2017-09-21 12:30:00	MSFT	Stock	74.66	74.67	74.5	74.56	387248.0
2017-09-21 13:00:00	MSFT	Stock	74.57	74.9	74.57	74.825	621586.0
2017-09-21 13:30:00	MSFT	Stock	74.825	74.88	74.775	74.81	397069.0
2017-09-21 14:00:00	MSFT	Stock	74.82	74.835	74.6	74.64	691443.0
2017-09-21 14:30:00	MSFT	Stock	74.635	74.64	74.45	74.55	605388.0
2017-09-21 15:00:00	MSFT	Stock	74.55	74.61	74.445	74.48	722076.0
2017-09-21 15:30:00	MSFT	Stock	74.471	74.495	74.2	74.22	3098229.0
2017-09-21 16:00:00	MSFT	Stock	74.21	74.32	74.21	74.3	5039186.0
2017-09-21 16:30:00	MSFT	Stock	74.29	74.32	74.29	74.32	1000.0
2017-09-21 17:00:00	MSFT	Stock	74.3	74.3	74.29	74.29	200.0

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

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