PREVIEW / stock_1hour / 2007-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-22.parquet
  size:    659 KB
  rows:    31,694
  symbols: 2,525

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-02-22 04:00:00	AAPL	Stock	3.1964	3.2	3.1964	3.2	66640.0
2007-02-22 05:00:00	AAPL	Stock	3.2007	3.2007	3.2	3.2	14000.0
2007-02-22 06:00:00	AAPL	Stock	3.2036	3.2071	3.2036	3.2071	98000.0
2007-02-22 07:00:00	AAPL	Stock	3.2071	3.2211	3.2	3.2071	1576820.0
2007-02-22 08:00:00	AAPL	Stock	3.2082	3.2429	3.2036	3.2304	16363032.0
2007-02-22 09:00:00	AAPL	Stock	3.2304	3.2432	3.1996	3.2021	202585740.0
2007-02-22 10:00:00	AAPL	Stock	3.2025	3.2225	3.1893	3.2082	190525468.0
2007-02-22 11:00:00	AAPL	Stock	3.2079	3.2082	3.1618	3.1825	155285788.0
2007-02-22 12:00:00	AAPL	Stock	3.1825	3.2214	3.1811	3.1939	74930100.0
2007-02-22 13:00:00	AAPL	Stock	3.1954	3.1982	3.185	3.1886	39944100.0
2007-02-22 14:00:00	AAPL	Stock	3.1886	3.195	3.175	3.1757	58275056.0
2007-02-22 15:00:00	AAPL	Stock	3.1754	3.1968	3.175	3.1968	87484488.0
2007-02-22 16:00:00	AAPL	Stock	3.1968	3.2054	3.1904	3.2	4370240.0
2007-02-22 17:00:00	AAPL	Stock	3.1986	3.2	3.1968	3.2	211120.0
2007-02-22 18:00:00	AAPL	Stock	3.2	3.2029	3.1971	3.1971	244608.0
2007-02-22 19:00:00	AAPL	Stock	3.1982	3.1982	3.1968	3.1968	136976.0
2007-02-22 07:00:00	MSFT	Stock	29.31	29.34	29.31	29.34	7300.0
2007-02-22 08:00:00	MSFT	Stock	29.3	29.31	29.23	29.31	85920.0
2007-02-22 09:00:00	MSFT	Stock	29.31	29.54	29.24	29.495	10367031.0
2007-02-22 10:00:00	MSFT	Stock	29.5	29.54	29.32	29.38	9489870.0
2007-02-22 11:00:00	MSFT	Stock	29.37	29.4	29.25	29.37	7147525.0
2007-02-22 12:00:00	MSFT	Stock	29.37	29.4	29.3	29.31	4524130.0
2007-02-22 13:00:00	MSFT	Stock	29.3	29.36	29.28	29.3	4558334.0
2007-02-22 14:00:00	MSFT	Stock	29.3	29.36	29.16	29.26	10012137.0
2007-02-22 15:00:00	MSFT	Stock	29.26	29.39	29.25	29.38	7549635.0
2007-02-22 16:00:00	MSFT	Stock	29.39	29.4	29.32	29.32	483365.0
2007-02-22 17:00:00	MSFT	Stock	29.32	29.33	29.3	29.32	8557.0
2007-02-22 18:00:00	MSFT	Stock	29.32	29.32	29.3	29.31	7151.0
2007-02-22 19:00:00	MSFT	Stock	29.31	29.31	29.28	29.28	7091.0
2007-02-22 08:00:00	NVDA	Stock	0.545	0.5542	0.545	0.55	1862220.0
2007-02-22 09:00:00	NVDA	Stock	0.55	0.5593	0.5485	0.554	117515640.0
2007-02-22 10:00:00	NVDA	Stock	0.5543	0.5563	0.5462	0.5533	102237600.0
2007-02-22 11:00:00	NVDA	Stock	0.5532	0.5545	0.5473	0.549	86898060.0
2007-02-22 12:00:00	NVDA	Stock	0.549	0.55	0.5467	0.5468	49535340.0
2007-02-22 13:00:00	NVDA	Stock	0.547	0.5485	0.5452	0.547	49747680.0
2007-02-22 14:00:00	NVDA	Stock	0.5468	0.548	0.5442	0.5448	68130120.0
2007-02-22 15:00:00	NVDA	Stock	0.545	0.5542	0.5443	0.5455	133572300.0
2007-02-22 16:00:00	NVDA	Stock	0.5453	0.547	0.5453	0.547	385800.0
2007-02-22 17:00:00	NVDA	Stock	0.5467	0.5467	0.5467	0.5467	6000.0
2007-02-22 18:00:00	NVDA	Stock	0.5475	0.5475	0.5475	0.5475	112860.0
2007-02-22 08:00:00	AMZN	Stock	2.065	2.0725	2.065	2.0675	60000.0
2007-02-22 09:00:00	AMZN	Stock	2.0675	2.1	2.0675	2.0855	13949680.0
2007-02-22 10:00:00	AMZN	Stock	2.086	2.089	2.0555	2.068	18018800.0
2007-02-22 11:00:00	AMZN	Stock	2.0684	2.0813	2.0445	2.0525	17600460.0
2007-02-22 12:00:00	AMZN	Stock	2.0525	2.058	2.05	2.0535	4342480.0
2007-02-22 13:00:00	AMZN	Stock	2.0535	2.062	2.053	2.057	8239420.0
2007-02-22 14:00:00	AMZN	Stock	2.0575	2.06	2.049	2.05	10617440.0
2007-02-22 15:00:00	AMZN	Stock	2.05	2.0595	2.049	2.051	22401100.0
2007-02-22 16:00:00	AMZN	Stock	2.054	2.054	2.05	2.054	79000.0
2007-02-22 09:00:00	CL	Stock	34.1	34.18	34.025	34.055	369400.0

> showing 50 of 31,694 rows — these rows as CSV

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