PREVIEW / stock_1hour / 2010-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-29.parquet
  size:    907 KB
  rows:    43,520
  symbols: 3,460

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-06-29 04:00:00	AAPL	Stock	9.5396	9.5396	9.5039	9.5039	8400.0
2010-06-29 05:00:00	AAPL	Stock	9.5	9.5032	9.5	9.5032	11200.0
2010-06-29 06:00:00	AAPL	Stock	9.5171	9.5182	9.5143	9.5143	19600.0
2010-06-29 07:00:00	AAPL	Stock	9.5143	9.5143	9.4686	9.4854	493052.0
2010-06-29 08:00:00	AAPL	Stock	9.485	9.4964	9.425	9.4511	5366340.0
2010-06-29 09:00:00	AAPL	Stock	9.4518	9.4671	9.2146	9.2618	195640956.0
2010-06-29 10:00:00	AAPL	Stock	9.2611	9.2662	9.1157	9.1943	243440932.0
2010-06-29 11:00:00	AAPL	Stock	9.1943	9.2407	9.1718	9.1771	105302596.0
2010-06-29 12:00:00	AAPL	Stock	9.1782	9.2186	9.1586	9.1664	70112700.0
2010-06-29 13:00:00	AAPL	Stock	9.1711	9.2004	9.1411	9.1868	75548060.0
2010-06-29 14:00:00	AAPL	Stock	9.1864	9.3043	9.1425	9.2089	168837424.0
2010-06-29 15:00:00	AAPL	Stock	9.2089	9.25	9.0821	9.1532	241050712.0
2010-06-29 16:00:00	AAPL	Stock	9.1514	9.43	9.1286	9.145	22186612.0
2010-06-29 17:00:00	AAPL	Stock	9.1443	9.16	9.1357	9.1525	789880.0
2010-06-29 18:00:00	AAPL	Stock	9.1496	9.1518	9.1443	9.1518	337456.0
2010-06-29 19:00:00	AAPL	Stock	9.1518	9.1568	9.1386	9.1486	705180.0
2010-06-29 04:00:00	MSFT	Stock	24.03	24.03	24.0	24.0	600.0
2010-06-29 06:00:00	MSFT	Stock	24.0	24.08	24.0	24.08	1440.0
2010-06-29 07:00:00	MSFT	Stock	24.0	24.1	24.0	24.09	13100.0
2010-06-29 08:00:00	MSFT	Stock	24.09	24.12	24.03	24.1	169045.0
2010-06-29 09:00:00	MSFT	Stock	24.06	24.2	23.85	23.96	10058553.0
2010-06-29 10:00:00	MSFT	Stock	23.96	23.99	23.68	23.84	19137696.0
2010-06-29 11:00:00	MSFT	Stock	23.84	23.89	23.62	23.65	11572476.0
2010-06-29 12:00:00	MSFT	Stock	23.647	23.66	23.34	23.35	14158498.0
2010-06-29 13:00:00	MSFT	Stock	23.35	23.52	23.34	23.42	17461427.0
2010-06-29 14:00:00	MSFT	Stock	23.418	23.49	23.28	23.34	13022347.0
2010-06-29 15:00:00	MSFT	Stock	23.345	23.48	23.11	23.32	26282693.0
2010-06-29 16:00:00	MSFT	Stock	23.32	24.31	23.2	23.3	5487494.0
2010-06-29 17:00:00	MSFT	Stock	23.27	23.27	23.24	23.27	37533.0
2010-06-29 18:00:00	MSFT	Stock	23.27	23.31	23.24	23.3	41195.0
2010-06-29 19:00:00	MSFT	Stock	23.28	23.3	23.28	23.3	13800.0
2010-06-29 20:00:00	MSFT	Stock	24.44	24.44	23.8	23.8	114400.0
2010-06-29 08:00:00	NVDA	Stock	0.275	0.275	0.2712	0.2738	428440.0
2010-06-29 09:00:00	NVDA	Stock	0.2718	0.2725	0.2638	0.2663	123989640.0
2010-06-29 10:00:00	NVDA	Stock	0.2663	0.2665	0.263	0.2658	118715200.0
2010-06-29 11:00:00	NVDA	Stock	0.2658	0.27	0.2655	0.2665	85682400.0
2010-06-29 12:00:00	NVDA	Stock	0.2668	0.2672	0.265	0.266	29332040.0
2010-06-29 13:00:00	NVDA	Stock	0.266	0.2665	0.2638	0.2655	48472720.0
2010-06-29 14:00:00	NVDA	Stock	0.2655	0.2665	0.2632	0.264	59687520.0
2010-06-29 15:00:00	NVDA	Stock	0.2639	0.2652	0.2603	0.2623	174256240.0
2010-06-29 16:00:00	NVDA	Stock	0.262	0.265	0.261	0.2623	17292360.0
2010-06-29 17:00:00	NVDA	Stock	0.2623	0.2623	0.2623	0.2623	32320.0
2010-06-29 18:00:00	NVDA	Stock	0.2623	0.2645	0.262	0.2645	287840.0
2010-06-29 19:00:00	NVDA	Stock	0.2623	0.2648	0.2623	0.2623	163200.0
2010-06-29 07:00:00	AMZN	Stock	5.8315	5.8315	5.8275	5.8275	6000.0
2010-06-29 08:00:00	AMZN	Stock	5.83	5.85	5.8145	5.815	157360.0
2010-06-29 09:00:00	AMZN	Stock	5.802	5.824	5.6145	5.6595	39445940.0
2010-06-29 10:00:00	AMZN	Stock	5.6595	5.6598	5.5505	5.6315	35806000.0
2010-06-29 11:00:00	AMZN	Stock	5.631	5.6695	5.5825	5.6015	21252000.0
2010-06-29 12:00:00	AMZN	Stock	5.604	5.63	5.564	5.577	12877820.0

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

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