PREVIEW / stock_30min / 2019-09-18

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-18.parquet
  size:    1.7 MB
  rows:    85,379
  symbols: 2,552

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-09-18 04:00:00	AAPL	Stock	55.25	55.25	55.25	55.25	7852.0
2019-09-18 04:30:00	AAPL	Stock	55.2	55.25	55.2	55.25	7932.0
2019-09-18 05:00:00	AAPL	Stock	55.2	55.23	55.2	55.23	1792.0
2019-09-18 05:30:00	AAPL	Stock	55.1875	55.2325	55.1875	55.2325	4000.0
2019-09-18 06:00:00	AAPL	Stock	55.225	55.225	55.1175	55.1475	11676.0
2019-09-18 06:30:00	AAPL	Stock	55.175	55.205	55.175	55.175	2376.0
2019-09-18 07:00:00	AAPL	Stock	55.2	55.245	55.12	55.15	46428.0
2019-09-18 07:30:00	AAPL	Stock	55.1725	55.215	55.0125	55.125	71896.0
2019-09-18 08:00:00	AAPL	Stock	55.175	55.245	55.1125	55.22	75416.0
2019-09-18 08:30:00	AAPL	Stock	55.2375	55.3375	55.2375	55.3125	132340.0
2019-09-18 09:00:00	AAPL	Stock	55.32	55.35	55.255	55.2625	134572.0
2019-09-18 09:30:00	AAPL	Stock	55.2825	55.5275	55.17	55.465	12173464.0
2019-09-18 10:00:00	AAPL	Stock	55.4648	55.61	55.46	55.5788	7278156.0
2019-09-18 10:30:00	AAPL	Stock	55.58	55.63	55.48	55.5425	4383420.0
2019-09-18 11:00:00	AAPL	Stock	55.5425	55.575	55.48	55.49	2744588.0
2019-09-18 11:30:00	AAPL	Stock	55.4875	55.5225	55.4275	55.4675	2495072.0
2019-09-18 12:00:00	AAPL	Stock	55.465	55.495	55.3475	55.3925	2366732.0
2019-09-18 12:30:00	AAPL	Stock	55.3925	55.4125	55.2875	55.295	3109372.0
2019-09-18 13:00:00	AAPL	Stock	55.295	55.2975	55.16	55.197	3336728.0
2019-09-18 13:30:00	AAPL	Stock	55.2	55.3308	55.1475	55.3008	2940536.0
2019-09-18 14:00:00	AAPL	Stock	55.306	55.4575	54.86	54.973	10878404.0
2019-09-18 14:30:00	AAPL	Stock	54.9775	55.22	54.9125	55.2	7532068.0
2019-09-18 15:00:00	AAPL	Stock	55.2	55.5475	55.175	55.51	6468584.0
2019-09-18 15:30:00	AAPL	Stock	55.505	55.7125	55.49	55.6925	11679200.0
2019-09-18 16:00:00	AAPL	Stock	55.6925	55.72	55.4022	55.7	7221124.0
2019-09-18 16:30:00	AAPL	Stock	55.7	55.75	55.6925	55.7375	111404.0
2019-09-18 17:00:00	AAPL	Stock	55.73	55.7425	55.7	55.7125	19320.0
2019-09-18 17:30:00	AAPL	Stock	55.7125	55.735	55.7025	55.705	10168.0
2019-09-18 18:00:00	AAPL	Stock	55.7075	55.7125	55.6775	55.695	32620.0
2019-09-18 18:30:00	AAPL	Stock	55.69	55.705	55.66	55.6875	45648.0
2019-09-18 19:00:00	AAPL	Stock	55.675	55.6825	55.6425	55.65	19704.0
2019-09-18 19:30:00	AAPL	Stock	55.6375	55.655	55.575	55.59	30520.0
2019-09-18 07:00:00	MSFT	Stock	137.37	137.44	137.25	137.44	1522.0
2019-09-18 07:30:00	MSFT	Stock	137.26	137.29	137.06	137.15	7688.0
2019-09-18 08:00:00	MSFT	Stock	137.3	137.73	137.1	137.22	7580.0
2019-09-18 08:30:00	MSFT	Stock	137.25	137.32	137.25	137.32	7109.0
2019-09-18 09:00:00	MSFT	Stock	137.27	137.37	137.23	137.32	8060.0
2019-09-18 09:30:00	MSFT	Stock	137.43	137.43	136.585	137.304	1643846.0
2019-09-18 10:00:00	MSFT	Stock	137.3	137.59	137.13	137.48	905177.0
2019-09-18 10:30:00	MSFT	Stock	137.49	137.81	137.42	137.805	872910.0
2019-09-18 11:00:00	MSFT	Stock	137.8	137.95	137.6	137.855	660493.0
2019-09-18 11:30:00	MSFT	Stock	137.86	138.07	137.705	137.78	786508.0
2019-09-18 12:00:00	MSFT	Stock	137.78	138.17	137.74	138.04	754698.0
2019-09-18 12:30:00	MSFT	Stock	138.05	138.1	137.72	137.73	649131.0
2019-09-18 13:00:00	MSFT	Stock	137.74	137.76	137.38	137.45	535880.0
2019-09-18 13:30:00	MSFT	Stock	137.45	137.77	137.42	137.766	642217.0
2019-09-18 14:00:00	MSFT	Stock	137.78	138.05	136.774	136.94	2624050.0
2019-09-18 14:30:00	MSFT	Stock	136.93	137.26	136.53	137.13	1419666.0
2019-09-18 15:00:00	MSFT	Stock	137.12	137.74	136.9	137.67	1198215.0
2019-09-18 15:30:00	MSFT	Stock	137.68	138.67	137.675	138.53	2787961.0

> showing 50 of 85,379 rows — these rows as CSV

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