PREVIEW / stock_1hour / 2009-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-04.parquet
  size:    799 KB
  rows:    39,332
  symbols: 3,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
2009-02-04 06:00:00	AAPL	Stock	3.2968	3.3054	3.2743	3.2743	30800.0
2009-02-04 07:00:00	AAPL	Stock	3.3143	3.3143	3.3036	3.3036	35560.0
2009-02-04 08:00:00	AAPL	Stock	3.3089	3.3304	3.3036	3.3286	691740.0
2009-02-04 09:00:00	AAPL	Stock	3.3293	3.3907	3.3207	3.3864	93304764.0
2009-02-04 10:00:00	AAPL	Stock	3.3864	3.4279	3.3864	3.4207	149199764.0
2009-02-04 11:00:00	AAPL	Stock	3.4207	3.4348	3.4143	3.4246	104733160.0
2009-02-04 12:00:00	AAPL	Stock	3.4254	3.4375	3.4161	3.42	86087568.0
2009-02-04 13:00:00	AAPL	Stock	3.4204	3.4204	3.3607	3.3761	117288360.0
2009-02-04 14:00:00	AAPL	Stock	3.3757	3.3829	3.3404	3.3725	100275700.0
2009-02-04 15:00:00	AAPL	Stock	3.3729	3.3807	3.3393	3.3418	129477096.0
2009-02-04 16:00:00	AAPL	Stock	3.34	3.3912	3.3382	3.3393	7990444.0
2009-02-04 17:00:00	AAPL	Stock	3.3332	3.3375	3.2982	3.3071	1627752.0
2009-02-04 18:00:00	AAPL	Stock	3.3071	3.3411	3.3036	3.3057	4019904.0
2009-02-04 19:00:00	AAPL	Stock	3.3071	3.315	3.3071	3.3121	44240.0
2009-02-04 07:00:00	MSFT	Stock	18.41	18.62	18.38	18.51	3500.0
2009-02-04 08:00:00	MSFT	Stock	18.51	18.61	18.5	18.51	29201.0
2009-02-04 09:00:00	MSFT	Stock	18.51	18.8	18.43	18.79	6630946.0
2009-02-04 10:00:00	MSFT	Stock	18.79	18.97	18.72	18.79	15903684.0
2009-02-04 11:00:00	MSFT	Stock	18.79	18.94	18.74	18.94	8643352.0
2009-02-04 12:00:00	MSFT	Stock	18.94	19.0	18.81	18.85	7077407.0
2009-02-04 13:00:00	MSFT	Stock	18.85	18.88	18.61	18.74	10444627.0
2009-02-04 14:00:00	MSFT	Stock	18.73	18.82	18.55	18.79	9794523.0
2009-02-04 15:00:00	MSFT	Stock	18.78	18.84	18.64	18.64	12780965.0
2009-02-04 16:00:00	MSFT	Stock	18.64	18.873	18.586	18.6	2138405.0
2009-02-04 17:00:00	MSFT	Stock	18.56	18.8	18.31	18.37	58318.0
2009-02-04 18:00:00	MSFT	Stock	18.36	18.49	18.32	18.44	20800.0
2009-02-04 19:00:00	MSFT	Stock	18.44	18.46	18.44	18.45	4605.0
2009-02-04 09:00:00	NVDA	Stock	0.212	0.2238	0.212	0.2232	119625280.0
2009-02-04 10:00:00	NVDA	Stock	0.2235	0.2283	0.2232	0.228	153216040.0
2009-02-04 11:00:00	NVDA	Stock	0.2278	0.2288	0.2245	0.2258	149130360.0
2009-02-04 12:00:00	NVDA	Stock	0.226	0.2275	0.2225	0.2228	56214960.0
2009-02-04 13:00:00	NVDA	Stock	0.2228	0.2238	0.2172	0.2188	63954800.0
2009-02-04 14:00:00	NVDA	Stock	0.2188	0.2203	0.2163	0.2198	94068480.0
2009-02-04 15:00:00	NVDA	Stock	0.2198	0.2208	0.2175	0.2175	122526440.0
2009-02-04 16:00:00	NVDA	Stock	0.2185	0.2227	0.217	0.2185	4116920.0
2009-02-04 17:00:00	NVDA	Stock	0.2168	0.2168	0.213	0.2135	232000.0
2009-02-04 18:00:00	NVDA	Stock	0.215	0.215	0.2132	0.2132	88000.0
2009-02-04 19:00:00	NVDA	Stock	0.2132	0.2132	0.213	0.213	120000.0
2009-02-04 06:00:00	AMZN	Stock	3.1605	3.1605	3.1605	3.1605	2000.0
2009-02-04 08:00:00	AMZN	Stock	3.171	3.171	3.158	3.17	191540.0
2009-02-04 09:00:00	AMZN	Stock	3.17	3.1795	3.1125	3.1425	35265780.0
2009-02-04 10:00:00	AMZN	Stock	3.1425	3.1585	3.109	3.111	53891920.0
2009-02-04 11:00:00	AMZN	Stock	3.1112	3.1185	3.0825	3.0935	38471320.0
2009-02-04 12:00:00	AMZN	Stock	3.0935	3.1025	3.066	3.076	22257600.0
2009-02-04 13:00:00	AMZN	Stock	3.0765	3.1192	3.048	3.064	30010260.0
2009-02-04 14:00:00	AMZN	Stock	3.064	3.074	3.0415	3.0728	28073960.0
2009-02-04 15:00:00	AMZN	Stock	3.0725	3.086	3.05	3.053	44089540.0
2009-02-04 16:00:00	AMZN	Stock	3.053	3.1	3.051	3.0725	20347820.0
2009-02-04 17:00:00	AMZN	Stock	3.0625	3.0675	3.04	3.0545	247000.0
2009-02-04 18:00:00	AMZN	Stock	3.05	3.05	3.035	3.035	70540.0

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

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