PREVIEW / stock_1hour / 2016-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-17.parquet
  size:    1.0 MB
  rows:    48,753
  symbols: 3,324

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
2016-05-17 04:00:00	AAPL	Stock	23.5	23.75	23.5	23.7	95868.0
2016-05-17 05:00:00	AAPL	Stock	23.6975	23.7125	23.655	23.6625	186232.0
2016-05-17 06:00:00	AAPL	Stock	23.6875	23.7475	23.625	23.625	171196.0
2016-05-17 07:00:00	AAPL	Stock	23.66	23.66	23.5525	23.6125	214696.0
2016-05-17 08:00:00	AAPL	Stock	23.6	23.66	23.525	23.54	566676.0
2016-05-17 09:00:00	AAPL	Stock	23.54	23.75	23.36	23.4525	38086780.0
2016-05-17 10:00:00	AAPL	Stock	23.455	23.495	23.335	23.4513	27507324.0
2016-05-17 11:00:00	AAPL	Stock	23.45	23.55	23.405	23.5062	19933232.0
2016-05-17 12:00:00	AAPL	Stock	23.5075	23.56	23.4112	23.435	15120672.0
2016-05-17 13:00:00	AAPL	Stock	23.4375	23.495	23.3825	23.385	12554544.0
2016-05-17 14:00:00	AAPL	Stock	23.385	23.4195	23.285	23.3275	20444204.0
2016-05-17 15:00:00	AAPL	Stock	23.3275	23.375	23.2525	23.37	25317088.0
2016-05-17 16:00:00	AAPL	Stock	23.3725	23.3825	23.3575	23.3725	12442580.0
2016-05-17 17:00:00	AAPL	Stock	23.3825	23.3875	23.375	23.38	41916.0
2016-05-17 18:00:00	AAPL	Stock	23.375	23.385	23.37	23.38	35384.0
2016-05-17 19:00:00	AAPL	Stock	23.38	23.3875	23.3775	23.3775	35876.0
2016-05-17 05:00:00	MSFT	Stock	51.63	51.63	51.63	51.63	1049.0
2016-05-17 07:00:00	MSFT	Stock	51.55	51.55	51.41	51.51	4960.0
2016-05-17 08:00:00	MSFT	Stock	51.56	51.56	50.728	51.45	17152.0
2016-05-17 09:00:00	MSFT	Stock	51.42	51.79	51.055	51.12	2830766.0
2016-05-17 10:00:00	MSFT	Stock	51.13	51.13	50.75	50.922	3339785.0
2016-05-17 11:00:00	MSFT	Stock	50.92	51.01	50.81	50.891	2056103.0
2016-05-17 12:00:00	MSFT	Stock	50.89	50.92	50.67	50.76	1742180.0
2016-05-17 13:00:00	MSFT	Stock	50.76	50.9	50.63	50.64	1965549.0
2016-05-17 14:00:00	MSFT	Stock	50.645	50.675	50.44	50.565	3727713.0
2016-05-17 15:00:00	MSFT	Stock	50.57	50.64	50.36	50.51	6372159.0
2016-05-17 16:00:00	MSFT	Stock	50.51	50.607	50.5	50.52	3805765.0
2016-05-17 17:00:00	MSFT	Stock	50.52	50.52	50.5	50.5	3218.0
2016-05-17 18:00:00	MSFT	Stock	50.5	50.52	50.5	50.51	6225.0
2016-05-17 19:00:00	MSFT	Stock	50.52	50.52	50.51	50.51	3473.0
2016-05-17 04:00:00	NVDA	Stock	1.0545	1.055	1.051	1.051	52000.0
2016-05-17 05:00:00	NVDA	Stock	1.053	1.053	1.0528	1.053	80000.0
2016-05-17 06:00:00	NVDA	Stock	1.053	1.0538	1.0505	1.0505	72000.0
2016-05-17 07:00:00	NVDA	Stock	1.0518	1.0525	1.0495	1.05	249760.0
2016-05-17 08:00:00	NVDA	Stock	1.05	1.0523	1.0483	1.05	1348720.0
2016-05-17 09:00:00	NVDA	Stock	1.05	1.0545	1.0365	1.042	85729520.0
2016-05-17 10:00:00	NVDA	Stock	1.042	1.0608	1.0398	1.0572	92479440.0
2016-05-17 11:00:00	NVDA	Stock	1.0572	1.0645	1.0535	1.0538	101957080.0
2016-05-17 12:00:00	NVDA	Stock	1.0538	1.0582	1.051	1.0578	45250120.0
2016-05-17 13:00:00	NVDA	Stock	1.0575	1.0615	1.0558	1.0561	72846960.0
2016-05-17 14:00:00	NVDA	Stock	1.056	1.057	1.0516	1.054	62123120.0
2016-05-17 15:00:00	NVDA	Stock	1.0543	1.0572	1.0532	1.057	80853280.0
2016-05-17 16:00:00	NVDA	Stock	1.057	1.0582	1.0552	1.057	31926560.0
2016-05-17 17:00:00	NVDA	Stock	1.057	1.057	1.0543	1.0543	32000.0
2016-05-17 18:00:00	NVDA	Stock	1.0575	1.059	1.0568	1.0568	111600.0
2016-05-17 19:00:00	NVDA	Stock	1.057	1.057	1.0568	1.0568	84200.0
2016-05-17 07:00:00	AMZN	Stock	35.605	35.605	35.525	35.5305	19860.0
2016-05-17 08:00:00	AMZN	Stock	35.5795	35.585	35.45	35.45	66300.0
2016-05-17 09:00:00	AMZN	Stock	35.4625	35.7235	35.2282	35.3075	12162600.0
2016-05-17 10:00:00	AMZN	Stock	35.3	35.3195	35.0625	35.2745	15514160.0

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

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