PREVIEW / stock_30min / 2013-04-03

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-03.parquet
  size:    1.5 MB
  rows:    78,256
  symbols: 3,484

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
2013-04-03 04:00:00	AAPL	Stock	15.4	15.4107	15.4	15.4107	11088.0
2013-04-03 06:30:00	AAPL	Stock	15.4	15.4	15.3929	15.3929	16744.0
2013-04-03 07:00:00	AAPL	Stock	15.3929	15.4036	15.3929	15.4036	19600.0
2013-04-03 07:30:00	AAPL	Stock	15.4211	15.4425	15.4018	15.4389	237636.0
2013-04-03 08:00:00	AAPL	Stock	15.4321	15.4425	15.25	15.3929	1133468.0
2013-04-03 08:30:00	AAPL	Stock	15.3932	15.4132	15.3821	15.3821	448112.0
2013-04-03 09:00:00	AAPL	Stock	15.3921	15.4207	15.3497	15.4207	773052.0
2013-04-03 09:30:00	AAPL	Stock	15.4143	15.561	15.3793	15.5354	57996708.0
2013-04-03 10:00:00	AAPL	Stock	15.5321	15.6079	15.4762	15.6029	40499396.0
2013-04-03 10:30:00	AAPL	Stock	15.6029	15.6171	15.5446	15.5464	31785068.0
2013-04-03 11:00:00	AAPL	Stock	15.55	15.57	15.5054	15.5636	27538700.0
2013-04-03 11:30:00	AAPL	Stock	15.5632	15.5682	15.5139	15.5257	13496952.0
2013-04-03 12:00:00	AAPL	Stock	15.5243	15.5282	15.4036	15.4082	23563428.0
2013-04-03 12:30:00	AAPL	Stock	15.405	15.4639	15.4014	15.4561	16322740.0
2013-04-03 13:00:00	AAPL	Stock	15.4564	15.4564	15.3811	15.4043	13870920.0
2013-04-03 13:30:00	AAPL	Stock	15.4029	15.4243	15.3682	15.3839	18663456.0
2013-04-03 14:00:00	AAPL	Stock	15.3872	15.4675	15.3796	15.4421	19569984.0
2013-04-03 14:30:00	AAPL	Stock	15.4425	15.4943	15.4068	15.4732	17657136.0
2013-04-03 15:00:00	AAPL	Stock	15.4754	15.4754	15.4296	15.4421	16854096.0
2013-04-03 15:30:00	AAPL	Stock	15.4412	15.4632	15.3832	15.4232	34945624.0
2013-04-03 16:00:00	AAPL	Stock	15.4232	15.5406	15.4217	15.4304	5315632.0
2013-04-03 16:30:00	AAPL	Stock	15.4321	15.443	15.4232	15.4368	886760.0
2013-04-03 17:00:00	AAPL	Stock	15.4382	15.4411	15.4282	15.435	405104.0
2013-04-03 17:30:00	AAPL	Stock	15.4304	15.435	15.4232	15.4232	662116.0
2013-04-03 18:00:00	AAPL	Stock	15.4268	15.4279	15.4232	15.4264	69356.0
2013-04-03 18:30:00	AAPL	Stock	15.4286	15.4286	15.4246	15.4286	62720.0
2013-04-03 19:00:00	AAPL	Stock	15.425	15.4318	15.425	15.4314	46732.0
2013-04-03 19:30:00	AAPL	Stock	15.4289	15.4504	15.4289	15.4504	161000.0
2013-04-03 05:00:00	MSFT	Stock	28.8	28.8	28.8	28.8	100.0
2013-04-03 05:30:00	MSFT	Stock	28.84	28.84	28.84	28.84	1100.0
2013-04-03 06:00:00	MSFT	Stock	28.89	28.89	28.89	28.89	100.0
2013-04-03 06:30:00	MSFT	Stock	28.75	28.75	28.75	28.75	300.0
2013-04-03 07:00:00	MSFT	Stock	28.8	28.8	28.8	28.8	500.0
2013-04-03 07:30:00	MSFT	Stock	28.8	28.82	28.8	28.82	685.0
2013-04-03 08:00:00	MSFT	Stock	28.65	28.77	28.65	28.76	5680.0
2013-04-03 08:30:00	MSFT	Stock	28.79	28.79	28.77	28.77	820.0
2013-04-03 09:00:00	MSFT	Stock	28.77	28.8	28.74	28.76	2792.0
2013-04-03 09:30:00	MSFT	Stock	28.75	28.89	28.74	28.887	3485768.0
2013-04-03 10:00:00	MSFT	Stock	28.88	28.93	28.78	28.83	2922264.0
2013-04-03 10:30:00	MSFT	Stock	28.83	28.93	28.79	28.893	3304789.0
2013-04-03 11:00:00	MSFT	Stock	28.9	28.9	28.83	28.86	2357570.0
2013-04-03 11:30:00	MSFT	Stock	28.85	28.95	28.84	28.945	1589484.0
2013-04-03 12:00:00	MSFT	Stock	28.94	28.95	28.9	28.915	1286132.0
2013-04-03 12:30:00	MSFT	Stock	28.92	28.94	28.84	28.85	1997187.0
2013-04-03 13:00:00	MSFT	Stock	28.855	28.88	28.83	28.855	3158789.0
2013-04-03 13:30:00	MSFT	Stock	28.85	28.86	28.67	28.69	2702681.0
2013-04-03 14:00:00	MSFT	Stock	28.69	28.72	28.62	28.64	2072513.0
2013-04-03 14:30:00	MSFT	Stock	28.634	28.7	28.63	28.675	1810779.0
2013-04-03 15:00:00	MSFT	Stock	28.68	28.68	28.61	28.63	1713293.0
2013-04-03 15:30:00	MSFT	Stock	28.62	28.655	28.54	28.56	4695251.0

> showing 50 of 78,256 rows — these rows as CSV

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