PREVIEW / stock_30min / 2018-05-15

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-15.parquet
  size:    1.7 MB
  rows:    83,774
  symbols: 2,854

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
2018-05-15 04:30:00	AAPL	Stock	46.86	46.86	46.755	46.755	800.0
2018-05-15 05:00:00	AAPL	Stock	46.795	46.8	46.795	46.8	3952.0
2018-05-15 05:30:00	AAPL	Stock	46.825	46.8275	46.8	46.8075	17892.0
2018-05-15 06:00:00	AAPL	Stock	46.8125	46.825	46.8125	46.825	3600.0
2018-05-15 06:30:00	AAPL	Stock	46.825	46.8275	46.825	46.8275	2800.0
2018-05-15 07:00:00	AAPL	Stock	46.875	46.9225	46.825	46.825	52492.0
2018-05-15 07:30:00	AAPL	Stock	46.8375	46.86	46.8	46.85	104452.0
2018-05-15 08:00:00	AAPL	Stock	46.85	47.1375	46.8075	46.8875	195236.0
2018-05-15 08:30:00	AAPL	Stock	46.8925	46.8925	46.6975	46.745	436556.0
2018-05-15 09:00:00	AAPL	Stock	46.7325	46.7925	46.69	46.7025	207740.0
2018-05-15 09:30:00	AAPL	Stock	46.7025	46.7225	46.4075	46.515	14286268.0
2018-05-15 10:00:00	AAPL	Stock	46.5175	46.65	46.4775	46.6183	6475228.0
2018-05-15 10:30:00	AAPL	Stock	46.6175	46.7675	46.5	46.525	6661232.0
2018-05-15 11:00:00	AAPL	Stock	46.5225	46.599	46.4425	46.485	4696040.0
2018-05-15 11:30:00	AAPL	Stock	46.4875	46.62	46.48	46.52	3834360.0
2018-05-15 12:00:00	AAPL	Stock	46.5212	46.545	46.4625	46.515	3469548.0
2018-05-15 12:30:00	AAPL	Stock	46.5125	46.6025	46.4975	46.51	4071612.0
2018-05-15 13:00:00	AAPL	Stock	46.51	46.525	46.4	46.4263	4236312.0
2018-05-15 13:30:00	AAPL	Stock	46.425	46.4512	46.275	46.305	4568816.0
2018-05-15 14:00:00	AAPL	Stock	46.305	46.4875	46.28	46.4425	5356344.0
2018-05-15 14:30:00	AAPL	Stock	46.44	46.55	46.3875	46.4075	4264536.0
2018-05-15 15:00:00	AAPL	Stock	46.415	46.4825	46.3925	46.445	3593520.0
2018-05-15 15:30:00	AAPL	Stock	46.445	46.6175	46.4125	46.61	8054704.0
2018-05-15 16:00:00	AAPL	Stock	46.61	46.61	46.525	46.5625	8924232.0
2018-05-15 16:30:00	AAPL	Stock	46.5625	46.61	46.5625	46.5825	16412.0
2018-05-15 17:00:00	AAPL	Stock	46.5875	46.5875	46.55	46.5825	13792.0
2018-05-15 17:30:00	AAPL	Stock	46.5775	46.5775	46.55	46.5625	16700.0
2018-05-15 18:00:00	AAPL	Stock	46.5575	46.5575	46.5	46.5	20480.0
2018-05-15 18:30:00	AAPL	Stock	46.4775	46.5075	46.25	46.465	100792.0
2018-05-15 19:00:00	AAPL	Stock	46.475	46.525	46.475	46.5225	16316.0
2018-05-15 19:30:00	AAPL	Stock	46.5225	46.5225	46.45	46.45	56512.0
2018-05-15 04:00:00	MSFT	Stock	97.75	97.75	97.75	97.75	100.0
2018-05-15 04:30:00	MSFT	Stock	97.8	97.8	97.8	97.8	200.0
2018-05-15 05:30:00	MSFT	Stock	97.9	97.9	97.9	97.9	108.0
2018-05-15 07:00:00	MSFT	Stock	97.85	98.03	97.85	98.03	1859.0
2018-05-15 07:30:00	MSFT	Stock	97.62	97.62	97.51	97.51	1490.0
2018-05-15 08:00:00	MSFT	Stock	97.61	97.9	97.61	97.88	2789.0
2018-05-15 08:30:00	MSFT	Stock	97.65	97.65	97.11	97.11	28700.0
2018-05-15 09:00:00	MSFT	Stock	97.19	97.5	97.11	97.46	21032.0
2018-05-15 09:30:00	MSFT	Stock	97.45	97.85	96.34	96.46	3828897.0
2018-05-15 10:00:00	MSFT	Stock	96.47	97.05	96.38	96.97	1471368.0
2018-05-15 10:30:00	MSFT	Stock	96.976	97.436	96.76	96.835	1519419.0
2018-05-15 11:00:00	MSFT	Stock	96.82	97.02	96.68	96.8	1111595.0
2018-05-15 11:30:00	MSFT	Stock	96.8	97.22	96.8	96.96	1000222.0
2018-05-15 12:00:00	MSFT	Stock	96.96	97.005	96.67	96.9	970510.0
2018-05-15 12:30:00	MSFT	Stock	96.9	97.2	96.87	97.006	791495.0
2018-05-15 13:00:00	MSFT	Stock	97.0	97.08	96.79	96.895	834979.0
2018-05-15 13:30:00	MSFT	Stock	96.89	97.01	96.57	96.62	764525.0
2018-05-15 14:00:00	MSFT	Stock	96.61	96.97	96.51	96.896	1054167.0
2018-05-15 14:30:00	MSFT	Stock	96.905	97.21	96.88	97.01	1027166.0

> showing 50 of 83,774 rows — these rows as CSV

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