PREVIEW / stock_1hour / 2007-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-13.parquet
  size:    770 KB
  rows:    38,234
  symbols: 3,050

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-13 09:00:00	AAPL	Stock	4.8225	4.8379	4.8043	4.8107	147047040.0
2007-07-13 10:00:00	AAPL	Stock	4.8107	4.8307	4.8064	4.8246	121284128.0
2007-07-13 11:00:00	AAPL	Stock	4.8246	4.8321	4.8143	4.825	74086320.0
2007-07-13 12:00:00	AAPL	Stock	4.825	4.8514	4.8201	4.8457	111741840.0
2007-07-13 13:00:00	AAPL	Stock	4.8457	4.8496	4.8311	4.8407	62161092.0
2007-07-13 14:00:00	AAPL	Stock	4.8407	4.8768	4.8396	4.8739	110489932.0
2007-07-13 15:00:00	AAPL	Stock	4.8742	4.9232	4.8725	4.9164	221947488.0
2007-07-13 16:00:00	AAPL	Stock	4.9161	4.9189	4.9161	4.9189	4529168.0
2007-07-13 09:00:00	MSFT	Stock	29.94	30.02	29.88	29.92	5977402.0
2007-07-13 10:00:00	MSFT	Stock	29.92	29.99	29.76	29.87	6402890.0
2007-07-13 11:00:00	MSFT	Stock	29.87	29.89	29.74	29.74	3627392.0
2007-07-13 12:00:00	MSFT	Stock	29.74	29.79	29.66	29.68	4171044.0
2007-07-13 13:00:00	MSFT	Stock	29.68	29.82	29.67	29.75	4972179.0
2007-07-13 14:00:00	MSFT	Stock	29.76	29.81	29.67	29.77	6430118.0
2007-07-13 15:00:00	MSFT	Stock	29.77	29.88	29.74	29.81	8092086.0
2007-07-13 16:00:00	MSFT	Stock	29.81	29.82	29.8	29.82	1034073.0
2007-07-13 09:00:00	NVDA	Stock	0.7667	0.7762	0.7637	0.7722	39977580.0
2007-07-13 10:00:00	NVDA	Stock	0.7723	0.7738	0.7695	0.7708	60773220.0
2007-07-13 11:00:00	NVDA	Stock	0.7709	0.7717	0.7657	0.7658	39003180.0
2007-07-13 12:00:00	NVDA	Stock	0.7658	0.7683	0.7642	0.7677	57338340.0
2007-07-13 13:00:00	NVDA	Stock	0.7677	0.7735	0.766	0.7678	28234740.0
2007-07-13 14:00:00	NVDA	Stock	0.7678	0.7702	0.7675	0.7695	31859940.0
2007-07-13 15:00:00	NVDA	Stock	0.7693	0.7695	0.764	0.7642	94413480.0
2007-07-13 16:00:00	NVDA	Stock	0.7642	0.7738	0.7642	0.7698	4882980.0
2007-07-13 17:00:00	NVDA	Stock	0.766	0.776	0.7642	0.7667	2752380.0
2007-07-13 18:00:00	NVDA	Stock	0.7668	0.7668	0.7668	0.7668	12000.0
2007-07-13 07:00:00	AMZN	Stock	3.635	3.636	3.635	3.636	21500.0
2007-07-13 08:00:00	AMZN	Stock	3.6395	3.6535	3.6395	3.645	281200.0
2007-07-13 09:00:00	AMZN	Stock	3.65	3.76	3.6425	3.6925	68554240.0
2007-07-13 10:00:00	AMZN	Stock	3.6925	3.73	3.6925	3.7085	35039400.0
2007-07-13 11:00:00	AMZN	Stock	3.7085	3.719	3.6965	3.7055	16503940.0
2007-07-13 12:00:00	AMZN	Stock	3.7055	3.724	3.7015	3.7225	10858460.0
2007-07-13 13:00:00	AMZN	Stock	3.7225	3.7405	3.7075	3.7325	25504300.0
2007-07-13 14:00:00	AMZN	Stock	3.7315	3.7675	3.725	3.766	31735520.0
2007-07-13 15:00:00	AMZN	Stock	3.765	3.7675	3.746	3.755	48808240.0
2007-07-13 16:00:00	AMZN	Stock	3.757	3.767	3.6935	3.7605	3041480.0
2007-07-13 17:00:00	AMZN	Stock	3.76	3.7675	3.684	3.7545	4029560.0
2007-07-13 18:00:00	AMZN	Stock	3.76	3.7615	3.76	3.7615	32500.0
2007-07-13 19:00:00	AMZN	Stock	3.7625	3.766	3.7625	3.765	36580.0
2007-07-13 09:00:00	TLT	Stock	84.45	84.55	84.41	84.49	109900.0
2007-07-13 10:00:00	TLT	Stock	84.48	84.49	83.94	83.99	173100.0
2007-07-13 11:00:00	TLT	Stock	83.99	84.28	83.99	84.23	147400.0
2007-07-13 12:00:00	TLT	Stock	84.23	84.38	84.22	84.22	101200.0
2007-07-13 13:00:00	TLT	Stock	84.22	84.31	84.19	84.22	29300.0
2007-07-13 14:00:00	TLT	Stock	84.24	84.31	84.2	84.31	37300.0
2007-07-13 15:00:00	TLT	Stock	84.3	84.42	84.28	84.39	125100.0
2007-07-13 16:00:00	TLT	Stock	84.39	84.39	84.26	84.26	1200.0
2007-07-13 09:00:00	CL	Stock	33.99	34.18	33.965	34.165	670200.0
2007-07-13 10:00:00	CL	Stock	34.165	34.33	34.15	34.325	722800.0
2007-07-13 11:00:00	CL	Stock	34.325	34.375	34.025	34.05	751200.0

> showing 50 of 38,234 rows — these rows as CSV

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