PREVIEW / stock_1hour / 2009-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-12.parquet
  size:    792 KB
  rows:    39,040
  symbols: 3,278

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-12 05:00:00	AAPL	Stock	3.4214	3.4214	3.4107	3.4107	5600.0
2009-02-12 07:00:00	AAPL	Stock	3.4157	3.4157	3.4146	3.4146	13720.0
2009-02-12 08:00:00	AAPL	Stock	3.4339	3.4525	3.4214	3.4479	1106280.0
2009-02-12 09:00:00	AAPL	Stock	3.4471	3.4961	3.4204	3.4861	106545852.0
2009-02-12 10:00:00	AAPL	Stock	3.4854	3.5193	3.4429	3.5046	148682184.0
2009-02-12 11:00:00	AAPL	Stock	3.5043	3.5318	3.4918	3.5171	100187976.0
2009-02-12 12:00:00	AAPL	Stock	3.5168	3.5507	3.5143	3.5264	66182424.0
2009-02-12 13:00:00	AAPL	Stock	3.5264	3.5271	3.4761	3.5075	92115632.0
2009-02-12 14:00:00	AAPL	Stock	3.5081	3.51	3.4518	3.4664	97194496.0
2009-02-12 15:00:00	AAPL	Stock	3.4664	3.5625	3.4529	3.5475	180398064.0
2009-02-12 16:00:00	AAPL	Stock	3.5457	3.5546	3.498	3.5443	8826272.0
2009-02-12 17:00:00	AAPL	Stock	3.5475	3.5536	3.5443	3.55	233548.0
2009-02-12 18:00:00	AAPL	Stock	3.55	3.55	3.5446	3.5446	9852164.0
2009-02-12 19:00:00	AAPL	Stock	3.5432	3.5443	3.5429	3.5439	32200.0
2009-02-12 07:00:00	MSFT	Stock	18.89	19.08	18.88	19.08	4600.0
2009-02-12 08:00:00	MSFT	Stock	19.09	19.21	19.04	19.18	17422.0
2009-02-12 09:00:00	MSFT	Stock	19.19	19.19	18.71	18.778	6800393.0
2009-02-12 10:00:00	MSFT	Stock	18.78	18.87	18.63	18.75	10956816.0
2009-02-12 11:00:00	MSFT	Stock	18.75	19.04	18.68	18.93	10557063.0
2009-02-12 12:00:00	MSFT	Stock	18.93	19.16	18.91	18.95	4629767.0
2009-02-12 13:00:00	MSFT	Stock	18.96	18.96	18.77	18.913	5658427.0
2009-02-12 14:00:00	MSFT	Stock	18.91	18.96	18.6	18.66	7288944.0
2009-02-12 15:00:00	MSFT	Stock	18.657	19.32	18.54	19.32	21794101.0
2009-02-12 16:00:00	MSFT	Stock	19.29	19.32	18.844	19.26	6871984.0
2009-02-12 17:00:00	MSFT	Stock	19.26	19.28	19.2	19.2	18618.0
2009-02-12 18:00:00	MSFT	Stock	19.2	19.24	19.1	19.15	7482.0
2009-02-12 19:00:00	MSFT	Stock	19.23	19.24	19.14	19.17	5418.0
2009-02-12 20:00:00	MSFT	Stock	18.7	18.7	18.7	18.7	17700.0
2009-02-12 08:00:00	NVDA	Stock	0.2035	0.2035	0.2025	0.2025	24000.0
2009-02-12 09:00:00	NVDA	Stock	0.2	0.2018	0.1965	0.1995	84847520.0
2009-02-12 10:00:00	NVDA	Stock	0.1995	0.2055	0.1978	0.2047	186812520.0
2009-02-12 11:00:00	NVDA	Stock	0.2047	0.2072	0.2038	0.2053	229095920.0
2009-02-12 12:00:00	NVDA	Stock	0.2053	0.2072	0.205	0.205	79980320.0
2009-02-12 13:00:00	NVDA	Stock	0.205	0.2055	0.202	0.2053	64366920.0
2009-02-12 14:00:00	NVDA	Stock	0.2053	0.2072	0.202	0.2025	81477360.0
2009-02-12 15:00:00	NVDA	Stock	0.2025	0.2092	0.2	0.208	266850040.0
2009-02-12 16:00:00	NVDA	Stock	0.208	0.2088	0.2005	0.208	13379600.0
2009-02-12 17:00:00	NVDA	Stock	0.208	0.208	0.2075	0.2075	36000.0
2009-02-12 19:00:00	NVDA	Stock	0.204	0.207	0.204	0.207	8000.0
2009-02-12 08:00:00	AMZN	Stock	3.1925	3.212	3.19	3.19	37500.0
2009-02-12 09:00:00	AMZN	Stock	3.1975	3.2	3.125	3.132	17560480.0
2009-02-12 10:00:00	AMZN	Stock	3.134	3.152	3.115	3.1385	21158160.0
2009-02-12 11:00:00	AMZN	Stock	3.1385	3.1965	3.124	3.1713	13853340.0
2009-02-12 12:00:00	AMZN	Stock	3.1702	3.2125	3.17	3.183	9862300.0
2009-02-12 13:00:00	AMZN	Stock	3.183	3.1906	3.1305	3.1625	18615600.0
2009-02-12 14:00:00	AMZN	Stock	3.1625	3.163	3.089	3.1068	25200840.0
2009-02-12 15:00:00	AMZN	Stock	3.106	3.209	3.0855	3.1965	50024980.0
2009-02-12 16:00:00	AMZN	Stock	3.197	3.198	3.1485	3.198	2770960.0
2009-02-12 17:00:00	AMZN	Stock	3.195	3.2	3.19	3.2	53700.0
2009-02-12 18:00:00	AMZN	Stock	3.191	3.2	3.191	3.1975	44000.0

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

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