PREVIEW / stock_30min / 2017-11-20

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-20.parquet
  size:    1.6 MB
  rows:    83,254
  symbols: 2,936

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-11-20 04:30:00	AAPL	Stock	42.475	42.475	42.475	42.475	1948.0
2017-11-20 05:30:00	AAPL	Stock	42.475	42.475	42.475	42.475	400.0
2017-11-20 06:00:00	AAPL	Stock	42.5	42.5	42.5	42.5	400.0
2017-11-20 06:30:00	AAPL	Stock	42.5	42.5475	42.5	42.525	10420.0
2017-11-20 07:00:00	AAPL	Stock	42.5075	42.5875	42.5	42.5025	23848.0
2017-11-20 07:30:00	AAPL	Stock	42.5325	42.56	42.5325	42.55	14624.0
2017-11-20 08:00:00	AAPL	Stock	42.555	42.625	42.515	42.625	91352.0
2017-11-20 08:30:00	AAPL	Stock	42.625	42.66	42.625	42.635	59796.0
2017-11-20 09:00:00	AAPL	Stock	42.6425	42.675	42.57	42.5825	143800.0
2017-11-20 09:30:00	AAPL	Stock	42.5725	42.64	42.4275	42.5425	9048116.0
2017-11-20 10:00:00	AAPL	Stock	42.5375	42.59	42.434	42.434	5726176.0
2017-11-20 10:30:00	AAPL	Stock	42.4325	42.5525	42.4325	42.5175	3919088.0
2017-11-20 11:00:00	AAPL	Stock	42.519	42.53	42.4175	42.4275	3583388.0
2017-11-20 11:30:00	AAPL	Stock	42.425	42.5	42.4	42.4865	3806152.0
2017-11-20 12:00:00	AAPL	Stock	42.4875	42.4925	42.39	42.4238	2973928.0
2017-11-20 12:30:00	AAPL	Stock	42.425	42.4925	42.4228	42.491	2116100.0
2017-11-20 13:00:00	AAPL	Stock	42.4912	42.5575	42.4875	42.54	2421836.0
2017-11-20 13:30:00	AAPL	Stock	42.54	42.5475	42.48	42.5025	2026872.0
2017-11-20 14:00:00	AAPL	Stock	42.5	42.51	42.4775	42.48	1654288.0
2017-11-20 14:30:00	AAPL	Stock	42.4788	42.5125	42.465	42.5075	2126576.0
2017-11-20 15:00:00	AAPL	Stock	42.5075	42.535	42.475	42.495	2751448.0
2017-11-20 15:30:00	AAPL	Stock	42.495	42.5	42.4625	42.4975	5430668.0
2017-11-20 16:00:00	AAPL	Stock	42.495	42.5	42.475	42.495	10393152.0
2017-11-20 16:30:00	AAPL	Stock	42.4875	42.4975	42.4775	42.495	43032.0
2017-11-20 17:00:00	AAPL	Stock	42.4925	42.4975	42.4925	42.4975	1600.0
2017-11-20 17:30:00	AAPL	Stock	42.4975	42.4975	42.4925	42.495	28420.0
2017-11-20 18:00:00	AAPL	Stock	42.495	42.4975	42.49	42.495	17496.0
2017-11-20 18:30:00	AAPL	Stock	42.49	42.5175	42.475	42.5175	59852.0
2017-11-20 19:00:00	AAPL	Stock	42.5025	42.5125	42.4875	42.495	11800.0
2017-11-20 19:30:00	AAPL	Stock	42.515	42.52	42.5	42.5025	29292.0
2017-11-20 04:00:00	MSFT	Stock	82.3	82.3	82.3	82.3	200.0
2017-11-20 04:30:00	MSFT	Stock	82.25	82.25	82.25	82.25	100.0
2017-11-20 07:00:00	MSFT	Stock	82.4	82.4	82.4	82.4	1100.0
2017-11-20 07:30:00	MSFT	Stock	82.36	82.36	82.36	82.36	152.0
2017-11-20 08:00:00	MSFT	Stock	82.4	82.47	82.35	82.47	11699.0
2017-11-20 08:30:00	MSFT	Stock	82.44	82.51	82.4	82.4	3637.0
2017-11-20 09:00:00	MSFT	Stock	82.48	82.65	82.4	82.48	8627.0
2017-11-20 09:30:00	MSFT	Stock	82.4	82.56	82.31	82.42	1384861.0
2017-11-20 10:00:00	MSFT	Stock	82.425	82.55	82.25	82.47	977601.0
2017-11-20 10:30:00	MSFT	Stock	82.47	82.56	82.38	82.5	824434.0
2017-11-20 11:00:00	MSFT	Stock	82.5	82.59	82.46	82.51	740637.0
2017-11-20 11:30:00	MSFT	Stock	82.51	82.55	82.42	82.495	621534.0
2017-11-20 12:00:00	MSFT	Stock	82.498	82.51	82.31	82.42	727061.0
2017-11-20 12:30:00	MSFT	Stock	82.43	82.53	82.4	82.51	747176.0
2017-11-20 13:00:00	MSFT	Stock	82.505	82.52	82.4	82.49	836460.0
2017-11-20 13:30:00	MSFT	Stock	82.5	82.519	82.47	82.49	699628.0
2017-11-20 14:00:00	MSFT	Stock	82.496	82.54	82.41	82.435	814854.0
2017-11-20 14:30:00	MSFT	Stock	82.44	82.48	82.39	82.435	609274.0
2017-11-20 15:00:00	MSFT	Stock	82.436	82.46	82.39	82.44	928264.0
2017-11-20 15:30:00	MSFT	Stock	82.45	82.59	82.41	82.54	1546913.0

> showing 50 of 83,254 rows — these rows as CSV

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