PREVIEW / stock_30min / 2017-03-21

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-21.parquet
  size:    1.6 MB
  rows:    81,981
  symbols: 3,073

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
2017-03-21 04:00:00	AAPL	Stock	35.3975	35.4575	35.3975	35.4575	8800.0
2017-03-21 04:30:00	AAPL	Stock	35.455	35.455	35.455	35.455	596.0
2017-03-21 05:00:00	AAPL	Stock	35.465	35.4675	35.46	35.4675	4868.0
2017-03-21 06:00:00	AAPL	Stock	35.465	35.4675	35.455	35.465	8624.0
2017-03-21 06:30:00	AAPL	Stock	35.4625	35.4625	35.45	35.46	8096.0
2017-03-21 07:00:00	AAPL	Stock	35.46	35.46	35.435	35.4375	24552.0
2017-03-21 07:30:00	AAPL	Stock	35.4375	35.4625	35.4325	35.4625	65876.0
2017-03-21 08:00:00	AAPL	Stock	35.4525	35.525	35.4275	35.5	281988.0
2017-03-21 08:30:00	AAPL	Stock	35.5	35.55	35.455	35.53	451256.0
2017-03-21 09:00:00	AAPL	Stock	35.5225	35.5425	35.4775	35.54	331400.0
2017-03-21 09:30:00	AAPL	Stock	35.5275	35.7	35.5275	35.6775	21473764.0
2017-03-21 10:00:00	AAPL	Stock	35.6785	35.6785	35.5375	35.5675	10649056.0
2017-03-21 10:30:00	AAPL	Stock	35.5675	35.6	35.435	35.4978	10202920.0
2017-03-21 11:00:00	AAPL	Stock	35.5	35.5025	35.305	35.3625	11140620.0
2017-03-21 11:30:00	AAPL	Stock	35.3575	35.3775	35.2375	35.3662	9850048.0
2017-03-21 12:00:00	AAPL	Stock	35.3675	35.37	35.2575	35.2725	7399824.0
2017-03-21 12:30:00	AAPL	Stock	35.2725	35.28	35.08	35.1425	9001256.0
2017-03-21 13:00:00	AAPL	Stock	35.1425	35.1812	35.0675	35.1538	5829160.0
2017-03-21 13:30:00	AAPL	Stock	35.1525	35.1575	34.9728	34.985	7203300.0
2017-03-21 14:00:00	AAPL	Stock	34.985	35.0875	34.9325	35.0425	7274176.0
2017-03-21 14:30:00	AAPL	Stock	35.0425	35.12	34.9825	35.1175	6461220.0
2017-03-21 15:00:00	AAPL	Stock	35.115	35.15	35.065	35.1402	8896224.0
2017-03-21 15:30:00	AAPL	Stock	35.14	35.1405	34.9575	34.9625	17386188.0
2017-03-21 16:00:00	AAPL	Stock	34.9625	35.4	34.94	34.9775	6796792.0
2017-03-21 16:30:00	AAPL	Stock	34.975	34.9875	34.9275	34.9275	156104.0
2017-03-21 17:00:00	AAPL	Stock	34.9275	34.95	34.9275	34.94	63396.0
2017-03-21 17:30:00	AAPL	Stock	34.9475	34.95	34.925	34.925	18092.0
2017-03-21 18:00:00	AAPL	Stock	34.925	34.9675	34.925	34.9375	17256.0
2017-03-21 18:30:00	AAPL	Stock	34.9375	34.95	34.8875	34.91	26704.0
2017-03-21 19:00:00	AAPL	Stock	34.9	34.9125	34.8875	34.89	56448.0
2017-03-21 19:30:00	AAPL	Stock	34.89	34.9	34.8375	34.8375	49352.0
2017-03-21 05:00:00	MSFT	Stock	65.17	65.2	65.17	65.2	1311.0
2017-03-21 07:00:00	MSFT	Stock	65.17	65.17	65.17	65.17	889.0
2017-03-21 08:00:00	MSFT	Stock	65.0	65.15	65.0	65.15	443.0
2017-03-21 08:30:00	MSFT	Stock	65.01	65.02	65.0	65.02	4178.0
2017-03-21 09:00:00	MSFT	Stock	65.01	65.17	65.01	65.17	5743.0
2017-03-21 09:30:00	MSFT	Stock	65.19	65.5	65.11	65.475	2256860.0
2017-03-21 10:00:00	MSFT	Stock	65.475	65.48	65.035	65.07	1963051.0
2017-03-21 10:30:00	MSFT	Stock	65.07	65.16	64.845	64.93	1670716.0
2017-03-21 11:00:00	MSFT	Stock	64.92	64.97	64.685	64.756	1884078.0
2017-03-21 11:30:00	MSFT	Stock	64.755	64.82	64.625	64.82	1750442.0
2017-03-21 12:00:00	MSFT	Stock	64.815	64.82	64.575	64.64	1386827.0
2017-03-21 12:30:00	MSFT	Stock	64.63	64.64	64.48	64.59	982946.0
2017-03-21 13:00:00	MSFT	Stock	64.59	64.66	64.5	64.644	853191.0
2017-03-21 13:30:00	MSFT	Stock	64.65	64.67	64.4	64.405	951838.0
2017-03-21 14:00:00	MSFT	Stock	64.405	64.6	64.4	64.52	1314470.0
2017-03-21 14:30:00	MSFT	Stock	64.52	64.62	64.39	64.52	1187296.0
2017-03-21 15:00:00	MSFT	Stock	64.51	64.55	64.43	64.46	1261399.0
2017-03-21 15:30:00	MSFT	Stock	64.46	64.47	64.13	64.21	4116633.0
2017-03-21 16:00:00	MSFT	Stock	64.21	64.25	64.07	64.15	2596532.0

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

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