PREVIEW / stock_30min / 2017-04-10

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-10.parquet
  size:    1.6 MB
  rows:    81,247
  symbols: 3,061

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-10 04:00:00	AAPL	Stock	35.925	35.925	35.91	35.91	808.0
2017-04-10 04:30:00	AAPL	Stock	35.9875	35.9875	35.9875	35.9875	736.0
2017-04-10 05:30:00	AAPL	Stock	35.9	35.9	35.895	35.895	3920.0
2017-04-10 06:00:00	AAPL	Stock	35.9	35.9	35.8775	35.8775	2800.0
2017-04-10 06:30:00	AAPL	Stock	35.925	35.925	35.9125	35.915	1200.0
2017-04-10 07:00:00	AAPL	Stock	35.925	35.925	35.88	35.9	18704.0
2017-04-10 07:30:00	AAPL	Stock	35.9325	35.9325	35.9125	35.92	8732.0
2017-04-10 08:00:00	AAPL	Stock	35.9125	35.93	35.8875	35.9125	55484.0
2017-04-10 08:30:00	AAPL	Stock	35.9125	35.915	35.865	35.875	65880.0
2017-04-10 09:00:00	AAPL	Stock	35.885	35.9125	35.875	35.89	63516.0
2017-04-10 09:30:00	AAPL	Stock	35.9	35.9698	35.8625	35.915	7876032.0
2017-04-10 10:00:00	AAPL	Stock	35.915	35.9175	35.8475	35.856	3997164.0
2017-04-10 10:30:00	AAPL	Stock	35.8575	35.9188	35.8575	35.87	4534604.0
2017-04-10 11:00:00	AAPL	Stock	35.8675	35.9	35.8575	35.8775	3355784.0
2017-04-10 11:30:00	AAPL	Stock	35.8775	35.8825	35.7875	35.8125	4464584.0
2017-04-10 12:00:00	AAPL	Stock	35.8125	35.85	35.7625	35.81	3977312.0
2017-04-10 12:30:00	AAPL	Stock	35.81	35.91	35.8025	35.905	4164600.0
2017-04-10 13:00:00	AAPL	Stock	35.905	35.935	35.885	35.915	3353944.0
2017-04-10 13:30:00	AAPL	Stock	35.915	35.94	35.8462	35.8625	2638484.0
2017-04-10 14:00:00	AAPL	Stock	35.8638	35.865	35.79	35.7975	3361656.0
2017-04-10 14:30:00	AAPL	Stock	35.7975	35.8575	35.78	35.827	3018440.0
2017-04-10 15:00:00	AAPL	Stock	35.8288	35.865	35.775	35.7975	3632988.0
2017-04-10 15:30:00	AAPL	Stock	35.795	35.8225	35.725	35.79	8872224.0
2017-04-10 16:00:00	AAPL	Stock	35.7925	35.8418	35.765	35.7875	8600112.0
2017-04-10 16:30:00	AAPL	Stock	35.7875	35.795	35.7875	35.795	10044.0
2017-04-10 17:00:00	AAPL	Stock	35.79	35.795	35.785	35.795	21200.0
2017-04-10 17:30:00	AAPL	Stock	35.785	35.785	35.78	35.78	4352.0
2017-04-10 18:00:00	AAPL	Stock	35.7925	35.8	35.785	35.8	13076.0
2017-04-10 18:30:00	AAPL	Stock	35.8	35.8025	35.785	35.785	27480.0
2017-04-10 19:00:00	AAPL	Stock	35.7925	35.7925	35.775	35.775	11764.0
2017-04-10 19:30:00	AAPL	Stock	35.7875	35.7875	35.7875	35.7875	4188.0
2017-04-10 08:00:00	MSFT	Stock	65.79	65.89	65.79	65.89	268.0
2017-04-10 08:30:00	MSFT	Stock	65.82	65.82	65.82	65.82	984.0
2017-04-10 09:00:00	MSFT	Stock	65.8	65.8	65.8	65.8	1740.0
2017-04-10 09:30:00	MSFT	Stock	65.61	65.8	65.58	65.69	1258275.0
2017-04-10 10:00:00	MSFT	Stock	65.69	65.75	65.615	65.73	640493.0
2017-04-10 10:30:00	MSFT	Stock	65.73	65.82	65.66	65.675	689719.0
2017-04-10 11:00:00	MSFT	Stock	65.68	65.71	65.59	65.66	579503.0
2017-04-10 11:30:00	MSFT	Stock	65.666	65.67	65.43	65.54	796250.0
2017-04-10 12:00:00	MSFT	Stock	65.54	65.57	65.36	65.465	820371.0
2017-04-10 12:30:00	MSFT	Stock	65.465	65.73	65.43	65.71	866491.0
2017-04-10 13:00:00	MSFT	Stock	65.7	65.77	65.68	65.72	426740.0
2017-04-10 13:30:00	MSFT	Stock	65.72	65.8	65.7	65.73	652030.0
2017-04-10 14:00:00	MSFT	Stock	65.735	65.74	65.57	65.63	748464.0
2017-04-10 14:30:00	MSFT	Stock	65.625	65.7	65.57	65.675	634227.0
2017-04-10 15:00:00	MSFT	Stock	65.673	65.73	65.54	65.58	726326.0
2017-04-10 15:30:00	MSFT	Stock	65.575	65.636	65.49	65.53	2424364.0
2017-04-10 16:00:00	MSFT	Stock	65.53	65.57	65.44	65.57	2486982.0
2017-04-10 16:30:00	MSFT	Stock	65.58	65.58	65.58	65.58	700.0
2017-04-10 17:30:00	MSFT	Stock	65.58	65.58	65.58	65.58	700.0

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

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