PREVIEW / stock_1hour / 2005-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-20.parquet
  size:    577 KB
  rows:    27,509
  symbols: 2,068

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
2005-09-20 07:00:00	AAPL	Stock	1.8929	1.8929	1.8929	1.8929	142800.0
2005-09-20 08:00:00	AAPL	Stock	1.8929	1.9068	1.8875	1.8996	5180560.0
2005-09-20 09:00:00	AAPL	Stock	1.8993	1.9068	1.88	1.9	99411116.0
2005-09-20 10:00:00	AAPL	Stock	1.9	1.9218	1.8964	1.9146	154172704.0
2005-09-20 11:00:00	AAPL	Stock	1.9146	1.9207	1.9093	1.9161	53498648.0
2005-09-20 12:00:00	AAPL	Stock	1.9161	1.9164	1.9104	1.9111	33987996.0
2005-09-20 13:00:00	AAPL	Stock	1.9118	1.9121	1.9014	1.9096	50201032.0
2005-09-20 14:00:00	AAPL	Stock	1.9096	1.9175	1.8946	1.8996	146236972.0
2005-09-20 15:00:00	AAPL	Stock	1.8996	1.9127	1.89	1.9011	143962168.0
2005-09-20 16:00:00	AAPL	Stock	1.8996	1.9054	1.8996	1.9021	49436576.0
2005-09-20 17:00:00	AAPL	Stock	1.9036	1.9054	1.8996	1.9046	524888.0
2005-09-20 18:00:00	AAPL	Stock	1.9018	1.9018	1.9	1.9018	92876.0
2005-09-20 08:00:00	MSFT	Stock	26.05	26.09	26.05	26.07	5985.0
2005-09-20 09:00:00	MSFT	Stock	26.07	26.18	26.01	26.12	5351422.0
2005-09-20 10:00:00	MSFT	Stock	26.11	26.22	26.1	26.16	8464643.0
2005-09-20 11:00:00	MSFT	Stock	26.17	26.181	26.07	26.11	3783815.0
2005-09-20 12:00:00	MSFT	Stock	26.12	26.15	26.07	26.109	2552606.0
2005-09-20 13:00:00	MSFT	Stock	26.11	26.11	25.96	25.97	6280270.0
2005-09-20 14:00:00	MSFT	Stock	25.96	26.12	25.79	25.81	12484113.0
2005-09-20 15:00:00	MSFT	Stock	25.81	26.112	25.69	25.84	17945043.0
2005-09-20 16:00:00	MSFT	Stock	25.85	25.85	25.741	25.81	362877.0
2005-09-20 17:00:00	MSFT	Stock	25.83	25.83	25.81	25.81	9280.0
2005-09-20 18:00:00	MSFT	Stock	25.81	26.03	25.81	26.03	50862.0
2005-09-20 08:00:00	NVDA	Stock	0.2749	0.2749	0.2747	0.2747	216000.0
2005-09-20 09:00:00	NVDA	Stock	0.2747	0.2776	0.2732	0.2774	67438560.0
2005-09-20 10:00:00	NVDA	Stock	0.2774	0.2809	0.2774	0.2795	93600360.0
2005-09-20 11:00:00	NVDA	Stock	0.2795	0.2807	0.2784	0.2804	46981440.0
2005-09-20 12:00:00	NVDA	Stock	0.2804	0.2816	0.2796	0.2805	36134760.0
2005-09-20 13:00:00	NVDA	Stock	0.2805	0.281	0.2795	0.2796	47562840.0
2005-09-20 14:00:00	NVDA	Stock	0.2797	0.2812	0.2773	0.2785	113837880.0
2005-09-20 15:00:00	NVDA	Stock	0.2786	0.2794	0.2772	0.2786	106192560.0
2005-09-20 16:00:00	NVDA	Stock	0.2785	0.2789	0.2782	0.2785	1143240.0
2005-09-20 17:00:00	NVDA	Stock	0.2785	0.2787	0.2785	0.2787	240000.0
2005-09-20 09:00:00	AMZN	Stock	2.1365	2.1505	2.1325	2.1385	4767380.0
2005-09-20 10:00:00	AMZN	Stock	2.1375	2.1385	2.1155	2.1315	8144660.0
2005-09-20 11:00:00	AMZN	Stock	2.1315	2.1355	2.1215	2.129	5720900.0
2005-09-20 12:00:00	AMZN	Stock	2.129	2.1345	2.125	2.126	3290220.0
2005-09-20 13:00:00	AMZN	Stock	2.126	2.1295	2.126	2.129	3528500.0
2005-09-20 14:00:00	AMZN	Stock	2.129	2.136	2.0985	2.0995	15372960.0
2005-09-20 15:00:00	AMZN	Stock	2.1	2.108	2.0885	2.0935	24992000.0
2005-09-20 16:00:00	AMZN	Stock	2.0945	2.117	2.093	2.0935	244000.0
2005-09-20 17:00:00	AMZN	Stock	2.094	2.095	2.094	2.095	70000.0
2005-09-20 09:00:00	CL	Stock	26.41	26.525	26.28	26.3	212800.0
2005-09-20 10:00:00	CL	Stock	26.305	26.425	26.255	26.39	652400.0
2005-09-20 11:00:00	CL	Stock	26.39	26.39	26.275	26.3	394000.0
2005-09-20 12:00:00	CL	Stock	26.3	26.305	26.255	26.26	247200.0
2005-09-20 13:00:00	CL	Stock	26.265	26.295	26.25	26.265	216400.0
2005-09-20 14:00:00	CL	Stock	26.27	26.37	26.25	26.255	572400.0
2005-09-20 15:00:00	CL	Stock	26.26	26.31	26.195	26.28	694000.0
2005-09-20 16:00:00	CL	Stock	26.295	26.295	26.295	26.295	5800.0

> showing 50 of 27,509 rows — these rows as CSV

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