PREVIEW / stock_1hour / 2010-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-14.parquet
  size:    898 KB
  rows:    43,002
  symbols: 3,468

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
2010-09-14 07:00:00	AAPL	Stock	9.5021	9.5196	9.4911	9.5089	140196.0
2010-09-14 08:00:00	AAPL	Stock	9.5107	9.5571	9.5018	9.5175	1824732.0
2010-09-14 09:00:00	AAPL	Stock	9.515	9.5596	9.4829	9.5561	71792140.0
2010-09-14 10:00:00	AAPL	Stock	9.5568	9.5761	9.5179	9.5689	72283876.0
2010-09-14 11:00:00	AAPL	Stock	9.5696	9.5911	9.5671	9.5879	53777612.0
2010-09-14 12:00:00	AAPL	Stock	9.5875	9.6132	9.5757	9.5825	51498972.0
2010-09-14 13:00:00	AAPL	Stock	9.5836	9.5937	9.5568	9.5889	33689852.0
2010-09-14 14:00:00	AAPL	Stock	9.5879	9.6071	9.5739	9.5981	43086736.0
2010-09-14 15:00:00	AAPL	Stock	9.5979	9.6021	9.5643	9.5729	65560376.0
2010-09-14 16:00:00	AAPL	Stock	9.5729	9.5933	9.5589	9.5646	9025016.0
2010-09-14 17:00:00	AAPL	Stock	9.565	9.5714	9.5625	9.5654	360584.0
2010-09-14 18:00:00	AAPL	Stock	9.5686	9.6121	9.5682	9.5943	2264304.0
2010-09-14 19:00:00	AAPL	Stock	9.5939	9.5939	9.5736	9.5864	508536.0
2010-09-14 05:00:00	MSFT	Stock	25.05	25.05	24.95	24.95	500.0
2010-09-14 06:00:00	MSFT	Stock	25.05	25.05	25.05	25.05	700.0
2010-09-14 07:00:00	MSFT	Stock	25.03	25.17	24.93	25.0	38400.0
2010-09-14 08:00:00	MSFT	Stock	25.0	25.1	24.97	24.99	134510.0
2010-09-14 09:00:00	MSFT	Stock	24.98	25.1	24.93	25.008	14764129.0
2010-09-14 10:00:00	MSFT	Stock	25.0	25.14	24.89	25.11	13741772.0
2010-09-14 11:00:00	MSFT	Stock	25.1	25.23	25.09	25.23	8905891.0
2010-09-14 12:00:00	MSFT	Stock	25.23	25.35	25.22	25.28	9148837.0
2010-09-14 13:00:00	MSFT	Stock	25.28	25.29	25.02	25.06	10936448.0
2010-09-14 14:00:00	MSFT	Stock	25.06	25.12	24.98	25.08	7811201.0
2010-09-14 15:00:00	MSFT	Stock	25.085	25.24	25.0	25.03	17584040.0
2010-09-14 16:00:00	MSFT	Stock	25.03	25.14	24.993	25.02	2493713.0
2010-09-14 17:00:00	MSFT	Stock	25.03	25.05	25.0	25.0	7002.0
2010-09-14 18:00:00	MSFT	Stock	25.0	25.05	25.0	25.03	21450.0
2010-09-14 19:00:00	MSFT	Stock	25.199	25.199	25.03	25.03	27939.0
2010-09-14 07:00:00	NVDA	Stock	0.2628	0.2628	0.2628	0.2628	12000.0
2010-09-14 08:00:00	NVDA	Stock	0.2658	0.2658	0.2628	0.2643	302480.0
2010-09-14 09:00:00	NVDA	Stock	0.2645	0.265	0.2612	0.2645	71500440.0
2010-09-14 10:00:00	NVDA	Stock	0.2645	0.267	0.2635	0.2652	117914240.0
2010-09-14 11:00:00	NVDA	Stock	0.2652	0.267	0.265	0.2668	119661680.0
2010-09-14 12:00:00	NVDA	Stock	0.2668	0.2668	0.265	0.266	56904560.0
2010-09-14 13:00:00	NVDA	Stock	0.266	0.2663	0.2618	0.2632	145366160.0
2010-09-14 14:00:00	NVDA	Stock	0.2633	0.2648	0.2623	0.2637	79725240.0
2010-09-14 15:00:00	NVDA	Stock	0.2638	0.2645	0.263	0.2635	87977880.0
2010-09-14 16:00:00	NVDA	Stock	0.2632	0.2656	0.2632	0.2632	18010200.0
2010-09-14 17:00:00	NVDA	Stock	0.262	0.262	0.262	0.262	40000.0
2010-09-14 18:00:00	NVDA	Stock	0.2625	0.2635	0.2612	0.2635	414000.0
2010-09-14 19:00:00	NVDA	Stock	0.2635	0.2635	0.2635	0.2635	210720.0
2010-09-14 07:00:00	AMZN	Stock	7.225	7.225	7.225	7.225	50000.0
2010-09-14 08:00:00	AMZN	Stock	7.225	7.293	7.225	7.265	571760.0
2010-09-14 09:00:00	AMZN	Stock	7.2585	7.2675	7.1916	7.258	11935740.0
2010-09-14 10:00:00	AMZN	Stock	7.2585	7.2885	7.2325	7.265	14702220.0
2010-09-14 11:00:00	AMZN	Stock	7.2655	7.333	7.2655	7.3228	13666760.0
2010-09-14 12:00:00	AMZN	Stock	7.323	7.335	7.2845	7.3	9481240.0
2010-09-14 13:00:00	AMZN	Stock	7.3	7.3155	7.2835	7.301	7364880.0
2010-09-14 14:00:00	AMZN	Stock	7.3	7.323	7.2955	7.3025	7816920.0
2010-09-14 15:00:00	AMZN	Stock	7.303	7.3155	7.2795	7.2875	17657440.0

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

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