PREVIEW / stock_30min / 2018-11-14

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-14.parquet
  size:    1.7 MB
  rows:    83,639
  symbols: 2,744

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-14 04:00:00	AAPL	Stock	48.375	48.375	47.7075	47.765	51756.0
2018-11-14 04:30:00	AAPL	Stock	47.795	47.845	47.765	47.8	10740.0
2018-11-14 05:00:00	AAPL	Stock	47.85	48.0	47.85	48.0	13432.0
2018-11-14 05:30:00	AAPL	Stock	48.06	48.09	48.0475	48.0525	9684.0
2018-11-14 06:00:00	AAPL	Stock	48.0525	48.0525	47.7425	47.7775	46540.0
2018-11-14 06:30:00	AAPL	Stock	47.785	47.85	47.73	47.73	17276.0
2018-11-14 07:00:00	AAPL	Stock	47.8225	48.05	47.8	48.0	171844.0
2018-11-14 07:30:00	AAPL	Stock	47.9525	48.05	47.8725	47.875	120028.0
2018-11-14 08:00:00	AAPL	Stock	47.8675	48.19	47.75	48.145	364236.0
2018-11-14 08:30:00	AAPL	Stock	48.12	48.455	48.1125	48.42	549132.0
2018-11-14 09:00:00	AAPL	Stock	48.42	48.525	48.255	48.515	516456.0
2018-11-14 09:30:00	AAPL	Stock	48.4525	48.62	47.9675	48.045	18905200.0
2018-11-14 10:00:00	AAPL	Stock	48.0375	48.0675	47.2225	47.485	27075508.0
2018-11-14 10:30:00	AAPL	Stock	47.49	47.6875	47.2925	47.476	15080488.0
2018-11-14 11:00:00	AAPL	Stock	47.4725	47.4835	47.1075	47.1825	16036640.0
2018-11-14 11:30:00	AAPL	Stock	47.185	47.2175	46.975	47.1925	12502468.0
2018-11-14 12:00:00	AAPL	Stock	47.195	47.2275	46.675	46.935	19630848.0
2018-11-14 12:30:00	AAPL	Stock	46.94	46.9625	46.5775	46.6115	12461168.0
2018-11-14 13:00:00	AAPL	Stock	46.615	47.105	46.56	46.8475	16133460.0
2018-11-14 13:30:00	AAPL	Stock	46.84	46.895	46.505	46.745	9724104.0
2018-11-14 14:00:00	AAPL	Stock	46.7463	46.925	46.4825	46.7775	9472264.0
2018-11-14 14:30:00	AAPL	Stock	46.7725	47.12	46.6775	47.0675	9845320.0
2018-11-14 15:00:00	AAPL	Stock	47.065	47.24	46.9625	47.025	10818628.0
2018-11-14 15:30:00	AAPL	Stock	47.03	47.0325	46.6225	46.7	17692168.0
2018-11-14 16:00:00	AAPL	Stock	46.7	46.85	46.635	46.75	11007364.0
2018-11-14 16:30:00	AAPL	Stock	46.8225	46.94	46.7525	46.94	219008.0
2018-11-14 17:00:00	AAPL	Stock	46.94	46.9625	46.7	46.925	346504.0
2018-11-14 17:30:00	AAPL	Stock	46.925	46.985	46.85	46.9475	140072.0
2018-11-14 18:00:00	AAPL	Stock	46.94	47.0125	46.9	46.9675	110908.0
2018-11-14 18:30:00	AAPL	Stock	46.945	46.975	46.725	46.785	130860.0
2018-11-14 19:00:00	AAPL	Stock	46.7625	46.82	46.7	46.81	98284.0
2018-11-14 19:30:00	AAPL	Stock	46.7875	46.8625	46.705	46.855	78088.0
2018-11-14 04:00:00	MSFT	Stock	106.0	106.01	105.76	106.01	967.0
2018-11-14 05:00:00	MSFT	Stock	106.34	106.48	106.34	106.4	2042.0
2018-11-14 05:30:00	MSFT	Stock	106.36	107.27	106.36	107.27	1500.0
2018-11-14 06:00:00	MSFT	Stock	106.55	106.6	106.52	106.6	500.0
2018-11-14 06:30:00	MSFT	Stock	106.62	106.62	106.62	106.62	670.0
2018-11-14 07:00:00	MSFT	Stock	106.57	106.77	106.34	106.53	2039.0
2018-11-14 07:30:00	MSFT	Stock	106.65	106.9	106.51	106.51	8607.0
2018-11-14 08:00:00	MSFT	Stock	106.6	106.99	106.6	106.99	5929.0
2018-11-14 08:30:00	MSFT	Stock	107.1	107.8	107.1	107.64	36081.0
2018-11-14 09:00:00	MSFT	Stock	107.64	108.1	107.35	108.07	17851.0
2018-11-14 09:30:00	MSFT	Stock	108.1	108.26	106.68	106.84	3232397.0
2018-11-14 10:00:00	MSFT	Stock	106.84	106.91	105.95	106.32	2509086.0
2018-11-14 10:30:00	MSFT	Stock	106.32	106.73	106.02	106.17	2004073.0
2018-11-14 11:00:00	MSFT	Stock	106.15	106.15	105.26	105.62	2071163.0
2018-11-14 11:30:00	MSFT	Stock	105.62	105.91	105.37	105.9	1416642.0
2018-11-14 12:00:00	MSFT	Stock	105.91	106.065	105.18	105.9	1714732.0
2018-11-14 12:30:00	MSFT	Stock	105.9	105.92	105.1	105.165	1944859.0
2018-11-14 13:00:00	MSFT	Stock	105.16	105.32	104.47	105.125	3016125.0

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

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