PREVIEW / stock_1hour / 2007-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-13.parquet
  size:    741 KB
  rows:    36,883
  symbols: 3,092

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
2007-09-13 09:00:00	AAPL	Stock	4.9582	4.9643	4.9189	4.9504	103432840.0
2007-09-13 10:00:00	AAPL	Stock	4.9511	4.9543	4.9043	4.9167	127007384.0
2007-09-13 11:00:00	AAPL	Stock	4.9168	4.9384	4.9129	4.9193	64202012.0
2007-09-13 12:00:00	AAPL	Stock	4.9193	4.9268	4.9054	4.9132	43593732.0
2007-09-13 13:00:00	AAPL	Stock	4.9129	4.9246	4.8893	4.8956	68921440.0
2007-09-13 14:00:00	AAPL	Stock	4.8954	4.91	4.8825	4.8996	71533812.0
2007-09-13 15:00:00	AAPL	Stock	4.8996	4.9076	4.8804	4.9007	92960196.0
2007-09-13 16:00:00	AAPL	Stock	4.904	4.904	4.8996	4.9	9367960.0
2007-09-13 09:00:00	MSFT	Stock	29.12	29.12	28.98	29.01	3007806.0
2007-09-13 10:00:00	MSFT	Stock	29.01	29.1	28.96	29.09	3146815.0
2007-09-13 11:00:00	MSFT	Stock	29.097	29.14	29.03	29.08	2840275.0
2007-09-13 12:00:00	MSFT	Stock	29.09	29.14	29.06	29.09	2003410.0
2007-09-13 13:00:00	MSFT	Stock	29.09	29.13	29.05	29.08	2784156.0
2007-09-13 14:00:00	MSFT	Stock	29.09	29.18	29.08	29.15	3320846.0
2007-09-13 15:00:00	MSFT	Stock	29.16	29.26	29.11	29.15	8574140.0
2007-09-13 16:00:00	MSFT	Stock	29.16	29.16	29.16	29.16	1586607.0
2007-09-13 08:00:00	NVDA	Stock	0.8358	0.8425	0.8358	0.8425	132600.0
2007-09-13 09:00:00	NVDA	Stock	0.8425	0.8908	0.826	0.836	70235840.0
2007-09-13 10:00:00	NVDA	Stock	0.8358	0.8385	0.827	0.83	61783560.0
2007-09-13 11:00:00	NVDA	Stock	0.8302	0.8322	0.8262	0.8317	53357520.0
2007-09-13 12:00:00	NVDA	Stock	0.8315	0.8322	0.8285	0.8305	41336840.0
2007-09-13 13:00:00	NVDA	Stock	0.8305	0.8338	0.8298	0.8335	38189880.0
2007-09-13 14:00:00	NVDA	Stock	0.8335	0.8368	0.8308	0.8349	42904480.0
2007-09-13 15:00:00	NVDA	Stock	0.8348	0.836	0.8248	0.8305	76876360.0
2007-09-13 16:00:00	NVDA	Stock	0.8305	0.8308	0.8275	0.8298	18938040.0
2007-09-13 17:00:00	NVDA	Stock	0.8278	0.8298	0.8275	0.8298	136000.0
2007-09-13 18:00:00	NVDA	Stock	0.83	0.83	0.83	0.83	24000.0
2007-09-13 19:00:00	NVDA	Stock	0.8298	0.8298	0.8298	0.8298	4000.0
2007-09-13 05:00:00	AMZN	Stock	4.365	4.365	4.365	4.365	4200.0
2007-09-13 06:00:00	AMZN	Stock	4.37	4.39	4.37	4.385	13800.0
2007-09-13 07:00:00	AMZN	Stock	4.3755	4.3755	4.3375	4.345	70000.0
2007-09-13 08:00:00	AMZN	Stock	4.3425	4.379	4.3405	4.3775	812260.0
2007-09-13 09:00:00	AMZN	Stock	4.3775	4.4	4.325	4.343	17685700.0
2007-09-13 10:00:00	AMZN	Stock	4.3435	4.3725	4.3335	4.3615	15939840.0
2007-09-13 11:00:00	AMZN	Stock	4.3615	4.397	4.358	4.3838	12619820.0
2007-09-13 12:00:00	AMZN	Stock	4.3845	4.4035	4.3715	4.3845	12635140.0
2007-09-13 13:00:00	AMZN	Stock	4.3845	4.392	4.366	4.3665	10290800.0
2007-09-13 14:00:00	AMZN	Stock	4.3675	4.374	4.345	4.35	16285480.0
2007-09-13 15:00:00	AMZN	Stock	4.35	4.365	4.3405	4.363	26358500.0
2007-09-13 16:00:00	AMZN	Stock	4.363	4.37	4.3585	4.37	2853740.0
2007-09-13 17:00:00	AMZN	Stock	4.3695	4.37	4.361	4.3625	74380.0
2007-09-13 18:00:00	AMZN	Stock	4.361	4.361	4.359	4.359	15800.0
2007-09-13 09:00:00	TLT	Stock	90.3	90.33	90.16	90.23	87700.0
2007-09-13 10:00:00	TLT	Stock	90.23	90.31	89.85	89.9	589500.0
2007-09-13 11:00:00	TLT	Stock	89.89	89.93	89.75	89.76	355035.0
2007-09-13 12:00:00	TLT	Stock	89.75	89.77	89.66	89.75	190000.0
2007-09-13 13:00:00	TLT	Stock	89.74	89.75	89.58	89.73	192000.0
2007-09-13 14:00:00	TLT	Stock	89.72	89.89	89.66	89.75	139100.0
2007-09-13 15:00:00	TLT	Stock	89.75	89.77	89.62	89.73	247900.0
2007-09-13 16:00:00	TLT	Stock	89.75	89.78	89.74	89.78	11000.0

> showing 50 of 36,883 rows — these rows as CSV

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