PREVIEW / stock_1hour / 2011-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-23.parquet
  size:    905 KB
  rows:    43,549
  symbols: 3,569

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
2011-12-23 04:00:00	AAPL	Stock	14.2657	14.2657	14.2411	14.2411	11480.0
2011-12-23 05:00:00	AAPL	Stock	14.25	14.25	14.2457	14.2457	11200.0
2011-12-23 07:00:00	AAPL	Stock	14.2614	14.2889	14.2607	14.2854	455560.0
2011-12-23 08:00:00	AAPL	Stock	14.2736	14.3036	14.2639	14.2725	2605820.0
2011-12-23 09:00:00	AAPL	Stock	14.2729	14.3132	14.2677	14.2896	42378308.0
2011-12-23 10:00:00	AAPL	Stock	14.2889	14.3029	14.2714	14.295	30571352.0
2011-12-23 11:00:00	AAPL	Stock	14.2964	14.3286	14.2911	14.3279	27447280.0
2011-12-23 12:00:00	AAPL	Stock	14.3279	14.4068	14.3189	14.4046	40870592.0
2011-12-23 13:00:00	AAPL	Stock	14.4046	14.405	14.3479	14.3643	31549000.0
2011-12-23 14:00:00	AAPL	Stock	14.3643	14.3663	14.3179	14.3261	25292512.0
2011-12-23 15:00:00	AAPL	Stock	14.3263	14.4139	14.3182	14.4064	59897544.0
2011-12-23 16:00:00	AAPL	Stock	14.4064	14.415	14.2933	14.415	4858420.0
2011-12-23 17:00:00	AAPL	Stock	14.4107	14.4125	14.4036	14.405	133700.0
2011-12-23 18:00:00	AAPL	Stock	14.4046	14.4046	14.3964	14.3968	145236.0
2011-12-23 19:00:00	AAPL	Stock	14.3968	14.4	14.3929	14.3946	100968.0
2011-12-23 08:00:00	MSFT	Stock	25.86	25.88	25.8	25.88	10080.0
2011-12-23 09:00:00	MSFT	Stock	25.86	25.95	25.73	25.85	3059870.0
2011-12-23 10:00:00	MSFT	Stock	25.85	25.86	25.73	25.84	2561301.0
2011-12-23 11:00:00	MSFT	Stock	25.84	25.96	25.83	25.93	3782466.0
2011-12-23 12:00:00	MSFT	Stock	25.93	26.0	25.92	25.989	2178217.0
2011-12-23 13:00:00	MSFT	Stock	25.985	26.04	25.96	26.015	2318920.0
2011-12-23 14:00:00	MSFT	Stock	26.01	26.02	25.95	25.97	1791118.0
2011-12-23 15:00:00	MSFT	Stock	25.97	26.03	25.95	26.02	5375583.0
2011-12-23 16:00:00	MSFT	Stock	26.02	26.033	25.87	25.915	1809425.0
2011-12-23 17:00:00	MSFT	Stock	25.99	26.02	25.99	26.02	4450.0
2011-12-23 18:00:00	MSFT	Stock	26.02	26.03	25.99	25.99	8599.0
2011-12-23 19:00:00	MSFT	Stock	26.02	26.02	26.02	26.02	11000.0
2011-12-23 08:00:00	NVDA	Stock	0.36	0.36	0.3588	0.3588	84800.0
2011-12-23 09:00:00	NVDA	Stock	0.3588	0.3602	0.355	0.356	21525280.0
2011-12-23 10:00:00	NVDA	Stock	0.3562	0.3562	0.3513	0.3538	46358640.0
2011-12-23 11:00:00	NVDA	Stock	0.3538	0.357	0.3538	0.356	38587800.0
2011-12-23 12:00:00	NVDA	Stock	0.3562	0.3562	0.353	0.3538	27688440.0
2011-12-23 13:00:00	NVDA	Stock	0.3536	0.3545	0.353	0.3538	24875800.0
2011-12-23 14:00:00	NVDA	Stock	0.3538	0.3548	0.353	0.3531	20438600.0
2011-12-23 15:00:00	NVDA	Stock	0.3531	0.3545	0.3525	0.3542	59053240.0
2011-12-23 16:00:00	NVDA	Stock	0.3542	0.355	0.3541	0.3542	10049720.0
2011-12-23 17:00:00	NVDA	Stock	0.355	0.355	0.3545	0.3545	33600.0
2011-12-23 07:00:00	AMZN	Stock	9.025	9.055	9.025	9.025	71020.0
2011-12-23 08:00:00	AMZN	Stock	9.03	9.04	8.976	8.979	313600.0
2011-12-23 09:00:00	AMZN	Stock	8.9815	8.984	8.825	8.8979	12382640.0
2011-12-23 10:00:00	AMZN	Stock	8.8979	8.925	8.78	8.8195	16091500.0
2011-12-23 11:00:00	AMZN	Stock	8.82	8.8686	8.8	8.8604	6917360.0
2011-12-23 12:00:00	AMZN	Stock	8.8605	8.892	8.8475	8.8745	8326940.0
2011-12-23 13:00:00	AMZN	Stock	8.8745	8.8855	8.852	8.8805	5560880.0
2011-12-23 14:00:00	AMZN	Stock	8.8805	8.882	8.8525	8.856	5263380.0
2011-12-23 15:00:00	AMZN	Stock	8.855	8.8815	8.85	8.864	12652200.0
2011-12-23 16:00:00	AMZN	Stock	8.864	8.8866	8.8535	8.8555	416300.0
2011-12-23 17:00:00	AMZN	Stock	8.86	8.86	8.8555	8.8555	24000.0
2011-12-23 18:00:00	AMZN	Stock	8.864	8.864	8.86	8.86	8000.0
2011-12-23 19:00:00	AMZN	Stock	8.86	8.86	8.8525	8.8525	20640.0

> showing 50 of 43,549 rows — these rows as CSV

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