PREVIEW / stock_30min / 2013-02-28

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-28.parquet
  size:    1.5 MB
  rows:    78,607
  symbols: 3,462

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
2013-02-28 05:30:00	AAPL	Stock	15.8964	15.8964	15.8964	15.8964	58800.0
2013-02-28 07:00:00	AAPL	Stock	15.8929	15.9107	15.8929	15.8929	77112.0
2013-02-28 07:30:00	AAPL	Stock	15.8996	15.9093	15.8571	15.8746	308112.0
2013-02-28 08:00:00	AAPL	Stock	15.9018	15.9211	15.85	15.8636	445452.0
2013-02-28 08:30:00	AAPL	Stock	15.8571	15.8664	15.8307	15.865	417172.0
2013-02-28 09:00:00	AAPL	Stock	15.8657	15.8836	15.8393	15.865	540260.0
2013-02-28 09:30:00	AAPL	Stock	15.8589	15.9779	15.8214	15.8896	52574536.0
2013-02-28 10:00:00	AAPL	Stock	15.8843	15.9954	15.8404	15.9221	32933600.0
2013-02-28 10:30:00	AAPL	Stock	15.9214	15.9286	15.8411	15.8779	21388584.0
2013-02-28 11:00:00	AAPL	Stock	15.8775	15.9286	15.8504	15.9014	16350432.0
2013-02-28 11:30:00	AAPL	Stock	15.9013	15.9107	15.8631	15.8915	11156208.0
2013-02-28 12:00:00	AAPL	Stock	15.8929	15.9507	15.8904	15.94	11011448.0
2013-02-28 12:30:00	AAPL	Stock	15.9404	15.9518	15.9039	15.9097	9807476.0
2013-02-28 13:00:00	AAPL	Stock	15.9079	15.9471	15.8857	15.9329	13951140.0
2013-02-28 13:30:00	AAPL	Stock	15.9321	15.9443	15.9107	15.9275	8381828.0
2013-02-28 14:00:00	AAPL	Stock	15.9275	15.9568	15.9168	15.9382	12035296.0
2013-02-28 14:30:00	AAPL	Stock	15.9382	15.9482	15.8571	15.8696	18460092.0
2013-02-28 15:00:00	AAPL	Stock	15.8754	15.9	15.8371	15.8882	17724952.0
2013-02-28 15:30:00	AAPL	Stock	15.8843	15.8932	15.7646	15.765	41400016.0
2013-02-28 16:00:00	AAPL	Stock	15.7643	15.9125	15.7406	15.7627	33268144.0
2013-02-28 16:30:00	AAPL	Stock	15.7644	15.8802	15.7588	15.7682	4696664.0
2013-02-28 17:00:00	AAPL	Stock	15.7696	15.7768	15.7643	15.775	3192896.0
2013-02-28 17:30:00	AAPL	Stock	15.7732	15.7768	15.7696	15.7732	79716.0
2013-02-28 18:00:00	AAPL	Stock	15.7732	15.7864	15.7718	15.7821	117320.0
2013-02-28 18:30:00	AAPL	Stock	15.7643	15.7789	15.7643	15.775	146860.0
2013-02-28 19:00:00	AAPL	Stock	15.7689	15.7725	15.7646	15.7721	44156.0
2013-02-28 19:30:00	AAPL	Stock	15.7679	15.7714	15.7646	15.7657	77084.0
2013-02-28 08:00:00	MSFT	Stock	27.94	27.94	27.58	27.85	16899.0
2013-02-28 09:00:00	MSFT	Stock	27.85	27.9	27.85	27.85	9500.0
2013-02-28 09:30:00	MSFT	Stock	27.88	27.97	27.74	27.89	2954067.0
2013-02-28 10:00:00	MSFT	Stock	27.89	27.94	27.85	27.89	2608110.0
2013-02-28 10:30:00	MSFT	Stock	27.885	27.89	27.75	27.76	1597131.0
2013-02-28 11:00:00	MSFT	Stock	27.765	27.84	27.75	27.84	1606582.0
2013-02-28 11:30:00	MSFT	Stock	27.84	27.87	27.81	27.84	1012965.0
2013-02-28 12:00:00	MSFT	Stock	27.84	27.87	27.83	27.855	808427.0
2013-02-28 12:30:00	MSFT	Stock	27.859	27.88	27.844	27.855	896011.0
2013-02-28 13:00:00	MSFT	Stock	27.85	27.9	27.83	27.886	1364017.0
2013-02-28 13:30:00	MSFT	Stock	27.89	27.94	27.88	27.94	1444268.0
2013-02-28 14:00:00	MSFT	Stock	27.935	27.95	27.91	27.95	1345781.0
2013-02-28 14:30:00	MSFT	Stock	27.945	27.96	27.9	27.915	1710292.0
2013-02-28 15:00:00	MSFT	Stock	27.915	27.92	27.84	27.89	2286688.0
2013-02-28 15:30:00	MSFT	Stock	27.885	27.9	27.77	27.775	7195559.0
2013-02-28 16:00:00	MSFT	Stock	27.77	27.929	27.77	27.797	8288798.0
2013-02-28 16:30:00	MSFT	Stock	27.803	27.88	27.794	27.8	97836.0
2013-02-28 17:00:00	MSFT	Stock	27.8	27.81	27.78	27.8	18645.0
2013-02-28 18:00:00	MSFT	Stock	27.8	27.81	27.8	27.81	1400.0
2013-02-28 19:00:00	MSFT	Stock	27.8	27.8	27.8	27.8	400.0
2013-02-28 19:30:00	MSFT	Stock	27.78	27.78	27.78	27.78	300.0
2013-02-28 08:30:00	NVDA	Stock	0.315	0.315	0.315	0.315	12000.0
2013-02-28 09:30:00	NVDA	Stock	0.314	0.3185	0.3128	0.3185	48855800.0

> showing 50 of 78,607 rows — these rows as CSV

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