PREVIEW / stock_30min / 2016-02-02

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-02.parquet
  size:    1.6 MB
  rows:    81,440
  symbols: 3,366

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-02-02 04:00:00	AAPL	Stock	23.9675	23.9675	23.8825	23.8825	1600.0
2016-02-02 04:30:00	AAPL	Stock	23.8875	23.8875	23.8025	23.835	4872.0
2016-02-02 05:00:00	AAPL	Stock	23.8775	23.8775	23.8175	23.8175	1320.0
2016-02-02 06:00:00	AAPL	Stock	23.8125	23.8125	23.7775	23.7775	28504.0
2016-02-02 06:30:00	AAPL	Stock	23.8475	23.9125	23.8475	23.91	9916.0
2016-02-02 07:00:00	AAPL	Stock	23.8375	23.8825	23.8275	23.875	14200.0
2016-02-02 07:30:00	AAPL	Stock	23.8375	23.85	23.8125	23.835	36072.0
2016-02-02 08:00:00	AAPL	Stock	23.84	23.9	23.815	23.85	229232.0
2016-02-02 08:30:00	AAPL	Stock	23.86	24.1075	23.805	23.85	251444.0
2016-02-02 09:00:00	AAPL	Stock	23.835	23.9125	23.825	23.8675	281484.0
2016-02-02 09:30:00	AAPL	Stock	23.855	24.01	23.7625	23.8225	18378880.0
2016-02-02 10:00:00	AAPL	Stock	23.8225	23.9125	23.76	23.8675	11413856.0
2016-02-02 10:30:00	AAPL	Stock	23.8675	23.925	23.815	23.8625	7863460.0
2016-02-02 11:00:00	AAPL	Stock	23.865	23.9725	23.8263	23.915	9134760.0
2016-02-02 11:30:00	AAPL	Stock	23.9125	23.9715	23.8312	23.8325	7406760.0
2016-02-02 12:00:00	AAPL	Stock	23.8345	23.8725	23.7875	23.815	6820256.0
2016-02-02 12:30:00	AAPL	Stock	23.8175	23.8575	23.78	23.8288	7026276.0
2016-02-02 13:00:00	AAPL	Stock	23.8275	23.85	23.7825	23.8248	5769168.0
2016-02-02 13:30:00	AAPL	Stock	23.8225	23.825	23.7275	23.7325	8328388.0
2016-02-02 14:00:00	AAPL	Stock	23.733	23.7722	23.645	23.655	8800324.0
2016-02-02 14:30:00	AAPL	Stock	23.655	23.71	23.57	23.575	9054500.0
2016-02-02 15:00:00	AAPL	Stock	23.574	23.69	23.57	23.649	9137740.0
2016-02-02 15:30:00	AAPL	Stock	23.6475	23.7275	23.59	23.62	16331520.0
2016-02-02 16:00:00	AAPL	Stock	23.62	23.71	23.6025	23.71	8645572.0
2016-02-02 16:30:00	AAPL	Stock	23.6875	23.7125	23.6425	23.6775	36220.0
2016-02-02 17:00:00	AAPL	Stock	23.68	23.69	23.6575	23.6625	58752.0
2016-02-02 17:30:00	AAPL	Stock	23.6825	23.695	23.66	23.695	29136.0
2016-02-02 18:00:00	AAPL	Stock	23.675	23.6925	23.675	23.685	25528.0
2016-02-02 18:30:00	AAPL	Stock	23.685	23.695	23.675	23.675	23648.0
2016-02-02 19:00:00	AAPL	Stock	23.675	23.6925	23.665	23.665	16904.0
2016-02-02 19:30:00	AAPL	Stock	23.6675	23.7	23.665	23.6925	49696.0
2016-02-02 04:00:00	MSFT	Stock	54.35	54.35	54.01	54.2	651.0
2016-02-02 04:30:00	MSFT	Stock	54.06	54.06	53.9	53.99	3860.0
2016-02-02 06:00:00	MSFT	Stock	54.03	54.03	53.99	53.99	7280.0
2016-02-02 07:00:00	MSFT	Stock	54.24	54.26	54.15	54.2	19742.0
2016-02-02 07:30:00	MSFT	Stock	54.2	54.25	54.14	54.25	17299.0
2016-02-02 08:00:00	MSFT	Stock	54.28	54.3	54.05	54.07	14044.0
2016-02-02 08:30:00	MSFT	Stock	54.1	54.13	54.02	54.05	26805.0
2016-02-02 09:00:00	MSFT	Stock	54.02	54.24	53.91	53.91	121750.0
2016-02-02 09:30:00	MSFT	Stock	54.16	54.26	53.66	53.775	7095337.0
2016-02-02 10:00:00	MSFT	Stock	53.77	53.88	53.65	53.665	3671660.0
2016-02-02 10:30:00	MSFT	Stock	53.665	53.7	53.46	53.63	4313225.0
2016-02-02 11:00:00	MSFT	Stock	53.63	53.975	53.6	53.95	3758595.0
2016-02-02 11:30:00	MSFT	Stock	53.95	54.0	53.72	53.72	2558727.0
2016-02-02 12:00:00	MSFT	Stock	53.725	53.77	53.49	53.549	2743431.0
2016-02-02 12:30:00	MSFT	Stock	53.55	53.73	53.5	53.65	2280884.0
2016-02-02 13:00:00	MSFT	Stock	53.65	53.66	53.31	53.5	2920668.0
2016-02-02 13:30:00	MSFT	Stock	53.495	53.5	53.2	53.2	2622186.0
2016-02-02 14:00:00	MSFT	Stock	53.21	53.295	52.96	52.98	2269346.0
2016-02-02 14:30:00	MSFT	Stock	52.98	53.07	52.72	52.72	3643799.0

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

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