PREVIEW / stock_30min / 2018-11-15

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-15.parquet
  size:    1.7 MB
  rows:    84,126
  symbols: 2,756

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-11-15 04:00:00	AAPL	Stock	47.0	47.15	46.9	47.0425	25040.0
2018-11-15 04:30:00	AAPL	Stock	46.9375	46.9375	46.835	46.835	1200.0
2018-11-15 05:00:00	AAPL	Stock	46.7525	46.93	46.75	46.925	18160.0
2018-11-15 05:30:00	AAPL	Stock	46.9225	46.995	46.875	46.995	17192.0
2018-11-15 06:00:00	AAPL	Stock	47.0225	47.095	47.0225	47.095	11596.0
2018-11-15 06:30:00	AAPL	Stock	47.015	47.0475	46.965	47.0475	14764.0
2018-11-15 07:00:00	AAPL	Stock	47.08	47.1725	46.98	47.09	155140.0
2018-11-15 07:30:00	AAPL	Stock	47.1	47.175	47.0375	47.05	206432.0
2018-11-15 08:00:00	AAPL	Stock	47.065	47.175	46.93	47.0725	521736.0
2018-11-15 08:30:00	AAPL	Stock	47.065	47.1775	46.95	47.1	521068.0
2018-11-15 09:00:00	AAPL	Stock	47.1	47.1725	46.91	47.115	782428.0
2018-11-15 09:30:00	AAPL	Stock	47.0975	47.36	46.8125	46.9325	22958484.0
2018-11-15 10:00:00	AAPL	Stock	46.9325	47.0775	46.755	46.9018	10839628.0
2018-11-15 10:30:00	AAPL	Stock	46.895	47.2225	46.725	47.13	10768372.0
2018-11-15 11:00:00	AAPL	Stock	47.135	47.5625	47.0725	47.5225	15125536.0
2018-11-15 11:30:00	AAPL	Stock	47.5225	47.72	47.44	47.557	11699684.0
2018-11-15 12:00:00	AAPL	Stock	47.555	47.6025	47.345	47.4725	8106904.0
2018-11-15 12:30:00	AAPL	Stock	47.4775	47.6148	47.24	47.315	7281072.0
2018-11-15 13:00:00	AAPL	Stock	47.3125	47.66	47.225	47.61	7185156.0
2018-11-15 13:30:00	AAPL	Stock	47.6135	47.8575	47.565	47.7888	10067828.0
2018-11-15 14:00:00	AAPL	Stock	47.7875	47.915	47.6575	47.889	6737668.0
2018-11-15 14:30:00	AAPL	Stock	47.8925	47.98	47.77	47.8532	6423020.0
2018-11-15 15:00:00	AAPL	Stock	47.8525	47.8825	47.55	47.6425	10259740.0
2018-11-15 15:30:00	AAPL	Stock	47.6425	47.9925	47.64	47.8525	15335284.0
2018-11-15 16:00:00	AAPL	Stock	47.8525	47.9375	47.575	47.6225	13085592.0
2018-11-15 16:30:00	AAPL	Stock	47.6625	47.7875	47.5875	47.6875	201904.0
2018-11-15 17:00:00	AAPL	Stock	47.6875	47.75	47.525	47.535	120840.0
2018-11-15 17:30:00	AAPL	Stock	47.535	47.8525	47.5025	47.525	39516.0
2018-11-15 18:00:00	AAPL	Stock	47.525	47.61	47.505	47.5875	87112.0
2018-11-15 18:30:00	AAPL	Stock	47.5875	47.5975	47.55	47.55	38728.0
2018-11-15 19:00:00	AAPL	Stock	47.55	47.625	47.53	47.6	44012.0
2018-11-15 19:30:00	AAPL	Stock	47.6125	47.625	47.5125	47.5125	61552.0
2018-11-15 04:00:00	MSFT	Stock	105.04	105.04	105.0	105.0	790.0
2018-11-15 04:30:00	MSFT	Stock	105.0	105.0	105.0	105.0	1381.0
2018-11-15 05:00:00	MSFT	Stock	105.29	105.3	105.29	105.3	600.0
2018-11-15 06:30:00	MSFT	Stock	105.38	105.38	105.35	105.35	200.0
2018-11-15 07:00:00	MSFT	Stock	105.69	105.69	105.6	105.6	3645.0
2018-11-15 07:30:00	MSFT	Stock	105.49	105.49	105.22	105.25	4567.0
2018-11-15 08:00:00	MSFT	Stock	105.69	105.75	104.87	105.0	12424.0
2018-11-15 08:30:00	MSFT	Stock	105.2	105.24	104.88	104.95	8329.0
2018-11-15 09:00:00	MSFT	Stock	105.11	105.2	104.03	104.8	47600.0
2018-11-15 09:30:00	MSFT	Stock	104.99	105.73	104.27	105.03	3315870.0
2018-11-15 10:00:00	MSFT	Stock	105.01	105.33	104.55	104.56	2059709.0
2018-11-15 10:30:00	MSFT	Stock	104.565	105.24	103.91	105.07	2334848.0
2018-11-15 11:00:00	MSFT	Stock	105.08	105.75	104.86	105.52	1536906.0
2018-11-15 11:30:00	MSFT	Stock	105.52	105.79	105.14	105.3	1566240.0
2018-11-15 12:00:00	MSFT	Stock	105.29	105.7	105.13	105.6	1435273.0
2018-11-15 12:30:00	MSFT	Stock	105.6	105.88	105.23	105.4	1173071.0
2018-11-15 13:00:00	MSFT	Stock	105.39	106.63	105.25	106.39	1774826.0
2018-11-15 13:30:00	MSFT	Stock	106.395	107.21	106.395	107.055	2074940.0

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

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