PREVIEW / stock_1hour / 2014-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-03.parquet
  size:    1.0 MB
  rows:    49,018
  symbols: 3,582

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-09-03 04:00:00	AAPL	Stock	25.7475	25.9925	25.7475	25.945	106544.0
2014-09-03 05:00:00	AAPL	Stock	25.9375	25.96	25.925	25.95	31680.0
2014-09-03 06:00:00	AAPL	Stock	25.9475	25.9475	25.875	25.9125	150756.0
2014-09-03 07:00:00	AAPL	Stock	25.9125	25.9125	25.805	25.8175	257604.0
2014-09-03 08:00:00	AAPL	Stock	25.825	25.9125	25.725	25.7625	1768148.0
2014-09-03 09:00:00	AAPL	Stock	25.7525	25.82	24.975	25.07	103408556.0
2014-09-03 10:00:00	AAPL	Stock	25.07	25.2775	25.0075	25.0675	72978208.0
2014-09-03 11:00:00	AAPL	Stock	25.0662	25.0925	24.645	24.77	94388872.0
2014-09-03 12:00:00	AAPL	Stock	24.7725	24.9825	24.7	24.97	66209408.0
2014-09-03 13:00:00	AAPL	Stock	24.9675	25.045	24.9075	24.98	31138156.0
2014-09-03 14:00:00	AAPL	Stock	24.98	24.9975	24.7275	24.745	31872416.0
2014-09-03 15:00:00	AAPL	Stock	24.7425	24.8	24.7025	24.735	57997648.0
2014-09-03 16:00:00	AAPL	Stock	24.735	25.3898	24.73	24.765	7765972.0
2014-09-03 17:00:00	AAPL	Stock	24.7675	24.7875	24.735	24.7775	1027160.0
2014-09-03 18:00:00	AAPL	Stock	24.7775	24.805	24.735	24.7875	544584.0
2014-09-03 19:00:00	AAPL	Stock	24.7925	24.7975	24.75	24.75	356428.0
2014-09-03 04:00:00	MSFT	Stock	45.3	45.3	45.3	45.3	221.0
2014-09-03 06:00:00	MSFT	Stock	45.21	45.21	45.21	45.21	100.0
2014-09-03 07:00:00	MSFT	Stock	45.23	45.23	45.21	45.21	4502.0
2014-09-03 08:00:00	MSFT	Stock	45.19	45.21	45.0	45.02	24175.0
2014-09-03 09:00:00	MSFT	Stock	45.03	45.05	44.1	44.91	8064497.0
2014-09-03 10:00:00	MSFT	Stock	44.911	45.03	44.84	44.94	5182693.0
2014-09-03 11:00:00	MSFT	Stock	44.945	45.0	44.86	44.88	3199162.0
2014-09-03 12:00:00	MSFT	Stock	44.885	45.08	44.85	45.055	3549185.0
2014-09-03 13:00:00	MSFT	Stock	45.055	45.11	45.01	45.045	3787638.0
2014-09-03 14:00:00	MSFT	Stock	45.045	45.06	44.92	44.935	2414044.0
2014-09-03 15:00:00	MSFT	Stock	44.935	45.02	44.88	44.955	4430879.0
2014-09-03 16:00:00	MSFT	Stock	44.96	45.005	44.905	45.005	1273775.0
2014-09-03 17:00:00	MSFT	Stock	44.96	44.96	44.91	44.92	15382.0
2014-09-03 18:00:00	MSFT	Stock	44.91	44.99	44.91	44.99	15602.0
2014-09-03 19:00:00	MSFT	Stock	44.96	44.96	44.92	44.96	4337.0
2014-09-03 09:00:00	NVDA	Stock	0.488	0.4938	0.4868	0.4935	46220120.0
2014-09-03 10:00:00	NVDA	Stock	0.4936	0.4938	0.4902	0.493	43151680.0
2014-09-03 11:00:00	NVDA	Stock	0.493	0.493	0.4905	0.4915	28877880.0
2014-09-03 12:00:00	NVDA	Stock	0.4915	0.4935	0.491	0.4923	31322800.0
2014-09-03 13:00:00	NVDA	Stock	0.4923	0.4923	0.4911	0.4915	14460240.0
2014-09-03 14:00:00	NVDA	Stock	0.4915	0.4925	0.4911	0.4915	25995520.0
2014-09-03 15:00:00	NVDA	Stock	0.4912	0.4923	0.4908	0.492	49615840.0
2014-09-03 16:00:00	NVDA	Stock	0.4921	0.4923	0.491	0.4921	16366360.0
2014-09-03 17:00:00	NVDA	Stock	0.4921	0.4921	0.4921	0.4921	43120.0
2014-09-03 06:00:00	AMZN	Stock	17.1435	17.1435	17.1435	17.1435	2000.0
2014-09-03 08:00:00	AMZN	Stock	17.119	17.1895	17.075	17.078	163780.0
2014-09-03 09:00:00	AMZN	Stock	17.125	17.1635	17.0275	17.0446	5645840.0
2014-09-03 10:00:00	AMZN	Stock	17.038	17.0814	16.9125	16.988	5998600.0
2014-09-03 11:00:00	AMZN	Stock	16.9818	17.0	16.919	16.922	4308760.0
2014-09-03 12:00:00	AMZN	Stock	16.9198	16.9705	16.8775	16.931	3469860.0
2014-09-03 13:00:00	AMZN	Stock	16.9332	16.9765	16.915	16.9484	3248700.0
2014-09-03 14:00:00	AMZN	Stock	16.9478	16.972	16.922	16.926	3237760.0
2014-09-03 15:00:00	AMZN	Stock	16.926	16.965	16.894	16.95	7834840.0
2014-09-03 16:00:00	AMZN	Stock	16.95	16.9765	16.9403	16.95	1479960.0

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

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