PREVIEW / stock_30min / 2019-07-18

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-18.parquet
  size:    1.7 MB
  rows:    84,024
  symbols: 2,583

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-07-18 04:00:00	AAPL	Stock	51.125	51.1725	51.0025	51.1	46280.0
2019-07-18 04:30:00	AAPL	Stock	51.11	51.115	51.1025	51.115	4608.0
2019-07-18 05:00:00	AAPL	Stock	51.075	51.15	51.075	51.15	6428.0
2019-07-18 05:30:00	AAPL	Stock	51.0875	51.0875	51.025	51.025	12440.0
2019-07-18 06:00:00	AAPL	Stock	50.975	51.0375	50.975	51.005	13148.0
2019-07-18 06:30:00	AAPL	Stock	51.025	51.0875	51.025	51.0625	14632.0
2019-07-18 07:00:00	AAPL	Stock	51.0625	51.1125	50.875	51.0125	149176.0
2019-07-18 07:30:00	AAPL	Stock	51.0125	51.025	50.95	50.975	32988.0
2019-07-18 08:00:00	AAPL	Stock	51.02	51.045	50.925	51.0	136028.0
2019-07-18 08:30:00	AAPL	Stock	51.02	51.095	51.005	51.015	173380.0
2019-07-18 09:00:00	AAPL	Stock	51.015	51.0225	50.925	51.0025	141680.0
2019-07-18 09:30:00	AAPL	Stock	51.0	51.445	50.925	51.305	12113684.0
2019-07-18 10:00:00	AAPL	Stock	51.31	51.3608	51.2175	51.245	5115476.0
2019-07-18 10:30:00	AAPL	Stock	51.2425	51.265	51.13	51.165	3559236.0
2019-07-18 11:00:00	AAPL	Stock	51.1625	51.1775	50.94	50.9975	3419076.0
2019-07-18 11:30:00	AAPL	Stock	50.9975	51.08	50.9718	51.0075	3168244.0
2019-07-18 12:00:00	AAPL	Stock	51.0112	51.1975	50.9775	51.15	2465452.0
2019-07-18 12:30:00	AAPL	Stock	51.16	51.2025	51.1075	51.1838	2219828.0
2019-07-18 13:00:00	AAPL	Stock	51.1825	51.25	51.175	51.215	2322776.0
2019-07-18 13:30:00	AAPL	Stock	51.215	51.24	51.155	51.195	2074704.0
2019-07-18 14:00:00	AAPL	Stock	51.2	51.3675	51.195	51.352	3283408.0
2019-07-18 14:30:00	AAPL	Stock	51.35	51.4025	51.3275	51.4025	3363532.0
2019-07-18 15:00:00	AAPL	Stock	51.4038	51.47	51.2675	51.3325	4169880.0
2019-07-18 15:30:00	AAPL	Stock	51.3345	51.42	51.2775	51.415	5498488.0
2019-07-18 16:00:00	AAPL	Stock	51.4138	51.4625	51.2588	51.43	5405980.0
2019-07-18 16:30:00	AAPL	Stock	51.43	51.4875	51.415	51.4875	167696.0
2019-07-18 17:00:00	AAPL	Stock	51.4825	51.485	51.415	51.465	211316.0
2019-07-18 17:30:00	AAPL	Stock	51.475	51.4925	51.455	51.4925	47200.0
2019-07-18 18:00:00	AAPL	Stock	51.4925	51.55	51.42	51.425	130732.0
2019-07-18 18:30:00	AAPL	Stock	51.43	51.4425	51.4	51.4	12524.0
2019-07-18 19:00:00	AAPL	Stock	51.4	51.4375	51.36	51.4375	32792.0
2019-07-18 19:30:00	AAPL	Stock	51.4375	51.495	51.4	51.4925	38304.0
2019-07-18 04:00:00	MSFT	Stock	136.03	136.03	135.68	135.68	4930.0
2019-07-18 04:30:00	MSFT	Stock	135.68	135.79	135.55	135.79	1865.0
2019-07-18 05:00:00	MSFT	Stock	135.9	135.97	135.81	135.81	1583.0
2019-07-18 05:30:00	MSFT	Stock	135.85	136.0	135.85	136.0	2000.0
2019-07-18 06:30:00	MSFT	Stock	135.85	136.09	135.85	136.09	5857.0
2019-07-18 07:00:00	MSFT	Stock	135.86	136.09	135.86	135.99	12234.0
2019-07-18 07:30:00	MSFT	Stock	136.15	136.15	135.95	136.0	14614.0
2019-07-18 08:00:00	MSFT	Stock	136.06	136.61	135.9	136.17	51832.0
2019-07-18 08:30:00	MSFT	Stock	136.17	136.32	136.06	136.1	24683.0
2019-07-18 09:00:00	MSFT	Stock	136.05	136.15	135.46	135.58	50324.0
2019-07-18 09:30:00	MSFT	Stock	135.55	136.23	134.75	135.94	2468110.0
2019-07-18 10:00:00	MSFT	Stock	135.945	136.45	135.75	136.04	1476336.0
2019-07-18 10:30:00	MSFT	Stock	136.04	136.23	135.75	135.8	1376942.0
2019-07-18 11:00:00	MSFT	Stock	135.79	135.83	135.28	135.39	1224187.0
2019-07-18 11:30:00	MSFT	Stock	135.38	135.39	134.67	135.01	1730515.0
2019-07-18 12:00:00	MSFT	Stock	135.01	135.18	134.93	135.02	1063677.0
2019-07-18 12:30:00	MSFT	Stock	135.02	135.32	134.96	135.045	972490.0
2019-07-18 13:00:00	MSFT	Stock	135.05	135.28	134.95	135.185	1133296.0

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

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