PREVIEW / stock_1hour / 2003-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-06.parquet
  size:    441 KB
  rows:    20,909
  symbols: 1,526

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-06 08:00:00	AAPL	Stock	0.2677	0.2682	0.2671	0.2675	734552.0
2003-01-06 09:00:00	AAPL	Stock	0.2679	0.2746	0.2673	0.2721	50878296.0
2003-01-06 10:00:00	AAPL	Stock	0.2723	0.2745	0.27	0.272	80802288.0
2003-01-06 11:00:00	AAPL	Stock	0.2719	0.2725	0.2696	0.2702	36384880.0
2003-01-06 12:00:00	AAPL	Stock	0.2702	0.2709	0.2695	0.2709	41772080.0
2003-01-06 13:00:00	AAPL	Stock	0.2707	0.2714	0.2686	0.2688	22368360.0
2003-01-06 14:00:00	AAPL	Stock	0.2688	0.2696	0.2673	0.268	53132912.0
2003-01-06 15:00:00	AAPL	Stock	0.268	0.2688	0.2657	0.2664	66836000.0
2003-01-06 16:00:00	AAPL	Stock	0.2659	0.267	0.2621	0.2661	11475744.0
2003-01-06 17:00:00	AAPL	Stock	0.2661	0.2661	0.2634	0.2655	517328.0
2003-01-06 18:00:00	AAPL	Stock	0.267	0.267	0.267	0.267	11200.0
2003-01-06 08:00:00	MSFT	Stock	27.035	27.13	26.85	27.0	267500.0
2003-01-06 09:00:00	MSFT	Stock	26.995	27.175	26.9	27.15	6709044.0
2003-01-06 10:00:00	MSFT	Stock	27.155	27.345	27.03	27.29	10409484.0
2003-01-06 11:00:00	MSFT	Stock	27.295	27.431	27.265	27.38	6746884.0
2003-01-06 12:00:00	MSFT	Stock	27.38	27.42	27.285	27.355	5597246.0
2003-01-06 13:00:00	MSFT	Stock	27.35	27.5	27.31	27.46	5955930.0
2003-01-06 14:00:00	MSFT	Stock	27.465	27.585	27.45	27.56	5644814.0
2003-01-06 15:00:00	MSFT	Stock	27.56	27.615	27.35	27.385	10469122.0
2003-01-06 16:00:00	MSFT	Stock	27.3855	27.49	27.33	27.395	1376180.0
2003-01-06 17:00:00	MSFT	Stock	27.46	27.5	27.385	27.5	53836.0
2003-01-06 18:00:00	MSFT	Stock	27.48	27.52	27.455	27.455	46918.0
2003-01-06 08:00:00	NVDA	Stock	0.1033	0.1049	0.1033	0.1046	276000.0
2003-01-06 09:00:00	NVDA	Stock	0.1046	0.1079	0.1026	0.1071	170157840.0
2003-01-06 10:00:00	NVDA	Stock	0.1071	0.1082	0.1062	0.1078	150802080.0
2003-01-06 11:00:00	NVDA	Stock	0.1077	0.1092	0.1074	0.109	98503920.0
2003-01-06 12:00:00	NVDA	Stock	0.109	0.1107	0.1089	0.1105	116876040.0
2003-01-06 13:00:00	NVDA	Stock	0.1107	0.1122	0.1105	0.1112	126804840.0
2003-01-06 14:00:00	NVDA	Stock	0.1111	0.1125	0.1111	0.1123	80563680.0
2003-01-06 15:00:00	NVDA	Stock	0.1123	0.1126	0.1104	0.111	188748120.0
2003-01-06 16:00:00	NVDA	Stock	0.111	0.1132	0.1105	0.1111	15009840.0
2003-01-06 17:00:00	NVDA	Stock	0.113	0.1133	0.1076	0.1076	1857600.0
2003-01-06 18:00:00	NVDA	Stock	0.1127	0.1137	0.1127	0.1137	489720.0
2003-01-06 08:00:00	AMZN	Stock	1.025	1.0255	1.011	1.02	244400.0
2003-01-06 09:00:00	AMZN	Stock	1.018	1.0415	1.015	1.0271	26699840.0
2003-01-06 10:00:00	AMZN	Stock	1.0275	1.033	1.0175	1.0325	27880980.0
2003-01-06 11:00:00	AMZN	Stock	1.032	1.0405	1.03	1.0354	16371740.0
2003-01-06 12:00:00	AMZN	Stock	1.0354	1.0435	1.0315	1.0335	11257640.0
2003-01-06 13:00:00	AMZN	Stock	1.034	1.041	1.0325	1.036	7999440.0
2003-01-06 14:00:00	AMZN	Stock	1.0365	1.0574	1.035	1.055	14358060.0
2003-01-06 15:00:00	AMZN	Stock	1.056	1.0585	1.0337	1.035	31047640.0
2003-01-06 16:00:00	AMZN	Stock	1.035	1.0382	1.0216	1.037	3045300.0
2003-01-06 17:00:00	AMZN	Stock	1.037	1.037	1.034	1.036	370000.0
2003-01-06 09:00:00	CL	Stock	26.58	26.65	26.555	26.65	185400.0
2003-01-06 10:00:00	CL	Stock	26.65	26.95	26.645	26.89	228200.0
2003-01-06 11:00:00	CL	Stock	26.89	26.975	26.87	26.965	214400.0
2003-01-06 12:00:00	CL	Stock	26.965	27.03	26.95	27.03	268400.0
2003-01-06 13:00:00	CL	Stock	27.03	27.145	27.005	27.015	341400.0
2003-01-06 14:00:00	CL	Stock	27.05	27.175	27.015	27.1	466400.0
2003-01-06 15:00:00	CL	Stock	27.105	27.225	27.1	27.155	578600.0

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

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