PREVIEW / stock_30min / 2013-12-27

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-27.parquet
  size:    1.5 MB
  rows:    80,325
  symbols: 3,531

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-12-27 04:00:00	AAPL	Stock	20.1643	20.1643	20.1643	20.1643	2800.0
2013-12-27 04:30:00	AAPL	Stock	20.1571	20.1625	20.1571	20.1571	11200.0
2013-12-27 05:00:00	AAPL	Stock	20.15	20.15	20.1321	20.1321	25200.0
2013-12-27 05:30:00	AAPL	Stock	20.125	20.1314	20.1179	20.1179	11200.0
2013-12-27 06:00:00	AAPL	Stock	20.1279	20.1279	20.1279	20.1279	2800.0
2013-12-27 06:30:00	AAPL	Stock	20.1554	20.1661	20.1536	20.1621	23800.0
2013-12-27 07:00:00	AAPL	Stock	20.1786	20.1821	20.16	20.1775	48636.0
2013-12-27 07:30:00	AAPL	Stock	20.1811	20.1961	20.1771	20.1821	61180.0
2013-12-27 08:00:00	AAPL	Stock	20.14	20.2143	20.14	20.1625	368200.0
2013-12-27 08:30:00	AAPL	Stock	20.1561	20.1561	20.1286	20.1446	193368.0
2013-12-27 09:00:00	AAPL	Stock	20.1447	20.1671	20.1289	20.1289	408548.0
2013-12-27 09:30:00	AAPL	Stock	20.1389	20.1575	20.0375	20.0432	37926700.0
2013-12-27 10:00:00	AAPL	Stock	20.0389	20.1032	20.0375	20.0486	22665636.0
2013-12-27 10:30:00	AAPL	Stock	20.0497	20.0497	19.9854	19.9876	23569700.0
2013-12-27 11:00:00	AAPL	Stock	19.9861	20.0186	19.9821	20.0107	15362480.0
2013-12-27 11:30:00	AAPL	Stock	20.0111	20.0179	19.9879	19.9976	15240792.0
2013-12-27 12:00:00	AAPL	Stock	19.9998	20.0243	19.9932	20.0125	9249996.0
2013-12-27 12:30:00	AAPL	Stock	20.0124	20.0396	19.9961	20.0264	6613572.0
2013-12-27 13:00:00	AAPL	Stock	20.0307	20.0371	20.0036	20.0107	4223352.0
2013-12-27 13:30:00	AAPL	Stock	20.0082	20.0239	20.0079	20.0132	4942028.0
2013-12-27 14:00:00	AAPL	Stock	20.015	20.0221	20.0079	20.0161	4123784.0
2013-12-27 14:30:00	AAPL	Stock	20.0161	20.0204	19.9929	19.9933	7055356.0
2013-12-27 15:00:00	AAPL	Stock	19.9957	20.0046	19.9914	19.9962	9647596.0
2013-12-27 15:30:00	AAPL	Stock	19.9932	20.0054	19.9854	20.0032	23584148.0
2013-12-27 16:00:00	AAPL	Stock	20.0032	20.0311	19.9975	20.0007	5301324.0
2013-12-27 16:30:00	AAPL	Stock	20.0	20.0032	19.9989	20.0	335300.0
2013-12-27 17:00:00	AAPL	Stock	20.0	20.0032	19.9971	20.0014	262528.0
2013-12-27 17:30:00	AAPL	Stock	20.0014	20.0014	20.0	20.0	30576.0
2013-12-27 18:00:00	AAPL	Stock	20.0018	20.0018	20.0	20.0	11424.0
2013-12-27 18:30:00	AAPL	Stock	19.9982	19.9982	19.9982	19.9982	5600.0
2013-12-27 19:00:00	AAPL	Stock	19.9879	19.9929	19.9839	19.9929	36400.0
2013-12-27 19:30:00	AAPL	Stock	19.9932	19.9982	19.9857	19.9982	138124.0
2013-12-27 07:00:00	MSFT	Stock	37.55	37.55	37.54	37.54	1650.0
2013-12-27 07:30:00	MSFT	Stock	37.53	37.53	37.5	37.5	1000.0
2013-12-27 08:00:00	MSFT	Stock	37.47	37.5	37.47	37.5	2592.0
2013-12-27 08:30:00	MSFT	Stock	37.5	37.5	37.49	37.5	5407.0
2013-12-27 09:00:00	MSFT	Stock	37.5	37.64	37.41	37.61	20547.0
2013-12-27 09:30:00	MSFT	Stock	37.58	37.62	37.42	37.43	2167823.0
2013-12-27 10:00:00	MSFT	Stock	37.42	37.62	37.41	37.547	1300186.0
2013-12-27 10:30:00	MSFT	Stock	37.54	37.55	37.28	37.305	1468641.0
2013-12-27 11:00:00	MSFT	Stock	37.31	37.36	37.25	37.345	1315267.0
2013-12-27 11:30:00	MSFT	Stock	37.35	37.37	37.28	37.32	1036999.0
2013-12-27 12:00:00	MSFT	Stock	37.32	37.33	37.264	37.267	479301.0
2013-12-27 12:30:00	MSFT	Stock	37.27	37.29	37.17	37.205	727300.0
2013-12-27 13:00:00	MSFT	Stock	37.2	37.26	37.2	37.25	463523.0
2013-12-27 13:30:00	MSFT	Stock	37.25	37.26	37.22	37.223	343037.0
2013-12-27 14:00:00	MSFT	Stock	37.225	37.3	37.22	37.28	644351.0
2013-12-27 14:30:00	MSFT	Stock	37.28	37.31	37.245	37.255	626735.0
2013-12-27 15:00:00	MSFT	Stock	37.255	37.29	37.25	37.285	471588.0
2013-12-27 15:30:00	MSFT	Stock	37.28	37.29	37.25	37.29	1679936.0

> showing 50 of 80,325 rows — these rows as CSV

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