PREVIEW / stock_30min / 2012-12-28

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-28.parquet
  size:    1.4 MB
  rows:    76,640
  symbols: 3,506

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-12-28 05:00:00	AAPL	Stock	18.3	18.3	18.3	18.3	2800.0
2012-12-28 05:30:00	AAPL	Stock	18.3	18.3	18.2911	18.2964	35560.0
2012-12-28 06:00:00	AAPL	Stock	18.2954	18.3054	18.2857	18.2857	32732.0
2012-12-28 06:30:00	AAPL	Stock	18.2693	18.2821	18.2686	18.2821	47600.0
2012-12-28 07:00:00	AAPL	Stock	18.2754	18.31	18.2579	18.3036	179704.0
2012-12-28 07:30:00	AAPL	Stock	18.3107	18.3268	18.2604	18.2604	155988.0
2012-12-28 08:00:00	AAPL	Stock	18.2539	18.3036	18.1646	18.2154	1570352.0
2012-12-28 08:30:00	AAPL	Stock	18.2157	18.2554	18.2143	18.25	950992.0
2012-12-28 09:00:00	AAPL	Stock	18.2496	18.2507	18.2214	18.2307	1279516.0
2012-12-28 09:30:00	AAPL	Stock	18.2321	18.3439	18.1968	18.2414	53163152.0
2012-12-28 10:00:00	AAPL	Stock	18.2449	18.2964	18.2221	18.2521	24426444.0
2012-12-28 10:30:00	AAPL	Stock	18.2543	18.3743	18.2532	18.3404	33900972.0
2012-12-28 11:00:00	AAPL	Stock	18.3446	18.3511	18.2971	18.3111	18677736.0
2012-12-28 11:30:00	AAPL	Stock	18.3129	18.3182	18.2704	18.2936	13082972.0
2012-12-28 12:00:00	AAPL	Stock	18.2914	18.3318	18.2857	18.3104	14821548.0
2012-12-28 12:30:00	AAPL	Stock	18.3129	18.3214	18.2893	18.2946	10848236.0
2012-12-28 13:00:00	AAPL	Stock	18.2918	18.305	18.2611	18.292	12572896.0
2012-12-28 13:30:00	AAPL	Stock	18.2921	18.2967	18.2604	18.2715	13678168.0
2012-12-28 14:00:00	AAPL	Stock	18.2709	18.2793	18.2332	18.2583	19100116.0
2012-12-28 14:30:00	AAPL	Stock	18.2621	18.2768	18.2439	18.2582	13556984.0
2012-12-28 15:00:00	AAPL	Stock	18.258	18.3664	18.255	18.3143	29382864.0
2012-12-28 15:30:00	AAPL	Stock	18.3161	18.3371	18.1471	18.1939	73570028.0
2012-12-28 16:00:00	AAPL	Stock	18.2107	18.3169	18.1107	18.1357	9909816.0
2012-12-28 16:30:00	AAPL	Stock	18.1357	18.1996	18.0964	18.1232	1755768.0
2012-12-28 17:00:00	AAPL	Stock	18.1161	18.2253	18.115	18.1518	495852.0
2012-12-28 17:30:00	AAPL	Stock	18.15	18.1964	18.1468	18.1836	1170232.0
2012-12-28 18:00:00	AAPL	Stock	18.1875	18.1875	18.1525	18.1625	214144.0
2012-12-28 18:30:00	AAPL	Stock	18.1571	18.1593	18.1429	18.1429	187880.0
2012-12-28 19:00:00	AAPL	Stock	18.1518	18.1607	18.125	18.125	83748.0
2012-12-28 19:30:00	AAPL	Stock	18.1386	18.1854	18.1386	18.1854	145880.0
2012-12-28 04:00:00	MSFT	Stock	27.0	27.0	27.0	27.0	300.0
2012-12-28 07:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	427.0
2012-12-28 07:30:00	MSFT	Stock	26.8	26.8	26.8	26.8	3200.0
2012-12-28 08:00:00	MSFT	Stock	26.85	26.9	26.8	26.81	3800.0
2012-12-28 08:30:00	MSFT	Stock	26.85	26.85	26.8	26.81	3086.0
2012-12-28 09:00:00	MSFT	Stock	26.8	26.8	26.72	26.73	19564.0
2012-12-28 09:30:00	MSFT	Stock	26.73	26.9	26.7	26.82	2690126.0
2012-12-28 10:00:00	MSFT	Stock	26.82	26.83	26.7	26.743	2082871.0
2012-12-28 10:30:00	MSFT	Stock	26.744	26.85	26.73	26.77	2120399.0
2012-12-28 11:00:00	MSFT	Stock	26.78	26.82	26.75	26.79	1763868.0
2012-12-28 11:30:00	MSFT	Stock	26.78	26.82	26.77	26.786	1096685.0
2012-12-28 12:00:00	MSFT	Stock	26.78	26.805	26.75	26.76	1338603.0
2012-12-28 12:30:00	MSFT	Stock	26.765	26.8	26.75	26.76	1278880.0
2012-12-28 13:00:00	MSFT	Stock	26.76	26.78	26.75	26.77	1113527.0
2012-12-28 13:30:00	MSFT	Stock	26.77	26.77	26.72	26.74	1191788.0
2012-12-28 14:00:00	MSFT	Stock	26.74	26.75	26.68	26.69	1162151.0
2012-12-28 14:30:00	MSFT	Stock	26.682	26.76	26.67	26.75	1747434.0
2012-12-28 15:00:00	MSFT	Stock	26.75	26.805	26.74	26.742	1888623.0
2012-12-28 15:30:00	MSFT	Stock	26.745	26.77	26.55	26.55	6626821.0
2012-12-28 16:00:00	MSFT	Stock	26.55	26.797	26.47	26.5	1728796.0

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

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