PREVIEW / stock_30min / 2014-10-31

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-31.parquet
  size:    1.7 MB
  rows:    85,585
  symbols: 3,589

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
2014-10-31 04:00:00	AAPL	Stock	26.75	27.5	26.75	26.9425	69740.0
2014-10-31 04:30:00	AAPL	Stock	26.9675	27.0025	26.9675	27.0025	19484.0
2014-10-31 05:00:00	AAPL	Stock	27.0025	27.1	27.0	27.0625	29428.0
2014-10-31 05:30:00	AAPL	Stock	27.0875	27.11	27.075	27.075	40272.0
2014-10-31 06:00:00	AAPL	Stock	27.085	27.0925	27.075	27.085	12300.0
2014-10-31 06:30:00	AAPL	Stock	27.0775	27.09	27.0625	27.0875	18752.0
2014-10-31 07:00:00	AAPL	Stock	27.0775	27.0775	27.0	27.01	221780.0
2014-10-31 07:30:00	AAPL	Stock	27.005	27.01	26.97	26.975	146904.0
2014-10-31 08:00:00	AAPL	Stock	26.9775	27.0925	26.95	26.95	804952.0
2014-10-31 08:30:00	AAPL	Stock	26.965	26.985	26.9625	26.9825	404356.0
2014-10-31 09:00:00	AAPL	Stock	26.9825	27.0375	26.97	27.005	936668.0
2014-10-31 09:30:00	AAPL	Stock	27.0025	27.01	26.885	26.9275	27287852.0
2014-10-31 10:00:00	AAPL	Stock	26.9288	26.945	26.8025	26.9325	16966480.0
2014-10-31 10:30:00	AAPL	Stock	26.9325	26.94	26.8475	26.88	12016232.0
2014-10-31 11:00:00	AAPL	Stock	26.88	26.9275	26.865	26.9262	8400464.0
2014-10-31 11:30:00	AAPL	Stock	26.9275	26.935	26.8645	26.9025	7792144.0
2014-10-31 12:00:00	AAPL	Stock	26.9025	26.9075	26.8575	26.8625	5736824.0
2014-10-31 12:30:00	AAPL	Stock	26.86	26.895	26.855	26.8875	5307276.0
2014-10-31 13:00:00	AAPL	Stock	26.8875	26.9162	26.8825	26.9125	5077108.0
2014-10-31 13:30:00	AAPL	Stock	26.9125	26.9175	26.8925	26.9025	4798320.0
2014-10-31 14:00:00	AAPL	Stock	26.9038	26.9175	26.8988	26.9078	5173348.0
2014-10-31 14:30:00	AAPL	Stock	26.91	26.935	26.9025	26.9215	8043948.0
2014-10-31 15:00:00	AAPL	Stock	26.9225	26.9475	26.9125	26.945	9999332.0
2014-10-31 15:30:00	AAPL	Stock	26.9475	27.0	26.9425	26.9925	25307052.0
2014-10-31 16:00:00	AAPL	Stock	27.0	27.0075	26.897	26.995	19897176.0
2014-10-31 16:30:00	AAPL	Stock	26.9925	27.0	26.9105	26.9975	942288.0
2014-10-31 17:00:00	AAPL	Stock	26.9975	27.0	26.9875	26.99	496032.0
2014-10-31 17:30:00	AAPL	Stock	26.995	26.9975	26.99	26.99	24416.0
2014-10-31 18:00:00	AAPL	Stock	26.9975	27.0	26.99	26.99	85764.0
2014-10-31 18:30:00	AAPL	Stock	26.995	26.9975	26.99	26.995	108760.0
2014-10-31 19:00:00	AAPL	Stock	26.9975	27.0	26.99	27.0	35740.0
2014-10-31 19:30:00	AAPL	Stock	26.995	27.0025	26.995	27.0	51868.0
2014-10-31 04:00:00	MSFT	Stock	46.2	46.2	46.2	46.2	100.0
2014-10-31 04:30:00	MSFT	Stock	46.54	46.55	46.54	46.55	700.0
2014-10-31 05:00:00	MSFT	Stock	46.61	46.61	46.61	46.61	100.0
2014-10-31 05:30:00	MSFT	Stock	46.62	46.62	46.62	46.62	300.0
2014-10-31 06:00:00	MSFT	Stock	46.6	46.65	46.6	46.65	6414.0
2014-10-31 06:30:00	MSFT	Stock	46.65	46.65	46.65	46.65	130.0
2014-10-31 07:00:00	MSFT	Stock	46.6	46.6	46.48	46.52	18300.0
2014-10-31 07:30:00	MSFT	Stock	46.52	46.52	46.48	46.48	9001.0
2014-10-31 08:00:00	MSFT	Stock	46.52	46.59	46.46	46.56	5732.0
2014-10-31 08:30:00	MSFT	Stock	46.54	46.6	46.46	46.5	27401.0
2014-10-31 09:00:00	MSFT	Stock	46.54	46.99	46.54	46.97	153429.0
2014-10-31 09:30:00	MSFT	Stock	46.94	46.97	46.48	46.63	4634267.0
2014-10-31 10:00:00	MSFT	Stock	46.621	46.89	46.621	46.82	2377853.0
2014-10-31 10:30:00	MSFT	Stock	46.82	46.84	46.65	46.71	1422261.0
2014-10-31 11:00:00	MSFT	Stock	46.71	46.85	46.67	46.73	1987202.0
2014-10-31 11:30:00	MSFT	Stock	46.72	46.74	46.63	46.68	1274056.0
2014-10-31 12:00:00	MSFT	Stock	46.68	46.79	46.67	46.75	1646603.0
2014-10-31 12:30:00	MSFT	Stock	46.75	46.79	46.695	46.78	1122305.0

> showing 50 of 85,585 rows — these rows as CSV

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