PREVIEW / stock_30min / 2012-12-19

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-19.parquet
  size:    1.5 MB
  rows:    76,854
  symbols: 3,495

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
2012-12-19 04:00:00	AAPL	Stock	19.1196	19.1429	19.0739	19.1004	104916.0
2012-12-19 04:30:00	AAPL	Stock	19.0846	19.1054	19.0689	19.1054	25760.0
2012-12-19 05:00:00	AAPL	Stock	19.105	19.1143	19.105	19.1139	36092.0
2012-12-19 05:30:00	AAPL	Stock	19.1143	19.1214	19.0714	19.0732	66920.0
2012-12-19 06:00:00	AAPL	Stock	19.0889	19.1232	19.0889	19.1214	8400.0
2012-12-19 06:30:00	AAPL	Stock	19.1161	19.1196	19.0739	19.0739	47600.0
2012-12-19 07:00:00	AAPL	Stock	19.0714	19.1032	19.0179	19.0643	396060.0
2012-12-19 07:30:00	AAPL	Stock	19.0607	19.0611	19.0021	19.0161	360836.0
2012-12-19 08:00:00	AAPL	Stock	19.0161	19.1036	18.8946	18.9375	2808624.0
2012-12-19 08:30:00	AAPL	Stock	18.9375	18.9625	18.8893	18.9571	2160424.0
2012-12-19 09:00:00	AAPL	Stock	18.9514	18.9821	18.9107	18.9811	2379524.0
2012-12-19 09:30:00	AAPL	Stock	18.9811	19.0536	18.8929	18.9136	68583088.0
2012-12-19 10:00:00	AAPL	Stock	18.9121	18.9121	18.7679	18.8245	60621680.0
2012-12-19 10:30:00	AAPL	Stock	18.8257	18.9614	18.7832	18.9289	37844744.0
2012-12-19 11:00:00	AAPL	Stock	18.9286	19.0607	18.9189	18.9782	41948620.0
2012-12-19 11:30:00	AAPL	Stock	18.9789	19.0532	18.9182	18.9365	24095316.0
2012-12-19 12:00:00	AAPL	Stock	18.9407	18.9882	18.9071	18.9771	22132740.0
2012-12-19 12:30:00	AAPL	Stock	18.9804	18.9929	18.9107	18.9375	19347664.0
2012-12-19 13:00:00	AAPL	Stock	18.9354	18.9554	18.8807	18.9111	17337320.0
2012-12-19 13:30:00	AAPL	Stock	18.9093	18.9157	18.8304	18.8964	20405896.0
2012-12-19 14:00:00	AAPL	Stock	18.8929	18.8996	18.8375	18.8679	15284276.0
2012-12-19 14:30:00	AAPL	Stock	18.8669	18.9107	18.8307	18.8976	21374192.0
2012-12-19 15:00:00	AAPL	Stock	18.8975	18.925	18.8429	18.8589	24901212.0
2012-12-19 15:30:00	AAPL	Stock	18.8571	18.9239	18.7893	18.7896	48313720.0
2012-12-19 16:00:00	AAPL	Stock	18.7971	19.0714	18.7693	18.8221	11041380.0
2012-12-19 16:30:00	AAPL	Stock	18.8296	18.8617	18.7968	18.8071	374780.0
2012-12-19 17:00:00	AAPL	Stock	18.8089	18.8164	18.7821	18.7929	632856.0
2012-12-19 17:30:00	AAPL	Stock	18.8018	18.8018	18.7871	18.7871	57064.0
2012-12-19 18:00:00	AAPL	Stock	18.7871	18.7871	18.7768	18.7779	223356.0
2012-12-19 18:30:00	AAPL	Stock	18.7779	18.7968	18.7768	18.7839	311640.0
2012-12-19 19:00:00	AAPL	Stock	18.7804	18.7854	18.7643	18.7854	275492.0
2012-12-19 19:30:00	AAPL	Stock	18.775	18.7786	18.7589	18.775	199920.0
2012-12-19 04:30:00	MSFT	Stock	27.6	27.6	27.6	27.6	100.0
2012-12-19 05:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	350.0
2012-12-19 06:30:00	MSFT	Stock	27.6	27.7	27.6	27.6	3150.0
2012-12-19 07:00:00	MSFT	Stock	27.59	27.6	27.59	27.6	800.0
2012-12-19 07:30:00	MSFT	Stock	27.55	27.55	27.55	27.55	168.0
2012-12-19 08:00:00	MSFT	Stock	27.57	27.67	27.55	27.6	21630.0
2012-12-19 08:30:00	MSFT	Stock	27.6	27.6	27.56	27.57	6600.0
2012-12-19 09:00:00	MSFT	Stock	27.57	27.72	27.57	27.72	29634.0
2012-12-19 09:30:00	MSFT	Stock	27.69	27.73	27.49	27.52	5971190.0
2012-12-19 10:00:00	MSFT	Stock	27.52	27.56	27.42	27.423	2977939.0
2012-12-19 10:30:00	MSFT	Stock	27.42	27.45	27.34	27.39	3258213.0
2012-12-19 11:00:00	MSFT	Stock	27.395	27.41	27.35	27.37	3257194.0
2012-12-19 11:30:00	MSFT	Stock	27.38	27.42	27.31	27.315	2931198.0
2012-12-19 12:00:00	MSFT	Stock	27.315	27.33	27.25	27.27	2815807.0
2012-12-19 12:30:00	MSFT	Stock	27.27	27.36	27.25	27.33	1720493.0
2012-12-19 13:00:00	MSFT	Stock	27.334	27.34	27.28	27.315	1688978.0
2012-12-19 13:30:00	MSFT	Stock	27.32	27.34	27.3	27.32	2736261.0
2012-12-19 14:00:00	MSFT	Stock	27.315	27.33	27.26	27.3	2499140.0

> showing 50 of 76,854 rows — these rows as CSV

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