PREVIEW / stock_1hour / 2009-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-01.parquet
  size:    913 KB
  rows:    43,120
  symbols: 3,441

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-12-01 04:00:00	AAPL	Stock	7.1664	7.1964	7.1664	7.1964	11200.0
2009-12-01 05:00:00	AAPL	Stock	7.2036	7.2036	7.2036	7.2036	14000.0
2009-12-01 06:00:00	AAPL	Stock	7.2036	7.2036	7.2036	7.2036	12600.0
2009-12-01 07:00:00	AAPL	Stock	7.2029	7.2043	7.1964	7.2	192556.0
2009-12-01 08:00:00	AAPL	Stock	7.1975	7.2182	7.1839	7.2061	3094504.0
2009-12-01 09:00:00	AAPL	Stock	7.2057	7.2418	7.1396	7.2221	61369476.0
2009-12-01 10:00:00	AAPL	Stock	7.22	7.2221	7.1614	7.1875	83422892.0
2009-12-01 11:00:00	AAPL	Stock	7.188	7.1982	7.1704	7.1864	37331280.0
2009-12-01 12:00:00	AAPL	Stock	7.1868	7.1961	7.1814	7.1875	24749032.0
2009-12-01 13:00:00	AAPL	Stock	7.1879	7.2004	7.1764	7.185	35336672.0
2009-12-01 14:00:00	AAPL	Stock	7.185	7.2068	7.17	7.1746	42621628.0
2009-12-01 15:00:00	AAPL	Stock	7.1746	7.1982	7.0296	7.0325	151162032.0
2009-12-01 16:00:00	AAPL	Stock	7.0325	7.1624	7.0318	7.0661	20444256.0
2009-12-01 17:00:00	AAPL	Stock	7.0661	7.0979	7.0643	7.0979	1643992.0
2009-12-01 18:00:00	AAPL	Stock	7.0975	7.1107	7.0929	7.1	1425452.0
2009-12-01 19:00:00	AAPL	Stock	7.0971	7.1036	7.0786	7.0875	790412.0
2009-12-01 04:00:00	MSFT	Stock	29.57	29.57	29.57	29.57	200.0
2009-12-01 06:00:00	MSFT	Stock	29.59	29.59	29.59	29.59	200.0
2009-12-01 08:00:00	MSFT	Stock	29.51	29.61	29.48	29.6	9187.0
2009-12-01 09:00:00	MSFT	Stock	29.6	29.81	29.41	29.78	5273620.0
2009-12-01 10:00:00	MSFT	Stock	29.78	29.8	29.6	29.78	8670904.0
2009-12-01 11:00:00	MSFT	Stock	29.77	29.94	29.73	29.93	6313806.0
2009-12-01 12:00:00	MSFT	Stock	29.92	29.98	29.89	29.95	3918065.0
2009-12-01 13:00:00	MSFT	Stock	29.941	29.99	29.9	29.925	3382764.0
2009-12-01 14:00:00	MSFT	Stock	29.928	29.98	29.87	29.97	5270904.0
2009-12-01 15:00:00	MSFT	Stock	29.97	30.05	29.92	30.01	11933543.0
2009-12-01 16:00:00	MSFT	Stock	30.0	30.03	29.311	29.97	3284419.0
2009-12-01 17:00:00	MSFT	Stock	29.92	29.97	29.76	29.94	6762.0
2009-12-01 18:00:00	MSFT	Stock	29.94	30.0	29.94	30.0	1320.0
2009-12-01 19:00:00	MSFT	Stock	29.97	30.01	29.97	30.01	2250.0
2009-12-01 09:00:00	NVDA	Stock	0.3265	0.336	0.3265	0.3356	74686400.0
2009-12-01 10:00:00	NVDA	Stock	0.3355	0.3368	0.333	0.3333	119565120.0
2009-12-01 11:00:00	NVDA	Stock	0.3333	0.3348	0.3322	0.3345	67969360.0
2009-12-01 12:00:00	NVDA	Stock	0.3342	0.335	0.3338	0.334	33349840.0
2009-12-01 13:00:00	NVDA	Stock	0.3338	0.3358	0.3338	0.335	31054920.0
2009-12-01 14:00:00	NVDA	Stock	0.3348	0.336	0.3335	0.3345	38589440.0
2009-12-01 15:00:00	NVDA	Stock	0.3348	0.335	0.333	0.3333	75230600.0
2009-12-01 16:00:00	NVDA	Stock	0.333	0.3342	0.333	0.333	13417320.0
2009-12-01 17:00:00	NVDA	Stock	0.333	0.333	0.333	0.333	4000.0
2009-12-01 18:00:00	NVDA	Stock	0.333	0.333	0.333	0.333	12000.0
2009-12-01 19:00:00	NVDA	Stock	0.3328	0.3328	0.3328	0.3328	16000.0
2009-12-01 04:00:00	AMZN	Stock	6.8545	6.88	6.8545	6.88	12000.0
2009-12-01 06:00:00	AMZN	Stock	6.858	6.858	6.82	6.82	8160.0
2009-12-01 07:00:00	AMZN	Stock	6.805	6.858	6.805	6.84	141120.0
2009-12-01 08:00:00	AMZN	Stock	6.845	6.855	6.8325	6.834	777060.0
2009-12-01 09:00:00	AMZN	Stock	6.8365	6.8565	6.7875	6.8395	34874700.0
2009-12-01 10:00:00	AMZN	Stock	6.8395	6.9345	6.8185	6.9315	50099860.0
2009-12-01 11:00:00	AMZN	Stock	6.9315	6.937	6.9015	6.919	20000260.0
2009-12-01 12:00:00	AMZN	Stock	6.919	6.9495	6.906	6.9445	16028780.0
2009-12-01 13:00:00	AMZN	Stock	6.9435	6.9675	6.939	6.946	17391920.0

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

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