PREVIEW / stock_30min / 2019-06-11

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-11.parquet
  size:    1.7 MB
  rows:    83,064
  symbols: 2,597

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
2019-06-11 04:30:00	AAPL	Stock	48.4375	48.505	48.4375	48.5	11200.0
2019-06-11 05:00:00	AAPL	Stock	48.5	48.555	48.475	48.555	16840.0
2019-06-11 05:30:00	AAPL	Stock	48.62	48.625	48.6125	48.6225	24204.0
2019-06-11 06:00:00	AAPL	Stock	48.61	48.6125	48.575	48.6125	11432.0
2019-06-11 06:30:00	AAPL	Stock	48.6275	48.725	48.625	48.67	28956.0
2019-06-11 07:00:00	AAPL	Stock	48.6625	48.69	48.625	48.6625	157816.0
2019-06-11 07:30:00	AAPL	Stock	48.675	48.7375	48.6375	48.7075	130456.0
2019-06-11 08:00:00	AAPL	Stock	48.7175	48.76	48.265	48.675	201748.0
2019-06-11 08:30:00	AAPL	Stock	48.6375	48.8375	48.6375	48.6725	163860.0
2019-06-11 09:00:00	AAPL	Stock	48.6925	48.74	48.6725	48.715	155956.0
2019-06-11 09:30:00	AAPL	Stock	48.71	48.905	48.4775	48.62	14350136.0
2019-06-11 10:00:00	AAPL	Stock	48.6162	48.9892	48.575	48.9892	10437016.0
2019-06-11 10:30:00	AAPL	Stock	48.9888	49.0	48.5	48.635	9573064.0
2019-06-11 11:00:00	AAPL	Stock	48.635	48.8075	48.5625	48.7175	5535156.0
2019-06-11 11:30:00	AAPL	Stock	48.72	48.7848	48.54	48.6175	4399416.0
2019-06-11 12:00:00	AAPL	Stock	48.6125	48.6375	48.425	48.465	5224648.0
2019-06-11 12:30:00	AAPL	Stock	48.4675	48.5725	48.4	48.44	4294252.0
2019-06-11 13:00:00	AAPL	Stock	48.43	48.56	48.42	48.4725	2779320.0
2019-06-11 13:30:00	AAPL	Stock	48.4725	48.635	48.43	48.6025	2957944.0
2019-06-11 14:00:00	AAPL	Stock	48.6025	48.705	48.5525	48.5638	3368240.0
2019-06-11 14:30:00	AAPL	Stock	48.565	48.6175	48.4725	48.61	3553788.0
2019-06-11 15:00:00	AAPL	Stock	48.61	48.7175	48.4975	48.7175	4344648.0
2019-06-11 15:30:00	AAPL	Stock	48.715	48.79	48.665	48.7025	8519960.0
2019-06-11 16:00:00	AAPL	Stock	48.7025	48.71	48.6775	48.6775	6534160.0
2019-06-11 16:30:00	AAPL	Stock	48.6875	48.6875	48.635	48.6625	21080.0
2019-06-11 17:00:00	AAPL	Stock	48.6675	48.7025	48.665	48.6725	7541876.0
2019-06-11 17:30:00	AAPL	Stock	48.6725	48.6875	48.6725	48.6875	14032.0
2019-06-11 18:00:00	AAPL	Stock	48.685	48.6875	48.6475	48.6625	27172.0
2019-06-11 18:30:00	AAPL	Stock	48.65	48.65	48.63	48.6375	7036.0
2019-06-11 19:00:00	AAPL	Stock	48.6375	48.675	48.63	48.63	15212.0
2019-06-11 19:30:00	AAPL	Stock	48.63	48.6475	48.555	48.555	37340.0
2019-06-11 04:30:00	MSFT	Stock	133.22	133.22	133.18	133.18	443.0
2019-06-11 06:00:00	MSFT	Stock	133.4	133.4	133.4	133.4	209.0
2019-06-11 06:30:00	MSFT	Stock	133.82	133.88	133.55	133.55	6778.0
2019-06-11 07:00:00	MSFT	Stock	133.55	133.78	133.47	133.6	14466.0
2019-06-11 07:30:00	MSFT	Stock	133.55	133.69	133.47	133.62	16244.0
2019-06-11 08:00:00	MSFT	Stock	133.5	133.8	132.93	133.65	32353.0
2019-06-11 08:30:00	MSFT	Stock	133.65	133.84	133.48	133.48	72828.0
2019-06-11 09:00:00	MSFT	Stock	133.65	133.9	133.55	133.89	14587.0
2019-06-11 09:30:00	MSFT	Stock	133.89	134.24	132.76	133.475	2838979.0
2019-06-11 10:00:00	MSFT	Stock	133.46	133.7	132.98	133.09	1612448.0
2019-06-11 10:30:00	MSFT	Stock	133.1	133.11	131.93	132.08	1705113.0
2019-06-11 11:00:00	MSFT	Stock	132.075	132.3	131.82	131.95	1169231.0
2019-06-11 11:30:00	MSFT	Stock	131.95	132.07	131.41	131.855	1123215.0
2019-06-11 12:00:00	MSFT	Stock	131.86	131.89	131.56	131.645	1009273.0
2019-06-11 12:30:00	MSFT	Stock	131.635	131.83	131.38	131.5	1159734.0
2019-06-11 13:00:00	MSFT	Stock	131.49	131.75	131.33	131.37	633975.0
2019-06-11 13:30:00	MSFT	Stock	131.38	131.78	131.276	131.77	732456.0
2019-06-11 14:00:00	MSFT	Stock	131.78	132.14	131.775	132.082	728326.0
2019-06-11 14:30:00	MSFT	Stock	132.084	132.1	131.46	131.59	729619.0

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

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