PREVIEW / stock_1hour / 2014-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-26.parquet
  size:    1.0 MB
  rows:    48,795
  symbols: 3,591

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-08-26 04:00:00	AAPL	Stock	25.3125	25.3525	25.3125	25.3475	11396.0
2014-08-26 05:00:00	AAPL	Stock	25.3425	25.3425	25.31	25.31	10312.0
2014-08-26 06:00:00	AAPL	Stock	25.3125	25.35	25.3125	25.35	19756.0
2014-08-26 07:00:00	AAPL	Stock	25.335	25.3975	25.325	25.3875	90112.0
2014-08-26 08:00:00	AAPL	Stock	25.385	25.395	25.325	25.375	563820.0
2014-08-26 09:00:00	AAPL	Stock	25.375	25.3825	25.215	25.305	26828672.0
2014-08-26 10:00:00	AAPL	Stock	25.305	25.315	25.2175	25.2575	27364616.0
2014-08-26 11:00:00	AAPL	Stock	25.2575	25.2975	25.2475	25.29	15154724.0
2014-08-26 12:00:00	AAPL	Stock	25.2888	25.35	25.2675	25.2775	10901204.0
2014-08-26 13:00:00	AAPL	Stock	25.279	25.3025	25.26	25.295	7290752.0
2014-08-26 14:00:00	AAPL	Stock	25.2975	25.32	25.2688	25.28	10467192.0
2014-08-26 15:00:00	AAPL	Stock	25.28	25.3	25.22	25.2225	19128984.0
2014-08-26 16:00:00	AAPL	Stock	25.2225	25.2832	19.4375	25.2275	3566784.0
2014-08-26 17:00:00	AAPL	Stock	25.2275	25.4075	25.2225	25.2425	124028.0
2014-08-26 18:00:00	AAPL	Stock	25.2225	25.25	25.2225	25.2475	128236.0
2014-08-26 19:00:00	AAPL	Stock	25.24	25.2575	25.235	25.255	93664.0
2014-08-26 06:00:00	MSFT	Stock	45.13	45.13	45.13	45.13	100.0
2014-08-26 07:00:00	MSFT	Stock	45.01	45.17	45.01	45.17	2100.0
2014-08-26 08:00:00	MSFT	Stock	45.25	45.25	45.25	45.25	1632.0
2014-08-26 09:00:00	MSFT	Stock	45.26	45.395	45.15	45.22	1521518.0
2014-08-26 10:00:00	MSFT	Stock	45.22	45.3	45.11	45.21	2191671.0
2014-08-26 11:00:00	MSFT	Stock	45.22	45.23	45.02	45.025	1737303.0
2014-08-26 12:00:00	MSFT	Stock	45.03	45.06	44.94	44.97	1587769.0
2014-08-26 13:00:00	MSFT	Stock	44.97	45.09	44.96	45.07	1110179.0
2014-08-26 14:00:00	MSFT	Stock	45.07	45.08	45.02	45.06	997262.0
2014-08-26 15:00:00	MSFT	Stock	45.055	45.09	44.98	45.0	3340621.0
2014-08-26 16:00:00	MSFT	Stock	45.005	45.161	44.99	45.04	901667.0
2014-08-26 17:00:00	MSFT	Stock	45.005	45.21	44.93	45.21	8880.0
2014-08-26 18:00:00	MSFT	Stock	45.01	45.03	45.01	45.03	17797.0
2014-08-26 19:00:00	MSFT	Stock	45.0	45.03	44.97	45.0	4203.0
2014-08-26 08:00:00	NVDA	Stock	0.477	0.477	0.4745	0.4768	504000.0
2014-08-26 09:00:00	NVDA	Stock	0.4772	0.4822	0.4772	0.4818	21599400.0
2014-08-26 10:00:00	NVDA	Stock	0.4818	0.4825	0.4795	0.4818	58611240.0
2014-08-26 11:00:00	NVDA	Stock	0.4818	0.4825	0.4812	0.4816	22334480.0
2014-08-26 12:00:00	NVDA	Stock	0.4816	0.4821	0.4805	0.4812	12361280.0
2014-08-26 13:00:00	NVDA	Stock	0.4812	0.4843	0.481	0.4841	35402200.0
2014-08-26 14:00:00	NVDA	Stock	0.484	0.485	0.484	0.4843	20155760.0
2014-08-26 15:00:00	NVDA	Stock	0.4844	0.4872	0.4843	0.4864	81275600.0
2014-08-26 16:00:00	NVDA	Stock	0.486	0.4872	0.4834	0.4864	3050600.0
2014-08-26 17:00:00	NVDA	Stock	0.4864	0.4864	0.4864	0.4864	10560.0
2014-08-26 18:00:00	NVDA	Stock	0.4865	0.4865	0.4865	0.4865	19720.0
2014-08-26 07:00:00	AMZN	Stock	16.8185	16.8265	16.786	16.786	21280.0
2014-08-26 08:00:00	AMZN	Stock	16.8275	16.8515	16.7975	16.849	293560.0
2014-08-26 09:00:00	AMZN	Stock	16.845	16.8935	16.7275	16.814	10529340.0
2014-08-26 10:00:00	AMZN	Stock	16.812	17.0448	16.7885	17.023	11898540.0
2014-08-26 11:00:00	AMZN	Stock	17.024	17.159	17.0055	17.0955	13815100.0
2014-08-26 12:00:00	AMZN	Stock	17.0958	17.1585	17.0775	17.1115	4978060.0
2014-08-26 13:00:00	AMZN	Stock	17.1055	17.1605	17.1005	17.1605	3629080.0
2014-08-26 14:00:00	AMZN	Stock	17.161	17.2105	17.1375	17.196	6084320.0
2014-08-26 15:00:00	AMZN	Stock	17.195	17.218	17.087	17.092	10179320.0

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

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