PREVIEW / stock_30min / 2018-12-31

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-31.parquet
  size:    1.8 MB
  rows:    87,503
  symbols: 2,761

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-31 04:00:00	AAPL	Stock	39.32	39.39	39.32	39.375	3200.0
2018-12-31 04:30:00	AAPL	Stock	39.3525	39.47	39.3525	39.47	1616.0
2018-12-31 05:00:00	AAPL	Stock	39.455	39.455	39.455	39.455	800.0
2018-12-31 05:30:00	AAPL	Stock	39.4375	39.4375	39.4375	39.4375	3848.0
2018-12-31 06:00:00	AAPL	Stock	39.4125	39.495	39.4125	39.495	5060.0
2018-12-31 06:30:00	AAPL	Stock	39.49	39.495	39.49	39.495	800.0
2018-12-31 07:00:00	AAPL	Stock	39.5	39.6925	39.4875	39.625	84156.0
2018-12-31 07:30:00	AAPL	Stock	39.595	39.66	39.5275	39.6125	61020.0
2018-12-31 08:00:00	AAPL	Stock	39.4838	39.6975	39.0575	39.545	845160.0
2018-12-31 08:30:00	AAPL	Stock	39.51	39.5125	39.455	39.4875	160304.0
2018-12-31 09:00:00	AAPL	Stock	39.4975	39.6775	39.48	39.6275	254076.0
2018-12-31 09:30:00	AAPL	Stock	39.625	39.84	39.37	39.4825	16568708.0
2018-12-31 10:00:00	AAPL	Stock	39.48	39.56	39.22	39.365	10380680.0
2018-12-31 10:30:00	AAPL	Stock	39.3675	39.4	39.1275	39.265	8683460.0
2018-12-31 11:00:00	AAPL	Stock	39.2648	39.425	39.2275	39.39	8529628.0
2018-12-31 11:30:00	AAPL	Stock	39.38	39.5425	39.2475	39.49	7934504.0
2018-12-31 12:00:00	AAPL	Stock	39.4975	39.645	39.435	39.6317	7093708.0
2018-12-31 12:30:00	AAPL	Stock	39.6305	39.735	39.5425	39.5925	5422204.0
2018-12-31 13:00:00	AAPL	Stock	39.595	39.62	39.5225	39.6	4591844.0
2018-12-31 13:30:00	AAPL	Stock	39.6	39.61	39.359	39.3925	4933548.0
2018-12-31 14:00:00	AAPL	Stock	39.395	39.455	39.2625	39.2725	6337580.0
2018-12-31 14:30:00	AAPL	Stock	39.2675	39.435	39.2125	39.3425	5490684.0
2018-12-31 15:00:00	AAPL	Stock	39.34	39.4225	39.225	39.2505	6084856.0
2018-12-31 15:30:00	AAPL	Stock	39.25	39.4875	39.12	39.485	13608036.0
2018-12-31 16:00:00	AAPL	Stock	39.4825	39.4825	39.35	39.4175	14436580.0
2018-12-31 16:30:00	AAPL	Stock	39.435	39.4625	39.42	39.4425	51036.0
2018-12-31 17:00:00	AAPL	Stock	39.4375	39.53	39.4375	39.5225	134380.0
2018-12-31 17:30:00	AAPL	Stock	39.525	39.525	39.47	39.525	32140.0
2018-12-31 18:00:00	AAPL	Stock	39.5125	39.5225	39.435	39.5075	1896784.0
2018-12-31 18:30:00	AAPL	Stock	39.5025	39.5025	39.4775	39.4875	16288.0
2018-12-31 19:00:00	AAPL	Stock	39.48	39.5125	39.4775	39.4925	27948.0
2018-12-31 19:30:00	AAPL	Stock	39.4925	39.545	39.4825	39.545	26600.0
2018-12-31 07:00:00	MSFT	Stock	101.1	101.85	101.1	101.5	9245.0
2018-12-31 07:30:00	MSFT	Stock	101.6	101.73	101.41	101.73	12080.0
2018-12-31 08:00:00	MSFT	Stock	101.59	101.77	100.39	101.45	275741.0
2018-12-31 08:30:00	MSFT	Stock	101.37	101.43	101.13	101.26	15140.0
2018-12-31 09:00:00	MSFT	Stock	101.26	101.49	101.1	101.39	29050.0
2018-12-31 09:30:00	MSFT	Stock	101.45	101.68	100.67	100.963	2504789.0
2018-12-31 10:00:00	MSFT	Stock	100.966	101.371	100.78	101.358	1816715.0
2018-12-31 10:30:00	MSFT	Stock	101.36	101.465	100.85	101.405	2044316.0
2018-12-31 11:00:00	MSFT	Stock	101.405	101.64	101.075	101.24	1866581.0
2018-12-31 11:30:00	MSFT	Stock	101.23	101.53	100.86	101.46	1535380.0
2018-12-31 12:00:00	MSFT	Stock	101.46	101.59	101.1	101.57	1237756.0
2018-12-31 12:30:00	MSFT	Stock	101.56	101.96	101.54	101.86	1126871.0
2018-12-31 13:00:00	MSFT	Stock	101.86	102.4	101.69	102.399	1502387.0
2018-12-31 13:30:00	MSFT	Stock	102.39	102.4	101.44	101.51	1239564.0
2018-12-31 14:00:00	MSFT	Stock	101.507	101.6	101.02	101.1	1427148.0
2018-12-31 14:30:00	MSFT	Stock	101.1	101.68	100.94	101.39	1206621.0
2018-12-31 15:00:00	MSFT	Stock	101.39	101.645	101.12	101.23	1434895.0
2018-12-31 15:30:00	MSFT	Stock	101.23	101.67	100.44	101.66	4375597.0

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

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