PREVIEW / stock_30min / 2019-06-28

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-28.parquet
  size:    1.7 MB
  rows:    86,327
  symbols: 2,617

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-06-28 04:00:00	AAPL	Stock	49.65	49.69	49.4375	49.55	11688.0
2019-06-28 04:30:00	AAPL	Stock	49.5775	49.5775	49.4375	49.5	5784.0
2019-06-28 05:00:00	AAPL	Stock	49.5	49.5	49.4675	49.4675	4088.0
2019-06-28 05:30:00	AAPL	Stock	49.48	49.48	49.48	49.48	1080.0
2019-06-28 06:00:00	AAPL	Stock	49.5225	49.5225	49.475	49.475	4840.0
2019-06-28 06:30:00	AAPL	Stock	49.5	49.515	49.5	49.51	2000.0
2019-06-28 07:00:00	AAPL	Stock	49.5	49.6875	49.475	49.5525	83324.0
2019-06-28 07:30:00	AAPL	Stock	49.6125	49.6375	49.575	49.6375	43272.0
2019-06-28 08:00:00	AAPL	Stock	49.525	49.72	49.515	49.5575	209968.0
2019-06-28 08:30:00	AAPL	Stock	49.5625	49.705	49.5375	49.6625	187028.0
2019-06-28 09:00:00	AAPL	Stock	49.6625	49.75	49.6225	49.6675	221192.0
2019-06-28 09:30:00	AAPL	Stock	49.68	49.8738	49.3125	49.335	11079620.0
2019-06-28 10:00:00	AAPL	Stock	49.335	49.48	49.2625	49.47	5482608.0
2019-06-28 10:30:00	AAPL	Stock	49.4725	49.575	49.3725	49.555	4068824.0
2019-06-28 11:00:00	AAPL	Stock	49.555	49.555	49.455	49.4925	2800304.0
2019-06-28 11:30:00	AAPL	Stock	49.4925	49.6835	49.4775	49.66	3359024.0
2019-06-28 12:00:00	AAPL	Stock	49.66	49.8325	49.6525	49.785	3783672.0
2019-06-28 12:30:00	AAPL	Stock	49.785	49.85	49.7325	49.735	3473516.0
2019-06-28 13:00:00	AAPL	Stock	49.74	49.745	49.5675	49.5752	2868064.0
2019-06-28 13:30:00	AAPL	Stock	49.5775	49.595	49.475	49.5115	2908420.0
2019-06-28 14:00:00	AAPL	Stock	49.5125	49.564	49.4775	49.5412	2805084.0
2019-06-28 14:30:00	AAPL	Stock	49.5425	49.5575	49.29	49.3225	4914180.0
2019-06-28 15:00:00	AAPL	Stock	49.3237	49.37	49.28	49.3425	5234248.0
2019-06-28 15:30:00	AAPL	Stock	49.3412	49.5225	49.3025	49.48	13733720.0
2019-06-28 16:00:00	AAPL	Stock	49.49	49.625	49.385	49.515	32080276.0
2019-06-28 16:30:00	AAPL	Stock	49.5225	49.5725	49.48	49.5	240952.0
2019-06-28 17:00:00	AAPL	Stock	49.5175	49.5225	49.4825	49.495	28220.0
2019-06-28 17:30:00	AAPL	Stock	49.495	49.5225	49.4875	49.5225	10432.0
2019-06-28 18:00:00	AAPL	Stock	49.5	49.5375	49.5	49.5375	22600.0
2019-06-28 18:30:00	AAPL	Stock	49.56	49.575	49.5175	49.55	25088.0
2019-06-28 19:00:00	AAPL	Stock	49.525	49.55	49.525	49.545	14732.0
2019-06-28 19:30:00	AAPL	Stock	49.545	49.5625	49.4975	49.4975	73684.0
2019-06-28 07:00:00	MSFT	Stock	134.59	134.59	134.38	134.38	2447.0
2019-06-28 07:30:00	MSFT	Stock	134.57	134.57	134.5	134.5	2249.0
2019-06-28 08:00:00	MSFT	Stock	134.58	134.69	134.42	134.44	3284.0
2019-06-28 08:30:00	MSFT	Stock	134.44	134.9	134.44	134.79	35585.0
2019-06-28 09:00:00	MSFT	Stock	134.71	134.75	134.5	134.57	11625.0
2019-06-28 09:30:00	MSFT	Stock	134.57	134.6	133.36	133.51	1754697.0
2019-06-28 10:00:00	MSFT	Stock	133.51	133.86	133.38	133.715	789452.0
2019-06-28 10:30:00	MSFT	Stock	133.72	133.81	133.57	133.66	620558.0
2019-06-28 11:00:00	MSFT	Stock	133.65	133.65	133.35	133.46	570205.0
2019-06-28 11:30:00	MSFT	Stock	133.465	133.55	133.37	133.45	655991.0
2019-06-28 12:00:00	MSFT	Stock	133.45	134.17	133.445	134.04	774292.0
2019-06-28 12:30:00	MSFT	Stock	134.032	134.07	133.875	133.9	817249.0
2019-06-28 13:00:00	MSFT	Stock	133.905	133.915	133.5	133.52	506823.0
2019-06-28 13:30:00	MSFT	Stock	133.52	133.59	133.215	133.25	535406.0
2019-06-28 14:00:00	MSFT	Stock	133.23	133.4	133.156	133.35	727625.0
2019-06-28 14:30:00	MSFT	Stock	133.35	133.51	133.31	133.454	767956.0
2019-06-28 15:00:00	MSFT	Stock	133.45	133.52	133.23	133.235	854198.0
2019-06-28 15:30:00	MSFT	Stock	133.24	134.19	133.16	133.93	4976215.0

> showing 50 of 86,327 rows — these rows as CSV

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