PREVIEW / stock_1hour / 2013-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-14.parquet
  size:    1.0 MB
  rows:    47,506
  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:00: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.6518	1443848.0
2013-11-14 09:00:00	AAPL	Stock	18.6518	18.7593	18.6382	18.7321	58423428.0
2013-11-14 10:00:00	AAPL	Stock	18.7346	18.8525	18.7075	18.8266	62838804.0
2013-11-14 11:00:00	AAPL	Stock	18.8279	18.8632	18.7971	18.815	42535724.0
2013-11-14 12:00:00	AAPL	Stock	18.8162	18.8489	18.7775	18.8443	16621808.0
2013-11-14 13:00:00	AAPL	Stock	18.8439	18.8689	18.8161	18.8675	20287428.0
2013-11-14 14:00:00	AAPL	Stock	18.8668	18.8982	18.8504	18.8711	25532248.0
2013-11-14 15:00:00	AAPL	Stock	18.8704	18.9029	18.8471	18.8639	40636512.0
2013-11-14 16:00:00	AAPL	Stock	18.8629	18.8704	18.6826	18.8282	9170364.0
2013-11-14 17:00:00	AAPL	Stock	18.8282	18.8629	18.8232	18.825	659960.0
2013-11-14 18:00:00	AAPL	Stock	18.825	18.8629	18.8196	18.8325	179424.0
2013-11-14 19:00:00	AAPL	Stock	18.8379	18.8482	18.8357	18.845	75264.0
2013-11-14 07:00: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.71	37.8	51999.0
2013-11-14 09:00:00	MSFT	Stock	37.79	38.13	37.71	37.89	8597488.0
2013-11-14 10:00:00	MSFT	Stock	37.885	37.96	37.72	37.801	10277862.0
2013-11-14 11:00:00	MSFT	Stock	37.8	38.0	37.75	37.925	5021720.0
2013-11-14 12:00:00	MSFT	Stock	37.925	37.95	37.835	37.867	3948692.0
2013-11-14 13:00:00	MSFT	Stock	37.87	37.89	37.83	37.89	2441366.0
2013-11-14 14:00:00	MSFT	Stock	37.88	37.99	37.86	37.95	5517683.0
2013-11-14 15:00:00	MSFT	Stock	37.955	38.08	37.94	38.02	4702052.0
2013-11-14 16:00:00	MSFT	Stock	38.03	38.038	37.876	38.0	3311078.0
2013-11-14 17:00: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	37.99	38.0	2900.0
2013-11-14 09:00:00	NVDA	Stock	0.4025	0.4079	0.4022	0.4053	43969760.0
2013-11-14 10:00:00	NVDA	Stock	0.4055	0.406	0.403	0.404	38425680.0
2013-11-14 11:00:00	NVDA	Stock	0.4043	0.4048	0.403	0.4043	20482600.0
2013-11-14 12:00:00	NVDA	Stock	0.404	0.4053	0.404	0.4045	17931920.0
2013-11-14 13:00:00	NVDA	Stock	0.4043	0.4062	0.4043	0.4055	54695120.0
2013-11-14 14:00:00	NVDA	Stock	0.4054	0.4062	0.4053	0.4055	18092520.0
2013-11-14 15:00:00	NVDA	Stock	0.4055	0.4072	0.4055	0.4055	101198880.0
2013-11-14 16:00:00	NVDA	Stock	0.4055	0.4065	0.4054	0.4055	11205520.0
2013-11-14 17:00:00	NVDA	Stock	0.405	0.405	0.405	0.405	32000.0
2013-11-14 04:00:00	AMZN	Stock	17.841	17.841	17.841	17.841	2000.0
2013-11-14 07:00:00	AMZN	Stock	17.8275	17.8275	17.7365	17.767	22000.0
2013-11-14 08:00:00	AMZN	Stock	17.805	17.8215	17.768	17.8	109300.0
2013-11-14 09:00:00	AMZN	Stock	17.795	18.2	17.78	18.1605	14791920.0
2013-11-14 10:00:00	AMZN	Stock	18.1608	18.246	18.0805	18.1985	14238440.0
2013-11-14 11:00:00	AMZN	Stock	18.1985	18.345	18.161	18.2315	12984700.0
2013-11-14 12:00:00	AMZN	Stock	18.2295	18.312	18.1238	18.2865	7256280.0
2013-11-14 13:00:00	AMZN	Stock	18.2885	18.425	18.277	18.425	8345540.0
2013-11-14 14:00:00	AMZN	Stock	18.425	18.4385	18.35	18.408	7951760.0
2013-11-14 15:00:00	AMZN	Stock	18.41	18.447	18.3322	18.37	14074020.0
2013-11-14 16:00:00	AMZN	Stock	18.362	18.384	18.2234	18.305	3227620.0
2013-11-14 17:00:00	AMZN	Stock	18.335	18.355	18.335	18.355	6000.0
2013-11-14 18:00:00	AMZN	Stock	18.362	18.3845	18.362	18.3845	41160.0
2013-11-14 19:00:00	AMZN	Stock	18.384	18.385	18.3605	18.3775	44340.0
2013-11-14 04:00:00	META	Stock	48.84	48.93	48.8	48.81	8159.0

> showing 50 of 47,506 rows — these rows as CSV

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