PREVIEW / stock_30min / 2020-07-02

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-02.parquet
  size:    1.9 MB
  rows:    96,598
  symbols: 2,435

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-07-02 04:00:00	AAPL	Stock	91.3475	91.5	91.2625	91.5	8928.0
2020-07-02 04:30:00	AAPL	Stock	91.5025	91.5025	91.5	91.5	1288.0
2020-07-02 05:00:00	AAPL	Stock	91.46	91.525	91.4	91.5	6712.0
2020-07-02 05:30:00	AAPL	Stock	91.46	91.46	91.3775	91.38	10732.0
2020-07-02 06:00:00	AAPL	Stock	91.3975	91.4	91.375	91.375	19064.0
2020-07-02 06:30:00	AAPL	Stock	91.35	91.4525	91.35	91.4525	3304.0
2020-07-02 07:00:00	AAPL	Stock	91.375	91.495	91.375	91.455	72564.0
2020-07-02 07:30:00	AAPL	Stock	91.4575	91.5	91.38	91.455	109008.0
2020-07-02 08:00:00	AAPL	Stock	91.435	91.4975	91.33	91.455	227008.0
2020-07-02 08:30:00	AAPL	Stock	91.45	91.85	91.45	91.8025	671236.0
2020-07-02 09:00:00	AAPL	Stock	91.8025	91.95	91.6625	91.9425	328368.0
2020-07-02 09:30:00	AAPL	Stock	91.9475	92.6175	91.8325	92.495	18156084.0
2020-07-02 10:00:00	AAPL	Stock	92.4975	92.52	91.375	91.54	11243316.0
2020-07-02 10:30:00	AAPL	Stock	91.5362	92.02	91.48	91.8078	8306304.0
2020-07-02 11:00:00	AAPL	Stock	91.8075	91.8175	91.4725	91.5888	5120532.0
2020-07-02 11:30:00	AAPL	Stock	91.6	91.885	91.4525	91.86	4531900.0
2020-07-02 12:00:00	AAPL	Stock	91.86	92.015	91.6675	91.95	4176040.0
2020-07-02 12:30:00	AAPL	Stock	91.9475	91.965	91.775	91.8925	2883060.0
2020-07-02 13:00:00	AAPL	Stock	91.89	91.8975	91.6125	91.645	3238864.0
2020-07-02 13:30:00	AAPL	Stock	91.6425	91.7425	91.5738	91.6125	3028212.0
2020-07-02 14:00:00	AAPL	Stock	91.605	91.74	91.535	91.735	2338120.0
2020-07-02 14:30:00	AAPL	Stock	91.7375	91.8275	91.68	91.78	2976452.0
2020-07-02 15:00:00	AAPL	Stock	91.7775	91.82	91.5525	91.6425	3756376.0
2020-07-02 15:30:00	AAPL	Stock	91.6475	91.75	90.91	91.03	11086152.0
2020-07-02 16:00:00	AAPL	Stock	91.03	91.1875	91.0275	91.14	9554056.0
2020-07-02 16:30:00	AAPL	Stock	91.1525	91.2375	91.125	91.215	97764.0
2020-07-02 17:00:00	AAPL	Stock	91.215	91.25	91.19	91.2125	28460.0
2020-07-02 17:30:00	AAPL	Stock	91.225	91.225	91.16	91.2225	10544.0
2020-07-02 18:00:00	AAPL	Stock	91.225	91.25	91.2025	91.25	27600.0
2020-07-02 18:30:00	AAPL	Stock	91.3	91.3	91.2025	91.2025	5528.0
2020-07-02 19:00:00	AAPL	Stock	91.2	91.2	91.15	91.2	20648.0
2020-07-02 19:30:00	AAPL	Stock	91.2	91.225	91.15	91.2125	23532.0
2020-07-02 04:00:00	MSFT	Stock	205.8	205.8	205.8	205.8	292.0
2020-07-02 04:30:00	MSFT	Stock	205.99	205.99	205.5	205.5	6478.0
2020-07-02 05:00:00	MSFT	Stock	205.49	205.5	205.49	205.5	1666.0
2020-07-02 05:30:00	MSFT	Stock	205.4	205.6	205.3	205.6	1635.0
2020-07-02 06:00:00	MSFT	Stock	205.7	205.7	205.35	205.35	1945.0
2020-07-02 06:30:00	MSFT	Stock	205.65	205.65	205.65	205.65	136.0
2020-07-02 07:00:00	MSFT	Stock	205.7	205.75	205.45	205.64	15182.0
2020-07-02 07:30:00	MSFT	Stock	205.63	206.0	205.43	205.72	28675.0
2020-07-02 08:00:00	MSFT	Stock	205.72	205.99	205.4	205.4	36271.0
2020-07-02 08:30:00	MSFT	Stock	205.5	206.8	205.5	206.598	79162.0
2020-07-02 09:00:00	MSFT	Stock	206.6	206.7	205.0	205.69	88862.0
2020-07-02 09:30:00	MSFT	Stock	205.69	207.71	205.0	207.43	4232829.0
2020-07-02 10:00:00	MSFT	Stock	207.43	207.56	206.469	206.6	2002236.0
2020-07-02 10:30:00	MSFT	Stock	206.62	207.99	206.37	207.7	2124788.0
2020-07-02 11:00:00	MSFT	Stock	207.69	207.7	206.062	206.28	1708993.0
2020-07-02 11:30:00	MSFT	Stock	206.32	207.09	206.2	207.031	1230864.0
2020-07-02 12:00:00	MSFT	Stock	207.03	207.61	206.66	207.5	971855.0
2020-07-02 12:30:00	MSFT	Stock	207.51	207.9	207.39	207.88	900913.0

> showing 50 of 96,598 rows — these rows as CSV

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