PREVIEW / stock_1hour / 2004-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-27.parquet
  size:    509 KB
  rows:    23,158
  symbols: 1,718

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
2004-01-27 08:00:00	AAPL	Stock	0.4107	0.4107	0.4105	0.4105	50400.0
2004-01-27 09:00:00	AAPL	Stock	0.4107	0.4126	0.4095	0.4109	15760080.0
2004-01-27 10:00:00	AAPL	Stock	0.4109	0.4136	0.4071	0.41	43274560.0
2004-01-27 11:00:00	AAPL	Stock	0.41	0.4114	0.4086	0.4111	33789616.0
2004-01-27 12:00:00	AAPL	Stock	0.4111	0.4116	0.4086	0.4116	37092664.0
2004-01-27 13:00:00	AAPL	Stock	0.4114	0.4136	0.4107	0.4136	46787272.0
2004-01-27 14:00:00	AAPL	Stock	0.4134	0.4152	0.4116	0.4132	45562160.0
2004-01-27 15:00:00	AAPL	Stock	0.4134	0.4138	0.4089	0.4116	49952672.0
2004-01-27 16:00:00	AAPL	Stock	0.4116	0.4129	0.4096	0.4127	2594760.0
2004-01-27 17:00:00	AAPL	Stock	0.4096	0.4096	0.4096	0.4096	56000.0
2004-01-27 18:00:00	AAPL	Stock	0.4089	0.4089	0.4089	0.4089	112000.0
2004-01-27 08:00:00	MSFT	Stock	28.7	28.74	28.65	28.67	61200.0
2004-01-27 09:00:00	MSFT	Stock	28.68	28.73	28.5	28.65	5217699.0
2004-01-27 10:00:00	MSFT	Stock	28.65	28.72	28.58	28.6	6843291.0
2004-01-27 11:00:00	MSFT	Stock	28.61	28.63	28.37	28.4	8477895.0
2004-01-27 12:00:00	MSFT	Stock	28.41	28.44	28.29	28.43	9007645.0
2004-01-27 13:00:00	MSFT	Stock	28.429	28.5	28.3199	28.48	6224639.0
2004-01-27 14:00:00	MSFT	Stock	28.48	28.53	28.36	28.42	7723649.0
2004-01-27 15:00:00	MSFT	Stock	28.42	28.46	28.22	28.25	12489309.0
2004-01-27 16:00:00	MSFT	Stock	28.25	28.4437	28.21	28.24	975328.0
2004-01-27 17:00:00	MSFT	Stock	28.25	28.3	28.24	28.3	43100.0
2004-01-27 18:00:00	MSFT	Stock	28.3	28.31	28.3	28.31	5300.0
2004-01-27 08:00:00	NVDA	Stock	0.1988	0.1988	0.1954	0.1967	2754000.0
2004-01-27 09:00:00	NVDA	Stock	0.1967	0.1992	0.1959	0.1978	42564360.0
2004-01-27 10:00:00	NVDA	Stock	0.1977	0.1978	0.1927	0.1927	137462400.0
2004-01-27 11:00:00	NVDA	Stock	0.1927	0.1927	0.19	0.1907	168816840.0
2004-01-27 12:00:00	NVDA	Stock	0.1908	0.1918	0.1902	0.1914	92745720.0
2004-01-27 13:00:00	NVDA	Stock	0.1914	0.1915	0.1896	0.1901	93652440.0
2004-01-27 14:00:00	NVDA	Stock	0.1901	0.1907	0.1885	0.1885	118233120.0
2004-01-27 15:00:00	NVDA	Stock	0.1885	0.1894	0.1871	0.1885	244944960.0
2004-01-27 16:00:00	NVDA	Stock	0.1887	0.1887	0.1875	0.1882	5329920.0
2004-01-27 17:00:00	NVDA	Stock	0.1876	0.1886	0.1862	0.1862	768000.0
2004-01-27 18:00:00	NVDA	Stock	0.1866	0.1875	0.1866	0.1875	108960.0
2004-01-27 08:00:00	AMZN	Stock	2.83	2.849	2.82	2.84	388500.0
2004-01-27 09:00:00	AMZN	Stock	2.8375	2.887	2.8355	2.8675	20271040.0
2004-01-27 10:00:00	AMZN	Stock	2.8675	2.87	2.8435	2.851	23086860.0
2004-01-27 11:00:00	AMZN	Stock	2.851	2.8515	2.8175	2.838	26830660.0
2004-01-27 12:00:00	AMZN	Stock	2.8375	2.8375	2.8195	2.831	14573420.0
2004-01-27 13:00:00	AMZN	Stock	2.831	2.8405	2.8015	2.8185	22384240.0
2004-01-27 14:00:00	AMZN	Stock	2.818	2.8225	2.794	2.8055	21811380.0
2004-01-27 15:00:00	AMZN	Stock	2.806	2.8155	2.784	2.786	45933400.0
2004-01-27 16:00:00	AMZN	Stock	2.784	2.9075	2.6925	2.7125	66745580.0
2004-01-27 17:00:00	AMZN	Stock	2.7125	2.7625	2.685	2.6925	8867980.0
2004-01-27 18:00:00	AMZN	Stock	2.6885	2.695	2.677	2.694	1877220.0
2004-01-27 09:00:00	CL	Stock	25.725	25.745	25.61	25.73	656200.0
2004-01-27 10:00:00	CL	Stock	25.73	25.775	25.65	25.72	968400.0
2004-01-27 11:00:00	CL	Stock	25.715	25.77	25.705	25.75	943800.0
2004-01-27 12:00:00	CL	Stock	25.74	25.76	25.685	25.755	682000.0
2004-01-27 13:00:00	CL	Stock	25.745	25.85	25.725	25.81	910200.0
2004-01-27 14:00:00	CL	Stock	25.81	25.82	25.7	25.71	562000.0

> showing 50 of 23,158 rows — these rows as CSV

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