PREVIEW / stock_30min / 2016-11-01

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-01.parquet
  size:    1.6 MB
  rows:    79,841
  symbols: 3,167

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
2016-11-01 05:00:00	AAPL	Stock	28.445	28.445	28.445	28.445	400.0
2016-11-01 07:00:00	AAPL	Stock	28.425	28.4375	28.425	28.4375	4476.0
2016-11-01 07:30:00	AAPL	Stock	28.435	28.435	28.4125	28.4125	20496.0
2016-11-01 08:00:00	AAPL	Stock	28.435	28.435	28.35	28.365	86848.0
2016-11-01 08:30:00	AAPL	Stock	28.3725	28.3875	28.3575	28.3875	56084.0
2016-11-01 09:00:00	AAPL	Stock	28.3875	28.405	28.3575	28.3775	169620.0
2016-11-01 09:30:00	AAPL	Stock	28.365	28.4425	28.245	28.2612	13470916.0
2016-11-01 10:00:00	AAPL	Stock	28.2625	28.3	28.1275	28.185	12809676.0
2016-11-01 10:30:00	AAPL	Stock	28.1825	28.2375	28.15	28.1975	6968440.0
2016-11-01 11:00:00	AAPL	Stock	28.1975	28.21	28.1575	28.1575	6166456.0
2016-11-01 11:30:00	AAPL	Stock	28.1575	28.1575	28.0525	28.0675	10173632.0
2016-11-01 12:00:00	AAPL	Stock	28.0675	28.07	27.9225	27.975	13650376.0
2016-11-01 12:30:00	AAPL	Stock	27.9725	28.0092	27.925	27.95	6642332.0
2016-11-01 13:00:00	AAPL	Stock	27.9475	27.95	27.735	27.7875	11739964.0
2016-11-01 13:30:00	AAPL	Stock	27.79	27.83	27.7	27.81	10251404.0
2016-11-01 14:00:00	AAPL	Stock	27.81	27.82	27.6325	27.72	13722564.0
2016-11-01 14:30:00	AAPL	Stock	27.7225	27.8325	27.715	27.755	10372432.0
2016-11-01 15:00:00	AAPL	Stock	27.7525	27.845	27.725	27.8225	9957060.0
2016-11-01 15:30:00	AAPL	Stock	27.8248	27.875	27.76	27.8725	20884300.0
2016-11-01 16:00:00	AAPL	Stock	27.8575	27.8875	27.8575	27.8775	10636396.0
2016-11-01 16:30:00	AAPL	Stock	27.87	27.8875	27.8575	27.8625	150984.0
2016-11-01 17:00:00	AAPL	Stock	27.865	27.89	27.8625	27.8775	44288.0
2016-11-01 17:30:00	AAPL	Stock	27.8875	27.8875	27.8575	27.8575	19936.0
2016-11-01 18:00:00	AAPL	Stock	27.86	27.8875	27.835	27.86	57740.0
2016-11-01 18:30:00	AAPL	Stock	27.8575	27.8675	27.825	27.825	21180.0
2016-11-01 19:00:00	AAPL	Stock	27.8275	27.85	27.8275	27.85	27320.0
2016-11-01 19:30:00	AAPL	Stock	27.8475	27.8675	27.835	27.85	23260.0
2016-11-01 07:30:00	MSFT	Stock	60.1	60.1	60.08	60.08	500.0
2016-11-01 08:00:00	MSFT	Stock	60.03	60.03	60.03	60.03	1158.0
2016-11-01 08:30:00	MSFT	Stock	60.03	60.03	60.03	60.03	780.0
2016-11-01 09:00:00	MSFT	Stock	60.15	60.15	59.94	59.94	15817.0
2016-11-01 09:30:00	MSFT	Stock	60.0	60.02	59.88	59.92	2677248.0
2016-11-01 10:00:00	MSFT	Stock	59.93	59.97	59.81	59.9	1862012.0
2016-11-01 10:30:00	MSFT	Stock	59.9	59.99	59.815	59.98	1472866.0
2016-11-01 11:00:00	MSFT	Stock	59.98	60.01	59.94	59.94	957955.0
2016-11-01 11:30:00	MSFT	Stock	59.93	59.97	59.84	59.87	921783.0
2016-11-01 12:00:00	MSFT	Stock	59.88	59.89	59.65	59.725	1546781.0
2016-11-01 12:30:00	MSFT	Stock	59.73	59.82	59.7	59.725	921258.0
2016-11-01 13:00:00	MSFT	Stock	59.73	59.79	59.553	59.635	1157339.0
2016-11-01 13:30:00	MSFT	Stock	59.64	59.645	59.41	59.47	1279460.0
2016-11-01 14:00:00	MSFT	Stock	59.47	59.575	59.25	59.52	1623874.0
2016-11-01 14:30:00	MSFT	Stock	59.52	59.64	59.388	59.54	1353971.0
2016-11-01 15:00:00	MSFT	Stock	59.53	59.76	59.385	59.76	2106888.0
2016-11-01 15:30:00	MSFT	Stock	59.754	59.9	59.73	59.8	2983088.0
2016-11-01 16:00:00	MSFT	Stock	59.8	59.81	59.75	59.75	1679968.0
2016-11-01 16:30:00	MSFT	Stock	59.74	59.75	59.74	59.75	952.0
2016-11-01 17:00:00	MSFT	Stock	59.78	59.78	59.72	59.78	3308.0
2016-11-01 17:30:00	MSFT	Stock	59.78	59.78	59.78	59.78	1200.0
2016-11-01 18:00:00	MSFT	Stock	59.79	59.8	59.79	59.79	2671.0
2016-11-01 18:30:00	MSFT	Stock	59.75	59.75	59.75	59.75	100.0

> showing 50 of 79,841 rows — these rows as CSV

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