PREVIEW / stock_1hour / 2007-12-24

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-24.parquet
  size:    551 KB
  rows:    24,691
  symbols: 3,205

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-12-24 04:00:00	AAPL	Stock	6.8757	6.8757	6.8757	6.8757	26600.0
2007-12-24 07:00:00	AAPL	Stock	6.8757	6.9464	6.8757	6.9429	253008.0
2007-12-24 08:00:00	AAPL	Stock	6.9429	6.9857	6.9286	6.9786	6077512.0
2007-12-24 09:00:00	AAPL	Stock	6.9786	7.0054	6.9254	7.0039	105436604.0
2007-12-24 10:00:00	AAPL	Stock	7.0025	7.0579	7.0025	7.0564	125788264.0
2007-12-24 11:00:00	AAPL	Stock	7.0564	7.0893	7.0518	7.0879	85722784.0
2007-12-24 12:00:00	AAPL	Stock	7.0879	7.1189	7.0721	7.1	129313184.0
2007-12-24 13:00:00	AAPL	Stock	7.1	7.1018	7.052	7.1	27095040.0
2007-12-24 14:00:00	AAPL	Stock	7.0954	7.1	7.0911	7.095	377440.0
2007-12-24 15:00:00	AAPL	Stock	7.0911	7.0982	7.0896	7.0932	106344.0
2007-12-24 16:00:00	AAPL	Stock	7.0964	7.1	7.0929	7.0982	76300.0
2007-12-24 07:00:00	MSFT	Stock	36.07	36.07	36.07	36.07	100.0
2007-12-24 08:00:00	MSFT	Stock	36.19	36.19	36.1	36.18	9377.0
2007-12-24 09:00:00	MSFT	Stock	36.18	36.7	36.05	36.62	5226448.0
2007-12-24 10:00:00	MSFT	Stock	36.62	36.71	36.5	36.71	6551709.0
2007-12-24 11:00:00	MSFT	Stock	36.71	36.71	36.6	36.61	4365800.0
2007-12-24 12:00:00	MSFT	Stock	36.6	36.72	36.55	36.62	7473973.0
2007-12-24 13:00:00	MSFT	Stock	36.58	36.78	36.55	36.6	5993513.0
2007-12-24 15:00:00	MSFT	Stock	36.6	36.61	36.58	36.58	984.0
2007-12-24 16:00:00	MSFT	Stock	36.65	36.74	36.65	36.74	677.0
2007-12-24 08:00:00	NVDA	Stock	0.8798	0.88	0.8798	0.88	12000.0
2007-12-24 09:00:00	NVDA	Stock	0.8812	0.8892	0.879	0.8852	21076400.0
2007-12-24 10:00:00	NVDA	Stock	0.8852	0.8938	0.8852	0.8933	25880880.0
2007-12-24 11:00:00	NVDA	Stock	0.8932	0.8938	0.8885	0.893	17997680.0
2007-12-24 12:00:00	NVDA	Stock	0.893	0.8988	0.8898	0.8948	35024520.0
2007-12-24 13:00:00	NVDA	Stock	0.8948	0.897	0.8899	0.894	3979760.0
2007-12-24 14:00:00	NVDA	Stock	0.8963	0.8975	0.8963	0.8975	17600.0
2007-12-24 15:00:00	NVDA	Stock	0.8945	0.8945	0.8945	0.8945	4000.0
2007-12-24 08:00:00	AMZN	Stock	4.5755	4.598	4.5375	4.5665	90540.0
2007-12-24 09:00:00	AMZN	Stock	4.5725	4.584	4.525	4.549	10655520.0
2007-12-24 10:00:00	AMZN	Stock	4.5465	4.5685	4.52	4.5304	11044200.0
2007-12-24 11:00:00	AMZN	Stock	4.5295	4.5365	4.515	4.5245	7003220.0
2007-12-24 12:00:00	AMZN	Stock	4.5255	4.578	4.5245	4.5535	10675400.0
2007-12-24 13:00:00	AMZN	Stock	4.5565	4.5615	4.5442	4.5442	821320.0
2007-12-24 14:00:00	AMZN	Stock	4.5325	4.55	4.5325	4.55	12000.0
2007-12-24 15:00:00	AMZN	Stock	4.56	4.56	4.56	4.56	2640.0
2007-12-24 16:00:00	AMZN	Stock	4.527	4.527	4.527	4.527	2000.0
2007-12-24 08:00:00	TLT	Stock	91.55	91.67	91.55	91.67	12100.0
2007-12-24 09:00:00	TLT	Stock	91.13	91.36	91.08	91.28	141700.0
2007-12-24 10:00:00	TLT	Stock	91.27	91.47	91.25	91.3	284500.0
2007-12-24 11:00:00	TLT	Stock	91.29	91.29	91.19	91.26	36100.0
2007-12-24 12:00:00	TLT	Stock	91.28	91.28	91.19	91.22	67657.0
2007-12-24 13:00:00	TLT	Stock	91.17	91.24	91.17	91.24	8200.0
2007-12-24 09:00:00	CL	Stock	39.5	39.66	39.35	39.455	281238.0
2007-12-24 10:00:00	CL	Stock	39.455	39.58	39.435	39.46	306804.0
2007-12-24 11:00:00	CL	Stock	39.47	39.47	39.265	39.265	276000.0
2007-12-24 12:00:00	CL	Stock	39.27	39.3	39.14	39.28	491800.0
2007-12-24 13:00:00	CL	Stock	39.275	39.37	39.23	39.36	225000.0

> showing 48 of 24,691 rows — these rows as CSV

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