PREVIEW / stock_30min / 2011-06-30

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-30.parquet
  size:    1.4 MB
  rows:    75,048
  symbols: 3,549

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
2011-06-30 07:00:00	AAPL	Stock	11.9639	11.9732	11.9639	11.9725	56000.0
2011-06-30 07:30:00	AAPL	Stock	11.9725	11.9725	11.9464	11.9607	64960.0
2011-06-30 08:00:00	AAPL	Stock	11.9482	11.96	11.9357	11.9518	199472.0
2011-06-30 08:30:00	AAPL	Stock	11.9443	11.9554	11.9357	11.955	229488.0
2011-06-30 09:00:00	AAPL	Stock	11.9625	11.9643	11.9304	11.95	952392.0
2011-06-30 09:30:00	AAPL	Stock	11.9536	11.9604	11.8871	11.9146	51254084.0
2011-06-30 10:00:00	AAPL	Stock	11.9171	12.0046	11.9136	11.9718	49083804.0
2011-06-30 10:30:00	AAPL	Stock	11.9729	11.9821	11.9286	11.9546	35232764.0
2011-06-30 11:00:00	AAPL	Stock	11.9554	11.9879	11.9518	11.9814	21668724.0
2011-06-30 11:30:00	AAPL	Stock	11.9821	11.996	11.9679	11.9704	19126744.0
2011-06-30 12:00:00	AAPL	Stock	11.9708	11.9796	11.9571	11.9629	10876992.0
2011-06-30 12:30:00	AAPL	Stock	11.9639	11.9739	11.9525	11.9639	10980116.0
2011-06-30 13:00:00	AAPL	Stock	11.9643	11.9836	11.9607	11.9814	15079484.0
2011-06-30 13:30:00	AAPL	Stock	11.9818	11.9911	11.9721	11.9836	11948720.0
2011-06-30 14:00:00	AAPL	Stock	11.9854	11.9875	11.9725	11.9764	8902824.0
2011-06-30 14:30:00	AAPL	Stock	11.9771	11.9894	11.9611	11.9646	14082432.0
2011-06-30 15:00:00	AAPL	Stock	11.9657	11.9821	11.9611	11.9786	14438984.0
2011-06-30 15:30:00	AAPL	Stock	11.9787	11.9882	11.975	11.9857	35937888.0
2011-06-30 16:00:00	AAPL	Stock	11.9882	11.9883	11.9627	11.9839	18773720.0
2011-06-30 16:30:00	AAPL	Stock	11.9839	11.9857	11.9793	11.9821	153916.0
2011-06-30 17:00:00	AAPL	Stock	11.93	11.9846	11.93	11.9796	169120.0
2011-06-30 17:30:00	AAPL	Stock	11.9796	11.985	11.9796	11.9839	145264.0
2011-06-30 18:00:00	AAPL	Stock	11.9839	11.9882	11.9839	11.9857	110152.0
2011-06-30 18:30:00	AAPL	Stock	11.9843	11.9879	11.9825	11.9825	36400.0
2011-06-30 19:00:00	AAPL	Stock	11.9854	11.9875	11.9821	11.9875	18760.0
2011-06-30 19:30:00	AAPL	Stock	11.9882	11.9886	11.9829	11.9868	164612.0
2011-06-30 07:00:00	MSFT	Stock	25.65	25.7	25.65	25.7	6000.0
2011-06-30 07:30:00	MSFT	Stock	25.7	25.7	25.7	25.7	1500.0
2011-06-30 08:00:00	MSFT	Stock	25.68	25.68	25.67	25.67	814.0
2011-06-30 08:30:00	MSFT	Stock	25.66	25.69	25.66	25.69	2600.0
2011-06-30 09:00:00	MSFT	Stock	25.69	25.78	25.69	25.71	26281.0
2011-06-30 09:30:00	MSFT	Stock	25.71	25.84	25.66	25.77	4197614.0
2011-06-30 10:00:00	MSFT	Stock	25.76	25.86	25.74	25.84	4309974.0
2011-06-30 10:30:00	MSFT	Stock	25.835	25.9	25.81	25.869	4174356.0
2011-06-30 11:00:00	MSFT	Stock	25.865	26.0	25.86	25.99	4785162.0
2011-06-30 11:30:00	MSFT	Stock	25.99	26.0	25.88	25.93	4228638.0
2011-06-30 12:00:00	MSFT	Stock	25.925	25.94	25.86	25.87	1768976.0
2011-06-30 12:30:00	MSFT	Stock	25.87	25.9	25.86	25.868	1491149.0
2011-06-30 13:00:00	MSFT	Stock	25.865	25.89	25.83	25.855	2388160.0
2011-06-30 13:30:00	MSFT	Stock	25.855	25.88	25.81	25.84	1677045.0
2011-06-30 14:00:00	MSFT	Stock	25.831	25.88	25.83	25.87	1907313.0
2011-06-30 14:30:00	MSFT	Stock	25.87	25.93	25.87	25.9	2283481.0
2011-06-30 15:00:00	MSFT	Stock	25.905	25.96	25.9	25.955	3445072.0
2011-06-30 15:30:00	MSFT	Stock	25.955	26.0	25.95	25.98	9772098.0
2011-06-30 16:00:00	MSFT	Stock	26.0	26.002	25.742	25.907	4823623.0
2011-06-30 16:30:00	MSFT	Stock	25.921	25.989	25.852	25.96	185275.0
2011-06-30 17:00:00	MSFT	Stock	25.62	25.98	25.62	25.98	5100.0
2011-06-30 17:30:00	MSFT	Stock	25.98	25.98	25.97	25.97	1200.0
2011-06-30 18:00:00	MSFT	Stock	25.99	26.0	25.99	26.0	23941.0
2011-06-30 19:30:00	MSFT	Stock	25.99	25.99	25.94	25.94	510.0

> showing 50 of 75,048 rows — these rows as CSV

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