PREVIEW / stock_30min / 2013-10-03

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-03.parquet
  size:    1.5 MB
  rows:    78,971
  symbols: 3,519

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-10-03 04:00:00	AAPL	Stock	17.3982	17.4107	17.3982	17.4107	14000.0
2013-10-03 05:30:00	AAPL	Stock	17.4286	17.4286	17.4107	17.4107	20720.0
2013-10-03 06:00:00	AAPL	Stock	17.4107	17.4107	17.4107	17.4107	5040.0
2013-10-03 06:30:00	AAPL	Stock	17.4286	17.4354	17.4286	17.4354	11200.0
2013-10-03 07:00:00	AAPL	Stock	17.4561	17.4586	17.4339	17.4571	64820.0
2013-10-03 07:30:00	AAPL	Stock	17.4571	17.5118	17.4571	17.5	189028.0
2013-10-03 08:00:00	AAPL	Stock	17.4964	17.5339	17.4354	17.5089	676200.0
2013-10-03 08:30:00	AAPL	Stock	17.5054	17.5314	17.4968	17.525	502628.0
2013-10-03 09:00:00	AAPL	Stock	17.5196	17.5532	17.5007	17.5179	1218112.0
2013-10-03 09:30:00	AAPL	Stock	17.5182	17.5839	17.4146	17.4289	43980272.0
2013-10-03 10:00:00	AAPL	Stock	17.43	17.43	17.2911	17.3184	39967592.0
2013-10-03 10:30:00	AAPL	Stock	17.3136	17.3532	17.3011	17.3446	18891012.0
2013-10-03 11:00:00	AAPL	Stock	17.3393	17.3571	17.3086	17.3139	20462148.0
2013-10-03 11:30:00	AAPL	Stock	17.3154	17.3346	17.1692	17.1735	32796204.0
2013-10-03 12:00:00	AAPL	Stock	17.1721	17.2607	17.1693	17.2571	20948620.0
2013-10-03 12:30:00	AAPL	Stock	17.2546	17.2946	17.2157	17.2679	18752524.0
2013-10-03 13:00:00	AAPL	Stock	17.2689	17.2957	17.2321	17.2757	16012584.0
2013-10-03 13:30:00	AAPL	Stock	17.2793	17.3204	17.2589	17.3143	15123080.0
2013-10-03 14:00:00	AAPL	Stock	17.3093	17.3139	17.2357	17.2864	14711928.0
2013-10-03 14:30:00	AAPL	Stock	17.2886	17.2907	17.2489	17.2507	8389556.0
2013-10-03 15:00:00	AAPL	Stock	17.2525	17.2796	17.2268	17.2775	9913680.0
2013-10-03 15:30:00	AAPL	Stock	17.2761	17.2795	17.2425	17.2639	22454040.0
2013-10-03 16:00:00	AAPL	Stock	17.2696	17.4099	17.2504	17.2536	6445488.0
2013-10-03 16:30:00	AAPL	Stock	17.4857	17.4857	17.2429	17.2429	20957636.0
2013-10-03 17:00:00	AAPL	Stock	17.2429	17.2639	17.2429	17.2496	151872.0
2013-10-03 17:30:00	AAPL	Stock	17.25	17.2639	17.2464	17.2604	162008.0
2013-10-03 18:00:00	AAPL	Stock	17.2546	17.2586	17.25	17.25	71904.0
2013-10-03 18:30:00	AAPL	Stock	17.2464	17.25	17.2446	17.2446	39200.0
2013-10-03 19:00:00	AAPL	Stock	17.2432	17.25	17.2432	17.25	72072.0
2013-10-03 19:30:00	AAPL	Stock	17.2493	17.2554	17.2446	17.2536	53844.0
2013-10-03 07:00:00	MSFT	Stock	33.72	33.77	33.72	33.77	2800.0
2013-10-03 07:30:00	MSFT	Stock	33.75	33.82	33.69	33.82	2940.0
2013-10-03 08:00:00	MSFT	Stock	33.77	33.81	33.77	33.8	6471.0
2013-10-03 08:30:00	MSFT	Stock	33.8	33.82	33.77	33.82	5637.0
2013-10-03 09:00:00	MSFT	Stock	33.82	34.0	33.82	33.89	44814.0
2013-10-03 09:30:00	MSFT	Stock	33.88	34.0	33.82	33.96	3667680.0
2013-10-03 10:00:00	MSFT	Stock	33.955	33.99	33.81	33.825	3780954.0
2013-10-03 10:30:00	MSFT	Stock	33.82	33.845	33.62	33.8	2296734.0
2013-10-03 11:00:00	MSFT	Stock	33.79	33.95	33.73	33.73	2587405.0
2013-10-03 11:30:00	MSFT	Stock	33.73	33.77	33.44	33.47	3463211.0
2013-10-03 12:00:00	MSFT	Stock	33.47	33.625	33.42	33.61	1929826.0
2013-10-03 12:30:00	MSFT	Stock	33.6	33.61	33.42	33.575	1893311.0
2013-10-03 13:00:00	MSFT	Stock	33.573	33.79	33.53	33.78	2523046.0
2013-10-03 13:30:00	MSFT	Stock	33.79	33.83	33.67	33.775	1717227.0
2013-10-03 14:00:00	MSFT	Stock	33.77	33.79	33.5	33.69	2607402.0
2013-10-03 14:30:00	MSFT	Stock	33.69	33.73	33.6	33.66	1508194.0
2013-10-03 15:00:00	MSFT	Stock	33.665	33.71	33.62	33.71	2004039.0
2013-10-03 15:30:00	MSFT	Stock	33.705	33.87	33.66	33.86	6063945.0
2013-10-03 16:00:00	MSFT	Stock	33.87	34.04	33.623	33.87	1621751.0
2013-10-03 16:30:00	MSFT	Stock	33.721	33.75	33.68	33.74	11841.0

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

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