PREVIEW / stock_1hour / 2014-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-24.parquet
  size:    1.0 MB
  rows:    48,520
  symbols: 3,573

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-06-24 04:00:00	AAPL	Stock	22.67	22.67	22.67	22.67	400.0
2014-06-24 05:00:00	AAPL	Stock	22.6925	22.695	22.665	22.675	17676.0
2014-06-24 06:00:00	AAPL	Stock	22.685	22.695	22.6825	22.695	4640.0
2014-06-24 07:00:00	AAPL	Stock	22.7	22.7425	22.7	22.74	103420.0
2014-06-24 08:00:00	AAPL	Stock	22.7375	22.7425	22.6975	22.73	368668.0
2014-06-24 09:00:00	AAPL	Stock	22.7275	22.8325	22.66	22.79	20817496.0
2014-06-24 10:00:00	AAPL	Stock	22.7875	22.9122	22.7875	22.8725	26951988.0
2014-06-24 11:00:00	AAPL	Stock	22.8745	22.935	22.8525	22.8672	16446004.0
2014-06-24 12:00:00	AAPL	Stock	22.865	22.92	22.8588	22.8925	10934552.0
2014-06-24 13:00:00	AAPL	Stock	22.89	22.8925	22.8	22.8525	13967856.0
2014-06-24 14:00:00	AAPL	Stock	22.855	22.855	22.775	22.78	11151392.0
2014-06-24 15:00:00	AAPL	Stock	22.78	22.78	22.5475	22.5725	40428480.0
2014-06-24 16:00:00	AAPL	Stock	22.5725	22.782	22.54	22.595	6706868.0
2014-06-24 17:00:00	AAPL	Stock	22.5875	22.8175	22.57	22.595	107596.0
2014-06-24 18:00:00	AAPL	Stock	22.595	22.6075	22.57	22.595	160124.0
2014-06-24 19:00:00	AAPL	Stock	22.595	22.5975	22.5825	22.595	42420.0
2014-06-24 05:00:00	MSFT	Stock	41.94	41.94	41.94	41.94	1909.0
2014-06-24 08:00:00	MSFT	Stock	41.95	41.95	41.87	41.89	1511.0
2014-06-24 09:00:00	MSFT	Stock	41.9	41.92	41.56	41.653	3262333.0
2014-06-24 10:00:00	MSFT	Stock	41.65	41.79	41.63	41.735	3244430.0
2014-06-24 11:00:00	MSFT	Stock	41.74	41.78	41.72	41.77	1778386.0
2014-06-24 12:00:00	MSFT	Stock	41.765	41.82	41.715	41.725	1137400.0
2014-06-24 13:00:00	MSFT	Stock	41.73	41.78	41.565	41.775	2682853.0
2014-06-24 14:00:00	MSFT	Stock	41.78	41.94	41.76	41.805	3409167.0
2014-06-24 15:00:00	MSFT	Stock	41.805	41.805	41.59	41.745	5402732.0
2014-06-24 16:00:00	MSFT	Stock	41.74	41.78	41.615	41.74	4625567.0
2014-06-24 17:00:00	MSFT	Stock	41.745	41.92	41.7	41.7	5893.0
2014-06-24 18:00:00	MSFT	Stock	41.77	41.78	41.7	41.7	17607.0
2014-06-24 19:00:00	MSFT	Stock	41.75	41.78	41.75	41.78	900.0
2014-06-24 07:00:00	NVDA	Stock	0.463	0.4638	0.463	0.4638	16240.0
2014-06-24 09:00:00	NVDA	Stock	0.467	0.468	0.465	0.4656	18317440.0
2014-06-24 10:00:00	NVDA	Stock	0.4658	0.4689	0.4658	0.4688	30103080.0
2014-06-24 11:00:00	NVDA	Stock	0.4689	0.4702	0.468	0.4695	28708360.0
2014-06-24 12:00:00	NVDA	Stock	0.4694	0.4708	0.4668	0.4668	16305600.0
2014-06-24 13:00:00	NVDA	Stock	0.467	0.467	0.4643	0.4643	24599200.0
2014-06-24 14:00:00	NVDA	Stock	0.4643	0.4655	0.461	0.4629	34915360.0
2014-06-24 15:00:00	NVDA	Stock	0.4628	0.4628	0.4585	0.4608	99746960.0
2014-06-24 16:00:00	NVDA	Stock	0.4605	0.4686	0.46	0.4604	12698600.0
2014-06-24 18:00:00	NVDA	Stock	0.4608	0.4608	0.4608	0.4608	4000.0
2014-06-24 07:00:00	AMZN	Stock	16.3625	16.3625	16.3425	16.348	59000.0
2014-06-24 08:00:00	AMZN	Stock	16.3465	16.3575	16.341	16.3575	86540.0
2014-06-24 09:00:00	AMZN	Stock	16.35	16.46	16.28	16.342	6637180.0
2014-06-24 10:00:00	AMZN	Stock	16.326	16.434	16.2635	16.3775	6622260.0
2014-06-24 11:00:00	AMZN	Stock	16.3775	16.473	16.325	16.4315	7469560.0
2014-06-24 12:00:00	AMZN	Stock	16.4335	16.4865	16.4135	16.445	3505380.0
2014-06-24 13:00:00	AMZN	Stock	16.4445	16.445	16.28	16.2847	5332440.0
2014-06-24 14:00:00	AMZN	Stock	16.2843	16.325	16.235	16.2765	5291940.0
2014-06-24 15:00:00	AMZN	Stock	16.265	16.2655	16.1369	16.208	10088380.0
2014-06-24 16:00:00	AMZN	Stock	16.208	16.3252	16.1955	16.208	410860.0
2014-06-24 17:00:00	AMZN	Stock	16.208	16.21	16.208	16.21	18000.0

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

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