PREVIEW / stock_1hour / 2008-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-12.parquet
  size:    796 KB
  rows:    39,963
  symbols: 3,268

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-03-12 05:00:00	AAPL	Stock	4.5593	4.5593	4.5593	4.5593	8400.0
2008-03-12 06:00:00	AAPL	Stock	4.5739	4.5775	4.5689	4.5689	22400.0
2008-03-12 07:00:00	AAPL	Stock	4.5593	4.5625	4.54	4.5496	361508.0
2008-03-12 08:00:00	AAPL	Stock	4.5464	4.5482	4.5125	4.5218	3086440.0
2008-03-12 09:00:00	AAPL	Stock	4.5214	4.5496	4.4879	4.4993	129608080.0
2008-03-12 10:00:00	AAPL	Stock	4.4982	4.5782	4.475	4.5625	220256176.0
2008-03-12 11:00:00	AAPL	Stock	4.5629	4.5957	4.5286	4.5482	168141204.0
2008-03-12 12:00:00	AAPL	Stock	4.5469	4.5654	4.525	4.535	97565496.0
2008-03-12 13:00:00	AAPL	Stock	4.535	4.5407	4.5132	4.5254	98252112.0
2008-03-12 14:00:00	AAPL	Stock	4.5254	4.5696	4.5146	4.5571	121841944.0
2008-03-12 15:00:00	AAPL	Stock	4.5568	4.575	4.4704	4.5028	208257644.0
2008-03-12 16:00:00	AAPL	Stock	4.5011	4.5468	4.4929	4.5	11764368.0
2008-03-12 17:00:00	AAPL	Stock	4.5	4.5	4.4936	4.4936	88004.0
2008-03-12 18:00:00	AAPL	Stock	4.4961	4.4979	4.4875	4.4893	108976.0
2008-03-12 19:00:00	AAPL	Stock	4.4829	4.4889	4.4768	4.4889	399896.0
2008-03-12 07:00:00	MSFT	Stock	29.33	29.46	29.33	29.46	200.0
2008-03-12 08:00:00	MSFT	Stock	29.35	29.37	29.14	29.23	29042.0
2008-03-12 09:00:00	MSFT	Stock	29.25	29.49	29.13	29.17	7573457.0
2008-03-12 10:00:00	MSFT	Stock	29.16	29.45	28.93	29.27	12049728.0
2008-03-12 11:00:00	MSFT	Stock	29.26	29.45	29.06	29.15	11623761.0
2008-03-12 12:00:00	MSFT	Stock	29.15	29.33	29.1	29.202	6678888.0
2008-03-12 13:00:00	MSFT	Stock	29.2	29.28	29.1	29.11	4836713.0
2008-03-12 14:00:00	MSFT	Stock	29.11	29.13	28.93	29.041	8608596.0
2008-03-12 15:00:00	MSFT	Stock	29.04	29.04	28.54	28.6	19835981.0
2008-03-12 16:00:00	MSFT	Stock	28.6	29.3	28.6	28.63	4323294.0
2008-03-12 17:00:00	MSFT	Stock	29.063	29.063	28.62	28.7	328735.0
2008-03-12 18:00:00	MSFT	Stock	28.7	29.05	28.68	28.7	104364.0
2008-03-12 19:00:00	MSFT	Stock	28.68	28.68	28.63	28.64	1040.0
2008-03-12 08:00:00	NVDA	Stock	0.477	0.4775	0.4725	0.4763	182720.0
2008-03-12 09:00:00	NVDA	Stock	0.475	0.4848	0.469	0.4765	60089840.0
2008-03-12 10:00:00	NVDA	Stock	0.4768	0.4788	0.4723	0.473	98284120.0
2008-03-12 11:00:00	NVDA	Stock	0.473	0.4782	0.4705	0.472	79968840.0
2008-03-12 12:00:00	NVDA	Stock	0.472	0.4748	0.4695	0.471	72827440.0
2008-03-12 13:00:00	NVDA	Stock	0.471	0.4728	0.4662	0.4698	110427680.0
2008-03-12 14:00:00	NVDA	Stock	0.4698	0.472	0.466	0.47	87227240.0
2008-03-12 15:00:00	NVDA	Stock	0.47	0.471	0.459	0.4618	183143200.0
2008-03-12 16:00:00	NVDA	Stock	0.463	0.4703	0.4605	0.463	4185360.0
2008-03-12 17:00:00	NVDA	Stock	0.468	0.468	0.46	0.4608	36929760.0
2008-03-12 18:00:00	NVDA	Stock	0.4612	0.464	0.4612	0.4638	80600.0
2008-03-12 19:00:00	NVDA	Stock	0.4638	0.464	0.4638	0.464	40000.0
2008-03-12 08:00:00	AMZN	Stock	3.35	3.35	3.33	3.33	14000.0
2008-03-12 09:00:00	AMZN	Stock	3.3385	3.3545	3.3045	3.31	15702160.0
2008-03-12 10:00:00	AMZN	Stock	3.3095	3.3725	3.282	3.3405	32572420.0
2008-03-12 11:00:00	AMZN	Stock	3.3415	3.4115	3.34	3.3665	32102700.0
2008-03-12 12:00:00	AMZN	Stock	3.3665	3.3925	3.361	3.366	14607880.0
2008-03-12 13:00:00	AMZN	Stock	3.366	3.394	3.3585	3.3685	12999000.0
2008-03-12 14:00:00	AMZN	Stock	3.3685	3.389	3.343	3.368	16688360.0
2008-03-12 15:00:00	AMZN	Stock	3.3665	3.3835	3.3185	3.3235	26451580.0
2008-03-12 16:00:00	AMZN	Stock	3.3245	3.3574	3.3165	3.3205	1675920.0
2008-03-12 17:00:00	AMZN	Stock	3.322	3.322	3.32	3.3205	23000.0

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

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