PREVIEW / stock_30min / 2012-10-19

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-19.parquet
  size:    1.4 MB
  rows:    76,002
  symbols: 3,465

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-10-19 04:00:00	AAPL	Stock	22.575	22.575	22.5714	22.5714	8400.0
2012-10-19 04:30:00	AAPL	Stock	22.5571	22.5571	22.5571	22.5571	8400.0
2012-10-19 05:30:00	AAPL	Stock	22.5179	22.5179	22.5179	22.5179	15120.0
2012-10-19 06:30:00	AAPL	Stock	22.5271	22.5271	22.5268	22.5268	18760.0
2012-10-19 07:00:00	AAPL	Stock	22.5268	22.5268	22.4875	22.4993	175308.0
2012-10-19 07:30:00	AAPL	Stock	22.5071	22.5804	22.5071	22.5429	390740.0
2012-10-19 08:00:00	AAPL	Stock	22.5179	22.5757	22.5179	22.5614	353080.0
2012-10-19 08:30:00	AAPL	Stock	22.5604	22.5707	22.5071	22.5436	584556.0
2012-10-19 09:00:00	AAPL	Stock	22.5436	22.5693	22.5179	22.5375	1079400.0
2012-10-19 09:30:00	AAPL	Stock	22.5375	22.5632	22.3493	22.4379	111253828.0
2012-10-19 10:00:00	AAPL	Stock	22.4336	22.4582	22.3343	22.3871	38730496.0
2012-10-19 10:30:00	AAPL	Stock	22.3807	22.3896	22.3307	22.3354	26653312.0
2012-10-19 11:00:00	AAPL	Stock	22.3379	22.3454	22.1629	22.2284	77007924.0
2012-10-19 11:30:00	AAPL	Stock	22.2264	22.23	21.9871	22.0907	79687356.0
2012-10-19 12:00:00	AAPL	Stock	22.0881	22.1243	22.0207	22.1	41017788.0
2012-10-19 12:30:00	AAPL	Stock	22.1025	22.1579	22.0821	22.0932	27201440.0
2012-10-19 13:00:00	AAPL	Stock	22.0889	22.1546	22.0593	22.0836	24436076.0
2012-10-19 13:30:00	AAPL	Stock	22.0836	22.0946	21.9882	22.0367	31475808.0
2012-10-19 14:00:00	AAPL	Stock	22.0355	22.0482	21.9704	21.9996	30786952.0
2012-10-19 14:30:00	AAPL	Stock	21.9961	22.0129	21.9143	21.9532	46520600.0
2012-10-19 15:00:00	AAPL	Stock	21.9525	21.9671	21.8857	21.8954	44836596.0
2012-10-19 15:30:00	AAPL	Stock	21.8971	21.9168	21.7721	21.778	107470496.0
2012-10-19 16:00:00	AAPL	Stock	21.7789	22.2896	21.7774	21.7843	27777988.0
2012-10-19 16:30:00	AAPL	Stock	21.785	21.7857	21.7786	21.7839	2575356.0
2012-10-19 17:00:00	AAPL	Stock	21.7846	21.7868	21.7754	21.7814	2269064.0
2012-10-19 17:30:00	AAPL	Stock	21.7818	22.3325	21.7679	21.7843	740488.0
2012-10-19 18:00:00	AAPL	Stock	21.7821	21.7821	21.7536	21.7561	218568.0
2012-10-19 18:30:00	AAPL	Stock	21.7707	21.7714	21.7579	21.7639	57960.0
2012-10-19 19:00:00	AAPL	Stock	21.7679	21.7679	21.7536	21.7661	74032.0
2012-10-19 19:30:00	AAPL	Stock	21.7679	21.78	21.7607	21.7611	198940.0
2012-10-19 04:30:00	MSFT	Stock	29.0	29.0	28.99	28.99	1300.0
2012-10-19 05:00:00	MSFT	Stock	28.98	28.98	28.97	28.97	800.0
2012-10-19 05:30:00	MSFT	Stock	28.89	28.89	28.86	28.86	500.0
2012-10-19 06:00:00	MSFT	Stock	28.96	28.96	28.96	28.96	131.0
2012-10-19 06:30:00	MSFT	Stock	28.91	28.91	28.91	28.91	200.0
2012-10-19 07:00:00	MSFT	Stock	28.91	28.96	28.88	28.88	2200.0
2012-10-19 07:30:00	MSFT	Stock	28.9	28.96	28.9	28.93	12638.0
2012-10-19 08:00:00	MSFT	Stock	28.95	29.08	28.75	28.85	154683.0
2012-10-19 08:30:00	MSFT	Stock	28.9	28.96	28.85	28.94	276943.0
2012-10-19 09:00:00	MSFT	Stock	28.94	29.54	28.94	29.06	579868.0
2012-10-19 09:30:00	MSFT	Stock	29.06	29.08	28.56	29.02	24094893.0
2012-10-19 10:00:00	MSFT	Stock	29.0	29.011	28.76	28.915	8698977.0
2012-10-19 10:30:00	MSFT	Stock	28.92	28.92	28.75	28.848	3725653.0
2012-10-19 11:00:00	MSFT	Stock	28.85	28.87	28.66	28.75	4750784.0
2012-10-19 11:30:00	MSFT	Stock	28.75	28.86	28.68	28.7	3860653.0
2012-10-19 12:00:00	MSFT	Stock	28.71	28.71	28.61	28.66	3191195.0
2012-10-19 12:30:00	MSFT	Stock	28.66	28.77	28.65	28.687	2470727.0
2012-10-19 13:00:00	MSFT	Stock	28.68	28.79	28.63	28.7	2481907.0
2012-10-19 13:30:00	MSFT	Stock	28.705	28.71	28.6	28.63	2360686.0
2012-10-19 14:00:00	MSFT	Stock	28.63	28.68	28.55	28.58	2602692.0

> showing 50 of 76,002 rows — these rows as CSV

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