PREVIEW / stock_30min / 2019-03-07

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-07.parquet
  size:    1.7 MB
  rows:    84,870
  symbols: 2,656

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-03-07 04:00:00	AAPL	Stock	43.5	43.5	43.475	43.485	4832.0
2019-03-07 05:00:00	AAPL	Stock	43.44	43.44	43.44	43.44	400.0
2019-03-07 06:00:00	AAPL	Stock	43.47	43.47	43.47	43.47	800.0
2019-03-07 06:30:00	AAPL	Stock	43.4775	43.4775	43.4775	43.4775	1200.0
2019-03-07 07:00:00	AAPL	Stock	43.4875	43.545	43.45	43.5425	38296.0
2019-03-07 07:30:00	AAPL	Stock	43.5325	43.5875	43.5025	43.5875	50696.0
2019-03-07 08:00:00	AAPL	Stock	43.515	43.6275	43.495	43.6275	56376.0
2019-03-07 08:30:00	AAPL	Stock	43.6125	43.675	43.57	43.58	108296.0
2019-03-07 09:00:00	AAPL	Stock	43.5875	43.62	43.4875	43.5	69344.0
2019-03-07 09:30:00	AAPL	Stock	43.4675	43.61	43.3625	43.3825	11004160.0
2019-03-07 10:00:00	AAPL	Stock	43.385	43.3875	43.005	43.1825	10601756.0
2019-03-07 10:30:00	AAPL	Stock	43.1825	43.2675	43.0675	43.2285	6059880.0
2019-03-07 11:00:00	AAPL	Stock	43.2275	43.3075	43.1825	43.2575	4136608.0
2019-03-07 11:30:00	AAPL	Stock	43.26	43.4125	43.26	43.4	4130896.0
2019-03-07 12:00:00	AAPL	Stock	43.3988	43.4222	43.3175	43.395	3519932.0
2019-03-07 12:30:00	AAPL	Stock	43.3925	43.5575	43.2575	43.5	5052708.0
2019-03-07 13:00:00	AAPL	Stock	43.5	43.555	43.4325	43.455	2776540.0
2019-03-07 13:30:00	AAPL	Stock	43.455	43.495	43.35	43.44	2762812.0
2019-03-07 14:00:00	AAPL	Stock	43.4375	43.46	43.3025	43.3312	3389612.0
2019-03-07 14:30:00	AAPL	Stock	43.3325	43.35	43.14	43.185	4907428.0
2019-03-07 15:00:00	AAPL	Stock	43.1875	43.205	43.0925	43.115	6279872.0
2019-03-07 15:30:00	AAPL	Stock	43.1125	43.215	43.075	43.1175	9139444.0
2019-03-07 16:00:00	AAPL	Stock	43.12	43.15	43.12	43.1325	15207576.0
2019-03-07 16:30:00	AAPL	Stock	43.1375	43.1525	43.125	43.15	776644.0
2019-03-07 17:00:00	AAPL	Stock	43.1575	43.1625	43.145	43.145	5496.0
2019-03-07 17:30:00	AAPL	Stock	43.13	43.14	43.13	43.14	12396.0
2019-03-07 18:00:00	AAPL	Stock	43.145	43.19	43.125	43.175	76288.0
2019-03-07 18:30:00	AAPL	Stock	43.175	43.2	43.175	43.2	7480.0
2019-03-07 19:00:00	AAPL	Stock	43.1775	43.2	43.1575	43.16	13064.0
2019-03-07 19:30:00	AAPL	Stock	43.16	43.165	43.0775	43.0775	39100.0
2019-03-07 04:30:00	MSFT	Stock	111.24	111.24	111.22	111.22	200.0
2019-03-07 05:30:00	MSFT	Stock	111.0	111.2	111.0	111.2	485.0
2019-03-07 07:00:00	MSFT	Stock	111.22	111.47	111.22	111.35	9579.0
2019-03-07 07:30:00	MSFT	Stock	111.35	111.55	111.35	111.54	4811.0
2019-03-07 08:00:00	MSFT	Stock	111.491	111.85	111.29	111.85	4466.0
2019-03-07 08:30:00	MSFT	Stock	111.75	111.9	111.55	111.7	7998.0
2019-03-07 09:00:00	MSFT	Stock	111.65	111.65	111.24	111.37	3936.0
2019-03-07 09:30:00	MSFT	Stock	111.39	111.55	110.57	110.64	2671842.0
2019-03-07 10:00:00	MSFT	Stock	110.625	110.71	110.15	110.31	1925733.0
2019-03-07 10:30:00	MSFT	Stock	110.305	110.48	109.865	110.41	1559626.0
2019-03-07 11:00:00	MSFT	Stock	110.415	110.57	110.13	110.34	1209718.0
2019-03-07 11:30:00	MSFT	Stock	110.35	110.92	110.35	110.78	956224.0
2019-03-07 12:00:00	MSFT	Stock	110.77	110.93	110.68	110.84	562013.0
2019-03-07 12:30:00	MSFT	Stock	110.84	111.21	110.55	111.16	866435.0
2019-03-07 13:00:00	MSFT	Stock	111.16	111.22	110.9	110.975	549201.0
2019-03-07 13:30:00	MSFT	Stock	110.98	110.98	110.7	110.74	599799.0
2019-03-07 14:00:00	MSFT	Stock	110.74	110.84	110.365	110.48	700958.0
2019-03-07 14:30:00	MSFT	Stock	110.48	110.54	109.939	110.07	1043188.0
2019-03-07 15:00:00	MSFT	Stock	110.08	110.33	109.94	110.006	1185841.0
2019-03-07 15:30:00	MSFT	Stock	110.01	110.5	110.004	110.38	2464334.0

> showing 50 of 84,870 rows — these rows as CSV

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