PREVIEW / stock_30min / 2010-02-05

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-05.parquet
  size:    1.4 MB
  rows:    73,955
  symbols: 3,429

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
2010-02-05 04:30:00	AAPL	Stock	6.8571	6.8604	6.8514	6.8514	30800.0
2010-02-05 05:30:00	AAPL	Stock	6.8375	6.8375	6.8193	6.8193	20020.0
2010-02-05 06:00:00	AAPL	Stock	6.7932	6.7943	6.7929	6.7943	172032.0
2010-02-05 06:30:00	AAPL	Stock	6.8179	6.8179	6.8179	6.8179	2800.0
2010-02-05 07:00:00	AAPL	Stock	6.835	6.835	6.8179	6.8286	61964.0
2010-02-05 07:30:00	AAPL	Stock	6.8275	6.845	6.8275	6.8332	266924.0
2010-02-05 08:00:00	AAPL	Stock	6.8232	6.8393	6.7957	6.8243	1767864.0
2010-02-05 08:30:00	AAPL	Stock	6.8282	6.9204	6.8018	6.92	11099004.0
2010-02-05 09:00:00	AAPL	Stock	6.9207	6.9286	6.8746	6.88	6469428.0
2010-02-05 09:30:00	AAPL	Stock	6.8795	6.9107	6.8161	6.8764	142699620.0
2010-02-05 10:00:00	AAPL	Stock	6.8764	6.9643	6.8429	6.9539	100902424.0
2010-02-05 10:30:00	AAPL	Stock	6.9525	6.9643	6.9179	6.9218	62399848.0
2010-02-05 11:00:00	AAPL	Stock	6.9218	6.9307	6.8875	6.9079	45578820.0
2010-02-05 11:30:00	AAPL	Stock	6.9079	6.9161	6.8686	6.9039	40966268.0
2010-02-05 12:00:00	AAPL	Stock	6.9043	6.9318	6.9	6.9261	34434372.0
2010-02-05 12:30:00	AAPL	Stock	6.9261	6.9286	6.9061	6.9232	20917260.0
2010-02-05 13:00:00	AAPL	Stock	6.9232	6.9243	6.8721	6.8768	30267804.0
2010-02-05 13:30:00	AAPL	Stock	6.8743	6.8879	6.8357	6.8461	50591044.0
2010-02-05 14:00:00	AAPL	Stock	6.8461	6.8871	6.8393	6.8732	51097200.0
2010-02-05 14:30:00	AAPL	Stock	6.8734	6.9107	6.8571	6.9104	45176208.0
2010-02-05 15:00:00	AAPL	Stock	6.9104	6.9979	6.9089	6.9689	96451432.0
2010-02-05 15:30:00	AAPL	Stock	6.97	7.0	6.9525	6.975	82008864.0
2010-02-05 16:00:00	AAPL	Stock	6.9746	6.9871	6.9088	6.9768	11131932.0
2010-02-05 16:30:00	AAPL	Stock	6.8456	6.9839	6.8456	6.9779	485716.0
2010-02-05 17:00:00	AAPL	Stock	6.9779	6.9875	6.8571	6.9868	2119880.0
2010-02-05 17:30:00	AAPL	Stock	6.9868	6.9957	6.9857	6.9946	215656.0
2010-02-05 18:00:00	AAPL	Stock	6.9957	6.9993	6.9807	6.9982	203140.0
2010-02-05 18:30:00	AAPL	Stock	6.9964	6.9964	6.9911	6.9914	79492.0
2010-02-05 19:00:00	AAPL	Stock	6.9914	6.9982	6.9911	6.9957	116228.0
2010-02-05 19:30:00	AAPL	Stock	6.9975	6.9979	6.9893	6.9964	180264.0
2010-02-05 20:00:00	AAPL	Stock	6.9157	6.9157	6.9111	6.9111	126000.0
2010-02-05 04:30:00	MSFT	Stock	27.76	27.76	27.7	27.7	1500.0
2010-02-05 05:00:00	MSFT	Stock	27.7	27.7	27.7	27.7	4330.0
2010-02-05 05:30:00	MSFT	Stock	27.7	27.7	27.7	27.7	634.0
2010-02-05 06:00:00	MSFT	Stock	27.53	27.53	27.53	27.53	400.0
2010-02-05 07:00:00	MSFT	Stock	27.57	27.68	27.53	27.62	6100.0
2010-02-05 07:30:00	MSFT	Stock	27.64	27.72	27.64	27.71	2300.0
2010-02-05 08:00:00	MSFT	Stock	27.65	27.79	27.65	27.7	26791.0
2010-02-05 08:30:00	MSFT	Stock	27.69	28.0	27.63	27.99	145662.0
2010-02-05 09:00:00	MSFT	Stock	27.81	28.1	27.81	28.0	380749.0
2010-02-05 09:30:00	MSFT	Stock	28.0	28.08	27.71	27.75	7493658.0
2010-02-05 10:00:00	MSFT	Stock	27.765	28.21	27.74	28.17	7417929.0
2010-02-05 10:30:00	MSFT	Stock	28.17	28.28	28.0	28.03	6594108.0
2010-02-05 11:00:00	MSFT	Stock	28.02	28.04	27.89	27.92	4431109.0
2010-02-05 11:30:00	MSFT	Stock	27.92	27.95	27.72	27.82	5380442.0
2010-02-05 12:00:00	MSFT	Stock	27.82	27.9	27.78	27.893	3052312.0
2010-02-05 12:30:00	MSFT	Stock	27.898	27.9	27.78	27.86	2797904.0
2010-02-05 13:00:00	MSFT	Stock	27.87	27.88	27.7	27.76	3138043.0
2010-02-05 13:30:00	MSFT	Stock	27.76	27.79	27.57	27.6	4372482.0
2010-02-05 14:00:00	MSFT	Stock	27.602	27.77	27.601	27.745	3300895.0

> showing 50 of 73,955 rows — these rows as CSV

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