PREVIEW / stock_30min / 2018-11-21

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-21.parquet
  size:    1.6 MB
  rows:    81,438
  symbols: 2,716

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-21 04:00:00	AAPL	Stock	44.5125	44.725	44.5125	44.675	47048.0
2018-11-21 04:30:00	AAPL	Stock	44.665	44.665	44.6	44.66	21340.0
2018-11-21 05:00:00	AAPL	Stock	44.6075	44.7	44.605	44.6875	20096.0
2018-11-21 05:30:00	AAPL	Stock	44.65	44.65	44.575	44.6375	5716.0
2018-11-21 06:00:00	AAPL	Stock	44.5575	44.7	44.5525	44.6625	16664.0
2018-11-21 06:30:00	AAPL	Stock	44.7125	44.7325	44.0725	44.075	128028.0
2018-11-21 07:00:00	AAPL	Stock	44.1225	44.645	44.1225	44.6325	340808.0
2018-11-21 07:30:00	AAPL	Stock	44.625	44.88	44.525	44.775	458056.0
2018-11-21 08:00:00	AAPL	Stock	44.4238	44.91	44.2488	44.8	796668.0
2018-11-21 08:30:00	AAPL	Stock	44.8225	44.83	44.65	44.695	627048.0
2018-11-21 09:00:00	AAPL	Stock	44.7025	44.9425	44.675	44.94	707300.0
2018-11-21 09:30:00	AAPL	Stock	44.9375	45.0675	44.3075	44.56	21558536.0
2018-11-21 10:00:00	AAPL	Stock	44.562	44.7475	44.3275	44.5125	12028464.0
2018-11-21 10:30:00	AAPL	Stock	44.5125	44.5925	44.2675	44.58	9295464.0
2018-11-21 11:00:00	AAPL	Stock	44.575	44.815	44.485	44.6718	8298320.0
2018-11-21 11:30:00	AAPL	Stock	44.665	44.685	44.39	44.4375	5636780.0
2018-11-21 12:00:00	AAPL	Stock	44.44	44.4788	44.2875	44.343	4862168.0
2018-11-21 12:30:00	AAPL	Stock	44.345	44.5625	44.3325	44.5525	3584164.0
2018-11-21 13:00:00	AAPL	Stock	44.5575	44.575	44.4175	44.4725	4170924.0
2018-11-21 13:30:00	AAPL	Stock	44.4712	44.595	44.4325	44.5925	3301920.0
2018-11-21 14:00:00	AAPL	Stock	44.59	44.5925	44.4975	44.555	2688272.0
2018-11-21 14:30:00	AAPL	Stock	44.5575	44.58	44.4525	44.4708	2832188.0
2018-11-21 15:00:00	AAPL	Stock	44.4725	44.5125	44.3075	44.3325	4512528.0
2018-11-21 15:30:00	AAPL	Stock	44.3325	44.3325	44.1375	44.19	12308940.0
2018-11-21 16:00:00	AAPL	Stock	44.195	44.225	44.1425	44.15	11663176.0
2018-11-21 16:30:00	AAPL	Stock	44.1725	44.1875	44.155	44.1575	21620.0
2018-11-21 17:00:00	AAPL	Stock	44.1625	44.1875	44.155	44.1875	21128.0
2018-11-21 17:30:00	AAPL	Stock	44.1875	44.195	44.1575	44.1675	21932.0
2018-11-21 18:00:00	AAPL	Stock	44.1875	44.2375	44.1875	44.2375	13824.0
2018-11-21 18:30:00	AAPL	Stock	44.2025	44.225	44.1875	44.2125	12356.0
2018-11-21 19:00:00	AAPL	Stock	44.225	44.245	44.2	44.225	14852.0
2018-11-21 19:30:00	AAPL	Stock	44.215	44.2475	44.2025	44.245	22600.0
2018-11-21 04:00:00	MSFT	Stock	102.8	103.2	102.8	102.9	4449.0
2018-11-21 04:30:00	MSFT	Stock	102.65	102.65	102.6	102.6	975.0
2018-11-21 05:00:00	MSFT	Stock	103.0	103.0	102.6	102.7	725.0
2018-11-21 06:00:00	MSFT	Stock	102.45	102.76	102.45	102.76	2225.0
2018-11-21 06:30:00	MSFT	Stock	102.83	102.84	102.51	102.51	2530.0
2018-11-21 07:00:00	MSFT	Stock	102.61	103.08	102.55	103.08	17639.0
2018-11-21 07:30:00	MSFT	Stock	103.05	104.17	102.6	103.1	22589.0
2018-11-21 08:00:00	MSFT	Stock	103.1	103.5	102.6	103.39	48691.0
2018-11-21 08:30:00	MSFT	Stock	103.15	103.34	102.7	103.1	33369.0
2018-11-21 09:00:00	MSFT	Stock	103.19	103.46	103.01	103.39	21074.0
2018-11-21 09:30:00	MSFT	Stock	103.6	103.723	102.24	102.99	4477228.0
2018-11-21 10:00:00	MSFT	Stock	103.0	103.59	102.81	103.41	2466404.0
2018-11-21 10:30:00	MSFT	Stock	103.4	103.58	102.89	103.275	1976379.0
2018-11-21 11:00:00	MSFT	Stock	103.28	104.18	103.07	104.02	2429768.0
2018-11-21 11:30:00	MSFT	Stock	104.015	104.15	103.56	103.93	1572539.0
2018-11-21 12:00:00	MSFT	Stock	103.94	104.08	103.78	104.022	1156556.0
2018-11-21 12:30:00	MSFT	Stock	104.02	104.43	103.86	104.385	1306242.0
2018-11-21 13:00:00	MSFT	Stock	104.39	104.417	103.88	104.0	869783.0

> showing 50 of 81,438 rows — these rows as CSV

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