PREVIEW / stock_30min / 2012-10-03

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-03.parquet
  size:    1.4 MB
  rows:    76,238
  symbols: 3,456

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-10-03 04:00:00	AAPL	Stock	23.6425	23.7464	23.6425	23.7464	29204.0
2012-10-03 04:30:00	AAPL	Stock	23.7146	23.7146	23.7143	23.7143	5600.0
2012-10-03 05:00:00	AAPL	Stock	23.75	23.75	23.75	23.75	14000.0
2012-10-03 05:30:00	AAPL	Stock	23.75	23.75	23.75	23.75	2800.0
2012-10-03 06:00:00	AAPL	Stock	23.7507	23.7661	23.7507	23.7643	18200.0
2012-10-03 06:30:00	AAPL	Stock	23.7518	23.7518	23.75	23.75	38528.0
2012-10-03 07:00:00	AAPL	Stock	23.7161	23.7479	23.7161	23.7325	132300.0
2012-10-03 07:30:00	AAPL	Stock	23.7443	23.75	23.7321	23.7357	120008.0
2012-10-03 08:00:00	AAPL	Stock	23.7325	23.7407	23.6789	23.7136	769944.0
2012-10-03 08:30:00	AAPL	Stock	23.7143	23.7143	23.5793	23.66	1343272.0
2012-10-03 09:00:00	AAPL	Stock	23.6536	23.7582	23.6536	23.75	1463560.0
2012-10-03 09:30:00	AAPL	Stock	23.7496	23.8489	23.6918	23.7621	67279044.0
2012-10-03 10:00:00	AAPL	Stock	23.7621	23.8571	23.6654	23.8371	54371940.0
2012-10-03 10:30:00	AAPL	Stock	23.8421	23.8471	23.6864	23.7371	28542220.0
2012-10-03 11:00:00	AAPL	Stock	23.743	23.8357	23.7232	23.8257	19959744.0
2012-10-03 11:30:00	AAPL	Stock	23.82	23.9082	23.7982	23.8791	26246836.0
2012-10-03 12:00:00	AAPL	Stock	23.8821	23.9018	23.8486	23.878	13894860.0
2012-10-03 12:30:00	AAPL	Stock	23.8836	23.9	23.8214	23.8471	13804532.0
2012-10-03 13:00:00	AAPL	Stock	23.8495	23.8714	23.8036	23.8639	14533512.0
2012-10-03 13:30:00	AAPL	Stock	23.8604	23.8612	23.7579	23.7784	18268600.0
2012-10-03 14:00:00	AAPL	Stock	23.78	23.8241	23.7411	23.7631	16214156.0
2012-10-03 14:30:00	AAPL	Stock	23.7607	23.8393	23.7579	23.8029	15294580.0
2012-10-03 15:00:00	AAPL	Stock	23.8039	23.9232	23.7589	23.9202	30619456.0
2012-10-03 15:30:00	AAPL	Stock	23.9209	23.995	23.8821	23.9929	52205692.0
2012-10-03 16:00:00	AAPL	Stock	23.9907	23.9955	23.82	23.9839	15160404.0
2012-10-03 16:30:00	AAPL	Stock	23.9786	23.9911	23.9212	23.9821	672560.0
2012-10-03 17:00:00	AAPL	Stock	23.9782	23.9864	23.9757	23.9861	284424.0
2012-10-03 17:30:00	AAPL	Stock	23.9757	23.9904	23.9757	23.9904	89404.0
2012-10-03 18:00:00	AAPL	Stock	23.9893	23.9925	23.9875	23.9911	98280.0
2012-10-03 18:30:00	AAPL	Stock	23.9911	24.0032	23.9825	23.9868	332444.0
2012-10-03 19:00:00	AAPL	Stock	23.9946	24.0071	23.9857	23.9857	162512.0
2012-10-03 19:30:00	AAPL	Stock	23.9911	24.0054	23.9911	24.0	194152.0
2012-10-03 07:00:00	MSFT	Stock	29.69	29.69	29.5	29.56	27702.0
2012-10-03 07:30:00	MSFT	Stock	29.62	29.68	29.62	29.68	3400.0
2012-10-03 08:00:00	MSFT	Stock	29.71	29.71	29.7	29.71	9550.0
2012-10-03 08:30:00	MSFT	Stock	29.71	29.75	29.71	29.73	29200.0
2012-10-03 09:00:00	MSFT	Stock	29.73	29.75	29.71	29.71	33473.0
2012-10-03 09:30:00	MSFT	Stock	29.75	29.8	29.67	29.74	3384785.0
2012-10-03 10:00:00	MSFT	Stock	29.75	29.95	29.68	29.93	5053500.0
2012-10-03 10:30:00	MSFT	Stock	29.93	29.94	29.88	29.9	3444752.0
2012-10-03 11:00:00	MSFT	Stock	29.9	29.99	29.9	29.93	3633738.0
2012-10-03 11:30:00	MSFT	Stock	29.925	29.94	29.84	29.895	2861391.0
2012-10-03 12:00:00	MSFT	Stock	29.9	29.92	29.84	29.915	3144791.0
2012-10-03 12:30:00	MSFT	Stock	29.92	29.93	29.81	29.83	2736546.0
2012-10-03 13:00:00	MSFT	Stock	29.83	29.85	29.78	29.821	1396455.0
2012-10-03 13:30:00	MSFT	Stock	29.83	29.83	29.74	29.74	2371125.0
2012-10-03 14:00:00	MSFT	Stock	29.745	29.76	29.69	29.721	2134264.0
2012-10-03 14:30:00	MSFT	Stock	29.726	29.8	29.72	29.735	2002485.0
2012-10-03 15:00:00	MSFT	Stock	29.74	29.8	29.71	29.78	2192323.0
2012-10-03 15:30:00	MSFT	Stock	29.785	29.9	29.755	29.86	7523602.0

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

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