PREVIEW / stock_1hour / 2007-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-21.parquet
  size:    757 KB
  rows:    37,883
  symbols: 3,117

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-08-21 09:00:00	AAPL	Stock	4.3646	4.4068	4.3214	4.3929	78084412.0
2007-08-21 10:00:00	AAPL	Stock	4.3929	4.5582	4.3654	4.5386	315983556.0
2007-08-21 11:00:00	AAPL	Stock	4.5411	4.6057	4.4736	4.5939	274031688.0
2007-08-21 12:00:00	AAPL	Stock	4.5939	4.5982	4.53	4.5554	166903940.0
2007-08-21 13:00:00	AAPL	Stock	4.555	4.5875	4.5332	4.56	116655224.0
2007-08-21 14:00:00	AAPL	Stock	4.5593	4.5729	4.5211	4.5561	133305508.0
2007-08-21 15:00:00	AAPL	Stock	4.5564	4.5893	4.5339	4.5589	169603616.0
2007-08-21 16:00:00	AAPL	Stock	4.5561	4.5584	4.5561	4.5561	7477428.0
2007-08-21 09:00:00	MSFT	Stock	28.1	28.32	28.08	28.23	3408739.0
2007-08-21 10:00:00	MSFT	Stock	28.221	28.23	27.9	27.948	7473261.0
2007-08-21 11:00:00	MSFT	Stock	27.95	28.09	27.87	28.06	7988828.0
2007-08-21 12:00:00	MSFT	Stock	28.06	28.23	27.99	28.05	7434340.0
2007-08-21 13:00:00	MSFT	Stock	28.06	28.1	28.0	28.021	3193068.0
2007-08-21 14:00:00	MSFT	Stock	28.02	28.1	27.9	27.933	4810132.0
2007-08-21 15:00:00	MSFT	Stock	27.94	28.09	27.9	28.08	9424559.0
2007-08-21 16:00:00	MSFT	Stock	28.07	28.07	28.07	28.07	1327894.0
2007-08-21 08:00:00	NVDA	Stock	0.7492	0.7542	0.7492	0.7542	588000.0
2007-08-21 09:00:00	NVDA	Stock	0.7483	0.7532	0.7425	0.744	42079140.0
2007-08-21 10:00:00	NVDA	Stock	0.7438	0.7558	0.7417	0.7542	69266100.0
2007-08-21 11:00:00	NVDA	Stock	0.7543	0.77	0.7537	0.7693	111924720.0
2007-08-21 12:00:00	NVDA	Stock	0.7695	0.78	0.7682	0.777	74297280.0
2007-08-21 13:00:00	NVDA	Stock	0.7773	0.7948	0.7767	0.7921	137075520.0
2007-08-21 14:00:00	NVDA	Stock	0.792	0.7945	0.788	0.7928	117379560.0
2007-08-21 15:00:00	NVDA	Stock	0.7927	0.7932	0.7845	0.7893	124209600.0
2007-08-21 16:00:00	NVDA	Stock	0.7882	0.7888	0.7857	0.7875	18332040.0
2007-08-21 17:00:00	NVDA	Stock	0.7875	0.7875	0.7858	0.7875	95760.0
2007-08-21 18:00:00	NVDA	Stock	0.7875	0.7888	0.7858	0.786	354900.0
2007-08-21 19:00:00	NVDA	Stock	0.7875	0.7875	0.786	0.786	27360.0
2007-08-21 06:00:00	AMZN	Stock	3.705	3.705	3.69	3.705	34480.0
2007-08-21 07:00:00	AMZN	Stock	3.71	3.755	3.71	3.75	8000.0
2007-08-21 08:00:00	AMZN	Stock	3.7505	3.7505	3.73	3.73	241000.0
2007-08-21 09:00:00	AMZN	Stock	3.735	3.751	3.7045	3.72	11787080.0
2007-08-21 10:00:00	AMZN	Stock	3.7195	3.82	3.7195	3.812	32751280.0
2007-08-21 11:00:00	AMZN	Stock	3.812	3.839	3.792	3.81	26442720.0
2007-08-21 12:00:00	AMZN	Stock	3.811	3.874	3.8095	3.85	22985140.0
2007-08-21 13:00:00	AMZN	Stock	3.8495	3.871	3.825	3.8625	14251360.0
2007-08-21 14:00:00	AMZN	Stock	3.861	3.8915	3.856	3.87	24116220.0
2007-08-21 15:00:00	AMZN	Stock	3.869	3.8875	3.868	3.877	24969840.0
2007-08-21 16:00:00	AMZN	Stock	3.877	3.8845	3.8742	3.8825	2516600.0
2007-08-21 17:00:00	AMZN	Stock	3.8845	3.8875	3.8775	3.8775	194180.0
2007-08-21 18:00:00	AMZN	Stock	3.8745	3.8865	3.8745	3.8845	58620.0
2007-08-21 19:00:00	AMZN	Stock	3.8805	3.8805	3.88	3.88	6000.0
2007-08-21 09:00:00	TLT	Stock	87.1	87.2	87.09	87.16	39700.0
2007-08-21 10:00:00	TLT	Stock	87.16	87.36	87.15	87.29	371900.0
2007-08-21 11:00:00	TLT	Stock	87.29	87.39	87.24	87.28	343400.0
2007-08-21 12:00:00	TLT	Stock	87.27	87.32	87.2	87.21	193300.0
2007-08-21 13:00:00	TLT	Stock	87.22	87.24	87.05	87.14	235500.0
2007-08-21 14:00:00	TLT	Stock	87.15	87.41	87.13	87.38	153600.0
2007-08-21 15:00:00	TLT	Stock	87.38	87.38	87.28	87.3	160100.0
2007-08-21 16:00:00	TLT	Stock	87.28	87.3	87.26	87.26	8900.0

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

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