PREVIEW / stock_1hour / 2009-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-13.parquet
  size:    783 KB
  rows:    38,824
  symbols: 3,317

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
2009-02-13 05:00:00	AAPL	Stock	3.5589	3.5693	3.5589	3.5693	5600.0
2009-02-13 06:00:00	AAPL	Stock	3.5607	3.5607	3.5607	3.5607	2800.0
2009-02-13 07:00:00	AAPL	Stock	3.5604	3.5604	3.5571	3.5571	14000.0
2009-02-13 08:00:00	AAPL	Stock	3.5554	3.5554	3.5111	3.5357	1197896.0
2009-02-13 09:00:00	AAPL	Stock	3.5343	3.5536	3.5043	3.5264	71096592.0
2009-02-13 10:00:00	AAPL	Stock	3.5264	3.5568	3.5107	3.5514	118925772.0
2009-02-13 11:00:00	AAPL	Stock	3.5507	3.5543	3.5307	3.5329	88781896.0
2009-02-13 12:00:00	AAPL	Stock	3.5325	3.5479	3.5211	3.5268	58293004.0
2009-02-13 13:00:00	AAPL	Stock	3.5261	3.5629	3.5196	3.5575	69799996.0
2009-02-13 14:00:00	AAPL	Stock	3.5582	3.5643	3.5411	3.5579	69704740.0
2009-02-13 15:00:00	AAPL	Stock	3.5586	3.5693	3.5368	3.54	116202520.0
2009-02-13 16:00:00	AAPL	Stock	3.5418	3.5479	3.5375	3.5429	7070980.0
2009-02-13 17:00:00	AAPL	Stock	3.5414	3.5429	3.5393	3.5393	35840.0
2009-02-13 18:00:00	AAPL	Stock	3.5414	3.5443	3.5393	3.5443	2943640.0
2009-02-13 19:00:00	AAPL	Stock	3.5414	3.5414	3.5393	3.5411	50400.0
2009-02-13 07:00:00	MSFT	Stock	19.2	19.35	19.2	19.35	500.0
2009-02-13 08:00:00	MSFT	Stock	19.36	19.37	19.2	19.26	15867.0
2009-02-13 09:00:00	MSFT	Stock	19.23	19.4	19.09	19.25	8112769.0
2009-02-13 10:00:00	MSFT	Stock	19.25	19.47	19.24	19.42	8437541.0
2009-02-13 11:00:00	MSFT	Stock	19.43	19.43	19.2	19.23	5687723.0
2009-02-13 12:00:00	MSFT	Stock	19.23	19.3	19.16	19.19	4584436.0
2009-02-13 13:00:00	MSFT	Stock	19.18	19.33	19.168	19.27	4407578.0
2009-02-13 14:00:00	MSFT	Stock	19.26	19.32	19.18	19.262	4615217.0
2009-02-13 15:00:00	MSFT	Stock	19.27	19.28	19.04	19.08	8948185.0
2009-02-13 16:00:00	MSFT	Stock	19.09	19.41	19.0	19.06	2071340.0
2009-02-13 17:00:00	MSFT	Stock	19.02	19.07	19.02	19.07	8937.0
2009-02-13 18:00:00	MSFT	Stock	19.09	19.09	19.07	19.08	15706.0
2009-02-13 19:00:00	MSFT	Stock	19.09	19.1	19.06	19.1	2216.0
2009-02-13 06:00:00	NVDA	Stock	0.2038	0.2038	0.2038	0.2038	40000.0
2009-02-13 07:00:00	NVDA	Stock	0.2058	0.2058	0.2058	0.2058	20000.0
2009-02-13 08:00:00	NVDA	Stock	0.2058	0.2058	0.2038	0.2053	20000.0
2009-02-13 09:00:00	NVDA	Stock	0.2035	0.2068	0.2018	0.2065	95376000.0
2009-02-13 10:00:00	NVDA	Stock	0.2065	0.21	0.206	0.2085	167513040.0
2009-02-13 11:00:00	NVDA	Stock	0.2082	0.2085	0.2043	0.2062	77137400.0
2009-02-13 12:00:00	NVDA	Stock	0.2062	0.207	0.204	0.205	65641880.0
2009-02-13 13:00:00	NVDA	Stock	0.2047	0.2078	0.2047	0.2068	68257040.0
2009-02-13 14:00:00	NVDA	Stock	0.2068	0.2075	0.2047	0.207	87418400.0
2009-02-13 15:00:00	NVDA	Stock	0.207	0.2102	0.2058	0.2078	189750240.0
2009-02-13 16:00:00	NVDA	Stock	0.2078	0.2085	0.2038	0.2078	1709400.0
2009-02-13 17:00:00	NVDA	Stock	0.2055	0.2075	0.2055	0.2075	44000.0
2009-02-13 18:00:00	NVDA	Stock	0.2075	0.2075	0.2075	0.2075	44000.0
2009-02-13 08:00:00	AMZN	Stock	3.198	3.205	3.1775	3.1775	33300.0
2009-02-13 09:00:00	AMZN	Stock	3.178	3.206	3.1575	3.187	10154240.0
2009-02-13 10:00:00	AMZN	Stock	3.1862	3.234	3.1785	3.22	18850500.0
2009-02-13 11:00:00	AMZN	Stock	3.22	3.222	3.181	3.184	9280140.0
2009-02-13 12:00:00	AMZN	Stock	3.1825	3.1905	3.1435	3.155	9519740.0
2009-02-13 13:00:00	AMZN	Stock	3.154	3.2045	3.1505	3.1944	8635740.0
2009-02-13 14:00:00	AMZN	Stock	3.193	3.209	3.182	3.1915	8785740.0
2009-02-13 15:00:00	AMZN	Stock	3.1935	3.196	3.16	3.164	15088100.0
2009-02-13 16:00:00	AMZN	Stock	3.1635	3.1895	3.16	3.1655	706120.0

> showing 50 of 38,824 rows — these rows as CSV

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