PREVIEW / stock_1hour / 2014-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-06.parquet
  size:    1.0 MB
  rows:    48,315
  symbols: 3,532

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-01-06 04:00:00	AAPL	Stock	19.3504	19.3504	19.3161	19.3171	54068.0
2014-01-06 05:00:00	AAPL	Stock	19.3182	19.3214	19.2679	19.2679	77868.0
2014-01-06 06:00:00	AAPL	Stock	19.2511	19.2611	19.0536	19.1061	671076.0
2014-01-06 07:00:00	AAPL	Stock	19.1061	19.2321	19.1061	19.2186	1238188.0
2014-01-06 08:00:00	AAPL	Stock	19.2143	19.3368	19.1571	19.2071	2072364.0
2014-01-06 09:00:00	AAPL	Stock	19.2071	19.2321	19.0571	19.2052	76552112.0
2014-01-06 10:00:00	AAPL	Stock	19.2061	19.365	19.1132	19.3157	67945136.0
2014-01-06 11:00:00	AAPL	Stock	19.3154	19.3596	19.2425	19.3571	38072720.0
2014-01-06 12:00:00	AAPL	Stock	19.3596	19.4643	19.3554	19.4511	32920300.0
2014-01-06 13:00:00	AAPL	Stock	19.4518	19.4907	19.4221	19.4436	33467448.0
2014-01-06 14:00:00	AAPL	Stock	19.4436	19.5136	19.4286	19.4857	34051836.0
2014-01-06 15:00:00	AAPL	Stock	19.4855	19.5286	19.4111	19.4267	46300576.0
2014-01-06 16:00:00	AAPL	Stock	19.4264	19.4404	19.1643	19.4286	22455020.0
2014-01-06 17:00:00	AAPL	Stock	19.4286	19.4357	19.4204	19.4221	276444.0
2014-01-06 18:00:00	AAPL	Stock	19.4357	19.4364	19.4111	19.4279	166180.0
2014-01-06 19:00:00	AAPL	Stock	19.4146	19.4554	19.4132	19.45	356048.0
2014-01-06 05:00:00	MSFT	Stock	37.0	37.0	37.0	37.0	100.0
2014-01-06 06:00:00	MSFT	Stock	37.14	37.14	37.04	37.04	500.0
2014-01-06 07:00:00	MSFT	Stock	37.03	37.09	36.99	37.0	1800.0
2014-01-06 08:00:00	MSFT	Stock	36.95	37.02	36.7	36.73	20245.0
2014-01-06 09:00:00	MSFT	Stock	36.75	36.9	36.45	36.46	4523706.0
2014-01-06 10:00:00	MSFT	Stock	36.45	36.505	36.2	36.235	7316952.0
2014-01-06 11:00:00	MSFT	Stock	36.24	36.36	36.17	36.334	3759377.0
2014-01-06 12:00:00	MSFT	Stock	36.34	36.35	36.21	36.256	2366319.0
2014-01-06 13:00:00	MSFT	Stock	36.26	36.26	36.172	36.255	4230278.0
2014-01-06 14:00:00	MSFT	Stock	36.26	36.29	36.2	36.234	3113397.0
2014-01-06 15:00:00	MSFT	Stock	36.235	36.24	36.11	36.13	8073844.0
2014-01-06 16:00:00	MSFT	Stock	36.16	36.38	36.12	36.18	9100313.0
2014-01-06 17:00:00	MSFT	Stock	36.18	36.18	36.14	36.14	2577.0
2014-01-06 18:00:00	MSFT	Stock	36.16	36.213	36.16	36.2	7643.0
2014-01-06 19:00:00	MSFT	Stock	36.18	36.2	36.18	36.2	3006.0
2014-01-06 08:00:00	NVDA	Stock	0.3933	0.3938	0.3933	0.3938	32000.0
2014-01-06 09:00:00	NVDA	Stock	0.3938	0.3965	0.392	0.3965	42214960.0
2014-01-06 10:00:00	NVDA	Stock	0.3965	0.3968	0.394	0.3948	89485560.0
2014-01-06 11:00:00	NVDA	Stock	0.3947	0.397	0.394	0.397	35952520.0
2014-01-06 12:00:00	NVDA	Stock	0.397	0.4	0.3965	0.3995	40402720.0
2014-01-06 13:00:00	NVDA	Stock	0.3996	0.3998	0.397	0.3985	31612560.0
2014-01-06 14:00:00	NVDA	Stock	0.3984	0.3988	0.3975	0.3988	25688720.0
2014-01-06 15:00:00	NVDA	Stock	0.3988	0.3988	0.3965	0.3968	75837840.0
2014-01-06 16:00:00	NVDA	Stock	0.397	0.3972	0.3918	0.397	42356160.0
2014-01-06 17:00:00	NVDA	Stock	0.397	0.3985	0.397	0.3985	74000.0
2014-01-06 05:00:00	AMZN	Stock	19.8695	19.8695	19.8695	19.8695	2000.0
2014-01-06 06:00:00	AMZN	Stock	19.8685	19.8685	19.8685	19.8685	4000.0
2014-01-06 08:00:00	AMZN	Stock	19.8431	19.8431	19.75	19.77	59340.0
2014-01-06 09:00:00	AMZN	Stock	19.775	19.85	19.521	19.5515	9527800.0
2014-01-06 10:00:00	AMZN	Stock	19.5525	19.6	19.444	19.5095	12445380.0
2014-01-06 11:00:00	AMZN	Stock	19.515	19.5975	19.5	19.5895	6716880.0
2014-01-06 12:00:00	AMZN	Stock	19.592	19.5995	19.485	19.493	4604640.0
2014-01-06 13:00:00	AMZN	Stock	19.4865	19.53	19.421	19.5255	4741060.0
2014-01-06 14:00:00	AMZN	Stock	19.5225	19.719	19.5225	19.7185	4548600.0

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

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