PREVIEW / stock_1hour / 2007-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-18.parquet
  size:    762 KB
  rows:    37,249
  symbols: 3,064

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-07-18 09:00:00	AAPL	Stock	4.9354	4.94	4.8939	4.9346	127695736.0
2007-07-18 10:00:00	AAPL	Stock	4.935	4.9443	4.8982	4.9125	128455068.0
2007-07-18 11:00:00	AAPL	Stock	4.9129	4.9261	4.9025	4.905	75155892.0
2007-07-18 12:00:00	AAPL	Stock	4.9054	4.9071	4.8586	4.885	123016516.0
2007-07-18 13:00:00	AAPL	Stock	4.8847	4.9146	4.8736	4.9014	74557532.0
2007-07-18 14:00:00	AAPL	Stock	4.9014	4.9114	4.8875	4.8921	69151292.0
2007-07-18 15:00:00	AAPL	Stock	4.8921	4.9336	4.8757	4.9332	115341184.0
2007-07-18 16:00:00	AAPL	Stock	4.9332	4.9332	4.9329	4.9329	7963536.0
2007-07-18 09:00:00	MSFT	Stock	30.51	30.8	30.5	30.74	6908517.0
2007-07-18 10:00:00	MSFT	Stock	30.74	30.86	30.65	30.74	10326747.0
2007-07-18 11:00:00	MSFT	Stock	30.73	30.88	30.72	30.72	8426870.0
2007-07-18 12:00:00	MSFT	Stock	30.725	30.73	30.56	30.66	6643043.0
2007-07-18 13:00:00	MSFT	Stock	30.66	30.76	30.53	30.69	5485685.0
2007-07-18 14:00:00	MSFT	Stock	30.68	30.79	30.67	30.785	5742373.0
2007-07-18 15:00:00	MSFT	Stock	30.785	30.97	30.78	30.95	15812458.0
2007-07-18 16:00:00	MSFT	Stock	30.96	30.96	30.92	30.92	1278671.0
2007-07-18 08:00:00	NVDA	Stock	0.7625	0.7627	0.7583	0.7627	69300.0
2007-07-18 09:00:00	NVDA	Stock	0.7633	0.7662	0.7592	0.7592	61562520.0
2007-07-18 10:00:00	NVDA	Stock	0.7593	0.7627	0.7458	0.7485	129726900.0
2007-07-18 11:00:00	NVDA	Stock	0.7488	0.7548	0.7485	0.7503	75837960.0
2007-07-18 12:00:00	NVDA	Stock	0.7507	0.7533	0.7463	0.7472	57242580.0
2007-07-18 13:00:00	NVDA	Stock	0.7472	0.7522	0.7463	0.7503	56344560.0
2007-07-18 14:00:00	NVDA	Stock	0.7503	0.7557	0.7498	0.7548	58167000.0
2007-07-18 15:00:00	NVDA	Stock	0.7548	0.7615	0.7532	0.7613	97038720.0
2007-07-18 16:00:00	NVDA	Stock	0.7613	0.7617	0.7603	0.7608	7674240.0
2007-07-18 17:00:00	NVDA	Stock	0.7607	0.7617	0.7607	0.7617	59520.0
2007-07-18 18:00:00	NVDA	Stock	0.7613	0.7613	0.7613	0.7613	30000.0
2007-07-18 19:00:00	NVDA	Stock	0.7613	0.7613	0.7613	0.7613	12000.0
2007-07-18 07:00:00	AMZN	Stock	3.675	3.675	3.675	3.675	2000.0
2007-07-18 08:00:00	AMZN	Stock	3.665	3.665	3.65	3.6535	77300.0
2007-07-18 09:00:00	AMZN	Stock	3.6535	3.6745	3.643	3.6595	20899620.0
2007-07-18 10:00:00	AMZN	Stock	3.66	3.674	3.65	3.6534	21651840.0
2007-07-18 11:00:00	AMZN	Stock	3.6535	3.6585	3.6435	3.651	16089360.0
2007-07-18 12:00:00	AMZN	Stock	3.651	3.653	3.6125	3.6335	17146260.0
2007-07-18 13:00:00	AMZN	Stock	3.6335	3.65	3.6265	3.6435	9333140.0
2007-07-18 14:00:00	AMZN	Stock	3.6435	3.6565	3.64	3.6495	8820280.0
2007-07-18 15:00:00	AMZN	Stock	3.651	3.6685	3.6435	3.667	25378060.0
2007-07-18 16:00:00	AMZN	Stock	3.6675	3.684	3.664	3.6655	411580.0
2007-07-18 17:00:00	AMZN	Stock	3.6675	3.6675	3.6655	3.6675	11600.0
2007-07-18 18:00:00	AMZN	Stock	3.668	3.67	3.6625	3.67	29960.0
2007-07-18 19:00:00	AMZN	Stock	3.6755	3.685	3.6755	3.685	12000.0
2007-07-18 09:00:00	TLT	Stock	84.93	84.96	84.86	84.91	70800.0
2007-07-18 10:00:00	TLT	Stock	84.9	85.54	84.81	85.4	685995.0
2007-07-18 11:00:00	TLT	Stock	85.39	85.42	85.29	85.33	171800.0
2007-07-18 12:00:00	TLT	Stock	85.34	85.5	85.32	85.35	86300.0
2007-07-18 13:00:00	TLT	Stock	85.35	85.47	85.34	85.39	130600.0
2007-07-18 14:00:00	TLT	Stock	85.4	85.46	85.35	85.4	83900.0
2007-07-18 15:00:00	TLT	Stock	85.39	85.45	85.13	85.19	190600.0
2007-07-18 16:00:00	TLT	Stock	85.18	85.21	85.18	85.21	45500.0
2007-07-18 09:00:00	CL	Stock	33.885	34.065	33.86	34.02	367400.0

> showing 50 of 37,249 rows — these rows as CSV

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