PREVIEW / stock_1hour / 2007-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-22.parquet
  size:    818 KB
  rows:    39,545
  symbols: 3,031

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-22 09:00:00	AAPL	Stock	4.4232	4.4446	4.3996	4.4275	98011760.0
2007-06-22 10:00:00	AAPL	Stock	4.4275	4.4446	4.4121	4.4229	111708016.0
2007-06-22 11:00:00	AAPL	Stock	4.4239	4.425	4.3943	4.4068	76770708.0
2007-06-22 12:00:00	AAPL	Stock	4.4065	4.4107	4.3793	4.3982	82516476.0
2007-06-22 13:00:00	AAPL	Stock	4.3979	4.4007	4.3707	4.3911	74683168.0
2007-06-22 14:00:00	AAPL	Stock	4.3911	4.4057	4.3839	4.3932	54725748.0
2007-06-22 15:00:00	AAPL	Stock	4.3936	4.4086	4.3829	4.3925	88924584.0
2007-06-22 16:00:00	AAPL	Stock	4.3925	4.3929	4.3923	4.3929	13969872.0
2007-06-22 09:00:00	MSFT	Stock	30.0	30.1	29.86	29.92	4881535.0
2007-06-22 10:00:00	MSFT	Stock	29.91	29.94	29.76	29.9	7786811.0
2007-06-22 11:00:00	MSFT	Stock	29.903	29.92	29.68	29.75	7294087.0
2007-06-22 12:00:00	MSFT	Stock	29.74	29.75	29.46	29.58	10172786.0
2007-06-22 13:00:00	MSFT	Stock	29.57	29.71	29.48	29.52	8541041.0
2007-06-22 14:00:00	MSFT	Stock	29.52	29.64	29.5	29.58	7597458.0
2007-06-22 15:00:00	MSFT	Stock	29.58	29.6	29.45	29.5	14945531.0
2007-06-22 16:00:00	MSFT	Stock	29.5	29.52	29.49	29.49	8410521.0
2007-06-22 08:00:00	NVDA	Stock	0.7163	0.7208	0.7128	0.7128	674640.0
2007-06-22 09:00:00	NVDA	Stock	0.716	0.7205	0.7115	0.7135	93299040.0
2007-06-22 10:00:00	NVDA	Stock	0.7133	0.7197	0.7058	0.7158	153730380.0
2007-06-22 11:00:00	NVDA	Stock	0.7158	0.7243	0.7143	0.7233	112214220.0
2007-06-22 12:00:00	NVDA	Stock	0.7233	0.7247	0.7183	0.7187	134138220.0
2007-06-22 13:00:00	NVDA	Stock	0.7187	0.725	0.718	0.7218	101963580.0
2007-06-22 14:00:00	NVDA	Stock	0.7218	0.7312	0.7208	0.7298	106332660.0
2007-06-22 15:00:00	NVDA	Stock	0.73	0.7303	0.7223	0.7262	135879840.0
2007-06-22 16:00:00	NVDA	Stock	0.726	0.73	0.7253	0.726	32021280.0
2007-06-22 17:00:00	NVDA	Stock	0.7267	0.7292	0.7258	0.7292	1146420.0
2007-06-22 18:00:00	NVDA	Stock	0.7292	0.7292	0.7292	0.7292	44700.0
2007-06-22 19:00:00	NVDA	Stock	0.727	0.729	0.726	0.729	39660.0
2007-06-22 09:00:00	AMZN	Stock	3.4735	3.494	3.4395	3.474	17097400.0
2007-06-22 10:00:00	AMZN	Stock	3.4735	3.4745	3.4375	3.464	24148000.0
2007-06-22 11:00:00	AMZN	Stock	3.4625	3.485	3.4535	3.4778	16634060.0
2007-06-22 12:00:00	AMZN	Stock	3.477	3.4785	3.428	3.4365	19936180.0
2007-06-22 13:00:00	AMZN	Stock	3.436	3.457	3.421	3.444	14977280.0
2007-06-22 14:00:00	AMZN	Stock	3.445	3.4575	3.436	3.447	12766000.0
2007-06-22 15:00:00	AMZN	Stock	3.447	3.4575	3.4325	3.4495	24201640.0
2007-06-22 16:00:00	AMZN	Stock	3.4485	3.449	3.4425	3.445	30885380.0
2007-06-22 17:00:00	AMZN	Stock	3.4444	3.4485	3.4444	3.4485	62000.0
2007-06-22 18:00:00	AMZN	Stock	3.4485	3.454	3.4465	3.454	53420.0
2007-06-22 09:00:00	TLT	Stock	83.05	83.1	82.95	83.02	110500.0
2007-06-22 10:00:00	TLT	Stock	83.05	83.4	83.05	83.28	119300.0
2007-06-22 11:00:00	TLT	Stock	83.28	83.43	83.27	83.4	245200.0
2007-06-22 12:00:00	TLT	Stock	83.39	83.58	83.29	83.53	879600.0
2007-06-22 13:00:00	TLT	Stock	83.53	83.68	83.45	83.51	77700.0
2007-06-22 14:00:00	TLT	Stock	83.52	83.61	83.49	83.61	178700.0
2007-06-22 15:00:00	TLT	Stock	83.61	83.77	83.6	83.7	402300.0
2007-06-22 16:00:00	TLT	Stock	83.72	83.76	83.72	83.76	3900.0
2007-06-22 09:00:00	CL	Stock	33.14	33.14	32.825	32.84	872800.0
2007-06-22 10:00:00	CL	Stock	32.835	32.92	32.785	32.805	782600.0
2007-06-22 11:00:00	CL	Stock	32.805	32.86	32.655	32.84	917000.0
2007-06-22 12:00:00	CL	Stock	32.84	32.88	32.64	32.71	1062000.0

> showing 50 of 39,545 rows — these rows as CSV

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