PREVIEW / stock_1hour / 2010-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-08.parquet
  size:    878 KB
  rows:    42,546
  symbols: 3,459

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-07-08 04:00:00	AAPL	Stock	9.2714	9.2789	9.2714	9.2789	14000.0
2010-07-08 05:00:00	AAPL	Stock	9.2804	9.2804	9.275	9.275	61600.0
2010-07-08 06:00:00	AAPL	Stock	9.2768	9.3018	9.2768	9.3018	11200.0
2010-07-08 07:00:00	AAPL	Stock	9.2768	9.2857	9.245	9.2621	625548.0
2010-07-08 08:00:00	AAPL	Stock	9.2575	9.3811	9.25	9.3679	10124296.0
2010-07-08 09:00:00	AAPL	Stock	9.37	9.3925	9.3086	9.3316	117870200.0
2010-07-08 10:00:00	AAPL	Stock	9.3311	9.3489	9.2825	9.2846	112375816.0
2010-07-08 11:00:00	AAPL	Stock	9.285	9.2851	9.1286	9.1521	143827796.0
2010-07-08 12:00:00	AAPL	Stock	9.1514	9.2032	9.1032	9.1175	80077900.0
2010-07-08 13:00:00	AAPL	Stock	9.1171	9.1996	9.1132	9.16	76212444.0
2010-07-08 14:00:00	AAPL	Stock	9.1579	9.1821	9.1107	9.175	61437068.0
2010-07-08 15:00:00	AAPL	Stock	9.1757	9.2375	9.1446	9.2143	121481024.0
2010-07-08 16:00:00	AAPL	Stock	9.2171	9.3472	9.1844	9.2207	11048380.0
2010-07-08 17:00:00	AAPL	Stock	9.2204	9.2207	9.2157	9.2161	346780.0
2010-07-08 18:00:00	AAPL	Stock	9.2189	9.2196	9.2036	9.2104	299600.0
2010-07-08 19:00:00	AAPL	Stock	9.2089	9.2107	9.1982	9.2004	641872.0
2010-07-08 07:00:00	MSFT	Stock	24.38	24.42	24.35	24.35	3800.0
2010-07-08 08:00:00	MSFT	Stock	24.35	24.54	24.31	24.53	65876.0
2010-07-08 09:00:00	MSFT	Stock	24.51	24.63	23.972	24.31	6374448.0
2010-07-08 10:00:00	MSFT	Stock	24.32	24.4	24.22	24.342	7702218.0
2010-07-08 11:00:00	MSFT	Stock	24.35	24.35	24.17	24.23	5968191.0
2010-07-08 12:00:00	MSFT	Stock	24.23	24.37	24.22	24.26	3949531.0
2010-07-08 13:00:00	MSFT	Stock	24.25	24.35	24.19	24.24	3538305.0
2010-07-08 14:00:00	MSFT	Stock	24.24	24.31	24.13	24.18	5425670.0
2010-07-08 15:00:00	MSFT	Stock	24.19	24.42	24.11	24.42	13715986.0
2010-07-08 16:00:00	MSFT	Stock	24.42	24.48	24.252	24.41	2124506.0
2010-07-08 17:00:00	MSFT	Stock	24.42	24.42	24.4	24.4	650.0
2010-07-08 18:00:00	MSFT	Stock	24.4	24.41	24.4	24.41	1263.0
2010-07-08 19:00:00	MSFT	Stock	24.43	24.43	24.35	24.39	10038.0
2010-07-08 08:00:00	NVDA	Stock	0.2675	0.27	0.266	0.269	338480.0
2010-07-08 09:00:00	NVDA	Stock	0.269	0.2715	0.26	0.2615	95927320.0
2010-07-08 10:00:00	NVDA	Stock	0.2614	0.2628	0.2603	0.2604	117274280.0
2010-07-08 11:00:00	NVDA	Stock	0.2605	0.2605	0.2558	0.2563	130241920.0
2010-07-08 12:00:00	NVDA	Stock	0.2565	0.2582	0.2558	0.2566	73426800.0
2010-07-08 13:00:00	NVDA	Stock	0.2568	0.2583	0.2563	0.2568	55509400.0
2010-07-08 14:00:00	NVDA	Stock	0.2567	0.2572	0.2545	0.256	113615720.0
2010-07-08 15:00:00	NVDA	Stock	0.256	0.2585	0.2546	0.2575	183918480.0
2010-07-08 16:00:00	NVDA	Stock	0.2578	0.259	0.2565	0.2565	3481880.0
2010-07-08 17:00:00	NVDA	Stock	0.2585	0.2585	0.257	0.257	236400.0
2010-07-08 18:00:00	NVDA	Stock	0.2585	0.2585	0.2578	0.2578	10520.0
2010-07-08 19:00:00	NVDA	Stock	0.2585	0.2588	0.2578	0.2578	144000.0
2010-07-08 07:00:00	AMZN	Stock	5.702	5.702	5.702	5.702	2000.0
2010-07-08 08:00:00	AMZN	Stock	5.7	5.747	5.684	5.745	361240.0
2010-07-08 09:00:00	AMZN	Stock	5.745	5.842	5.7375	5.7925	26317900.0
2010-07-08 10:00:00	AMZN	Stock	5.7934	5.874	5.7575	5.821	28232280.0
2010-07-08 11:00:00	AMZN	Stock	5.82	5.82	5.745	5.7755	18177040.0
2010-07-08 12:00:00	AMZN	Stock	5.7755	5.8075	5.7445	5.756	10118620.0
2010-07-08 13:00:00	AMZN	Stock	5.754	5.8195	5.74	5.752	13461400.0
2010-07-08 14:00:00	AMZN	Stock	5.7522	5.7615	5.7035	5.756	11444660.0
2010-07-08 15:00:00	AMZN	Stock	5.756	5.8135	5.7285	5.8075	23988060.0

> showing 50 of 42,546 rows — these rows as CSV

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