PREVIEW / stock_30min / 2013-11-14

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-14.parquet
  size:    1.5 MB
  rows:    80,062
  symbols: 3,538

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
2013-11-14 06:00:00	AAPL	Stock	18.5657	18.5657	18.5657	18.5657	2800.0
2013-11-14 07:30:00	AAPL	Stock	18.5921	18.6232	18.5921	18.6232	89488.0
2013-11-14 08:00:00	AAPL	Stock	18.6196	18.6732	18.5714	18.6571	626948.0
2013-11-14 08:30:00	AAPL	Stock	18.6596	18.6632	18.6518	18.6518	816900.0
2013-11-14 09:00:00	AAPL	Stock	18.6518	18.6875	18.6429	18.6811	600292.0
2013-11-14 09:30:00	AAPL	Stock	18.6782	18.7593	18.6382	18.7321	57823136.0
2013-11-14 10:00:00	AAPL	Stock	18.7346	18.8089	18.7075	18.7911	39586260.0
2013-11-14 10:30:00	AAPL	Stock	18.7939	18.8525	18.7918	18.8266	23252544.0
2013-11-14 11:00:00	AAPL	Stock	18.8279	18.8632	18.7971	18.8443	23822428.0
2013-11-14 11:30:00	AAPL	Stock	18.8461	18.8561	18.8064	18.815	18713296.0
2013-11-14 12:00:00	AAPL	Stock	18.8162	18.8232	18.7775	18.8214	8873704.0
2013-11-14 12:30:00	AAPL	Stock	18.8246	18.8489	18.8161	18.8443	7748104.0
2013-11-14 13:00:00	AAPL	Stock	18.8439	18.8614	18.83	18.8411	10351320.0
2013-11-14 13:30:00	AAPL	Stock	18.8425	18.8689	18.8161	18.8675	9936108.0
2013-11-14 14:00:00	AAPL	Stock	18.8668	18.8929	18.8504	18.8834	14078484.0
2013-11-14 14:30:00	AAPL	Stock	18.8832	18.8982	18.8629	18.8711	11453764.0
2013-11-14 15:00:00	AAPL	Stock	18.8704	18.9029	18.8504	18.8568	13951980.0
2013-11-14 15:30:00	AAPL	Stock	18.8571	18.8875	18.8471	18.8639	26684532.0
2013-11-14 16:00:00	AAPL	Stock	18.8629	18.8704	18.8095	18.8666	8809724.0
2013-11-14 16:30:00	AAPL	Stock	18.8507	18.8629	18.6826	18.8282	360640.0
2013-11-14 17:00:00	AAPL	Stock	18.8282	18.8293	18.8243	18.8282	123144.0
2013-11-14 17:30:00	AAPL	Stock	18.8232	18.8629	18.8232	18.825	536816.0
2013-11-14 18:00:00	AAPL	Stock	18.825	18.8321	18.8196	18.8321	117936.0
2013-11-14 18:30:00	AAPL	Stock	18.8321	18.8629	18.8321	18.8325	61488.0
2013-11-14 19:00:00	AAPL	Stock	18.8379	18.8393	18.8357	18.8393	34552.0
2013-11-14 19:30:00	AAPL	Stock	18.8439	18.8482	18.8375	18.845	40712.0
2013-11-14 07:30:00	MSFT	Stock	38.0	38.0	38.0	38.0	1000.0
2013-11-14 08:00:00	MSFT	Stock	38.19	38.19	37.8	37.82	19519.0
2013-11-14 08:30:00	MSFT	Stock	37.82	37.98	37.71	37.8	32480.0
2013-11-14 09:00:00	MSFT	Stock	37.79	37.93	37.71	37.9	109859.0
2013-11-14 09:30:00	MSFT	Stock	37.91	38.13	37.72	37.89	8487629.0
2013-11-14 10:00:00	MSFT	Stock	37.885	37.93	37.72	37.91	6585055.0
2013-11-14 10:30:00	MSFT	Stock	37.91	37.96	37.77	37.801	3692807.0
2013-11-14 11:00:00	MSFT	Stock	37.8	37.97	37.75	37.91	2355966.0
2013-11-14 11:30:00	MSFT	Stock	37.905	38.0	37.87	37.925	2665754.0
2013-11-14 12:00:00	MSFT	Stock	37.925	37.95	37.835	37.86	2518647.0
2013-11-14 12:30:00	MSFT	Stock	37.86	37.9	37.84	37.867	1430045.0
2013-11-14 13:00:00	MSFT	Stock	37.87	37.89	37.835	37.88	1060834.0
2013-11-14 13:30:00	MSFT	Stock	37.88	37.89	37.83	37.89	1380532.0
2013-11-14 14:00:00	MSFT	Stock	37.88	37.99	37.86	37.948	2895913.0
2013-11-14 14:30:00	MSFT	Stock	37.94	37.965	37.91	37.95	2621770.0
2013-11-14 15:00:00	MSFT	Stock	37.955	38.06	37.94	38.046	1664904.0
2013-11-14 15:30:00	MSFT	Stock	38.05	38.08	37.99	38.02	3037148.0
2013-11-14 16:00:00	MSFT	Stock	38.03	38.038	37.909	37.96	3254270.0
2013-11-14 16:30:00	MSFT	Stock	38.026	38.03	37.876	38.0	56808.0
2013-11-14 17:30:00	MSFT	Stock	38.03	38.03	38.03	38.03	300.0
2013-11-14 18:00:00	MSFT	Stock	38.0	38.0	38.0	38.0	200.0
2013-11-14 18:30:00	MSFT	Stock	37.99	38.0	37.99	38.0	2700.0
2013-11-14 09:00:00	NVDA	Stock	0.4025	0.4028	0.4025	0.4028	41160.0
2013-11-14 09:30:00	NVDA	Stock	0.4025	0.4079	0.4022	0.4053	43928600.0

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

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