PREVIEW / stock_1hour / 2013-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-25.parquet
  size:    970 KB
  rows:    45,129
  symbols: 3,481

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
2013-03-25 04:00:00	AAPL	Stock	16.6071	16.6429	16.5857	16.5857	27916.0
2013-03-25 05:00:00	AAPL	Stock	16.6071	16.675	16.6071	16.675	51716.0
2013-03-25 06:00:00	AAPL	Stock	16.675	16.6786	16.5468	16.6171	301000.0
2013-03-25 07:00:00	AAPL	Stock	16.5946	16.6518	16.5579	16.6389	1523200.0
2013-03-25 08:00:00	AAPL	Stock	16.6386	16.6429	16.4286	16.5571	4195128.0
2013-03-25 09:00:00	AAPL	Stock	16.5621	16.7429	16.5321	16.7184	93271752.0
2013-03-25 10:00:00	AAPL	Stock	16.7189	16.7839	16.615	16.6536	97831048.0
2013-03-25 11:00:00	AAPL	Stock	16.6582	16.6589	16.5168	16.6036	77345548.0
2013-03-25 12:00:00	AAPL	Stock	16.5987	16.6229	16.5179	16.5261	42324268.0
2013-03-25 13:00:00	AAPL	Stock	16.5243	16.6711	16.495	16.65	49595532.0
2013-03-25 14:00:00	AAPL	Stock	16.6511	16.6814	16.5786	16.6088	40598880.0
2013-03-25 15:00:00	AAPL	Stock	16.6104	16.6136	16.4921	16.5546	75236504.0
2013-03-25 16:00:00	AAPL	Stock	16.5564	16.6982	16.5246	16.5704	9990652.0
2013-03-25 17:00:00	AAPL	Stock	16.5704	16.5711	16.5439	16.5439	738724.0
2013-03-25 18:00:00	AAPL	Stock	16.5471	16.5536	16.5207	16.5339	318696.0
2013-03-25 19:00:00	AAPL	Stock	16.5282	16.5429	16.5232	16.5232	522396.0
2013-03-25 08:00:00	MSFT	Stock	28.2	28.35	28.2	28.32	6871.0
2013-03-25 09:00:00	MSFT	Stock	28.31	28.35	28.2	28.265	2550520.0
2013-03-25 10:00:00	MSFT	Stock	28.26	28.28	28.08	28.09	4613282.0
2013-03-25 11:00:00	MSFT	Stock	28.1	28.13	27.96	28.105	7157467.0
2013-03-25 12:00:00	MSFT	Stock	28.1	28.13	28.05	28.08	4827340.0
2013-03-25 13:00:00	MSFT	Stock	28.08	28.3	28.04	28.235	8170338.0
2013-03-25 14:00:00	MSFT	Stock	28.236	28.25	28.132	28.162	2804174.0
2013-03-25 15:00:00	MSFT	Stock	28.17	28.19	28.08	28.16	6811446.0
2013-03-25 16:00:00	MSFT	Stock	28.17	28.22	28.1	28.22	6869899.0
2013-03-25 17:00:00	MSFT	Stock	28.22	28.24	28.16	28.16	7300.0
2013-03-25 08:00:00	NVDA	Stock	0.3115	0.3115	0.3115	0.3115	19600.0
2013-03-25 09:00:00	NVDA	Stock	0.3135	0.314	0.3118	0.312	37025720.0
2013-03-25 10:00:00	NVDA	Stock	0.3118	0.3124	0.309	0.3106	77021280.0
2013-03-25 11:00:00	NVDA	Stock	0.3106	0.3115	0.309	0.3098	43987320.0
2013-03-25 12:00:00	NVDA	Stock	0.3096	0.31	0.3088	0.309	34640000.0
2013-03-25 13:00:00	NVDA	Stock	0.3088	0.3103	0.308	0.3093	52428080.0
2013-03-25 14:00:00	NVDA	Stock	0.309	0.31	0.3088	0.3088	26477640.0
2013-03-25 15:00:00	NVDA	Stock	0.3089	0.3105	0.308	0.3103	78617280.0
2013-03-25 16:00:00	NVDA	Stock	0.3103	0.3125	0.3088	0.3103	4510080.0
2013-03-25 17:00:00	NVDA	Stock	0.311	0.311	0.311	0.311	32000.0
2013-03-25 19:00:00	NVDA	Stock	0.3103	0.3103	0.3103	0.3103	4000.0
2013-03-25 07:00:00	AMZN	Stock	12.975	12.975	12.9305	12.9305	8000.0
2013-03-25 08:00:00	AMZN	Stock	12.931	12.9995	12.93	12.9325	140480.0
2013-03-25 09:00:00	AMZN	Stock	12.9175	12.95	12.825	12.893	7832640.0
2013-03-25 10:00:00	AMZN	Stock	12.8915	12.9714	12.8161	12.82	10793900.0
2013-03-25 11:00:00	AMZN	Stock	12.82	12.8625	12.769	12.7825	6347220.0
2013-03-25 12:00:00	AMZN	Stock	12.7795	12.801	12.725	12.742	4539440.0
2013-03-25 13:00:00	AMZN	Stock	12.7465	12.85	12.725	12.825	5134940.0
2013-03-25 14:00:00	AMZN	Stock	12.8201	12.843	12.7775	12.782	4189760.0
2013-03-25 15:00:00	AMZN	Stock	12.7845	12.833	12.747	12.8005	7408340.0
2013-03-25 16:00:00	AMZN	Stock	12.8035	12.9112	12.7898	12.8175	1054980.0
2013-03-25 17:00:00	AMZN	Stock	12.825	12.825	12.801	12.801	61980.0
2013-03-25 18:00:00	AMZN	Stock	12.826	12.826	12.8175	12.8255	12000.0
2013-03-25 19:00:00	AMZN	Stock	12.825	12.8275	12.822	12.8275	14000.0

> showing 50 of 45,129 rows — these rows as CSV

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