PREVIEW / stock_30min / 2019-04-12

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-12.parquet
  size:    1.7 MB
  rows:    84,062
  symbols: 2,624

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-12 04:00:00	AAPL	Stock	49.82	50.0	49.82	50.0	2848.0
2019-04-12 05:00:00	AAPL	Stock	49.9975	50.025	49.9975	50.02	5596.0
2019-04-12 05:30:00	AAPL	Stock	50.0	50.0375	49.975	50.0375	11400.0
2019-04-12 06:00:00	AAPL	Stock	50.0	50.075	50.0	50.075	2972.0
2019-04-12 06:30:00	AAPL	Stock	50.075	50.075	49.5	49.7	122116.0
2019-04-12 07:00:00	AAPL	Stock	49.75	49.875	49.65	49.805	137036.0
2019-04-12 07:30:00	AAPL	Stock	49.8225	49.925	49.8225	49.86	90800.0
2019-04-12 08:00:00	AAPL	Stock	49.7498	49.995	49.6875	49.975	212872.0
2019-04-12 08:30:00	AAPL	Stock	49.9875	50.0325	49.9375	49.9525	289416.0
2019-04-12 09:00:00	AAPL	Stock	49.96	49.96	49.7775	49.8	488432.0
2019-04-12 09:30:00	AAPL	Stock	49.8075	50.035	49.755	49.955	12984464.0
2019-04-12 10:00:00	AAPL	Stock	49.9575	49.9725	49.465	49.6025	12309736.0
2019-04-12 10:30:00	AAPL	Stock	49.6075	49.65	49.1675	49.25	12376160.0
2019-04-12 11:00:00	AAPL	Stock	49.2525	49.325	49.0525	49.3212	8889380.0
2019-04-12 11:30:00	AAPL	Stock	49.32	49.425	49.26	49.421	5040008.0
2019-04-12 12:00:00	AAPL	Stock	49.42	49.4725	49.375	49.405	4545664.0
2019-04-12 12:30:00	AAPL	Stock	49.405	49.4925	49.39	49.45	3124724.0
2019-04-12 13:00:00	AAPL	Stock	49.45	49.475	49.42	49.459	2987316.0
2019-04-12 13:30:00	AAPL	Stock	49.46	49.615	49.44	49.5838	4490076.0
2019-04-12 14:00:00	AAPL	Stock	49.585	49.775	49.5725	49.7748	5210384.0
2019-04-12 14:30:00	AAPL	Stock	49.774	49.785	49.6275	49.6605	4584088.0
2019-04-12 15:00:00	AAPL	Stock	49.665	49.7425	49.65	49.737	3481632.0
2019-04-12 15:30:00	AAPL	Stock	49.735	49.7625	49.605	49.72	9682244.0
2019-04-12 16:00:00	AAPL	Stock	49.7225	49.75	49.5965	49.7	8851704.0
2019-04-12 16:30:00	AAPL	Stock	49.7025	49.7025	49.6875	49.6975	25556.0
2019-04-12 17:00:00	AAPL	Stock	49.6975	49.7175	49.6775	49.715	22888.0
2019-04-12 17:30:00	AAPL	Stock	49.6775	49.7	49.6775	49.6925	9084.0
2019-04-12 18:00:00	AAPL	Stock	49.7	49.725	49.6925	49.725	10388.0
2019-04-12 18:30:00	AAPL	Stock	49.725	49.735	49.72	49.735	19648.0
2019-04-12 19:00:00	AAPL	Stock	49.735	49.7375	49.715	49.73	10576.0
2019-04-12 19:30:00	AAPL	Stock	49.725	49.7575	49.725	49.7575	19792.0
2019-04-12 04:00:00	MSFT	Stock	120.5	120.75	120.5	120.75	400.0
2019-04-12 04:30:00	MSFT	Stock	121.0	121.0	120.99	120.99	348.0
2019-04-12 05:00:00	MSFT	Stock	121.0	121.0	120.99	120.99	348.0
2019-04-12 05:30:00	MSFT	Stock	120.99	120.99	120.95	120.98	952.0
2019-04-12 06:00:00	MSFT	Stock	120.9	121.0	120.9	120.99	994.0
2019-04-12 06:30:00	MSFT	Stock	121.0	121.17	121.0	121.17	3307.0
2019-04-12 07:00:00	MSFT	Stock	121.01	121.19	120.93	121.19	7895.0
2019-04-12 07:30:00	MSFT	Stock	121.09	121.09	121.0	121.0	6550.0
2019-04-12 08:00:00	MSFT	Stock	120.91	121.2	120.9	121.08	28804.0
2019-04-12 08:30:00	MSFT	Stock	121.08	121.15	120.932	120.932	15018.0
2019-04-12 09:00:00	MSFT	Stock	120.97	121.05	120.59	120.73	19629.0
2019-04-12 09:30:00	MSFT	Stock	120.76	120.98	120.37	120.625	2424945.0
2019-04-12 10:00:00	MSFT	Stock	120.625	120.92	120.41	120.875	1424718.0
2019-04-12 10:30:00	MSFT	Stock	120.875	120.9	120.55	120.65	1034406.0
2019-04-12 11:00:00	MSFT	Stock	120.66	120.66	120.39	120.55	778039.0
2019-04-12 11:30:00	MSFT	Stock	120.555	120.81	120.545	120.74	606928.0
2019-04-12 12:00:00	MSFT	Stock	120.74	120.77	120.61	120.645	721049.0
2019-04-12 12:30:00	MSFT	Stock	120.645	120.685	120.56	120.647	934126.0
2019-04-12 13:00:00	MSFT	Stock	120.645	120.68	120.52	120.56	717004.0

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

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