PREVIEW / stock_30min / 2019-11-18

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-18.parquet
  size:    1.7 MB
  rows:    85,572
  symbols: 2,522

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-11-18 04:00:00	AAPL	Stock	66.525	66.5625	66.525	66.5625	7740.0
2019-11-18 04:30:00	AAPL	Stock	66.6	66.675	66.5825	66.625	12544.0
2019-11-18 05:00:00	AAPL	Stock	66.6	66.635	66.6	66.6	3200.0
2019-11-18 05:30:00	AAPL	Stock	66.5775	66.595	66.5625	66.5625	5800.0
2019-11-18 06:00:00	AAPL	Stock	66.5875	66.5875	66.5575	66.5575	4800.0
2019-11-18 06:30:00	AAPL	Stock	66.55	66.625	66.55	66.625	22792.0
2019-11-18 07:00:00	AAPL	Stock	66.625	66.725	66.625	66.725	110708.0
2019-11-18 07:30:00	AAPL	Stock	66.7125	66.8	66.7025	66.79	127980.0
2019-11-18 08:00:00	AAPL	Stock	66.6725	66.81	66.505	66.505	699032.0
2019-11-18 08:30:00	AAPL	Stock	66.5	66.595	66.42	66.55	446756.0
2019-11-18 09:00:00	AAPL	Stock	66.555	66.5725	66.4125	66.4475	210844.0
2019-11-18 09:30:00	AAPL	Stock	66.4475	66.5475	66.0575	66.1525	12302996.0
2019-11-18 10:00:00	AAPL	Stock	66.15	66.4225	66.14	66.2325	6542664.0
2019-11-18 10:30:00	AAPL	Stock	66.2308	66.3825	66.2025	66.31	3337516.0
2019-11-18 11:00:00	AAPL	Stock	66.3105	66.4275	66.285	66.3675	3569508.0
2019-11-18 11:30:00	AAPL	Stock	66.37	66.52	66.3675	66.4975	3792456.0
2019-11-18 12:00:00	AAPL	Stock	66.4925	66.5	66.3775	66.395	2107988.0
2019-11-18 12:30:00	AAPL	Stock	66.3932	66.6225	66.3625	66.5875	3430192.0
2019-11-18 13:00:00	AAPL	Stock	66.5888	66.6835	66.5425	66.675	2840360.0
2019-11-18 13:30:00	AAPL	Stock	66.6775	66.7475	66.6625	66.7085	3411268.0
2019-11-18 14:00:00	AAPL	Stock	66.7125	66.7875	66.64	66.7375	3551172.0
2019-11-18 14:30:00	AAPL	Stock	66.7365	66.8575	66.731	66.799	3596012.0
2019-11-18 15:00:00	AAPL	Stock	66.7988	66.8175	66.65	66.7432	3987564.0
2019-11-18 15:30:00	AAPL	Stock	66.7425	66.79	66.6712	66.78	7056916.0
2019-11-18 16:00:00	AAPL	Stock	66.775	66.8	66.73	66.8	10160716.0
2019-11-18 16:30:00	AAPL	Stock	66.81	66.945	66.775	66.9	138320.0
2019-11-18 17:00:00	AAPL	Stock	66.9125	66.9125	66.7925	66.825	123428.0
2019-11-18 17:30:00	AAPL	Stock	66.8275	66.835	66.8025	66.8125	25196.0
2019-11-18 18:00:00	AAPL	Stock	66.8125	66.825	66.78	66.78	29656.0
2019-11-18 18:30:00	AAPL	Stock	66.8	66.82	66.7875	66.82	5176.0
2019-11-18 19:00:00	AAPL	Stock	66.795	66.8	66.765	66.8	13148.0
2019-11-18 19:30:00	AAPL	Stock	66.7975	66.7975	66.685	66.75	53568.0
2019-11-18 04:00:00	MSFT	Stock	150.0	150.4	150.0	150.3	1190.0
2019-11-18 04:30:00	MSFT	Stock	150.43	150.69	150.4	150.4	842.0
2019-11-18 05:00:00	MSFT	Stock	150.4	150.44	150.32	150.44	5824.0
2019-11-18 05:30:00	MSFT	Stock	150.36	150.4	150.26	150.26	5599.0
2019-11-18 06:00:00	MSFT	Stock	150.28	150.37	150.28	150.37	2591.0
2019-11-18 06:30:00	MSFT	Stock	150.38	150.45	150.35	150.36	2667.0
2019-11-18 07:00:00	MSFT	Stock	150.4	150.44	150.2	150.3	26931.0
2019-11-18 07:30:00	MSFT	Stock	150.41	150.43	150.3	150.43	7917.0
2019-11-18 08:00:00	MSFT	Stock	150.35	150.45	149.94	149.94	78555.0
2019-11-18 08:30:00	MSFT	Stock	150.01	150.12	149.9	149.96	22620.0
2019-11-18 09:00:00	MSFT	Stock	150.0	150.07	149.92	149.96	36550.0
2019-11-18 09:30:00	MSFT	Stock	150.06	150.16	149.15	149.3	2517563.0
2019-11-18 10:00:00	MSFT	Stock	149.3	149.425	149.06	149.16	1229324.0
2019-11-18 10:30:00	MSFT	Stock	149.155	149.53	148.98	149.44	1477535.0
2019-11-18 11:00:00	MSFT	Stock	149.44	149.48	149.19	149.25	1047261.0
2019-11-18 11:30:00	MSFT	Stock	149.245	149.86	149.19	149.86	1131129.0
2019-11-18 12:00:00	MSFT	Stock	149.855	150.04	149.66	149.678	906348.0
2019-11-18 12:30:00	MSFT	Stock	149.672	149.74	149.59	149.726	397494.0

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

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