PREVIEW / stock_30min / 2014-04-23

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-23.parquet
  size:    1.6 MB
  rows:    82,668
  symbols: 3,549

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-04-23 05:00:00	AAPL	Stock	18.975	18.975	18.975	18.975	3948.0
2014-04-23 07:00:00	AAPL	Stock	18.9804	18.9875	18.9679	18.9804	50400.0
2014-04-23 07:30:00	AAPL	Stock	18.9732	18.975	18.9204	18.9214	63112.0
2014-04-23 08:00:00	AAPL	Stock	18.9196	18.9821	18.9107	18.9196	331520.0
2014-04-23 08:30:00	AAPL	Stock	18.9125	18.9532	18.9107	18.9379	84000.0
2014-04-23 09:00:00	AAPL	Stock	18.9364	18.9364	18.8893	18.8979	363048.0
2014-04-23 09:30:00	AAPL	Stock	18.895	18.9689	18.8482	18.9193	29931048.0
2014-04-23 10:00:00	AAPL	Stock	18.9171	18.9193	18.8607	18.8964	16013900.0
2014-04-23 10:30:00	AAPL	Stock	18.8982	18.9221	18.875	18.9046	12441968.0
2014-04-23 11:00:00	AAPL	Stock	18.9046	18.9164	18.8736	18.8904	13547912.0
2014-04-23 11:30:00	AAPL	Stock	18.8889	18.8989	18.8686	18.8782	9809128.0
2014-04-23 12:00:00	AAPL	Stock	18.8793	18.8857	18.8657	18.8854	11584328.0
2014-04-23 12:30:00	AAPL	Stock	18.8836	18.8996	18.8782	18.8832	7548520.0
2014-04-23 13:00:00	AAPL	Stock	18.8832	18.8913	18.83	18.8418	13251504.0
2014-04-23 13:30:00	AAPL	Stock	18.8429	18.8493	18.7936	18.8189	12340244.0
2014-04-23 14:00:00	AAPL	Stock	18.8182	18.8507	18.8079	18.8122	12224156.0
2014-04-23 14:30:00	AAPL	Stock	18.8154	18.8304	18.7871	18.8154	12230204.0
2014-04-23 15:00:00	AAPL	Stock	18.8161	18.8193	18.7879	18.7932	13652016.0
2014-04-23 15:30:00	AAPL	Stock	18.7929	18.7964	18.7304	18.7407	32941076.0
2014-04-23 16:00:00	AAPL	Stock	18.7411	18.8941	18.6782	18.7768	12166784.0
2014-04-23 16:30:00	AAPL	Stock	20.1786	20.33	18.7411	20.0543	62775300.0
2014-04-23 17:00:00	AAPL	Stock	20.0561	20.3346	18.7373	20.2964	33386836.0
2014-04-23 17:30:00	AAPL	Stock	20.3036	20.3118	20.1432	20.1725	9010652.0
2014-04-23 18:00:00	AAPL	Stock	18.7411	20.1964	18.7411	20.1704	3397828.0
2014-04-23 18:30:00	AAPL	Stock	20.1711	20.2021	18.7411	20.2021	1116892.0
2014-04-23 19:00:00	AAPL	Stock	20.1964	20.2361	20.1843	20.2264	1071644.0
2014-04-23 19:30:00	AAPL	Stock	20.2236	20.2236	20.1821	20.2196	1514100.0
2014-04-23 07:30:00	MSFT	Stock	39.93	39.93	39.93	39.93	500.0
2014-04-23 08:00:00	MSFT	Stock	39.96	39.96	39.96	39.96	180.0
2014-04-23 08:30:00	MSFT	Stock	39.95	39.99	39.95	39.96	8560.0
2014-04-23 09:00:00	MSFT	Stock	39.96	40.01	39.95	39.97	13000.0
2014-04-23 09:30:00	MSFT	Stock	39.99	39.99	39.67	39.7	3567598.0
2014-04-23 10:00:00	MSFT	Stock	39.7	39.7	39.55	39.58	2499401.0
2014-04-23 10:30:00	MSFT	Stock	39.59	39.62	39.47	39.56	2081112.0
2014-04-23 11:00:00	MSFT	Stock	39.55	39.64	39.48	39.51	1421289.0
2014-04-23 11:30:00	MSFT	Stock	39.509	39.66	39.5	39.56	1171796.0
2014-04-23 12:00:00	MSFT	Stock	39.56	39.59	39.48	39.53	672323.0
2014-04-23 12:30:00	MSFT	Stock	39.53	39.66	39.51	39.635	722286.0
2014-04-23 13:00:00	MSFT	Stock	39.64	39.66	39.57	39.63	669874.0
2014-04-23 13:30:00	MSFT	Stock	39.634	39.68	39.54	39.63	687799.0
2014-04-23 14:00:00	MSFT	Stock	39.625	39.68	39.6	39.656	781840.0
2014-04-23 14:30:00	MSFT	Stock	39.66	39.74	39.64	39.72	826426.0
2014-04-23 15:00:00	MSFT	Stock	39.725	39.8	39.71	39.775	1143858.0
2014-04-23 15:30:00	MSFT	Stock	39.775	39.79	39.64	39.68	4291270.0
2014-04-23 16:00:00	MSFT	Stock	39.69	39.76	39.505	39.65	2868368.0
2014-04-23 16:30:00	MSFT	Stock	39.75	39.8	39.69	39.75	205469.0
2014-04-23 17:00:00	MSFT	Stock	39.75	39.77	39.682	39.75	39707.0
2014-04-23 17:30:00	MSFT	Stock	39.76	39.8	39.75	39.78	19500.0
2014-04-23 18:00:00	MSFT	Stock	39.74	39.89	39.72	39.88	6891.0
2014-04-23 18:30:00	MSFT	Stock	39.88	39.89	39.8	39.85	4375.0

> showing 50 of 82,668 rows — these rows as CSV

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