PREVIEW / stock_1hour / 2007-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-20.parquet
  size:    823 KB
  rows:    40,946
  symbols: 3,257

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-12-20 04:00:00	AAPL	Stock	6.5807	6.5807	6.5807	6.5807	2800.0
2007-12-20 07:00:00	AAPL	Stock	6.6068	6.6068	6.5768	6.5882	119756.0
2007-12-20 08:00:00	AAPL	Stock	6.5821	6.6071	6.5714	6.5914	3459064.0
2007-12-20 09:00:00	AAPL	Stock	6.5911	6.6246	6.5643	6.575	89498724.0
2007-12-20 10:00:00	AAPL	Stock	6.5744	6.6304	6.5475	6.5718	132232940.0
2007-12-20 11:00:00	AAPL	Stock	6.5721	6.5843	6.5554	6.5682	68815320.0
2007-12-20 12:00:00	AAPL	Stock	6.5679	6.5821	6.5504	6.5736	56506632.0
2007-12-20 13:00:00	AAPL	Stock	6.5732	6.6346	6.5718	6.6286	93604924.0
2007-12-20 14:00:00	AAPL	Stock	6.6282	6.6964	6.6107	6.6725	143549056.0
2007-12-20 15:00:00	AAPL	Stock	6.6725	6.7082	6.6561	6.6839	157500616.0
2007-12-20 16:00:00	AAPL	Stock	6.6854	6.7857	6.6202	6.7575	23308600.0
2007-12-20 17:00:00	AAPL	Stock	6.7582	6.7839	6.6141	6.7821	3262280.0
2007-12-20 18:00:00	AAPL	Stock	6.7789	6.7911	6.7786	6.7786	1575308.0
2007-12-20 19:00:00	AAPL	Stock	6.7786	6.7857	6.7643	6.7807	621264.0
2007-12-20 08:00:00	MSFT	Stock	34.94	35.2	34.94	35.15	78563.0
2007-12-20 09:00:00	MSFT	Stock	35.18	35.39	35.1	35.17	6770470.0
2007-12-20 10:00:00	MSFT	Stock	35.17	35.43	35.08	35.31	8833823.0
2007-12-20 11:00:00	MSFT	Stock	35.3	35.38	35.21	35.35	6019657.0
2007-12-20 12:00:00	MSFT	Stock	35.34	35.39	35.23	35.31	5505892.0
2007-12-20 13:00:00	MSFT	Stock	35.31	35.5	35.28	35.47	5989440.0
2007-12-20 14:00:00	MSFT	Stock	35.47	35.73	35.45	35.63	8843121.0
2007-12-20 15:00:00	MSFT	Stock	35.62	35.79	35.47	35.52	14179327.0
2007-12-20 16:00:00	MSFT	Stock	35.53	35.62	35.35	35.62	3168613.0
2007-12-20 17:00:00	MSFT	Stock	35.62	35.68	35.448	35.65	68123.0
2007-12-20 18:00:00	MSFT	Stock	35.69	35.75	35.69	35.69	5390.0
2007-12-20 19:00:00	MSFT	Stock	35.7	35.74	35.7	35.7	2150.0
2007-12-20 08:00:00	NVDA	Stock	0.8625	0.875	0.8612	0.8655	305000.0
2007-12-20 09:00:00	NVDA	Stock	0.8745	0.8775	0.8645	0.865	20734840.0
2007-12-20 10:00:00	NVDA	Stock	0.8648	0.8715	0.862	0.8627	35099000.0
2007-12-20 11:00:00	NVDA	Stock	0.8628	0.8665	0.8585	0.8598	24094320.0
2007-12-20 12:00:00	NVDA	Stock	0.8595	0.8648	0.8568	0.8598	23676000.0
2007-12-20 13:00:00	NVDA	Stock	0.8598	0.87	0.8592	0.8675	27024120.0
2007-12-20 14:00:00	NVDA	Stock	0.8672	0.8775	0.8665	0.8732	53251840.0
2007-12-20 15:00:00	NVDA	Stock	0.8728	0.8812	0.8705	0.879	83201280.0
2007-12-20 16:00:00	NVDA	Stock	0.8792	0.8868	0.8706	0.8711	12239160.0
2007-12-20 17:00:00	NVDA	Stock	0.885	0.885	0.8792	0.88	220480.0
2007-12-20 08:00:00	AMZN	Stock	4.505	4.505	4.4725	4.4725	76000.0
2007-12-20 09:00:00	AMZN	Stock	4.494	4.5375	4.475	4.4855	17041360.0
2007-12-20 10:00:00	AMZN	Stock	4.4855	4.5145	4.4665	4.4985	19785380.0
2007-12-20 11:00:00	AMZN	Stock	4.4985	4.5005	4.4605	4.467	13055380.0
2007-12-20 12:00:00	AMZN	Stock	4.4665	4.499	4.4545	4.4945	13555420.0
2007-12-20 13:00:00	AMZN	Stock	4.4955	4.512	4.482	4.5045	12023100.0
2007-12-20 14:00:00	AMZN	Stock	4.5065	4.5325	4.4935	4.5165	15790180.0
2007-12-20 15:00:00	AMZN	Stock	4.517	4.536	4.5035	4.5325	22715760.0
2007-12-20 16:00:00	AMZN	Stock	4.5305	4.5375	4.469	4.5375	2283320.0
2007-12-20 17:00:00	AMZN	Stock	4.5375	4.545	4.529	4.545	95960.0
2007-12-20 18:00:00	AMZN	Stock	4.545	4.545	4.545	4.545	32160.0
2007-12-20 19:00:00	AMZN	Stock	4.5495	4.553	4.5495	4.553	20000.0
2007-12-20 09:00:00	TLT	Stock	93.29	93.31	93.06	93.2	363900.0
2007-12-20 10:00:00	TLT	Stock	93.19	93.63	93.13	93.62	400499.0

> showing 50 of 40,946 rows — these rows as CSV

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