PREVIEW / stock_30min / 2018-10-18

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-18.parquet
  size:    1.7 MB
  rows:    83,237
  symbols: 2,757

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-10-18 04:00:00	AAPL	Stock	55.15	55.2625	55.055	55.1625	20136.0
2018-10-18 05:00:00	AAPL	Stock	55.1625	55.175	55.0	55.0	28188.0
2018-10-18 05:30:00	AAPL	Stock	55.0	55.0	55.0	55.0	8000.0
2018-10-18 06:00:00	AAPL	Stock	55.0625	55.0625	55.0	55.0	5072.0
2018-10-18 06:30:00	AAPL	Stock	54.9275	54.9375	54.925	54.925	5164.0
2018-10-18 07:00:00	AAPL	Stock	54.99	54.995	54.8	54.85	148236.0
2018-10-18 07:30:00	AAPL	Stock	54.8975	54.925	54.75	54.75	183404.0
2018-10-18 08:00:00	AAPL	Stock	55.0	55.0	54.6525	54.7875	325184.0
2018-10-18 08:30:00	AAPL	Stock	54.8175	54.875	54.775	54.87	152388.0
2018-10-18 09:00:00	AAPL	Stock	54.855	54.8725	54.4625	54.465	404144.0
2018-10-18 09:30:00	AAPL	Stock	54.465	54.7325	54.425	54.6162	12619252.0
2018-10-18 10:00:00	AAPL	Stock	54.605	54.705	54.44	54.6285	6755424.0
2018-10-18 10:30:00	AAPL	Stock	54.625	54.935	54.5775	54.815	6793976.0
2018-10-18 11:00:00	AAPL	Stock	54.82	54.8625	54.41	54.445	6670060.0
2018-10-18 11:30:00	AAPL	Stock	54.445	54.4675	53.9675	54.0725	10442536.0
2018-10-18 12:00:00	AAPL	Stock	54.0725	54.4075	54.005	54.3208	5907652.0
2018-10-18 12:30:00	AAPL	Stock	54.3175	54.52	54.2575	54.2825	4099592.0
2018-10-18 13:00:00	AAPL	Stock	54.28	54.32	53.7125	53.8675	8028148.0
2018-10-18 13:30:00	AAPL	Stock	53.8725	53.9825	53.7325	53.9	5988492.0
2018-10-18 14:00:00	AAPL	Stock	53.9025	54.1925	53.855	54.095	5552772.0
2018-10-18 14:30:00	AAPL	Stock	54.0875	54.285	53.99	54.0615	4738320.0
2018-10-18 15:00:00	AAPL	Stock	54.06	54.1225	53.8875	54.04	5229756.0
2018-10-18 15:30:00	AAPL	Stock	54.0325	54.115	53.25	54.03	11109004.0
2018-10-18 16:00:00	AAPL	Stock	54.005	54.7985	53.995	54.0675	9254504.0
2018-10-18 16:30:00	AAPL	Stock	54.0675	54.1375	54.005	54.105	154684.0
2018-10-18 17:00:00	AAPL	Stock	54.1125	54.1225	54.075	54.0875	25160.0
2018-10-18 17:30:00	AAPL	Stock	54.08	54.155	54.0775	54.15	46652.0
2018-10-18 18:00:00	AAPL	Stock	54.125	54.125	54.0275	54.0775	56140.0
2018-10-18 18:30:00	AAPL	Stock	54.0825	54.1125	54.065	54.105	16044.0
2018-10-18 19:00:00	AAPL	Stock	54.0875	54.125	54.0875	54.125	55740.0
2018-10-18 19:30:00	AAPL	Stock	54.1575	54.1725	54.12	54.125	57280.0
2018-10-18 04:00:00	MSFT	Stock	110.68	110.68	110.64	110.68	600.0
2018-10-18 04:30:00	MSFT	Stock	110.68	110.71	110.68	110.71	200.0
2018-10-18 06:00:00	MSFT	Stock	110.71	110.71	110.71	110.71	494.0
2018-10-18 06:30:00	MSFT	Stock	110.69	110.69	110.69	110.69	1218.0
2018-10-18 07:00:00	MSFT	Stock	110.5	110.67	110.5	110.56	1902.0
2018-10-18 07:30:00	MSFT	Stock	110.53	110.53	110.13	110.31	4703.0
2018-10-18 08:00:00	MSFT	Stock	110.1	110.6	110.1	110.53	8336.0
2018-10-18 08:30:00	MSFT	Stock	110.55	110.65	110.38	110.52	6746.0
2018-10-18 09:00:00	MSFT	Stock	110.51	110.63	110.13	110.15	13154.0
2018-10-18 09:30:00	MSFT	Stock	110.13	110.53	109.89	110.025	2503527.0
2018-10-18 10:00:00	MSFT	Stock	110.02	110.1	109.59	109.96	1656830.0
2018-10-18 10:30:00	MSFT	Stock	109.96	110.18	109.77	109.85	1426679.0
2018-10-18 11:00:00	MSFT	Stock	109.87	110.02	108.9	108.97	1661811.0
2018-10-18 11:30:00	MSFT	Stock	108.97	109.05	107.905	108.28	2620661.0
2018-10-18 12:00:00	MSFT	Stock	108.27	108.96	108.105	108.875	1624231.0
2018-10-18 12:30:00	MSFT	Stock	108.87	109.45	108.695	109.0	1114494.0
2018-10-18 13:00:00	MSFT	Stock	109.0	109.034	107.92	108.12	1932526.0
2018-10-18 13:30:00	MSFT	Stock	108.125	108.38	107.83	108.2	1665291.0
2018-10-18 14:00:00	MSFT	Stock	108.14	108.76	108.04	108.49	1547926.0

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

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