PREVIEW / stock_1hour / 2009-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-29.parquet
  size:    886 KB
  rows:    42,534
  symbols: 3,467

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-29 04:00:00	AAPL	Stock	7.5714	7.5714	7.5714	7.5714	5600.0
2009-12-29 05:00:00	AAPL	Stock	7.5714	7.575	7.5714	7.5714	8400.0
2009-12-29 06:00:00	AAPL	Stock	7.5707	7.5707	7.5707	7.5707	2800.0
2009-12-29 07:00:00	AAPL	Stock	7.5836	7.5993	7.5782	7.5929	78540.0
2009-12-29 08:00:00	AAPL	Stock	7.5893	7.6036	7.5804	7.5821	2837296.0
2009-12-29 09:00:00	AAPL	Stock	7.5814	7.5971	7.5243	7.5479	82185376.0
2009-12-29 10:00:00	AAPL	Stock	7.5479	7.5511	7.5007	7.5268	76424516.0
2009-12-29 11:00:00	AAPL	Stock	7.5261	7.5321	7.4789	7.495	60711112.0
2009-12-29 12:00:00	AAPL	Stock	7.4946	7.4968	7.4629	7.4748	54606300.0
2009-12-29 13:00:00	AAPL	Stock	7.4746	7.5139	7.4654	7.5014	36933036.0
2009-12-29 14:00:00	AAPL	Stock	7.5021	7.5029	7.4732	7.4814	37869300.0
2009-12-29 15:00:00	AAPL	Stock	7.4804	7.4993	7.4546	7.4668	69377560.0
2009-12-29 16:00:00	AAPL	Stock	7.4679	7.5492	7.4604	7.4657	6502748.0
2009-12-29 17:00:00	AAPL	Stock	7.4657	7.4804	7.4643	7.4786	846748.0
2009-12-29 18:00:00	AAPL	Stock	7.4782	7.4786	7.4643	7.4764	847700.0
2009-12-29 19:00:00	AAPL	Stock	7.4775	7.4786	7.4646	7.4646	682528.0
2009-12-29 07:00:00	MSFT	Stock	31.19	31.19	31.19	31.19	200.0
2009-12-29 08:00:00	MSFT	Stock	31.22	31.29	31.18	31.2	30156.0
2009-12-29 09:00:00	MSFT	Stock	31.25	31.49	31.23	31.38	3695054.0
2009-12-29 10:00:00	MSFT	Stock	31.38	31.42	31.26	31.3	3689507.0
2009-12-29 11:00:00	MSFT	Stock	31.295	31.38	31.28	31.38	2566384.0
2009-12-29 12:00:00	MSFT	Stock	31.375	31.43	31.35	31.425	2552218.0
2009-12-29 13:00:00	MSFT	Stock	31.42	31.43	31.32	31.392	2444376.0
2009-12-29 14:00:00	MSFT	Stock	31.4	31.49	31.38	31.475	4193541.0
2009-12-29 15:00:00	MSFT	Stock	31.48	31.5	31.38	31.39	7740193.0
2009-12-29 16:00:00	MSFT	Stock	31.39	31.416	31.363	31.39	1326876.0
2009-12-29 17:00:00	MSFT	Stock	31.16	31.39	31.024	31.39	217326.0
2009-12-29 18:00:00	MSFT	Stock	31.39	31.39	31.39	31.39	8809.0
2009-12-29 19:00:00	MSFT	Stock	31.37	31.38	31.36	31.36	6310.0
2009-12-29 08:00:00	NVDA	Stock	0.444	0.4442	0.444	0.4442	16000.0
2009-12-29 09:00:00	NVDA	Stock	0.4445	0.4478	0.4425	0.4462	33174240.0
2009-12-29 10:00:00	NVDA	Stock	0.4465	0.4485	0.4458	0.4462	41393960.0
2009-12-29 11:00:00	NVDA	Stock	0.4465	0.448	0.445	0.4468	68341800.0
2009-12-29 12:00:00	NVDA	Stock	0.447	0.4482	0.4458	0.4478	56807520.0
2009-12-29 13:00:00	NVDA	Stock	0.4475	0.45	0.447	0.45	36349520.0
2009-12-29 14:00:00	NVDA	Stock	0.45	0.451	0.4488	0.4495	60948120.0
2009-12-29 15:00:00	NVDA	Stock	0.4495	0.4518	0.4495	0.4505	78062520.0
2009-12-29 16:00:00	NVDA	Stock	0.4505	0.4505	0.448	0.4505	2227960.0
2009-12-29 17:00:00	NVDA	Stock	0.4505	0.4505	0.4505	0.4505	223040.0
2009-12-29 18:00:00	NVDA	Stock	0.4518	0.452	0.4518	0.4518	26400.0
2009-12-29 19:00:00	NVDA	Stock	0.452	0.452	0.452	0.452	8400.0
2009-12-29 06:00:00	AMZN	Stock	6.979	6.98	6.979	6.98	16000.0
2009-12-29 07:00:00	AMZN	Stock	6.9995	7.023	6.994	7.018	78000.0
2009-12-29 08:00:00	AMZN	Stock	7.0235	7.047	7.018	7.0275	519400.0
2009-12-29 09:00:00	AMZN	Stock	7.028	7.129	7.025	7.05	36128360.0
2009-12-29 10:00:00	AMZN	Stock	7.0545	7.0545	6.9845	7.012	32483900.0
2009-12-29 11:00:00	AMZN	Stock	7.0115	7.0235	6.99	7.0	17046520.0
2009-12-29 12:00:00	AMZN	Stock	6.9995	7.0141	6.9555	6.9597	17222960.0
2009-12-29 13:00:00	AMZN	Stock	6.96	6.984	6.9275	6.975	22318900.0
2009-12-29 14:00:00	AMZN	Stock	6.975	6.985	6.95	6.9595	12110060.0

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

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