PREVIEW / stock_30min / 2009-08-31

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-08-31.parquet
  size:    1.4 MB
  rows:    73,724
  symbols: 3,385

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
2009-08-31 07:00:00	AAPL	Stock	6.0536	6.0536	6.0196	6.035	83384.0
2009-08-31 07:30:00	AAPL	Stock	6.0268	6.0268	6.0139	6.025	62748.0
2009-08-31 08:00:00	AAPL	Stock	6.0268	6.0268	6.0054	6.0125	459424.0
2009-08-31 08:30:00	AAPL	Stock	6.0121	6.0179	6.0089	6.0089	301532.0
2009-08-31 09:00:00	AAPL	Stock	6.0057	6.0171	6.0018	6.0032	989800.0
2009-08-31 09:30:00	AAPL	Stock	6.0057	6.0304	5.975	5.9914	60152120.0
2009-08-31 10:00:00	AAPL	Stock	5.9911	6.0014	5.9825	5.9929	27010452.0
2009-08-31 10:30:00	AAPL	Stock	5.9929	6.0171	5.9836	6.0093	25717664.0
2009-08-31 11:00:00	AAPL	Stock	6.0093	6.0111	5.9829	5.9864	14552412.0
2009-08-31 11:30:00	AAPL	Stock	5.9868	6.0046	5.9864	5.9943	11310880.0
2009-08-31 12:00:00	AAPL	Stock	5.9943	6.0139	5.9879	6.0032	19586560.0
2009-08-31 12:30:00	AAPL	Stock	6.0039	6.0089	5.9893	5.9914	12885852.0
2009-08-31 13:00:00	AAPL	Stock	5.9921	5.9943	5.9464	5.9896	14747432.0
2009-08-31 13:30:00	AAPL	Stock	5.989	5.996	5.9857	5.9914	10096548.0
2009-08-31 14:00:00	AAPL	Stock	5.9914	5.9946	5.9857	5.9921	7849436.0
2009-08-31 14:30:00	AAPL	Stock	5.9929	6.0096	5.9918	6.0018	15533868.0
2009-08-31 15:00:00	AAPL	Stock	6.0018	6.0025	5.9871	5.9939	17936716.0
2009-08-31 15:30:00	AAPL	Stock	5.993	6.0125	5.993	6.0086	38512936.0
2009-08-31 16:00:00	AAPL	Stock	6.0082	6.0114	5.9988	6.0075	27087060.0
2009-08-31 16:30:00	AAPL	Stock	6.0025	6.0075	6.0014	6.0071	1917804.0
2009-08-31 17:00:00	AAPL	Stock	6.0071	6.0075	6.0039	6.0071	129640.0
2009-08-31 17:30:00	AAPL	Stock	6.0071	6.0075	6.0071	6.0071	102368.0
2009-08-31 18:00:00	AAPL	Stock	6.0064	6.0075	6.0064	6.0071	419552.0
2009-08-31 18:30:00	AAPL	Stock	6.0071	6.01	6.0071	6.0089	90692.0
2009-08-31 19:00:00	AAPL	Stock	6.0089	6.0089	6.0075	6.0075	11200.0
2009-08-31 19:30:00	AAPL	Stock	6.0075	6.0118	6.0075	6.0118	87696.0
2009-08-31 05:30:00	MSFT	Stock	24.46	24.46	24.46	24.46	450.0
2009-08-31 06:30:00	MSFT	Stock	24.44	24.44	24.44	24.44	100.0
2009-08-31 07:00:00	MSFT	Stock	24.5	24.58	24.5	24.55	1200.0
2009-08-31 07:30:00	MSFT	Stock	24.55	24.55	24.5	24.5	2500.0
2009-08-31 08:00:00	MSFT	Stock	24.5	24.5	24.45	24.45	7865.0
2009-08-31 08:30:00	MSFT	Stock	24.46	24.46	24.41	24.42	4158.0
2009-08-31 09:00:00	MSFT	Stock	24.46	24.58	24.42	24.58	20634.0
2009-08-31 09:30:00	MSFT	Stock	24.57	24.59	24.29	24.5	7103508.0
2009-08-31 10:00:00	MSFT	Stock	24.5	24.6	24.5	24.563	3461754.0
2009-08-31 10:30:00	MSFT	Stock	24.57	24.85	24.53	24.84	4336327.0
2009-08-31 11:00:00	MSFT	Stock	24.84	24.85	24.61	24.61	3015821.0
2009-08-31 11:30:00	MSFT	Stock	24.61	24.67	24.57	24.625	2512237.0
2009-08-31 12:00:00	MSFT	Stock	24.63	24.67	24.59	24.64	1866816.0
2009-08-31 12:30:00	MSFT	Stock	24.64	24.65	24.57	24.571	1225965.0
2009-08-31 13:00:00	MSFT	Stock	24.58	24.6	24.55	24.56	1501449.0
2009-08-31 13:30:00	MSFT	Stock	24.562	24.62	24.55	24.6	1741667.0
2009-08-31 14:00:00	MSFT	Stock	24.6	24.63	24.56	24.59	1607258.0
2009-08-31 14:30:00	MSFT	Stock	24.585	24.61	24.56	24.57	1886030.0
2009-08-31 15:00:00	MSFT	Stock	24.57	24.58	24.46	24.506	3453486.0
2009-08-31 15:30:00	MSFT	Stock	24.51	24.69	24.505	24.64	7049361.0
2009-08-31 16:00:00	MSFT	Stock	24.64	24.66	24.55	24.646	6160017.0
2009-08-31 16:30:00	MSFT	Stock	24.65	24.658	24.63	24.658	729150.0
2009-08-31 17:00:00	MSFT	Stock	24.65	24.65	24.64	24.64	52482.0
2009-08-31 17:30:00	MSFT	Stock	24.64	24.65	24.6	24.6	6792.0

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

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