PREVIEW / stock_1hour / 2005-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-03.parquet
  size:    562 KB
  rows:    26,032
  symbols: 1,913

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-01-03 08:00:00	AAPL	Stock	1.1607	1.1661	1.1518	1.1607	5910576.0
2005-01-03 09:00:00	AAPL	Stock	1.1607	1.1627	1.1277	1.1357	183156512.0
2005-01-03 10:00:00	AAPL	Stock	1.1361	1.1384	1.1179	1.1266	180934992.0
2005-01-03 11:00:00	AAPL	Stock	1.1263	1.1348	1.1214	1.1314	80163776.0
2005-01-03 12:00:00	AAPL	Stock	1.1314	1.1361	1.1268	1.1348	44763040.0
2005-01-03 13:00:00	AAPL	Stock	1.1348	1.135	1.1248	1.1255	45756592.0
2005-01-03 14:00:00	AAPL	Stock	1.1261	1.1341	1.1223	1.1304	44374064.0
2005-01-03 15:00:00	AAPL	Stock	1.13	1.1338	1.1241	1.1307	89244960.0
2005-01-03 16:00:00	AAPL	Stock	1.13	1.1321	1.1295	1.13	6682088.0
2005-01-03 17:00:00	AAPL	Stock	1.1302	1.1304	1.1288	1.1288	1242024.0
2005-01-03 18:00:00	AAPL	Stock	1.1288	1.1289	1.1268	1.1268	185080.0
2005-01-03 08:00:00	MSFT	Stock	26.81	26.84	26.71	26.8	91745.0
2005-01-03 09:00:00	MSFT	Stock	26.81	26.95	26.72	26.87	10822394.0
2005-01-03 10:00:00	MSFT	Stock	26.88	26.91	26.65	26.76	14021396.0
2005-01-03 11:00:00	MSFT	Stock	26.76	26.77	26.65	26.73	5435753.0
2005-01-03 12:00:00	MSFT	Stock	26.73	26.75	26.68	26.73	4006950.0
2005-01-03 13:00:00	MSFT	Stock	26.74	26.79	26.67	26.74	5206581.0
2005-01-03 14:00:00	MSFT	Stock	26.74	26.79	26.72	26.75	6033908.0
2005-01-03 15:00:00	MSFT	Stock	26.741	26.81	26.649	26.72	11021550.0
2005-01-03 16:00:00	MSFT	Stock	26.74	26.76	26.7	26.71	2920854.0
2005-01-03 17:00:00	MSFT	Stock	26.71	26.74	26.71	26.73	65970.0
2005-01-03 18:00:00	MSFT	Stock	26.75	26.75	26.74	26.74	300.0
2005-01-03 08:00:00	NVDA	Stock	0.204	0.2067	0.1963	0.2033	8598120.0
2005-01-03 09:00:00	NVDA	Stock	0.2036	0.206	0.1977	0.2033	254005080.0
2005-01-03 10:00:00	NVDA	Stock	0.2033	0.2037	0.1962	0.1996	271269120.0
2005-01-03 11:00:00	NVDA	Stock	0.1996	0.2	0.1976	0.1992	108705960.0
2005-01-03 12:00:00	NVDA	Stock	0.1991	0.1994	0.1978	0.199	56194080.0
2005-01-03 13:00:00	NVDA	Stock	0.1989	0.1993	0.1979	0.198	66591600.0
2005-01-03 14:00:00	NVDA	Stock	0.1979	0.1991	0.1979	0.1982	92392320.0
2005-01-03 15:00:00	NVDA	Stock	0.1981	0.1987	0.1957	0.1967	191797920.0
2005-01-03 16:00:00	NVDA	Stock	0.1966	0.1982	0.1966	0.1975	5662440.0
2005-01-03 17:00:00	NVDA	Stock	0.1968	0.1971	0.1968	0.1971	288000.0
2005-01-03 18:00:00	NVDA	Stock	0.1967	0.1967	0.1964	0.1964	675600.0
2005-01-03 08:00:00	AMZN	Stock	2.228	2.28	2.2145	2.2555	1074160.0
2005-01-03 09:00:00	AMZN	Stock	2.2535	2.272	2.218	2.246	48843700.0
2005-01-03 10:00:00	AMZN	Stock	2.246	2.248	2.2105	2.2275	48715720.0
2005-01-03 11:00:00	AMZN	Stock	2.228	2.2415	2.218	2.2355	21288420.0
2005-01-03 12:00:00	AMZN	Stock	2.2355	2.2425	2.2295	2.237	9716360.0
2005-01-03 13:00:00	AMZN	Stock	2.237	2.246	2.233	2.242	14543800.0
2005-01-03 14:00:00	AMZN	Stock	2.242	2.245	2.228	2.229	21624160.0
2005-01-03 15:00:00	AMZN	Stock	2.229	2.244	2.2175	2.223	38059060.0
2005-01-03 16:00:00	AMZN	Stock	2.2235	2.2265	2.2135	2.219	1820300.0
2005-01-03 17:00:00	AMZN	Stock	2.2215	2.226	2.2215	2.2225	610000.0
2005-01-03 18:00:00	AMZN	Stock	2.2215	2.224	2.2215	2.224	58200.0
2005-01-03 09:00:00	CL	Stock	25.455	25.575	25.455	25.525	434400.0
2005-01-03 10:00:00	CL	Stock	25.525	25.575	25.3	25.335	701600.0
2005-01-03 11:00:00	CL	Stock	25.336	25.345	25.29	25.305	433400.0
2005-01-03 12:00:00	CL	Stock	25.305	25.31	25.195	25.225	640600.0
2005-01-03 13:00:00	CL	Stock	25.225	25.245	25.125	25.2	479600.0
2005-01-03 14:00:00	CL	Stock	25.2	25.225	25.09	25.097	829800.0

> showing 50 of 26,032 rows — these rows as CSV

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