PREVIEW / stock_30min / 2017-04-07

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-07.parquet
  size:    1.6 MB
  rows:    81,213
  symbols: 3,030

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
2017-04-07 04:00:00	AAPL	Stock	35.8775	35.8775	35.825	35.825	5248.0
2017-04-07 04:30:00	AAPL	Stock	35.87	35.87	35.87	35.87	420.0
2017-04-07 05:30:00	AAPL	Stock	35.87	35.87	35.87	35.87	400.0
2017-04-07 06:00:00	AAPL	Stock	35.8525	35.8525	35.8525	35.8525	536.0
2017-04-07 06:30:00	AAPL	Stock	35.87	35.875	35.87	35.875	5264.0
2017-04-07 07:00:00	AAPL	Stock	35.875	35.925	35.87	35.925	6700.0
2017-04-07 07:30:00	AAPL	Stock	35.95	35.95	35.88	35.9	17240.0
2017-04-07 08:00:00	AAPL	Stock	35.8875	35.935	35.8525	35.895	41272.0
2017-04-07 08:30:00	AAPL	Stock	35.89	35.89	35.805	35.8525	125184.0
2017-04-07 09:00:00	AAPL	Stock	35.8525	35.9425	35.8525	35.925	53828.0
2017-04-07 09:30:00	AAPL	Stock	35.9325	36.045	35.8475	35.8575	11013420.0
2017-04-07 10:00:00	AAPL	Stock	35.8625	35.975	35.8175	35.9628	5375340.0
2017-04-07 10:30:00	AAPL	Stock	35.9638	36.025	35.9375	35.9622	3935928.0
2017-04-07 11:00:00	AAPL	Stock	35.96	35.9675	35.9	35.9375	3690460.0
2017-04-07 11:30:00	AAPL	Stock	35.9388	35.9525	35.89	35.9025	2946412.0
2017-04-07 12:00:00	AAPL	Stock	35.905	35.98	35.9022	35.965	2237408.0
2017-04-07 12:30:00	AAPL	Stock	35.9685	36.005	35.96	35.995	2188872.0
2017-04-07 13:00:00	AAPL	Stock	35.9972	35.9975	35.93	35.985	2750692.0
2017-04-07 13:30:00	AAPL	Stock	35.985	36.005	35.95	35.9725	2667288.0
2017-04-07 14:00:00	AAPL	Stock	35.9725	35.9925	35.94	35.9475	3517536.0
2017-04-07 14:30:00	AAPL	Stock	35.95	35.96	35.91	35.9175	2927204.0
2017-04-07 15:00:00	AAPL	Stock	35.9175	35.9362	35.8875	35.905	3350952.0
2017-04-07 15:30:00	AAPL	Stock	35.905	35.9125	35.8275	35.835	8064344.0
2017-04-07 16:00:00	AAPL	Stock	35.835	35.9195	35.835	35.84	5051512.0
2017-04-07 16:30:00	AAPL	Stock	35.8475	35.855	35.835	35.84	104436.0
2017-04-07 17:00:00	AAPL	Stock	35.8525	35.8525	35.84	35.8475	10300.0
2017-04-07 17:30:00	AAPL	Stock	35.84	35.8425	35.8375	35.8375	28676.0
2017-04-07 18:00:00	AAPL	Stock	35.8275	35.8375	35.8275	35.8375	3548.0
2017-04-07 18:30:00	AAPL	Stock	35.8375	35.8375	35.8375	35.8375	2000.0
2017-04-07 19:00:00	AAPL	Stock	35.8375	35.8375	35.8375	35.8375	400.0
2017-04-07 19:30:00	AAPL	Stock	35.85	35.8575	35.8375	35.8575	12532.0
2017-04-07 08:00:00	MSFT	Stock	65.6	65.6	65.52	65.52	1100.0
2017-04-07 08:30:00	MSFT	Stock	65.52	65.53	65.5	65.52	2375.0
2017-04-07 09:00:00	MSFT	Stock	65.55	65.85	65.55	65.83	6632.0
2017-04-07 09:30:00	MSFT	Stock	65.85	65.89	65.47	65.5	1623966.0
2017-04-07 10:00:00	MSFT	Stock	65.49	65.75	65.44	65.75	883254.0
2017-04-07 10:30:00	MSFT	Stock	65.75	65.85	65.66	65.69	652375.0
2017-04-07 11:00:00	MSFT	Stock	65.7	65.84	65.64	65.79	860280.0
2017-04-07 11:30:00	MSFT	Stock	65.785	65.81	65.69	65.79	769996.0
2017-04-07 12:00:00	MSFT	Stock	65.8	65.93	65.785	65.89	646581.0
2017-04-07 12:30:00	MSFT	Stock	65.895	65.9	65.78	65.8	596040.0
2017-04-07 13:00:00	MSFT	Stock	65.8	65.9	65.74	65.89	608877.0
2017-04-07 13:30:00	MSFT	Stock	65.88	65.96	65.87	65.925	648286.0
2017-04-07 14:00:00	MSFT	Stock	65.92	65.96	65.855	65.89	534733.0
2017-04-07 14:30:00	MSFT	Stock	65.88	65.94	65.825	65.84	734716.0
2017-04-07 15:00:00	MSFT	Stock	65.845	65.877	65.78	65.8	542731.0
2017-04-07 15:30:00	MSFT	Stock	65.79	65.81	65.67	65.69	1891948.0
2017-04-07 16:00:00	MSFT	Stock	65.68	65.77	65.68	65.68	1878385.0
2017-04-07 16:30:00	MSFT	Stock	65.61	65.68	65.61	65.68	872.0
2017-04-07 17:00:00	MSFT	Stock	65.75	65.75	65.71	65.71	613.0

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

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