PREVIEW / stock_30min / 2014-07-16

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-16.parquet
  size:    1.6 MB
  rows:    82,433
  symbols: 3,568

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-07-16 04:00:00	AAPL	Stock	24.345	24.345	24.2	24.2725	27512.0
2014-07-16 04:30:00	AAPL	Stock	24.275	24.2825	24.2275	24.2475	27420.0
2014-07-16 05:00:00	AAPL	Stock	24.2475	24.27	24.2475	24.27	13360.0
2014-07-16 05:30:00	AAPL	Stock	24.2875	24.315	24.2875	24.315	4200.0
2014-07-16 06:00:00	AAPL	Stock	24.3375	24.35	24.3225	24.33	28516.0
2014-07-16 06:30:00	AAPL	Stock	24.325	24.395	24.31	24.375	174900.0
2014-07-16 07:00:00	AAPL	Stock	24.3675	24.42	24.3075	24.42	294172.0
2014-07-16 07:30:00	AAPL	Stock	24.4075	24.4975	24.4	24.4075	508268.0
2014-07-16 08:00:00	AAPL	Stock	24.4125	24.49	24.3	24.345	2164696.0
2014-07-16 08:30:00	AAPL	Stock	24.345	24.36	24.31	24.3375	682856.0
2014-07-16 09:00:00	AAPL	Stock	24.3375	24.3675	24.235	24.2425	2098232.0
2014-07-16 09:30:00	AAPL	Stock	24.2425	24.275	24.065	24.0925	44239148.0
2014-07-16 10:00:00	AAPL	Stock	24.0925	24.14	24.0175	24.04	17945376.0
2014-07-16 10:30:00	AAPL	Stock	24.0425	24.105	24.0325	24.0375	13821528.0
2014-07-16 11:00:00	AAPL	Stock	24.0375	24.125	24.0375	24.12	10472104.0
2014-07-16 11:30:00	AAPL	Stock	24.12	24.12	24.0475	24.0902	8420816.0
2014-07-16 12:00:00	AAPL	Stock	24.09	24.125	24.0725	24.11	6386944.0
2014-07-16 12:30:00	AAPL	Stock	24.11	24.125	24.055	24.0575	5802992.0
2014-07-16 13:00:00	AAPL	Stock	24.055	24.0725	23.98	24.0475	9241012.0
2014-07-16 13:30:00	AAPL	Stock	24.0475	24.0525	23.9825	24.005	4996744.0
2014-07-16 14:00:00	AAPL	Stock	24.0075	24.045	23.9962	24.0275	6399780.0
2014-07-16 14:30:00	AAPL	Stock	24.03	24.045	23.9675	23.9675	6632252.0
2014-07-16 15:00:00	AAPL	Stock	23.9675	24.0025	23.8975	23.9188	10437040.0
2014-07-16 15:30:00	AAPL	Stock	23.9188	23.935	23.685	23.695	32241280.0
2014-07-16 16:00:00	AAPL	Stock	23.695	24.086	23.685	23.7375	8221128.0
2014-07-16 16:30:00	AAPL	Stock	23.7375	23.78	23.695	23.775	756428.0
2014-07-16 17:00:00	AAPL	Stock	23.77	23.77	23.695	23.7325	221240.0
2014-07-16 17:30:00	AAPL	Stock	23.7325	23.7525	23.7325	23.7525	102412.0
2014-07-16 18:00:00	AAPL	Stock	23.7525	23.755	23.7325	23.7325	140628.0
2014-07-16 18:30:00	AAPL	Stock	23.7375	23.745	23.695	23.74	198248.0
2014-07-16 19:00:00	AAPL	Stock	23.745	23.745	23.73	23.7375	47404.0
2014-07-16 19:30:00	AAPL	Stock	23.735	23.735	23.695	23.695	156280.0
2014-07-16 07:00:00	MSFT	Stock	42.61	42.61	42.61	42.61	100.0
2014-07-16 07:30:00	MSFT	Stock	42.62	42.71	42.6	42.7	6845.0
2014-07-16 08:00:00	MSFT	Stock	42.67	42.7	42.6	42.65	8577.0
2014-07-16 08:30:00	MSFT	Stock	42.65	42.72	42.65	42.66	23594.0
2014-07-16 09:00:00	MSFT	Stock	42.66	42.66	42.47	42.5	46057.0
2014-07-16 09:30:00	MSFT	Stock	42.51	42.98	42.48	42.98	5594702.0
2014-07-16 10:00:00	MSFT	Stock	42.98	43.13	42.955	43.06	4875661.0
2014-07-16 10:30:00	MSFT	Stock	43.07	43.11	42.92	42.99	3206637.0
2014-07-16 11:00:00	MSFT	Stock	42.99	43.25	42.93	43.23	3392746.0
2014-07-16 11:30:00	MSFT	Stock	43.23	43.46	43.15	43.435	2942324.0
2014-07-16 12:00:00	MSFT	Stock	43.43	43.89	43.43	43.76	4889357.0
2014-07-16 12:30:00	MSFT	Stock	43.76	43.935	43.75	43.905	3547538.0
2014-07-16 13:00:00	MSFT	Stock	43.9	43.99	43.835	43.975	2665129.0
2014-07-16 13:30:00	MSFT	Stock	43.973	43.99	43.86	43.865	2464319.0
2014-07-16 14:00:00	MSFT	Stock	43.865	44.06	43.845	43.97	4320874.0
2014-07-16 14:30:00	MSFT	Stock	43.96	44.0	43.915	43.944	3405144.0
2014-07-16 15:00:00	MSFT	Stock	43.94	44.18	43.94	44.172	6557651.0
2014-07-16 15:30:00	MSFT	Stock	44.18	44.31	43.98	44.07	8832027.0

> showing 50 of 82,433 rows — these rows as CSV

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