PREVIEW / stock_30min / 2016-07-28

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-28.parquet
  size:    1.6 MB
  rows:    81,732
  symbols: 3,261

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-07-28 04:00:00	AAPL	Stock	25.85	25.875	25.8	25.8	11520.0
2016-07-28 04:30:00	AAPL	Stock	25.8025	25.8125	25.8	25.8025	6972.0
2016-07-28 05:00:00	AAPL	Stock	25.8075	25.8125	25.7825	25.7825	14560.0
2016-07-28 05:30:00	AAPL	Stock	25.7775	25.8325	25.7775	25.7825	7908.0
2016-07-28 06:30:00	AAPL	Stock	25.7875	25.7875	25.78	25.78	9896.0
2016-07-28 07:00:00	AAPL	Stock	25.765	25.78	25.735	25.7475	48756.0
2016-07-28 07:30:00	AAPL	Stock	25.745	25.785	25.7025	25.7225	62692.0
2016-07-28 08:00:00	AAPL	Stock	25.7225	25.77	25.675	25.7425	190736.0
2016-07-28 08:30:00	AAPL	Stock	25.7475	25.75	25.72	25.7375	104020.0
2016-07-28 09:00:00	AAPL	Stock	25.745	25.775	25.7125	25.7125	255328.0
2016-07-28 09:30:00	AAPL	Stock	25.7125	26.0575	25.705	25.9875	26597188.0
2016-07-28 10:00:00	AAPL	Stock	25.99	26.0375	25.9525	25.99	14863716.0
2016-07-28 10:30:00	AAPL	Stock	25.9925	26.0125	25.9275	25.9825	12102032.0
2016-07-28 11:00:00	AAPL	Stock	25.9825	25.9975	25.9275	25.9325	8332140.0
2016-07-28 11:30:00	AAPL	Stock	25.93	25.9725	25.875	25.9648	7966644.0
2016-07-28 12:00:00	AAPL	Stock	25.9625	25.975	25.9062	25.9338	5467840.0
2016-07-28 12:30:00	AAPL	Stock	25.9325	25.935	25.875	25.8998	4744712.0
2016-07-28 13:00:00	AAPL	Stock	25.9	25.945	25.89	25.93	4596240.0
2016-07-28 13:30:00	AAPL	Stock	25.9288	25.995	25.92	25.995	5289348.0
2016-07-28 14:00:00	AAPL	Stock	25.9962	26.025	25.9875	26.01	6584476.0
2016-07-28 14:30:00	AAPL	Stock	26.0112	26.0225	25.995	26.01	5165544.0
2016-07-28 15:00:00	AAPL	Stock	26.01	26.0375	25.9975	26.025	6377576.0
2016-07-28 15:30:00	AAPL	Stock	26.0275	26.1125	26.02	26.0825	19869796.0
2016-07-28 16:00:00	AAPL	Stock	26.085	26.1225	26.0325	26.1075	7362328.0
2016-07-28 16:30:00	AAPL	Stock	26.105	26.125	26.085	26.125	1306508.0
2016-07-28 17:00:00	AAPL	Stock	26.11	26.135	26.105	26.125	146168.0
2016-07-28 17:30:00	AAPL	Stock	26.125	26.145	26.125	26.1275	76596.0
2016-07-28 18:00:00	AAPL	Stock	26.14	26.14	26.12	26.12	82944.0
2016-07-28 18:30:00	AAPL	Stock	26.125	26.135	26.1175	26.135	15424.0
2016-07-28 19:00:00	AAPL	Stock	26.125	26.135	26.1175	26.125	37292.0
2016-07-28 19:30:00	AAPL	Stock	26.125	26.145	26.1175	26.135	78088.0
2016-07-28 07:30:00	MSFT	Stock	56.11	56.11	56.1	56.1	512.0
2016-07-28 08:00:00	MSFT	Stock	56.06	56.06	55.95	56.0	1378.0
2016-07-28 08:30:00	MSFT	Stock	56.0	56.0	55.89	55.99	1333.0
2016-07-28 09:00:00	MSFT	Stock	55.92	56.07	55.92	56.0	29062.0
2016-07-28 09:30:00	MSFT	Stock	56.01	56.22	55.91	56.065	3521383.0
2016-07-28 10:00:00	MSFT	Stock	56.07	56.15	55.83	55.857	2795055.0
2016-07-28 10:30:00	MSFT	Stock	55.86	55.91	55.72	55.8	7085493.0
2016-07-28 11:00:00	MSFT	Stock	55.8	55.92	55.77	55.89	1929938.0
2016-07-28 11:30:00	MSFT	Stock	55.88	55.98	55.85	55.97	2048216.0
2016-07-28 12:00:00	MSFT	Stock	55.965	56.06	55.95	55.985	1154628.0
2016-07-28 12:30:00	MSFT	Stock	55.98	56.14	55.98	56.095	1295894.0
2016-07-28 13:00:00	MSFT	Stock	56.1	56.29	56.075	56.205	2201969.0
2016-07-28 13:30:00	MSFT	Stock	56.2	56.3	56.16	56.29	1091077.0
2016-07-28 14:00:00	MSFT	Stock	56.3	56.37	56.24	56.295	1074352.0
2016-07-28 14:30:00	MSFT	Stock	56.29	56.31	56.22	56.245	1168088.0
2016-07-28 15:00:00	MSFT	Stock	56.24	56.29	56.18	56.21	1198888.0
2016-07-28 15:30:00	MSFT	Stock	56.215	56.275	56.15	56.21	5516403.0
2016-07-28 16:00:00	MSFT	Stock	56.21	56.25	56.06	56.06	3420341.0
2016-07-28 16:30:00	MSFT	Stock	56.09	56.09	56.09	56.09	1108.0

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

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