PREVIEW / stock_30min / 2020-01-08

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-08.parquet
  size:    1.8 MB
  rows:    87,816
  symbols: 2,474

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
2020-01-08 04:00:00	AAPL	Stock	74.125	74.345	74.125	74.2475	89240.0
2020-01-08 04:30:00	AAPL	Stock	74.2625	74.3125	74.1725	74.3	24092.0
2020-01-08 05:00:00	AAPL	Stock	74.25	74.5	74.25	74.45	36464.0
2020-01-08 05:30:00	AAPL	Stock	74.475	74.5	74.45	74.5	10004.0
2020-01-08 06:00:00	AAPL	Stock	74.5625	74.6325	74.5	74.6325	32132.0
2020-01-08 06:30:00	AAPL	Stock	74.6625	74.6875	74.5675	74.5925	54124.0
2020-01-08 07:00:00	AAPL	Stock	74.54	74.59	74.4	74.5125	225780.0
2020-01-08 07:30:00	AAPL	Stock	74.485	74.635	74.485	74.6175	144428.0
2020-01-08 08:00:00	AAPL	Stock	74.425	74.7825	74.3875	74.67	503204.0
2020-01-08 08:30:00	AAPL	Stock	74.6975	74.7	74.4375	74.525	220552.0
2020-01-08 09:00:00	AAPL	Stock	74.5447	74.575	74.2325	74.2925	456020.0
2020-01-08 09:30:00	AAPL	Stock	74.29	74.775	74.289	74.5925	12964364.0
2020-01-08 10:00:00	AAPL	Stock	74.595	74.69	74.4875	74.6175	5855048.0
2020-01-08 10:30:00	AAPL	Stock	74.6175	74.665	74.3425	74.4325	5293740.0
2020-01-08 11:00:00	AAPL	Stock	74.4325	74.8725	74.375	74.7175	5803088.0
2020-01-08 11:30:00	AAPL	Stock	74.7185	75.0525	74.6025	75.0225	11542404.0
2020-01-08 12:00:00	AAPL	Stock	75.0225	75.61	75.02	75.5972	10521740.0
2020-01-08 12:30:00	AAPL	Stock	75.5995	75.76	75.3825	75.6577	9728220.0
2020-01-08 13:00:00	AAPL	Stock	75.6612	75.7775	75.6	75.7302	5108812.0
2020-01-08 13:30:00	AAPL	Stock	75.7328	75.8075	75.6225	75.6508	4500484.0
2020-01-08 14:00:00	AAPL	Stock	75.65	75.755	75.6325	75.6612	3053260.0
2020-01-08 14:30:00	AAPL	Stock	75.6625	75.7725	75.6325	75.7675	3572468.0
2020-01-08 15:00:00	AAPL	Stock	75.7675	76.075	75.755	76.025	8284676.0
2020-01-08 15:30:00	AAPL	Stock	76.0275	76.11	75.56	75.7875	14606832.0
2020-01-08 16:00:00	AAPL	Stock	75.7975	75.905	75.615	75.7975	9693244.0
2020-01-08 16:30:00	AAPL	Stock	75.8125	75.9225	75.7875	75.865	173484.0
2020-01-08 17:00:00	AAPL	Stock	75.8675	75.895	75.825	75.8675	50444.0
2020-01-08 17:30:00	AAPL	Stock	75.83	75.85	75.82	75.835	18064.0
2020-01-08 18:00:00	AAPL	Stock	75.84	75.97	75.83	75.9675	104492.0
2020-01-08 18:30:00	AAPL	Stock	75.9475	75.95	75.825	75.9125	46280.0
2020-01-08 19:00:00	AAPL	Stock	75.925	75.9875	75.9	75.9	67980.0
2020-01-08 19:30:00	AAPL	Stock	75.9225	76.0	75.9	75.9975	79116.0
2020-01-08 04:00:00	MSFT	Stock	156.62	157.47	156.62	157.19	28674.0
2020-01-08 04:30:00	MSFT	Stock	157.2	157.3	157.0	157.3	8139.0
2020-01-08 05:00:00	MSFT	Stock	157.3	157.59	157.3	157.59	3270.0
2020-01-08 05:30:00	MSFT	Stock	157.52	158.05	157.39	157.88	10283.0
2020-01-08 06:00:00	MSFT	Stock	157.89	158.26	157.75	158.26	4239.0
2020-01-08 06:30:00	MSFT	Stock	158.0	158.07	157.83	157.83	5447.0
2020-01-08 07:00:00	MSFT	Stock	157.83	158.29	157.6	158.1	77412.0
2020-01-08 07:30:00	MSFT	Stock	158.1	158.64	158.08	158.64	49874.0
2020-01-08 08:00:00	MSFT	Stock	157.7	159.06	157.58	159.06	148362.0
2020-01-08 08:30:00	MSFT	Stock	159.06	159.16	158.61	158.842	50392.0
2020-01-08 09:00:00	MSFT	Stock	158.8	158.94	158.52	158.94	65836.0
2020-01-08 09:30:00	MSFT	Stock	158.93	158.99	157.949	158.6	2812247.0
2020-01-08 10:00:00	MSFT	Stock	158.61	159.23	158.51	158.988	1555532.0
2020-01-08 10:30:00	MSFT	Stock	158.98	159.29	158.8	159.18	1271316.0
2020-01-08 11:00:00	MSFT	Stock	159.18	159.68	158.88	159.42	1439745.0
2020-01-08 11:30:00	MSFT	Stock	159.43	160.18	159.16	159.835	2216411.0
2020-01-08 12:00:00	MSFT	Stock	159.84	160.01	159.77	159.916	1100026.0
2020-01-08 12:30:00	MSFT	Stock	159.92	160.05	159.85	159.895	949099.0

> showing 50 of 87,816 rows — these rows as CSV

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