PREVIEW / stock_30min / 2019-12-09

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-09.parquet
  size:    1.7 MB
  rows:    84,947
  symbols: 2,490

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-12-09 04:00:00	AAPL	Stock	67.5025	67.5025	67.405	67.45	26628.0
2019-12-09 04:30:00	AAPL	Stock	67.4625	67.525	67.4625	67.525	6464.0
2019-12-09 05:00:00	AAPL	Stock	67.5575	67.5875	67.55	67.5875	8244.0
2019-12-09 05:30:00	AAPL	Stock	67.575	67.6	67.575	67.6	7844.0
2019-12-09 06:00:00	AAPL	Stock	67.5975	67.6	67.5125	67.525	24080.0
2019-12-09 06:30:00	AAPL	Stock	67.48	67.54	67.475	67.5	27192.0
2019-12-09 07:00:00	AAPL	Stock	67.5125	67.6	67.5025	67.5875	42536.0
2019-12-09 07:30:00	AAPL	Stock	67.5875	67.625	67.5	67.55	86468.0
2019-12-09 08:00:00	AAPL	Stock	67.5222	67.6375	67.475	67.5575	260124.0
2019-12-09 08:30:00	AAPL	Stock	67.5575	67.5575	67.49	67.555	140792.0
2019-12-09 09:00:00	AAPL	Stock	67.55	67.5625	67.495	67.52	192648.0
2019-12-09 09:30:00	AAPL	Stock	67.5175	67.7	67.2875	67.3975	12631912.0
2019-12-09 10:00:00	AAPL	Stock	67.3975	67.4725	67.29	67.4325	4128336.0
2019-12-09 10:30:00	AAPL	Stock	67.43	67.455	67.3025	67.405	3425844.0
2019-12-09 11:00:00	AAPL	Stock	67.405	67.4075	66.9572	67.0375	7693420.0
2019-12-09 11:30:00	AAPL	Stock	67.0362	67.045	66.485	66.56	12231860.0
2019-12-09 12:00:00	AAPL	Stock	66.56	66.625	66.2275	66.2975	15054952.0
2019-12-09 12:30:00	AAPL	Stock	66.2982	66.43	66.23	66.4205	9705196.0
2019-12-09 13:00:00	AAPL	Stock	66.4208	66.695	66.3975	66.6775	6764048.0
2019-12-09 13:30:00	AAPL	Stock	66.675	66.86	66.61	66.805	5898536.0
2019-12-09 14:00:00	AAPL	Stock	66.8037	66.8225	66.6075	66.7375	4176948.0
2019-12-09 14:30:00	AAPL	Stock	66.74	66.86	66.675	66.7992	3659548.0
2019-12-09 15:00:00	AAPL	Stock	66.8	66.89	66.7525	66.8482	4009480.0
2019-12-09 15:30:00	AAPL	Stock	66.85	66.8538	66.6525	66.73	7561036.0
2019-12-09 16:00:00	AAPL	Stock	66.73	66.7425	66.625	66.65	13174300.0
2019-12-09 16:30:00	AAPL	Stock	66.6475	66.73	66.5875	66.6125	156908.0
2019-12-09 17:00:00	AAPL	Stock	66.6175	66.73	66.6	66.625	893304.0
2019-12-09 17:30:00	AAPL	Stock	66.625	66.625	66.585	66.6125	27496.0
2019-12-09 18:00:00	AAPL	Stock	66.6125	66.66	66.605	66.605	51224.0
2019-12-09 18:30:00	AAPL	Stock	66.635	66.7125	66.635	66.645	30564.0
2019-12-09 19:00:00	AAPL	Stock	66.6675	66.68	66.645	66.6525	19952.0
2019-12-09 19:30:00	AAPL	Stock	66.64	66.7	66.64	66.7	23408.0
2019-12-09 04:00:00	MSFT	Stock	151.56	151.56	151.2	151.2	1115.0
2019-12-09 04:30:00	MSFT	Stock	151.23	151.25	151.2	151.2	2400.0
2019-12-09 05:00:00	MSFT	Stock	151.1	151.44	151.1	151.44	1140.0
2019-12-09 05:30:00	MSFT	Stock	151.37	151.37	151.37	151.37	100.0
2019-12-09 06:00:00	MSFT	Stock	151.38	151.45	151.38	151.45	402.0
2019-12-09 06:30:00	MSFT	Stock	151.3	151.3	151.3	151.3	600.0
2019-12-09 07:00:00	MSFT	Stock	151.3	151.36	151.2	151.3	6642.0
2019-12-09 07:30:00	MSFT	Stock	151.31	151.35	151.03	151.03	7291.0
2019-12-09 08:00:00	MSFT	Stock	151.25	151.4	150.95	150.95	28117.0
2019-12-09 08:30:00	MSFT	Stock	150.96	151.0	150.7	150.852	23335.0
2019-12-09 09:00:00	MSFT	Stock	150.93	151.13	150.82	151.12	12605.0
2019-12-09 09:30:00	MSFT	Stock	151.13	152.21	150.91	152.01	2121844.0
2019-12-09 10:00:00	MSFT	Stock	152.01	152.085	151.71	151.79	1033961.0
2019-12-09 10:30:00	MSFT	Stock	151.785	151.92	151.665	151.75	659257.0
2019-12-09 11:00:00	MSFT	Stock	151.75	151.75	151.42	151.6	729120.0
2019-12-09 11:30:00	MSFT	Stock	151.602	151.9	151.57	151.859	669448.0
2019-12-09 12:00:00	MSFT	Stock	151.855	152.09	151.79	151.85	560011.0
2019-12-09 12:30:00	MSFT	Stock	151.85	151.88	151.67	151.8	421645.0

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

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