PREVIEW / stock_30min / 2020-07-24

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-24.parquet
  size:    1.9 MB
  rows:    95,547
  symbols: 2,425

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-24 04:00:00	AAPL	Stock	91.5	91.575	91.125	91.415	117252.0
2020-07-24 04:30:00	AAPL	Stock	91.425	91.5775	91.3875	91.5	27292.0
2020-07-24 05:00:00	AAPL	Stock	91.46	91.4975	91.305	91.3875	18668.0
2020-07-24 05:30:00	AAPL	Stock	91.3725	91.5625	91.3725	91.5625	35420.0
2020-07-24 06:00:00	AAPL	Stock	91.5625	91.9925	91.5	91.9625	55636.0
2020-07-24 06:30:00	AAPL	Stock	91.9625	91.9925	91.515	91.7075	79320.0
2020-07-24 07:00:00	AAPL	Stock	91.75	92.0	91.195	91.195	352468.0
2020-07-24 07:30:00	AAPL	Stock	91.1575	91.255	90.775	91.22	335844.0
2020-07-24 08:00:00	AAPL	Stock	91.8125	92.0	90.85	91.5	718908.0
2020-07-24 08:30:00	AAPL	Stock	91.5	91.625	91.2675	91.435	297540.0
2020-07-24 09:00:00	AAPL	Stock	91.4325	91.4675	90.8425	90.9375	522252.0
2020-07-24 09:30:00	AAPL	Stock	90.9475	91.2675	89.145	90.565	36154196.0
2020-07-24 10:00:00	AAPL	Stock	90.566	91.5925	90.5375	91.4475	16109028.0
2020-07-24 10:30:00	AAPL	Stock	91.445	92.12	90.69	92.09	12214868.0
2020-07-24 11:00:00	AAPL	Stock	92.1025	92.905	91.8425	92.7025	12451096.0
2020-07-24 11:30:00	AAPL	Stock	92.7075	92.7375	91.735	92.31	8691240.0
2020-07-24 12:00:00	AAPL	Stock	92.31	92.4175	91.8775	92.28	5785956.0
2020-07-24 12:30:00	AAPL	Stock	92.2825	92.31	91.805	91.95	4526648.0
2020-07-24 13:00:00	AAPL	Stock	91.9475	92.2025	91.395	91.9325	5704880.0
2020-07-24 13:30:00	AAPL	Stock	91.94	92.6225	91.7725	92.4275	5272840.0
2020-07-24 14:00:00	AAPL	Stock	92.425	92.8675	92.335	92.7662	5125504.0
2020-07-24 14:30:00	AAPL	Stock	92.7725	92.7775	92.1475	92.472	4980660.0
2020-07-24 15:00:00	AAPL	Stock	92.4675	92.97	92.2975	92.375	8343780.0
2020-07-24 15:30:00	AAPL	Stock	92.37	92.79	92.2525	92.605	11005276.0
2020-07-24 16:00:00	AAPL	Stock	92.615	92.81	92.605	92.65	4173748.0
2020-07-24 16:30:00	AAPL	Stock	92.685	92.8125	92.685	92.775	24280.0
2020-07-24 17:00:00	AAPL	Stock	92.8125	92.85	92.7375	92.75	41060.0
2020-07-24 17:30:00	AAPL	Stock	92.75	92.75	92.5	92.5	22900.0
2020-07-24 18:00:00	AAPL	Stock	92.5175	92.615	92.4375	92.5025	299644.0
2020-07-24 18:30:00	AAPL	Stock	92.4425	92.4975	92.375	92.45	28296.0
2020-07-24 19:00:00	AAPL	Stock	92.4025	92.4375	92.295	92.295	23880.0
2020-07-24 19:30:00	AAPL	Stock	92.2525	92.44	92.2525	92.425	46144.0
2020-07-24 04:00:00	MSFT	Stock	199.7	199.99	199.03	199.89	26185.0
2020-07-24 04:30:00	MSFT	Stock	199.77	199.98	199.7	199.9	7723.0
2020-07-24 05:00:00	MSFT	Stock	199.74	199.95	199.74	199.95	6160.0
2020-07-24 05:30:00	MSFT	Stock	199.95	200.5	199.95	200.5	9574.0
2020-07-24 06:00:00	MSFT	Stock	200.5	200.9	200.4	200.86	7330.0
2020-07-24 06:30:00	MSFT	Stock	200.75	200.85	200.0	200.42	14169.0
2020-07-24 07:00:00	MSFT	Stock	200.41	201.5	200.25	200.32	80243.0
2020-07-24 07:30:00	MSFT	Stock	200.31	200.69	199.87	200.5	100311.0
2020-07-24 08:00:00	MSFT	Stock	200.8	201.44	199.83	201.0	161281.0
2020-07-24 08:30:00	MSFT	Stock	201.0	201.47	200.39	200.69	79273.0
2020-07-24 09:00:00	MSFT	Stock	200.65	201.2	200.22	200.42	166388.0
2020-07-24 09:30:00	MSFT	Stock	200.42	200.76	197.51	199.75	7315019.0
2020-07-24 10:00:00	MSFT	Stock	199.73	201.75	199.67	201.407	3470197.0
2020-07-24 10:30:00	MSFT	Stock	201.42	202.1	200.09	202.06	2533839.0
2020-07-24 11:00:00	MSFT	Stock	202.07	202.56	201.28	202.404	2213181.0
2020-07-24 11:30:00	MSFT	Stock	202.41	202.86	201.89	202.495	1919219.0
2020-07-24 12:00:00	MSFT	Stock	202.5	202.57	200.92	201.78	1536453.0
2020-07-24 12:30:00	MSFT	Stock	201.76	201.82	200.77	201.02	1057761.0

> showing 50 of 95,547 rows — these rows as CSV

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