PREVIEW / stock_30min / 2018-12-03

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-03.parquet
  size:    1.8 MB
  rows:    87,405
  symbols: 2,739

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
2018-12-03 04:00:00	AAPL	Stock	46.05	46.4625	46.05	46.1625	176760.0
2018-12-03 04:30:00	AAPL	Stock	46.2	46.3325	46.1825	46.3325	35388.0
2018-12-03 05:00:00	AAPL	Stock	46.35	46.4025	46.2525	46.2775	64252.0
2018-12-03 05:30:00	AAPL	Stock	46.3525	46.375	46.2125	46.275	99276.0
2018-12-03 06:00:00	AAPL	Stock	46.2525	46.2775	46.05	46.1	138432.0
2018-12-03 06:30:00	AAPL	Stock	46.1	46.225	46.07	46.1125	160588.0
2018-12-03 07:00:00	AAPL	Stock	46.1725	46.25	46.025	46.125	498364.0
2018-12-03 07:30:00	AAPL	Stock	46.1075	46.175	46.025	46.1	339460.0
2018-12-03 08:00:00	AAPL	Stock	46.1	46.215	46.025	46.135	1080928.0
2018-12-03 08:30:00	AAPL	Stock	46.1525	46.1525	45.9875	46.0025	614628.0
2018-12-03 09:00:00	AAPL	Stock	46.0	46.145	45.9425	46.095	793436.0
2018-12-03 09:30:00	AAPL	Stock	46.0975	46.17	45.3325	45.415	27424580.0
2018-12-03 10:00:00	AAPL	Stock	45.4175	45.7675	45.3675	45.748	14906292.0
2018-12-03 10:30:00	AAPL	Stock	45.75	45.7925	45.3675	45.405	10536076.0
2018-12-03 11:00:00	AAPL	Stock	45.405	45.6725	45.335	45.5475	8533312.0
2018-12-03 11:30:00	AAPL	Stock	45.55	45.64	45.3025	45.35	7256908.0
2018-12-03 12:00:00	AAPL	Stock	45.3525	45.5275	45.3525	45.4825	4965312.0
2018-12-03 12:30:00	AAPL	Stock	45.485	45.5707	45.4375	45.535	3691176.0
2018-12-03 13:00:00	AAPL	Stock	45.535	45.7225	45.5338	45.665	4528192.0
2018-12-03 13:30:00	AAPL	Stock	45.6682	45.685	45.5075	45.6125	3580976.0
2018-12-03 14:00:00	AAPL	Stock	45.615	45.735	45.4475	45.72	5064084.0
2018-12-03 14:30:00	AAPL	Stock	45.72	45.9375	45.7112	45.875	6860652.0
2018-12-03 15:00:00	AAPL	Stock	45.8725	46.075	45.7325	46.055	9021536.0
2018-12-03 15:30:00	AAPL	Stock	46.0565	46.235	46.005	46.2325	16543892.0
2018-12-03 16:00:00	AAPL	Stock	46.2325	46.2375	45.5475	46.16	16535264.0
2018-12-03 16:30:00	AAPL	Stock	46.1475	46.16	46.0475	46.1225	130712.0
2018-12-03 17:00:00	AAPL	Stock	46.125	46.125	46.08	46.0825	20032.0
2018-12-03 17:30:00	AAPL	Stock	46.1	46.205	45.75	45.7875	350996.0
2018-12-03 18:00:00	AAPL	Stock	45.775	45.86	45.7525	45.795	88136.0
2018-12-03 18:30:00	AAPL	Stock	45.85	45.8625	45.755	45.7625	40308.0
2018-12-03 19:00:00	AAPL	Stock	45.7625	45.7625	45.52	45.625	123468.0
2018-12-03 19:30:00	AAPL	Stock	45.625	45.695	45.45	45.5	199436.0
2018-12-03 04:00:00	MSFT	Stock	113.05	114.0	113.05	113.6	9281.0
2018-12-03 04:30:00	MSFT	Stock	113.75	113.85	113.46	113.85	13242.0
2018-12-03 05:00:00	MSFT	Stock	113.84	113.84	113.31	113.35	10481.0
2018-12-03 05:30:00	MSFT	Stock	113.45	113.47	113.3	113.31	3657.0
2018-12-03 06:00:00	MSFT	Stock	113.33	113.33	113.23	113.23	1198.0
2018-12-03 06:30:00	MSFT	Stock	113.33	113.47	113.2	113.3	3442.0
2018-12-03 07:00:00	MSFT	Stock	113.36	113.47	113.01	113.38	42136.0
2018-12-03 07:30:00	MSFT	Stock	113.33	113.45	113.19	113.34	16804.0
2018-12-03 08:00:00	MSFT	Stock	113.456	113.49	113.01	113.03	71031.0
2018-12-03 08:30:00	MSFT	Stock	113.02	113.02	112.62	112.9	33452.0
2018-12-03 09:00:00	MSFT	Stock	112.85	113.19	112.8	113.09	57072.0
2018-12-03 09:30:00	MSFT	Stock	113.12	113.42	111.71	111.97	5509209.0
2018-12-03 10:00:00	MSFT	Stock	111.99	112.57	111.92	112.215	2817327.0
2018-12-03 10:30:00	MSFT	Stock	112.213	112.235	110.93	110.995	2420154.0
2018-12-03 11:00:00	MSFT	Stock	111.0	112.0	110.73	111.81	2649689.0
2018-12-03 11:30:00	MSFT	Stock	111.83	112.06	111.21	111.34	1519406.0
2018-12-03 12:00:00	MSFT	Stock	111.349	111.72	111.34	111.67	885622.0
2018-12-03 12:30:00	MSFT	Stock	111.67	111.97	111.47	111.75	891363.0

> showing 50 of 87,405 rows — these rows as CSV

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