PREVIEW / stock_1hour / 2008-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-22.parquet
  size:    824 KB
  rows:    40,647
  symbols: 3,376

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
2008-12-22 06:00:00	AAPL	Stock	3.2143	3.2143	3.2143	3.2143	7000.0
2008-12-22 07:00:00	AAPL	Stock	3.2321	3.2393	3.2175	3.2393	49280.0
2008-12-22 08:00:00	AAPL	Stock	3.2232	3.2314	3.2179	3.2214	1567720.0
2008-12-22 09:00:00	AAPL	Stock	3.2229	3.2229	3.1161	3.1204	109904032.0
2008-12-22 10:00:00	AAPL	Stock	3.1206	3.125	3.0804	3.1196	156011212.0
2008-12-22 11:00:00	AAPL	Stock	3.1196	3.1232	3.0493	3.0736	112174944.0
2008-12-22 12:00:00	AAPL	Stock	3.0732	3.0984	3.0536	3.0683	63154756.0
2008-12-22 13:00:00	AAPL	Stock	3.0683	3.075	3.0439	3.0502	72390808.0
2008-12-22 14:00:00	AAPL	Stock	3.05	3.0636	3.0357	3.0368	98221200.0
2008-12-22 15:00:00	AAPL	Stock	3.0368	3.1179	3.0246	3.0632	193662336.0
2008-12-22 16:00:00	AAPL	Stock	3.0632	3.0801	3.0516	3.0679	29595216.0
2008-12-22 17:00:00	AAPL	Stock	3.0671	3.075	3.0607	3.0625	447188.0
2008-12-22 18:00:00	AAPL	Stock	3.0661	3.0714	3.0646	3.07	205268.0
2008-12-22 19:00:00	AAPL	Stock	3.0714	3.0739	3.07	3.0739	170744.0
2008-12-22 04:00:00	MSFT	Stock	19.24	19.24	19.24	19.24	150.0
2008-12-22 05:00:00	MSFT	Stock	19.25	19.25	19.25	19.25	150.0
2008-12-22 07:00:00	MSFT	Stock	19.25	19.25	19.25	19.25	100.0
2008-12-22 08:00:00	MSFT	Stock	19.2	19.26	19.2	19.22	29507.0
2008-12-22 09:00:00	MSFT	Stock	19.2	19.29	18.91	19.08	6129751.0
2008-12-22 10:00:00	MSFT	Stock	19.07	19.27	19.01	19.23	7464174.0
2008-12-22 11:00:00	MSFT	Stock	19.23	19.25	19.09	19.25	6576469.0
2008-12-22 12:00:00	MSFT	Stock	19.24	19.25	19.07	19.099	4877136.0
2008-12-22 13:00:00	MSFT	Stock	19.099	19.18	19.01	19.045	7442118.0
2008-12-22 14:00:00	MSFT	Stock	19.04	19.1	18.9	18.97	7267714.0
2008-12-22 15:00:00	MSFT	Stock	18.97	19.24	18.89	19.2	13288225.0
2008-12-22 16:00:00	MSFT	Stock	19.2	19.24	18.91	19.17	4394622.0
2008-12-22 17:00:00	MSFT	Stock	19.17	19.2	19.17	19.2	15600.0
2008-12-22 18:00:00	MSFT	Stock	19.2	19.2	19.17	19.17	699.0
2008-12-22 19:00:00	MSFT	Stock	19.18	19.22	19.18	19.18	1750.0
2008-12-22 08:00:00	NVDA	Stock	0.2138	0.216	0.2115	0.216	48000.0
2008-12-22 09:00:00	NVDA	Stock	0.2163	0.2168	0.2047	0.205	46519520.0
2008-12-22 10:00:00	NVDA	Stock	0.205	0.2053	0.199	0.203	77438960.0
2008-12-22 11:00:00	NVDA	Stock	0.203	0.203	0.1972	0.1986	41312560.0
2008-12-22 12:00:00	NVDA	Stock	0.1985	0.1998	0.1955	0.197	68794200.0
2008-12-22 13:00:00	NVDA	Stock	0.1968	0.1982	0.195	0.1958	42873600.0
2008-12-22 14:00:00	NVDA	Stock	0.1955	0.1968	0.193	0.1938	51096000.0
2008-12-22 15:00:00	NVDA	Stock	0.194	0.201	0.1928	0.2007	171068160.0
2008-12-22 16:00:00	NVDA	Stock	0.2002	0.2033	0.1988	0.2007	6740640.0
2008-12-22 17:00:00	NVDA	Stock	0.1988	0.1988	0.1988	0.1988	4000.0
2008-12-22 08:00:00	AMZN	Stock	2.5595	2.5715	2.5595	2.571	7000.0
2008-12-22 09:00:00	AMZN	Stock	2.5755	2.6075	2.516	2.5982	31267820.0
2008-12-22 10:00:00	AMZN	Stock	2.5985	2.5985	2.545	2.5505	25431000.0
2008-12-22 11:00:00	AMZN	Stock	2.5505	2.5575	2.501	2.5025	15834460.0
2008-12-22 12:00:00	AMZN	Stock	2.502	2.5425	2.488	2.5385	18372440.0
2008-12-22 13:00:00	AMZN	Stock	2.538	2.567	2.5285	2.534	13916860.0
2008-12-22 14:00:00	AMZN	Stock	2.534	2.5445	2.478	2.481	15821120.0
2008-12-22 15:00:00	AMZN	Stock	2.4805	2.5115	2.4235	2.495	52261640.0
2008-12-22 16:00:00	AMZN	Stock	2.492	2.4925	2.47	2.4925	405960.0
2008-12-22 17:00:00	AMZN	Stock	2.4925	2.499	2.4925	2.499	27360.0
2008-12-22 18:00:00	AMZN	Stock	2.495	2.5	2.495	2.5	24000.0

> showing 50 of 40,647 rows — these rows as CSV

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