PREVIEW / stock_1hour / 2015-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-06.parquet
  size:    1.1 MB
  rows:    49,213
  symbols: 3,516

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
2015-03-06 04:00:00	AAPL	Stock	31.5625	31.65	31.5625	31.625	20000.0
2015-03-06 05:00:00	AAPL	Stock	31.6425	31.685	31.625	31.63	25832.0
2015-03-06 06:00:00	AAPL	Stock	31.63	31.665	31.6225	31.625	72892.0
2015-03-06 07:00:00	AAPL	Stock	31.625	31.8675	31.625	31.825	413764.0
2015-03-06 08:00:00	AAPL	Stock	31.815	31.85	31.625	31.7825	1716572.0
2015-03-06 09:00:00	AAPL	Stock	31.7875	32.4625	31.7875	32.3013	65610744.0
2015-03-06 10:00:00	AAPL	Stock	32.3025	32.3425	32.0775	32.155	47980364.0
2015-03-06 11:00:00	AAPL	Stock	32.1528	32.155	31.83	31.946	35562156.0
2015-03-06 12:00:00	AAPL	Stock	31.9472	32.0422	31.85	31.882	23932180.0
2015-03-06 13:00:00	AAPL	Stock	31.8838	31.915	31.7025	31.775	21455348.0
2015-03-06 14:00:00	AAPL	Stock	31.7725	31.91	31.6825	31.69	24654636.0
2015-03-06 15:00:00	AAPL	Stock	31.6918	31.8175	31.565	31.6475	40506528.0
2015-03-06 16:00:00	AAPL	Stock	31.65	31.967	31.63	31.7175	12689276.0
2015-03-06 17:00:00	AAPL	Stock	31.7225	31.9205	31.65	31.72	457304.0
2015-03-06 18:00:00	AAPL	Stock	31.725	31.7675	31.725	31.7675	238148.0
2015-03-06 19:00:00	AAPL	Stock	31.7625	31.7775	31.745	31.7625	157456.0
2015-03-06 08:00:00	MSFT	Stock	43.02	43.1	42.9	42.95	8598.0
2015-03-06 09:00:00	MSFT	Stock	42.949	43.11	42.78	42.98	3451661.0
2015-03-06 10:00:00	MSFT	Stock	42.98	43.025	42.653	42.676	3721560.0
2015-03-06 11:00:00	MSFT	Stock	42.675	42.68	42.3	42.374	5147817.0
2015-03-06 12:00:00	MSFT	Stock	42.375	42.47	42.25	42.29	4372850.0
2015-03-06 13:00:00	MSFT	Stock	42.3	42.34	42.16	42.25	3117579.0
2015-03-06 14:00:00	MSFT	Stock	42.25	42.39	42.15	42.21	3341013.0
2015-03-06 15:00:00	MSFT	Stock	42.21	42.38	42.21	42.365	5987823.0
2015-03-06 16:00:00	MSFT	Stock	42.36	42.486	42.254	42.36	4994869.0
2015-03-06 17:00:00	MSFT	Stock	42.39	42.42	42.36	42.42	112114.0
2015-03-06 18:00:00	MSFT	Stock	42.42	42.43	42.42	42.43	1169.0
2015-03-06 19:00:00	MSFT	Stock	42.41	42.44	42.41	42.44	5084.0
2015-03-06 08:00:00	NVDA	Stock	0.5725	0.5738	0.5725	0.5725	79600.0
2015-03-06 09:00:00	NVDA	Stock	0.5705	0.5708	0.564	0.5684	28210320.0
2015-03-06 10:00:00	NVDA	Stock	0.5682	0.571	0.567	0.5675	31899560.0
2015-03-06 11:00:00	NVDA	Stock	0.5675	0.568	0.5655	0.5672	40908760.0
2015-03-06 12:00:00	NVDA	Stock	0.5672	0.5675	0.564	0.5654	24628640.0
2015-03-06 13:00:00	NVDA	Stock	0.5655	0.5665	0.5638	0.5657	25100840.0
2015-03-06 14:00:00	NVDA	Stock	0.5658	0.5665	0.5638	0.5642	22476680.0
2015-03-06 15:00:00	NVDA	Stock	0.564	0.5658	0.5631	0.5638	63259280.0
2015-03-06 16:00:00	NVDA	Stock	0.5638	0.5658	0.5637	0.5638	3707440.0
2015-03-06 17:00:00	NVDA	Stock	0.5661	0.5661	0.5661	0.5661	397200.0
2015-03-06 18:00:00	NVDA	Stock	0.5642	0.5642	0.5642	0.5642	80000.0
2015-03-06 06:00:00	AMZN	Stock	19.4	19.4	19.4	19.4	2180.0
2015-03-06 07:00:00	AMZN	Stock	19.419	19.419	19.419	19.419	10000.0
2015-03-06 08:00:00	AMZN	Stock	19.42	19.4425	19.3415	19.4	206760.0
2015-03-06 09:00:00	AMZN	Stock	19.3705	19.38	19.2105	19.2655	7720560.0
2015-03-06 10:00:00	AMZN	Stock	19.283	19.3245	19.193	19.2206	5995620.0
2015-03-06 11:00:00	AMZN	Stock	19.215	19.225	19.125	19.1338	5388540.0
2015-03-06 12:00:00	AMZN	Stock	19.139	19.174	19.0405	19.0545	4396760.0
2015-03-06 13:00:00	AMZN	Stock	19.0505	19.0748	19.0248	19.0365	3945220.0
2015-03-06 14:00:00	AMZN	Stock	19.036	19.0845	18.95	18.9665	6383000.0
2015-03-06 15:00:00	AMZN	Stock	18.968	19.0135	18.944	19.0045	8976540.0
2015-03-06 16:00:00	AMZN	Stock	19.0045	19.2391	19.0	19.0	5678600.0

> showing 50 of 49,213 rows — these rows as CSV

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