PREVIEW / stock_30min / 2013-07-30

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-30.parquet
  size:    1.5 MB
  rows:    79,134
  symbols: 3,537

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-07-30 04:00:00	AAPL	Stock	16.0461	16.0536	16.0193	16.0193	11200.0
2013-07-30 06:30:00	AAPL	Stock	16.0289	16.0289	16.0289	16.0289	16968.0
2013-07-30 07:00:00	AAPL	Stock	16.0357	16.0893	16.0357	16.075	236404.0
2013-07-30 07:30:00	AAPL	Stock	16.0793	16.0889	16.0643	16.0679	333732.0
2013-07-30 08:00:00	AAPL	Stock	16.0643	16.0957	15.9643	16.0954	984620.0
2013-07-30 08:30:00	AAPL	Stock	16.0921	16.0961	16.0714	16.0764	860244.0
2013-07-30 09:00:00	AAPL	Stock	16.0768	16.1	16.0625	16.0696	1040844.0
2013-07-30 09:30:00	AAPL	Stock	16.07	16.1721	16.0439	16.1289	54832484.0
2013-07-30 10:00:00	AAPL	Stock	16.1307	16.2029	16.1132	16.1668	28388668.0
2013-07-30 10:30:00	AAPL	Stock	16.1668	16.2261	16.1611	16.2018	22817032.0
2013-07-30 11:00:00	AAPL	Stock	16.2007	16.2494	16.1807	16.2296	22488172.0
2013-07-30 11:30:00	AAPL	Stock	16.2275	16.3268	16.2261	16.3109	29408568.0
2013-07-30 12:00:00	AAPL	Stock	16.3118	16.3121	16.24	16.2632	22980608.0
2013-07-30 12:30:00	AAPL	Stock	16.2654	16.3121	16.2325	16.2879	15408792.0
2013-07-30 13:00:00	AAPL	Stock	16.288	16.3036	16.1989	16.2096	15463392.0
2013-07-30 13:30:00	AAPL	Stock	16.2089	16.2296	16.1929	16.2071	13952344.0
2013-07-30 14:00:00	AAPL	Stock	16.2071	16.2386	16.19	16.2343	11097912.0
2013-07-30 14:30:00	AAPL	Stock	16.2343	16.2673	16.2139	16.2371	13563676.0
2013-07-30 15:00:00	AAPL	Stock	16.2361	16.2657	16.2218	16.2575	10949568.0
2013-07-30 15:30:00	AAPL	Stock	16.2582	16.2589	16.1804	16.19	29460592.0
2013-07-30 16:00:00	AAPL	Stock	16.19	16.3068	15.9695	16.1964	10431568.0
2013-07-30 16:30:00	AAPL	Stock	16.1964	16.205	16.19	16.2018	145068.0
2013-07-30 17:00:00	AAPL	Stock	16.19	16.2032	16.19	16.1964	123592.0
2013-07-30 17:30:00	AAPL	Stock	16.1946	16.2036	16.1943	16.2036	34188.0
2013-07-30 18:00:00	AAPL	Stock	16.2032	16.2143	16.19	16.19	262136.0
2013-07-30 18:30:00	AAPL	Stock	16.1979	16.2057	16.1979	16.2057	45752.0
2013-07-30 19:00:00	AAPL	Stock	16.1986	16.1986	16.1986	16.1986	2800.0
2013-07-30 19:30:00	AAPL	Stock	16.2068	16.2068	16.1986	16.2	81844.0
2013-07-30 06:00:00	MSFT	Stock	31.55	31.55	31.55	31.55	1000.0
2013-07-30 07:00:00	MSFT	Stock	31.62	31.62	31.62	31.62	307.0
2013-07-30 07:30:00	MSFT	Stock	31.65	31.71	31.65	31.68	5380.0
2013-07-30 08:00:00	MSFT	Stock	31.59	31.7	31.59	31.64	5668.0
2013-07-30 08:30:00	MSFT	Stock	31.64	31.68	31.63	31.68	5107.0
2013-07-30 09:00:00	MSFT	Stock	31.64	31.78	31.6	31.78	14386.0
2013-07-30 09:30:00	MSFT	Stock	31.78	31.79	31.55	31.56	3684774.0
2013-07-30 10:00:00	MSFT	Stock	31.56	31.75	31.56	31.715	3122315.0
2013-07-30 10:30:00	MSFT	Stock	31.71	31.728	31.66	31.72	3291346.0
2013-07-30 11:00:00	MSFT	Stock	31.715	31.87	31.705	31.87	3761051.0
2013-07-30 11:30:00	MSFT	Stock	31.865	32.12	31.86	32.025	6116287.0
2013-07-30 12:00:00	MSFT	Stock	32.025	32.03	31.84	31.93	2494605.0
2013-07-30 12:30:00	MSFT	Stock	31.93	32.0	31.83	31.84	2660139.0
2013-07-30 13:00:00	MSFT	Stock	31.846	31.9	31.75	31.755	1513919.0
2013-07-30 13:30:00	MSFT	Stock	31.75	31.76	31.66	31.71	2202469.0
2013-07-30 14:00:00	MSFT	Stock	31.71	31.75	31.69	31.746	2078752.0
2013-07-30 14:30:00	MSFT	Stock	31.75	31.78	31.7	31.74	2254741.0
2013-07-30 15:00:00	MSFT	Stock	31.73	31.87	31.71	31.855	2488460.0
2013-07-30 15:30:00	MSFT	Stock	31.86	31.9	31.82	31.865	5632456.0
2013-07-30 16:00:00	MSFT	Stock	31.85	32.0	31.747	31.85	2827055.0
2013-07-30 16:30:00	MSFT	Stock	31.85	31.93	31.85	31.86	33458.0
2013-07-30 17:00:00	MSFT	Stock	31.85	31.85	31.85	31.85	7294.0

> showing 50 of 79,134 rows — these rows as CSV

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