PREVIEW / stock_30min / 2018-07-06

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-06.parquet
  size:    1.6 MB
  rows:    82,156
  symbols: 2,802

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
2018-07-06 04:00:00	AAPL	Stock	46.2125	46.2375	46.2125	46.2375	2064.0
2018-07-06 04:30:00	AAPL	Stock	46.15	46.25	46.15	46.25	1216.0
2018-07-06 05:00:00	AAPL	Stock	46.325	46.325	46.2625	46.2625	1936.0
2018-07-06 06:00:00	AAPL	Stock	46.2875	46.2975	46.2875	46.2975	1956.0
2018-07-06 06:30:00	AAPL	Stock	46.25	46.25	46.25	46.25	532.0
2018-07-06 07:00:00	AAPL	Stock	46.275	46.3175	46.27	46.27	42636.0
2018-07-06 07:30:00	AAPL	Stock	46.275	46.3	46.245	46.2625	15668.0
2018-07-06 08:00:00	AAPL	Stock	46.275	46.33	46.25	46.2775	48660.0
2018-07-06 08:30:00	AAPL	Stock	46.315	46.5088	46.315	46.385	177588.0
2018-07-06 09:00:00	AAPL	Stock	46.3775	46.4625	46.3125	46.3825	122788.0
2018-07-06 09:30:00	AAPL	Stock	46.385	46.79	46.3	46.7825	9692220.0
2018-07-06 10:00:00	AAPL	Stock	46.7825	46.805	46.5625	46.5975	4609672.0
2018-07-06 10:30:00	AAPL	Stock	46.6	46.725	46.505	46.6675	4123124.0
2018-07-06 11:00:00	AAPL	Stock	46.665	46.8615	46.665	46.84	4647192.0
2018-07-06 11:30:00	AAPL	Stock	46.8388	46.935	46.8125	46.85	4457036.0
2018-07-06 12:00:00	AAPL	Stock	46.8538	46.9475	46.8475	46.919	3096500.0
2018-07-06 12:30:00	AAPL	Stock	46.9175	46.9625	46.8825	46.92	2164652.0
2018-07-06 13:00:00	AAPL	Stock	46.92	46.9375	46.8575	46.872	1623084.0
2018-07-06 13:30:00	AAPL	Stock	46.875	46.93	46.845	46.92	1660372.0
2018-07-06 14:00:00	AAPL	Stock	46.92	46.945	46.88	46.9112	1709388.0
2018-07-06 14:30:00	AAPL	Stock	46.91	46.925	46.84	46.906	1766100.0
2018-07-06 15:00:00	AAPL	Stock	46.9075	47.085	46.9025	47.0825	4855280.0
2018-07-06 15:30:00	AAPL	Stock	47.0832	47.1085	46.8625	46.995	9890592.0
2018-07-06 16:00:00	AAPL	Stock	47.055	47.1	46.9925	46.9925	7129300.0
2018-07-06 16:30:00	AAPL	Stock	47.08	47.09	46.9925	47.0675	129512.0
2018-07-06 17:00:00	AAPL	Stock	47.07	47.07	47.0425	47.05	15120.0
2018-07-06 17:30:00	AAPL	Stock	47.05	47.075	47.05	47.0625	3360.0
2018-07-06 18:00:00	AAPL	Stock	47.0625	47.0625	47.0625	47.0625	3400.0
2018-07-06 18:30:00	AAPL	Stock	47.0725	47.0725	47.055	47.055	9016.0
2018-07-06 19:00:00	AAPL	Stock	47.04	47.075	47.04	47.075	11984.0
2018-07-06 19:30:00	AAPL	Stock	47.0625	47.0875	47.0625	47.0875	5900.0
2018-07-06 04:30:00	MSFT	Stock	99.6	99.6	99.6	99.6	100.0
2018-07-06 08:00:00	MSFT	Stock	99.4	99.56	99.29	99.5	5122.0
2018-07-06 08:30:00	MSFT	Stock	99.55	100.08	99.48	99.84	22388.0
2018-07-06 09:00:00	MSFT	Stock	99.62	99.99	99.62	99.99	4709.0
2018-07-06 09:30:00	MSFT	Stock	99.97	100.4	99.67	100.26	1915286.0
2018-07-06 10:00:00	MSFT	Stock	100.25	100.45	100.07	100.21	1218245.0
2018-07-06 10:30:00	MSFT	Stock	100.22	100.38	100.02	100.325	899807.0
2018-07-06 11:00:00	MSFT	Stock	100.33	100.83	100.32	100.82	1027505.0
2018-07-06 11:30:00	MSFT	Stock	100.82	101.21	100.81	101.09	1521059.0
2018-07-06 12:00:00	MSFT	Stock	101.095	101.35	101.04	101.29	1092189.0
2018-07-06 12:30:00	MSFT	Stock	101.285	101.335	101.02	101.1	551479.0
2018-07-06 13:00:00	MSFT	Stock	101.105	101.21	101.08	101.105	432359.0
2018-07-06 13:30:00	MSFT	Stock	101.11	101.2	101.08	101.085	366164.0
2018-07-06 14:00:00	MSFT	Stock	101.085	101.155	101.01	101.05	589370.0
2018-07-06 14:30:00	MSFT	Stock	101.05	101.14	100.96	101.095	573559.0
2018-07-06 15:00:00	MSFT	Stock	101.095	101.42	101.09	101.394	916497.0
2018-07-06 15:30:00	MSFT	Stock	101.4	101.43	100.71	101.17	2805767.0
2018-07-06 16:00:00	MSFT	Stock	101.16	101.26	101.14	101.16	2741645.0
2018-07-06 16:30:00	MSFT	Stock	101.16	101.2	101.15	101.2	1936.0

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

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