PREVIEW / stock_30min / 2017-11-16

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-16.parquet
  size:    1.7 MB
  rows:    83,866
  symbols: 2,943

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-16 04:00:00	AAPL	Stock	42.515	42.525	42.515	42.525	3132.0
2017-11-16 04:30:00	AAPL	Stock	42.5625	42.6025	42.5625	42.6025	1200.0
2017-11-16 05:00:00	AAPL	Stock	42.62	42.635	42.62	42.635	22824.0
2017-11-16 05:30:00	AAPL	Stock	42.635	42.6625	42.62	42.645	9296.0
2017-11-16 06:00:00	AAPL	Stock	42.6475	42.6475	42.5625	42.5875	44960.0
2017-11-16 06:30:00	AAPL	Stock	42.595	42.6325	42.58	42.6025	17712.0
2017-11-16 07:00:00	AAPL	Stock	42.5925	42.7	42.5775	42.6875	226364.0
2017-11-16 07:30:00	AAPL	Stock	42.6875	42.7075	42.66	42.6925	182968.0
2017-11-16 08:00:00	AAPL	Stock	42.6875	42.75	42.58	42.66	343744.0
2017-11-16 08:30:00	AAPL	Stock	42.675	42.7	42.6175	42.69	210208.0
2017-11-16 09:00:00	AAPL	Stock	42.69	42.845	42.67	42.785	491188.0
2017-11-16 09:30:00	AAPL	Stock	42.795	42.8075	42.575	42.6368	14773876.0
2017-11-16 10:00:00	AAPL	Stock	42.635	42.7138	42.6075	42.6825	6291456.0
2017-11-16 10:30:00	AAPL	Stock	42.6825	42.765	42.6775	42.7225	6163672.0
2017-11-16 11:00:00	AAPL	Stock	42.7212	42.775	42.71	42.7292	3623984.0
2017-11-16 11:30:00	AAPL	Stock	42.7275	42.8525	42.7225	42.825	4446356.0
2017-11-16 12:00:00	AAPL	Stock	42.825	42.935	42.815	42.9075	4316208.0
2017-11-16 12:30:00	AAPL	Stock	42.9075	42.93	42.864	42.8775	3129368.0
2017-11-16 13:00:00	AAPL	Stock	42.875	42.94	42.8625	42.8825	2891308.0
2017-11-16 13:30:00	AAPL	Stock	42.8825	42.955	42.8575	42.94	3086388.0
2017-11-16 14:00:00	AAPL	Stock	42.94	42.9675	42.8675	42.88	4589540.0
2017-11-16 14:30:00	AAPL	Stock	42.88	42.9	42.855	42.8862	2855384.0
2017-11-16 15:00:00	AAPL	Stock	42.8862	42.905	42.825	42.8662	4271880.0
2017-11-16 15:30:00	AAPL	Stock	42.8675	42.905	42.7725	42.775	8793296.0
2017-11-16 16:00:00	AAPL	Stock	42.775	42.8375	42.775	42.7875	8773696.0
2017-11-16 16:30:00	AAPL	Stock	42.7875	42.795	42.7875	42.795	9680.0
2017-11-16 17:00:00	AAPL	Stock	42.7875	42.825	42.7875	42.8225	23128.0
2017-11-16 17:30:00	AAPL	Stock	42.8125	42.8225	42.8	42.8125	36468.0
2017-11-16 18:00:00	AAPL	Stock	42.815	42.82	42.8025	42.82	8236.0
2017-11-16 18:30:00	AAPL	Stock	42.8125	42.82	42.805	42.805	4068.0
2017-11-16 19:00:00	AAPL	Stock	42.805	42.815	42.8025	42.8125	46624.0
2017-11-16 19:30:00	AAPL	Stock	42.8175	42.8175	42.8	42.81	26780.0
2017-11-16 04:00:00	MSFT	Stock	83.23	83.24	83.23	83.24	2500.0
2017-11-16 04:30:00	MSFT	Stock	83.38	83.38	83.38	83.38	120.0
2017-11-16 06:00:00	MSFT	Stock	83.3	83.3	83.3	83.3	819.0
2017-11-16 06:30:00	MSFT	Stock	83.35	83.35	83.35	83.35	147.0
2017-11-16 07:00:00	MSFT	Stock	83.35	83.44	83.35	83.44	1853.0
2017-11-16 07:30:00	MSFT	Stock	83.44	83.5	83.43	83.5	4424.0
2017-11-16 08:00:00	MSFT	Stock	83.3	83.5	83.3	83.35	26042.0
2017-11-16 08:30:00	MSFT	Stock	83.45	83.45	83.32	83.33	16695.0
2017-11-16 09:00:00	MSFT	Stock	83.34	83.43	83.15	83.15	22474.0
2017-11-16 09:30:00	MSFT	Stock	83.1	83.42	83.02	83.12	2395341.0
2017-11-16 10:00:00	MSFT	Stock	83.125	83.245	83.03	83.06	995921.0
2017-11-16 10:30:00	MSFT	Stock	83.06	83.09	82.94	83.01	1248921.0
2017-11-16 11:00:00	MSFT	Stock	83.01	83.17	82.99	83.11	916556.0
2017-11-16 11:30:00	MSFT	Stock	83.105	83.19	83.053	83.14	1037155.0
2017-11-16 12:00:00	MSFT	Stock	83.135	83.261	83.135	83.251	1047564.0
2017-11-16 12:30:00	MSFT	Stock	83.26	83.335	83.22	83.3	942100.0
2017-11-16 13:00:00	MSFT	Stock	83.295	83.405	83.245	83.26	989131.0
2017-11-16 13:30:00	MSFT	Stock	83.27	83.3	83.19	83.23	934804.0

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

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