PREVIEW / stock_1hour / 2004-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-01.parquet
  size:    509 KB
  rows:    23,825
  symbols: 1,760

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-04-01 08:00:00	AAPL	Stock	0.483	0.4839	0.4811	0.483	313992.0
2004-04-01 09:00:00	AAPL	Stock	0.4821	0.487	0.4754	0.4814	42382424.0
2004-04-01 10:00:00	AAPL	Stock	0.4816	0.4855	0.4789	0.4832	70509096.0
2004-04-01 11:00:00	AAPL	Stock	0.4834	0.4834	0.4791	0.4804	37111816.0
2004-04-01 12:00:00	AAPL	Stock	0.4805	0.4809	0.4786	0.4789	21044408.0
2004-04-01 13:00:00	AAPL	Stock	0.4788	0.4818	0.4786	0.4791	16949464.0
2004-04-01 14:00:00	AAPL	Stock	0.4789	0.4829	0.4789	0.482	32015760.0
2004-04-01 15:00:00	AAPL	Stock	0.482	0.4848	0.4814	0.4841	63133336.0
2004-04-01 16:00:00	AAPL	Stock	0.4818	0.4845	0.4814	0.4821	4342240.0
2004-04-01 17:00:00	AAPL	Stock	0.4834	0.4834	0.4821	0.4821	4420416.0
2004-04-01 08:00:00	MSFT	Stock	24.95	25.0	24.91	25.0	26301.0
2004-04-01 09:00:00	MSFT	Stock	25.0	25.1	24.93	25.0	5498825.0
2004-04-01 10:00:00	MSFT	Stock	24.99	25.11	24.99	25.05	11359461.0
2004-04-01 11:00:00	MSFT	Stock	25.05	25.08	24.96	24.98	6349955.0
2004-04-01 12:00:00	MSFT	Stock	24.99	25.0	24.9	24.92	6550500.0
2004-04-01 13:00:00	MSFT	Stock	24.92	25.04	24.87	25.02	9205492.0
2004-04-01 14:00:00	MSFT	Stock	25.02	25.08	24.96	24.99	8519095.0
2004-04-01 15:00:00	MSFT	Stock	24.98	25.09	24.9399	25.09	11668222.0
2004-04-01 16:00:00	MSFT	Stock	25.07	25.1	24.98	25.07	6231381.0
2004-04-01 17:00:00	MSFT	Stock	25.03	25.07	25.03	25.06	232876.0
2004-04-01 18:00:00	MSFT	Stock	25.07	25.07	25.0	25.07	18347.0
2004-04-01 08:00:00	NVDA	Stock	0.2204	0.2204	0.22	0.22	156000.0
2004-04-01 09:00:00	NVDA	Stock	0.2201	0.2208	0.2185	0.2203	117764880.0
2004-04-01 10:00:00	NVDA	Stock	0.2201	0.2247	0.2201	0.2231	128652840.0
2004-04-01 11:00:00	NVDA	Stock	0.223	0.2234	0.2123	0.2131	335535600.0
2004-04-01 12:00:00	NVDA	Stock	0.2132	0.216	0.2106	0.2113	235149000.0
2004-04-01 13:00:00	NVDA	Stock	0.2112	0.2175	0.2112	0.2167	179555400.0
2004-04-01 14:00:00	NVDA	Stock	0.2167	0.2172	0.2139	0.2141	92002080.0
2004-04-01 15:00:00	NVDA	Stock	0.2144	0.2166	0.2142	0.2161	135538200.0
2004-04-01 16:00:00	NVDA	Stock	0.2165	0.2182	0.2157	0.2167	22624320.0
2004-04-01 17:00:00	NVDA	Stock	0.2171	0.2171	0.2167	0.2167	2568000.0
2004-04-01 08:00:00	AMZN	Stock	2.1645	2.1655	2.164	2.1655	18000.0
2004-04-01 09:00:00	AMZN	Stock	2.1675	2.1745	2.163	2.173	10418800.0
2004-04-01 10:00:00	AMZN	Stock	2.1725	2.208	2.1725	2.203	19418020.0
2004-04-01 11:00:00	AMZN	Stock	2.2035	2.222	2.199	2.214	19977320.0
2004-04-01 12:00:00	AMZN	Stock	2.214	2.219	2.2085	2.2125	12436320.0
2004-04-01 13:00:00	AMZN	Stock	2.2125	2.2245	2.2045	2.224	9955880.0
2004-04-01 14:00:00	AMZN	Stock	2.2245	2.2335	2.219	2.226	13908440.0
2004-04-01 15:00:00	AMZN	Stock	2.225	2.2405	2.2155	2.24	27480100.0
2004-04-01 16:00:00	AMZN	Stock	2.2385	2.245	2.235	2.2405	11252300.0
2004-04-01 17:00:00	AMZN	Stock	2.241	2.243	2.2399	2.243	726160.0
2004-04-01 18:00:00	AMZN	Stock	2.24	2.245	2.24	2.242	50000.0
2004-04-01 09:00:00	CL	Stock	27.575	27.575	27.46	27.46	288000.0
2004-04-01 10:00:00	CL	Stock	27.45	27.555	27.41	27.485	892200.0
2004-04-01 11:00:00	CL	Stock	27.485	27.505	27.46	27.475	307400.0
2004-04-01 12:00:00	CL	Stock	27.475	27.525	27.405	27.405	330600.0
2004-04-01 13:00:00	CL	Stock	27.415	27.51	27.415	27.46	279400.0
2004-04-01 14:00:00	CL	Stock	27.46	27.48	27.44	27.445	384600.0
2004-04-01 15:00:00	CL	Stock	27.445	27.525	27.4	27.515	657600.0
2004-04-01 16:00:00	CL	Stock	27.46	27.46	27.46	27.46	10600.0

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

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