PREVIEW / stock_30min / 2018-11-30

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-30.parquet
  size:    1.7 MB
  rows:    85,692
  symbols: 2,785

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-11-30 04:00:00	AAPL	Stock	44.8025	44.8025	44.7475	44.7475	5172.0
2018-11-30 04:30:00	AAPL	Stock	44.625	44.625	44.625	44.625	544.0
2018-11-30 05:00:00	AAPL	Stock	44.685	44.7225	44.64	44.7225	3480.0
2018-11-30 05:30:00	AAPL	Stock	44.69	44.7	44.6725	44.7	6396.0
2018-11-30 06:30:00	AAPL	Stock	44.695	44.695	44.4025	44.515	14600.0
2018-11-30 07:00:00	AAPL	Stock	44.61	44.61	44.475	44.6	60976.0
2018-11-30 07:30:00	AAPL	Stock	44.625	44.66	44.59	44.6475	89376.0
2018-11-30 08:00:00	AAPL	Stock	44.5025	44.8725	44.47	44.84	211688.0
2018-11-30 08:30:00	AAPL	Stock	44.8425	45.0225	44.8425	45.0	303156.0
2018-11-30 09:00:00	AAPL	Stock	45.0025	45.0725	44.9375	45.0725	244880.0
2018-11-30 09:30:00	AAPL	Stock	45.0725	45.0825	44.5325	44.5925	11751400.0
2018-11-30 10:00:00	AAPL	Stock	44.5962	44.7225	44.4775	44.5725	8924120.0
2018-11-30 10:30:00	AAPL	Stock	44.5725	44.6975	44.525	44.5252	6250244.0
2018-11-30 11:00:00	AAPL	Stock	44.5232	44.5875	44.4425	44.486	6305940.0
2018-11-30 11:30:00	AAPL	Stock	44.485	44.6025	44.4	44.5525	6459080.0
2018-11-30 12:00:00	AAPL	Stock	44.555	44.5575	44.4575	44.49	4213304.0
2018-11-30 12:30:00	AAPL	Stock	44.4918	44.5425	44.43	44.4325	3584000.0
2018-11-30 13:00:00	AAPL	Stock	44.4318	44.44	44.335	44.4175	4284860.0
2018-11-30 13:30:00	AAPL	Stock	44.42	44.61	44.3775	44.5275	5851608.0
2018-11-30 14:00:00	AAPL	Stock	44.5275	44.5378	44.3625	44.4362	4697224.0
2018-11-30 14:30:00	AAPL	Stock	44.44	44.44	44.2575	44.307	6310600.0
2018-11-30 15:00:00	AAPL	Stock	44.3062	44.7925	44.3062	44.741	11414528.0
2018-11-30 15:30:00	AAPL	Stock	44.7425	44.8275	44.5225	44.65	18028428.0
2018-11-30 16:00:00	AAPL	Stock	44.65	44.71	44.595	44.6625	28704744.0
2018-11-30 16:30:00	AAPL	Stock	44.6625	44.7125	44.645	44.71	202544.0
2018-11-30 17:00:00	AAPL	Stock	44.71	44.77	44.7	44.7	110316.0
2018-11-30 17:30:00	AAPL	Stock	44.7	44.7275	44.7	44.7275	65548.0
2018-11-30 18:00:00	AAPL	Stock	44.7275	44.7625	44.6875	44.7125	55308.0
2018-11-30 18:30:00	AAPL	Stock	44.6975	44.72	44.65	44.675	67908.0
2018-11-30 19:00:00	AAPL	Stock	44.69	44.7125	44.665	44.7	21600.0
2018-11-30 19:30:00	AAPL	Stock	44.7	44.72	44.675	44.7	55512.0
2018-11-30 07:00:00	MSFT	Stock	109.88	110.0	109.59	109.9	6121.0
2018-11-30 07:30:00	MSFT	Stock	109.75	109.85	109.75	109.85	721.0
2018-11-30 08:00:00	MSFT	Stock	109.608	110.39	109.6	110.29	11890.0
2018-11-30 08:30:00	MSFT	Stock	110.22	110.49	110.16	110.42	20051.0
2018-11-30 09:00:00	MSFT	Stock	110.43	110.8	110.2	110.69	43891.0
2018-11-30 09:30:00	MSFT	Stock	110.73	110.81	109.81	110.05	2519590.0
2018-11-30 10:00:00	MSFT	Stock	110.05	110.21	109.69	110.08	1823705.0
2018-11-30 10:30:00	MSFT	Stock	110.08	110.737	110.08	110.36	1757824.0
2018-11-30 11:00:00	MSFT	Stock	110.364	110.415	110.02	110.04	1271927.0
2018-11-30 11:30:00	MSFT	Stock	110.04	110.49	109.94	110.315	1132454.0
2018-11-30 12:00:00	MSFT	Stock	110.32	110.35	109.819	109.956	1247571.0
2018-11-30 12:30:00	MSFT	Stock	109.96	110.08	109.704	109.71	857493.0
2018-11-30 13:00:00	MSFT	Stock	109.72	109.845	109.36	109.785	1018739.0
2018-11-30 13:30:00	MSFT	Stock	109.79	110.46	109.6	110.39	1727387.0
2018-11-30 14:00:00	MSFT	Stock	110.39	110.455	110.04	110.13	1007646.0
2018-11-30 14:30:00	MSFT	Stock	110.13	110.4	110.02	110.25	1166784.0
2018-11-30 15:00:00	MSFT	Stock	110.25	110.74	110.23	110.54	1401336.0
2018-11-30 15:30:00	MSFT	Stock	110.55	110.97	110.29	110.92	4447401.0
2018-11-30 16:00:00	MSFT	Stock	110.9	111.0	110.58	111.0	6921750.0

> showing 50 of 85,692 rows — these rows as CSV

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