PREVIEW / stock_1hour / 2007-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-23.parquet
  size:    758 KB
  rows:    37,047
  symbols: 3,013

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-05-23 09:00:00	AAPL	Stock	4.0721	4.1029	4.0686	4.095	97150340.0
2007-05-23 10:00:00	AAPL	Stock	4.095	4.1071	4.0879	4.1029	128447452.0
2007-05-23 11:00:00	AAPL	Stock	4.1032	4.1036	4.0836	4.0968	78914024.0
2007-05-23 12:00:00	AAPL	Stock	4.0968	4.1	4.0704	4.0889	107926252.0
2007-05-23 13:00:00	AAPL	Stock	4.0893	4.0914	4.0357	4.0418	108732652.0
2007-05-23 14:00:00	AAPL	Stock	4.0421	4.0643	4.0211	4.0597	192590776.0
2007-05-23 15:00:00	AAPL	Stock	4.06	4.0621	4.0289	4.0318	124519304.0
2007-05-23 16:00:00	AAPL	Stock	4.0318	4.0321	4.0318	4.0318	4940572.0
2007-05-23 09:00:00	MSFT	Stock	30.84	30.84	30.61	30.655	4253604.0
2007-05-23 10:00:00	MSFT	Stock	30.641	30.71	30.59	30.6	6529733.0
2007-05-23 11:00:00	MSFT	Stock	30.6	30.74	30.57	30.71	5543417.0
2007-05-23 12:00:00	MSFT	Stock	30.7	30.79	30.65	30.77	2751035.0
2007-05-23 13:00:00	MSFT	Stock	30.77	30.79	30.73	30.77	5418075.0
2007-05-23 14:00:00	MSFT	Stock	30.77	30.83	30.69	30.78	7966224.0
2007-05-23 15:00:00	MSFT	Stock	30.79	30.81	30.58	30.58	9761010.0
2007-05-23 16:00:00	MSFT	Stock	30.58	30.58	30.58	30.58	1235108.0
2007-05-23 09:00:00	NVDA	Stock	0.5883	0.5925	0.5872	0.5898	39502320.0
2007-05-23 10:00:00	NVDA	Stock	0.5899	0.5908	0.5835	0.5838	62674440.0
2007-05-23 11:00:00	NVDA	Stock	0.5838	0.5865	0.5833	0.585	31097460.0
2007-05-23 12:00:00	NVDA	Stock	0.585	0.5853	0.5797	0.58	60640380.0
2007-05-23 13:00:00	NVDA	Stock	0.58	0.5808	0.5767	0.577	52616280.0
2007-05-23 14:00:00	NVDA	Stock	0.5772	0.5775	0.5713	0.5747	98689560.0
2007-05-23 15:00:00	NVDA	Stock	0.5745	0.5763	0.5723	0.573	83993520.0
2007-05-23 16:00:00	NVDA	Stock	0.5733	0.5733	0.5718	0.5718	1222740.0
2007-05-23 17:00:00	NVDA	Stock	0.572	0.5733	0.572	0.5733	72000.0
2007-05-23 18:00:00	NVDA	Stock	0.5738	0.5738	0.5738	0.5738	42000.0
2007-05-23 06:00:00	AMZN	Stock	3.45	3.45	3.45	3.45	2000.0
2007-05-23 07:00:00	AMZN	Stock	3.4475	3.4475	3.4475	3.4475	4000.0
2007-05-23 08:00:00	AMZN	Stock	3.4535	3.468	3.4535	3.4675	1360360.0
2007-05-23 09:00:00	AMZN	Stock	3.4675	3.495	3.446	3.4884	50401060.0
2007-05-23 10:00:00	AMZN	Stock	3.488	3.5545	3.4855	3.5435	114427980.0
2007-05-23 11:00:00	AMZN	Stock	3.543	3.5725	3.5135	3.544	94522900.0
2007-05-23 12:00:00	AMZN	Stock	3.544	3.6285	3.5375	3.625	104525960.0
2007-05-23 13:00:00	AMZN	Stock	3.625	3.6655	3.583	3.5855	142032880.0
2007-05-23 14:00:00	AMZN	Stock	3.5855	3.5885	3.5035	3.5095	155702300.0
2007-05-23 15:00:00	AMZN	Stock	3.509	3.523	3.4395	3.45	174224600.0
2007-05-23 16:00:00	AMZN	Stock	3.451	3.599	3.4465	3.452	8027640.0
2007-05-23 17:00:00	AMZN	Stock	3.4525	3.4625	3.45	3.4625	504060.0
2007-05-23 18:00:00	AMZN	Stock	3.455	3.469	3.455	3.4645	883540.0
2007-05-23 19:00:00	AMZN	Stock	3.4645	3.465	3.46	3.465	159020.0
2007-05-23 09:00:00	TLT	Stock	86.84	86.84	86.81	86.82	19000.0
2007-05-23 10:00:00	TLT	Stock	86.82	86.84	86.64	86.66	67489.0
2007-05-23 11:00:00	TLT	Stock	86.68	86.71	86.54	86.58	93300.0
2007-05-23 12:00:00	TLT	Stock	86.58	86.59	86.35	86.42	191100.0
2007-05-23 13:00:00	TLT	Stock	86.41	86.42	86.31	86.37	268100.0
2007-05-23 14:00:00	TLT	Stock	86.37	86.56	86.35	86.43	115700.0
2007-05-23 15:00:00	TLT	Stock	86.43	86.49	86.37	86.42	147775.0
2007-05-23 16:00:00	TLT	Stock	86.41	86.49	86.41	86.49	400.0
2007-05-23 09:00:00	CL	Stock	33.485	33.49	33.325	33.335	448000.0
2007-05-23 10:00:00	CL	Stock	33.325	33.56	33.145	33.17	1276930.0

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

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