PREVIEW / stock_30min / 2020-06-05

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-05.parquet
  size:    2.0 MB
  rows:    101,558
  symbols: 2,409

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-06-05 04:00:00	AAPL	Stock	81.0725	81.2075	81.0725	81.2075	14348.0
2020-06-05 04:30:00	AAPL	Stock	81.1625	81.225	80.8675	81.0225	19624.0
2020-06-05 05:00:00	AAPL	Stock	81.025	81.05	81.025	81.05	8964.0
2020-06-05 05:30:00	AAPL	Stock	80.92	80.9625	80.875	80.9625	4800.0
2020-06-05 06:00:00	AAPL	Stock	80.9625	80.9625	80.875	80.875	11436.0
2020-06-05 06:30:00	AAPL	Stock	80.9275	80.9275	80.8775	80.9	1976.0
2020-06-05 07:00:00	AAPL	Stock	80.9025	80.9875	80.9025	80.925	96808.0
2020-06-05 07:30:00	AAPL	Stock	80.92	80.9775	80.75	80.775	107456.0
2020-06-05 08:00:00	AAPL	Stock	80.9255	80.9825	80.5035	80.7	157964.0
2020-06-05 08:30:00	AAPL	Stock	80.735	81.1125	80.387	80.7475	608400.0
2020-06-05 09:00:00	AAPL	Stock	80.75	81.2	80.75	80.8125	539036.0
2020-06-05 09:30:00	AAPL	Stock	80.85	82.0	80.8075	81.6975	16394904.0
2020-06-05 10:00:00	AAPL	Stock	81.705	81.7425	81.43	81.66	6688468.0
2020-06-05 10:30:00	AAPL	Stock	81.6625	82.0	81.6175	81.9875	6442704.0
2020-06-05 11:00:00	AAPL	Stock	81.99	82.25	81.9058	82.225	7764092.0
2020-06-05 11:30:00	AAPL	Stock	82.22	82.45	82.0925	82.4048	6883096.0
2020-06-05 12:00:00	AAPL	Stock	82.403	82.5	82.2525	82.3575	5892184.0
2020-06-05 12:30:00	AAPL	Stock	82.3558	82.5	82.32	82.4875	4200172.0
2020-06-05 13:00:00	AAPL	Stock	82.48	82.68	82.365	82.662	6230732.0
2020-06-05 13:30:00	AAPL	Stock	82.6625	82.78	82.5342	82.5775	5047812.0
2020-06-05 14:00:00	AAPL	Stock	82.575	82.6725	82.43	82.505	4602884.0
2020-06-05 14:30:00	AAPL	Stock	82.51	82.6775	82.3125	82.5612	5630728.0
2020-06-05 15:00:00	AAPL	Stock	82.5625	82.8975	82.455	82.8725	7040552.0
2020-06-05 15:30:00	AAPL	Stock	82.8675	82.9375	82.5075	82.875	14275608.0
2020-06-05 16:00:00	AAPL	Stock	82.9225	82.9225	82.475	82.775	10673988.0
2020-06-05 16:30:00	AAPL	Stock	82.7875	82.825	78.75	82.8125	881804.0
2020-06-05 17:00:00	AAPL	Stock	82.795	82.825	82.7875	82.79	22536.0
2020-06-05 17:30:00	AAPL	Stock	82.8	82.825	82.725	82.7275	105432.0
2020-06-05 18:00:00	AAPL	Stock	82.7275	82.7725	82.7225	82.725	17948.0
2020-06-05 18:30:00	AAPL	Stock	82.725	82.7825	82.725	82.725	6436.0
2020-06-05 19:00:00	AAPL	Stock	82.7275	82.7625	82.7225	82.75	28352.0
2020-06-05 19:30:00	AAPL	Stock	82.74	82.75	82.7225	82.7225	21140.0
2020-06-05 04:00:00	MSFT	Stock	183.67	184.4	183.67	184.4	1858.0
2020-06-05 05:00:00	MSFT	Stock	184.0	184.0	184.0	184.0	700.0
2020-06-05 06:00:00	MSFT	Stock	183.46	183.6	183.46	183.5	875.0
2020-06-05 06:30:00	MSFT	Stock	183.55	183.55	183.31	183.31	319.0
2020-06-05 07:00:00	MSFT	Stock	183.54	183.55	183.03	183.48	6641.0
2020-06-05 07:30:00	MSFT	Stock	183.41	183.44	182.95	182.95	33664.0
2020-06-05 08:00:00	MSFT	Stock	183.3	183.55	182.5	182.8	36964.0
2020-06-05 08:30:00	MSFT	Stock	182.88	183.45	181.75	182.8	172609.0
2020-06-05 09:00:00	MSFT	Stock	182.88	184.0	182.34	182.44	104449.0
2020-06-05 09:30:00	MSFT	Stock	182.57	185.265	182.01	185.04	4837432.0
2020-06-05 10:00:00	MSFT	Stock	185.05	185.2	183.87	184.655	2499942.0
2020-06-05 10:30:00	MSFT	Stock	184.66	185.39	184.34	185.05	2237953.0
2020-06-05 11:00:00	MSFT	Stock	185.055	186.0	184.98	185.66	2225366.0
2020-06-05 11:30:00	MSFT	Stock	185.65	186.0	185.21	185.785	1541586.0
2020-06-05 12:00:00	MSFT	Stock	185.78	186.32	185.67	186.23	1957067.0
2020-06-05 12:30:00	MSFT	Stock	186.23	186.5	185.96	186.39	1331354.0
2020-06-05 13:00:00	MSFT	Stock	186.38	186.78	185.9	186.69	1174533.0
2020-06-05 13:30:00	MSFT	Stock	186.695	186.758	185.981	186.11	1302486.0

> showing 50 of 101,558 rows — these rows as CSV

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