PREVIEW / stock_30min / 2011-11-07

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-07.parquet
  size:    1.4 MB
  rows:    74,115
  symbols: 3,518

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
2011-11-07 04:00:00	AAPL	Stock	14.2146	14.2146	14.2146	14.2146	5600.0
2011-11-07 05:00:00	AAPL	Stock	14.1786	14.2143	14.1786	14.2143	5600.0
2011-11-07 07:00:00	AAPL	Stock	14.25	14.25	14.25	14.25	2800.0
2011-11-07 07:30:00	AAPL	Stock	14.2536	14.2861	14.2536	14.2696	112000.0
2011-11-07 08:00:00	AAPL	Stock	14.2843	14.2871	14.2493	14.2629	436044.0
2011-11-07 08:30:00	AAPL	Stock	14.2521	14.2604	14.2332	14.2536	185192.0
2011-11-07 09:00:00	AAPL	Stock	14.2536	14.3036	14.2464	14.2839	1035636.0
2011-11-07 09:30:00	AAPL	Stock	14.2832	14.2846	14.1864	14.2536	50476748.0
2011-11-07 10:00:00	AAPL	Stock	14.2539	14.2711	14.2082	14.2204	22537172.0
2011-11-07 10:30:00	AAPL	Stock	14.22	14.2321	14.1625	14.1704	32381132.0
2011-11-07 11:00:00	AAPL	Stock	14.1682	14.1875	14.1525	14.1675	24276672.0
2011-11-07 11:30:00	AAPL	Stock	14.1675	14.1886	14.1496	14.1736	12661068.0
2011-11-07 12:00:00	AAPL	Stock	14.1725	14.2085	14.1475	14.1629	13858068.0
2011-11-07 12:30:00	AAPL	Stock	14.1604	14.175	14.15	14.16	9229752.0
2011-11-07 13:00:00	AAPL	Stock	14.1607	14.2018	14.1584	14.2018	9426396.0
2011-11-07 13:30:00	AAPL	Stock	14.2012	14.25	14.1832	14.2359	14631512.0
2011-11-07 14:00:00	AAPL	Stock	14.2346	14.2607	14.2143	14.2454	14669620.0
2011-11-07 14:30:00	AAPL	Stock	14.2425	14.2696	14.2375	14.2593	12934488.0
2011-11-07 15:00:00	AAPL	Stock	14.2621	14.2839	14.2504	14.2546	15248184.0
2011-11-07 15:30:00	AAPL	Stock	14.2546	14.2857	14.2143	14.2775	24501624.0
2011-11-07 16:00:00	AAPL	Stock	14.2775	14.2843	14.2174	14.2679	5298804.0
2011-11-07 16:30:00	AAPL	Stock	14.2686	14.2732	14.265	14.2711	227304.0
2011-11-07 17:00:00	AAPL	Stock	14.2729	14.2854	14.27	14.2854	271180.0
2011-11-07 17:30:00	AAPL	Stock	14.2811	14.2893	14.2764	14.2854	243404.0
2011-11-07 18:00:00	AAPL	Stock	14.2982	14.2982	14.2761	14.2857	50960.0
2011-11-07 18:30:00	AAPL	Stock	14.2857	14.2857	14.2679	14.2786	73276.0
2011-11-07 19:00:00	AAPL	Stock	14.2857	14.2946	14.2843	14.2893	135968.0
2011-11-07 19:30:00	AAPL	Stock	14.2893	14.2893	14.275	14.2821	122500.0
2011-11-07 04:00:00	MSFT	Stock	26.35	26.35	26.15	26.2	2100.0
2011-11-07 04:30:00	MSFT	Stock	26.18	26.27	26.17	26.27	1200.0
2011-11-07 05:30:00	MSFT	Stock	26.17	26.17	26.17	26.17	200.0
2011-11-07 06:00:00	MSFT	Stock	26.14	26.14	26.14	26.14	300.0
2011-11-07 07:00:00	MSFT	Stock	26.11	26.11	26.11	26.11	300.0
2011-11-07 07:30:00	MSFT	Stock	26.23	26.3	26.21	26.25	4400.0
2011-11-07 08:00:00	MSFT	Stock	26.21	26.21	26.17	26.2	2480.0
2011-11-07 08:30:00	MSFT	Stock	26.19	26.23	26.12	26.15	8196.0
2011-11-07 09:00:00	MSFT	Stock	26.17	26.28	26.17	26.21	14934.0
2011-11-07 09:30:00	MSFT	Stock	26.2	26.57	26.18	26.56	4413231.0
2011-11-07 10:00:00	MSFT	Stock	26.565	26.58	26.35	26.38	2522835.0
2011-11-07 10:30:00	MSFT	Stock	26.38	26.38	26.19	26.22	3378897.0
2011-11-07 11:00:00	MSFT	Stock	26.21	26.3	26.18	26.22	2117538.0
2011-11-07 11:30:00	MSFT	Stock	26.21	26.265	26.19	26.225	1292562.0
2011-11-07 12:00:00	MSFT	Stock	26.22	26.29	26.14	26.145	1713391.0
2011-11-07 12:30:00	MSFT	Stock	26.14	26.16	26.13	26.145	980862.0
2011-11-07 13:00:00	MSFT	Stock	26.145	26.19	26.13	26.19	1571655.0
2011-11-07 13:30:00	MSFT	Stock	26.19	26.305	26.16	26.25	2494281.0
2011-11-07 14:00:00	MSFT	Stock	26.25	26.53	26.25	26.5	3299575.0
2011-11-07 14:30:00	MSFT	Stock	26.5	26.67	26.46	26.66	3262652.0
2011-11-07 15:00:00	MSFT	Stock	26.655	26.76	26.65	26.66	3638254.0
2011-11-07 15:30:00	MSFT	Stock	26.66	26.82	26.65	26.8	9315616.0

> showing 50 of 74,115 rows — these rows as CSV

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