PREVIEW / stock_30min / 2019-11-15

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-15.parquet
  size:    1.7 MB
  rows:    84,017
  symbols: 2,500

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-11-15 04:00:00	AAPL	Stock	65.86	65.925	65.7675	65.925	38044.0
2019-11-15 04:30:00	AAPL	Stock	65.9125	65.9575	65.9125	65.9525	42720.0
2019-11-15 05:00:00	AAPL	Stock	65.9375	65.97	65.85	65.875	10492.0
2019-11-15 05:30:00	AAPL	Stock	65.88	65.91	65.7825	65.8275	31244.0
2019-11-15 06:00:00	AAPL	Stock	65.8	65.8125	65.7875	65.79	20992.0
2019-11-15 06:30:00	AAPL	Stock	65.86	65.9625	65.8575	65.9175	33764.0
2019-11-15 07:00:00	AAPL	Stock	65.8875	65.9575	65.875	65.88	77124.0
2019-11-15 07:30:00	AAPL	Stock	65.8875	65.9625	65.8875	65.9225	136840.0
2019-11-15 08:00:00	AAPL	Stock	65.934	65.9625	65.8725	65.9375	259460.0
2019-11-15 08:30:00	AAPL	Stock	65.93	65.9975	65.925	65.9625	169228.0
2019-11-15 09:00:00	AAPL	Stock	65.9625	66.145	65.9225	65.925	553040.0
2019-11-15 09:30:00	AAPL	Stock	65.925	66.14	65.82	65.8415	15953580.0
2019-11-15 10:00:00	AAPL	Stock	65.8375	66.02	65.7525	66.01	8267072.0
2019-11-15 10:30:00	AAPL	Stock	66.0125	66.0625	65.9325	66.0238	4187208.0
2019-11-15 11:00:00	AAPL	Stock	66.025	66.17	66.025	66.1675	6783376.0
2019-11-15 11:30:00	AAPL	Stock	66.17	66.1975	66.0425	66.0525	3222028.0
2019-11-15 12:00:00	AAPL	Stock	66.0537	66.15	66.045	66.055	3509636.0
2019-11-15 12:30:00	AAPL	Stock	66.0525	66.22	66.0188	66.11	3372952.0
2019-11-15 13:00:00	AAPL	Stock	66.115	66.1525	66.06	66.1295	3348376.0
2019-11-15 13:30:00	AAPL	Stock	66.1275	66.27	66.11	66.22	3832712.0
2019-11-15 14:00:00	AAPL	Stock	66.2225	66.3075	66.1925	66.2392	4321332.0
2019-11-15 14:30:00	AAPL	Stock	66.2375	66.2795	66.205	66.2675	3014324.0
2019-11-15 15:00:00	AAPL	Stock	66.2675	66.3125	66.1775	66.2418	5912580.0
2019-11-15 15:30:00	AAPL	Stock	66.2425	66.445	66.1912	66.4375	11086716.0
2019-11-15 16:00:00	AAPL	Stock	66.44	66.455	66.3775	66.45	9110792.0
2019-11-15 16:30:00	AAPL	Stock	66.45	66.5	66.44	66.475	237836.0
2019-11-15 17:00:00	AAPL	Stock	66.4775	66.52	66.4775	66.48	70040.0
2019-11-15 17:30:00	AAPL	Stock	66.4925	66.5	66.45	66.48	35592.0
2019-11-15 18:00:00	AAPL	Stock	66.4625	66.4775	66.45	66.475	46588.0
2019-11-15 18:30:00	AAPL	Stock	66.455	66.465	66.45	66.465	14200.0
2019-11-15 19:00:00	AAPL	Stock	66.4725	66.5	66.4575	66.49	30532.0
2019-11-15 19:30:00	AAPL	Stock	66.485	66.525	66.4525	66.525	64688.0
2019-11-15 04:00:00	MSFT	Stock	148.48	148.54	148.48	148.51	311.0
2019-11-15 04:30:00	MSFT	Stock	148.76	148.77	148.76	148.77	399.0
2019-11-15 05:00:00	MSFT	Stock	148.75	148.77	148.54	148.6	4468.0
2019-11-15 05:30:00	MSFT	Stock	148.83	148.83	148.46	148.67	1502.0
2019-11-15 06:00:00	MSFT	Stock	148.55	148.55	148.51	148.51	1473.0
2019-11-15 06:30:00	MSFT	Stock	148.52	148.53	148.52	148.52	445.0
2019-11-15 07:00:00	MSFT	Stock	148.79	148.79	148.54	148.6	7511.0
2019-11-15 07:30:00	MSFT	Stock	148.6	148.67	148.5	148.51	5207.0
2019-11-15 08:00:00	MSFT	Stock	148.52	148.7	148.4	148.56	14161.0
2019-11-15 08:30:00	MSFT	Stock	148.55	148.74	148.45	148.73	13972.0
2019-11-15 09:00:00	MSFT	Stock	148.72	149.4	148.72	148.89	172793.0
2019-11-15 09:30:00	MSFT	Stock	148.88	149.11	148.27	148.73	3557999.0
2019-11-15 10:00:00	MSFT	Stock	148.72	149.455	148.66	149.31	1672312.0
2019-11-15 10:30:00	MSFT	Stock	149.315	149.56	149.08	149.55	1129225.0
2019-11-15 11:00:00	MSFT	Stock	149.55	149.81	149.47	149.73	1483420.0
2019-11-15 11:30:00	MSFT	Stock	149.74	149.76	149.48	149.56	719106.0
2019-11-15 12:00:00	MSFT	Stock	149.574	149.754	149.52	149.62	786286.0
2019-11-15 12:30:00	MSFT	Stock	149.62	149.85	149.6	149.64	725127.0

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

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