PREVIEW / stock_30min / 2019-07-31

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-31.parquet
  size:    1.8 MB
  rows:    88,562
  symbols: 2,601

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-07-31 04:00:00	AAPL	Stock	54.5325	54.575	54.35	54.55	96668.0
2019-07-31 04:30:00	AAPL	Stock	54.5075	54.545	54.4425	54.5	20532.0
2019-07-31 05:00:00	AAPL	Stock	54.5	54.55	54.425	54.425	50280.0
2019-07-31 05:30:00	AAPL	Stock	54.3875	54.4375	54.275	54.3275	40920.0
2019-07-31 06:00:00	AAPL	Stock	54.325	54.445	54.29	54.435	45276.0
2019-07-31 06:30:00	AAPL	Stock	54.375	54.42	54.3125	54.3375	39492.0
2019-07-31 07:00:00	AAPL	Stock	54.37	54.525	54.3225	54.425	392224.0
2019-07-31 07:30:00	AAPL	Stock	54.425	54.5725	54.375	54.455	569368.0
2019-07-31 08:00:00	AAPL	Stock	54.4325	54.5675	54.2675	54.2675	841740.0
2019-07-31 08:30:00	AAPL	Stock	54.265	54.3	54.1	54.1875	860200.0
2019-07-31 09:00:00	AAPL	Stock	54.1825	54.3475	54.075	54.1	1594952.0
2019-07-31 09:30:00	AAPL	Stock	54.08	55.3425	54.08	54.7775	68866272.0
2019-07-31 10:00:00	AAPL	Stock	54.78	54.985	54.3225	54.3775	26727940.0
2019-07-31 10:30:00	AAPL	Stock	54.3775	54.5902	54.2875	54.5625	15101008.0
2019-07-31 11:00:00	AAPL	Stock	54.5625	54.6925	54.455	54.4725	8144772.0
2019-07-31 11:30:00	AAPL	Stock	54.4725	54.545	54.3775	54.4685	5685528.0
2019-07-31 12:00:00	AAPL	Stock	54.4675	54.485	54.195	54.2175	6592224.0
2019-07-31 12:30:00	AAPL	Stock	54.218	54.375	54.0425	54.265	9913188.0
2019-07-31 13:00:00	AAPL	Stock	54.2632	54.375	54.2125	54.317	4601656.0
2019-07-31 13:30:00	AAPL	Stock	54.32	54.4175	54.21	54.3325	4145888.0
2019-07-31 14:00:00	AAPL	Stock	54.3375	54.455	54.135	54.2125	8860288.0
2019-07-31 14:30:00	AAPL	Stock	54.213	54.3275	52.825	53.65	24031416.0
2019-07-31 15:00:00	AAPL	Stock	53.645	53.96	53.425	53.822	16372832.0
2019-07-31 15:30:00	AAPL	Stock	53.8275	53.8275	53.195	53.195	19984984.0
2019-07-31 16:00:00	AAPL	Stock	53.26	54.2962	53.2325	53.265	12587036.0
2019-07-31 16:30:00	AAPL	Stock	53.265	53.265	53.165	53.175	192252.0
2019-07-31 17:00:00	AAPL	Stock	53.2125	53.2225	53.1525	53.21	68180.0
2019-07-31 17:30:00	AAPL	Stock	53.225	53.26	53.15	53.17	103788.0
2019-07-31 18:00:00	AAPL	Stock	53.17	53.2225	53.0775	53.22	148276.0
2019-07-31 18:30:00	AAPL	Stock	53.205	53.2725	53.1875	53.2375	97520.0
2019-07-31 19:00:00	AAPL	Stock	53.24	53.3725	53.235	53.3475	47776.0
2019-07-31 19:30:00	AAPL	Stock	53.36	53.3975	53.225	53.225	89864.0
2019-07-31 04:00:00	MSFT	Stock	140.73	140.78	140.73	140.78	700.0
2019-07-31 04:30:00	MSFT	Stock	140.77	140.78	140.76	140.76	1486.0
2019-07-31 05:30:00	MSFT	Stock	140.6	140.6	140.6	140.6	100.0
2019-07-31 06:00:00	MSFT	Stock	140.38	140.38	140.38	140.38	100.0
2019-07-31 06:30:00	MSFT	Stock	140.35	140.35	140.35	140.35	300.0
2019-07-31 07:00:00	MSFT	Stock	140.41	140.41	140.11	140.33	5146.0
2019-07-31 07:30:00	MSFT	Stock	140.33	140.39	140.22	140.39	4797.0
2019-07-31 08:00:00	MSFT	Stock	140.15	140.45	140.15	140.4	4800.0
2019-07-31 08:30:00	MSFT	Stock	140.5	140.596	140.45	140.5	10889.0
2019-07-31 09:00:00	MSFT	Stock	140.59	140.69	140.01	140.25	47919.0
2019-07-31 09:30:00	MSFT	Stock	140.21	140.49	139.215	139.57	3464225.0
2019-07-31 10:00:00	MSFT	Stock	139.56	139.76	139.2	139.25	1796231.0
2019-07-31 10:30:00	MSFT	Stock	139.25	139.29	138.83	139.26	1958285.0
2019-07-31 11:00:00	MSFT	Stock	139.26	139.545	139.12	139.14	1032295.0
2019-07-31 11:30:00	MSFT	Stock	139.15	139.275	139.04	139.22	633260.0
2019-07-31 12:00:00	MSFT	Stock	139.22	139.26	138.98	139.0	711659.0
2019-07-31 12:30:00	MSFT	Stock	138.99	139.03	138.87	138.97	633001.0
2019-07-31 13:00:00	MSFT	Stock	138.97	138.99	138.65	138.68	929172.0

> showing 50 of 88,562 rows — these rows as CSV

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