PREVIEW / stock_30min / 2020-07-17

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-17.parquet
  size:    1.9 MB
  rows:    95,599
  symbols: 2,446

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-17 04:00:00	AAPL	Stock	96.2875	96.5125	96.255	96.5125	5756.0
2020-07-17 04:30:00	AAPL	Stock	96.615	96.615	96.615	96.615	400.0
2020-07-17 05:00:00	AAPL	Stock	96.6325	96.6325	96.5025	96.5025	4400.0
2020-07-17 05:30:00	AAPL	Stock	96.75	96.7875	96.6525	96.6525	9060.0
2020-07-17 06:00:00	AAPL	Stock	96.6525	96.6525	96.6375	96.6375	800.0
2020-07-17 06:30:00	AAPL	Stock	96.7	96.7	96.7	96.7	2800.0
2020-07-17 07:00:00	AAPL	Stock	96.6525	96.825	96.6275	96.7125	72408.0
2020-07-17 07:30:00	AAPL	Stock	96.7	96.8	96.5925	96.7775	32164.0
2020-07-17 08:00:00	AAPL	Stock	96.75	96.9975	96.6028	96.93	273268.0
2020-07-17 08:30:00	AAPL	Stock	96.9125	96.9868	96.875	96.9225	87124.0
2020-07-17 09:00:00	AAPL	Stock	96.875	97.2475	96.75	96.8325	535264.0
2020-07-17 09:30:00	AAPL	Stock	96.9875	97.1475	96.225	96.5965	13717808.0
2020-07-17 10:00:00	AAPL	Stock	96.59	96.65	95.9075	95.9715	6307536.0
2020-07-17 10:30:00	AAPL	Stock	95.9925	96.4212	95.84	96.3975	4985808.0
2020-07-17 11:00:00	AAPL	Stock	96.395	96.5225	96.3175	96.4575	3714548.0
2020-07-17 11:30:00	AAPL	Stock	96.4625	96.695	96.23	96.6875	3955476.0
2020-07-17 12:00:00	AAPL	Stock	96.6975	96.87	96.655	96.725	4123492.0
2020-07-17 12:30:00	AAPL	Stock	96.7275	96.7725	96.4077	96.4938	2810280.0
2020-07-17 13:00:00	AAPL	Stock	96.4975	96.6025	96.2525	96.5202	3715372.0
2020-07-17 13:30:00	AAPL	Stock	96.52	96.5325	96.2525	96.2925	2291624.0
2020-07-17 14:00:00	AAPL	Stock	96.2988	96.625	96.2955	96.355	3433824.0
2020-07-17 14:30:00	AAPL	Stock	96.3575	96.585	96.295	96.4325	3058812.0
2020-07-17 15:00:00	AAPL	Stock	96.4238	96.4925	96.295	96.4625	3467020.0
2020-07-17 15:30:00	AAPL	Stock	96.465	96.68	96.2775	96.2875	7689228.0
2020-07-17 16:00:00	AAPL	Stock	96.29	96.4928	96.0425	96.225	8054160.0
2020-07-17 16:30:00	AAPL	Stock	96.225	96.31	96.2	96.31	124144.0
2020-07-17 17:00:00	AAPL	Stock	96.275	96.31	96.2375	96.2375	71724.0
2020-07-17 17:30:00	AAPL	Stock	96.25	96.2775	96.25	96.275	8512.0
2020-07-17 18:00:00	AAPL	Stock	96.275	96.325	96.275	96.3125	19072.0
2020-07-17 18:30:00	AAPL	Stock	96.3125	96.3225	96.2875	96.2875	31100.0
2020-07-17 19:00:00	AAPL	Stock	96.2875	96.3125	96.2775	96.2775	64232.0
2020-07-17 19:30:00	AAPL	Stock	96.29	96.3625	96.29	96.3625	53820.0
2020-07-17 04:00:00	MSFT	Stock	203.6	204.26	203.6	204.26	499.0
2020-07-17 04:30:00	MSFT	Stock	204.48	204.87	204.48	204.78	1919.0
2020-07-17 05:00:00	MSFT	Stock	204.57	204.69	204.57	204.6	478.0
2020-07-17 05:30:00	MSFT	Stock	204.59	204.59	204.55	204.55	747.0
2020-07-17 06:00:00	MSFT	Stock	204.4	204.67	204.4	204.55	2761.0
2020-07-17 06:30:00	MSFT	Stock	204.65	204.72	204.56	204.56	2521.0
2020-07-17 07:00:00	MSFT	Stock	204.37	204.62	204.27	204.45	12659.0
2020-07-17 07:30:00	MSFT	Stock	204.51	204.53	204.05	204.25	15050.0
2020-07-17 08:00:00	MSFT	Stock	204.497	204.86	204.01	204.86	58798.0
2020-07-17 08:30:00	MSFT	Stock	204.88	204.88	204.592	204.745	26056.0
2020-07-17 09:00:00	MSFT	Stock	204.666	206.18	204.46	204.46	238550.0
2020-07-17 09:30:00	MSFT	Stock	204.46	205.04	201.86	202.82	5021647.0
2020-07-17 10:00:00	MSFT	Stock	202.8	203.05	201.48	201.76	2307293.0
2020-07-17 10:30:00	MSFT	Stock	201.76	202.61	201.39	202.56	1757631.0
2020-07-17 11:00:00	MSFT	Stock	202.57	202.99	202.41	202.683	1148245.0
2020-07-17 11:30:00	MSFT	Stock	202.7	202.79	201.922	202.25	1332198.0
2020-07-17 12:00:00	MSFT	Stock	202.25	202.88	202.154	202.61	1155380.0
2020-07-17 12:30:00	MSFT	Stock	202.625	203.2	202.36	202.69	1407341.0

> showing 50 of 95,599 rows — these rows as CSV

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