PREVIEW / stock_30min / 2019-08-22

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-22.parquet
  size:    1.7 MB
  rows:    83,053
  symbols: 2,557

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-08-22 04:00:00	AAPL	Stock	53.3175	53.3175	53.2	53.2	3272.0
2019-08-22 04:30:00	AAPL	Stock	53.085	53.1125	53.085	53.11	1512.0
2019-08-22 05:00:00	AAPL	Stock	53.1075	53.1075	52.9025	52.9025	27176.0
2019-08-22 05:30:00	AAPL	Stock	52.925	52.995	52.885	52.95	9604.0
2019-08-22 06:00:00	AAPL	Stock	52.9975	53.05	52.9775	53.025	8808.0
2019-08-22 06:30:00	AAPL	Stock	53.015	53.05	53.005	53.01	14440.0
2019-08-22 07:00:00	AAPL	Stock	53.0475	53.2125	53.0	53.195	71340.0
2019-08-22 07:30:00	AAPL	Stock	53.1875	53.3	53.1525	53.2625	51404.0
2019-08-22 08:00:00	AAPL	Stock	53.295	53.3	53.0	53.27	168908.0
2019-08-22 08:30:00	AAPL	Stock	53.2625	53.36	53.2025	53.3225	115336.0
2019-08-22 09:00:00	AAPL	Stock	53.2875	53.325	53.2225	53.3	139540.0
2019-08-22 09:30:00	AAPL	Stock	53.2975	53.6088	53.2525	53.56	11505420.0
2019-08-22 10:00:00	AAPL	Stock	53.57	53.58	53.1825	53.23	6322824.0
2019-08-22 10:30:00	AAPL	Stock	53.2275	53.2275	52.7525	52.7875	8591988.0
2019-08-22 11:00:00	AAPL	Stock	52.79	53.03	52.6875	52.915	6765564.0
2019-08-22 11:30:00	AAPL	Stock	52.9175	53.15	52.885	53.0178	4603080.0
2019-08-22 12:00:00	AAPL	Stock	53.02	53.1575	53.0075	53.0938	2508420.0
2019-08-22 12:30:00	AAPL	Stock	53.0925	53.15	53.015	53.0675	2212040.0
2019-08-22 13:00:00	AAPL	Stock	53.065	53.245	53.0525	53.2225	2680896.0
2019-08-22 13:30:00	AAPL	Stock	53.2238	53.2825	53.1775	53.185	2762336.0
2019-08-22 14:00:00	AAPL	Stock	53.1875	53.215	53.0925	53.1125	2425968.0
2019-08-22 14:30:00	AAPL	Stock	53.1125	53.21	53.0822	53.1912	3324996.0
2019-08-22 15:00:00	AAPL	Stock	53.195	53.2088	53.0675	53.12	2857236.0
2019-08-22 15:30:00	AAPL	Stock	53.1175	53.325	53.06	53.1125	10027612.0
2019-08-22 16:00:00	AAPL	Stock	53.115	53.185	53.06	53.135	8894388.0
2019-08-22 16:30:00	AAPL	Stock	53.115	53.1225	53.0625	53.0875	47292.0
2019-08-22 17:00:00	AAPL	Stock	53.0875	53.0875	53.025	53.075	39480.0
2019-08-22 17:30:00	AAPL	Stock	53.0625	53.0625	53.03	53.03	31632.0
2019-08-22 18:00:00	AAPL	Stock	53.0475	53.1125	53.035	53.1125	15096.0
2019-08-22 18:30:00	AAPL	Stock	53.1125	53.1125	53.065	53.0925	12080.0
2019-08-22 19:00:00	AAPL	Stock	53.0875	53.0925	53.055	53.055	10772.0
2019-08-22 19:30:00	AAPL	Stock	53.03	53.09	53.0075	53.09	18116.0
2019-08-22 05:00:00	MSFT	Stock	138.3	138.4	137.89	137.99	1335.0
2019-08-22 05:30:00	MSFT	Stock	138.0	138.0	137.9	137.95	429.0
2019-08-22 07:00:00	MSFT	Stock	138.39	138.78	138.21	138.78	4395.0
2019-08-22 07:30:00	MSFT	Stock	138.6	139.2	138.56	139.07	4284.0
2019-08-22 08:00:00	MSFT	Stock	138.6	139.19	138.2	138.86	7187.0
2019-08-22 08:30:00	MSFT	Stock	138.94	139.3	138.85	139.08	7059.0
2019-08-22 09:00:00	MSFT	Stock	139.09	139.2	138.6	138.7	18164.0
2019-08-22 09:30:00	MSFT	Stock	138.71	139.2	138.52	138.88	1771866.0
2019-08-22 10:00:00	MSFT	Stock	138.886	138.9	137.72	137.76	1231618.0
2019-08-22 10:30:00	MSFT	Stock	137.755	137.755	136.29	136.404	1986151.0
2019-08-22 11:00:00	MSFT	Stock	136.42	137.1	136.315	136.7	1152535.0
2019-08-22 11:30:00	MSFT	Stock	136.71	136.99	136.58	136.67	733701.0
2019-08-22 12:00:00	MSFT	Stock	136.67	137.05	136.62	136.93	595152.0
2019-08-22 12:30:00	MSFT	Stock	136.93	137.235	136.81	137.086	693608.0
2019-08-22 13:00:00	MSFT	Stock	137.082	137.59	137.082	137.45	623983.0
2019-08-22 13:30:00	MSFT	Stock	137.47	137.5	137.245	137.47	594278.0
2019-08-22 14:00:00	MSFT	Stock	137.48	137.59	137.22	137.32	661605.0
2019-08-22 14:30:00	MSFT	Stock	137.33	137.78	137.31	137.74	741340.0

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

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