PREVIEW / stock_1hour / 2005-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-04.parquet
  size:    544 KB
  rows:    25,278
  symbols: 1,928

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
2005-02-04 08:00:00	AAPL	Stock	1.3889	1.3973	1.3889	1.3911	1072344.0
2005-02-04 09:00:00	AAPL	Stock	1.3905	1.4045	1.3845	1.4027	103824224.0
2005-02-04 10:00:00	AAPL	Stock	1.4027	1.4041	1.3861	1.3986	154965104.0
2005-02-04 11:00:00	AAPL	Stock	1.3986	1.4014	1.393	1.3938	74530400.0
2005-02-04 12:00:00	AAPL	Stock	1.3939	1.3964	1.3918	1.3957	34504792.0
2005-02-04 13:00:00	AAPL	Stock	1.3957	1.4004	1.3936	1.3966	39260872.0
2005-02-04 14:00:00	AAPL	Stock	1.3966	1.4002	1.3938	1.3952	43672496.0
2005-02-04 15:00:00	AAPL	Stock	1.3954	1.4095	1.3948	1.4075	87746176.0
2005-02-04 16:00:00	AAPL	Stock	1.4084	1.4089	1.4063	1.4089	7163184.0
2005-02-04 17:00:00	AAPL	Stock	1.4089	1.4098	1.4075	1.4075	53200.0
2005-02-04 18:00:00	AAPL	Stock	1.4075	1.4079	1.4075	1.4079	84000.0
2005-02-04 08:00:00	MSFT	Stock	26.22	26.27	26.19	26.2	49161.0
2005-02-04 09:00:00	MSFT	Stock	26.22	26.27	26.14	26.23	5631695.0
2005-02-04 10:00:00	MSFT	Stock	26.23	26.35	26.22	26.29	7387735.0
2005-02-04 11:00:00	MSFT	Stock	26.28	26.33	26.249	26.25	5381235.0
2005-02-04 12:00:00	MSFT	Stock	26.25	26.29	26.239	26.28	2706352.0
2005-02-04 13:00:00	MSFT	Stock	26.28	26.301	26.21	26.26	7120198.0
2005-02-04 14:00:00	MSFT	Stock	26.26	26.27	26.18	26.21	13045218.0
2005-02-04 15:00:00	MSFT	Stock	26.21	26.37	26.18	26.31	14988408.0
2005-02-04 16:00:00	MSFT	Stock	26.32	26.34	26.29	26.3	2114862.0
2005-02-04 17:00:00	MSFT	Stock	26.31	26.31	26.3	26.31	2300.0
2005-02-04 18:00:00	MSFT	Stock	26.3	26.31	26.3	26.3	3084.0
2005-02-04 08:00:00	NVDA	Stock	0.2054	0.2054	0.2027	0.204	264000.0
2005-02-04 09:00:00	NVDA	Stock	0.2039	0.2082	0.2033	0.2073	83261640.0
2005-02-04 10:00:00	NVDA	Stock	0.2077	0.2129	0.2067	0.2105	208322040.0
2005-02-04 11:00:00	NVDA	Stock	0.2104	0.2118	0.2092	0.2109	87648480.0
2005-02-04 12:00:00	NVDA	Stock	0.2109	0.2113	0.2107	0.2111	46989240.0
2005-02-04 13:00:00	NVDA	Stock	0.2111	0.2129	0.2108	0.2128	97874400.0
2005-02-04 14:00:00	NVDA	Stock	0.2129	0.214	0.2117	0.2132	86459400.0
2005-02-04 15:00:00	NVDA	Stock	0.2132	0.2155	0.2131	0.2148	180051000.0
2005-02-04 16:00:00	NVDA	Stock	0.215	0.2157	0.2138	0.2151	3406440.0
2005-02-04 17:00:00	NVDA	Stock	0.2152	0.2157	0.2152	0.2154	600000.0
2005-02-04 18:00:00	NVDA	Stock	0.2156	0.216	0.2156	0.216	402000.0
2005-02-04 08:00:00	AMZN	Stock	1.7895	1.7985	1.7775	1.7865	1424220.0
2005-02-04 09:00:00	AMZN	Stock	1.783	1.788	1.7595	1.7605	61109100.0
2005-02-04 10:00:00	AMZN	Stock	1.7605	1.799	1.7605	1.7805	89243940.0
2005-02-04 11:00:00	AMZN	Stock	1.78	1.788	1.7675	1.769	39164060.0
2005-02-04 12:00:00	AMZN	Stock	1.768	1.779	1.7635	1.779	26479940.0
2005-02-04 13:00:00	AMZN	Stock	1.7785	1.7845	1.7742	1.7805	33812280.0
2005-02-04 14:00:00	AMZN	Stock	1.781	1.7835	1.7695	1.7705	32414900.0
2005-02-04 15:00:00	AMZN	Stock	1.7705	1.7885	1.77	1.7875	57955120.0
2005-02-04 16:00:00	AMZN	Stock	1.786	1.7875	1.78	1.7845	1803160.0
2005-02-04 17:00:00	AMZN	Stock	1.785	1.79	1.7845	1.7895	955000.0
2005-02-04 18:00:00	AMZN	Stock	1.79	1.79	1.785	1.785	32000.0
2005-02-04 09:00:00	CL	Stock	27.175	27.34	27.12	27.215	586400.0
2005-02-04 10:00:00	CL	Stock	27.235	27.425	27.21	27.425	586000.0
2005-02-04 11:00:00	CL	Stock	27.425	27.47	27.29	27.295	777800.0
2005-02-04 12:00:00	CL	Stock	27.295	27.34	27.245	27.3195	511800.0
2005-02-04 13:00:00	CL	Stock	27.315	27.315	27.18	27.275	879800.0
2005-02-04 14:00:00	CL	Stock	27.2795	27.32	27.255	27.28	683600.0

> showing 50 of 25,278 rows — these rows as CSV

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