PREVIEW / stock_1hour / 2006-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-07.parquet
  size:    611 KB
  rows:    29,117
  symbols: 2,304

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
2006-07-07 08:00:00	AAPL	Stock	2.0014	2.005	1.9886	1.9939	2311484.0
2006-07-07 09:00:00	AAPL	Stock	1.9936	1.9936	1.9525	1.9636	135857288.0
2006-07-07 10:00:00	AAPL	Stock	1.9634	1.9764	1.9564	1.9704	137807460.0
2006-07-07 11:00:00	AAPL	Stock	1.9704	1.9993	1.9686	1.9896	129039932.0
2006-07-07 12:00:00	AAPL	Stock	1.9904	2.0196	1.9846	2.0029	137205880.0
2006-07-07 13:00:00	AAPL	Stock	2.0029	2.0064	1.9889	2.0007	76437844.0
2006-07-07 14:00:00	AAPL	Stock	2.0007	2.0079	1.9764	1.9775	78622544.0
2006-07-07 15:00:00	AAPL	Stock	1.9768	1.9854	1.9718	1.9796	94355996.0
2006-07-07 16:00:00	AAPL	Stock	1.9786	1.9964	1.9771	1.9832	2985500.0
2006-07-07 17:00:00	AAPL	Stock	1.9832	1.9857	1.9832	1.9846	707000.0
2006-07-07 18:00:00	AAPL	Stock	1.9836	1.9857	1.9836	1.9857	25200.0
2006-07-07 08:00:00	MSFT	Stock	23.48	23.58	23.48	23.5	81138.0
2006-07-07 09:00:00	MSFT	Stock	23.49	23.55	23.35	23.52	8118342.0
2006-07-07 10:00:00	MSFT	Stock	23.51	23.52	23.4	23.42	10151433.0
2006-07-07 11:00:00	MSFT	Stock	23.42	23.5	23.38	23.422	5306264.0
2006-07-07 12:00:00	MSFT	Stock	23.42	23.49	23.41	23.42	3498814.0
2006-07-07 13:00:00	MSFT	Stock	23.42	23.45	23.38	23.45	4698563.0
2006-07-07 14:00:00	MSFT	Stock	23.44	23.47	23.36	23.39	7332001.0
2006-07-07 15:00:00	MSFT	Stock	23.39	23.45	23.3	23.31	11262751.0
2006-07-07 16:00:00	MSFT	Stock	23.31	23.39	23.29	23.32	219018.0
2006-07-07 17:00:00	MSFT	Stock	23.32	23.33	23.31	23.32	6450.0
2006-07-07 18:00:00	MSFT	Stock	23.33	23.33	23.31	23.32	800.0
2006-07-07 04:00:00	NVDA	Stock	0.3333	0.3333	0.3333	0.3333	36000.0
2006-07-07 08:00:00	NVDA	Stock	0.3333	0.3358	0.3332	0.3333	426120.0
2006-07-07 09:00:00	NVDA	Stock	0.3332	0.3362	0.3278	0.3297	71176800.0
2006-07-07 10:00:00	NVDA	Stock	0.3295	0.3308	0.3262	0.3273	92504160.0
2006-07-07 11:00:00	NVDA	Stock	0.3273	0.3285	0.3258	0.3263	66389580.0
2006-07-07 12:00:00	NVDA	Stock	0.3263	0.3292	0.326	0.3267	30061920.0
2006-07-07 13:00:00	NVDA	Stock	0.3267	0.3282	0.325	0.325	31285380.0
2006-07-07 14:00:00	NVDA	Stock	0.3252	0.326	0.3202	0.3203	89044980.0
2006-07-07 15:00:00	NVDA	Stock	0.3202	0.3233	0.3192	0.3228	136218000.0
2006-07-07 16:00:00	NVDA	Stock	0.3228	0.3228	0.3208	0.3227	957960.0
2006-07-07 17:00:00	NVDA	Stock	0.3227	0.3227	0.3227	0.3227	58500.0
2006-07-07 18:00:00	NVDA	Stock	0.3218	0.3233	0.3218	0.3233	67020.0
2006-07-07 09:00:00	AMZN	Stock	1.8375	1.8375	1.8015	1.8185	8565480.0
2006-07-07 10:00:00	AMZN	Stock	1.8185	1.8265	1.8055	1.8065	12184220.0
2006-07-07 11:00:00	AMZN	Stock	1.806	1.839	1.801	1.8305	14105480.0
2006-07-07 12:00:00	AMZN	Stock	1.831	1.864	1.828	1.85	10312060.0
2006-07-07 13:00:00	AMZN	Stock	1.8499	1.856	1.8275	1.8285	8946560.0
2006-07-07 14:00:00	AMZN	Stock	1.8285	1.83	1.807	1.8135	11041120.0
2006-07-07 15:00:00	AMZN	Stock	1.813	1.8135	1.7875	1.8055	30604540.0
2006-07-07 16:00:00	AMZN	Stock	1.8055	1.811	1.7985	1.7985	456920.0
2006-07-07 09:00:00	CL	Stock	30.38	30.59	30.38	30.52	315400.0
2006-07-07 10:00:00	CL	Stock	30.52	30.6	30.43	30.445	457800.0
2006-07-07 11:00:00	CL	Stock	30.45	30.525	30.445	30.485	428200.0
2006-07-07 12:00:00	CL	Stock	30.49	30.515	30.46	30.495	306000.0
2006-07-07 13:00:00	CL	Stock	30.49	30.525	30.46	30.51	220800.0
2006-07-07 14:00:00	CL	Stock	30.5	30.545	30.425	30.45	352200.0
2006-07-07 15:00:00	CL	Stock	30.44	30.489	30.4	30.44	534400.0
2006-07-07 16:00:00	CL	Stock	30.44	30.44	30.44	30.44	3200.0

> showing 50 of 29,117 rows — these rows as CSV

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