PREVIEW / stock_30min / 2013-12-11

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-11.parquet
  size:    1.6 MB
  rows:    81,835
  symbols: 3,529

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-11 04:00:00	AAPL	Stock	20.1786	20.1896	20.1786	20.1896	15736.0
2013-12-11 04:30:00	AAPL	Stock	20.2079	20.2079	20.2079	20.2079	2800.0
2013-12-11 05:30:00	AAPL	Stock	20.2329	20.2329	20.2289	20.2289	5600.0
2013-12-11 06:00:00	AAPL	Stock	20.2204	20.2204	20.2014	20.2014	44800.0
2013-12-11 06:30:00	AAPL	Stock	20.2132	20.2136	20.1954	20.1954	57316.0
2013-12-11 07:00:00	AAPL	Stock	20.2021	20.2321	20.1464	20.1893	101780.0
2013-12-11 07:30:00	AAPL	Stock	20.22	20.2679	20.22	20.2679	100492.0
2013-12-11 08:00:00	AAPL	Stock	20.2696	20.3107	20.1786	20.3014	930748.0
2013-12-11 08:30:00	AAPL	Stock	20.2875	20.2875	20.2718	20.2729	208740.0
2013-12-11 09:00:00	AAPL	Stock	20.28	20.28	20.2321	20.2343	554092.0
2013-12-11 09:30:00	AAPL	Stock	20.2361	20.3918	20.2343	20.2989	51727900.0
2013-12-11 10:00:00	AAPL	Stock	20.2936	20.2954	20.1829	20.2525	29962856.0
2013-12-11 10:30:00	AAPL	Stock	20.255	20.3104	20.2454	20.2839	20413624.0
2013-12-11 11:00:00	AAPL	Stock	20.2802	20.2989	20.2029	20.2346	12006932.0
2013-12-11 11:30:00	AAPL	Stock	20.2346	20.2379	20.1944	20.2032	16326044.0
2013-12-11 12:00:00	AAPL	Stock	20.2018	20.2057	20.0997	20.1191	20177164.0
2013-12-11 12:30:00	AAPL	Stock	20.1189	20.1571	20.1129	20.1218	15065120.0
2013-12-11 13:00:00	AAPL	Stock	20.1218	20.1571	20.0614	20.0814	22270164.0
2013-12-11 13:30:00	AAPL	Stock	20.0761	20.1286	20.0639	20.1118	11278092.0
2013-12-11 14:00:00	AAPL	Stock	20.11	20.1107	20.0293	20.0625	15520876.0
2013-12-11 14:30:00	AAPL	Stock	20.0643	20.125	20.0464	20.055	13243048.0
2013-12-11 15:00:00	AAPL	Stock	20.0571	20.0829	20.0071	20.0335	15766352.0
2013-12-11 15:30:00	AAPL	Stock	20.0343	20.0586	19.9889	20.0407	29897140.0
2013-12-11 16:00:00	AAPL	Stock	20.0454	20.2342	20.0139	20.0368	23852164.0
2013-12-11 16:30:00	AAPL	Stock	20.0486	20.255	20.0443	20.0571	723408.0
2013-12-11 17:00:00	AAPL	Stock	20.0586	20.0693	20.0586	20.0693	66500.0
2013-12-11 17:30:00	AAPL	Stock	20.0643	20.0661	20.0486	20.0486	74788.0
2013-12-11 18:00:00	AAPL	Stock	20.0679	20.0714	20.0643	20.0714	57456.0
2013-12-11 18:30:00	AAPL	Stock	20.0714	20.0771	20.0589	20.0589	72968.0
2013-12-11 19:00:00	AAPL	Stock	20.0636	20.0679	20.0636	20.0679	85120.0
2013-12-11 19:30:00	AAPL	Stock	20.0661	20.0714	20.0554	20.0679	87752.0
2013-12-11 06:30:00	MSFT	Stock	38.15	38.15	38.15	38.15	1665.0
2013-12-11 07:00:00	MSFT	Stock	38.2	38.36	38.2	38.36	1100.0
2013-12-11 07:30:00	MSFT	Stock	38.3	38.3	38.3	38.3	100.0
2013-12-11 08:00:00	MSFT	Stock	38.3	38.32	38.3	38.32	350.0
2013-12-11 08:30:00	MSFT	Stock	38.24	38.28	38.22	38.23	36716.0
2013-12-11 09:00:00	MSFT	Stock	38.23	38.25	38.04	38.04	26053.0
2013-12-11 09:30:00	MSFT	Stock	38.06	38.3	37.86	37.95	4625252.0
2013-12-11 10:00:00	MSFT	Stock	37.95	37.95	37.68	37.69	2996629.0
2013-12-11 10:30:00	MSFT	Stock	37.7	37.78	37.66	37.675	2524613.0
2013-12-11 11:00:00	MSFT	Stock	37.675	37.74	37.66	37.73	1594676.0
2013-12-11 11:30:00	MSFT	Stock	37.73	37.73	37.57	37.6	2210021.0
2013-12-11 12:00:00	MSFT	Stock	37.605	37.61	37.39	37.45	3371102.0
2013-12-11 12:30:00	MSFT	Stock	37.44	37.53	37.39	37.45	1788845.0
2013-12-11 13:00:00	MSFT	Stock	37.45	37.7	37.45	37.63	2100849.0
2013-12-11 13:30:00	MSFT	Stock	37.63	37.67	37.61	37.66	1389533.0
2013-12-11 14:00:00	MSFT	Stock	37.665	37.67	37.6	37.665	1555960.0
2013-12-11 14:30:00	MSFT	Stock	37.67	37.67	37.6	37.61	1657247.0
2013-12-11 15:00:00	MSFT	Stock	37.61	37.66	37.58	37.59	2236512.0
2013-12-11 15:30:00	MSFT	Stock	37.59	37.64	37.55	37.605	5133026.0

> showing 50 of 81,835 rows — these rows as CSV

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