PREVIEW / stock_30min / 2019-01-31

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-31.parquet
  size:    1.7 MB
  rows:    86,073
  symbols: 2,689

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-31 04:00:00	AAPL	Stock	41.5875	41.6025	41.5	41.5125	56392.0
2019-01-31 04:30:00	AAPL	Stock	41.5625	41.66	41.5625	41.66	27192.0
2019-01-31 05:00:00	AAPL	Stock	41.6025	41.6025	41.4825	41.4825	47888.0
2019-01-31 05:30:00	AAPL	Stock	41.45	41.5125	41.45	41.5	26580.0
2019-01-31 06:00:00	AAPL	Stock	41.5	41.5425	41.5	41.5375	4288.0
2019-01-31 06:30:00	AAPL	Stock	41.6	41.6	41.6	41.6	3200.0
2019-01-31 07:00:00	AAPL	Stock	41.5475	41.6375	41.525	41.625	93156.0
2019-01-31 07:30:00	AAPL	Stock	41.6325	41.6625	41.575	41.625	202296.0
2019-01-31 08:00:00	AAPL	Stock	41.55	41.675	41.525	41.5625	305684.0
2019-01-31 08:30:00	AAPL	Stock	41.565	41.6	41.535	41.5675	216204.0
2019-01-31 09:00:00	AAPL	Stock	41.565	41.5875	41.475	41.5525	297696.0
2019-01-31 09:30:00	AAPL	Stock	41.53	41.67	41.14	41.635	16993416.0
2019-01-31 10:00:00	AAPL	Stock	41.64	42.0225	41.545	41.9988	14350640.0
2019-01-31 10:30:00	AAPL	Stock	42.0	42.18	41.98	42.07	14975848.0
2019-01-31 11:00:00	AAPL	Stock	42.07	42.1625	41.9275	42.0	8260588.0
2019-01-31 11:30:00	AAPL	Stock	42.0	42.25	41.99	42.221	8181900.0
2019-01-31 12:00:00	AAPL	Stock	42.22	42.2275	41.9675	42.0495	6925648.0
2019-01-31 12:30:00	AAPL	Stock	42.05	42.0632	41.88	41.9435	5536040.0
2019-01-31 13:00:00	AAPL	Stock	41.9408	41.9425	41.755	41.775	5143800.0
2019-01-31 13:30:00	AAPL	Stock	41.773	41.865	41.7	41.859	6047008.0
2019-01-31 14:00:00	AAPL	Stock	41.8575	41.885	41.72	41.755	5468520.0
2019-01-31 14:30:00	AAPL	Stock	41.7525	41.765	41.6395	41.68	4737168.0
2019-01-31 15:00:00	AAPL	Stock	41.685	41.745	41.56	41.7172	6118152.0
2019-01-31 15:30:00	AAPL	Stock	41.7175	41.7325	41.545	41.5675	11733600.0
2019-01-31 16:00:00	AAPL	Stock	41.61	41.725	41.55	41.55	24912344.0
2019-01-31 16:30:00	AAPL	Stock	41.5875	41.725	41.57	41.7225	155216.0
2019-01-31 17:00:00	AAPL	Stock	41.7225	41.725	41.625	41.6875	95780.0
2019-01-31 17:30:00	AAPL	Stock	41.6575	41.685	41.605	41.6125	93088.0
2019-01-31 18:00:00	AAPL	Stock	41.655	41.685	41.625	41.685	106940.0
2019-01-31 18:30:00	AAPL	Stock	41.655	41.675	41.63	41.63	69108.0
2019-01-31 19:00:00	AAPL	Stock	41.63	41.7225	41.625	41.7025	102700.0
2019-01-31 19:30:00	AAPL	Stock	41.725	41.7475	41.7	41.7425	30644.0
2019-01-31 04:00:00	MSFT	Stock	103.63	104.25	103.63	104.18	5178.0
2019-01-31 04:30:00	MSFT	Stock	104.06	104.38	104.03	104.38	4510.0
2019-01-31 05:00:00	MSFT	Stock	104.22	104.22	103.9	103.9	10102.0
2019-01-31 05:30:00	MSFT	Stock	104.0	104.48	103.91	104.25	1818.0
2019-01-31 06:00:00	MSFT	Stock	104.12	104.12	104.12	104.12	100.0
2019-01-31 06:30:00	MSFT	Stock	104.44	104.44	104.11	104.18	3449.0
2019-01-31 07:00:00	MSFT	Stock	104.21	104.4	104.1	104.3	39726.0
2019-01-31 07:30:00	MSFT	Stock	104.2	104.2	103.5	103.89	70090.0
2019-01-31 08:00:00	MSFT	Stock	104.11	104.33	103.51	103.51	140066.0
2019-01-31 08:30:00	MSFT	Stock	103.51	103.72	103.26	103.36	303719.0
2019-01-31 09:00:00	MSFT	Stock	103.36	103.85	102.9	103.78	156430.0
2019-01-31 09:30:00	MSFT	Stock	103.8	105.08	103.51	104.095	9546474.0
2019-01-31 10:00:00	MSFT	Stock	104.095	104.23	103.18	104.095	5570264.0
2019-01-31 10:30:00	MSFT	Stock	104.09	104.48	103.71	103.86	3279286.0
2019-01-31 11:00:00	MSFT	Stock	103.865	104.09	103.79	103.86	2128209.0
2019-01-31 11:30:00	MSFT	Stock	103.865	104.93	103.76	104.814	2396738.0
2019-01-31 12:00:00	MSFT	Stock	104.815	105.21	104.46	104.555	2513361.0
2019-01-31 12:30:00	MSFT	Stock	104.56	104.98	104.2	104.97	1971513.0

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

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