PREVIEW / stock_1hour / 2007-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-28.parquet
  size:    682 KB
  rows:    32,347
  symbols: 2,550

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
2007-03-28 07:00:00	AAPL	Stock	3.405	3.4057	3.3964	3.3964	156800.0
2007-03-28 08:00:00	AAPL	Stock	3.3982	3.4036	3.3893	3.3929	4052552.0
2007-03-28 09:00:00	AAPL	Stock	3.3896	3.4068	3.3843	3.3896	112860580.0
2007-03-28 10:00:00	AAPL	Stock	3.39	3.4071	3.3786	3.3886	147624092.0
2007-03-28 11:00:00	AAPL	Stock	3.3882	3.3975	3.3857	3.3936	69691272.0
2007-03-28 12:00:00	AAPL	Stock	3.3932	3.3946	3.3668	3.3843	162018836.0
2007-03-28 13:00:00	AAPL	Stock	3.3843	3.385	3.3689	3.3721	69077596.0
2007-03-28 14:00:00	AAPL	Stock	3.3725	3.375	3.3343	3.345	183790376.0
2007-03-28 15:00:00	AAPL	Stock	3.345	3.3489	3.3268	3.3289	176994608.0
2007-03-28 16:00:00	AAPL	Stock	3.3293	3.3571	3.3221	3.3311	11116364.0
2007-03-28 17:00:00	AAPL	Stock	3.3321	3.3339	3.3232	3.3286	5407416.0
2007-03-28 18:00:00	AAPL	Stock	3.3257	3.3304	3.3257	3.3304	230020.0
2007-03-28 19:00:00	AAPL	Stock	3.3304	3.3332	3.3257	3.3332	231840.0
2007-03-28 08:00:00	MSFT	Stock	27.72	27.72	27.6	27.6	31050.0
2007-03-28 09:00:00	MSFT	Stock	27.6	27.88	27.4	27.76	4672830.0
2007-03-28 10:00:00	MSFT	Stock	27.76	27.85	27.52	27.73	7980827.0
2007-03-28 11:00:00	MSFT	Stock	27.73	27.81	27.65	27.7	4199536.0
2007-03-28 12:00:00	MSFT	Stock	27.709	28.0	27.7	27.87	5137685.0
2007-03-28 13:00:00	MSFT	Stock	27.87	27.95	27.79	27.86	3358920.0
2007-03-28 14:00:00	MSFT	Stock	27.86	27.91	27.66	27.7	6567344.0
2007-03-28 15:00:00	MSFT	Stock	27.69	27.81	27.63	27.63	12100710.0
2007-03-28 16:00:00	MSFT	Stock	27.63	27.69	27.6	27.69	1445382.0
2007-03-28 17:00:00	MSFT	Stock	27.69	27.69	27.64	27.69	1726121.0
2007-03-28 18:00:00	MSFT	Stock	27.69	27.69	27.67	27.67	4100.0
2007-03-28 19:00:00	MSFT	Stock	27.69	27.69	27.67	27.67	1250.0
2007-03-28 08:00:00	NVDA	Stock	0.491	0.491	0.4908	0.4908	28200.0
2007-03-28 09:00:00	NVDA	Stock	0.4947	0.4963	0.4883	0.4918	55072740.0
2007-03-28 10:00:00	NVDA	Stock	0.492	0.493	0.486	0.4907	79960740.0
2007-03-28 11:00:00	NVDA	Stock	0.4907	0.4917	0.486	0.4873	67078740.0
2007-03-28 12:00:00	NVDA	Stock	0.4875	0.4928	0.4868	0.4923	56303880.0
2007-03-28 13:00:00	NVDA	Stock	0.4922	0.4928	0.4892	0.4902	46816920.0
2007-03-28 14:00:00	NVDA	Stock	0.4902	0.491	0.4875	0.4888	47688240.0
2007-03-28 15:00:00	NVDA	Stock	0.4888	0.4902	0.4865	0.4868	86525520.0
2007-03-28 16:00:00	NVDA	Stock	0.4865	0.4868	0.485	0.485	13253520.0
2007-03-28 17:00:00	NVDA	Stock	0.4868	0.4868	0.4858	0.4868	4694280.0
2007-03-28 18:00:00	NVDA	Stock	0.4875	0.4875	0.4875	0.4875	78000.0
2007-03-28 19:00:00	NVDA	Stock	0.4875	0.4875	0.4875	0.4875	92640.0
2007-03-28 08:00:00	AMZN	Stock	1.959	1.959	1.955	1.955	12000.0
2007-03-28 09:00:00	AMZN	Stock	1.9595	1.966	1.9515	1.96	8969980.0
2007-03-28 10:00:00	AMZN	Stock	1.96	1.96	1.937	1.955	21706360.0
2007-03-28 11:00:00	AMZN	Stock	1.9545	1.956	1.9395	1.949	8312340.0
2007-03-28 12:00:00	AMZN	Stock	1.949	1.974	1.949	1.9715	15082740.0
2007-03-28 13:00:00	AMZN	Stock	1.971	1.9755	1.967	1.9725	17592720.0
2007-03-28 14:00:00	AMZN	Stock	1.973	1.9735	1.9585	1.9626	17517960.0
2007-03-28 15:00:00	AMZN	Stock	1.963	1.974	1.963	1.9685	25404020.0
2007-03-28 16:00:00	AMZN	Stock	1.9665	1.97	1.9665	1.9675	2193540.0
2007-03-28 17:00:00	AMZN	Stock	1.967	1.967	1.9625	1.9625	441640.0
2007-03-28 19:00:00	AMZN	Stock	1.9635	1.9635	1.9635	1.9635	20000.0
2007-03-28 09:00:00	CL	Stock	33.17	33.21	33.04	33.2	373000.0
2007-03-28 10:00:00	CL	Stock	33.205	33.24	33.05	33.14	550800.0

> showing 50 of 32,347 rows — these rows as CSV

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