PREVIEW / stock_30min / 2011-04-12

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-12.parquet
  size:    1.4 MB
  rows:    74,545
  symbols: 3,537

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
2011-04-12 04:00:00	AAPL	Stock	11.7679	11.7764	11.7368	11.7368	22400.0
2011-04-12 04:30:00	AAPL	Stock	11.7396	11.7396	11.7396	11.7396	2800.0
2011-04-12 05:00:00	AAPL	Stock	11.7364	11.7482	11.7325	11.7482	12880.0
2011-04-12 05:30:00	AAPL	Stock	11.75	11.75	11.7321	11.7321	17360.0
2011-04-12 06:00:00	AAPL	Stock	11.7461	11.75	11.7321	11.75	51212.0
2011-04-12 06:30:00	AAPL	Stock	11.7393	11.7393	11.7393	11.7393	8400.0
2011-04-12 07:00:00	AAPL	Stock	11.7332	11.7464	11.6968	11.6971	465556.0
2011-04-12 07:30:00	AAPL	Stock	11.6975	11.7679	11.6961	11.725	534940.0
2011-04-12 08:00:00	AAPL	Stock	11.73	11.7714	11.725	11.7714	1203804.0
2011-04-12 08:30:00	AAPL	Stock	11.7714	11.8593	11.7661	11.8482	3160528.0
2011-04-12 09:00:00	AAPL	Stock	11.8475	11.8589	11.8032	11.8075	2319772.0
2011-04-12 09:30:00	AAPL	Stock	11.8064	11.9189	11.7929	11.8536	97409144.0
2011-04-12 10:00:00	AAPL	Stock	11.8536	11.8946	11.8211	11.8811	49847308.0
2011-04-12 10:30:00	AAPL	Stock	11.8811	11.8942	11.8464	11.8514	32137952.0
2011-04-12 11:00:00	AAPL	Stock	11.8529	11.8607	11.7936	11.8143	39112836.0
2011-04-12 11:30:00	AAPL	Stock	11.8125	11.8389	11.8089	11.8214	19050024.0
2011-04-12 12:00:00	AAPL	Stock	11.8211	11.8343	11.7989	11.8275	15771168.0
2011-04-12 12:30:00	AAPL	Stock	11.8268	11.8714	11.8118	11.8489	18299540.0
2011-04-12 13:00:00	AAPL	Stock	11.8489	11.855	11.8161	11.8464	14889896.0
2011-04-12 13:30:00	AAPL	Stock	11.8464	11.8743	11.8371	11.865	21048468.0
2011-04-12 14:00:00	AAPL	Stock	11.8646	11.8854	11.8575	11.8736	16837520.0
2011-04-12 14:30:00	AAPL	Stock	11.8732	11.8804	11.8357	11.8486	17000424.0
2011-04-12 15:00:00	AAPL	Stock	11.8471	11.8754	11.8393	11.845	21107940.0
2011-04-12 15:30:00	AAPL	Stock	11.8446	11.8771	11.8357	11.8714	36408288.0
2011-04-12 16:00:00	AAPL	Stock	11.8686	11.8786	11.7945	11.8743	10262840.0
2011-04-12 16:30:00	AAPL	Stock	11.875	11.8786	11.8421	11.8736	240100.0
2011-04-12 17:00:00	AAPL	Stock	11.8743	11.88	11.8714	11.875	184604.0
2011-04-12 17:30:00	AAPL	Stock	11.8718	11.8907	11.8714	11.8904	550032.0
2011-04-12 18:00:00	AAPL	Stock	11.89	11.9089	11.8714	11.9018	577976.0
2011-04-12 18:30:00	AAPL	Stock	11.9018	11.9018	11.8836	11.8996	276836.0
2011-04-12 19:00:00	AAPL	Stock	11.9011	11.9011	11.8889	11.8929	132692.0
2011-04-12 19:30:00	AAPL	Stock	11.8982	11.9082	11.8929	11.9082	186424.0
2011-04-12 05:30:00	MSFT	Stock	25.98	25.98	25.98	25.98	100.0
2011-04-12 07:00:00	MSFT	Stock	25.81	25.85	25.81	25.85	1050.0
2011-04-12 07:30:00	MSFT	Stock	25.84	25.84	25.81	25.81	3000.0
2011-04-12 08:00:00	MSFT	Stock	25.88	25.9	25.83	25.9	16686.0
2011-04-12 08:30:00	MSFT	Stock	25.89	25.89	25.84	25.87	13144.0
2011-04-12 09:00:00	MSFT	Stock	25.88	25.91	25.75	25.82	55543.0
2011-04-12 09:30:00	MSFT	Stock	25.82	25.85	25.71	25.802	5036472.0
2011-04-12 10:00:00	MSFT	Stock	25.802	25.82	25.74	25.8	2481131.0
2011-04-12 10:30:00	MSFT	Stock	25.8	25.82	25.66	25.66	2688165.0
2011-04-12 11:00:00	MSFT	Stock	25.66	25.68	25.61	25.668	2512666.0
2011-04-12 11:30:00	MSFT	Stock	25.67	25.69	25.66	25.67	1485481.0
2011-04-12 12:00:00	MSFT	Stock	25.677	25.71	25.66	25.67	1758082.0
2011-04-12 12:30:00	MSFT	Stock	25.67	25.73	25.65	25.72	1424690.0
2011-04-12 13:00:00	MSFT	Stock	25.722	25.76	25.69	25.735	1298558.0
2011-04-12 13:30:00	MSFT	Stock	25.74	25.78	25.68	25.73	1698116.0
2011-04-12 14:00:00	MSFT	Stock	25.738	25.75	25.69	25.715	1714863.0
2011-04-12 14:30:00	MSFT	Stock	25.71	25.72	25.62	25.64	2823265.0
2011-04-12 15:00:00	MSFT	Stock	25.65	25.67	25.55	25.58	3432597.0

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

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