PREVIEW / stock_30min / 2019-09-19

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-19.parquet
  size:    1.7 MB
  rows:    85,392
  symbols: 2,553

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-09-19 04:00:00	AAPL	Stock	55.54	55.5875	55.5	55.55	16688.0
2019-09-19 04:30:00	AAPL	Stock	55.5475	55.6075	55.5275	55.5275	7716.0
2019-09-19 05:30:00	AAPL	Stock	55.55	55.55	55.55	55.55	756.0
2019-09-19 06:00:00	AAPL	Stock	55.525	55.525	55.48	55.5225	5600.0
2019-09-19 06:30:00	AAPL	Stock	55.4375	55.465	55.435	55.465	14800.0
2019-09-19 07:00:00	AAPL	Stock	55.4825	55.5725	55.4475	55.5725	126168.0
2019-09-19 07:30:00	AAPL	Stock	55.5725	55.6	55.5625	55.6	23220.0
2019-09-19 08:00:00	AAPL	Stock	55.45	55.6775	55.445	55.6775	155640.0
2019-09-19 08:30:00	AAPL	Stock	55.685	55.7975	55.625	55.725	235200.0
2019-09-19 09:00:00	AAPL	Stock	55.7225	55.76	55.4775	55.5025	352628.0
2019-09-19 09:30:00	AAPL	Stock	55.53	55.81	55.5	55.7275	12768156.0
2019-09-19 10:00:00	AAPL	Stock	55.7275	55.79	55.6425	55.747	5386472.0
2019-09-19 10:30:00	AAPL	Stock	55.7475	55.94	55.7475	55.815	5329968.0
2019-09-19 11:00:00	AAPL	Stock	55.8125	55.8475	55.62	55.635	5022100.0
2019-09-19 11:30:00	AAPL	Stock	55.6362	55.755	55.49	55.54	4679168.0
2019-09-19 12:00:00	AAPL	Stock	55.5425	55.575	55.24	55.25	4366784.0
2019-09-19 12:30:00	AAPL	Stock	55.25	55.3625	55.1925	55.3438	3837276.0
2019-09-19 13:00:00	AAPL	Stock	55.3425	55.425	55.2725	55.3	2317640.0
2019-09-19 13:30:00	AAPL	Stock	55.3	55.4075	55.0925	55.3962	5586084.0
2019-09-19 14:00:00	AAPL	Stock	55.395	55.43	55.2988	55.3362	2980732.0
2019-09-19 14:30:00	AAPL	Stock	55.335	55.335	55.1875	55.2698	3874300.0
2019-09-19 15:00:00	AAPL	Stock	55.2688	55.375	55.2225	55.3475	3417616.0
2019-09-19 15:30:00	AAPL	Stock	55.3475	55.3525	55.1875	55.2375	7539220.0
2019-09-19 16:00:00	AAPL	Stock	55.2525	55.275	55.21	55.275	7271232.0
2019-09-19 16:30:00	AAPL	Stock	55.275	55.275	55.24	55.275	63124.0
2019-09-19 17:00:00	AAPL	Stock	55.275	55.285	55.215	55.25	19536.0
2019-09-19 17:30:00	AAPL	Stock	55.2475	55.2725	55.215	55.2175	19212.0
2019-09-19 18:00:00	AAPL	Stock	55.24	55.2725	55.24	55.2625	23844.0
2019-09-19 18:30:00	AAPL	Stock	55.2725	55.285	55.26	55.28	9008.0
2019-09-19 19:00:00	AAPL	Stock	55.265	55.275	55.25	55.2525	20912.0
2019-09-19 19:30:00	AAPL	Stock	55.2675	55.32	55.24	55.2975	41352.0
2019-09-19 04:00:00	MSFT	Stock	140.0	140.11	140.0	140.1	1834.0
2019-09-19 04:30:00	MSFT	Stock	140.12	140.2	140.08	140.1	900.0
2019-09-19 05:00:00	MSFT	Stock	140.1	140.2	140.06	140.06	2999.0
2019-09-19 05:30:00	MSFT	Stock	140.19	140.19	140.1	140.1	673.0
2019-09-19 06:00:00	MSFT	Stock	140.17	140.29	140.17	140.29	1362.0
2019-09-19 06:30:00	MSFT	Stock	140.29	140.29	139.88	139.95	10223.0
2019-09-19 07:00:00	MSFT	Stock	139.99	140.1	139.77	140.1	38090.0
2019-09-19 07:30:00	MSFT	Stock	140.05	140.3	140.04	140.22	18745.0
2019-09-19 08:00:00	MSFT	Stock	140.22	140.37	139.79	140.29	84266.0
2019-09-19 08:30:00	MSFT	Stock	140.28	140.6	138.52	140.45	82347.0
2019-09-19 09:00:00	MSFT	Stock	140.45	140.65	140.13	140.3	157483.0
2019-09-19 09:30:00	MSFT	Stock	140.3	141.9	140.23	141.69	7365726.0
2019-09-19 10:00:00	MSFT	Stock	141.685	142.37	141.63	141.975	3548328.0
2019-09-19 10:30:00	MSFT	Stock	141.98	142.17	141.67	141.76	1991639.0
2019-09-19 11:00:00	MSFT	Stock	141.762	141.81	141.115	141.27	1610955.0
2019-09-19 11:30:00	MSFT	Stock	141.26	141.61	141.18	141.295	1195581.0
2019-09-19 12:00:00	MSFT	Stock	141.29	141.51	140.63	140.778	1394735.0
2019-09-19 12:30:00	MSFT	Stock	140.78	140.96	140.66	140.666	1005113.0
2019-09-19 13:00:00	MSFT	Stock	140.66	140.85	140.074	140.811	1748892.0

> showing 50 of 85,392 rows — these rows as CSV

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