PREVIEW / stock_30min / 2019-12-03

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-03.parquet
  size:    1.8 MB
  rows:    86,472
  symbols: 2,481

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-12-03 04:00:00	AAPL	Stock	66.2475	66.25	66.1	66.1	15112.0
2019-12-03 04:30:00	AAPL	Stock	66.095	66.095	66.0375	66.0375	11800.0
2019-12-03 05:00:00	AAPL	Stock	66.02	66.0225	65.435	65.435	72660.0
2019-12-03 05:30:00	AAPL	Stock	65.495	65.5825	65.475	65.5025	51276.0
2019-12-03 06:00:00	AAPL	Stock	65.5025	65.5625	65.4975	65.5625	18500.0
2019-12-03 06:30:00	AAPL	Stock	65.575	65.67	65.575	65.65	14516.0
2019-12-03 07:00:00	AAPL	Stock	65.635	65.6875	65.4325	65.5025	163612.0
2019-12-03 07:30:00	AAPL	Stock	65.5225	65.5275	65.165	65.1825	229644.0
2019-12-03 08:00:00	AAPL	Stock	65.525	65.6375	64.75	64.895	610676.0
2019-12-03 08:30:00	AAPL	Stock	64.875	64.9025	64.6575	64.6825	631544.0
2019-12-03 09:00:00	AAPL	Stock	64.6925	64.81	64.53	64.565	736804.0
2019-12-03 09:30:00	AAPL	Stock	64.5625	64.6245	64.0725	64.44	23699620.0
2019-12-03 10:00:00	AAPL	Stock	64.44	64.6125	64.2275	64.4825	10047388.0
2019-12-03 10:30:00	AAPL	Stock	64.485	64.5275	64.2025	64.2475	7431344.0
2019-12-03 11:00:00	AAPL	Stock	64.2525	64.44	64.12	64.235	6106500.0
2019-12-03 11:30:00	AAPL	Stock	64.2325	64.485	64.185	64.395	4871900.0
2019-12-03 12:00:00	AAPL	Stock	64.393	64.5725	64.29	64.4962	4756348.0
2019-12-03 12:30:00	AAPL	Stock	64.4975	64.5225	64.41	64.4925	2900588.0
2019-12-03 13:00:00	AAPL	Stock	64.495	64.665	64.4775	64.6425	3877872.0
2019-12-03 13:30:00	AAPL	Stock	64.6425	64.8298	64.6075	64.639	5536504.0
2019-12-03 14:00:00	AAPL	Stock	64.6382	64.7375	64.465	64.55	3802444.0
2019-12-03 14:30:00	AAPL	Stock	64.5475	64.6388	64.525	64.61	2744968.0
2019-12-03 15:00:00	AAPL	Stock	64.62	64.7977	64.565	64.765	3781596.0
2019-12-03 15:30:00	AAPL	Stock	64.7625	64.8825	64.5925	64.88	7887592.0
2019-12-03 16:00:00	AAPL	Stock	64.8625	64.95	64.8175	64.95	9623992.0
2019-12-03 16:30:00	AAPL	Stock	64.9375	64.9475	64.8498	64.9375	188864.0
2019-12-03 17:00:00	AAPL	Stock	64.9375	64.9375	64.9	64.9125	28732.0
2019-12-03 17:30:00	AAPL	Stock	64.9125	64.94	64.8975	64.925	42224.0
2019-12-03 18:00:00	AAPL	Stock	64.9125	64.9725	64.9	64.9725	36540.0
2019-12-03 18:30:00	AAPL	Stock	64.9575	64.9725	64.9425	64.97	7232.0
2019-12-03 19:00:00	AAPL	Stock	64.96	64.98	64.82	64.875	50852.0
2019-12-03 19:30:00	AAPL	Stock	64.8725	64.875	64.6925	64.7725	71804.0
2019-12-03 04:00:00	MSFT	Stock	149.53	149.93	149.53	149.93	619.0
2019-12-03 04:30:00	MSFT	Stock	149.82	149.82	149.54	149.68	4550.0
2019-12-03 05:00:00	MSFT	Stock	149.8	149.8	148.71	148.87	6082.0
2019-12-03 05:30:00	MSFT	Stock	148.9	148.94	148.71	148.79	2009.0
2019-12-03 06:00:00	MSFT	Stock	148.74	148.82	148.67	148.67	1341.0
2019-12-03 06:30:00	MSFT	Stock	148.8	148.98	148.8	148.98	237.0
2019-12-03 07:00:00	MSFT	Stock	148.89	148.91	148.5	148.6	34003.0
2019-12-03 07:30:00	MSFT	Stock	148.6	148.65	147.91	148.1	26017.0
2019-12-03 08:00:00	MSFT	Stock	148.7	149.92	147.63	148.06	48526.0
2019-12-03 08:30:00	MSFT	Stock	148.0	148.0	147.4	147.48	54970.0
2019-12-03 09:00:00	MSFT	Stock	147.46	147.75	147.02	147.39	59759.0
2019-12-03 09:30:00	MSFT	Stock	147.48	147.963	146.65	147.8	3586778.0
2019-12-03 10:00:00	MSFT	Stock	147.81	148.27	147.39	147.99	1689705.0
2019-12-03 10:30:00	MSFT	Stock	147.98	148.41	147.63	147.93	1579682.0
2019-12-03 11:00:00	MSFT	Stock	147.96	148.199	147.77	147.82	1146009.0
2019-12-03 11:30:00	MSFT	Stock	147.83	148.23	147.77	148.205	851214.0
2019-12-03 12:00:00	MSFT	Stock	148.21	148.4	147.95	148.24	758677.0
2019-12-03 12:30:00	MSFT	Stock	148.247	148.29	148.07	148.26	614690.0

> showing 50 of 86,472 rows — these rows as CSV

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