PREVIEW / stock_30min / 2013-01-24

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-24.parquet
  size:    1.5 MB
  rows:    76,700
  symbols: 3,498

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
2013-01-24 04:00:00	AAPL	Stock	16.5714	16.7857	16.5714	16.7857	1069096.0
2013-01-24 04:30:00	AAPL	Stock	16.7857	16.8429	16.7475	16.8421	706636.0
2013-01-24 05:00:00	AAPL	Stock	16.8421	16.9286	16.8357	16.9214	924196.0
2013-01-24 05:30:00	AAPL	Stock	16.905	16.905	16.7607	16.8393	804356.0
2013-01-24 06:00:00	AAPL	Stock	16.8014	16.8014	16.6829	16.7	996240.0
2013-01-24 06:30:00	AAPL	Stock	16.6911	16.7143	16.5982	16.6229	2105264.0
2013-01-24 07:00:00	AAPL	Stock	16.6232	16.7321	16.6075	16.7093	5090988.0
2013-01-24 07:30:00	AAPL	Stock	16.6957	16.7429	16.6875	16.7296	4327316.0
2013-01-24 08:00:00	AAPL	Stock	16.7321	16.7596	16.5639	16.6071	15223040.0
2013-01-24 08:30:00	AAPL	Stock	16.6071	16.6071	16.4446	16.4814	16051056.0
2013-01-24 09:00:00	AAPL	Stock	16.4818	16.5186	16.3804	16.4268	23982868.0
2013-01-24 09:30:00	AAPL	Stock	16.4279	16.5914	16.095	16.5469	438203948.0
2013-01-24 10:00:00	AAPL	Stock	16.5439	16.6071	16.3929	16.5789	158806060.0
2013-01-24 10:30:00	AAPL	Stock	16.5757	16.6332	16.4586	16.4699	104601000.0
2013-01-24 11:00:00	AAPL	Stock	16.4639	16.505	16.3804	16.4876	89065088.0
2013-01-24 11:30:00	AAPL	Stock	16.4868	16.4932	16.4371	16.465	45734500.0
2013-01-24 12:00:00	AAPL	Stock	16.4646	16.4696	16.4157	16.4291	39738496.0
2013-01-24 12:30:00	AAPL	Stock	16.4295	16.4321	16.2968	16.2989	49108696.0
2013-01-24 13:00:00	AAPL	Stock	16.3007	16.3018	16.1977	16.2429	76489504.0
2013-01-24 13:30:00	AAPL	Stock	16.2414	16.2684	16.1607	16.1664	53565848.0
2013-01-24 14:00:00	AAPL	Stock	16.1668	16.2104	16.1429	16.1593	56104972.0
2013-01-24 14:30:00	AAPL	Stock	16.1579	16.2321	16.1183	16.2155	62817216.0
2013-01-24 15:00:00	AAPL	Stock	16.2155	16.2232	16.1464	16.1507	54657428.0
2013-01-24 15:30:00	AAPL	Stock	16.1507	16.1968	16.0804	16.0893	117956384.0
2013-01-24 16:00:00	AAPL	Stock	16.0839	16.3379	16.0336	16.0532	13960408.0
2013-01-24 16:30:00	AAPL	Stock	16.0882	16.1544	15.9911	16.0071	2807392.0
2013-01-24 17:00:00	AAPL	Stock	16.0175	16.0882	16.0068	16.0143	955136.0
2013-01-24 17:30:00	AAPL	Stock	16.0146	16.4996	15.9771	15.9825	1316532.0
2013-01-24 18:00:00	AAPL	Stock	15.9879	16.0179	15.9829	16.0179	394744.0
2013-01-24 18:30:00	AAPL	Stock	16.0171	16.0286	16.0011	16.0114	407036.0
2013-01-24 19:00:00	AAPL	Stock	16.0082	16.0143	16.0068	16.0123	311164.0
2013-01-24 19:30:00	AAPL	Stock	16.0114	16.0268	16.0054	16.0132	478324.0
2013-01-24 07:30:00	MSFT	Stock	27.46	27.6	27.46	27.6	3000.0
2013-01-24 08:00:00	MSFT	Stock	27.47	27.6	27.43	27.6	40739.0
2013-01-24 08:30:00	MSFT	Stock	27.57	27.6	27.55	27.59	56575.0
2013-01-24 09:00:00	MSFT	Stock	27.59	27.73	27.59	27.71	52758.0
2013-01-24 09:30:00	MSFT	Stock	27.72	28.06	27.56	27.96	13243232.0
2013-01-24 10:00:00	MSFT	Stock	27.96	28.07	27.9	27.985	7586866.0
2013-01-24 10:30:00	MSFT	Stock	27.99	28.05	27.9	27.97	7337389.0
2013-01-24 11:00:00	MSFT	Stock	27.97	28.05	27.968	28.05	9360487.0
2013-01-24 11:30:00	MSFT	Stock	28.04	28.06	28.0	28.035	5739826.0
2013-01-24 12:00:00	MSFT	Stock	28.03	28.045	27.99	28.0	3993122.0
2013-01-24 12:30:00	MSFT	Stock	28.0	28.01	27.95	27.95	4666821.0
2013-01-24 13:00:00	MSFT	Stock	27.95	27.97	27.895	27.916	4544324.0
2013-01-24 13:30:00	MSFT	Stock	27.918	27.93	27.82	27.852	4264343.0
2013-01-24 14:00:00	MSFT	Stock	27.85	27.93	27.84	27.928	4449274.0
2013-01-24 14:30:00	MSFT	Stock	27.92	28.0	27.86	27.875	5183023.0
2013-01-24 15:00:00	MSFT	Stock	27.87	27.93	27.825	27.845	5988990.0
2013-01-24 15:30:00	MSFT	Stock	27.85	27.855	27.6	27.63	16056185.0
2013-01-24 16:00:00	MSFT	Stock	27.63	28.19	26.96	27.21	4870006.0

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

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