PREVIEW / stock_1hour / 2007-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-26.parquet
  size:    761 KB
  rows:    37,159
  symbols: 3,036

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-06-26 09:00:00	AAPL	Stock	4.4279	4.4286	4.3814	4.3907	151982096.0
2007-06-26 10:00:00	AAPL	Stock	4.3904	4.3925	4.3057	4.3229	263388328.0
2007-06-26 11:00:00	AAPL	Stock	4.3225	4.3279	4.2504	4.275	262562244.0
2007-06-26 12:00:00	AAPL	Stock	4.275	4.2904	4.2525	4.2764	135474136.0
2007-06-26 13:00:00	AAPL	Stock	4.2761	4.3161	4.2707	4.2882	142891448.0
2007-06-26 14:00:00	AAPL	Stock	4.2882	4.2929	4.2593	4.2593	120532188.0
2007-06-26 15:00:00	AAPL	Stock	4.2593	4.2754	4.24	4.2754	191495780.0
2007-06-26 16:00:00	AAPL	Stock	4.2754	4.2754	4.2711	4.2732	9124976.0
2007-06-26 09:00:00	MSFT	Stock	29.55	29.651	29.5	29.64	3897656.0
2007-06-26 10:00:00	MSFT	Stock	29.65	29.7	29.57	29.58	6768868.0
2007-06-26 11:00:00	MSFT	Stock	29.57	29.74	29.51	29.73	4312264.0
2007-06-26 12:00:00	MSFT	Stock	29.72	29.78	29.67	29.72	5046607.0
2007-06-26 13:00:00	MSFT	Stock	29.72	29.8	29.69	29.72	4613551.0
2007-06-26 14:00:00	MSFT	Stock	29.725	29.74	29.51	29.52	6383268.0
2007-06-26 15:00:00	MSFT	Stock	29.51	29.61	29.5	29.53	9029535.0
2007-06-26 16:00:00	MSFT	Stock	29.52	29.53	29.52	29.52	2698266.0
2007-06-26 08:00:00	NVDA	Stock	0.7007	0.7063	0.7007	0.7063	694020.0
2007-06-26 09:00:00	NVDA	Stock	0.7067	0.708	0.6917	0.6977	82802040.0
2007-06-26 10:00:00	NVDA	Stock	0.6978	0.6987	0.6783	0.6787	212287560.0
2007-06-26 11:00:00	NVDA	Stock	0.6788	0.6857	0.6783	0.685	101713500.0
2007-06-26 12:00:00	NVDA	Stock	0.6852	0.6855	0.6797	0.68	71158800.0
2007-06-26 13:00:00	NVDA	Stock	0.6799	0.6832	0.6758	0.6767	91289220.0
2007-06-26 14:00:00	NVDA	Stock	0.6767	0.6807	0.6763	0.6768	98893440.0
2007-06-26 15:00:00	NVDA	Stock	0.6768	0.6995	0.6733	0.6753	165554760.0
2007-06-26 16:00:00	NVDA	Stock	0.6752	0.7088	0.674	0.6748	19689240.0
2007-06-26 17:00:00	NVDA	Stock	0.677	0.677	0.6753	0.6753	126600.0
2007-06-26 18:00:00	NVDA	Stock	0.6768	0.6768	0.6733	0.6733	66000.0
2007-06-26 19:00:00	NVDA	Stock	0.6768	0.677	0.6768	0.677	178620.0
2007-06-26 07:00:00	AMZN	Stock	3.4375	3.44	3.4375	3.44	43400.0
2007-06-26 08:00:00	AMZN	Stock	3.45	3.45	3.433	3.433	132000.0
2007-06-26 09:00:00	AMZN	Stock	3.432	3.4375	3.3725	3.376	30884280.0
2007-06-26 10:00:00	AMZN	Stock	3.376	3.4065	3.369	3.3775	47413040.0
2007-06-26 11:00:00	AMZN	Stock	3.3775	3.4	3.371	3.396	25619720.0
2007-06-26 12:00:00	AMZN	Stock	3.3955	3.4065	3.371	3.374	15475980.0
2007-06-26 13:00:00	AMZN	Stock	3.3735	3.3975	3.372	3.3955	23526100.0
2007-06-26 14:00:00	AMZN	Stock	3.3955	3.403	3.375	3.3775	27099940.0
2007-06-26 15:00:00	AMZN	Stock	3.3775	3.41	3.371	3.375	40222380.0
2007-06-26 16:00:00	AMZN	Stock	3.375	3.43	3.37	3.374	7413340.0
2007-06-26 17:00:00	AMZN	Stock	3.374	3.374	3.374	3.374	24280.0
2007-06-26 18:00:00	AMZN	Stock	3.3725	3.375	3.3725	3.375	4000.0
2007-06-26 19:00:00	AMZN	Stock	3.3725	3.3725	3.37	3.37	29780.0
2007-06-26 09:00:00	TLT	Stock	84.29	84.32	84.19	84.26	129400.0
2007-06-26 10:00:00	TLT	Stock	84.26	84.31	84.13	84.28	1245480.0
2007-06-26 11:00:00	TLT	Stock	84.28	84.28	83.97	83.97	214100.0
2007-06-26 12:00:00	TLT	Stock	83.98	84.16	83.97	84.13	123000.0
2007-06-26 13:00:00	TLT	Stock	84.13	84.2	84.08	84.16	154600.0
2007-06-26 14:00:00	TLT	Stock	84.15	84.15	84.05	84.06	70400.0
2007-06-26 15:00:00	TLT	Stock	84.06	84.12	84.01	84.07	221300.0
2007-06-26 16:00:00	TLT	Stock	84.07	84.24	84.07	84.24	6700.0
2007-06-26 09:00:00	CL	Stock	32.77	32.775	32.675	32.755	1090400.0

> showing 50 of 37,159 rows — these rows as CSV

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