PREVIEW / stock_1hour / 2014-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-14.parquet
  size:    1.1 MB
  rows:    50,413
  symbols: 3,564

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-10-14 04:00:00	AAPL	Stock	25.055	25.0575	24.995	24.995	12788.0
2014-10-14 05:00:00	AAPL	Stock	24.965	24.975	24.9225	24.975	34796.0
2014-10-14 06:00:00	AAPL	Stock	24.955	25.0725	24.955	24.9975	13816.0
2014-10-14 07:00:00	AAPL	Stock	25.035	25.1	25.025	25.055	230024.0
2014-10-14 08:00:00	AAPL	Stock	25.0425	25.1625	25.0	25.12	1268120.0
2014-10-14 09:00:00	AAPL	Stock	25.115	25.13	24.795	24.85	36818624.0
2014-10-14 10:00:00	AAPL	Stock	24.8525	25.0625	24.7225	24.9975	46636516.0
2014-10-14 11:00:00	AAPL	Stock	24.9962	25.1028	24.9625	25.054	22180736.0
2014-10-14 12:00:00	AAPL	Stock	25.0525	25.115	24.95	24.965	18200980.0
2014-10-14 13:00:00	AAPL	Stock	24.9662	24.975	24.7375	24.7825	25303624.0
2014-10-14 14:00:00	AAPL	Stock	24.78	24.89	24.7025	24.8025	26440812.0
2014-10-14 15:00:00	AAPL	Stock	24.8025	24.9075	24.6425	24.6975	48467040.0
2014-10-14 16:00:00	AAPL	Stock	24.6875	27.4225	20.4163	24.775	12798468.0
2014-10-14 17:00:00	AAPL	Stock	24.7825	24.79	24.6875	24.77	1614756.0
2014-10-14 18:00:00	AAPL	Stock	24.775	24.85	24.77	24.81	242624.0
2014-10-14 19:00:00	AAPL	Stock	24.81	24.8225	24.8025	24.82	85176.0
2014-10-14 05:00:00	MSFT	Stock	43.5	43.65	43.5	43.65	700.0
2014-10-14 06:00:00	MSFT	Stock	43.51	43.55	43.5	43.55	5800.0
2014-10-14 07:00:00	MSFT	Stock	43.7	43.7	43.6	43.7	5450.0
2014-10-14 08:00:00	MSFT	Stock	43.65	44.01	43.65	43.92	9572.0
2014-10-14 09:00:00	MSFT	Stock	43.91	44.38	43.56	44.37	4663428.0
2014-10-14 10:00:00	MSFT	Stock	44.37	44.38	43.81	43.93	6685285.0
2014-10-14 11:00:00	MSFT	Stock	43.94	44.0	43.68	43.935	4808436.0
2014-10-14 12:00:00	MSFT	Stock	43.93	44.08	43.85	44.07	3305197.0
2014-10-14 13:00:00	MSFT	Stock	44.065	44.18	43.92	44.09	2420487.0
2014-10-14 14:00:00	MSFT	Stock	44.09	44.15	43.73	43.79	3840503.0
2014-10-14 15:00:00	MSFT	Stock	43.79	44.03	43.66	43.74	7819091.0
2014-10-14 16:00:00	MSFT	Stock	43.73	44.2	43.723	44.0	2947611.0
2014-10-14 17:00:00	MSFT	Stock	43.73	44.05	43.73	44.04	33931.0
2014-10-14 18:00:00	MSFT	Stock	44.05	44.16	44.02	44.03	5225.0
2014-10-14 19:00:00	MSFT	Stock	44.04	44.17	44.04	44.17	850.0
2014-10-14 09:00:00	NVDA	Stock	0.426	0.4314	0.4232	0.4246	27070720.0
2014-10-14 10:00:00	NVDA	Stock	0.4245	0.4315	0.423	0.4305	59731840.0
2014-10-14 11:00:00	NVDA	Stock	0.4308	0.4405	0.4296	0.4401	75120160.0
2014-10-14 12:00:00	NVDA	Stock	0.4402	0.4412	0.4332	0.4345	41102760.0
2014-10-14 13:00:00	NVDA	Stock	0.4345	0.4366	0.4315	0.4335	28154600.0
2014-10-14 14:00:00	NVDA	Stock	0.4338	0.4345	0.4295	0.4302	26843520.0
2014-10-14 15:00:00	NVDA	Stock	0.4305	0.4318	0.4265	0.4295	85059240.0
2014-10-14 16:00:00	NVDA	Stock	0.4294	0.432	0.4294	0.4294	14963360.0
2014-10-14 17:00:00	NVDA	Stock	0.4294	0.4294	0.4294	0.4294	621200.0
2014-10-14 04:00:00	AMZN	Stock	15.364	15.364	15.35	15.35	17560.0
2014-10-14 05:00:00	AMZN	Stock	15.364	15.364	15.364	15.364	2000.0
2014-10-14 06:00:00	AMZN	Stock	15.364	15.364	15.364	15.364	2000.0
2014-10-14 07:00:00	AMZN	Stock	15.3405	15.3405	15.339	15.34	8000.0
2014-10-14 08:00:00	AMZN	Stock	15.363	15.425	15.3545	15.404	217020.0
2014-10-14 09:00:00	AMZN	Stock	15.4005	15.448	15.312	15.3345	10693440.0
2014-10-14 10:00:00	AMZN	Stock	15.336	15.5655	15.2875	15.5115	12113180.0
2014-10-14 11:00:00	AMZN	Stock	15.5125	15.612	15.454	15.577	6512460.0
2014-10-14 12:00:00	AMZN	Stock	15.588	15.607	15.4465	15.517	5115640.0
2014-10-14 13:00:00	AMZN	Stock	15.522	15.567	15.4405	15.4845	4976320.0

> showing 50 of 50,413 rows — these rows as CSV

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