PREVIEW / stock_1hour / 2003-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-04-14.parquet
  size:    417 KB
  rows:    20,942
  symbols: 1,565

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-04-14 08:00:00	AAPL	Stock	0.2446	0.2446	0.2402	0.2445	6804392.0
2003-04-14 09:00:00	AAPL	Stock	0.2434	0.2455	0.2411	0.242	149891728.0
2003-04-14 10:00:00	AAPL	Stock	0.242	0.2429	0.2411	0.2423	64430912.0
2003-04-14 11:00:00	AAPL	Stock	0.2423	0.2446	0.2421	0.2436	53373376.0
2003-04-14 12:00:00	AAPL	Stock	0.2436	0.2446	0.2423	0.2432	44709000.0
2003-04-14 13:00:00	AAPL	Stock	0.2432	0.2443	0.2423	0.2434	30198784.0
2003-04-14 14:00:00	AAPL	Stock	0.2434	0.2438	0.2418	0.2427	28326536.0
2003-04-14 15:00:00	AAPL	Stock	0.2429	0.243	0.2411	0.2429	75798576.0
2003-04-14 16:00:00	AAPL	Stock	0.2429	0.2432	0.2414	0.2425	3858400.0
2003-04-14 17:00:00	AAPL	Stock	0.2425	0.2425	0.237	0.2414	1876000.0
2003-04-14 08:00:00	MSFT	Stock	24.4	24.45	24.07	24.3	79580.0
2003-04-14 09:00:00	MSFT	Stock	24.3	24.389	24.07	24.34	7500417.0
2003-04-14 10:00:00	MSFT	Stock	24.34	24.4	24.23	24.33	6186373.0
2003-04-14 11:00:00	MSFT	Stock	24.34	24.57	24.29	24.55	6946135.0
2003-04-14 12:00:00	MSFT	Stock	24.55	24.74	24.53	24.73	5101066.0
2003-04-14 13:00:00	MSFT	Stock	24.72	24.75	24.57	24.68	3732549.0
2003-04-14 14:00:00	MSFT	Stock	24.69	24.711	24.48	24.53	4931106.0
2003-04-14 15:00:00	MSFT	Stock	24.52	24.88	24.52	24.752	10807480.0
2003-04-14 16:00:00	MSFT	Stock	24.7511	24.85	24.4878	24.81	1282147.0
2003-04-14 17:00:00	MSFT	Stock	24.84	24.97	24.2	24.75	728229.0
2003-04-14 18:00:00	MSFT	Stock	24.75	24.78	24.75	24.78	4280.0
2003-04-14 09:00:00	NVDA	Stock	0.1103	0.1108	0.1083	0.1102	85989480.0
2003-04-14 10:00:00	NVDA	Stock	0.1102	0.1104	0.1089	0.1098	67834800.0
2003-04-14 11:00:00	NVDA	Stock	0.1098	0.1114	0.1098	0.1112	52431960.0
2003-04-14 12:00:00	NVDA	Stock	0.1112	0.1116	0.1107	0.1114	50869320.0
2003-04-14 13:00:00	NVDA	Stock	0.1114	0.1121	0.1113	0.1117	46578000.0
2003-04-14 14:00:00	NVDA	Stock	0.1117	0.1117	0.1112	0.1112	27337440.0
2003-04-14 15:00:00	NVDA	Stock	0.1112	0.1127	0.1112	0.1123	77895120.0
2003-04-14 16:00:00	NVDA	Stock	0.1123	0.1142	0.1118	0.1122	13169280.0
2003-04-14 17:00:00	NVDA	Stock	0.1122	0.1124	0.1103	0.1117	2394480.0
2003-04-14 18:00:00	NVDA	Stock	0.1117	0.1117	0.1104	0.1104	53520.0
2003-04-14 08:00:00	AMZN	Stock	1.255	1.2865	1.225	1.2865	1209200.0
2003-04-14 09:00:00	AMZN	Stock	1.2475	1.286	1.225	1.2325	56227480.0
2003-04-14 10:00:00	AMZN	Stock	1.232	1.24	1.23	1.2395	31289000.0
2003-04-14 11:00:00	AMZN	Stock	1.239	1.2455	1.234	1.245	23620980.0
2003-04-14 12:00:00	AMZN	Stock	1.245	1.25	1.2425	1.25	19531740.0
2003-04-14 13:00:00	AMZN	Stock	1.25	1.2502	1.243	1.245	8461840.0
2003-04-14 14:00:00	AMZN	Stock	1.2454	1.2485	1.2415	1.2445	13011340.0
2003-04-14 15:00:00	AMZN	Stock	1.244	1.2575	1.2425	1.2515	25860260.0
2003-04-14 16:00:00	AMZN	Stock	1.2515	1.254	1.2475	1.2525	5358000.0
2003-04-14 17:00:00	AMZN	Stock	1.2525	1.2575	1.2504	1.2504	895000.0
2003-04-14 18:00:00	AMZN	Stock	1.25	1.253	1.25	1.25	20000.0
2003-04-14 09:00:00	CL	Stock	27.775	28.03	27.77	27.985	215400.0
2003-04-14 10:00:00	CL	Stock	27.995	28.1	27.9	27.955	323400.0
2003-04-14 11:00:00	CL	Stock	27.955	28.15	27.925	28.075	313800.0
2003-04-14 12:00:00	CL	Stock	28.065	28.16	28.03	28.155	166400.0
2003-04-14 13:00:00	CL	Stock	28.155	28.155	28.025	28.105	203800.0
2003-04-14 14:00:00	CL	Stock	28.12	28.205	28.035	28.065	327000.0
2003-04-14 15:00:00	CL	Stock	28.075	28.35	28.075	28.29	618600.0
2003-04-14 16:00:00	CL	Stock	28.31	28.31	28.3	28.31	50200.0

> showing 50 of 20,942 rows — these rows as CSV

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