PREVIEW / stock_1hour / 2014-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-07.parquet
  size:    1.0 MB
  rows:    48,407
  symbols: 3,552

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-05-07 04:00:00	AAPL	Stock	21.2368	21.2368	21.2368	21.2368	2800.0
2014-05-07 06:00:00	AAPL	Stock	21.275	21.275	21.2589	21.2589	11200.0
2014-05-07 07:00:00	AAPL	Stock	21.2654	21.3161	21.2654	21.2996	206864.0
2014-05-07 08:00:00	AAPL	Stock	21.2946	21.3479	21.1786	21.3393	1126524.0
2014-05-07 09:00:00	AAPL	Stock	21.3418	21.3429	21.115	21.1586	36993376.0
2014-05-07 10:00:00	AAPL	Stock	21.1586	21.2357	20.9904	21.0982	55560680.0
2014-05-07 11:00:00	AAPL	Stock	21.0996	21.1964	21.0375	21.1682	25052440.0
2014-05-07 12:00:00	AAPL	Stock	21.1711	21.1903	21.0407	21.0429	16403968.0
2014-05-07 13:00:00	AAPL	Stock	21.0414	21.1168	21.0071	21.0421	16306304.0
2014-05-07 14:00:00	AAPL	Stock	21.0421	21.1543	21.0339	21.1071	16501604.0
2014-05-07 15:00:00	AAPL	Stock	21.1089	21.1786	21.0761	21.155	30415840.0
2014-05-07 16:00:00	AAPL	Stock	21.1546	21.1982	21.0882	21.1339	9687496.0
2014-05-07 17:00:00	AAPL	Stock	21.1321	21.1418	21.125	21.1389	213444.0
2014-05-07 18:00:00	AAPL	Stock	21.1389	21.1546	21.1289	21.1425	329896.0
2014-05-07 19:00:00	AAPL	Stock	21.1404	21.15	21.1286	21.1286	210168.0
2014-05-07 07:00:00	MSFT	Stock	39.1	39.1	39.1	39.1	7200.0
2014-05-07 08:00:00	MSFT	Stock	39.1	39.25	39.1	39.18	6008.0
2014-05-07 09:00:00	MSFT	Stock	39.16	39.24	38.92	38.936	2964652.0
2014-05-07 10:00:00	MSFT	Stock	38.94	39.02	38.58	38.74	9412747.0
2014-05-07 11:00:00	MSFT	Stock	38.75	38.93	38.51	38.812	4405113.0
2014-05-07 12:00:00	MSFT	Stock	38.818	38.86	38.66	38.69	1864673.0
2014-05-07 13:00:00	MSFT	Stock	38.685	38.83	38.66	38.77	3301800.0
2014-05-07 14:00:00	MSFT	Stock	38.77	39.21	38.76	39.2	6368987.0
2014-05-07 15:00:00	MSFT	Stock	39.19	39.51	39.15	39.4	9680744.0
2014-05-07 16:00:00	MSFT	Stock	39.4	39.449	38.991	39.38	2593849.0
2014-05-07 17:00:00	MSFT	Stock	39.36	39.4	39.35	39.4	11501.0
2014-05-07 18:00:00	MSFT	Stock	39.35	39.35	39.32	39.33	3138.0
2014-05-07 19:00:00	MSFT	Stock	39.33	39.35	39.33	39.35	4393.0
2014-05-07 09:00:00	NVDA	Stock	0.4562	0.4582	0.4525	0.4535	25442480.0
2014-05-07 10:00:00	NVDA	Stock	0.4534	0.4564	0.4518	0.4552	75692960.0
2014-05-07 11:00:00	NVDA	Stock	0.4552	0.4605	0.454	0.4593	42950800.0
2014-05-07 12:00:00	NVDA	Stock	0.4593	0.4603	0.4572	0.4572	20283080.0
2014-05-07 13:00:00	NVDA	Stock	0.4572	0.4585	0.455	0.4551	17592000.0
2014-05-07 14:00:00	NVDA	Stock	0.455	0.4562	0.4549	0.4552	23276600.0
2014-05-07 15:00:00	NVDA	Stock	0.4552	0.4575	0.4542	0.4568	56482720.0
2014-05-07 16:00:00	NVDA	Stock	0.4568	0.457	0.4557	0.457	9705800.0
2014-05-07 18:00:00	NVDA	Stock	0.4562	0.46	0.4562	0.4588	184000.0
2014-05-07 05:00:00	AMZN	Stock	14.944	14.944	14.93	14.93	10000.0
2014-05-07 06:00:00	AMZN	Stock	14.934	14.934	14.9	14.9	14220.0
2014-05-07 07:00:00	AMZN	Stock	14.8995	14.9385	14.8995	14.915	26000.0
2014-05-07 08:00:00	AMZN	Stock	14.93	14.95	14.8865	14.887	310840.0
2014-05-07 09:00:00	AMZN	Stock	14.885	14.89	14.4262	14.4788	27366120.0
2014-05-07 10:00:00	AMZN	Stock	14.4815	14.6185	14.334	14.5195	25970400.0
2014-05-07 11:00:00	AMZN	Stock	14.5255	14.62	14.427	14.5785	12996880.0
2014-05-07 12:00:00	AMZN	Stock	14.5785	14.5805	14.441	14.46	12024780.0
2014-05-07 13:00:00	AMZN	Stock	14.4585	14.5495	14.4165	14.4205	16044820.0
2014-05-07 14:00:00	AMZN	Stock	14.4175	14.585	14.4	14.5585	10448820.0
2014-05-07 15:00:00	AMZN	Stock	14.5505	14.66	14.508	14.6355	18113260.0
2014-05-07 16:00:00	AMZN	Stock	14.6355	14.65	14.446	14.6155	3495080.0
2014-05-07 17:00:00	AMZN	Stock	14.5575	14.5935	14.5275	14.5275	25000.0

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

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