PREVIEW / stock_1hour / 2015-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-05.parquet
  size:    1.0 MB
  rows:    48,457
  symbols: 3,494

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-05 04:00:00	AAPL	Stock	32.165	32.22	32.165	32.21	12820.0
2015-03-05 05:00:00	AAPL	Stock	32.1975	32.2175	32.1975	32.2175	11580.0
2015-03-05 06:00:00	AAPL	Stock	32.2175	32.2325	32.2125	32.225	22208.0
2015-03-05 07:00:00	AAPL	Stock	32.2125	32.235	32.2025	32.2025	100808.0
2015-03-05 08:00:00	AAPL	Stock	32.205	32.2475	32.1025	32.195	777196.0
2015-03-05 09:00:00	AAPL	Stock	32.175	32.1975	31.93	31.955	25496900.0
2015-03-05 10:00:00	AAPL	Stock	31.955	32.0	31.7525	31.78	40553448.0
2015-03-05 11:00:00	AAPL	Stock	31.7775	31.7925	31.5772	31.735	41776272.0
2015-03-05 12:00:00	AAPL	Stock	31.735	31.7428	31.44	31.48	26070340.0
2015-03-05 13:00:00	AAPL	Stock	31.48	31.6125	31.4525	31.585	17765056.0
2015-03-05 14:00:00	AAPL	Stock	31.58	31.7325	31.58	31.6775	20190172.0
2015-03-05 15:00:00	AAPL	Stock	31.6775	31.68	31.535	31.6	28504280.0
2015-03-05 16:00:00	AAPL	Stock	31.6025	31.7722	31.565	31.5748	8471776.0
2015-03-05 17:00:00	AAPL	Stock	31.575	31.6025	31.5575	31.5625	177228.0
2015-03-05 18:00:00	AAPL	Stock	31.565	31.6025	31.55	31.565	127912.0
2015-03-05 19:00:00	AAPL	Stock	31.575	31.575	31.525	31.5375	219348.0
2015-03-05 08:00:00	MSFT	Stock	43.13	43.15	43.08	43.15	2377.0
2015-03-05 09:00:00	MSFT	Stock	43.1	43.24	42.82	43.14	3551599.0
2015-03-05 10:00:00	MSFT	Stock	43.14	43.22	43.08	43.15	2386729.0
2015-03-05 11:00:00	MSFT	Stock	43.14	43.2	43.09	43.14	2497395.0
2015-03-05 12:00:00	MSFT	Stock	43.14	43.18	43.025	43.095	2045373.0
2015-03-05 13:00:00	MSFT	Stock	43.09	43.15	43.03	43.135	1723080.0
2015-03-05 14:00:00	MSFT	Stock	43.14	43.19	43.09	43.16	1519260.0
2015-03-05 15:00:00	MSFT	Stock	43.16	43.19	43.07	43.09	4862143.0
2015-03-05 16:00:00	MSFT	Stock	43.11	43.152	43.01	43.01	3575001.0
2015-03-05 17:00:00	MSFT	Stock	43.05	43.07	43.05	43.06	5388.0
2015-03-05 18:00:00	MSFT	Stock	43.07	43.11	43.05	43.05	11121.0
2015-03-05 19:00:00	MSFT	Stock	43.05	43.05	43.04	43.04	762.0
2015-03-05 09:00:00	NVDA	Stock	0.5605	0.5624	0.5592	0.5619	22494840.0
2015-03-05 10:00:00	NVDA	Stock	0.5619	0.5675	0.5608	0.5662	47780920.0
2015-03-05 11:00:00	NVDA	Stock	0.5662	0.5685	0.5655	0.5685	41084640.0
2015-03-05 12:00:00	NVDA	Stock	0.5682	0.571	0.5658	0.5658	58413400.0
2015-03-05 13:00:00	NVDA	Stock	0.5658	0.5698	0.5658	0.5698	35719400.0
2015-03-05 14:00:00	NVDA	Stock	0.5698	0.5722	0.5695	0.5721	28509960.0
2015-03-05 15:00:00	NVDA	Stock	0.5722	0.5725	0.571	0.5716	68853760.0
2015-03-05 16:00:00	NVDA	Stock	0.5715	0.5715	0.5678	0.5678	1705000.0
2015-03-05 04:00:00	AMZN	Stock	19.126	19.126	19.126	19.126	12000.0
2015-03-05 08:00:00	AMZN	Stock	19.16	19.211	19.14	19.211	103300.0
2015-03-05 09:00:00	AMZN	Stock	19.1885	19.295	19.184	19.26	6686280.0
2015-03-05 10:00:00	AMZN	Stock	19.2625	19.4209	19.252	19.3668	12121020.0
2015-03-05 11:00:00	AMZN	Stock	19.3632	19.3665	19.2595	19.3292	5239040.0
2015-03-05 12:00:00	AMZN	Stock	19.334	19.354	19.3005	19.3125	2934220.0
2015-03-05 13:00:00	AMZN	Stock	19.3153	19.405	19.3135	19.3676	4719440.0
2015-03-05 14:00:00	AMZN	Stock	19.3725	19.409	19.3565	19.3882	5455760.0
2015-03-05 15:00:00	AMZN	Stock	19.39	19.414	19.328	19.3845	9918640.0
2015-03-05 16:00:00	AMZN	Stock	19.3915	19.4265	19.3523	19.4225	763160.0
2015-03-05 17:00:00	AMZN	Stock	19.3915	19.41	19.3915	19.41	29100.0
2015-03-05 18:00:00	AMZN	Stock	19.3915	19.3915	19.3915	19.3915	59260.0
2015-03-05 08:00:00	GOOGL	Stock	28.994	28.994	28.994	28.994	2000.0
2015-03-05 09:00:00	GOOGL	Stock	28.9675	29.1495	28.9115	29.0803	4052900.0

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

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