PREVIEW / stock_30min / 2014-10-30

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-30.parquet
  size:    1.5 MB
  rows:    79,387
  symbols: 3,554

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-10-30 04:00:00	AAPL	Stock	26.8	26.85	26.8	26.825	12400.0
2014-10-30 04:30:00	AAPL	Stock	26.825	26.825	26.775	26.775	44120.0
2014-10-30 05:00:00	AAPL	Stock	26.775	26.775	26.7025	26.715	22084.0
2014-10-30 05:30:00	AAPL	Stock	26.7025	26.7025	26.665	26.69	21164.0
2014-10-30 06:00:00	AAPL	Stock	26.68	26.71	26.65	26.71	52144.0
2014-10-30 06:30:00	AAPL	Stock	26.7075	26.7075	26.65	26.65	32616.0
2014-10-30 07:00:00	AAPL	Stock	26.6475	26.6875	26.6125	26.65	167708.0
2014-10-30 07:30:00	AAPL	Stock	26.64	26.6725	26.6	26.6725	137624.0
2014-10-30 08:00:00	AAPL	Stock	26.6625	26.835	26.61	26.7375	427936.0
2014-10-30 08:30:00	AAPL	Stock	26.745	26.7975	26.7325	26.7325	252368.0
2014-10-30 09:00:00	AAPL	Stock	26.7325	26.775	26.69	26.7125	406460.0
2014-10-30 09:30:00	AAPL	Stock	26.7125	26.8225	26.71	26.74	17289792.0
2014-10-30 10:00:00	AAPL	Stock	26.74	26.755	26.66	26.695	11934360.0
2014-10-30 10:30:00	AAPL	Stock	26.6925	26.7225	26.475	26.57	21916296.0
2014-10-30 11:00:00	AAPL	Stock	26.57	26.6425	26.565	26.615	9884380.0
2014-10-30 11:30:00	AAPL	Stock	26.6175	26.6375	26.5625	26.6118	6692196.0
2014-10-30 12:00:00	AAPL	Stock	26.615	26.7	26.6	26.6985	7529956.0
2014-10-30 12:30:00	AAPL	Stock	26.6982	26.7575	26.695	26.755	7454952.0
2014-10-30 13:00:00	AAPL	Stock	26.7528	26.8375	26.7075	26.8025	10032748.0
2014-10-30 13:30:00	AAPL	Stock	26.8025	26.81	26.7575	26.79	5923900.0
2014-10-30 14:00:00	AAPL	Stock	26.79	26.8	26.705	26.7125	7166160.0
2014-10-30 14:30:00	AAPL	Stock	26.7125	26.75	26.635	26.6562	7130184.0
2014-10-30 15:00:00	AAPL	Stock	26.656	26.675	26.625	26.65	7023604.0
2014-10-30 15:30:00	AAPL	Stock	26.65	26.745	26.6488	26.745	14563364.0
2014-10-30 16:00:00	AAPL	Stock	26.745	26.745	26.6045	26.7125	17050332.0
2014-10-30 16:30:00	AAPL	Stock	26.745	26.745	26.6855	26.7125	194996.0
2014-10-30 17:00:00	AAPL	Stock	26.715	26.74	26.715	26.7325	31448.0
2014-10-30 17:30:00	AAPL	Stock	26.7325	26.745	26.7325	26.7325	35140.0
2014-10-30 18:00:00	AAPL	Stock	26.73	26.73	26.705	26.7175	38664.0
2014-10-30 18:30:00	AAPL	Stock	26.7225	26.755	26.7225	26.7325	153668.0
2014-10-30 19:00:00	AAPL	Stock	26.755	26.755	26.7375	26.7475	29640.0
2014-10-30 19:30:00	AAPL	Stock	26.7425	26.775	26.74	26.775	56500.0
2014-10-30 05:00:00	MSFT	Stock	46.42	46.42	46.42	46.42	500.0
2014-10-30 07:30:00	MSFT	Stock	46.26	46.26	46.25	46.25	1400.0
2014-10-30 08:00:00	MSFT	Stock	46.29	46.34	46.29	46.34	4598.0
2014-10-30 08:30:00	MSFT	Stock	46.34	46.41	46.3	46.3	3458.0
2014-10-30 09:00:00	MSFT	Stock	46.35	46.4	46.25	46.25	9974.0
2014-10-30 09:30:00	MSFT	Stock	46.25	46.32	45.925	45.95	2779482.0
2014-10-30 10:00:00	MSFT	Stock	45.95	46.005	45.79	45.981	2321813.0
2014-10-30 10:30:00	MSFT	Stock	45.975	46.11	45.94	46.09	1543635.0
2014-10-30 11:00:00	MSFT	Stock	46.09	46.2	46.06	46.09	1415050.0
2014-10-30 11:30:00	MSFT	Stock	46.09	46.11	45.97	45.99	1838422.0
2014-10-30 12:00:00	MSFT	Stock	45.995	46.0	45.77	45.895	1994799.0
2014-10-30 12:30:00	MSFT	Stock	45.895	45.99	45.89	45.935	934630.0
2014-10-30 13:00:00	MSFT	Stock	45.935	46.27	45.93	46.23	3163643.0
2014-10-30 13:30:00	MSFT	Stock	46.24	46.245	46.07	46.11	1546044.0
2014-10-30 14:00:00	MSFT	Stock	46.12	46.13	45.97	45.981	1453355.0
2014-10-30 14:30:00	MSFT	Stock	45.99	46.16	45.92	45.94	1252869.0
2014-10-30 15:00:00	MSFT	Stock	45.94	45.95	45.83	45.84	1578076.0
2014-10-30 15:30:00	MSFT	Stock	45.84	46.06	45.83	46.05	4736036.0

> showing 50 of 79,387 rows — these rows as CSV

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