PREVIEW / stock_1hour / 2004-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-27.parquet
  size:    509 KB
  rows:    24,367
  symbols: 1,835

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-09-27 08:00:00	AAPL	Stock	0.6639	0.6639	0.6618	0.6636	138320.0
2004-09-27 09:00:00	AAPL	Stock	0.662	0.6641	0.6577	0.6627	62933920.0
2004-09-27 10:00:00	AAPL	Stock	0.6625	0.6757	0.662	0.6739	107523920.0
2004-09-27 11:00:00	AAPL	Stock	0.6738	0.6782	0.6736	0.6777	71017016.0
2004-09-27 12:00:00	AAPL	Stock	0.6779	0.6779	0.6707	0.6759	49258160.0
2004-09-27 13:00:00	AAPL	Stock	0.6761	0.6761	0.6725	0.675	17110856.0
2004-09-27 14:00:00	AAPL	Stock	0.675	0.6768	0.6713	0.6729	18880736.0
2004-09-27 15:00:00	AAPL	Stock	0.6732	0.6743	0.6689	0.67	44019920.0
2004-09-27 16:00:00	AAPL	Stock	0.6702	0.6721	0.6696	0.6702	5322128.0
2004-09-27 17:00:00	AAPL	Stock	0.6705	0.6705	0.6702	0.6702	868336.0
2004-09-27 08:00:00	MSFT	Stock	27.27	27.27	27.22	27.23	14600.0
2004-09-27 09:00:00	MSFT	Stock	27.22	27.2858	27.13	27.248	5720308.0
2004-09-27 10:00:00	MSFT	Stock	27.25	27.28	27.21	27.24	5300969.0
2004-09-27 11:00:00	MSFT	Stock	27.24	27.29	27.23	27.26	3703566.0
2004-09-27 12:00:00	MSFT	Stock	27.26	27.32	27.25	27.29	4045459.0
2004-09-27 13:00:00	MSFT	Stock	27.29	27.3	27.25	27.27	2683474.0
2004-09-27 14:00:00	MSFT	Stock	27.28	27.3	27.23	27.26	6796816.0
2004-09-27 15:00:00	MSFT	Stock	27.26	27.2736	27.14	27.24	11245229.0
2004-09-27 16:00:00	MSFT	Stock	27.23	27.3	27.15	27.25	4379120.0
2004-09-27 17:00:00	MSFT	Stock	27.26	27.26	27.19	27.2524	220118.0
2004-09-27 18:00:00	MSFT	Stock	27.25	27.26	27.25	27.25	4750.0
2004-09-27 09:00:00	NVDA	Stock	0.1158	0.1165	0.1129	0.1145	84232920.0
2004-09-27 10:00:00	NVDA	Stock	0.1144	0.1175	0.1142	0.1162	101153880.0
2004-09-27 11:00:00	NVDA	Stock	0.1162	0.1171	0.1154	0.1158	49397760.0
2004-09-27 12:00:00	NVDA	Stock	0.1157	0.1166	0.1153	0.1162	22714200.0
2004-09-27 13:00:00	NVDA	Stock	0.1162	0.1165	0.1155	0.1165	22804440.0
2004-09-27 14:00:00	NVDA	Stock	0.1166	0.1167	0.1155	0.1159	18865440.0
2004-09-27 15:00:00	NVDA	Stock	0.1159	0.116	0.1142	0.115	83846880.0
2004-09-27 16:00:00	NVDA	Stock	0.115	0.1151	0.1142	0.1143	13184520.0
2004-09-27 17:00:00	NVDA	Stock	0.1149	0.115	0.1139	0.115	680640.0
2004-09-27 08:00:00	AMZN	Stock	2.0425	2.0425	2.0395	2.0395	6200.0
2004-09-27 09:00:00	AMZN	Stock	2.0365	2.0505	2.0135	2.0145	29368960.0
2004-09-27 10:00:00	AMZN	Stock	2.014	2.027	2.0055	2.0075	32167360.0
2004-09-27 11:00:00	AMZN	Stock	2.0075	2.016	2.002	2.005	23682640.0
2004-09-27 12:00:00	AMZN	Stock	2.005	2.0235	2.005	2.017	12752160.0
2004-09-27 13:00:00	AMZN	Stock	2.016	2.018	2.0	2.0005	12671380.0
2004-09-27 14:00:00	AMZN	Stock	2.0005	2.005	1.997	2.005	17483220.0
2004-09-27 15:00:00	AMZN	Stock	2.005	2.0065	1.9875	1.9955	35797160.0
2004-09-27 16:00:00	AMZN	Stock	1.9955	1.997	1.9935	1.9965	2366900.0
2004-09-27 17:00:00	AMZN	Stock	1.995	1.9966	1.9925	1.9925	450320.0
2004-09-27 09:00:00	CL	Stock	22.775	22.825	22.63	22.665	1722000.0
2004-09-27 10:00:00	CL	Stock	22.665	22.77	22.625	22.675	1789600.0
2004-09-27 11:00:00	CL	Stock	22.68	22.715	22.575	22.6	1033000.0
2004-09-27 12:00:00	CL	Stock	22.595	22.7	22.59	22.69	965600.0
2004-09-27 13:00:00	CL	Stock	22.69	22.71	22.66	22.7	1152800.0
2004-09-27 14:00:00	CL	Stock	22.705	22.705	22.625	22.675	881000.0
2004-09-27 15:00:00	CL	Stock	22.675	22.705	22.59	22.62	1516600.0
2004-09-27 16:00:00	CL	Stock	22.615	22.615	22.615	22.615	29000.0
2004-09-27 17:00:00	CL	Stock	22.615	22.615	22.615	22.615	2600.0
2004-09-27 19:00:00	CL	Stock	22.645	22.645	22.645	22.645	2000.0

> showing 50 of 24,367 rows — these rows as CSV

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