PREVIEW / stock_1hour / 2015-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-15.parquet
  size:    1.1 MB
  rows:    48,958
  symbols: 3,519

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-04-15 04:00:00	AAPL	Stock	31.68	31.705	31.68	31.705	4708.0
2015-04-15 05:00:00	AAPL	Stock	31.6875	31.6875	31.6875	31.6875	4000.0
2015-04-15 06:00:00	AAPL	Stock	31.655	31.75	31.6525	31.7075	40444.0
2015-04-15 07:00:00	AAPL	Stock	31.7075	31.7075	31.63	31.645	26676.0
2015-04-15 08:00:00	AAPL	Stock	31.6425	31.6875	31.6075	31.66	344420.0
2015-04-15 09:00:00	AAPL	Stock	31.6675	31.7125	31.5275	31.59	16290416.0
2015-04-15 10:00:00	AAPL	Stock	31.585	31.64	31.53	31.579	14627676.0
2015-04-15 11:00:00	AAPL	Stock	31.58	31.6025	31.5025	31.5725	12914716.0
2015-04-15 12:00:00	AAPL	Stock	31.5725	31.5775	31.505	31.5425	7672448.0
2015-04-15 13:00:00	AAPL	Stock	31.5425	31.645	31.5225	31.62	11777520.0
2015-04-15 14:00:00	AAPL	Stock	31.6175	31.7805	31.6075	31.7725	17706844.0
2015-04-15 15:00:00	AAPL	Stock	31.7715	31.7825	31.6625	31.695	18691288.0
2015-04-15 16:00:00	AAPL	Stock	31.695	31.735	31.6875	31.7225	6563704.0
2015-04-15 17:00:00	AAPL	Stock	31.715	31.7225	31.695	31.7125	57592.0
2015-04-15 18:00:00	AAPL	Stock	31.7125	31.7275	31.7002	31.715	59152.0
2015-04-15 19:00:00	AAPL	Stock	31.7225	31.725	31.695	31.72	42556.0
2015-04-15 05:00:00	MSFT	Stock	41.74	41.89	41.74	41.89	390.0
2015-04-15 06:00:00	MSFT	Stock	41.82	41.82	41.78	41.78	2200.0
2015-04-15 07:00:00	MSFT	Stock	41.94	42.0	41.83	41.93	17470.0
2015-04-15 08:00:00	MSFT	Stock	41.97	41.97	41.83	41.84	10155.0
2015-04-15 09:00:00	MSFT	Stock	41.83	42.04	41.68	41.91	3455492.0
2015-04-15 10:00:00	MSFT	Stock	41.91	41.96	41.8	41.91	3417494.0
2015-04-15 11:00:00	MSFT	Stock	41.91	42.04	41.87	42.04	2335879.0
2015-04-15 12:00:00	MSFT	Stock	42.035	42.14	42.015	42.08	2435273.0
2015-04-15 13:00:00	MSFT	Stock	42.07	42.21	42.05	42.201	2634890.0
2015-04-15 14:00:00	MSFT	Stock	42.205	42.45	42.18	42.45	3730882.0
2015-04-15 15:00:00	MSFT	Stock	42.445	42.46	42.24	42.26	5155763.0
2015-04-15 16:00:00	MSFT	Stock	42.255	42.43	42.24	42.43	2954316.0
2015-04-15 17:00:00	MSFT	Stock	42.25	42.29	42.25	42.255	13847.0
2015-04-15 18:00:00	MSFT	Stock	42.29	42.29	42.27	42.27	2500.0
2015-04-15 19:00:00	MSFT	Stock	42.26	42.27	42.2	42.26	744.0
2015-04-15 08:00:00	NVDA	Stock	0.5625	0.5625	0.5522	0.5522	10000.0
2015-04-15 09:00:00	NVDA	Stock	0.5595	0.565	0.5589	0.561	26518400.0
2015-04-15 10:00:00	NVDA	Stock	0.5612	0.564	0.5578	0.564	46716480.0
2015-04-15 11:00:00	NVDA	Stock	0.5639	0.5648	0.5612	0.5638	32147440.0
2015-04-15 12:00:00	NVDA	Stock	0.5638	0.565	0.5628	0.565	17484480.0
2015-04-15 13:00:00	NVDA	Stock	0.5648	0.5699	0.5646	0.5664	25072560.0
2015-04-15 14:00:00	NVDA	Stock	0.5665	0.5685	0.5658	0.5672	28230120.0
2015-04-15 15:00:00	NVDA	Stock	0.5674	0.5678	0.5652	0.5655	47122160.0
2015-04-15 16:00:00	NVDA	Stock	0.5658	0.5658	0.5593	0.5593	564680.0
2015-04-15 04:00:00	AMZN	Stock	19.2315	19.2315	19.2315	19.2315	6000.0
2015-04-15 08:00:00	AMZN	Stock	19.3	19.32	19.2805	19.3	20000.0
2015-04-15 09:00:00	AMZN	Stock	19.3	19.3145	19.12	19.1498	9150780.0
2015-04-15 10:00:00	AMZN	Stock	19.1545	19.1685	19.09	19.166	5974260.0
2015-04-15 11:00:00	AMZN	Stock	19.1695	19.211	19.082	19.152	4132300.0
2015-04-15 12:00:00	AMZN	Stock	19.1553	19.1895	19.135	19.1895	2273840.0
2015-04-15 13:00:00	AMZN	Stock	19.1908	19.242	19.1475	19.233	2568200.0
2015-04-15 14:00:00	AMZN	Stock	19.2315	19.2875	19.2135	19.2145	3407520.0
2015-04-15 15:00:00	AMZN	Stock	19.2155	19.243	19.1675	19.1716	4172580.0
2015-04-15 16:00:00	AMZN	Stock	19.1725	19.2995	19.1725	19.2475	3088320.0

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

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