PREVIEW / stock_1hour / 2014-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-17.parquet
  size:    1.0 MB
  rows:    48,612
  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-03-17 04:00:00	AAPL	Stock	18.795	18.7961	18.795	18.7961	14000.0
2014-03-17 05:00:00	AAPL	Stock	18.8646	18.8814	18.8646	18.8814	5600.0
2014-03-17 06:00:00	AAPL	Stock	18.8482	18.8536	18.8279	18.8536	19600.0
2014-03-17 07:00:00	AAPL	Stock	18.8304	18.8757	18.8304	18.8393	142296.0
2014-03-17 08:00:00	AAPL	Stock	18.8421	18.8857	18.8275	18.8357	1189748.0
2014-03-17 09:00:00	AAPL	Stock	18.8336	18.9275	18.8112	18.8718	32271148.0
2014-03-17 10:00:00	AAPL	Stock	18.8704	18.9105	18.7804	18.8314	30434068.0
2014-03-17 11:00:00	AAPL	Stock	18.8311	18.8929	18.8264	18.8861	15606248.0
2014-03-17 12:00:00	AAPL	Stock	18.8879	18.9257	18.8732	18.9096	15190364.0
2014-03-17 13:00:00	AAPL	Stock	18.9104	18.9168	18.8682	18.8939	11777584.0
2014-03-17 14:00:00	AAPL	Stock	18.8918	18.8946	18.8368	18.86	12727904.0
2014-03-17 15:00:00	AAPL	Stock	18.8607	18.8689	18.7875	18.8189	26156396.0
2014-03-17 16:00:00	AAPL	Stock	18.8121	18.9192	18.7986	18.8104	14509684.0
2014-03-17 17:00:00	AAPL	Stock	18.8143	18.8268	18.8046	18.8143	442708.0
2014-03-17 18:00:00	AAPL	Stock	18.8121	18.8214	18.8057	18.8214	115276.0
2014-03-17 19:00:00	AAPL	Stock	18.8189	18.8189	18.7893	18.8	172088.0
2014-03-17 07:00:00	MSFT	Stock	37.85	37.98	37.85	37.98	500.0
2014-03-17 08:00:00	MSFT	Stock	37.9	37.93	37.88	37.92	2345.0
2014-03-17 09:00:00	MSFT	Stock	37.93	38.31	37.76	38.3	2463482.0
2014-03-17 10:00:00	MSFT	Stock	38.3	38.41	38.11	38.14	4013204.0
2014-03-17 11:00:00	MSFT	Stock	38.13	38.2	37.94	38.05	1781125.0
2014-03-17 12:00:00	MSFT	Stock	38.05	38.25	38.013	38.14	1624416.0
2014-03-17 13:00:00	MSFT	Stock	38.143	38.22	38.135	38.185	1142564.0
2014-03-17 14:00:00	MSFT	Stock	38.19	38.265	38.155	38.195	1335750.0
2014-03-17 15:00:00	MSFT	Stock	38.19	38.2	38.01	38.04	5381918.0
2014-03-17 16:00:00	MSFT	Stock	38.05	38.153	38.004	38.127	1986809.0
2014-03-17 17:00:00	MSFT	Stock	38.05	38.14	38.05	38.14	61802.0
2014-03-17 18:00:00	MSFT	Stock	38.14	38.14	38.05	38.071	28940.0
2014-03-17 19:00:00	MSFT	Stock	38.14	38.14	38.05	38.05	2384.0
2014-03-17 08:00:00	NVDA	Stock	0.4385	0.45	0.4385	0.45	36000.0
2014-03-17 09:00:00	NVDA	Stock	0.4455	0.45	0.445	0.4482	24027200.0
2014-03-17 10:00:00	NVDA	Stock	0.4482	0.4492	0.4472	0.449	67186520.0
2014-03-17 11:00:00	NVDA	Stock	0.449	0.4492	0.4472	0.4475	42442840.0
2014-03-17 12:00:00	NVDA	Stock	0.4476	0.449	0.4469	0.4472	21727240.0
2014-03-17 13:00:00	NVDA	Stock	0.4472	0.4488	0.4468	0.4481	20922920.0
2014-03-17 14:00:00	NVDA	Stock	0.448	0.4482	0.4458	0.4462	24455640.0
2014-03-17 15:00:00	NVDA	Stock	0.4462	0.4475	0.4451	0.4452	55739800.0
2014-03-17 16:00:00	NVDA	Stock	0.4455	0.4477	0.4455	0.4455	2671520.0
2014-03-17 17:00:00	NVDA	Stock	0.4455	0.4455	0.4455	0.4455	166680.0
2014-03-17 18:00:00	NVDA	Stock	0.4455	0.4455	0.4455	0.4455	57600.0
2014-03-17 04:00:00	AMZN	Stock	18.725	18.75	18.725	18.75	4000.0
2014-03-17 05:00:00	AMZN	Stock	18.8375	18.8375	18.798	18.798	4000.0
2014-03-17 07:00:00	AMZN	Stock	18.8205	18.85	18.8	18.8	16000.0
2014-03-17 08:00:00	AMZN	Stock	18.8375	18.858	18.6215	18.858	324620.0
2014-03-17 09:00:00	AMZN	Stock	18.858	18.911	18.7795	18.862	7931720.0
2014-03-17 10:00:00	AMZN	Stock	18.8525	18.9425	18.8505	18.866	7977440.0
2014-03-17 11:00:00	AMZN	Stock	18.869	18.897	18.755	18.794	5331840.0
2014-03-17 12:00:00	AMZN	Stock	18.7945	18.874	18.7655	18.863	3395500.0
2014-03-17 13:00:00	AMZN	Stock	18.8625	18.8678	18.8	18.828	2993660.0
2014-03-17 14:00:00	AMZN	Stock	18.831	18.862	18.8165	18.8449	3498640.0

> showing 50 of 48,612 rows — these rows as CSV

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