PREVIEW / stock_1hour / 2015-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-04.parquet
  size:    1.0 MB
  rows:    48,728
  symbols: 3,522

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-05-04 04:00:00	AAPL	Stock	32.33	32.445	32.3025	32.41	93960.0
2015-05-04 05:00:00	AAPL	Stock	32.415	32.415	32.3375	32.3375	33064.0
2015-05-04 06:00:00	AAPL	Stock	32.3625	32.375	32.325	32.3625	62864.0
2015-05-04 07:00:00	AAPL	Stock	32.3375	32.44	32.3325	32.435	299688.0
2015-05-04 08:00:00	AAPL	Stock	32.425	32.485	32.3325	32.4552	1077600.0
2015-05-04 09:00:00	AAPL	Stock	32.455	32.6425	32.375	32.5725	35304196.0
2015-05-04 10:00:00	AAPL	Stock	32.575	32.5875	32.345	32.43	35059648.0
2015-05-04 11:00:00	AAPL	Stock	32.4325	32.4925	32.345	32.427	16598852.0
2015-05-04 12:00:00	AAPL	Stock	32.4255	32.427	32.1068	32.18	23018692.0
2015-05-04 13:00:00	AAPL	Stock	32.18	32.3275	32.065	32.32	20371988.0
2015-05-04 14:00:00	AAPL	Stock	32.32	32.3475	32.1675	32.2575	16305184.0
2015-05-04 15:00:00	AAPL	Stock	32.2575	32.275	32.1525	32.175	23023740.0
2015-05-04 16:00:00	AAPL	Stock	32.175	32.5355	32.15	32.1825	12562500.0
2015-05-04 17:00:00	AAPL	Stock	32.185	32.1922	32.18	32.1875	48796.0
2015-05-04 18:00:00	AAPL	Stock	32.1825	32.1875	32.1625	32.18	116872.0
2015-05-04 19:00:00	AAPL	Stock	32.18	32.1875	32.175	32.185	81604.0
2015-05-04 04:00:00	MSFT	Stock	48.65	48.65	48.51	48.51	1905.0
2015-05-04 05:00:00	MSFT	Stock	48.5	48.59	48.5	48.51	3760.0
2015-05-04 06:00:00	MSFT	Stock	48.55	48.55	48.47	48.47	2808.0
2015-05-04 07:00:00	MSFT	Stock	48.55	48.56	48.49	48.54	15423.0
2015-05-04 08:00:00	MSFT	Stock	48.55	48.58	48.47	48.5	34855.0
2015-05-04 09:00:00	MSFT	Stock	48.48	48.87	48.35	48.8	3462016.0
2015-05-04 10:00:00	MSFT	Stock	48.8	48.84	48.5	48.535	3829799.0
2015-05-04 11:00:00	MSFT	Stock	48.533	48.67	48.48	48.535	3698991.0
2015-05-04 12:00:00	MSFT	Stock	48.53	48.575	48.44	48.445	2256192.0
2015-05-04 13:00:00	MSFT	Stock	48.445	48.51	48.33	48.5	3308874.0
2015-05-04 14:00:00	MSFT	Stock	48.5	48.535	48.335	48.34	4461214.0
2015-05-04 15:00:00	MSFT	Stock	48.345	48.385	48.18	48.24	9353305.0
2015-05-04 16:00:00	MSFT	Stock	48.24	48.486	48.21	48.24	2066838.0
2015-05-04 17:00:00	MSFT	Stock	48.21	48.25	48.21	48.22	2896.0
2015-05-04 18:00:00	MSFT	Stock	48.24	48.24	48.24	48.24	300.0
2015-05-04 19:00:00	MSFT	Stock	48.24	48.25	48.22	48.24	9100.0
2015-05-04 07:00:00	NVDA	Stock	0.5635	0.5662	0.5625	0.5662	48000.0
2015-05-04 08:00:00	NVDA	Stock	0.5665	0.5688	0.566	0.5688	44000.0
2015-05-04 09:00:00	NVDA	Stock	0.5682	0.572	0.5652	0.5672	11991760.0
2015-05-04 10:00:00	NVDA	Stock	0.5672	0.5688	0.5638	0.564	20342720.0
2015-05-04 11:00:00	NVDA	Stock	0.5642	0.568	0.5635	0.567	19362840.0
2015-05-04 12:00:00	NVDA	Stock	0.5668	0.567	0.5646	0.5652	12700520.0
2015-05-04 13:00:00	NVDA	Stock	0.5652	0.566	0.564	0.5652	12631640.0
2015-05-04 14:00:00	NVDA	Stock	0.565	0.5688	0.5648	0.5672	21927640.0
2015-05-04 15:00:00	NVDA	Stock	0.5671	0.5678	0.5652	0.5654	37985560.0
2015-05-04 16:00:00	NVDA	Stock	0.5652	0.5667	0.5652	0.5667	2771440.0
2015-05-04 04:00:00	AMZN	Stock	21.175	21.175	21.175	21.175	2600.0
2015-05-04 06:00:00	AMZN	Stock	21.175	21.175	21.175	21.175	7400.0
2015-05-04 07:00:00	AMZN	Stock	21.1875	21.387	21.1875	21.325	193980.0
2015-05-04 08:00:00	AMZN	Stock	21.25	21.387	21.25	21.305	223520.0
2015-05-04 09:00:00	AMZN	Stock	21.305	21.486	21.233	21.4618	8862780.0
2015-05-04 10:00:00	AMZN	Stock	21.4615	21.4885	21.274	21.304	7568020.0
2015-05-04 11:00:00	AMZN	Stock	21.303	21.334	21.233	21.2675	4618720.0
2015-05-04 12:00:00	AMZN	Stock	21.2675	21.325	21.1825	21.187	3977280.0

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

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