PREVIEW / stock_1hour / 2005-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-12.parquet
  size:    544 KB
  rows:    25,659
  symbols: 1,955

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-04-12 07:00:00	AAPL	Stock	1.5157	1.5157	1.5057	1.5086	156800.0
2005-04-12 08:00:00	AAPL	Stock	1.5071	1.5214	1.5071	1.5175	8781080.0
2005-04-12 09:00:00	AAPL	Stock	1.5175	1.5343	1.5096	1.53	159831532.0
2005-04-12 10:00:00	AAPL	Stock	1.53	1.5425	1.5268	1.5364	171450972.0
2005-04-12 11:00:00	AAPL	Stock	1.5364	1.5364	1.5136	1.5189	126689416.0
2005-04-12 12:00:00	AAPL	Stock	1.5193	1.5225	1.5036	1.5111	83133232.0
2005-04-12 13:00:00	AAPL	Stock	1.5114	1.5161	1.5039	1.5071	56366632.0
2005-04-12 14:00:00	AAPL	Stock	1.5071	1.5307	1.5004	1.5267	187041932.0
2005-04-12 15:00:00	AAPL	Stock	1.5268	1.5357	1.5207	1.525	173720652.0
2005-04-12 16:00:00	AAPL	Stock	1.5232	1.5314	1.5221	1.525	4508140.0
2005-04-12 17:00:00	AAPL	Stock	1.5239	1.5275	1.5236	1.525	783356.0
2005-04-12 18:00:00	AAPL	Stock	1.5257	1.5275	1.525	1.5268	344092.0
2005-04-12 08:00:00	MSFT	Stock	24.99	25.01	24.96	24.96	34500.0
2005-04-12 09:00:00	MSFT	Stock	24.97	24.98	24.87	24.89	4699854.0
2005-04-12 10:00:00	MSFT	Stock	24.89	24.99	24.8	24.9	8170898.0
2005-04-12 11:00:00	MSFT	Stock	24.9	24.95	24.88	24.89	6090490.0
2005-04-12 12:00:00	MSFT	Stock	24.9	24.94	24.86	24.91	4689115.0
2005-04-12 13:00:00	MSFT	Stock	24.91	24.95	24.88	24.95	4765840.0
2005-04-12 14:00:00	MSFT	Stock	24.94	25.25	24.89	25.22	19158100.0
2005-04-12 15:00:00	MSFT	Stock	25.23	25.35	25.2	25.31	15103077.0
2005-04-12 16:00:00	MSFT	Stock	25.32	25.4	25.28	25.33	543564.0
2005-04-12 17:00:00	MSFT	Stock	25.3	25.34	25.269	25.33	39572.0
2005-04-12 18:00:00	MSFT	Stock	25.32	25.34	25.32	25.34	603.0
2005-04-12 08:00:00	NVDA	Stock	0.1916	0.1916	0.1901	0.1901	220920.0
2005-04-12 09:00:00	NVDA	Stock	0.1912	0.1913	0.1892	0.1904	44985360.0
2005-04-12 10:00:00	NVDA	Stock	0.1904	0.191	0.1899	0.19	51052440.0
2005-04-12 11:00:00	NVDA	Stock	0.19	0.1901	0.1888	0.1891	38786400.0
2005-04-12 12:00:00	NVDA	Stock	0.1892	0.1892	0.1884	0.1884	36159360.0
2005-04-12 13:00:00	NVDA	Stock	0.1884	0.1885	0.1867	0.1875	59949240.0
2005-04-12 14:00:00	NVDA	Stock	0.1874	0.1929	0.1872	0.1923	151762800.0
2005-04-12 15:00:00	NVDA	Stock	0.1922	0.1942	0.1918	0.1936	121360800.0
2005-04-12 16:00:00	NVDA	Stock	0.1939	0.1951	0.1935	0.1942	2959680.0
2005-04-12 17:00:00	NVDA	Stock	0.1952	0.1952	0.1939	0.1943	540120.0
2005-04-12 09:00:00	AMZN	Stock	1.723	1.725	1.71	1.7105	10559800.0
2005-04-12 10:00:00	AMZN	Stock	1.7105	1.7155	1.696	1.701	17554360.0
2005-04-12 11:00:00	AMZN	Stock	1.7	1.7069	1.699	1.702	17598220.0
2005-04-12 12:00:00	AMZN	Stock	1.7015	1.705	1.695	1.6975	9608600.0
2005-04-12 13:00:00	AMZN	Stock	1.698	1.698	1.686	1.687	16572820.0
2005-04-12 14:00:00	AMZN	Stock	1.686	1.7215	1.683	1.7195	23606460.0
2005-04-12 15:00:00	AMZN	Stock	1.7195	1.732	1.7185	1.732	24446200.0
2005-04-12 16:00:00	AMZN	Stock	1.73	1.7325	1.725	1.7285	2201500.0
2005-04-12 17:00:00	AMZN	Stock	1.7315	1.7315	1.7247	1.7247	194780.0
2005-04-12 18:00:00	AMZN	Stock	1.728	1.731	1.728	1.731	12000.0
2005-04-12 09:00:00	CL	Stock	26.87	26.925	26.655	26.695	309400.0
2005-04-12 10:00:00	CL	Stock	26.695	26.75	26.52	26.555	417000.0
2005-04-12 11:00:00	CL	Stock	26.555	26.725	26.555	26.675	474800.0
2005-04-12 12:00:00	CL	Stock	26.675	26.675	26.545	26.55	201800.0
2005-04-12 13:00:00	CL	Stock	26.55	26.705	26.55	26.635	242000.0
2005-04-12 14:00:00	CL	Stock	26.635	27.07	26.58	27.01	839600.0
2005-04-12 15:00:00	CL	Stock	27.01	27.07	26.87	26.97	1086400.0

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

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