PREVIEW / stock_30min / 2019-10-01

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-01.parquet
  size:    1.7 MB
  rows:    83,526
  symbols: 2,505

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-10-01 04:00:00	AAPL	Stock	56.175	56.25	56.175	56.25	25952.0
2019-10-01 04:30:00	AAPL	Stock	56.31	56.3375	56.31	56.3375	3684.0
2019-10-01 05:00:00	AAPL	Stock	56.29	56.295	56.2325	56.245	12320.0
2019-10-01 05:30:00	AAPL	Stock	56.25	56.2525	56.25	56.25	6976.0
2019-10-01 06:00:00	AAPL	Stock	56.25	56.25	56.25	56.25	652.0
2019-10-01 06:30:00	AAPL	Stock	56.255	56.3425	56.25	56.2775	25228.0
2019-10-01 07:00:00	AAPL	Stock	56.25	56.3125	56.1725	56.24	190696.0
2019-10-01 07:30:00	AAPL	Stock	56.2375	56.355	56.2375	56.3325	138796.0
2019-10-01 08:00:00	AAPL	Stock	56.3	56.3725	55.855	56.315	334648.0
2019-10-01 08:30:00	AAPL	Stock	56.32	56.3975	56.3125	56.3125	303660.0
2019-10-01 09:00:00	AAPL	Stock	56.3125	56.325	56.225	56.2575	323112.0
2019-10-01 09:30:00	AAPL	Stock	56.2825	57.055	56.175	57.0175	23271560.0
2019-10-01 10:00:00	AAPL	Stock	57.0125	57.02	56.4598	56.6888	17234916.0
2019-10-01 10:30:00	AAPL	Stock	56.6875	56.7838	56.515	56.5475	8497352.0
2019-10-01 11:00:00	AAPL	Stock	56.545	56.91	56.49	56.91	6587312.0
2019-10-01 11:30:00	AAPL	Stock	56.91	56.915	56.5175	56.5675	5513416.0
2019-10-01 12:00:00	AAPL	Stock	56.565	56.57	56.335	56.3825	7025832.0
2019-10-01 12:30:00	AAPL	Stock	56.38	56.5525	56.3275	56.3475	4761484.0
2019-10-01 13:00:00	AAPL	Stock	56.34	56.38	56.16	56.2925	6383920.0
2019-10-01 13:30:00	AAPL	Stock	56.2975	56.3175	56.105	56.223	5329632.0
2019-10-01 14:00:00	AAPL	Stock	56.2212	56.32	56.1775	56.251	3374372.0
2019-10-01 14:30:00	AAPL	Stock	56.2525	56.435	56.2475	56.2875	4332308.0
2019-10-01 15:00:00	AAPL	Stock	56.2925	56.415	56.2025	56.305	4646140.0
2019-10-01 15:30:00	AAPL	Stock	56.3025	56.32	56.05	56.145	8897712.0
2019-10-01 16:00:00	AAPL	Stock	56.145	56.17	56.1	56.17	6153100.0
2019-10-01 16:30:00	AAPL	Stock	56.1125	56.25	56.105	56.25	56028.0
2019-10-01 17:00:00	AAPL	Stock	56.285	56.3	56.2125	56.2125	25304.0
2019-10-01 17:30:00	AAPL	Stock	56.285	56.285	56.1825	56.2725	13152.0
2019-10-01 18:00:00	AAPL	Stock	56.225	56.25	56.195	56.25	9888.0
2019-10-01 18:30:00	AAPL	Stock	56.2675	56.325	56.2675	56.3075	25908.0
2019-10-01 19:00:00	AAPL	Stock	56.325	56.325	56.2725	56.2875	23984.0
2019-10-01 19:30:00	AAPL	Stock	56.2875	56.3	56.25	56.2925	14452.0
2019-10-01 04:00:00	MSFT	Stock	139.5	139.5	139.5	139.5	300.0
2019-10-01 04:30:00	MSFT	Stock	139.7	139.79	139.7	139.79	500.0
2019-10-01 05:00:00	MSFT	Stock	139.77	139.77	139.75	139.75	739.0
2019-10-01 06:00:00	MSFT	Stock	139.55	139.55	139.55	139.55	469.0
2019-10-01 06:30:00	MSFT	Stock	139.6	139.63	139.56	139.56	500.0
2019-10-01 07:00:00	MSFT	Stock	139.52	139.57	139.4	139.5	7298.0
2019-10-01 07:30:00	MSFT	Stock	139.57	139.57	139.5	139.5	1926.0
2019-10-01 08:00:00	MSFT	Stock	139.57	139.59	139.37	139.45	7305.0
2019-10-01 08:30:00	MSFT	Stock	139.5	139.59	139.03	139.48	16908.0
2019-10-01 09:00:00	MSFT	Stock	139.48	139.7	139.46	139.7	26137.0
2019-10-01 09:30:00	MSFT	Stock	139.66	140.25	139.57	139.83	2352486.0
2019-10-01 10:00:00	MSFT	Stock	139.81	139.95	138.34	138.95	1864912.0
2019-10-01 10:30:00	MSFT	Stock	138.93	139.14	138.67	138.73	1185368.0
2019-10-01 11:00:00	MSFT	Stock	138.73	138.84	138.42	138.73	925334.0
2019-10-01 11:30:00	MSFT	Stock	138.74	138.83	138.21	138.34	830473.0
2019-10-01 12:00:00	MSFT	Stock	138.335	138.34	137.57	137.96	1112448.0
2019-10-01 12:30:00	MSFT	Stock	137.96	138.16	137.84	137.85	512731.0
2019-10-01 13:00:00	MSFT	Stock	137.84	137.89	137.53	137.545	706213.0

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

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