PREVIEW / stock_30min / 2019-11-27

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-27.parquet
  size:    1.7 MB
  rows:    84,567
  symbols: 2,477

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-27 04:00:00	AAPL	Stock	66.375	66.425	66.375	66.425	6892.0
2019-11-27 04:30:00	AAPL	Stock	66.45	66.45	66.4	66.45	26004.0
2019-11-27 05:00:00	AAPL	Stock	66.45	66.45	66.4	66.4	10412.0
2019-11-27 05:30:00	AAPL	Stock	66.4	66.4625	66.4	66.4575	5668.0
2019-11-27 06:00:00	AAPL	Stock	66.425	66.425	66.4125	66.4125	10480.0
2019-11-27 06:30:00	AAPL	Stock	66.35	66.35	66.3125	66.3125	8268.0
2019-11-27 07:00:00	AAPL	Stock	66.29	66.31	66.25	66.2625	45084.0
2019-11-27 07:30:00	AAPL	Stock	66.2625	66.335	66.255	66.325	24188.0
2019-11-27 08:00:00	AAPL	Stock	66.3	66.345	66.275	66.3175	86784.0
2019-11-27 08:30:00	AAPL	Stock	66.325	66.4075	66.2725	66.2725	129468.0
2019-11-27 09:00:00	AAPL	Stock	66.275	66.4575	66.25	66.4025	278396.0
2019-11-27 09:30:00	AAPL	Stock	66.4075	66.5675	66.3275	66.5375	8777116.0
2019-11-27 10:00:00	AAPL	Stock	66.5375	66.5375	66.355	66.4988	4515736.0
2019-11-27 10:30:00	AAPL	Stock	66.5	66.5975	66.4375	66.5525	4289972.0
2019-11-27 11:00:00	AAPL	Stock	66.545	66.65	66.545	66.6305	2886116.0
2019-11-27 11:30:00	AAPL	Stock	66.6325	66.6425	66.5375	66.6072	2033692.0
2019-11-27 12:00:00	AAPL	Stock	66.605	66.6775	66.585	66.6375	2327632.0
2019-11-27 12:30:00	AAPL	Stock	66.6395	66.6625	66.5825	66.5925	1584260.0
2019-11-27 13:00:00	AAPL	Stock	66.5925	66.6425	66.58	66.635	1750020.0
2019-11-27 13:30:00	AAPL	Stock	66.635	66.735	66.6272	66.695	2500264.0
2019-11-27 14:00:00	AAPL	Stock	66.6908	66.7525	66.67	66.735	2481440.0
2019-11-27 14:30:00	AAPL	Stock	66.7325	66.7775	66.7	66.75	2716776.0
2019-11-27 15:00:00	AAPL	Stock	66.7525	66.8	66.7025	66.7838	2652404.0
2019-11-27 15:30:00	AAPL	Stock	66.785	66.995	66.77	66.975	7472180.0
2019-11-27 16:00:00	AAPL	Stock	66.96	66.9925	66.8875	66.9625	5709472.0
2019-11-27 16:30:00	AAPL	Stock	66.9625	66.9875	66.96	66.9775	148768.0
2019-11-27 17:00:00	AAPL	Stock	66.9775	66.985	66.97	66.97	9644.0
2019-11-27 17:30:00	AAPL	Stock	66.97	66.98	66.9375	66.96	18252.0
2019-11-27 18:00:00	AAPL	Stock	66.975	66.975	66.75	66.7875	154744.0
2019-11-27 18:30:00	AAPL	Stock	66.775	66.8	66.725	66.775	90732.0
2019-11-27 19:00:00	AAPL	Stock	66.7825	66.8	66.7375	66.7375	36192.0
2019-11-27 19:30:00	AAPL	Stock	66.7375	66.7375	66.6375	66.675	70252.0
2019-11-27 04:00:00	MSFT	Stock	152.61	152.61	152.61	152.61	100.0
2019-11-27 04:30:00	MSFT	Stock	152.71	152.71	152.71	152.71	280.0
2019-11-27 05:00:00	MSFT	Stock	152.65	152.71	152.65	152.71	300.0
2019-11-27 06:00:00	MSFT	Stock	152.75	152.75	152.67	152.67	600.0
2019-11-27 06:30:00	MSFT	Stock	152.54	152.54	152.5	152.5	1344.0
2019-11-27 07:00:00	MSFT	Stock	152.5	152.57	152.48	152.49	4099.0
2019-11-27 07:30:00	MSFT	Stock	152.48	152.55	152.45	152.55	2212.0
2019-11-27 08:00:00	MSFT	Stock	152.58	152.59	152.5	152.5	9520.0
2019-11-27 08:30:00	MSFT	Stock	152.48	152.66	152.47	152.47	19743.0
2019-11-27 09:00:00	MSFT	Stock	152.497	152.57	152.26	152.3	12662.0
2019-11-27 09:30:00	MSFT	Stock	152.35	152.5	151.61	151.7	2064323.0
2019-11-27 10:00:00	MSFT	Stock	151.695	152.01	151.52	151.96	1119672.0
2019-11-27 10:30:00	MSFT	Stock	151.97	152.27	151.92	152.08	833479.0
2019-11-27 11:00:00	MSFT	Stock	152.09	152.27	152.0	152.21	596808.0
2019-11-27 11:30:00	MSFT	Stock	152.21	152.35	152.1	152.294	554461.0
2019-11-27 12:00:00	MSFT	Stock	152.293	152.33	152.18	152.2	483933.0
2019-11-27 12:30:00	MSFT	Stock	152.195	152.27	152.134	152.175	417387.0
2019-11-27 13:00:00	MSFT	Stock	152.175	152.285	152.05	152.055	610566.0

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

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