PREVIEW / stock_30min / 2012-11-09

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-09.parquet
  size:    1.4 MB
  rows:    74,425
  symbols: 3,463

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-11-09 04:00:00	AAPL	Stock	19.2054	19.2054	19.1564	19.1679	43344.0
2012-11-09 04:30:00	AAPL	Stock	19.1696	19.25	19.1432	19.2214	191800.0
2012-11-09 05:00:00	AAPL	Stock	19.2214	19.25	19.2214	19.2214	62328.0
2012-11-09 05:30:00	AAPL	Stock	19.2214	19.2375	19.2143	19.2143	142632.0
2012-11-09 06:00:00	AAPL	Stock	19.2036	19.2036	19.1661	19.1661	74648.0
2012-11-09 06:30:00	AAPL	Stock	19.1836	19.1836	19.1432	19.1786	120652.0
2012-11-09 07:00:00	AAPL	Stock	19.1571	19.165	19.115	19.15	453628.0
2012-11-09 07:30:00	AAPL	Stock	19.1429	19.1507	19.1086	19.1246	868952.0
2012-11-09 08:00:00	AAPL	Stock	19.125	19.1596	19.0489	19.1475	5030732.0
2012-11-09 08:30:00	AAPL	Stock	19.15	19.2589	19.1464	19.225	4475800.0
2012-11-09 09:00:00	AAPL	Stock	19.2232	19.4111	19.2218	19.2929	9932104.0
2012-11-09 09:30:00	AAPL	Stock	19.3007	19.3652	19.0614	19.1579	167123768.0
2012-11-09 10:00:00	AAPL	Stock	19.1529	19.5357	19.1257	19.4682	131309696.0
2012-11-09 10:30:00	AAPL	Stock	19.4732	19.6221	19.4075	19.6211	85479044.0
2012-11-09 11:00:00	AAPL	Stock	19.6214	19.7254	19.5643	19.6293	69679344.0
2012-11-09 11:30:00	AAPL	Stock	19.6293	19.7018	19.5357	19.5686	44896992.0
2012-11-09 12:00:00	AAPL	Stock	19.5674	19.7564	19.5643	19.7295	43113924.0
2012-11-09 12:30:00	AAPL	Stock	19.7261	19.8171	19.7143	19.7593	37975812.0
2012-11-09 13:00:00	AAPL	Stock	19.7571	19.8039	19.5759	19.5759	57410528.0
2012-11-09 13:30:00	AAPL	Stock	19.5765	19.6389	19.5039	19.5996	55961276.0
2012-11-09 14:00:00	AAPL	Stock	19.6037	19.6168	19.4589	19.5836	40208084.0
2012-11-09 14:30:00	AAPL	Stock	19.585	19.6779	19.5357	19.5514	33996032.0
2012-11-09 15:00:00	AAPL	Stock	19.5464	19.5975	19.4364	19.5818	44388540.0
2012-11-09 15:30:00	AAPL	Stock	19.5782	19.6139	19.4764	19.5464	57867012.0
2012-11-09 16:00:00	AAPL	Stock	19.5369	19.6429	19.4944	19.5429	23261448.0
2012-11-09 16:30:00	AAPL	Stock	19.5411	19.5801	19.2136	19.5496	705964.0
2012-11-09 17:00:00	AAPL	Stock	19.5496	19.5496	19.5325	19.5325	289828.0
2012-11-09 17:30:00	AAPL	Stock	19.5354	19.5357	19.5314	19.5321	151844.0
2012-11-09 18:00:00	AAPL	Stock	19.5354	19.5357	19.5243	19.5243	243684.0
2012-11-09 18:30:00	AAPL	Stock	19.5268	19.5271	19.5096	19.5261	155792.0
2012-11-09 19:00:00	AAPL	Stock	19.5214	19.5336	19.5214	19.5232	30324.0
2012-11-09 19:30:00	AAPL	Stock	19.5246	19.5389	19.5243	19.5357	104832.0
2012-11-09 04:30:00	MSFT	Stock	28.8	28.8	28.67	28.8	500.0
2012-11-09 06:00:00	MSFT	Stock	28.98	28.98	28.98	28.98	100.0
2012-11-09 07:30:00	MSFT	Stock	28.78	28.88	28.78	28.79	9000.0
2012-11-09 08:00:00	MSFT	Stock	28.79	28.85	28.79	28.85	38950.0
2012-11-09 08:30:00	MSFT	Stock	28.82	28.88	28.82	28.87	18500.0
2012-11-09 09:00:00	MSFT	Stock	28.87	28.88	28.85	28.87	21541.0
2012-11-09 09:30:00	MSFT	Stock	28.87	29.19	28.83	29.01	6324650.0
2012-11-09 10:00:00	MSFT	Stock	29.0	29.09	28.97	28.99	5291706.0
2012-11-09 10:30:00	MSFT	Stock	28.995	29.02	28.92	28.977	3205063.0
2012-11-09 11:00:00	MSFT	Stock	28.97	29.01	28.87	28.926	2897145.0
2012-11-09 11:30:00	MSFT	Stock	28.925	29.02	28.9	28.99	2483709.0
2012-11-09 12:00:00	MSFT	Stock	29.0	29.05	28.995	29.01	1710824.0
2012-11-09 12:30:00	MSFT	Stock	29.015	29.03	28.97	28.98	1657577.0
2012-11-09 13:00:00	MSFT	Stock	28.98	29.02	28.85	28.86	2641536.0
2012-11-09 13:30:00	MSFT	Stock	28.86	28.97	28.86	28.94	2312630.0
2012-11-09 14:00:00	MSFT	Stock	28.94	28.99	28.88	28.99	2113192.0
2012-11-09 14:30:00	MSFT	Stock	28.99	29.06	28.9	28.9	1758544.0
2012-11-09 15:00:00	MSFT	Stock	28.905	28.93	28.88	28.91	2664886.0

> showing 50 of 74,425 rows — these rows as CSV

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