PREVIEW / stock_30min / 2014-12-16

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-16.parquet
  size:    1.6 MB
  rows:    84,871
  symbols: 3,541

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-12-16 04:00:00	AAPL	Stock	26.975	26.975	26.77	26.8975	29660.0
2014-12-16 04:30:00	AAPL	Stock	26.9	26.9675	26.8975	26.945	22232.0
2014-12-16 05:00:00	AAPL	Stock	26.9525	26.9575	26.945	26.9475	13904.0
2014-12-16 05:30:00	AAPL	Stock	26.9725	27.025	26.9725	27.025	9200.0
2014-12-16 06:00:00	AAPL	Stock	26.985	27.05	26.985	27.025	33144.0
2014-12-16 06:30:00	AAPL	Stock	27.015	27.015	26.8275	26.8275	41412.0
2014-12-16 07:00:00	AAPL	Stock	26.825	26.8275	26.595	26.6625	306064.0
2014-12-16 07:30:00	AAPL	Stock	26.6425	26.7125	26.55	26.555	451820.0
2014-12-16 08:00:00	AAPL	Stock	26.555	26.8125	26.525	26.7625	1346868.0
2014-12-16 08:30:00	AAPL	Stock	26.77	26.77	26.65	26.6525	946828.0
2014-12-16 09:00:00	AAPL	Stock	26.66	26.7225	26.5675	26.59	956740.0
2014-12-16 09:30:00	AAPL	Stock	26.59	27.11	26.565	26.8325	34369000.0
2014-12-16 10:00:00	AAPL	Stock	26.825	27.0875	26.6825	27.04	20885188.0
2014-12-16 10:30:00	AAPL	Stock	27.035	27.17	26.825	27.155	17606008.0
2014-12-16 11:00:00	AAPL	Stock	27.155	27.445	27.13	27.4245	18098424.0
2014-12-16 11:30:00	AAPL	Stock	27.425	27.54	27.275	27.31	17145056.0
2014-12-16 12:00:00	AAPL	Stock	27.3075	27.355	27.2525	27.3075	7837828.0
2014-12-16 12:30:00	AAPL	Stock	27.3075	27.375	27.15	27.1582	9253880.0
2014-12-16 13:00:00	AAPL	Stock	27.1578	27.2275	26.9025	27.02	13510572.0
2014-12-16 13:30:00	AAPL	Stock	27.0175	27.1425	26.92	27.0625	9849856.0
2014-12-16 14:00:00	AAPL	Stock	27.0575	27.172	27.0	27.09	7620780.0
2014-12-16 14:30:00	AAPL	Stock	27.0875	27.1275	26.93	26.9725	7686480.0
2014-12-16 15:00:00	AAPL	Stock	26.9725	27.02	26.8325	26.845	11800536.0
2014-12-16 15:30:00	AAPL	Stock	26.845	26.9025	26.6625	26.685	29195472.0
2014-12-16 16:00:00	AAPL	Stock	26.6862	27.287	26.6028	26.675	17840012.0
2014-12-16 16:30:00	AAPL	Stock	26.67	27.11	26.65	26.6625	265680.0
2014-12-16 17:00:00	AAPL	Stock	26.6725	26.6875	26.65	26.6625	140464.0
2014-12-16 17:30:00	AAPL	Stock	26.6725	26.6725	26.6375	26.6375	51196.0
2014-12-16 18:00:00	AAPL	Stock	26.64	26.6875	26.6125	26.6125	123652.0
2014-12-16 18:30:00	AAPL	Stock	26.6175	26.655	26.6175	26.6548	100324.0
2014-12-16 19:00:00	AAPL	Stock	26.6525	26.7325	26.6475	26.7325	103008.0
2014-12-16 19:30:00	AAPL	Stock	26.7325	26.735	26.6925	26.725	88692.0
2014-12-16 04:00:00	MSFT	Stock	46.6	46.6	46.6	46.6	500.0
2014-12-16 04:30:00	MSFT	Stock	46.81	46.81	46.81	46.81	100.0
2014-12-16 05:30:00	MSFT	Stock	46.84	46.84	46.84	46.84	200.0
2014-12-16 06:00:00	MSFT	Stock	46.76	46.76	46.25	46.26	25100.0
2014-12-16 06:30:00	MSFT	Stock	46.25	46.25	46.05	46.05	1600.0
2014-12-16 07:00:00	MSFT	Stock	46.06	46.06	45.85	45.9	33332.0
2014-12-16 07:30:00	MSFT	Stock	45.96	46.06	45.96	46.06	16800.0
2014-12-16 08:00:00	MSFT	Stock	46.04	46.13	45.95	46.12	30804.0
2014-12-16 08:30:00	MSFT	Stock	46.12	46.12	46.0	46.0	37662.0
2014-12-16 09:00:00	MSFT	Stock	45.98	46.05	45.8	45.83	48801.0
2014-12-16 09:30:00	MSFT	Stock	45.85	46.0	45.47	45.8	6309067.0
2014-12-16 10:00:00	MSFT	Stock	45.8	45.975	45.59	45.882	4694895.0
2014-12-16 10:30:00	MSFT	Stock	45.88	45.9	45.73	45.85	3025158.0
2014-12-16 11:00:00	MSFT	Stock	45.85	46.14	45.795	46.08	3234716.0
2014-12-16 11:30:00	MSFT	Stock	46.09	46.34	45.99	46.01	3522486.0
2014-12-16 12:00:00	MSFT	Stock	46.01	46.19	46.0	46.07	1358852.0
2014-12-16 12:30:00	MSFT	Stock	46.065	46.14	45.87	45.89	1508647.0
2014-12-16 13:00:00	MSFT	Stock	45.88	45.965	45.65	45.75	1924379.0

> showing 50 of 84,871 rows — these rows as CSV

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