PREVIEW / stock_30min / 2019-11-26

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-26.parquet
  size:    1.8 MB
  rows:    86,251
  symbols: 2,500

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-11-26 04:00:00	AAPL	Stock	66.5125	66.5125	66.5125	66.5125	800.0
2019-11-26 04:30:00	AAPL	Stock	66.5425	66.55	66.5	66.55	3448.0
2019-11-26 05:00:00	AAPL	Stock	66.565	66.565	66.5375	66.55	8140.0
2019-11-26 05:30:00	AAPL	Stock	66.55	66.55	66.55	66.55	400.0
2019-11-26 06:00:00	AAPL	Stock	66.565	66.565	66.565	66.565	2000.0
2019-11-26 06:30:00	AAPL	Stock	66.6	66.65	66.5975	66.615	23556.0
2019-11-26 07:00:00	AAPL	Stock	66.625	66.6925	66.6125	66.69	75204.0
2019-11-26 07:30:00	AAPL	Stock	66.7125	66.73	66.6525	66.6875	62728.0
2019-11-26 08:00:00	AAPL	Stock	66.6875	66.7725	66.6	66.675	179880.0
2019-11-26 08:30:00	AAPL	Stock	66.6625	66.7625	66.6625	66.7025	162720.0
2019-11-26 09:00:00	AAPL	Stock	66.7025	66.75	66.6375	66.7325	133216.0
2019-11-26 09:30:00	AAPL	Stock	66.7325	66.79	66.3085	66.505	9725860.0
2019-11-26 10:00:00	AAPL	Stock	66.5125	66.59	66.39	66.5	4415220.0
2019-11-26 10:30:00	AAPL	Stock	66.4945	66.6225	66.375	66.5878	5154496.0
2019-11-26 11:00:00	AAPL	Stock	66.59	66.6025	66.4712	66.5	2419536.0
2019-11-26 11:30:00	AAPL	Stock	66.5	66.64	66.4325	66.6038	2674368.0
2019-11-26 12:00:00	AAPL	Stock	66.6028	66.635	66.5387	66.6075	1989988.0
2019-11-26 12:30:00	AAPL	Stock	66.6075	66.675	66.58	66.65	2005076.0
2019-11-26 13:00:00	AAPL	Stock	66.6575	66.6975	66.6175	66.65	1713564.0
2019-11-26 13:30:00	AAPL	Stock	66.65	66.6562	66.57	66.605	1896240.0
2019-11-26 14:00:00	AAPL	Stock	66.61	66.6575	66.58	66.5938	1596064.0
2019-11-26 14:30:00	AAPL	Stock	66.5975	66.6438	66.5325	66.6125	1861352.0
2019-11-26 15:00:00	AAPL	Stock	66.6125	66.64	66.5725	66.5725	2169188.0
2019-11-26 15:30:00	AAPL	Stock	66.575	66.6762	65.625	66.025	12203560.0
2019-11-26 16:00:00	AAPL	Stock	66.0325	66.3	66.0325	66.1925	31072852.0
2019-11-26 16:30:00	AAPL	Stock	66.1925	66.2125	66.0725	66.2025	496332.0
2019-11-26 17:00:00	AAPL	Stock	66.2	66.2375	66.0725	66.235	631828.0
2019-11-26 17:30:00	AAPL	Stock	66.235	66.2475	66.23	66.2475	27444.0
2019-11-26 18:00:00	AAPL	Stock	66.24	66.25	66.0725	66.25	79868.0
2019-11-26 18:30:00	AAPL	Stock	66.2175	66.2475	66.215	66.2475	8432.0
2019-11-26 19:00:00	AAPL	Stock	66.24	66.25	66.2075	66.25	24684.0
2019-11-26 19:30:00	AAPL	Stock	66.2175	66.23	66.1875	66.19	16688.0
2019-11-26 04:00:00	MSFT	Stock	151.43	151.43	151.3	151.38	300.0
2019-11-26 06:00:00	MSFT	Stock	151.19	151.19	151.1	151.1	447.0
2019-11-26 06:30:00	MSFT	Stock	151.39	151.39	151.39	151.39	100.0
2019-11-26 07:00:00	MSFT	Stock	151.35	151.43	151.3	151.43	579.0
2019-11-26 07:30:00	MSFT	Stock	151.4	151.4	151.37	151.37	2679.0
2019-11-26 08:00:00	MSFT	Stock	151.33	151.46	151.3	151.3	11195.0
2019-11-26 08:30:00	MSFT	Stock	151.32	151.36	151.272	151.33	6340.0
2019-11-26 09:00:00	MSFT	Stock	151.32	151.45	151.25	151.37	9667.0
2019-11-26 09:30:00	MSFT	Stock	151.37	152.197	151.32	151.94	2369689.0
2019-11-26 10:00:00	MSFT	Stock	151.95	152.14	151.75	152.01	1089934.0
2019-11-26 10:30:00	MSFT	Stock	152.015	152.115	151.875	151.99	855510.0
2019-11-26 11:00:00	MSFT	Stock	151.99	152.185	151.96	152.06	613348.0
2019-11-26 11:30:00	MSFT	Stock	152.06	152.11	151.87	151.98	662877.0
2019-11-26 12:00:00	MSFT	Stock	151.98	152.095	151.96	152.02	479036.0
2019-11-26 12:30:00	MSFT	Stock	152.01	152.1	151.93	152.044	430334.0
2019-11-26 13:00:00	MSFT	Stock	152.05	152.17	152.0	152.01	409760.0
2019-11-26 13:30:00	MSFT	Stock	152.01	152.015	151.905	151.975	399030.0
2019-11-26 14:00:00	MSFT	Stock	151.99	152.02	151.94	151.963	399259.0

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

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