PREVIEW / stock_1hour / 2013-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-22.parquet
  size:    997 KB
  rows:    46,489
  symbols: 3,511

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-07-22 05:00:00	AAPL	Stock	15.2039	15.2086	15.2039	15.2086	5600.0
2013-07-22 06:00:00	AAPL	Stock	15.2093	15.2093	15.2032	15.2082	25900.0
2013-07-22 07:00:00	AAPL	Stock	15.1893	15.27	15.1893	15.2582	358876.0
2013-07-22 08:00:00	AAPL	Stock	15.2468	15.2607	15.2143	15.2471	1259356.0
2013-07-22 09:00:00	AAPL	Stock	15.2446	15.3571	15.1953	15.2443	55187580.0
2013-07-22 10:00:00	AAPL	Stock	15.2496	15.3286	15.2175	15.2854	35531412.0
2013-07-22 11:00:00	AAPL	Stock	15.2843	15.2986	15.2346	15.2467	17400096.0
2013-07-22 12:00:00	AAPL	Stock	15.2441	15.2657	15.2344	15.2404	14201068.0
2013-07-22 13:00:00	AAPL	Stock	15.24	15.2421	15.2019	15.2289	13561464.0
2013-07-22 14:00:00	AAPL	Stock	15.2289	15.2743	15.225	15.2671	14680596.0
2013-07-22 15:00:00	AAPL	Stock	15.2663	15.2671	15.1964	15.2221	20519912.0
2013-07-22 16:00:00	AAPL	Stock	15.2254	15.2596	15.2089	15.2254	28845236.0
2013-07-22 17:00:00	AAPL	Stock	15.2214	15.2357	15.2029	15.2321	210224.0
2013-07-22 18:00:00	AAPL	Stock	15.2321	15.25	15.2318	15.2321	142268.0
2013-07-22 19:00:00	AAPL	Stock	15.2329	15.2454	15.2321	15.2393	63308.0
2013-07-22 05:00:00	MSFT	Stock	31.65	31.66	31.65	31.66	640.0
2013-07-22 06:00:00	MSFT	Stock	31.67	31.7	31.67	31.7	4800.0
2013-07-22 07:00:00	MSFT	Stock	31.7	31.78	31.66	31.71	47964.0
2013-07-22 08:00:00	MSFT	Stock	31.71	31.78	31.51	31.55	213168.0
2013-07-22 09:00:00	MSFT	Stock	31.54	31.98	31.48	31.64	20387201.0
2013-07-22 10:00:00	MSFT	Stock	31.635	31.96	31.62	31.89	13467744.0
2013-07-22 11:00:00	MSFT	Stock	31.89	31.92	31.75	31.76	5537871.0
2013-07-22 12:00:00	MSFT	Stock	31.76	31.84	31.76	31.795	4767698.0
2013-07-22 13:00:00	MSFT	Stock	31.795	31.82	31.7	31.74	5492157.0
2013-07-22 14:00:00	MSFT	Stock	31.74	31.91	31.71	31.876	6733485.0
2013-07-22 15:00:00	MSFT	Stock	31.88	32.0	31.84	32.0	13159132.0
2013-07-22 16:00:00	MSFT	Stock	32.0	32.01	31.8	31.9	7346732.0
2013-07-22 17:00:00	MSFT	Stock	31.853	32.01	31.853	31.9	146842.0
2013-07-22 18:00:00	MSFT	Stock	31.9	31.96	31.9	31.96	7893.0
2013-07-22 19:00:00	MSFT	Stock	31.94	31.94	31.9	31.9	8020.0
2013-07-22 08:00:00	NVDA	Stock	0.3565	0.3565	0.3565	0.3565	6280.0
2013-07-22 09:00:00	NVDA	Stock	0.3582	0.3595	0.3565	0.3575	36298080.0
2013-07-22 10:00:00	NVDA	Stock	0.3575	0.3612	0.3572	0.3612	37502840.0
2013-07-22 11:00:00	NVDA	Stock	0.3612	0.362	0.358	0.3585	44560880.0
2013-07-22 12:00:00	NVDA	Stock	0.3585	0.3592	0.3582	0.3585	20121400.0
2013-07-22 13:00:00	NVDA	Stock	0.3585	0.3588	0.3562	0.3569	20332920.0
2013-07-22 14:00:00	NVDA	Stock	0.357	0.3582	0.3562	0.3571	33404560.0
2013-07-22 15:00:00	NVDA	Stock	0.357	0.357	0.3542	0.3558	88597240.0
2013-07-22 16:00:00	NVDA	Stock	0.3555	0.3588	0.3548	0.3548	312600.0
2013-07-22 17:00:00	NVDA	Stock	0.3548	0.3548	0.3548	0.3548	20000.0
2013-07-22 19:00:00	NVDA	Stock	0.3555	0.3555	0.3555	0.3555	12000.0
2013-07-22 06:00:00	AMZN	Stock	15.3165	15.3165	15.3	15.3	6000.0
2013-07-22 07:00:00	AMZN	Stock	15.2755	15.3	15.275	15.3	60000.0
2013-07-22 08:00:00	AMZN	Stock	15.225	15.3	15.225	15.298	56760.0
2013-07-22 09:00:00	AMZN	Stock	15.29	15.49	15.1935	15.212	14430700.0
2013-07-22 10:00:00	AMZN	Stock	15.212	15.2295	15.1015	15.14	8028560.0
2013-07-22 11:00:00	AMZN	Stock	15.139	15.1705	15.1	15.1555	5164840.0
2013-07-22 12:00:00	AMZN	Stock	15.1578	15.208	15.1365	15.1515	3026320.0
2013-07-22 13:00:00	AMZN	Stock	15.15	15.1835	15.142	15.1636	3989480.0
2013-07-22 14:00:00	AMZN	Stock	15.1635	15.2335	15.1405	15.2155	4471440.0

> showing 50 of 46,489 rows — these rows as CSV

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