PREVIEW / stock_1hour / 2007-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-19.parquet
  size:    770 KB
  rows:    37,982
  symbols: 3,134

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-19 09:00:00	AAPL	Stock	5.1071	5.1129	5.0714	5.0821	144159008.0
2007-09-19 10:00:00	AAPL	Stock	5.0814	5.0943	5.0625	5.0905	137278176.0
2007-09-19 11:00:00	AAPL	Stock	5.0907	5.1089	5.0807	5.09	103753272.0
2007-09-19 12:00:00	AAPL	Stock	5.09	5.0939	5.0664	5.0825	88227020.0
2007-09-19 13:00:00	AAPL	Stock	5.0825	5.0857	5.0589	5.0761	85882776.0
2007-09-19 14:00:00	AAPL	Stock	5.0761	5.0818	5.0446	5.0636	87167248.0
2007-09-19 15:00:00	AAPL	Stock	5.0636	5.075	4.9786	5.0282	250858552.0
2007-09-19 16:00:00	AAPL	Stock	5.0268	5.0282	5.0257	5.0275	8929900.0
2007-09-19 09:00:00	MSFT	Stock	28.87	28.91	28.55	28.618	8063934.0
2007-09-19 10:00:00	MSFT	Stock	28.62	28.71	28.56	28.638	13568320.0
2007-09-19 11:00:00	MSFT	Stock	28.64	28.64	28.44	28.498	12486935.0
2007-09-19 12:00:00	MSFT	Stock	28.5	28.55	28.44	28.48	8465389.0
2007-09-19 13:00:00	MSFT	Stock	28.48	28.48	28.34	28.35	10009043.0
2007-09-19 14:00:00	MSFT	Stock	28.36	28.59	28.3	28.58	13978378.0
2007-09-19 15:00:00	MSFT	Stock	28.58	28.67	28.53	28.67	11732615.0
2007-09-19 16:00:00	MSFT	Stock	28.67	28.67	28.65	28.67	2363765.0
2007-09-19 08:00:00	NVDA	Stock	0.8812	0.8908	0.875	0.8908	551960.0
2007-09-19 09:00:00	NVDA	Stock	0.8898	0.9	0.8825	0.8878	81095840.0
2007-09-19 10:00:00	NVDA	Stock	0.8875	0.8878	0.8755	0.8815	100699840.0
2007-09-19 11:00:00	NVDA	Stock	0.8812	0.8832	0.8628	0.8635	74148040.0
2007-09-19 12:00:00	NVDA	Stock	0.8635	0.871	0.8622	0.87	39640320.0
2007-09-19 13:00:00	NVDA	Stock	0.87	0.8704	0.864	0.8672	39208520.0
2007-09-19 14:00:00	NVDA	Stock	0.8675	0.8678	0.8505	0.8578	65791160.0
2007-09-19 15:00:00	NVDA	Stock	0.8578	0.8632	0.8562	0.86	66451360.0
2007-09-19 16:00:00	NVDA	Stock	0.8602	0.8622	0.8585	0.859	8386120.0
2007-09-19 17:00:00	NVDA	Stock	0.8602	0.8602	0.8602	0.8602	49960.0
2007-09-19 18:00:00	NVDA	Stock	0.8602	0.8602	0.8588	0.8588	16040.0
2007-09-19 19:00:00	NVDA	Stock	0.859	0.859	0.859	0.859	6000.0
2007-09-19 06:00:00	AMZN	Stock	4.4	4.41	4.4	4.41	6200.0
2007-09-19 07:00:00	AMZN	Stock	4.425	4.45	4.415	4.435	30000.0
2007-09-19 08:00:00	AMZN	Stock	4.4445	4.463	4.4445	4.4625	246840.0
2007-09-19 09:00:00	AMZN	Stock	4.4625	4.483	4.4295	4.4375	22425140.0
2007-09-19 10:00:00	AMZN	Stock	4.4375	4.457	4.413	4.4485	29823020.0
2007-09-19 11:00:00	AMZN	Stock	4.449	4.491	4.4265	4.442	20260660.0
2007-09-19 12:00:00	AMZN	Stock	4.442	4.4595	4.431	4.4535	6846740.0
2007-09-19 13:00:00	AMZN	Stock	4.4535	4.454	4.422	4.4405	11974360.0
2007-09-19 14:00:00	AMZN	Stock	4.439	4.4445	4.416	4.4355	12996180.0
2007-09-19 15:00:00	AMZN	Stock	4.4345	4.456	4.4265	4.45	16265500.0
2007-09-19 16:00:00	AMZN	Stock	4.4465	4.4505	4.443	4.4505	273560.0
2007-09-19 17:00:00	AMZN	Stock	4.45	4.4505	4.45	4.4505	11000.0
2007-09-19 18:00:00	AMZN	Stock	4.4625	4.4625	4.435	4.435	7040.0
2007-09-19 19:00:00	AMZN	Stock	4.462	4.462	4.462	4.462	2000.0
2007-09-19 09:00:00	TLT	Stock	88.71	88.83	88.39	88.53	1358830.0
2007-09-19 10:00:00	TLT	Stock	88.52	88.75	88.46	88.71	1011300.0
2007-09-19 11:00:00	TLT	Stock	88.72	88.75	88.5	88.67	540700.0
2007-09-19 12:00:00	TLT	Stock	88.67	88.8	88.37	88.68	195900.0
2007-09-19 13:00:00	TLT	Stock	88.69	88.84	88.65	88.75	258200.0
2007-09-19 14:00:00	TLT	Stock	88.76	88.92	88.76	88.9	74900.0
2007-09-19 15:00:00	TLT	Stock	88.9	89.01	88.87	88.93	168100.0
2007-09-19 16:00:00	TLT	Stock	88.86	88.86	88.83	88.83	5600.0

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

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