PREVIEW / stock_30min / 2014-04-04

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-04.parquet
  size:    1.6 MB
  rows:    83,725
  symbols: 3,544

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-04-04 05:00:00	AAPL	Stock	19.2754	19.2754	19.2754	19.2754	2884.0
2014-04-04 06:00:00	AAPL	Stock	19.2754	19.2896	19.2754	19.2896	16800.0
2014-04-04 07:30:00	AAPL	Stock	19.2839	19.2839	19.2696	19.2696	43036.0
2014-04-04 08:00:00	AAPL	Stock	19.2739	19.2821	19.1429	19.2682	127400.0
2014-04-04 08:30:00	AAPL	Stock	19.2636	19.2925	19.2425	19.2757	708372.0
2014-04-04 09:00:00	AAPL	Stock	19.2632	19.2918	19.2543	19.2861	510076.0
2014-04-04 09:30:00	AAPL	Stock	19.2804	19.2857	19.1546	19.185	26930288.0
2014-04-04 10:00:00	AAPL	Stock	19.185	19.2107	19.14	19.1857	17733352.0
2014-04-04 10:30:00	AAPL	Stock	19.1882	19.1896	19.1	19.1086	15633548.0
2014-04-04 11:00:00	AAPL	Stock	19.1079	19.1125	19.0536	19.0714	16448880.0
2014-04-04 11:30:00	AAPL	Stock	19.0675	19.0996	19.0465	19.0907	13858460.0
2014-04-04 12:00:00	AAPL	Stock	19.088	19.0964	19.025	19.0325	14238112.0
2014-04-04 12:30:00	AAPL	Stock	19.0307	19.0425	18.9654	18.9743	14440468.0
2014-04-04 13:00:00	AAPL	Stock	18.9757	19.0179	18.9736	18.9821	11088784.0
2014-04-04 13:30:00	AAPL	Stock	18.9779	19.0571	18.9643	19.0296	12566064.0
2014-04-04 14:00:00	AAPL	Stock	19.0271	19.0379	18.9746	18.9836	10561124.0
2014-04-04 14:30:00	AAPL	Stock	18.9871	19.0032	18.9493	18.9614	12621644.0
2014-04-04 15:00:00	AAPL	Stock	18.9625	19.0257	18.9507	19.0189	16092888.0
2014-04-04 15:30:00	AAPL	Stock	19.0186	19.0357	18.9939	18.9939	29331876.0
2014-04-04 16:00:00	AAPL	Stock	18.9939	19.0629	18.9929	19.0171	14776636.0
2014-04-04 16:30:00	AAPL	Stock	19.0179	19.0186	19.0107	19.0118	211232.0
2014-04-04 17:00:00	AAPL	Stock	19.0107	19.2425	18.9936	19.0171	413896.0
2014-04-04 17:30:00	AAPL	Stock	19.0179	19.0179	19.0129	19.0175	16800.0
2014-04-04 18:00:00	AAPL	Stock	18.9936	19.0179	18.9936	19.0107	546280.0
2014-04-04 18:30:00	AAPL	Stock	19.0011	19.0114	19.0	19.0	33656.0
2014-04-04 19:30:00	AAPL	Stock	19.01	19.0175	19.0071	19.0175	82376.0
2014-04-04 07:30:00	MSFT	Stock	41.02	41.02	41.0	41.0	1100.0
2014-04-04 08:00:00	MSFT	Stock	40.9	41.12	40.9	41.12	4096.0
2014-04-04 08:30:00	MSFT	Stock	41.13	41.25	41.1	41.17	37020.0
2014-04-04 09:00:00	MSFT	Stock	41.17	41.27	41.12	41.27	28210.0
2014-04-04 09:30:00	MSFT	Stock	41.24	41.39	40.67	40.86	3545058.0
2014-04-04 10:00:00	MSFT	Stock	40.855	40.95	40.475	40.67	4018544.0
2014-04-04 10:30:00	MSFT	Stock	40.674	40.75	40.4	40.43	3561136.0
2014-04-04 11:00:00	MSFT	Stock	40.43	40.45	40.18	40.24	3106315.0
2014-04-04 11:30:00	MSFT	Stock	40.24	40.25	39.87	40.005	5837294.0
2014-04-04 12:00:00	MSFT	Stock	40.0	40.045	39.695	39.96	4078511.0
2014-04-04 12:30:00	MSFT	Stock	39.955	39.99	39.71	39.75	2457803.0
2014-04-04 13:00:00	MSFT	Stock	39.755	39.925	39.7	39.84	2355954.0
2014-04-04 13:30:00	MSFT	Stock	39.84	39.88	39.7	39.77	2538544.0
2014-04-04 14:00:00	MSFT	Stock	39.775	39.886	39.745	39.81	1991668.0
2014-04-04 14:30:00	MSFT	Stock	39.805	39.93	39.64	39.92	3099293.0
2014-04-04 15:00:00	MSFT	Stock	39.916	40.11	39.84	40.094	3652959.0
2014-04-04 15:30:00	MSFT	Stock	40.09	40.1	39.87	39.87	6003190.0
2014-04-04 16:00:00	MSFT	Stock	39.87	40.145	39.85	39.87	2634293.0
2014-04-04 16:30:00	MSFT	Stock	39.9	39.95	39.88	39.95	1899.0
2014-04-04 17:00:00	MSFT	Stock	39.9	39.9	39.87	39.9	20558.0
2014-04-04 17:30:00	MSFT	Stock	39.9	39.9	39.87	39.9	39886.0
2014-04-04 18:00:00	MSFT	Stock	39.87	39.93	39.85	39.85	22102.0
2014-04-04 18:30:00	MSFT	Stock	39.91	39.91	39.84	39.85	2728.0
2014-04-04 19:00:00	MSFT	Stock	39.84	39.84	39.84	39.84	250.0

> showing 50 of 83,725 rows — these rows as CSV

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