PREVIEW / stock_30min / 2019-04-15

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-15.parquet
  size:    1.7 MB
  rows:    83,180
  symbols: 2,631

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-04-15 04:00:00	AAPL	Stock	49.695	49.7	49.695	49.7	800.0
2019-04-15 04:30:00	AAPL	Stock	49.61	49.68	49.61	49.68	1708.0
2019-04-15 07:00:00	AAPL	Stock	49.68	49.7325	49.6625	49.6875	19868.0
2019-04-15 07:30:00	AAPL	Stock	49.665	49.665	49.5725	49.575	35400.0
2019-04-15 08:00:00	AAPL	Stock	49.7295	49.8425	49.5375	49.6575	86764.0
2019-04-15 08:30:00	AAPL	Stock	49.685	49.685	49.635	49.655	26540.0
2019-04-15 09:00:00	AAPL	Stock	49.65	49.6775	49.6	49.6475	69276.0
2019-04-15 09:30:00	AAPL	Stock	49.645	49.9625	49.6275	49.76	10975824.0
2019-04-15 10:00:00	AAPL	Stock	49.76	49.7862	49.665	49.685	5086436.0
2019-04-15 10:30:00	AAPL	Stock	49.685	49.694	49.5025	49.651	4826124.0
2019-04-15 11:00:00	AAPL	Stock	49.65	49.74	49.625	49.72	2822460.0
2019-04-15 11:30:00	AAPL	Stock	49.72	49.845	49.65	49.6545	4514652.0
2019-04-15 12:00:00	AAPL	Stock	49.65	49.6825	49.625	49.6625	2563740.0
2019-04-15 12:30:00	AAPL	Stock	49.665	49.7125	49.625	49.68	2099140.0
2019-04-15 13:00:00	AAPL	Stock	49.6775	49.745	49.6725	49.7175	1994136.0
2019-04-15 13:30:00	AAPL	Stock	49.715	49.7525	49.705	49.715	1910696.0
2019-04-15 14:00:00	AAPL	Stock	49.715	49.79	49.71	49.745	2250796.0
2019-04-15 14:30:00	AAPL	Stock	49.7425	49.7825	49.7025	49.7775	2653332.0
2019-04-15 15:00:00	AAPL	Stock	49.7775	49.8325	49.7675	49.8115	2977512.0
2019-04-15 15:30:00	AAPL	Stock	49.8103	49.825	49.725	49.8075	5855100.0
2019-04-15 16:00:00	AAPL	Stock	49.8075	49.8075	49.755	49.795	10385872.0
2019-04-15 16:30:00	AAPL	Stock	49.776	49.8075	49.7752	49.7752	29748.0
2019-04-15 17:00:00	AAPL	Stock	49.775	49.7875	49.7625	49.7625	17840.0
2019-04-15 17:30:00	AAPL	Stock	49.7575	49.7575	49.7575	49.7575	800.0
2019-04-15 18:00:00	AAPL	Stock	49.7725	49.795	49.7575	49.795	8664.0
2019-04-15 18:30:00	AAPL	Stock	49.7875	49.795	49.7875	49.795	2072.0
2019-04-15 19:00:00	AAPL	Stock	49.8	49.8075	49.8	49.8075	8936.0
2019-04-15 19:30:00	AAPL	Stock	49.8075	49.8375	49.8075	49.825	21588.0
2019-04-15 06:30:00	MSFT	Stock	121.2	121.2	121.11	121.11	1300.0
2019-04-15 07:00:00	MSFT	Stock	121.07	121.07	120.98	121.07	4279.0
2019-04-15 07:30:00	MSFT	Stock	121.1	121.1	121.0	121.0	1375.0
2019-04-15 08:00:00	MSFT	Stock	121.132	121.132	120.93	120.98	2253.0
2019-04-15 08:30:00	MSFT	Stock	121.0	121.07	120.96	120.98	5784.0
2019-04-15 09:00:00	MSFT	Stock	120.98	121.07	120.96	120.96	9485.0
2019-04-15 09:30:00	MSFT	Stock	120.94	121.58	120.81	121.32	1947437.0
2019-04-15 10:00:00	MSFT	Stock	121.32	121.35	120.75	120.76	959698.0
2019-04-15 10:30:00	MSFT	Stock	120.76	120.914	120.57	120.85	925395.0
2019-04-15 11:00:00	MSFT	Stock	120.85	121.06	120.81	121.06	796970.0
2019-04-15 11:30:00	MSFT	Stock	121.06	121.065	120.73	120.92	606687.0
2019-04-15 12:00:00	MSFT	Stock	120.925	120.95	120.75	120.765	507960.0
2019-04-15 12:30:00	MSFT	Stock	120.77	120.915	120.765	120.825	519098.0
2019-04-15 13:00:00	MSFT	Stock	120.825	120.995	120.78	120.837	529608.0
2019-04-15 13:30:00	MSFT	Stock	120.834	120.97	120.81	120.945	526631.0
2019-04-15 14:00:00	MSFT	Stock	120.94	121.06	120.93	121.0	715488.0
2019-04-15 14:30:00	MSFT	Stock	121.01	121.14	120.98	121.104	875157.0
2019-04-15 15:00:00	MSFT	Stock	121.11	121.26	121.06	121.16	772574.0
2019-04-15 15:30:00	MSFT	Stock	121.15	121.21	121.02	121.06	1433970.0
2019-04-15 16:00:00	MSFT	Stock	121.05	121.1	120.94	120.94	2334745.0
2019-04-15 16:30:00	MSFT	Stock	121.05	121.06	120.91	120.91	2665.0
2019-04-15 17:00:00	MSFT	Stock	121.05	121.08	121.0	121.08	2294.0

> showing 50 of 83,180 rows — these rows as CSV

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