PREVIEW / stock_1hour / 2009-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-23.parquet
  size:    906 KB
  rows:    43,636
  symbols: 3,450

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
2009-12-23 04:00:00	AAPL	Stock	7.1525	7.1525	7.1525	7.1525	5600.0
2009-12-23 07:00:00	AAPL	Stock	7.1857	7.1929	7.1857	7.1875	201600.0
2009-12-23 08:00:00	AAPL	Stock	7.1825	7.1911	7.1725	7.1893	1442280.0
2009-12-23 09:00:00	AAPL	Stock	7.1896	7.2143	7.1811	7.1992	60930016.0
2009-12-23 10:00:00	AAPL	Stock	7.1971	7.2146	7.1718	7.2001	83823852.0
2009-12-23 11:00:00	AAPL	Stock	7.2002	7.2104	7.1861	7.2034	42337960.0
2009-12-23 12:00:00	AAPL	Stock	7.2025	7.2136	7.1968	7.2125	28697984.0
2009-12-23 13:00:00	AAPL	Stock	7.2121	7.2279	7.2061	7.2186	41067012.0
2009-12-23 14:00:00	AAPL	Stock	7.2186	7.2243	7.215	7.2189	24813180.0
2009-12-23 15:00:00	AAPL	Stock	7.2189	7.2236	7.2	7.2211	52923304.0
2009-12-23 16:00:00	AAPL	Stock	7.2211	7.2275	7.1974	7.2232	4472496.0
2009-12-23 17:00:00	AAPL	Stock	7.22	7.2232	7.2179	7.2225	400400.0
2009-12-23 18:00:00	AAPL	Stock	7.2232	7.225	7.2179	7.2225	437920.0
2009-12-23 19:00:00	AAPL	Stock	7.2214	7.2261	7.2214	7.2214	256340.0
2009-12-23 05:00:00	MSFT	Stock	30.59	30.59	30.59	30.59	100.0
2009-12-23 06:00:00	MSFT	Stock	30.69	30.69	30.6	30.6	650.0
2009-12-23 07:00:00	MSFT	Stock	30.7	30.8	30.7	30.8	2430.0
2009-12-23 08:00:00	MSFT	Stock	30.85	30.92	30.56	30.76	31265.0
2009-12-23 09:00:00	MSFT	Stock	30.76	30.86	30.7	30.81	2097973.0
2009-12-23 10:00:00	MSFT	Stock	30.81	30.83	30.69	30.81	4521068.0
2009-12-23 11:00:00	MSFT	Stock	30.815	30.9	30.81	30.88	2973087.0
2009-12-23 12:00:00	MSFT	Stock	30.882	30.95	30.87	30.93	3246639.0
2009-12-23 13:00:00	MSFT	Stock	30.93	30.94	30.81	30.849	3998983.0
2009-12-23 14:00:00	MSFT	Stock	30.85	30.94	30.84	30.91	2989316.0
2009-12-23 15:00:00	MSFT	Stock	30.9	30.95	30.84	30.93	5360267.0
2009-12-23 16:00:00	MSFT	Stock	30.92	30.95	30.819	30.9	916712.0
2009-12-23 17:00:00	MSFT	Stock	30.9	30.92	30.9	30.9	38485.0
2009-12-23 18:00:00	MSFT	Stock	30.9	30.92	30.9	30.92	18954.0
2009-12-23 19:00:00	MSFT	Stock	30.9	30.92	30.9	30.92	635.0
2009-12-23 08:00:00	NVDA	Stock	0.45	0.4502	0.45	0.4502	58000.0
2009-12-23 09:00:00	NVDA	Stock	0.4538	0.4555	0.4492	0.4508	57459800.0
2009-12-23 10:00:00	NVDA	Stock	0.4505	0.4506	0.4455	0.4485	87700560.0
2009-12-23 11:00:00	NVDA	Stock	0.4485	0.45	0.4456	0.4485	56933520.0
2009-12-23 12:00:00	NVDA	Stock	0.4482	0.4512	0.4478	0.451	25298880.0
2009-12-23 13:00:00	NVDA	Stock	0.451	0.453	0.4504	0.4505	43951560.0
2009-12-23 14:00:00	NVDA	Stock	0.4507	0.4538	0.4502	0.4538	47611440.0
2009-12-23 15:00:00	NVDA	Stock	0.4538	0.4545	0.4522	0.4532	108575800.0
2009-12-23 16:00:00	NVDA	Stock	0.4532	0.4545	0.4508	0.4522	10578040.0
2009-12-23 17:00:00	NVDA	Stock	0.4525	0.4532	0.4525	0.4532	285640.0
2009-12-23 18:00:00	NVDA	Stock	0.4542	0.4542	0.4542	0.4542	84000.0
2009-12-23 19:00:00	NVDA	Stock	0.4532	0.4532	0.4532	0.4532	20000.0
2009-12-23 07:00:00	AMZN	Stock	6.7375	6.7375	6.7375	6.7375	2000.0
2009-12-23 08:00:00	AMZN	Stock	6.715	6.7395	6.715	6.7275	411120.0
2009-12-23 09:00:00	AMZN	Stock	6.734	6.8215	6.7175	6.8	24468040.0
2009-12-23 10:00:00	AMZN	Stock	6.8025	6.8575	6.7635	6.8382	38333800.0
2009-12-23 11:00:00	AMZN	Stock	6.8375	6.8825	6.817	6.8814	21570500.0
2009-12-23 12:00:00	AMZN	Stock	6.8805	6.9	6.8735	6.8925	20681540.0
2009-12-23 13:00:00	AMZN	Stock	6.8925	6.916	6.88	6.8815	16442620.0
2009-12-23 14:00:00	AMZN	Stock	6.8815	6.949	6.8805	6.939	23730400.0
2009-12-23 15:00:00	AMZN	Stock	6.9391	6.9525	6.9135	6.95	31902580.0

> showing 50 of 43,636 rows — these rows as CSV

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