PREVIEW / stock_30min / 2012-06-11

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-11.parquet
  size:    1.4 MB
  rows:    77,875
  symbols: 3,515

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
2012-06-11 04:00:00	AAPL	Stock	20.7839	21.0554	20.7839	21.0357	132244.0
2012-06-11 04:30:00	AAPL	Stock	21.0304	21.0304	20.9757	20.9757	19600.0
2012-06-11 05:00:00	AAPL	Stock	20.9861	20.9861	20.9646	20.965	36400.0
2012-06-11 05:30:00	AAPL	Stock	20.965	20.965	20.9607	20.9607	8400.0
2012-06-11 06:00:00	AAPL	Stock	20.9536	20.9536	20.9536	20.9536	25200.0
2012-06-11 06:30:00	AAPL	Stock	20.9375	20.9379	20.8929	20.8929	126336.0
2012-06-11 07:00:00	AAPL	Stock	20.9046	20.9046	20.8679	20.8714	788284.0
2012-06-11 07:30:00	AAPL	Stock	20.875	20.8929	20.84	20.8789	871612.0
2012-06-11 08:00:00	AAPL	Stock	20.8911	20.9732	20.8821	20.9557	2513504.0
2012-06-11 08:30:00	AAPL	Stock	20.9504	20.9821	20.9482	20.9536	2402596.0
2012-06-11 09:00:00	AAPL	Stock	20.9525	20.9907	20.9232	20.9907	4310880.0
2012-06-11 09:30:00	AAPL	Stock	20.9843	20.9989	20.845	20.9457	80087140.0
2012-06-11 10:00:00	AAPL	Stock	20.9432	21.0171	20.8929	20.9311	54798800.0
2012-06-11 10:30:00	AAPL	Stock	20.931	20.9679	20.8946	20.925	26361160.0
2012-06-11 11:00:00	AAPL	Stock	20.9271	20.9675	20.9111	20.9536	23261644.0
2012-06-11 11:30:00	AAPL	Stock	20.9535	21.0179	20.9429	20.99	27262228.0
2012-06-11 12:00:00	AAPL	Stock	20.9911	20.9968	20.9551	20.9643	13940360.0
2012-06-11 12:30:00	AAPL	Stock	20.9639	20.9773	20.9218	20.9279	18317936.0
2012-06-11 13:00:00	AAPL	Stock	20.9279	20.9604	20.8639	20.8857	30978892.0
2012-06-11 13:30:00	AAPL	Stock	20.8857	20.8907	20.7032	20.7941	57890168.0
2012-06-11 14:00:00	AAPL	Stock	20.7975	20.7975	20.7068	20.7821	34409032.0
2012-06-11 14:30:00	AAPL	Stock	20.7836	20.8543	20.6786	20.6986	45658648.0
2012-06-11 15:00:00	AAPL	Stock	20.6993	20.7207	20.4504	20.4954	75052908.0
2012-06-11 15:30:00	AAPL	Stock	20.4948	20.5661	20.3796	20.4107	71141616.0
2012-06-11 16:00:00	AAPL	Stock	20.4125	20.9751	20.395	20.4121	8683612.0
2012-06-11 16:30:00	AAPL	Stock	20.4107	20.9436	20.3821	20.9436	2612260.0
2012-06-11 17:00:00	AAPL	Stock	20.3964	20.4071	20.3786	20.3964	437892.0
2012-06-11 17:30:00	AAPL	Stock	20.3964	20.4	20.3932	20.3932	58912.0
2012-06-11 18:00:00	AAPL	Stock	20.3929	20.3964	20.3921	20.3929	42980.0
2012-06-11 18:30:00	AAPL	Stock	20.3811	20.4082	20.3811	20.4068	255164.0
2012-06-11 19:00:00	AAPL	Stock	20.4032	20.4054	20.3843	20.3929	111104.0
2012-06-11 19:30:00	AAPL	Stock	20.3929	20.3946	20.3571	20.3618	241556.0
2012-06-11 05:30:00	MSFT	Stock	29.95	29.95	29.95	29.95	300.0
2012-06-11 06:00:00	MSFT	Stock	29.91	29.93	29.91	29.93	500.0
2012-06-11 07:00:00	MSFT	Stock	29.9	29.94	29.83	29.83	3050.0
2012-06-11 07:30:00	MSFT	Stock	29.8	29.85	29.8	29.8	3900.0
2012-06-11 08:00:00	MSFT	Stock	29.85	29.89	29.8	29.85	13677.0
2012-06-11 08:30:00	MSFT	Stock	29.85	29.85	29.8	29.83	23973.0
2012-06-11 09:00:00	MSFT	Stock	29.83	29.84	29.65	29.75	26780.0
2012-06-11 09:30:00	MSFT	Stock	29.78	29.81	29.37	29.405	5142353.0
2012-06-11 10:00:00	MSFT	Stock	29.4	29.49	29.36	29.4	3824890.0
2012-06-11 10:30:00	MSFT	Stock	29.396	29.44	29.23	29.3	3119567.0
2012-06-11 11:00:00	MSFT	Stock	29.295	29.34	29.228	29.308	2409129.0
2012-06-11 11:30:00	MSFT	Stock	29.3	29.35	29.21	29.26	2591519.0
2012-06-11 12:00:00	MSFT	Stock	29.26	29.3	29.22	29.24	1341905.0
2012-06-11 12:30:00	MSFT	Stock	29.245	29.3	29.23	29.29	1278418.0
2012-06-11 13:00:00	MSFT	Stock	29.29	29.35	29.27	29.34	1729760.0
2012-06-11 13:30:00	MSFT	Stock	29.34	29.34	29.24	29.275	1581365.0
2012-06-11 14:00:00	MSFT	Stock	29.28	29.28	29.2	29.21	1981174.0
2012-06-11 14:30:00	MSFT	Stock	29.21	29.24	29.15	29.15	1974645.0

> showing 50 of 77,875 rows — these rows as CSV

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