PREVIEW / stock_30min / 2013-09-11

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-11.parquet
  size:    1.5 MB
  rows:    78,798
  symbols: 3,519

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-09-11 04:00:00	AAPL	Stock	17.6429	17.6429	17.3354	17.3354	92344.0
2013-09-11 04:30:00	AAPL	Stock	17.3214	17.3357	17.2643	17.3161	181832.0
2013-09-11 05:00:00	AAPL	Stock	17.315	17.3214	17.2846	17.2946	311752.0
2013-09-11 05:30:00	AAPL	Stock	17.3036	17.3421	17.3036	17.3111	210364.0
2013-09-11 06:00:00	AAPL	Stock	17.3229	17.3471	17.2454	17.2639	496216.0
2013-09-11 06:30:00	AAPL	Stock	17.2589	17.2679	17.1996	17.2136	599536.0
2013-09-11 07:00:00	AAPL	Stock	17.2214	17.2496	17.0957	17.1036	2228940.0
2013-09-11 07:30:00	AAPL	Stock	17.1036	17.1125	16.8857	16.9554	9131500.0
2013-09-11 08:00:00	AAPL	Stock	16.95	17.0536	16.8857	16.9604	11899188.0
2013-09-11 08:30:00	AAPL	Stock	16.9589	16.9811	16.8664	16.8861	11707752.0
2013-09-11 09:00:00	AAPL	Stock	16.8814	16.9018	16.6679	16.6857	21068516.0
2013-09-11 09:30:00	AAPL	Stock	16.6936	16.9175	16.6004	16.7483	247316468.0
2013-09-11 10:00:00	AAPL	Stock	16.7479	16.8443	16.6543	16.6824	95025700.0
2013-09-11 10:30:00	AAPL	Stock	16.6818	16.7061	16.61	16.625	80809988.0
2013-09-11 11:00:00	AAPL	Stock	16.6289	16.7243	16.6071	16.6382	59750516.0
2013-09-11 11:30:00	AAPL	Stock	16.6368	16.6653	16.6143	16.6332	36173088.0
2013-09-11 12:00:00	AAPL	Stock	16.6343	16.7257	16.6321	16.6536	40247200.0
2013-09-11 12:30:00	AAPL	Stock	16.6532	16.7	16.6268	16.6954	28114464.0
2013-09-11 13:00:00	AAPL	Stock	16.6961	16.7654	16.6818	16.7482	35349216.0
2013-09-11 13:30:00	AAPL	Stock	16.7482	16.805	16.7411	16.7793	29422344.0
2013-09-11 14:00:00	AAPL	Stock	16.7814	16.8232	16.7348	16.7629	27238624.0
2013-09-11 14:30:00	AAPL	Stock	16.7621	16.8143	16.7568	16.7725	21070560.0
2013-09-11 15:00:00	AAPL	Stock	16.7743	16.7857	16.6604	16.6709	38938284.0
2013-09-11 15:30:00	AAPL	Stock	16.6747	16.7307	16.6657	16.7082	64386504.0
2013-09-11 16:00:00	AAPL	Stock	16.7082	16.8238	16.6629	16.7082	22238720.0
2013-09-11 16:30:00	AAPL	Stock	16.7536	16.7714	16.7082	16.7082	1619296.0
2013-09-11 17:00:00	AAPL	Stock	16.7714	16.7857	16.75	16.7596	1115072.0
2013-09-11 17:30:00	AAPL	Stock	16.7596	16.7661	16.7082	16.7661	173544.0
2013-09-11 18:00:00	AAPL	Stock	16.7625	16.7786	16.7425	16.7425	285152.0
2013-09-11 18:30:00	AAPL	Stock	16.7361	16.7429	16.7143	16.7421	219492.0
2013-09-11 19:00:00	AAPL	Stock	16.7443	16.7607	16.7411	16.7439	177744.0
2013-09-11 19:30:00	AAPL	Stock	16.7557	16.7682	16.7536	16.7682	438620.0
2013-09-11 06:00:00	MSFT	Stock	32.5	32.5	32.5	32.5	100.0
2013-09-11 06:30:00	MSFT	Stock	32.5	32.5	32.5	32.5	100.0
2013-09-11 08:00:00	MSFT	Stock	32.44	32.52	32.35	32.5	15817.0
2013-09-11 08:30:00	MSFT	Stock	32.45	32.5	32.41	32.41	12000.0
2013-09-11 09:00:00	MSFT	Stock	32.4	32.62	32.4	32.58	57825.0
2013-09-11 09:30:00	MSFT	Stock	32.57	32.8	32.53	32.7	7269609.0
2013-09-11 10:00:00	MSFT	Stock	32.69	32.77	32.66	32.75	3817842.0
2013-09-11 10:30:00	MSFT	Stock	32.755	32.84	32.71	32.835	3278099.0
2013-09-11 11:00:00	MSFT	Stock	32.835	32.93	32.8	32.93	2683510.0
2013-09-11 11:30:00	MSFT	Stock	32.93	32.93	32.77	32.85	2503750.0
2013-09-11 12:00:00	MSFT	Stock	32.845	32.9	32.775	32.83	2043618.0
2013-09-11 12:30:00	MSFT	Stock	32.84	32.86	32.77	32.854	1052575.0
2013-09-11 13:00:00	MSFT	Stock	32.86	32.86	32.8	32.82	1426323.0
2013-09-11 13:30:00	MSFT	Stock	32.82	32.87	32.79	32.801	1385926.0
2013-09-11 14:00:00	MSFT	Stock	32.81	32.83	32.78	32.8	1218412.0
2013-09-11 14:30:00	MSFT	Stock	32.797	32.86	32.79	32.805	1357104.0
2013-09-11 15:00:00	MSFT	Stock	32.8	32.82	32.78	32.788	1827359.0
2013-09-11 15:30:00	MSFT	Stock	32.78	32.81	32.72	32.75	4095353.0

> showing 50 of 78,798 rows — these rows as CSV

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