PREVIEW / stock_1hour / 2003-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-14.parquet
  size:    418 KB
  rows:    19,743
  symbols: 1,533

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
2003-01-14 08:00:00	AAPL	Stock	0.2625	0.2625	0.2623	0.2623	44800.0
2003-01-14 09:00:00	AAPL	Stock	0.2623	0.2646	0.2591	0.2613	24949344.0
2003-01-14 10:00:00	AAPL	Stock	0.2613	0.2629	0.2591	0.26	28995064.0
2003-01-14 11:00:00	AAPL	Stock	0.26	0.2607	0.2591	0.2605	12879888.0
2003-01-14 12:00:00	AAPL	Stock	0.2605	0.2607	0.2589	0.2589	16728824.0
2003-01-14 13:00:00	AAPL	Stock	0.2591	0.2598	0.2588	0.2598	25846856.0
2003-01-14 14:00:00	AAPL	Stock	0.26	0.2604	0.2589	0.26	18991616.0
2003-01-14 15:00:00	AAPL	Stock	0.26	0.2636	0.2598	0.2616	30232552.0
2003-01-14 16:00:00	AAPL	Stock	0.2616	0.2639	0.2588	0.2588	12058368.0
2003-01-14 17:00:00	AAPL	Stock	0.262	0.2621	0.2609	0.2609	772800.0
2003-01-14 08:00:00	MSFT	Stock	28.325	28.465	28.0	28.25	212860.0
2003-01-14 09:00:00	MSFT	Stock	28.25	28.325	28.095	28.285	9139364.0
2003-01-14 10:00:00	MSFT	Stock	28.295	28.47	28.155	28.305	12355758.0
2003-01-14 11:00:00	MSFT	Stock	28.305	28.5	28.255	28.36	5587250.0
2003-01-14 12:00:00	MSFT	Stock	28.355	28.4	28.305	28.33	3871176.0
2003-01-14 13:00:00	MSFT	Stock	28.33	28.375	28.27	28.36	3095330.0
2003-01-14 14:00:00	MSFT	Stock	28.36	28.37	28.27	28.3	3638156.0
2003-01-14 15:00:00	MSFT	Stock	28.3095	28.5	28.3	28.495	8458306.0
2003-01-14 16:00:00	MSFT	Stock	28.5	28.65	28.2905	28.425	2675530.0
2003-01-14 17:00:00	MSFT	Stock	28.425	28.555	28.415	28.48	251514.0
2003-01-14 18:00:00	MSFT	Stock	28.48	28.48	28.455	28.455	17000.0
2003-01-14 08:00:00	NVDA	Stock	0.1037	0.104	0.1021	0.1022	1824000.0
2003-01-14 09:00:00	NVDA	Stock	0.1023	0.1039	0.0999	0.1033	175942200.0
2003-01-14 10:00:00	NVDA	Stock	0.1033	0.1037	0.1012	0.1014	144120000.0
2003-01-14 11:00:00	NVDA	Stock	0.1013	0.1023	0.1013	0.1018	52659480.0
2003-01-14 12:00:00	NVDA	Stock	0.1018	0.1023	0.1015	0.1017	73014720.0
2003-01-14 13:00:00	NVDA	Stock	0.1016	0.1021	0.1013	0.1017	55595520.0
2003-01-14 14:00:00	NVDA	Stock	0.1017	0.1032	0.1013	0.1027	138514800.0
2003-01-14 15:00:00	NVDA	Stock	0.1027	0.104	0.1026	0.1027	165769680.0
2003-01-14 16:00:00	NVDA	Stock	0.1027	0.1046	0.1017	0.102	17302920.0
2003-01-14 17:00:00	NVDA	Stock	0.1027	0.1031	0.1025	0.1027	4788000.0
2003-01-14 18:00:00	NVDA	Stock	0.1025	0.1036	0.1025	0.103	2346360.0
2003-01-14 08:00:00	AMZN	Stock	1.1175	1.12	1.0935	1.1	693100.0
2003-01-14 09:00:00	AMZN	Stock	1.099	1.108	1.085	1.0925	19092400.0
2003-01-14 10:00:00	AMZN	Stock	1.0925	1.1045	1.083	1.0916	25168220.0
2003-01-14 11:00:00	AMZN	Stock	1.0915	1.101	1.09	1.099	9638460.0
2003-01-14 12:00:00	AMZN	Stock	1.1	1.111	1.099	1.1075	11431160.0
2003-01-14 13:00:00	AMZN	Stock	1.1085	1.1125	1.106	1.1095	9641720.0
2003-01-14 14:00:00	AMZN	Stock	1.1095	1.1205	1.107	1.1175	18580860.0
2003-01-14 15:00:00	AMZN	Stock	1.1175	1.1375	1.1165	1.1375	34820580.0
2003-01-14 16:00:00	AMZN	Stock	1.1375	1.142	1.1	1.1335	3144000.0
2003-01-14 17:00:00	AMZN	Stock	1.1335	1.1375	1.1335	1.1356	395400.0
2003-01-14 18:00:00	AMZN	Stock	1.139	1.139	1.139	1.139	20000.0
2003-01-14 09:00:00	CL	Stock	26.3	26.34	26.21	26.25	269400.0
2003-01-14 10:00:00	CL	Stock	26.26	26.31	26.195	26.25	375800.0
2003-01-14 11:00:00	CL	Stock	26.245	26.25	26.2	26.245	248400.0
2003-01-14 12:00:00	CL	Stock	26.25	26.29	26.19	26.235	217000.0
2003-01-14 13:00:00	CL	Stock	26.245	26.295	26.215	26.23	200400.0
2003-01-14 14:00:00	CL	Stock	26.235	26.265	26.21	26.26	212200.0
2003-01-14 15:00:00	CL	Stock	26.26	26.295	26.245	26.28	454400.0

> showing 50 of 19,743 rows — these rows as CSV

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