PREVIEW / stock_30min / 2020-04-06

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-06.parquet
  size:    1.9 MB
  rows:    94,471
  symbols: 2,441

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
2020-04-06 04:00:00	AAPL	Stock	62.9025	63.0275	62.5125	62.75	65336.0
2020-04-06 04:30:00	AAPL	Stock	62.85	62.8875	62.4875	62.8675	51380.0
2020-04-06 05:00:00	AAPL	Stock	62.8	63.0	62.5525	63.0	33380.0
2020-04-06 05:30:00	AAPL	Stock	62.985	63.175	62.9	62.9675	37168.0
2020-04-06 06:00:00	AAPL	Stock	62.915	62.995	62.75	62.8125	16848.0
2020-04-06 06:30:00	AAPL	Stock	62.8125	62.87	62.795	62.8475	15736.0
2020-04-06 07:00:00	AAPL	Stock	62.795	62.875	62.375	62.5775	484760.0
2020-04-06 07:30:00	AAPL	Stock	62.565	62.5925	62.375	62.4675	351724.0
2020-04-06 08:00:00	AAPL	Stock	62.5	62.825	62.271	62.4475	460744.0
2020-04-06 08:30:00	AAPL	Stock	62.4025	62.785	62.4	62.6875	520252.0
2020-04-06 09:00:00	AAPL	Stock	62.6758	62.75	62.6	62.7175	424244.0
2020-04-06 09:30:00	AAPL	Stock	62.7175	63.415	62.345	63.315	22768976.0
2020-04-06 10:00:00	AAPL	Stock	63.3275	63.3475	63.0675	63.2695	10213744.0
2020-04-06 10:30:00	AAPL	Stock	63.275	63.52	63.1	63.2525	11245024.0
2020-04-06 11:00:00	AAPL	Stock	63.245	63.4975	63.1875	63.455	6926692.0
2020-04-06 11:30:00	AAPL	Stock	63.455	63.52	63.285	63.4058	5730780.0
2020-04-06 12:00:00	AAPL	Stock	63.41	63.655	63.355	63.53	8241132.0
2020-04-06 12:30:00	AAPL	Stock	63.534	63.5975	63.3642	63.5925	5591308.0
2020-04-06 13:00:00	AAPL	Stock	63.595	63.7475	63.4675	63.715	6129468.0
2020-04-06 13:30:00	AAPL	Stock	63.72	63.94	63.665	63.935	6462276.0
2020-04-06 14:00:00	AAPL	Stock	63.935	63.945	63.6525	63.825	6005208.0
2020-04-06 14:30:00	AAPL	Stock	63.83	63.9975	63.7475	63.9875	5179960.0
2020-04-06 15:00:00	AAPL	Stock	63.985	64.2625	63.8425	64.236	10437924.0
2020-04-06 15:30:00	AAPL	Stock	64.2395	65.7775	64.1775	65.5713	36010920.0
2020-04-06 16:00:00	AAPL	Stock	65.6175	65.6175	65.3375	65.465	21210236.0
2020-04-06 16:30:00	AAPL	Stock	65.5	65.6175	65.415	65.4675	205600.0
2020-04-06 17:00:00	AAPL	Stock	65.475	65.475	65.375	65.39	102772.0
2020-04-06 17:30:00	AAPL	Stock	65.41	65.425	65.31	65.37	57988.0
2020-04-06 18:00:00	AAPL	Stock	65.33	65.4175	65.27	65.275	110052.0
2020-04-06 18:30:00	AAPL	Stock	65.2825	65.375	65.1575	65.1975	119572.0
2020-04-06 19:00:00	AAPL	Stock	65.18	65.4825	65.1525	65.4725	122240.0
2020-04-06 19:30:00	AAPL	Stock	65.485	65.75	65.4425	65.675	251736.0
2020-04-06 04:00:00	MSFT	Stock	159.9	160.29	159.1	159.86	28321.0
2020-04-06 04:30:00	MSFT	Stock	160.21	160.92	159.4	160.75	8566.0
2020-04-06 05:00:00	MSFT	Stock	160.3	160.75	160.0	160.5	5393.0
2020-04-06 05:30:00	MSFT	Stock	160.62	161.44	160.6	160.97	11062.0
2020-04-06 06:00:00	MSFT	Stock	160.75	160.75	160.0	160.6	8726.0
2020-04-06 06:30:00	MSFT	Stock	160.35	160.5	160.2	160.47	2816.0
2020-04-06 07:00:00	MSFT	Stock	160.18	160.38	158.99	159.97	147202.0
2020-04-06 07:30:00	MSFT	Stock	159.9	160.26	159.53	159.8	69558.0
2020-04-06 08:00:00	MSFT	Stock	159.74	160.2	159.0	159.8	131886.0
2020-04-06 08:30:00	MSFT	Stock	159.88	160.33	159.67	160.103	106531.0
2020-04-06 09:00:00	MSFT	Stock	160.05	160.6	159.7	160.46	109629.0
2020-04-06 09:30:00	MSFT	Stock	160.28	161.0	157.58	160.39	8022586.0
2020-04-06 10:00:00	MSFT	Stock	160.39	160.79	159.58	160.48	3543447.0
2020-04-06 10:30:00	MSFT	Stock	160.49	161.02	159.95	160.3	2978372.0
2020-04-06 11:00:00	MSFT	Stock	160.29	161.465	160.17	161.28	2787581.0
2020-04-06 11:30:00	MSFT	Stock	161.26	161.49	160.73	161.27	1965239.0
2020-04-06 12:00:00	MSFT	Stock	161.27	162.0	161.11	161.94	2426759.0
2020-04-06 12:30:00	MSFT	Stock	161.94	162.076	161.675	162.02	2167088.0

> showing 50 of 94,471 rows — these rows as CSV

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