PREVIEW / stock_30min / 2016-06-09

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-09.parquet
  size:    1.6 MB
  rows:    81,663
  symbols: 3,288

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
2016-06-09 04:30:00	AAPL	Stock	24.625	24.625	24.625	24.625	800.0
2016-06-09 05:30:00	AAPL	Stock	24.615	24.6325	24.615	24.625	8800.0
2016-06-09 06:00:00	AAPL	Stock	24.625	24.625	24.625	24.625	4400.0
2016-06-09 06:30:00	AAPL	Stock	24.625	24.625	24.625	24.625	400.0
2016-06-09 07:00:00	AAPL	Stock	24.6375	24.66	24.635	24.66	11860.0
2016-06-09 07:30:00	AAPL	Stock	24.65	24.65	24.6375	24.6375	6400.0
2016-06-09 08:00:00	AAPL	Stock	24.625	24.675	24.625	24.6425	66992.0
2016-06-09 08:30:00	AAPL	Stock	24.6625	24.695	24.65	24.67	114632.0
2016-06-09 09:00:00	AAPL	Stock	24.6675	24.695	24.62	24.6225	286040.0
2016-06-09 09:30:00	AAPL	Stock	24.625	24.8875	24.615	24.8475	17717684.0
2016-06-09 10:00:00	AAPL	Stock	24.8498	24.875	24.795	24.8238	8753804.0
2016-06-09 10:30:00	AAPL	Stock	24.8225	24.925	24.81	24.8975	8638324.0
2016-06-09 11:00:00	AAPL	Stock	24.8955	24.9525	24.8825	24.9462	6379136.0
2016-06-09 11:30:00	AAPL	Stock	24.947	24.995	24.925	24.9682	7294596.0
2016-06-09 12:00:00	AAPL	Stock	24.9675	24.9688	24.878	24.905	5536672.0
2016-06-09 12:30:00	AAPL	Stock	24.905	24.9575	24.8975	24.9325	3150552.0
2016-06-09 13:00:00	AAPL	Stock	24.93	24.9975	24.93	24.9875	5820056.0
2016-06-09 13:30:00	AAPL	Stock	24.985	24.9875	24.89	24.927	4747188.0
2016-06-09 14:00:00	AAPL	Stock	24.9275	24.9325	24.8875	24.895	3730448.0
2016-06-09 14:30:00	AAPL	Stock	24.8975	24.9725	24.8925	24.91	6216320.0
2016-06-09 15:00:00	AAPL	Stock	24.9125	24.9325	24.9	24.9225	4023340.0
2016-06-09 15:30:00	AAPL	Stock	24.9225	24.9475	24.9	24.915	9380304.0
2016-06-09 16:00:00	AAPL	Stock	24.9125	24.92	24.828	24.9125	4420268.0
2016-06-09 16:30:00	AAPL	Stock	24.9125	24.9125	24.9	24.9	50308.0
2016-06-09 17:00:00	AAPL	Stock	24.9	24.91	24.89	24.9075	16400.0
2016-06-09 17:30:00	AAPL	Stock	24.9	24.9025	24.89	24.9025	3096.0
2016-06-09 18:00:00	AAPL	Stock	24.895	24.9075	24.89	24.895	27692.0
2016-06-09 18:30:00	AAPL	Stock	24.9075	24.9075	24.9025	24.9025	2400.0
2016-06-09 19:00:00	AAPL	Stock	24.905	24.91	24.9	24.91	22400.0
2016-06-09 19:30:00	AAPL	Stock	24.9	24.9225	24.9	24.92	16736.0
2016-06-09 08:00:00	MSFT	Stock	52.05	52.05	51.95	51.95	249.0
2016-06-09 08:30:00	MSFT	Stock	51.84	51.89	51.83	51.83	2100.0
2016-06-09 09:00:00	MSFT	Stock	51.8	51.85	51.71	51.84	14852.0
2016-06-09 09:30:00	MSFT	Stock	52.0	52.0	51.77	51.903	1834394.0
2016-06-09 10:00:00	MSFT	Stock	51.905	51.965	51.82	51.82	1729259.0
2016-06-09 10:30:00	MSFT	Stock	51.83	51.84	51.73	51.745	1010053.0
2016-06-09 11:00:00	MSFT	Stock	51.745	51.78	51.6	51.605	1149857.0
2016-06-09 11:30:00	MSFT	Stock	51.605	51.69	51.58	51.633	740751.0
2016-06-09 12:00:00	MSFT	Stock	51.635	51.635	51.49	51.59	882256.0
2016-06-09 12:30:00	MSFT	Stock	51.6	51.74	51.59	51.725	686308.0
2016-06-09 13:00:00	MSFT	Stock	51.725	51.86	51.7	51.801	727040.0
2016-06-09 13:30:00	MSFT	Stock	51.8	51.83	51.595	51.67	875348.0
2016-06-09 14:00:00	MSFT	Stock	51.664	51.735	51.615	51.69	763049.0
2016-06-09 14:30:00	MSFT	Stock	51.69	51.81	51.68	51.725	797431.0
2016-06-09 15:00:00	MSFT	Stock	51.73	51.77	51.67	51.72	1032919.0
2016-06-09 15:30:00	MSFT	Stock	51.71	51.76	51.62	51.62	3216080.0
2016-06-09 16:00:00	MSFT	Stock	51.62	51.65	51.62	51.65	3576403.0
2016-06-09 16:30:00	MSFT	Stock	51.65	51.65	51.63	51.63	2589.0
2016-06-09 17:00:00	MSFT	Stock	51.63	51.63	51.5	51.5	2800.0
2016-06-09 17:30:00	MSFT	Stock	51.62	51.62	51.62	51.62	800.0

> showing 50 of 81,663 rows — these rows as CSV

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