PREVIEW / stock_1hour / 2007-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-02.parquet
  size:    768 KB
  rows:    37,858
  symbols: 3,039

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-07-02 09:00:00	AAPL	Stock	4.3232	4.3604	4.2607	4.3464	273012376.0
2007-07-02 10:00:00	AAPL	Stock	4.3464	4.3571	4.3036	4.3264	168136668.0
2007-07-02 11:00:00	AAPL	Stock	4.3257	4.3536	4.3179	4.3293	97677020.0
2007-07-02 12:00:00	AAPL	Stock	4.3289	4.3571	4.3186	4.3321	110937372.0
2007-07-02 13:00:00	AAPL	Stock	4.3318	4.3375	4.3179	4.3254	58128812.0
2007-07-02 14:00:00	AAPL	Stock	4.3254	4.335	4.3107	4.3214	73203004.0
2007-07-02 15:00:00	AAPL	Stock	4.3211	4.3421	4.3	4.3307	126930580.0
2007-07-02 16:00:00	AAPL	Stock	4.3304	4.3307	4.3282	4.3307	5025552.0
2007-07-02 09:00:00	MSFT	Stock	29.67	29.8	29.6	29.73	5838872.0
2007-07-02 10:00:00	MSFT	Stock	29.74	29.77	29.56	29.68	7820662.0
2007-07-02 11:00:00	MSFT	Stock	29.68	29.73	29.55	29.57	5625672.0
2007-07-02 12:00:00	MSFT	Stock	29.553	29.63	29.49	29.62	5479654.0
2007-07-02 13:00:00	MSFT	Stock	29.62	29.78	29.6	29.735	3831163.0
2007-07-02 14:00:00	MSFT	Stock	29.74	29.79	29.71	29.77	4272099.0
2007-07-02 15:00:00	MSFT	Stock	29.76	29.79	29.67	29.75	7715007.0
2007-07-02 16:00:00	MSFT	Stock	29.74	29.74	29.74	29.74	1054824.0
2007-07-02 08:00:00	NVDA	Stock	0.6885	0.69	0.6885	0.69	8187420.0
2007-07-02 09:00:00	NVDA	Stock	0.6932	0.7	0.6932	0.6985	47898780.0
2007-07-02 10:00:00	NVDA	Stock	0.6983	0.7133	0.6983	0.713	118761000.0
2007-07-02 11:00:00	NVDA	Stock	0.7132	0.7175	0.7113	0.7113	101023860.0
2007-07-02 12:00:00	NVDA	Stock	0.7115	0.7163	0.7095	0.7128	59940720.0
2007-07-02 13:00:00	NVDA	Stock	0.7128	0.715	0.7113	0.7128	38939100.0
2007-07-02 14:00:00	NVDA	Stock	0.7128	0.7158	0.712	0.7153	50981100.0
2007-07-02 15:00:00	NVDA	Stock	0.7152	0.7173	0.7137	0.7172	98127120.0
2007-07-02 16:00:00	NVDA	Stock	0.7172	0.7172	0.7158	0.7168	557640.0
2007-07-02 17:00:00	NVDA	Stock	0.7168	0.7168	0.7168	0.7168	24000.0
2007-07-02 19:00:00	NVDA	Stock	0.7167	0.7168	0.7167	0.7168	36900.0
2007-07-02 08:00:00	AMZN	Stock	3.425	3.445	3.4205	3.444	1752500.0
2007-07-02 09:00:00	AMZN	Stock	3.4435	3.4495	3.41	3.4305	10819900.0
2007-07-02 10:00:00	AMZN	Stock	3.4295	3.466	3.4225	3.463	15828920.0
2007-07-02 11:00:00	AMZN	Stock	3.463	3.476	3.46	3.4605	11651260.0
2007-07-02 12:00:00	AMZN	Stock	3.4605	3.476	3.46	3.467	7600000.0
2007-07-02 13:00:00	AMZN	Stock	3.467	3.4815	3.4655	3.4775	9713300.0
2007-07-02 14:00:00	AMZN	Stock	3.479	3.4825	3.4735	3.479	12144760.0
2007-07-02 15:00:00	AMZN	Stock	3.4785	3.4855	3.473	3.48	23670340.0
2007-07-02 16:00:00	AMZN	Stock	3.4805	3.4825	3.479	3.4825	2250340.0
2007-07-02 17:00:00	AMZN	Stock	3.4815	3.4815	3.4805	3.4805	204200.0
2007-07-02 18:00:00	AMZN	Stock	3.4805	3.485	3.4805	3.485	23400.0
2007-07-02 19:00:00	AMZN	Stock	3.4845	3.494	3.475	3.494	122000.0
2007-07-02 09:00:00	TLT	Stock	84.81	85.02	84.81	85.0	97200.0
2007-07-02 10:00:00	TLT	Stock	84.99	85.19	84.85	85.15	301500.0
2007-07-02 11:00:00	TLT	Stock	85.16	85.19	84.97	84.98	205100.0
2007-07-02 12:00:00	TLT	Stock	84.99	85.07	84.97	85.02	182900.0
2007-07-02 13:00:00	TLT	Stock	85.03	85.08	84.99	85.02	112800.0
2007-07-02 14:00:00	TLT	Stock	85.0	85.17	84.98	85.16	264700.0
2007-07-02 15:00:00	TLT	Stock	85.16	85.37	85.16	85.3	638560.0
2007-07-02 16:00:00	TLT	Stock	85.3	85.31	85.29	85.29	9600.0
2007-07-02 09:00:00	CL	Stock	32.61	32.72	32.52	32.7	535000.0
2007-07-02 10:00:00	CL	Stock	32.705	32.78	32.52	32.585	402400.0
2007-07-02 11:00:00	CL	Stock	32.585	32.665	32.5	32.5	591200.0

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

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