PREVIEW / stock_1hour / 2010-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-05.parquet
  size:    921 KB
  rows:    43,570
  symbols: 3,499

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-10-05 04:00:00	AAPL	Stock	10.0	10.0714	10.0	10.0643	9856.0
2010-10-05 07:00:00	AAPL	Stock	10.0021	10.0318	10.0021	10.0125	50120.0
2010-10-05 08:00:00	AAPL	Stock	10.0071	10.0618	10.0057	10.0536	2885036.0
2010-10-05 09:00:00	AAPL	Stock	10.0564	10.1893	9.9514	10.1839	105287392.0
2010-10-05 10:00:00	AAPL	Stock	10.1857	10.2375	10.1689	10.2082	108990728.0
2010-10-05 11:00:00	AAPL	Stock	10.2104	10.25	10.2036	10.2382	49836892.0
2010-10-05 12:00:00	AAPL	Stock	10.2382	10.2472	10.2214	10.2439	24295768.0
2010-10-05 13:00:00	AAPL	Stock	10.2439	10.2604	10.2304	10.2525	31878532.0
2010-10-05 14:00:00	AAPL	Stock	10.2514	10.2821	10.2411	10.2809	41633396.0
2010-10-05 15:00:00	AAPL	Stock	10.2821	10.3371	10.2754	10.3371	98663376.0
2010-10-05 16:00:00	AAPL	Stock	10.3325	10.3381	10.0751	10.325	23932356.0
2010-10-05 17:00:00	AAPL	Stock	10.2381	10.3361	10.2381	10.3268	1079008.0
2010-10-05 18:00:00	AAPL	Stock	10.3264	10.3368	10.3193	10.3339	777924.0
2010-10-05 19:00:00	AAPL	Stock	10.3357	10.3411	10.3321	10.3411	725732.0
2010-10-05 06:00:00	MSFT	Stock	23.98	23.98	23.9	23.9	4100.0
2010-10-05 07:00:00	MSFT	Stock	23.93	23.95	23.93	23.95	22500.0
2010-10-05 08:00:00	MSFT	Stock	23.95	24.05	23.95	24.03	62810.0
2010-10-05 09:00:00	MSFT	Stock	24.03	24.2	23.91	24.09	10783145.0
2010-10-05 10:00:00	MSFT	Stock	24.08	24.33	24.02	24.28	17447241.0
2010-10-05 11:00:00	MSFT	Stock	24.28	24.45	24.27	24.36	10892132.0
2010-10-05 12:00:00	MSFT	Stock	24.36	24.42	24.28	24.37	4997291.0
2010-10-05 13:00:00	MSFT	Stock	24.371	24.45	24.32	24.35	6377463.0
2010-10-05 14:00:00	MSFT	Stock	24.345	24.4	24.32	24.36	5286301.0
2010-10-05 15:00:00	MSFT	Stock	24.36	24.44	24.34	24.37	13568592.0
2010-10-05 16:00:00	MSFT	Stock	24.36	24.412	24.26	24.37	5537192.0
2010-10-05 17:00:00	MSFT	Stock	24.33	24.39	24.33	24.37	81169.0
2010-10-05 18:00:00	MSFT	Stock	24.37	24.37	24.35	24.37	117007.0
2010-10-05 19:00:00	MSFT	Stock	24.36	24.36	24.33	24.35	3133.0
2010-10-05 08:00:00	NVDA	Stock	0.2818	0.2875	0.28	0.2862	415200.0
2010-10-05 09:00:00	NVDA	Stock	0.287	0.2882	0.281	0.2858	100368920.0
2010-10-05 10:00:00	NVDA	Stock	0.2858	0.2875	0.2845	0.285	187249280.0
2010-10-05 11:00:00	NVDA	Stock	0.285	0.2858	0.2835	0.2849	102063000.0
2010-10-05 12:00:00	NVDA	Stock	0.2849	0.286	0.2838	0.2845	48603560.0
2010-10-05 13:00:00	NVDA	Stock	0.2848	0.285	0.2834	0.285	69764440.0
2010-10-05 14:00:00	NVDA	Stock	0.285	0.2855	0.2825	0.2832	73705160.0
2010-10-05 15:00:00	NVDA	Stock	0.283	0.2842	0.2822	0.283	150021600.0
2010-10-05 16:00:00	NVDA	Stock	0.283	0.2846	0.2825	0.2838	6579240.0
2010-10-05 17:00:00	NVDA	Stock	0.2825	0.2832	0.2825	0.2828	544480.0
2010-10-05 18:00:00	NVDA	Stock	0.2828	0.284	0.2828	0.283	454000.0
2010-10-05 19:00:00	NVDA	Stock	0.283	0.283	0.283	0.283	24000.0
2010-10-05 04:00:00	AMZN	Stock	7.815	7.815	7.815	7.815	2000.0
2010-10-05 08:00:00	AMZN	Stock	7.805	7.844	7.805	7.844	158500.0
2010-10-05 09:00:00	AMZN	Stock	7.844	7.919	7.7695	7.917	14885060.0
2010-10-05 10:00:00	AMZN	Stock	7.91	7.9435	7.879	7.8905	17990460.0
2010-10-05 11:00:00	AMZN	Stock	7.892	7.9535	7.8895	7.9309	11741020.0
2010-10-05 12:00:00	AMZN	Stock	7.931	7.982	7.923	7.9805	9787560.0
2010-10-05 13:00:00	AMZN	Stock	7.9785	8.0	7.956	7.987	10682000.0
2010-10-05 14:00:00	AMZN	Stock	7.986	8.05	7.984	8.049	17088300.0
2010-10-05 15:00:00	AMZN	Stock	8.0475	8.0605	8.0305	8.0435	21401240.0
2010-10-05 16:00:00	AMZN	Stock	8.043	8.0533	7.9654	8.0325	6738480.0

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

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