PREVIEW / stock_1hour / 2006-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-14.parquet
  size:    589 KB
  rows:    28,410
  symbols: 2,345

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-08-14 05:00:00	AAPL	Stock	2.2811	2.2811	2.2811	2.2811	2800.0
2006-08-14 08:00:00	AAPL	Stock	2.2786	2.2946	2.2714	2.2857	2119488.0
2006-08-14 09:00:00	AAPL	Stock	2.2857	2.305	2.275	2.2857	121894276.0
2006-08-14 10:00:00	AAPL	Stock	2.2857	2.2893	2.2714	2.288	104522880.0
2006-08-14 11:00:00	AAPL	Stock	2.2879	2.3096	2.2864	2.3085	136228596.0
2006-08-14 12:00:00	AAPL	Stock	2.3086	2.3293	2.3082	2.3168	98291760.0
2006-08-14 13:00:00	AAPL	Stock	2.3171	2.3204	2.3071	2.3096	43048572.0
2006-08-14 14:00:00	AAPL	Stock	2.3096	2.3143	2.2982	2.3036	82654292.0
2006-08-14 15:00:00	AAPL	Stock	2.3036	2.3036	2.2804	2.2804	122238816.0
2006-08-14 16:00:00	AAPL	Stock	2.2825	2.2857	2.28	2.2846	1007608.0
2006-08-14 17:00:00	AAPL	Stock	2.2854	2.2854	2.2832	2.2832	159740.0
2006-08-14 18:00:00	AAPL	Stock	2.2832	2.285	2.2832	2.285	42420.0
2006-08-14 07:00:00	MSFT	Stock	24.54	24.58	24.54	24.54	3000.0
2006-08-14 08:00:00	MSFT	Stock	24.5	24.56	24.43	24.56	757800.0
2006-08-14 09:00:00	MSFT	Stock	24.55	24.57	24.4	24.43	5103495.0
2006-08-14 10:00:00	MSFT	Stock	24.43	24.52	24.35	24.42	6775335.0
2006-08-14 11:00:00	MSFT	Stock	24.41	24.5	24.38	24.48	7121035.0
2006-08-14 12:00:00	MSFT	Stock	24.49	24.57	24.46	24.57	5640913.0
2006-08-14 13:00:00	MSFT	Stock	24.57	24.59	24.52	24.54	3351259.0
2006-08-14 14:00:00	MSFT	Stock	24.54	24.6	24.49	24.512	6168274.0
2006-08-14 15:00:00	MSFT	Stock	24.52	24.55	24.48	24.52	9132973.0
2006-08-14 16:00:00	MSFT	Stock	24.52	24.53	24.49	24.5	840149.0
2006-08-14 17:00:00	MSFT	Stock	24.5	24.53	24.49	24.49	728030.0
2006-08-14 08:00:00	NVDA	Stock	0.3975	0.3988	0.3948	0.395	592200.0
2006-08-14 09:00:00	NVDA	Stock	0.395	0.3967	0.3877	0.3888	99697620.0
2006-08-14 10:00:00	NVDA	Stock	0.3887	0.3955	0.3862	0.389	102997860.0
2006-08-14 11:00:00	NVDA	Stock	0.389	0.3988	0.3888	0.3984	143396760.0
2006-08-14 12:00:00	NVDA	Stock	0.3982	0.3987	0.3955	0.3958	52807560.0
2006-08-14 13:00:00	NVDA	Stock	0.3957	0.396	0.3917	0.392	65644980.0
2006-08-14 14:00:00	NVDA	Stock	0.3918	0.395	0.3873	0.3885	116250240.0
2006-08-14 15:00:00	NVDA	Stock	0.3883	0.395	0.3858	0.388	156550080.0
2006-08-14 16:00:00	NVDA	Stock	0.3883	0.3888	0.388	0.388	2302860.0
2006-08-14 17:00:00	NVDA	Stock	0.3882	0.3882	0.388	0.388	36000.0
2006-08-14 09:00:00	AMZN	Stock	1.3075	1.3215	1.3075	1.3205	9068980.0
2006-08-14 10:00:00	AMZN	Stock	1.32	1.337	1.319	1.336	13693000.0
2006-08-14 11:00:00	AMZN	Stock	1.336	1.3505	1.332	1.3485	16242580.0
2006-08-14 12:00:00	AMZN	Stock	1.3485	1.353	1.347	1.348	12874260.0
2006-08-14 13:00:00	AMZN	Stock	1.3475	1.35	1.3325	1.3355	10256880.0
2006-08-14 14:00:00	AMZN	Stock	1.335	1.343	1.324	1.3325	14154000.0
2006-08-14 15:00:00	AMZN	Stock	1.3325	1.336	1.3255	1.3275	24552660.0
2006-08-14 16:00:00	AMZN	Stock	1.3285	1.3295	1.326	1.3265	118140.0
2006-08-14 09:00:00	CL	Stock	30.025	30.09	29.95	30.04	311200.0
2006-08-14 10:00:00	CL	Stock	30.035	30.08	29.875	29.885	356800.0
2006-08-14 11:00:00	CL	Stock	29.89	30.05	29.875	29.88	371800.0
2006-08-14 12:00:00	CL	Stock	29.905	29.95	29.875	29.875	228800.0
2006-08-14 13:00:00	CL	Stock	29.875	29.93	29.87	29.91	332600.0
2006-08-14 14:00:00	CL	Stock	29.915	29.935	29.855	29.865	430400.0
2006-08-14 15:00:00	CL	Stock	29.8735	29.895	29.79	29.855	557400.0

> showing 48 of 28,410 rows — these rows as CSV

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