PREVIEW / stock_30min / 2012-12-12

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-12.parquet
  size:    1.4 MB
  rows:    77,047
  symbols: 3,500

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-12 04:00:00	AAPL	Stock	19.4436	19.5	19.4436	19.5	57988.0
2012-12-12 04:30:00	AAPL	Stock	19.5529	19.5529	19.5071	19.5143	42000.0
2012-12-12 05:00:00	AAPL	Stock	19.5018	19.5304	19.4907	19.5018	88872.0
2012-12-12 05:30:00	AAPL	Stock	19.5179	19.5211	19.4929	19.5143	81200.0
2012-12-12 06:00:00	AAPL	Stock	19.5036	19.5182	19.4643	19.4821	97720.0
2012-12-12 06:30:00	AAPL	Stock	19.4864	19.4918	19.4732	19.4893	117600.0
2012-12-12 07:00:00	AAPL	Stock	19.4893	19.5243	19.4761	19.5	456932.0
2012-12-12 07:30:00	AAPL	Stock	19.4836	19.5164	19.4732	19.5	315532.0
2012-12-12 08:00:00	AAPL	Stock	19.5	19.6221	19.4768	19.5725	4220328.0
2012-12-12 08:30:00	AAPL	Stock	19.5721	19.5871	19.5286	19.5607	2133740.0
2012-12-12 09:00:00	AAPL	Stock	19.5643	19.5879	19.5289	19.5607	2496088.0
2012-12-12 09:30:00	AAPL	Stock	19.5607	19.5714	19.2954	19.3239	82463500.0
2012-12-12 10:00:00	AAPL	Stock	19.3239	19.3571	19.2354	19.2871	51204748.0
2012-12-12 10:30:00	AAPL	Stock	19.2921	19.3086	19.1525	19.2161	40486880.0
2012-12-12 11:00:00	AAPL	Stock	19.2104	19.325	19.1679	19.2837	33361608.0
2012-12-12 11:30:00	AAPL	Stock	19.2843	19.2996	19.1904	19.1996	16921660.0
2012-12-12 12:00:00	AAPL	Stock	19.2	19.2904	19.1968	19.2643	12256720.0
2012-12-12 12:30:00	AAPL	Stock	19.2682	19.4421	19.2189	19.4082	51908892.0
2012-12-12 13:00:00	AAPL	Stock	19.4075	19.4164	19.3	19.3661	29011360.0
2012-12-12 13:30:00	AAPL	Stock	19.3657	19.4236	19.3325	19.3478	18570888.0
2012-12-12 14:00:00	AAPL	Stock	19.3557	19.3764	19.2843	19.2879	21746844.0
2012-12-12 14:30:00	AAPL	Stock	19.2929	19.3464	19.2554	19.2925	22263864.0
2012-12-12 15:00:00	AAPL	Stock	19.295	19.3125	19.2007	19.2214	29095108.0
2012-12-12 15:30:00	AAPL	Stock	19.2143	19.2768	19.1557	19.2471	51531060.0
2012-12-12 16:00:00	AAPL	Stock	19.26	19.438	19.2143	19.3223	7341096.0
2012-12-12 16:30:00	AAPL	Stock	19.2475	19.2671	19.2242	19.25	289632.0
2012-12-12 17:00:00	AAPL	Stock	19.2536	19.2607	19.2475	19.2607	113036.0
2012-12-12 17:30:00	AAPL	Stock	19.2625	19.2639	19.2507	19.2529	78456.0
2012-12-12 18:00:00	AAPL	Stock	19.2589	19.2739	19.2589	19.2739	117600.0
2012-12-12 18:30:00	AAPL	Stock	19.2739	19.2789	19.2657	19.2782	90944.0
2012-12-12 19:00:00	AAPL	Stock	19.2768	19.2811	19.2686	19.2732	97580.0
2012-12-12 19:30:00	AAPL	Stock	19.275	19.2768	19.2679	19.2718	224308.0
2012-12-12 08:00:00	MSFT	Stock	27.39	27.47	27.38	27.45	3628.0
2012-12-12 08:30:00	MSFT	Stock	27.48	27.48	27.45	27.47	6550.0
2012-12-12 09:00:00	MSFT	Stock	27.32	27.56	27.32	27.52	90029.0
2012-12-12 09:30:00	MSFT	Stock	27.51	27.62	27.43	27.54	5042841.0
2012-12-12 10:00:00	MSFT	Stock	27.545	27.55	27.44	27.485	3005378.0
2012-12-12 10:30:00	MSFT	Stock	27.49	27.5	27.32	27.345	2678658.0
2012-12-12 11:00:00	MSFT	Stock	27.34	27.41	27.33	27.4	2269025.0
2012-12-12 11:30:00	MSFT	Stock	27.4	27.44	27.34	27.35	2113032.0
2012-12-12 12:00:00	MSFT	Stock	27.35	27.36	27.31	27.34	2665464.0
2012-12-12 12:30:00	MSFT	Stock	27.345	27.55	27.3	27.49	7333634.0
2012-12-12 13:00:00	MSFT	Stock	27.5	27.51	27.39	27.44	2189527.0
2012-12-12 13:30:00	MSFT	Stock	27.45	27.49	27.39	27.43	1624667.0
2012-12-12 14:00:00	MSFT	Stock	27.42	27.45	27.29	27.305	2159061.0
2012-12-12 14:30:00	MSFT	Stock	27.3	27.33	27.25	27.26	2135128.0
2012-12-12 15:00:00	MSFT	Stock	27.27	27.27	27.15	27.175	2645515.0
2012-12-12 15:30:00	MSFT	Stock	27.17	27.24	27.08	27.24	5765420.0
2012-12-12 16:00:00	MSFT	Stock	27.23	27.47	27.2	27.396	1177699.0
2012-12-12 16:30:00	MSFT	Stock	27.24	27.391	27.17	27.2	123994.0

> showing 50 of 77,047 rows — these rows as CSV

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