PREVIEW / stock_30min / 2019-11-20

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-20.parquet
  size:    1.8 MB
  rows:    87,003
  symbols: 2,500

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-11-20 04:00:00	AAPL	Stock	66.2475	66.2475	66.075	66.17	11484.0
2019-11-20 04:30:00	AAPL	Stock	66.14	66.23	66.14	66.22	8528.0
2019-11-20 05:00:00	AAPL	Stock	66.215	66.215	66.15	66.155	7316.0
2019-11-20 05:30:00	AAPL	Stock	66.14	66.14	66.09	66.09	17384.0
2019-11-20 06:00:00	AAPL	Stock	66.15	66.15	66.05	66.075	25880.0
2019-11-20 06:30:00	AAPL	Stock	66.1225	66.255	66.1225	66.255	33012.0
2019-11-20 07:00:00	AAPL	Stock	66.275	66.3375	66.25	66.25	101912.0
2019-11-20 07:30:00	AAPL	Stock	66.25	66.275	66.2075	66.2225	72580.0
2019-11-20 08:00:00	AAPL	Stock	66.255	66.3375	66.2	66.2875	169116.0
2019-11-20 08:30:00	AAPL	Stock	66.2925	66.325	66.215	66.225	129360.0
2019-11-20 09:00:00	AAPL	Stock	66.2175	66.5175	66.21	66.3875	200656.0
2019-11-20 09:30:00	AAPL	Stock	66.3875	66.5208	66.2	66.3025	8386708.0
2019-11-20 10:00:00	AAPL	Stock	66.3062	66.3825	66.0575	66.197	5757304.0
2019-11-20 10:30:00	AAPL	Stock	66.1963	66.3375	66.165	66.2588	3535208.0
2019-11-20 11:00:00	AAPL	Stock	66.2625	66.305	66.0565	66.0575	3138676.0
2019-11-20 11:30:00	AAPL	Stock	66.0562	66.14	65.8525	65.89	4697736.0
2019-11-20 12:00:00	AAPL	Stock	65.892	66.07	65.8825	65.9725	3230452.0
2019-11-20 12:30:00	AAPL	Stock	65.975	66.075	65.166	65.4275	7348376.0
2019-11-20 13:00:00	AAPL	Stock	65.4325	65.5825	65.1	65.376	10308232.0
2019-11-20 13:30:00	AAPL	Stock	65.3758	65.555	65.2775	65.5125	5124892.0
2019-11-20 14:00:00	AAPL	Stock	65.5128	65.535	65.3025	65.52	4331240.0
2019-11-20 14:30:00	AAPL	Stock	65.5188	65.705	65.515	65.5625	4821080.0
2019-11-20 15:00:00	AAPL	Stock	65.5625	65.7475	65.4975	65.505	4246180.0
2019-11-20 15:30:00	AAPL	Stock	65.5162	65.8075	65.45	65.805	8159980.0
2019-11-20 16:00:00	AAPL	Stock	65.7975	65.7975	65.705	65.7875	10905320.0
2019-11-20 16:30:00	AAPL	Stock	65.7975	65.7975	65.75	65.77	113896.0
2019-11-20 17:00:00	AAPL	Stock	65.7875	66.2175	65.7875	66.0225	355248.0
2019-11-20 17:30:00	AAPL	Stock	66.0125	66.0375	65.895	65.9425	87792.0
2019-11-20 18:00:00	AAPL	Stock	65.94	65.965	65.805	65.9375	41536.0
2019-11-20 18:30:00	AAPL	Stock	65.9875	66.0625	65.9275	65.9875	31144.0
2019-11-20 19:00:00	AAPL	Stock	66.0	66.075	65.95	65.95	46060.0
2019-11-20 19:30:00	AAPL	Stock	65.95	65.975	65.8125	65.8375	78128.0
2019-11-20 04:00:00	MSFT	Stock	149.55	149.55	149.12	149.31	8609.0
2019-11-20 04:30:00	MSFT	Stock	149.3	149.45	149.3	149.45	1782.0
2019-11-20 05:00:00	MSFT	Stock	149.49	149.51	149.35	149.35	3950.0
2019-11-20 05:30:00	MSFT	Stock	149.35	149.35	149.35	149.35	200.0
2019-11-20 06:00:00	MSFT	Stock	149.31	149.48	149.21	149.25	8753.0
2019-11-20 06:30:00	MSFT	Stock	149.35	149.45	149.35	149.45	900.0
2019-11-20 07:00:00	MSFT	Stock	149.6	149.8	149.46	149.65	5291.0
2019-11-20 07:30:00	MSFT	Stock	149.7	149.7	149.6	149.6	7837.0
2019-11-20 08:00:00	MSFT	Stock	149.463	149.79	149.463	149.65	12333.0
2019-11-20 08:30:00	MSFT	Stock	149.63	149.78	149.55	149.62	15272.0
2019-11-20 09:00:00	MSFT	Stock	149.57	150.95	149.55	150.85	72671.0
2019-11-20 09:30:00	MSFT	Stock	150.23	150.85	149.75	150.605	3002720.0
2019-11-20 10:00:00	MSFT	Stock	150.61	150.698	150.11	150.225	1298982.0
2019-11-20 10:30:00	MSFT	Stock	150.22	150.41	150.07	150.328	1173580.0
2019-11-20 11:00:00	MSFT	Stock	150.33	150.465	150.21	150.27	728663.0
2019-11-20 11:30:00	MSFT	Stock	150.27	150.305	149.96	150.06	858475.0
2019-11-20 12:00:00	MSFT	Stock	150.079	150.22	149.96	150.085	692313.0
2019-11-20 12:30:00	MSFT	Stock	150.09	150.18	148.96	149.31	1445766.0

> showing 50 of 87,003 rows — these rows as CSV

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