PREVIEW / stock_1hour / 2008-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-10.parquet
  size:    795 KB
  rows:    40,032
  symbols: 3,282

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-04-10 05:00:00	AAPL	Stock	5.4086	5.4104	5.4086	5.4104	14420.0
2008-04-10 07:00:00	AAPL	Stock	5.4057	5.4296	5.3939	5.4264	92400.0
2008-04-10 08:00:00	AAPL	Stock	5.42	5.42	5.3768	5.3979	2706564.0
2008-04-10 09:00:00	AAPL	Stock	5.3989	5.4518	5.3786	5.4436	120427244.0
2008-04-10 10:00:00	AAPL	Stock	5.4436	5.5164	5.4164	5.505	200424364.0
2008-04-10 11:00:00	AAPL	Stock	5.5046	5.54	5.4968	5.5182	128942212.0
2008-04-10 12:00:00	AAPL	Stock	5.5186	5.5339	5.5079	5.5139	68826296.0
2008-04-10 13:00:00	AAPL	Stock	5.514	5.5507	5.5107	5.5321	101301956.0
2008-04-10 14:00:00	AAPL	Stock	5.5318	5.5439	5.5118	5.5375	121721096.0
2008-04-10 15:00:00	AAPL	Stock	5.5378	5.5425	5.4929	5.5196	172912488.0
2008-04-10 16:00:00	AAPL	Stock	5.5179	5.525	5.5	5.5243	31851456.0
2008-04-10 17:00:00	AAPL	Stock	5.5233	5.5282	5.5196	5.5264	983584.0
2008-04-10 18:00:00	AAPL	Stock	5.5268	5.53	5.5196	5.5282	368088.0
2008-04-10 19:00:00	AAPL	Stock	5.5282	5.5296	5.5271	5.5296	360360.0
2008-04-10 07:00:00	MSFT	Stock	29.12	29.12	29.0	29.0	22385.0
2008-04-10 08:00:00	MSFT	Stock	29.08	29.08	28.88	28.9	165761.0
2008-04-10 09:00:00	MSFT	Stock	28.9	29.11	28.8	28.94	7007675.0
2008-04-10 10:00:00	MSFT	Stock	28.94	29.34	28.87	29.31	10827228.0
2008-04-10 11:00:00	MSFT	Stock	29.31	29.4	29.26	29.33	5840083.0
2008-04-10 12:00:00	MSFT	Stock	29.33	29.38	29.15	29.19	6649482.0
2008-04-10 13:00:00	MSFT	Stock	29.19	29.29	29.13	29.14	5501133.0
2008-04-10 14:00:00	MSFT	Stock	29.13	29.3	29.07	29.21	7607030.0
2008-04-10 15:00:00	MSFT	Stock	29.2	29.24	28.95	29.1	12942313.0
2008-04-10 16:00:00	MSFT	Stock	29.1	29.285	29.05	29.15	7479048.0
2008-04-10 17:00:00	MSFT	Stock	29.15	29.21	29.11	29.14	80600.0
2008-04-10 18:00:00	MSFT	Stock	29.15	29.17	29.15	29.17	1411.0
2008-04-10 19:00:00	MSFT	Stock	29.15	29.15	29.14	29.14	2977.0
2008-04-10 08:00:00	NVDA	Stock	0.4885	0.493	0.483	0.483	208000.0
2008-04-10 09:00:00	NVDA	Stock	0.4883	0.5013	0.4875	0.488	87202880.0
2008-04-10 10:00:00	NVDA	Stock	0.488	0.4952	0.4822	0.494	122266440.0
2008-04-10 11:00:00	NVDA	Stock	0.4938	0.501	0.4912	0.5003	121066240.0
2008-04-10 12:00:00	NVDA	Stock	0.5003	0.5013	0.4965	0.499	79578200.0
2008-04-10 13:00:00	NVDA	Stock	0.4992	0.5128	0.4985	0.505	202159680.0
2008-04-10 14:00:00	NVDA	Stock	0.505	0.506	0.4992	0.5028	208709480.0
2008-04-10 15:00:00	NVDA	Stock	0.5025	0.503	0.4948	0.4968	244872840.0
2008-04-10 16:00:00	NVDA	Stock	0.4965	0.4992	0.4963	0.497	8897520.0
2008-04-10 17:00:00	NVDA	Stock	0.4975	0.5013	0.497	0.5013	505400.0
2008-04-10 18:00:00	NVDA	Stock	0.4965	0.4992	0.4965	0.499	4026400.0
2008-04-10 19:00:00	NVDA	Stock	0.498	0.4985	0.4978	0.4978	60120.0
2008-04-10 08:00:00	AMZN	Stock	3.72	3.7245	3.72	3.7245	4000.0
2008-04-10 09:00:00	AMZN	Stock	3.7235	3.725	3.6365	3.655	21969500.0
2008-04-10 10:00:00	AMZN	Stock	3.6535	3.742	3.645	3.736	28157240.0
2008-04-10 11:00:00	AMZN	Stock	3.736	3.7745	3.7225	3.7535	15927760.0
2008-04-10 12:00:00	AMZN	Stock	3.754	3.765	3.7265	3.737	9541680.0
2008-04-10 13:00:00	AMZN	Stock	3.737	3.757	3.734	3.736	10956300.0
2008-04-10 14:00:00	AMZN	Stock	3.736	3.7395	3.704	3.73	12077480.0
2008-04-10 15:00:00	AMZN	Stock	3.73	3.744	3.717	3.74	21560240.0
2008-04-10 16:00:00	AMZN	Stock	3.7355	3.755	3.7162	3.755	1865100.0
2008-04-10 17:00:00	AMZN	Stock	3.7415	3.755	3.7415	3.755	57860.0
2008-04-10 18:00:00	AMZN	Stock	3.7505	3.7505	3.75	3.75	12000.0

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

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