PREVIEW / stock_30min / 2012-09-13

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-13.parquet
  size:    1.4 MB
  rows:    76,406
  symbols: 3,488

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-09-13 04:00:00	AAPL	Stock	23.9161	23.9289	23.8932	23.9289	27160.0
2012-09-13 04:30:00	AAPL	Stock	23.9286	23.9646	23.9286	23.9646	128268.0
2012-09-13 05:00:00	AAPL	Stock	23.9679	24.0	23.9679	23.9821	25200.0
2012-09-13 05:30:00	AAPL	Stock	24.0	24.0143	23.9821	24.0	51380.0
2012-09-13 06:00:00	AAPL	Stock	23.9857	23.9996	23.9821	23.9996	48580.0
2012-09-13 06:30:00	AAPL	Stock	24.0143	24.0232	23.9907	23.9907	64400.0
2012-09-13 07:00:00	AAPL	Stock	23.9875	24.0779	23.9875	24.0779	980252.0
2012-09-13 07:30:00	AAPL	Stock	24.0714	24.1286	24.0714	24.0893	2232608.0
2012-09-13 08:00:00	AAPL	Stock	24.0982	24.1321	24.0	24.0875	3427480.0
2012-09-13 08:30:00	AAPL	Stock	24.0846	24.1179	24.0714	24.1093	2465344.0
2012-09-13 09:00:00	AAPL	Stock	24.1071	24.1904	24.0982	24.1904	3785544.0
2012-09-13 09:30:00	AAPL	Stock	24.1893	24.2739	24.0989	24.1911	101838184.0
2012-09-13 10:00:00	AAPL	Stock	24.1943	24.2464	24.1368	24.1701	45529596.0
2012-09-13 10:30:00	AAPL	Stock	24.17	24.2354	24.1646	24.2196	28927500.0
2012-09-13 11:00:00	AAPL	Stock	24.22	24.2339	24.1836	24.2268	17764796.0
2012-09-13 11:30:00	AAPL	Stock	24.2261	24.2357	24.1936	24.2007	13557852.0
2012-09-13 12:00:00	AAPL	Stock	24.1979	24.2029	24.1546	24.175	16621920.0
2012-09-13 12:30:00	AAPL	Stock	24.1744	24.3129	24.1536	24.285	72466576.0
2012-09-13 13:00:00	AAPL	Stock	24.2854	24.3746	24.2689	24.3746	44685816.0
2012-09-13 13:30:00	AAPL	Stock	24.3736	24.4532	24.3679	24.4126	51418416.0
2012-09-13 14:00:00	AAPL	Stock	24.4138	24.4804	24.3929	24.4679	34715772.0
2012-09-13 14:30:00	AAPL	Stock	24.4679	24.4821	24.4332	24.455	29466052.0
2012-09-13 15:00:00	AAPL	Stock	24.455	24.4579	24.3671	24.3907	31845352.0
2012-09-13 15:30:00	AAPL	Stock	24.3932	24.4514	24.3654	24.3918	44150988.0
2012-09-13 16:00:00	AAPL	Stock	24.3896	24.4064	24.2252	24.3893	29289344.0
2012-09-13 16:30:00	AAPL	Stock	24.3911	24.3961	24.38	24.3889	597800.0
2012-09-13 17:00:00	AAPL	Stock	24.2164	24.4054	24.2164	24.4032	321188.0
2012-09-13 17:30:00	AAPL	Stock	24.4004	24.4168	24.4004	24.4168	310828.0
2012-09-13 18:00:00	AAPL	Stock	24.4179	24.4357	24.4179	24.4304	470456.0
2012-09-13 18:30:00	AAPL	Stock	24.4304	24.4321	24.425	24.4321	101836.0
2012-09-13 19:00:00	AAPL	Stock	24.4264	24.4318	24.4229	24.4279	132944.0
2012-09-13 19:30:00	AAPL	Stock	24.4264	24.4429	24.4246	24.4293	258132.0
2012-09-13 07:30:00	MSFT	Stock	30.8	30.8	30.78	30.78	850.0
2012-09-13 08:00:00	MSFT	Stock	30.8	30.93	30.76	30.76	70440.0
2012-09-13 08:30:00	MSFT	Stock	30.77	30.78	30.76	30.78	5774.0
2012-09-13 09:00:00	MSFT	Stock	30.78	30.87	30.75	30.87	18707.0
2012-09-13 09:30:00	MSFT	Stock	30.87	30.9	30.4	30.53	4389329.0
2012-09-13 10:00:00	MSFT	Stock	30.524	30.61	30.455	30.47	3874518.0
2012-09-13 10:30:00	MSFT	Stock	30.48	30.57	30.47	30.555	1698425.0
2012-09-13 11:00:00	MSFT	Stock	30.56	30.62	30.55	30.6	1817753.0
2012-09-13 11:30:00	MSFT	Stock	30.595	30.6	30.54	30.55	1177487.0
2012-09-13 12:00:00	MSFT	Stock	30.55	30.66	30.54	30.61	1972706.0
2012-09-13 12:30:00	MSFT	Stock	30.62	31.0	30.55	30.88	5646353.0
2012-09-13 13:00:00	MSFT	Stock	30.89	30.965	30.86	30.94	2872962.0
2012-09-13 13:30:00	MSFT	Stock	30.941	31.07	30.941	30.95	1797845.0
2012-09-13 14:00:00	MSFT	Stock	30.95	31.18	30.91	31.12	2532398.0
2012-09-13 14:30:00	MSFT	Stock	31.132	31.14	31.035	31.08	2448167.0
2012-09-13 15:00:00	MSFT	Stock	31.08	31.13	31.05	31.06	3599269.0
2012-09-13 15:30:00	MSFT	Stock	31.065	31.1	30.89	30.97	6189933.0
2012-09-13 16:00:00	MSFT	Stock	30.95	31.03	30.564	30.96	4103447.0

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

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