PREVIEW / stock_30min / 2020-07-14

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-14.parquet
  size:    1.9 MB
  rows:    98,078
  symbols: 2,447

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
2020-07-14 04:00:00	AAPL	Stock	95.9	96.2225	95.9	96.1025	36744.0
2020-07-14 04:30:00	AAPL	Stock	96.155	96.33	96.155	96.2475	19080.0
2020-07-14 05:00:00	AAPL	Stock	96.2	96.3	96.0	96.3	11560.0
2020-07-14 05:30:00	AAPL	Stock	96.3	96.315	96.1	96.105	11128.0
2020-07-14 06:00:00	AAPL	Stock	96.135	96.1425	96.0	96.0125	5656.0
2020-07-14 06:30:00	AAPL	Stock	96.0	96.0	95.7575	95.7575	17152.0
2020-07-14 07:00:00	AAPL	Stock	95.845	96.17	95.765	96.0175	250212.0
2020-07-14 07:30:00	AAPL	Stock	96.015	96.7	96.015	96.6	255988.0
2020-07-14 08:00:00	AAPL	Stock	95.924	96.6975	95.765	96.14	341908.0
2020-07-14 08:30:00	AAPL	Stock	96.055	96.15	95.0025	95.01	446180.0
2020-07-14 09:00:00	AAPL	Stock	95.05	95.354	94.625	94.8325	1069328.0
2020-07-14 09:30:00	AAPL	Stock	94.825	96.6125	94.5775	95.3875	22228772.0
2020-07-14 10:00:00	AAPL	Stock	95.3725	95.4075	93.8775	94.7825	13408176.0
2020-07-14 10:30:00	AAPL	Stock	94.7838	95.4375	94.68	94.8375	9861340.0
2020-07-14 11:00:00	AAPL	Stock	94.84	95.365	94.5078	95.255	7321272.0
2020-07-14 11:30:00	AAPL	Stock	95.25	96.08	95.08	95.5265	7902888.0
2020-07-14 12:00:00	AAPL	Stock	95.55	96.025	95.3925	95.6375	4498100.0
2020-07-14 12:30:00	AAPL	Stock	95.6412	95.915	95.2775	95.37	3467224.0
2020-07-14 13:00:00	AAPL	Stock	95.35	95.54	95.005	95.445	3893940.0
2020-07-14 13:30:00	AAPL	Stock	95.45	96.1998	95.4275	95.748	5604708.0
2020-07-14 14:00:00	AAPL	Stock	95.7625	96.735	95.6425	96.6375	7689696.0
2020-07-14 14:30:00	AAPL	Stock	96.6375	96.8675	96.2925	96.6425	8203664.0
2020-07-14 15:00:00	AAPL	Stock	96.6475	96.7	95.7175	96.4458	8668484.0
2020-07-14 15:30:00	AAPL	Stock	96.45	97.255	96.315	97.0525	14350656.0
2020-07-14 16:00:00	AAPL	Stock	97.0575	97.125	96.8875	96.95	10391488.0
2020-07-14 16:30:00	AAPL	Stock	96.95	97.0575	96.88	96.9375	101644.0
2020-07-14 17:00:00	AAPL	Stock	96.925	97.7425	96.9175	97.69	248880.0
2020-07-14 17:30:00	AAPL	Stock	97.6375	97.725	97.0575	97.425	74868.0
2020-07-14 18:00:00	AAPL	Stock	97.45	97.75	97.4	97.75	103972.0
2020-07-14 18:30:00	AAPL	Stock	97.75	97.75	97.575	97.725	60916.0
2020-07-14 19:00:00	AAPL	Stock	97.725	97.725	97.575	97.625	41600.0
2020-07-14 19:30:00	AAPL	Stock	97.65	97.7875	97.65	97.78	78812.0
2020-07-14 04:00:00	MSFT	Stock	207.78	207.99	206.9	207.4	8948.0
2020-07-14 04:30:00	MSFT	Stock	207.52	207.97	207.52	207.71	5348.0
2020-07-14 05:00:00	MSFT	Stock	207.73	207.95	207.51	207.51	3616.0
2020-07-14 05:30:00	MSFT	Stock	207.78	207.9	207.65	207.65	1019.0
2020-07-14 06:00:00	MSFT	Stock	207.72	207.75	207.46	207.46	376.0
2020-07-14 06:30:00	MSFT	Stock	207.48	207.5	206.65	207.29	4288.0
2020-07-14 07:00:00	MSFT	Stock	207.31	208.0	207.0	207.56	62247.0
2020-07-14 07:30:00	MSFT	Stock	207.81	208.81	207.81	208.71	13798.0
2020-07-14 08:00:00	MSFT	Stock	207.0	209.69	207.0	207.98	79356.0
2020-07-14 08:30:00	MSFT	Stock	207.76	208.0	205.0	205.13	111097.0
2020-07-14 09:00:00	MSFT	Stock	205.15	206.86	204.19	206.61	156892.0
2020-07-14 09:30:00	MSFT	Stock	206.61	208.3	202.03	204.0	5483214.0
2020-07-14 10:00:00	MSFT	Stock	203.98	204.82	202.09	204.7	3064416.0
2020-07-14 10:30:00	MSFT	Stock	204.7	206.35	204.29	205.012	2693467.0
2020-07-14 11:00:00	MSFT	Stock	205.03	206.19	204.26	205.575	1606188.0
2020-07-14 11:30:00	MSFT	Stock	205.57	206.79	205.29	206.06	1340628.0
2020-07-14 12:00:00	MSFT	Stock	206.02	207.1	205.48	206.39	1168327.0
2020-07-14 12:30:00	MSFT	Stock	206.4	207.06	205.74	205.91	1018569.0

> showing 50 of 98,078 rows — these rows as CSV

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