PREVIEW / stock_30min / 2018-11-20

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-20.parquet
  size:    1.7 MB
  rows:    84,815
  symbols: 2,765

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-11-20 04:00:00	AAPL	Stock	45.75	45.92	45.7	45.825	123984.0
2018-11-20 04:30:00	AAPL	Stock	45.76	45.935	45.76	45.8125	73256.0
2018-11-20 05:00:00	AAPL	Stock	45.7825	45.8775	45.755	45.845	28760.0
2018-11-20 05:30:00	AAPL	Stock	45.8125	45.8425	45.7125	45.7125	34816.0
2018-11-20 06:00:00	AAPL	Stock	45.71	45.845	45.695	45.73	63248.0
2018-11-20 06:30:00	AAPL	Stock	45.7	45.88	45.7	45.88	39008.0
2018-11-20 07:00:00	AAPL	Stock	45.8225	45.875	45.4775	45.5025	419076.0
2018-11-20 07:30:00	AAPL	Stock	45.52	45.5275	45.175	45.175	598188.0
2018-11-20 08:00:00	AAPL	Stock	45.1875	45.715	45.1125	45.25	1004644.0
2018-11-20 08:30:00	AAPL	Stock	45.25	45.2825	44.725	44.745	1504116.0
2018-11-20 09:00:00	AAPL	Stock	44.745	44.86	44.5025	44.5875	2014804.0
2018-11-20 09:30:00	AAPL	Stock	44.5925	45.2875	43.8775	44.7675	51887504.0
2018-11-20 10:00:00	AAPL	Stock	44.7625	44.8775	44.1625	44.5725	29668440.0
2018-11-20 10:30:00	AAPL	Stock	44.5635	45.2425	44.425	45.1287	21998572.0
2018-11-20 11:00:00	AAPL	Stock	45.1292	45.3	44.75	44.785	12890844.0
2018-11-20 11:30:00	AAPL	Stock	44.7875	45.2475	44.7275	45.1675	9660080.0
2018-11-20 12:00:00	AAPL	Stock	45.1675	45.3675	44.9675	45.2475	8309880.0
2018-11-20 12:30:00	AAPL	Stock	45.2425	45.36	44.72	44.7425	8273920.0
2018-11-20 13:00:00	AAPL	Stock	44.7375	44.8252	44.45	44.6275	8210780.0
2018-11-20 13:30:00	AAPL	Stock	44.625	44.7525	44.4825	44.49	5993128.0
2018-11-20 14:00:00	AAPL	Stock	44.49	44.525	44.25	44.295	9314308.0
2018-11-20 14:30:00	AAPL	Stock	44.295	44.5375	44.2	44.269	9761008.0
2018-11-20 15:00:00	AAPL	Stock	44.2675	44.3375	43.9625	44.1515	16281488.0
2018-11-20 15:30:00	AAPL	Stock	44.1525	44.2925	43.965	44.235	21627104.0
2018-11-20 16:00:00	AAPL	Stock	44.24	44.25	44.075	44.21	12525332.0
2018-11-20 16:30:00	AAPL	Stock	44.1925	44.245	44.125	44.175	2902144.0
2018-11-20 17:00:00	AAPL	Stock	44.175	44.245	44.1375	44.1625	105756.0
2018-11-20 17:30:00	AAPL	Stock	44.16	44.195	44.0775	44.165	61232.0
2018-11-20 18:00:00	AAPL	Stock	44.1625	44.1625	44.0625	44.0975	159536.0
2018-11-20 18:30:00	AAPL	Stock	44.0825	44.0925	44.025	44.0725	59156.0
2018-11-20 19:00:00	AAPL	Stock	44.0875	44.1925	44.0	44.1925	111132.0
2018-11-20 19:30:00	AAPL	Stock	44.2125	44.3125	44.2	44.25	120644.0
2018-11-20 04:00:00	MSFT	Stock	103.59	103.65	103.0	103.02	4163.0
2018-11-20 04:30:00	MSFT	Stock	103.5	103.59	103.21	103.35	4120.0
2018-11-20 05:00:00	MSFT	Stock	103.22	103.31	103.2	103.23	3055.0
2018-11-20 05:30:00	MSFT	Stock	103.26	103.26	103.24	103.24	900.0
2018-11-20 06:00:00	MSFT	Stock	103.22	103.25	103.2	103.2	2945.0
2018-11-20 06:30:00	MSFT	Stock	103.19	103.73	103.0	103.73	7036.0
2018-11-20 07:00:00	MSFT	Stock	103.6	103.6	103.07	103.07	50727.0
2018-11-20 07:30:00	MSFT	Stock	103.19	103.35	102.63	102.8	43533.0
2018-11-20 08:00:00	MSFT	Stock	102.802	103.73	102.35	102.58	119822.0
2018-11-20 08:30:00	MSFT	Stock	102.5	102.76	101.7	101.87	97739.0
2018-11-20 09:00:00	MSFT	Stock	101.95	102.49	101.06	101.77	176970.0
2018-11-20 09:30:00	MSFT	Stock	101.76	102.65	100.71	101.055	9204584.0
2018-11-20 10:00:00	MSFT	Stock	101.06	101.36	99.353	100.922	8319275.0
2018-11-20 10:30:00	MSFT	Stock	100.92	102.51	100.56	102.41	4861306.0
2018-11-20 11:00:00	MSFT	Stock	102.41	102.97	101.73	101.95	2792214.0
2018-11-20 11:30:00	MSFT	Stock	101.95	102.74	101.74	102.22	2283228.0
2018-11-20 12:00:00	MSFT	Stock	102.236	102.7	101.91	102.56	1960044.0
2018-11-20 12:30:00	MSFT	Stock	102.54	102.78	101.92	101.966	1536024.0

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

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