PREVIEW / stock_30min / 2014-03-27

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-27.parquet
  size:    1.6 MB
  rows:    83,731
  symbols: 3,528

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
2014-03-27 05:30:00	AAPL	Stock	19.25	19.25	19.25	19.25	12600.0
2014-03-27 07:00:00	AAPL	Stock	19.3129	19.3136	19.28	19.3054	75432.0
2014-03-27 07:30:00	AAPL	Stock	19.31	19.3111	19.2821	19.2821	46760.0
2014-03-27 08:00:00	AAPL	Stock	19.3146	19.3146	19.2264	19.2782	406056.0
2014-03-27 08:30:00	AAPL	Stock	19.2775	19.2839	19.2361	19.2643	429296.0
2014-03-27 09:00:00	AAPL	Stock	19.2696	19.3014	19.2643	19.2957	312844.0
2014-03-27 09:30:00	AAPL	Stock	19.2862	19.33	19.1607	19.2639	34106212.0
2014-03-27 10:00:00	AAPL	Stock	19.2607	19.3393	19.2271	19.2557	21089404.0
2014-03-27 10:30:00	AAPL	Stock	19.2561	19.2754	19.1907	19.2496	13126204.0
2014-03-27 11:00:00	AAPL	Stock	19.25	19.2679	19.1893	19.1937	7450968.0
2014-03-27 11:30:00	AAPL	Stock	19.1939	19.1941	19.1393	19.1641	13288772.0
2014-03-27 12:00:00	AAPL	Stock	19.1682	19.1961	19.1225	19.1848	12451796.0
2014-03-27 12:30:00	AAPL	Stock	19.1882	19.1943	19.1407	19.1504	6961976.0
2014-03-27 13:00:00	AAPL	Stock	19.1518	19.1993	19.1418	19.1593	9159276.0
2014-03-27 13:30:00	AAPL	Stock	19.1664	19.1743	19.1282	19.1507	6637064.0
2014-03-27 14:00:00	AAPL	Stock	19.1504	19.1986	19.1114	19.1971	10590132.0
2014-03-27 14:30:00	AAPL	Stock	19.1954	19.2386	19.1859	19.1859	11386676.0
2014-03-27 15:00:00	AAPL	Stock	19.1868	19.2093	19.1518	19.1964	9730000.0
2014-03-27 15:30:00	AAPL	Stock	19.1921	19.2311	19.1854	19.1937	17981432.0
2014-03-27 16:00:00	AAPL	Stock	19.195	19.2071	19.1804	19.1911	7442148.0
2014-03-27 16:30:00	AAPL	Stock	19.195	19.1957	19.1842	19.1911	693756.0
2014-03-27 17:00:00	AAPL	Stock	19.195	19.1964	19.195	19.1964	36400.0
2014-03-27 17:30:00	AAPL	Stock	19.2064	19.2064	19.195	19.195	310044.0
2014-03-27 18:00:00	AAPL	Stock	19.2043	19.2054	19.195	19.2	212128.0
2014-03-27 18:30:00	AAPL	Stock	19.2054	19.2054	19.2054	19.2054	36400.0
2014-03-27 19:00:00	AAPL	Stock	19.2068	19.2129	19.2068	19.2089	11200.0
2014-03-27 19:30:00	AAPL	Stock	19.2089	19.2236	19.2089	19.2236	53900.0
2014-03-27 07:00:00	MSFT	Stock	39.97	39.97	39.81	39.81	8700.0
2014-03-27 07:30:00	MSFT	Stock	39.88	39.88	39.88	39.88	400.0
2014-03-27 08:00:00	MSFT	Stock	39.94	39.94	39.79	39.81	15284.0
2014-03-27 08:30:00	MSFT	Stock	39.79	39.79	39.71	39.78	5303.0
2014-03-27 09:00:00	MSFT	Stock	39.79	39.89	39.7	39.72	163965.0
2014-03-27 09:30:00	MSFT	Stock	39.74	39.97	39.58	39.875	4176101.0
2014-03-27 10:00:00	MSFT	Stock	39.87	39.88	39.61	39.79	3046963.0
2014-03-27 10:30:00	MSFT	Stock	39.795	39.81	39.62	39.71	1204549.0
2014-03-27 11:00:00	MSFT	Stock	39.705	39.73	39.54	39.543	1343572.0
2014-03-27 11:30:00	MSFT	Stock	39.54	39.6	39.4	39.57	2061922.0
2014-03-27 12:00:00	MSFT	Stock	39.58	39.66	39.44	39.634	1152763.0
2014-03-27 12:30:00	MSFT	Stock	39.64	39.69	39.47	39.608	1948651.0
2014-03-27 13:00:00	MSFT	Stock	39.6	39.745	39.59	39.641	1964572.0
2014-03-27 13:30:00	MSFT	Stock	39.645	39.69	39.42	39.45	3288501.0
2014-03-27 14:00:00	MSFT	Stock	39.45	39.56	39.36	39.469	2220385.0
2014-03-27 14:30:00	MSFT	Stock	39.47	39.51	39.42	39.425	1546071.0
2014-03-27 15:00:00	MSFT	Stock	39.42	39.5	39.41	39.46	2214357.0
2014-03-27 15:30:00	MSFT	Stock	39.46	39.54	39.34	39.36	5786283.0
2014-03-27 16:00:00	MSFT	Stock	39.36	39.569	39.35	39.4	1547019.0
2014-03-27 16:30:00	MSFT	Stock	39.4	39.41	39.3	39.3	229823.0
2014-03-27 17:00:00	MSFT	Stock	39.3	39.66	39.26	39.59	41085.0
2014-03-27 17:30:00	MSFT	Stock	39.59	39.62	39.359	39.61	125754.0
2014-03-27 18:00:00	MSFT	Stock	39.62	39.64	39.59	39.59	5423.0

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

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