PREVIEW / stock_30min / 2018-12-19

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-19.parquet
  size:    1.7 MB
  rows:    85,559
  symbols: 2,728

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-19 04:00:00	AAPL	Stock	41.6075	41.6075	41.6075	41.6075	400.0
2018-12-19 04:30:00	AAPL	Stock	41.575	41.575	41.575	41.575	5692.0
2018-12-19 05:00:00	AAPL	Stock	41.5925	41.7425	41.5925	41.7025	2816.0
2018-12-19 05:30:00	AAPL	Stock	41.665	41.665	41.665	41.665	400.0
2018-12-19 06:00:00	AAPL	Stock	41.675	41.7	41.675	41.7	1516.0
2018-12-19 06:30:00	AAPL	Stock	41.675	41.675	41.675	41.675	1600.0
2018-12-19 07:00:00	AAPL	Stock	41.63	41.7175	41.615	41.67	27996.0
2018-12-19 07:30:00	AAPL	Stock	41.675	41.68	41.645	41.6725	21684.0
2018-12-19 08:00:00	AAPL	Stock	41.67	41.73	41.5475	41.5625	246912.0
2018-12-19 08:30:00	AAPL	Stock	41.565	41.62	41.5075	41.5825	93232.0
2018-12-19 09:00:00	AAPL	Stock	41.5825	41.5825	41.465	41.5	104388.0
2018-12-19 09:30:00	AAPL	Stock	41.5	41.7875	41.24	41.6875	13004560.0
2018-12-19 10:00:00	AAPL	Stock	41.6875	41.8625	41.6025	41.72	9183836.0
2018-12-19 10:30:00	AAPL	Stock	41.72	41.7975	41.5603	41.65	5119172.0
2018-12-19 11:00:00	AAPL	Stock	41.6545	41.66	41.4725	41.5025	4144864.0
2018-12-19 11:30:00	AAPL	Stock	41.4975	41.675	41.4425	41.6425	4291760.0
2018-12-19 12:00:00	AAPL	Stock	41.645	41.735	41.63	41.6512	3717608.0
2018-12-19 12:30:00	AAPL	Stock	41.65	41.81	41.6362	41.6512	4106604.0
2018-12-19 13:00:00	AAPL	Stock	41.65	41.68	41.465	41.5025	4274236.0
2018-12-19 13:30:00	AAPL	Stock	41.5015	41.75	41.4882	41.7375	4362600.0
2018-12-19 14:00:00	AAPL	Stock	41.6975	41.8175	40.725	41.2195	19531992.0
2018-12-19 14:30:00	AAPL	Stock	41.225	41.3675	40.3	40.435	21892804.0
2018-12-19 15:00:00	AAPL	Stock	40.4375	40.4375	39.7725	40.1325	31684800.0
2018-12-19 15:30:00	AAPL	Stock	40.1398	40.35	39.9425	40.19	19942012.0
2018-12-19 16:00:00	AAPL	Stock	40.1825	40.275	40.13	40.2	21245192.0
2018-12-19 16:30:00	AAPL	Stock	40.21	40.245	40.125	40.245	124036.0
2018-12-19 17:00:00	AAPL	Stock	40.245	40.2475	40.1625	40.1875	68512.0
2018-12-19 17:30:00	AAPL	Stock	40.1625	40.2225	40.0275	40.1075	4456236.0
2018-12-19 18:00:00	AAPL	Stock	40.1075	40.27	40.0	40.27	695704.0
2018-12-19 18:30:00	AAPL	Stock	40.25	40.29	40.175	40.245	62696.0
2018-12-19 19:00:00	AAPL	Stock	40.235	40.2725	40.1925	40.2475	45952.0
2018-12-19 19:30:00	AAPL	Stock	40.2125	40.3	40.2125	40.3	60796.0
2018-12-19 05:00:00	MSFT	Stock	104.24	104.36	104.24	104.35	610.0
2018-12-19 05:30:00	MSFT	Stock	104.58	104.75	104.51	104.75	5304.0
2018-12-19 06:00:00	MSFT	Stock	104.8	104.8	104.6	104.6	10319.0
2018-12-19 06:30:00	MSFT	Stock	104.74	104.74	104.74	104.74	300.0
2018-12-19 07:00:00	MSFT	Stock	104.55	104.83	104.51	104.75	8197.0
2018-12-19 07:30:00	MSFT	Stock	104.71	104.74	104.55	104.56	4654.0
2018-12-19 08:00:00	MSFT	Stock	104.67	104.8	104.12	104.25	34043.0
2018-12-19 08:30:00	MSFT	Stock	104.14	104.25	104.1	104.15	10810.0
2018-12-19 09:00:00	MSFT	Stock	104.1	104.26	103.51	103.65	35588.0
2018-12-19 09:30:00	MSFT	Stock	103.64	105.099	103.51	104.9	4478339.0
2018-12-19 10:00:00	MSFT	Stock	104.9	105.62	104.9	105.41	3133371.0
2018-12-19 10:30:00	MSFT	Stock	105.42	105.918	105.39	105.88	2162410.0
2018-12-19 11:00:00	MSFT	Stock	105.89	105.92	105.29	105.57	2029344.0
2018-12-19 11:30:00	MSFT	Stock	105.57	106.16	105.36	106.16	1581652.0
2018-12-19 12:00:00	MSFT	Stock	106.16	106.66	106.1	106.51	1552289.0
2018-12-19 12:30:00	MSFT	Stock	106.52	106.62	106.19	106.22	1293711.0
2018-12-19 13:00:00	MSFT	Stock	106.225	106.285	105.835	105.87	1655501.0
2018-12-19 13:30:00	MSFT	Stock	105.88	106.69	105.825	106.69	1601568.0

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

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