PREVIEW / stock_1hour / 2004-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-13.parquet
  size:    509 KB
  rows:    24,087
  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-13 08:00:00	AAPL	Stock	0.6405	0.6405	0.6405	0.6405	32704.0
2004-09-13 09:00:00	AAPL	Stock	0.6405	0.6438	0.637	0.6432	31416224.0
2004-09-13 10:00:00	AAPL	Stock	0.643	0.6432	0.6384	0.642	41923112.0
2004-09-13 11:00:00	AAPL	Stock	0.642	0.6441	0.6409	0.642	45524976.0
2004-09-13 12:00:00	AAPL	Stock	0.642	0.6427	0.6413	0.6414	10023272.0
2004-09-13 13:00:00	AAPL	Stock	0.6414	0.6425	0.6398	0.6404	14975296.0
2004-09-13 14:00:00	AAPL	Stock	0.6404	0.6425	0.6373	0.6373	21987728.0
2004-09-13 15:00:00	AAPL	Stock	0.6373	0.6389	0.6307	0.6346	80809064.0
2004-09-13 16:00:00	AAPL	Stock	0.6343	0.6373	0.6338	0.6346	3603320.0
2004-09-13 17:00:00	AAPL	Stock	0.6355	0.6355	0.6339	0.6339	4391184.0
2004-09-13 18:00:00	AAPL	Stock	0.6368	0.6368	0.6368	0.6368	56000.0
2004-09-13 08:00:00	MSFT	Stock	27.52	27.57	27.52	27.54	59086.0
2004-09-13 09:00:00	MSFT	Stock	27.54	27.57	27.4	27.48	5726411.0
2004-09-13 10:00:00	MSFT	Stock	27.48	27.57	27.44	27.499	7240683.0
2004-09-13 11:00:00	MSFT	Stock	27.491	27.53	27.46	27.47	5964098.0
2004-09-13 12:00:00	MSFT	Stock	27.47	27.48	27.44	27.441	3113281.0
2004-09-13 13:00:00	MSFT	Stock	27.44	27.47	27.41	27.42	5637636.0
2004-09-13 14:00:00	MSFT	Stock	27.42	27.47	27.4	27.43	3422048.0
2004-09-13 15:00:00	MSFT	Stock	27.43	27.47	26.74	27.23	11915418.0
2004-09-13 16:00:00	MSFT	Stock	27.25	27.36	27.2	27.32	2116588.0
2004-09-13 17:00:00	MSFT	Stock	27.35	27.3683	27.26	27.3683	1266329.0
2004-09-13 18:00:00	MSFT	Stock	27.3	27.3	27.3	27.3	500.0
2004-09-13 08:00:00	NVDA	Stock	0.1158	0.1158	0.1158	0.1158	24000.0
2004-09-13 09:00:00	NVDA	Stock	0.1171	0.1193	0.1167	0.1176	112731720.0
2004-09-13 10:00:00	NVDA	Stock	0.1176	0.1203	0.1172	0.119	139718160.0
2004-09-13 11:00:00	NVDA	Stock	0.1191	0.1218	0.1189	0.1202	173379840.0
2004-09-13 12:00:00	NVDA	Stock	0.1202	0.1204	0.1194	0.1202	108449640.0
2004-09-13 13:00:00	NVDA	Stock	0.1202	0.1204	0.1184	0.119	91815960.0
2004-09-13 14:00:00	NVDA	Stock	0.119	0.1201	0.1187	0.1197	79023720.0
2004-09-13 15:00:00	NVDA	Stock	0.1197	0.1202	0.1183	0.1194	199475040.0
2004-09-13 16:00:00	NVDA	Stock	0.1193	0.1199	0.119	0.1195	1530000.0
2004-09-13 17:00:00	NVDA	Stock	0.1195	0.1199	0.1195	0.1196	3786240.0
2004-09-13 18:00:00	NVDA	Stock	0.1199	0.1199	0.1199	0.1199	96000.0
2004-09-13 09:00:00	AMZN	Stock	1.9325	1.96	1.9325	1.9495	22543380.0
2004-09-13 10:00:00	AMZN	Stock	1.9505	1.9745	1.947	1.967	27599520.0
2004-09-13 11:00:00	AMZN	Stock	1.966	1.9935	1.965	1.9905	21344720.0
2004-09-13 12:00:00	AMZN	Stock	1.9905	1.9975	1.987	1.9955	19600840.0
2004-09-13 13:00:00	AMZN	Stock	1.995	2.0015	1.985	1.9904	17517360.0
2004-09-13 14:00:00	AMZN	Stock	1.9904	1.998	1.979	1.9875	14837800.0
2004-09-13 15:00:00	AMZN	Stock	1.9875	2.002	1.9815	2.0	30546600.0
2004-09-13 16:00:00	AMZN	Stock	2.0	2.007	1.9985	2.0005	3745820.0
2004-09-13 17:00:00	AMZN	Stock	2.0055	2.0055	1.9874	1.9874	594380.0
2004-09-13 18:00:00	AMZN	Stock	2.0055	2.0055	2.001	2.0055	12000.0
2004-09-13 08:00:00	CL	Stock	27.22	27.22	27.22	27.22	3800.0
2004-09-13 09:00:00	CL	Stock	27.15	27.195	27.075	27.185	239200.0
2004-09-13 10:00:00	CL	Stock	27.185	27.535	27.175	27.505	716600.0
2004-09-13 11:00:00	CL	Stock	27.5	27.515	27.45	27.47	289400.0
2004-09-13 12:00:00	CL	Stock	27.47	27.515	27.435	27.435	157400.0
2004-09-13 13:00:00	CL	Stock	27.445	27.45	27.38	27.385	291800.0
2004-09-13 14:00:00	CL	Stock	27.39	27.395	27.335	27.34	402800.0

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

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