PREVIEW / stock_30min / 2012-05-16

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-16.parquet
  size:    1.4 MB
  rows:    75,304
  symbols: 3,531

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-05-16 04:00:00	AAPL	Stock	19.7036	19.7496	19.69	19.7496	84336.0
2012-05-16 04:30:00	AAPL	Stock	19.7496	19.7496	19.7214	19.7214	11200.0
2012-05-16 05:00:00	AAPL	Stock	19.7393	19.7393	19.7393	19.7393	5600.0
2012-05-16 06:00:00	AAPL	Stock	19.7357	19.7357	19.7357	19.7357	5460.0
2012-05-16 06:30:00	AAPL	Stock	19.7768	19.7782	19.7768	19.7779	25620.0
2012-05-16 07:00:00	AAPL	Stock	19.785	19.8707	19.785	19.8571	427224.0
2012-05-16 07:30:00	AAPL	Stock	19.8571	19.9211	19.8543	19.8929	877156.0
2012-05-16 08:00:00	AAPL	Stock	19.8754	19.9029	19.8	19.8571	1108576.0
2012-05-16 08:30:00	AAPL	Stock	19.8618	19.8714	19.7746	19.7857	1699768.0
2012-05-16 09:00:00	AAPL	Stock	19.7961	19.8375	19.7929	19.7929	1719760.0
2012-05-16 09:30:00	AAPL	Stock	19.7875	19.8889	19.7404	19.782	62443192.0
2012-05-16 10:00:00	AAPL	Stock	19.7846	19.8196	19.7007	19.7739	47167904.0
2012-05-16 10:30:00	AAPL	Stock	19.7719	19.8293	19.7293	19.799	32348232.0
2012-05-16 11:00:00	AAPL	Stock	19.7921	19.8146	19.66	19.6605	35363048.0
2012-05-16 11:30:00	AAPL	Stock	19.6589	19.7386	19.6554	19.7268	24970148.0
2012-05-16 12:00:00	AAPL	Stock	19.7295	19.7314	19.6875	19.7143	13862044.0
2012-05-16 12:30:00	AAPL	Stock	19.7143	19.7411	19.6964	19.7036	12620552.0
2012-05-16 13:00:00	AAPL	Stock	19.7036	19.7143	19.6661	19.6725	12263776.0
2012-05-16 13:30:00	AAPL	Stock	19.6736	19.6857	19.4754	19.5677	63660912.0
2012-05-16 14:00:00	AAPL	Stock	19.5643	19.6071	19.4918	19.5004	31705044.0
2012-05-16 14:30:00	AAPL	Stock	19.5004	19.518	19.4107	19.4921	53227328.0
2012-05-16 15:00:00	AAPL	Stock	19.4921	19.5032	19.3229	19.3439	62463968.0
2012-05-16 15:30:00	AAPL	Stock	19.3439	19.5436	19.3325	19.5025	85183280.0
2012-05-16 16:00:00	AAPL	Stock	19.5018	19.6981	19.3484	19.5286	11453092.0
2012-05-16 16:30:00	AAPL	Stock	19.5286	19.6055	19.3631	19.5125	297780.0
2012-05-16 17:00:00	AAPL	Stock	19.5043	19.5043	19.4707	19.4714	237944.0
2012-05-16 17:30:00	AAPL	Stock	19.4718	19.4718	19.3929	19.3929	498624.0
2012-05-16 18:00:00	AAPL	Stock	19.3929	19.4421	19.3836	19.4071	330596.0
2012-05-16 18:30:00	AAPL	Stock	19.4143	19.4357	19.4107	19.4339	42700.0
2012-05-16 19:00:00	AAPL	Stock	19.4286	19.4421	19.4268	19.4332	150836.0
2012-05-16 19:30:00	AAPL	Stock	19.4382	19.475	19.4382	19.4643	192696.0
2012-05-16 07:00:00	MSFT	Stock	30.37	30.37	30.37	30.37	405.0
2012-05-16 08:00:00	MSFT	Stock	30.23	30.42	30.2	30.42	7181.0
2012-05-16 08:30:00	MSFT	Stock	30.45	30.47	30.4	30.45	9525.0
2012-05-16 09:00:00	MSFT	Stock	30.41	30.44	30.25	30.25	8436.0
2012-05-16 09:30:00	MSFT	Stock	30.3	30.33	29.95	30.075	8026666.0
2012-05-16 10:00:00	MSFT	Stock	30.07	30.15	29.96	30.07	5020551.0
2012-05-16 10:30:00	MSFT	Stock	30.07	30.16	30.05	30.085	3678496.0
2012-05-16 11:00:00	MSFT	Stock	30.09	30.09	29.87	29.875	5701573.0
2012-05-16 11:30:00	MSFT	Stock	29.875	29.97	29.74	29.95	5541491.0
2012-05-16 12:00:00	MSFT	Stock	29.95	29.95	29.85	29.9	2670207.0
2012-05-16 12:30:00	MSFT	Stock	29.9	29.99	29.89	29.928	1993458.0
2012-05-16 13:00:00	MSFT	Stock	29.929	29.97	29.9	29.9	2083109.0
2012-05-16 13:30:00	MSFT	Stock	29.91	29.92	29.82	29.88	2702347.0
2012-05-16 14:00:00	MSFT	Stock	29.885	29.95	29.77	29.791	4216857.0
2012-05-16 14:30:00	MSFT	Stock	29.795	30.02	29.75	29.955	4174798.0
2012-05-16 15:00:00	MSFT	Stock	29.95	29.96	29.85	29.88	2222805.0
2012-05-16 15:30:00	MSFT	Stock	29.88	29.98	29.87	29.9	7828448.0
2012-05-16 16:00:00	MSFT	Stock	29.9	29.959	29.84	29.84	3237440.0
2012-05-16 16:30:00	MSFT	Stock	29.88	30.034	29.83	29.83	25684.0

> showing 50 of 75,304 rows — these rows as CSV

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