PREVIEW / stock_1hour / 2004-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-20.parquet
  size:    527 KB
  rows:    25,001
  symbols: 1,800

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-07-20 09:00:00	AAPL	Stock	0.5709	0.5713	0.5634	0.5661	40028016.0
2004-07-20 10:00:00	AAPL	Stock	0.5659	0.5682	0.5643	0.5671	35036120.0
2004-07-20 11:00:00	AAPL	Stock	0.567	0.5714	0.567	0.5705	35094752.0
2004-07-20 12:00:00	AAPL	Stock	0.5705	0.5725	0.5705	0.5709	27328448.0
2004-07-20 13:00:00	AAPL	Stock	0.5709	0.5723	0.5709	0.5716	22863064.0
2004-07-20 14:00:00	AAPL	Stock	0.5716	0.5739	0.5713	0.5714	49589848.0
2004-07-20 15:00:00	AAPL	Stock	0.5714	0.5746	0.5713	0.5746	42016240.0
2004-07-20 16:00:00	AAPL	Stock	0.5746	0.5768	0.5736	0.575	4620392.0
2004-07-20 17:00:00	AAPL	Stock	0.5777	0.58	0.5643	0.58	11415040.0
2004-07-20 18:00:00	AAPL	Stock	0.5795	0.5795	0.5786	0.5786	78400.0
2004-07-20 08:00:00	MSFT	Stock	27.9	28.08	27.9	28.0143	36313.0
2004-07-20 09:00:00	MSFT	Stock	27.95	28.06	27.91	27.94	6945596.0
2004-07-20 10:00:00	MSFT	Stock	27.94	28.05	27.86	28.04	8433943.0
2004-07-20 11:00:00	MSFT	Stock	28.04	28.25	27.98	28.19	8517703.0
2004-07-20 12:00:00	MSFT	Stock	28.19	28.38	28.17	28.34	7708092.0
2004-07-20 13:00:00	MSFT	Stock	28.34	28.48	28.27	28.44	7814455.0
2004-07-20 14:00:00	MSFT	Stock	28.439	28.44	28.11	28.15	11325328.0
2004-07-20 15:00:00	MSFT	Stock	28.15	28.32	28.15	28.3	10349306.0
2004-07-20 16:00:00	MSFT	Stock	28.29	29.71	28.1787	29.45	20222700.0
2004-07-20 17:00:00	MSFT	Stock	29.45	29.94	27.95	29.8	4303664.0
2004-07-20 18:00:00	MSFT	Stock	29.8	29.87	29.7	29.81	572626.0
2004-07-20 09:00:00	NVDA	Stock	0.1279	0.1289	0.1274	0.1281	35361480.0
2004-07-20 10:00:00	NVDA	Stock	0.1279	0.1279	0.1266	0.1269	35029680.0
2004-07-20 11:00:00	NVDA	Stock	0.127	0.1294	0.1267	0.1294	47867640.0
2004-07-20 12:00:00	NVDA	Stock	0.1292	0.1293	0.128	0.128	30629040.0
2004-07-20 13:00:00	NVDA	Stock	0.1279	0.1293	0.1279	0.1292	39562920.0
2004-07-20 14:00:00	NVDA	Stock	0.1291	0.1296	0.1282	0.129	47467440.0
2004-07-20 15:00:00	NVDA	Stock	0.129	0.131	0.1289	0.1306	77917560.0
2004-07-20 16:00:00	NVDA	Stock	0.1306	0.1312	0.1304	0.1312	2767440.0
2004-07-20 17:00:00	NVDA	Stock	0.1303	0.1321	0.1302	0.1314	10884240.0
2004-07-20 18:00:00	NVDA	Stock	0.1323	0.1328	0.1323	0.1327	408000.0
2004-07-20 08:00:00	AMZN	Stock	2.302	2.3063	2.3015	2.3063	397960.0
2004-07-20 09:00:00	AMZN	Stock	2.301	2.3375	2.2995	2.335	18934740.0
2004-07-20 10:00:00	AMZN	Stock	2.3355	2.362	2.3335	2.362	22747180.0
2004-07-20 11:00:00	AMZN	Stock	2.3615	2.371	2.351	2.3685	16001520.0
2004-07-20 12:00:00	AMZN	Stock	2.3685	2.378	2.362	2.362	11259980.0
2004-07-20 13:00:00	AMZN	Stock	2.362	2.375	2.354	2.3675	11307260.0
2004-07-20 14:00:00	AMZN	Stock	2.3675	2.3925	2.367	2.3755	17131580.0
2004-07-20 15:00:00	AMZN	Stock	2.3755	2.386	2.345	2.35	29345140.0
2004-07-20 16:00:00	AMZN	Stock	2.35	2.358	2.347	2.3495	3327940.0
2004-07-20 17:00:00	AMZN	Stock	2.363	2.375	2.3345	2.375	6273160.0
2004-07-20 18:00:00	AMZN	Stock	2.375	2.38	2.375	2.3795	48000.0
2004-07-20 09:00:00	CL	Stock	28.015	28.115	28.005	28.045	192600.0
2004-07-20 10:00:00	CL	Stock	28.04	28.055	27.96	27.995	328600.0
2004-07-20 11:00:00	CL	Stock	27.985	28.05	27.945	28.05	391600.0
2004-07-20 12:00:00	CL	Stock	28.05	28.12	28.01	28.12	552600.0
2004-07-20 13:00:00	CL	Stock	28.11	28.125	28.07	28.09	278600.0
2004-07-20 14:00:00	CL	Stock	28.09	28.125	28.06	28.075	554800.0
2004-07-20 15:00:00	CL	Stock	28.085	28.31	28.08	28.3	1370400.0
2004-07-20 16:00:00	CL	Stock	28.31	28.3105	28.31	28.31	204000.0

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

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