PREVIEW / stock_30min / 2015-01-07

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-07.parquet
  size:    1.6 MB
  rows:    84,881
  symbols: 3,529

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
2015-01-07 04:00:00	AAPL	Stock	26.6875	26.7	26.6875	26.7	1200.0
2015-01-07 04:30:00	AAPL	Stock	26.6375	26.685	26.6375	26.685	2800.0
2015-01-07 05:00:00	AAPL	Stock	26.685	26.7	26.65	26.7	5600.0
2015-01-07 05:30:00	AAPL	Stock	26.7	26.7925	26.7	26.7825	3836.0
2015-01-07 06:00:00	AAPL	Stock	26.7875	26.8225	26.785	26.8125	23448.0
2015-01-07 06:30:00	AAPL	Stock	26.805	26.805	26.7	26.72	38000.0
2015-01-07 07:00:00	AAPL	Stock	26.7175	26.7725	26.7025	26.7625	90908.0
2015-01-07 07:30:00	AAPL	Stock	26.755	26.785	26.7325	26.775	114016.0
2015-01-07 08:00:00	AAPL	Stock	26.765	26.835	26.7075	26.8125	376700.0
2015-01-07 08:30:00	AAPL	Stock	26.81	26.8175	26.725	26.7375	447188.0
2015-01-07 09:00:00	AAPL	Stock	26.7475	26.825	26.745	26.7925	616640.0
2015-01-07 09:30:00	AAPL	Stock	26.8	26.9825	26.6738	26.96	27482956.0
2015-01-07 10:00:00	AAPL	Stock	26.9575	27.05	26.88	26.9562	17328752.0
2015-01-07 10:30:00	AAPL	Stock	26.955	26.9975	26.82	26.96	11543920.0
2015-01-07 11:00:00	AAPL	Stock	26.96	26.985	26.7775	26.84	10603176.0
2015-01-07 11:30:00	AAPL	Stock	26.835	27.0125	26.83	26.989	9189136.0
2015-01-07 12:00:00	AAPL	Stock	26.99	27.025	26.91	26.95	8879128.0
2015-01-07 12:30:00	AAPL	Stock	26.9488	26.975	26.9175	26.945	5472332.0
2015-01-07 13:00:00	AAPL	Stock	26.9475	26.99	26.8375	26.8588	6114648.0
2015-01-07 13:30:00	AAPL	Stock	26.86	26.975	26.852	26.95	5434972.0
2015-01-07 14:00:00	AAPL	Stock	26.9512	26.99	26.8575	26.8775	8582132.0
2015-01-07 14:30:00	AAPL	Stock	26.875	26.945	26.84	26.8625	6340352.0
2015-01-07 15:00:00	AAPL	Stock	26.8625	26.96	26.845	26.956	7553820.0
2015-01-07 15:30:00	AAPL	Stock	26.955	26.9675	26.9	26.9375	13284308.0
2015-01-07 16:00:00	AAPL	Stock	26.9375	26.9625	26.817	26.96	6322532.0
2015-01-07 16:30:00	AAPL	Stock	26.96	26.98	26.9375	26.975	97432.0
2015-01-07 17:00:00	AAPL	Stock	26.9408	26.995	26.9168	26.995	698628.0
2015-01-07 17:30:00	AAPL	Stock	26.995	27.045	26.9375	27.025	143988.0
2015-01-07 18:00:00	AAPL	Stock	27.0375	27.0375	27.0125	27.0325	56972.0
2015-01-07 18:30:00	AAPL	Stock	27.025	27.0375	27.01	27.0275	72056.0
2015-01-07 19:00:00	AAPL	Stock	27.015	27.025	27.0	27.01	30848.0
2015-01-07 19:30:00	AAPL	Stock	27.02	27.0375	26.9975	27.0375	137448.0
2015-01-07 06:30:00	MSFT	Stock	46.05	46.3	46.02	46.27	9450.0
2015-01-07 07:00:00	MSFT	Stock	46.22	46.24	46.11	46.21	9221.0
2015-01-07 07:30:00	MSFT	Stock	46.14	46.21	46.12	46.16	3110.0
2015-01-07 08:00:00	MSFT	Stock	46.11	46.3	46.09	46.18	13534.0
2015-01-07 08:30:00	MSFT	Stock	46.15	46.19	46.07	46.12	27270.0
2015-01-07 09:00:00	MSFT	Stock	46.14	46.15	45.86	45.93	39180.0
2015-01-07 09:30:00	MSFT	Stock	45.98	45.99	45.49	45.74	3879453.0
2015-01-07 10:00:00	MSFT	Stock	45.74	45.88	45.635	45.68	2182982.0
2015-01-07 10:30:00	MSFT	Stock	45.68	45.92	45.65	45.85	1552714.0
2015-01-07 11:00:00	MSFT	Stock	45.85	45.89	45.68	45.8	1457251.0
2015-01-07 11:30:00	MSFT	Stock	45.8	46.32	45.78	46.29	2272909.0
2015-01-07 12:00:00	MSFT	Stock	46.28	46.44	46.21	46.324	2248796.0
2015-01-07 12:30:00	MSFT	Stock	46.32	46.46	46.25	46.4	1232454.0
2015-01-07 13:00:00	MSFT	Stock	46.4	46.44	46.25	46.286	1573141.0
2015-01-07 13:30:00	MSFT	Stock	46.285	46.36	46.27	46.322	1107320.0
2015-01-07 14:00:00	MSFT	Stock	46.33	46.39	46.2	46.254	1618397.0
2015-01-07 14:30:00	MSFT	Stock	46.25	46.396	46.105	46.124	1190459.0
2015-01-07 15:00:00	MSFT	Stock	46.123	46.26	46.09	46.21	1188844.0

> showing 50 of 84,881 rows — these rows as CSV

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