PREVIEW / stock_30min / 2018-09-17

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-17.parquet
  size:    1.7 MB
  rows:    84,170
  symbols: 2,781

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-09-17 04:00:00	AAPL	Stock	55.975	55.975	55.8875	55.8875	14552.0
2018-09-17 04:30:00	AAPL	Stock	55.8875	55.9125	55.8875	55.91	1600.0
2018-09-17 05:00:00	AAPL	Stock	55.945	55.95	55.9325	55.9325	5672.0
2018-09-17 05:30:00	AAPL	Stock	55.925	55.925	55.8	55.825	13516.0
2018-09-17 06:00:00	AAPL	Stock	55.825	55.825	55.6525	55.6675	19960.0
2018-09-17 06:30:00	AAPL	Stock	55.7	55.7125	55.575	55.675	22992.0
2018-09-17 07:00:00	AAPL	Stock	55.695	55.72	55.3275	55.5	160392.0
2018-09-17 07:30:00	AAPL	Stock	55.5	55.595	55.43	55.4675	224360.0
2018-09-17 08:00:00	AAPL	Stock	55.675	55.7125	55.3875	55.405	223296.0
2018-09-17 08:30:00	AAPL	Stock	55.4075	55.485	55.39	55.485	220500.0
2018-09-17 09:00:00	AAPL	Stock	55.475	55.6225	55.475	55.5	205500.0
2018-09-17 09:30:00	AAPL	Stock	55.5375	55.7375	54.9328	55.3	19015136.0
2018-09-17 10:00:00	AAPL	Stock	55.3	55.36	55.13	55.27	8083140.0
2018-09-17 10:30:00	AAPL	Stock	55.27	55.2775	54.81	54.9425	11723552.0
2018-09-17 11:00:00	AAPL	Stock	54.9388	55.1075	54.8925	54.995	6422584.0
2018-09-17 11:30:00	AAPL	Stock	54.9925	55.0325	54.8895	54.9875	4862312.0
2018-09-17 12:00:00	AAPL	Stock	54.989	55.1375	54.9662	55.1025	5238552.0
2018-09-17 12:30:00	AAPL	Stock	55.105	55.1175	54.9375	54.9842	3544508.0
2018-09-17 13:00:00	AAPL	Stock	54.98	55.0002	54.8175	54.837	4237116.0
2018-09-17 13:30:00	AAPL	Stock	54.8375	55.15	54.6675	54.8758	12386748.0
2018-09-17 14:00:00	AAPL	Stock	54.8762	55.09	54.825	54.9525	7913164.0
2018-09-17 14:30:00	AAPL	Stock	54.9532	55.07	54.8852	54.93	3474876.0
2018-09-17 15:00:00	AAPL	Stock	54.935	54.945	54.5925	54.7	8776124.0
2018-09-17 15:30:00	AAPL	Stock	54.7	54.7075	54.3175	54.4725	17824696.0
2018-09-17 16:00:00	AAPL	Stock	54.47	54.525	54.4325	54.5025	10277964.0
2018-09-17 16:30:00	AAPL	Stock	54.52	54.5225	54.455	54.47	110332.0
2018-09-17 17:00:00	AAPL	Stock	54.4875	54.5	54.46	54.5	41024.0
2018-09-17 17:30:00	AAPL	Stock	54.4998	54.52	54.4625	54.4625	49328.0
2018-09-17 18:00:00	AAPL	Stock	54.475	54.4875	54.3575	54.4425	86268.0
2018-09-17 18:30:00	AAPL	Stock	54.375	54.4375	54.195	54.23	106916.0
2018-09-17 19:00:00	AAPL	Stock	54.2025	54.2325	54.0475	54.08	169420.0
2018-09-17 19:30:00	AAPL	Stock	54.075	54.1	54.0	54.0625	173144.0
2018-09-17 04:30:00	MSFT	Stock	113.2	113.2	113.2	113.2	133.0
2018-09-17 06:30:00	MSFT	Stock	113.3	113.32	113.3	113.32	675.0
2018-09-17 07:00:00	MSFT	Stock	113.0	113.17	112.87	113.17	2452.0
2018-09-17 07:30:00	MSFT	Stock	113.2	113.25	113.1	113.18	8789.0
2018-09-17 08:00:00	MSFT	Stock	113.23	113.3	113.02	113.26	5548.0
2018-09-17 08:30:00	MSFT	Stock	113.26	113.58	113.13	113.45	13239.0
2018-09-17 09:00:00	MSFT	Stock	113.43	113.7	113.306	113.56	27508.0
2018-09-17 09:30:00	MSFT	Stock	113.69	113.7	112.92	113.515	2338647.0
2018-09-17 10:00:00	MSFT	Stock	113.52	113.52	112.64	112.83	1758152.0
2018-09-17 10:30:00	MSFT	Stock	112.83	113.01	112.4	112.48	1099002.0
2018-09-17 11:00:00	MSFT	Stock	112.485	112.75	112.39	112.5	986948.0
2018-09-17 11:30:00	MSFT	Stock	112.5	112.63	112.41	112.6	775564.0
2018-09-17 12:00:00	MSFT	Stock	112.6	112.73	112.57	112.57	703303.0
2018-09-17 12:30:00	MSFT	Stock	112.58	112.749	112.43	112.73	697567.0
2018-09-17 13:00:00	MSFT	Stock	112.72	112.788	112.52	112.56	470713.0
2018-09-17 13:30:00	MSFT	Stock	112.56	112.89	112.475	112.66	739238.0
2018-09-17 14:00:00	MSFT	Stock	112.652	112.85	112.58	112.72	643245.0
2018-09-17 14:30:00	MSFT	Stock	112.725	112.77	112.53	112.575	573851.0

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

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