PREVIEW / stock_1hour / 2016-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-26.parquet
  size:    1.0 MB
  rows:    48,522
  symbols: 3,322

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-04-26 04:00:00	AAPL	Stock	26.325	26.325	26.2375	26.2375	31640.0
2016-04-26 05:00:00	AAPL	Stock	26.2325	26.2325	26.22	26.23	2420.0
2016-04-26 06:00:00	AAPL	Stock	26.25	26.25	26.1275	26.1275	17660.0
2016-04-26 07:00:00	AAPL	Stock	26.15	26.2025	26.0	26.0725	212216.0
2016-04-26 08:00:00	AAPL	Stock	26.0825	26.325	26.025	26.1025	911728.0
2016-04-26 09:00:00	AAPL	Stock	26.1025	26.325	25.965	26.25	23860944.0
2016-04-26 10:00:00	AAPL	Stock	26.25	26.2825	26.0675	26.1132	21533508.0
2016-04-26 11:00:00	AAPL	Stock	26.1135	26.1838	26.0625	26.1588	14132908.0
2016-04-26 12:00:00	AAPL	Stock	26.159	26.225	26.075	26.0807	11340932.0
2016-04-26 13:00:00	AAPL	Stock	26.08	26.135	26.0138	26.115	14739388.0
2016-04-26 14:00:00	AAPL	Stock	26.115	26.1675	26.035	26.101	18138016.0
2016-04-26 15:00:00	AAPL	Stock	26.1025	26.1425	26.0125	26.075	36603316.0
2016-04-26 16:00:00	AAPL	Stock	26.0875	26.2168	24.105	24.1425	40886884.0
2016-04-26 17:00:00	AAPL	Stock	24.15	24.25	23.94	23.9625	20278064.0
2016-04-26 18:00:00	AAPL	Stock	23.9575	26.1335	23.8775	23.97	4136372.0
2016-04-26 19:00:00	AAPL	Stock	23.97	24.03	23.9375	24.0275	1162752.0
2016-04-26 05:00:00	MSFT	Stock	52.3	52.3	52.3	52.3	2000.0
2016-04-26 07:00:00	MSFT	Stock	52.27	52.27	52.27	52.27	100.0
2016-04-26 08:00:00	MSFT	Stock	52.27	52.27	52.13	52.13	20673.0
2016-04-26 09:00:00	MSFT	Stock	52.18	52.35	51.78	51.81	3434579.0
2016-04-26 10:00:00	MSFT	Stock	51.81	51.94	51.36	51.48	4639774.0
2016-04-26 11:00:00	MSFT	Stock	51.49	51.61	51.32	51.445	3445852.0
2016-04-26 12:00:00	MSFT	Stock	51.445	51.55	51.31	51.315	2688514.0
2016-04-26 13:00:00	MSFT	Stock	51.32	51.41	51.22	51.22	3174923.0
2016-04-26 14:00:00	MSFT	Stock	51.226	51.27	51.09	51.185	4093225.0
2016-04-26 15:00:00	MSFT	Stock	51.18	51.44	51.16	51.44	7766012.0
2016-04-26 16:00:00	MSFT	Stock	51.44	51.44	51.21	51.3	2196073.0
2016-04-26 17:00:00	MSFT	Stock	51.21	51.44	51.16	51.17	161571.0
2016-04-26 18:00:00	MSFT	Stock	51.21	51.3	51.2	51.24	11112.0
2016-04-26 19:00:00	MSFT	Stock	51.21	51.3	51.21	51.28	5870.0
2016-04-26 09:00:00	NVDA	Stock	0.9168	0.9273	0.9113	0.9243	21188880.0
2016-04-26 10:00:00	NVDA	Stock	0.9245	0.9254	0.914	0.9152	32973120.0
2016-04-26 11:00:00	NVDA	Stock	0.9155	0.92	0.9152	0.9175	49063240.0
2016-04-26 12:00:00	NVDA	Stock	0.9175	0.9195	0.9133	0.9135	14752280.0
2016-04-26 13:00:00	NVDA	Stock	0.9135	0.9146	0.9102	0.9128	25665480.0
2016-04-26 14:00:00	NVDA	Stock	0.9129	0.913	0.9082	0.9092	24131920.0
2016-04-26 15:00:00	NVDA	Stock	0.909	0.9125	0.908	0.912	35611520.0
2016-04-26 16:00:00	NVDA	Stock	0.912	0.9135	0.9098	0.9098	256920.0
2016-04-26 17:00:00	NVDA	Stock	0.9098	0.912	0.9098	0.9105	68920.0
2016-04-26 18:00:00	NVDA	Stock	0.9113	0.912	0.9108	0.9108	56280.0
2016-04-26 19:00:00	NVDA	Stock	0.912	0.912	0.912	0.912	8200.0
2016-04-26 04:00:00	AMZN	Stock	31.3835	31.3835	31.3835	31.3835	6000.0
2016-04-26 07:00:00	AMZN	Stock	31.4	31.425	31.4	31.425	6600.0
2016-04-26 08:00:00	AMZN	Stock	31.378	31.405	31.35	31.35	101480.0
2016-04-26 09:00:00	AMZN	Stock	31.4415	31.4415	31.021	31.1905	7486500.0
2016-04-26 10:00:00	AMZN	Stock	31.1975	31.25	30.833	30.8635	8297240.0
2016-04-26 11:00:00	AMZN	Stock	30.8715	30.961	30.84	30.941	4833840.0
2016-04-26 12:00:00	AMZN	Stock	30.943	30.9975	30.9185	30.9325	3434500.0
2016-04-26 13:00:00	AMZN	Stock	30.936	30.9735	30.866	30.9116	3402660.0
2016-04-26 14:00:00	AMZN	Stock	30.9165	30.932	30.744	30.7851	5589460.0

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

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