PREVIEW / stock_30min / 2016-11-02

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-02.parquet
  size:    1.6 MB
  rows:    80,755
  symbols: 3,183

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-11-02 04:00:00	AAPL	Stock	27.8	27.8	27.675	27.675	8276.0
2016-11-02 04:30:00	AAPL	Stock	27.6875	27.7225	27.6875	27.71	5948.0
2016-11-02 05:00:00	AAPL	Stock	27.7125	27.7175	27.7	27.7075	5180.0
2016-11-02 05:30:00	AAPL	Stock	27.7275	27.7475	27.725	27.7475	3204.0
2016-11-02 06:00:00	AAPL	Stock	27.7275	27.7675	27.7275	27.7675	1080.0
2016-11-02 06:30:00	AAPL	Stock	27.775	27.775	27.75	27.75	800.0
2016-11-02 07:00:00	AAPL	Stock	27.7525	27.8425	27.75	27.8	36944.0
2016-11-02 07:30:00	AAPL	Stock	27.8	27.835	27.78	27.805	37920.0
2016-11-02 08:00:00	AAPL	Stock	27.7875	27.825	27.75	27.79	98704.0
2016-11-02 08:30:00	AAPL	Stock	27.79	27.825	27.76	27.825	104524.0
2016-11-02 09:00:00	AAPL	Stock	27.825	27.835	27.805	27.81	204580.0
2016-11-02 09:30:00	AAPL	Stock	27.85	28.0625	27.8075	28.0125	15158068.0
2016-11-02 10:00:00	AAPL	Stock	28.0075	28.0275	27.9075	27.9425	7382736.0
2016-11-02 10:30:00	AAPL	Stock	27.9425	27.9675	27.8725	27.885	8350884.0
2016-11-02 11:00:00	AAPL	Stock	27.8842	28.0875	27.8775	28.08	7760156.0
2016-11-02 11:30:00	AAPL	Stock	28.0775	28.0825	27.995	28.0075	5631112.0
2016-11-02 12:00:00	AAPL	Stock	28.0075	28.0225	27.97	27.985	4650952.0
2016-11-02 12:30:00	AAPL	Stock	27.985	27.995	27.95	27.9875	3941332.0
2016-11-02 13:00:00	AAPL	Stock	27.989	28.005	27.895	27.9125	4964660.0
2016-11-02 13:30:00	AAPL	Stock	27.9125	27.9675	27.8775	27.9625	3974244.0
2016-11-02 14:00:00	AAPL	Stock	27.96	28.055	27.8938	28.0238	9562808.0
2016-11-02 14:30:00	AAPL	Stock	28.02	28.035	27.945	27.9635	5194740.0
2016-11-02 15:00:00	AAPL	Stock	27.9638	28.005	27.93	28.0025	5365876.0
2016-11-02 15:30:00	AAPL	Stock	28.0025	28.01	27.8975	27.9	10073452.0
2016-11-02 16:00:00	AAPL	Stock	27.8975	27.9025	27.84	27.895	5994376.0
2016-11-02 16:30:00	AAPL	Stock	27.8825	27.9	27.875	27.8825	56200.0
2016-11-02 17:00:00	AAPL	Stock	27.8975	27.8975	27.79	27.79	61912.0
2016-11-02 17:30:00	AAPL	Stock	27.78	27.81	27.75	27.755	75572.0
2016-11-02 18:00:00	AAPL	Stock	27.75	27.75	27.6875	27.7125	117140.0
2016-11-02 18:30:00	AAPL	Stock	27.7125	27.7225	27.6875	27.7	54208.0
2016-11-02 19:00:00	AAPL	Stock	27.7	27.725	27.6975	27.725	97780.0
2016-11-02 19:30:00	AAPL	Stock	27.72	27.7325	27.72	27.7275	103500.0
2016-11-02 07:00:00	MSFT	Stock	59.7	59.7	59.7	59.7	450.0
2016-11-02 08:00:00	MSFT	Stock	59.71	59.76	59.7	59.7	2526.0
2016-11-02 08:30:00	MSFT	Stock	59.7	59.72	59.67	59.67	1730.0
2016-11-02 09:00:00	MSFT	Stock	59.63	59.95	59.63	59.83	16130.0
2016-11-02 09:30:00	MSFT	Stock	59.82	59.93	59.64	59.78	2080890.0
2016-11-02 10:00:00	MSFT	Stock	59.77	59.83	59.64	59.73	1042533.0
2016-11-02 10:30:00	MSFT	Stock	59.73	59.74	59.51	59.545	1286758.0
2016-11-02 11:00:00	MSFT	Stock	59.545	59.79	59.54	59.766	1050092.0
2016-11-02 11:30:00	MSFT	Stock	59.765	59.79	59.67	59.71	1152365.0
2016-11-02 12:00:00	MSFT	Stock	59.71	59.82	59.67	59.73	939291.0
2016-11-02 12:30:00	MSFT	Stock	59.73	59.745	59.59	59.6	806573.0
2016-11-02 13:00:00	MSFT	Stock	59.603	59.625	59.31	59.38	1459352.0
2016-11-02 13:30:00	MSFT	Stock	59.38	59.55	59.37	59.53	1240468.0
2016-11-02 14:00:00	MSFT	Stock	59.53	59.77	59.3	59.68	2415378.0
2016-11-02 14:30:00	MSFT	Stock	59.68	59.77	59.49	59.55	1411412.0
2016-11-02 15:00:00	MSFT	Stock	59.545	59.69	59.48	59.652	1265703.0
2016-11-02 15:30:00	MSFT	Stock	59.66	59.67	59.41	59.43	2426613.0
2016-11-02 16:00:00	MSFT	Stock	59.43	59.51	59.35	59.5	1862574.0

> showing 50 of 80,755 rows — these rows as CSV

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