PREVIEW / stock_30min / 2019-01-23

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-23.parquet
  size:    1.7 MB
  rows:    82,472
  symbols: 2,678

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-01-23 04:30:00	AAPL	Stock	38.4475	38.4475	38.4475	38.4475	1312.0
2019-01-23 06:00:00	AAPL	Stock	38.435	38.4875	38.4	38.4	7100.0
2019-01-23 06:30:00	AAPL	Stock	38.425	38.5	38.425	38.5	11908.0
2019-01-23 07:00:00	AAPL	Stock	38.5	38.5875	38.4875	38.575	51020.0
2019-01-23 07:30:00	AAPL	Stock	38.575	38.5875	38.5075	38.5275	32736.0
2019-01-23 08:00:00	AAPL	Stock	38.5	38.595	38.5	38.5325	110920.0
2019-01-23 08:30:00	AAPL	Stock	38.515	38.56	38.4625	38.525	131216.0
2019-01-23 09:00:00	AAPL	Stock	38.5488	38.595	38.5025	38.53	121976.0
2019-01-23 09:30:00	AAPL	Stock	38.5375	38.785	38.465	38.6525	11419000.0
2019-01-23 10:00:00	AAPL	Stock	38.654	38.7475	38.44	38.4575	6183040.0
2019-01-23 10:30:00	AAPL	Stock	38.4625	38.535	38.3425	38.4188	5603448.0
2019-01-23 11:00:00	AAPL	Stock	38.4185	38.43	38.1575	38.225	5985832.0
2019-01-23 11:30:00	AAPL	Stock	38.225	38.29	38.01	38.0605	5841220.0
2019-01-23 12:00:00	AAPL	Stock	38.06	38.0975	37.925	38.065	5664180.0
2019-01-23 12:30:00	AAPL	Stock	38.0625	38.1975	38.0215	38.165	3513144.0
2019-01-23 13:00:00	AAPL	Stock	38.17	38.2475	38.0375	38.21	3474760.0
2019-01-23 13:30:00	AAPL	Stock	38.21	38.3275	38.2075	38.31	4071924.0
2019-01-23 14:00:00	AAPL	Stock	38.3175	38.4025	38.1823	38.3275	4643608.0
2019-01-23 14:30:00	AAPL	Stock	38.3275	38.3285	38.165	38.275	4759520.0
2019-01-23 15:00:00	AAPL	Stock	38.275	38.455	38.2575	38.44	5054024.0
2019-01-23 15:30:00	AAPL	Stock	38.4425	38.4925	38.3675	38.4925	7013836.0
2019-01-23 16:00:00	AAPL	Stock	38.4925	38.4925	38.43	38.485	8479604.0
2019-01-23 16:30:00	AAPL	Stock	38.455	38.5	38.425	38.4825	33500.0
2019-01-23 17:00:00	AAPL	Stock	38.4775	38.4775	38.425	38.425	11536.0
2019-01-23 17:30:00	AAPL	Stock	38.45	38.475	38.425	38.4375	13268.0
2019-01-23 18:00:00	AAPL	Stock	38.4475	38.4925	38.425	38.4925	15196.0
2019-01-23 18:30:00	AAPL	Stock	38.485	38.4875	38.3975	38.3975	17980.0
2019-01-23 19:00:00	AAPL	Stock	38.38	38.425	38.38	38.3875	3396.0
2019-01-23 19:30:00	AAPL	Stock	38.455	38.49	38.4375	38.49	21592.0
2019-01-23 05:00:00	MSFT	Stock	106.0	106.08	106.0	106.08	300.0
2019-01-23 05:30:00	MSFT	Stock	106.1	106.1	106.1	106.1	200.0
2019-01-23 06:00:00	MSFT	Stock	106.1	106.1	105.8	105.82	2297.0
2019-01-23 07:00:00	MSFT	Stock	106.16	106.45	106.1	106.44	9505.0
2019-01-23 07:30:00	MSFT	Stock	106.45	106.45	106.25	106.32	7317.0
2019-01-23 08:00:00	MSFT	Stock	106.05	106.49	106.0	106.23	38956.0
2019-01-23 08:30:00	MSFT	Stock	106.11	106.3	106.0	106.21	21709.0
2019-01-23 09:00:00	MSFT	Stock	106.21	106.37	106.05	106.1	24636.0
2019-01-23 09:30:00	MSFT	Stock	106.12	106.92	106.07	106.755	2981148.0
2019-01-23 10:00:00	MSFT	Stock	106.74	107.04	106.35	106.38	1992651.0
2019-01-23 10:30:00	MSFT	Stock	106.38	106.55	106.01	106.11	1214168.0
2019-01-23 11:00:00	MSFT	Stock	106.12	106.45	105.92	106.125	1664251.0
2019-01-23 11:30:00	MSFT	Stock	106.12	106.286	105.55	105.69	1314781.0
2019-01-23 12:00:00	MSFT	Stock	105.675	105.81	105.34	105.545	1253351.0
2019-01-23 12:30:00	MSFT	Stock	105.545	106.1	105.51	106.055	946915.0
2019-01-23 13:00:00	MSFT	Stock	106.064	106.14	105.76	105.96	818169.0
2019-01-23 13:30:00	MSFT	Stock	105.965	106.18	105.965	106.05	851112.0
2019-01-23 14:00:00	MSFT	Stock	106.06	106.38	105.88	106.11	991544.0
2019-01-23 14:30:00	MSFT	Stock	106.12	106.12	105.67	105.95	1073783.0
2019-01-23 15:00:00	MSFT	Stock	105.94	106.54	105.91	106.402	1200606.0
2019-01-23 15:30:00	MSFT	Stock	106.41	106.79	106.3	106.79	2919144.0

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

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