PREVIEW / stock_30min / 2013-12-23

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-23.parquet
  size:    1.6 MB
  rows:    83,247
  symbols: 3,543

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-23 04:00:00	AAPL	Stock	19.7861	20.3446	19.7861	20.1964	354928.0
2013-12-23 04:30:00	AAPL	Stock	20.2014	20.2032	20.1768	20.1846	405160.0
2013-12-23 05:00:00	AAPL	Stock	20.2118	20.2607	20.2118	20.25	62972.0
2013-12-23 05:30:00	AAPL	Stock	20.2493	20.3036	20.2493	20.3036	135576.0
2013-12-23 06:00:00	AAPL	Stock	20.3304	20.3482	20.2954	20.3461	191296.0
2013-12-23 06:30:00	AAPL	Stock	20.3479	20.3479	20.2975	20.2975	375592.0
2013-12-23 07:00:00	AAPL	Stock	20.2911	20.4654	20.2911	20.3036	2635192.0
2013-12-23 07:30:00	AAPL	Stock	20.3021	20.3446	20.2107	20.2521	2510228.0
2013-12-23 08:00:00	AAPL	Stock	20.2729	20.4643	20.1786	20.2543	4682468.0
2013-12-23 08:30:00	AAPL	Stock	20.2496	20.285	20.2393	20.2804	2625308.0
2013-12-23 09:00:00	AAPL	Stock	20.2836	20.2929	20.2271	20.2814	5088636.0
2013-12-23 09:30:00	AAPL	Stock	20.2857	20.2971	20.0986	20.2432	110518436.0
2013-12-23 10:00:00	AAPL	Stock	20.2429	20.25	20.1496	20.1571	45689700.0
2013-12-23 10:30:00	AAPL	Stock	20.1568	20.2143	20.1275	20.2122	27940164.0
2013-12-23 11:00:00	AAPL	Stock	20.2121	20.2407	20.1907	20.2172	18837112.0
2013-12-23 11:30:00	AAPL	Stock	20.2171	20.2296	20.1814	20.2112	14369208.0
2013-12-23 12:00:00	AAPL	Stock	20.2125	20.2539	20.1946	20.2443	18142740.0
2013-12-23 12:30:00	AAPL	Stock	20.2448	20.2831	20.2414	20.2483	16775640.0
2013-12-23 13:00:00	AAPL	Stock	20.2479	20.2839	20.2357	20.2825	11557392.0
2013-12-23 13:30:00	AAPL	Stock	20.2836	20.2882	20.2321	20.2421	16502976.0
2013-12-23 14:00:00	AAPL	Stock	20.2439	20.3179	20.2032	20.3061	24857840.0
2013-12-23 14:30:00	AAPL	Stock	20.3029	20.3571	20.3029	20.3406	26399520.0
2013-12-23 15:00:00	AAPL	Stock	20.3379	20.3807	20.3139	20.3711	26241964.0
2013-12-23 15:30:00	AAPL	Stock	20.3693	20.3829	20.3289	20.3654	42669228.0
2013-12-23 16:00:00	AAPL	Stock	20.3604	20.3714	20.2495	20.3571	10520356.0
2013-12-23 16:30:00	AAPL	Stock	20.3604	20.3604	20.1988	20.3511	2223928.0
2013-12-23 17:00:00	AAPL	Stock	20.3518	20.3671	20.3518	20.3625	391832.0
2013-12-23 17:30:00	AAPL	Stock	20.3614	20.3621	20.35	20.3571	178556.0
2013-12-23 18:00:00	AAPL	Stock	20.3596	20.3657	20.3536	20.3571	255640.0
2013-12-23 18:30:00	AAPL	Stock	20.3571	20.3571	20.3571	20.3571	25788.0
2013-12-23 19:00:00	AAPL	Stock	20.35	20.365	20.3489	20.3607	86492.0
2013-12-23 19:30:00	AAPL	Stock	20.3643	20.3661	20.3482	20.3625	305928.0
2013-12-23 04:00:00	MSFT	Stock	37.0	37.12	37.0	37.12	585.0
2013-12-23 05:00:00	MSFT	Stock	37.08	37.08	36.83	36.83	500.0
2013-12-23 07:00:00	MSFT	Stock	36.91	36.91	36.91	36.91	431.0
2013-12-23 08:00:00	MSFT	Stock	36.98	37.02	36.9	37.02	7899.0
2013-12-23 08:30:00	MSFT	Stock	37.02	37.03	37.0	37.0	6740.0
2013-12-23 09:00:00	MSFT	Stock	37.0	37.02	36.88	36.88	23200.0
2013-12-23 09:30:00	MSFT	Stock	36.81	36.89	36.62	36.65	2904435.0
2013-12-23 10:00:00	MSFT	Stock	36.65	36.66	36.565	36.6	1804365.0
2013-12-23 10:30:00	MSFT	Stock	36.6	36.67	36.58	36.66	1517183.0
2013-12-23 11:00:00	MSFT	Stock	36.655	36.69	36.6	36.66	1817072.0
2013-12-23 11:30:00	MSFT	Stock	36.655	36.68	36.64	36.644	1784624.0
2013-12-23 12:00:00	MSFT	Stock	36.65	36.75	36.61	36.72	1381287.0
2013-12-23 12:30:00	MSFT	Stock	36.729	36.73	36.69	36.7	1201866.0
2013-12-23 13:00:00	MSFT	Stock	36.7	36.71	36.62	36.62	876200.0
2013-12-23 13:30:00	MSFT	Stock	36.625	36.66	36.56	36.576	1103300.0
2013-12-23 14:00:00	MSFT	Stock	36.57	36.6	36.55	36.567	1200348.0
2013-12-23 14:30:00	MSFT	Stock	36.565	36.67	36.56	36.61	795507.0
2013-12-23 15:00:00	MSFT	Stock	36.616	36.63	36.58	36.615	1214185.0

> showing 50 of 83,247 rows — these rows as CSV

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