PREVIEW / stock_1hour / 2005-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-09.parquet
  size:    552 KB
  rows:    26,118
  symbols: 2,063

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-08-09 08:00:00	AAPL	Stock	1.5239	1.5268	1.5239	1.5268	16464.0
2005-08-09 09:00:00	AAPL	Stock	1.5304	1.5421	1.5304	1.5407	28869176.0
2005-08-09 10:00:00	AAPL	Stock	1.5407	1.5618	1.5361	1.5557	65749544.0
2005-08-09 11:00:00	AAPL	Stock	1.5564	1.5629	1.5525	1.5625	51364040.0
2005-08-09 12:00:00	AAPL	Stock	1.5625	1.5639	1.5536	1.5618	41049764.0
2005-08-09 13:00:00	AAPL	Stock	1.5618	1.5621	1.5579	1.5607	26234712.0
2005-08-09 14:00:00	AAPL	Stock	1.5607	1.5675	1.5564	1.5596	55300448.0
2005-08-09 15:00:00	AAPL	Stock	1.56	1.565	1.5575	1.565	102117120.0
2005-08-09 16:00:00	AAPL	Stock	1.5646	1.5714	1.5611	1.5675	5578636.0
2005-08-09 17:00:00	AAPL	Stock	1.5714	1.5714	1.5614	1.5625	457128.0
2005-08-09 18:00:00	AAPL	Stock	1.5618	1.5629	1.5618	1.5629	46760.0
2005-08-09 08:00:00	MSFT	Stock	27.2	27.23	27.13	27.2	91302.0
2005-08-09 09:00:00	MSFT	Stock	27.2	27.29	26.861	27.149	5617640.0
2005-08-09 10:00:00	MSFT	Stock	27.14	27.19	27.01	27.129	9855175.0
2005-08-09 11:00:00	MSFT	Stock	27.13	27.3	27.12	27.279	8277179.0
2005-08-09 12:00:00	MSFT	Stock	27.27	27.38	27.21	27.319	5210105.0
2005-08-09 13:00:00	MSFT	Stock	27.32	27.4	27.22	27.36	10466813.0
2005-08-09 14:00:00	MSFT	Stock	27.37	27.51	27.28	27.38	12982101.0
2005-08-09 15:00:00	MSFT	Stock	27.39	27.46	27.19	27.34	10199729.0
2005-08-09 16:00:00	MSFT	Stock	27.36	27.42	27.29	27.31	186420.0
2005-08-09 17:00:00	MSFT	Stock	27.35	27.35	27.25	27.25	644743.0
2005-08-09 18:00:00	MSFT	Stock	27.28	27.28	27.25	27.28	6800.0
2005-08-09 08:00:00	NVDA	Stock	0.2342	0.2342	0.2339	0.2339	648000.0
2005-08-09 09:00:00	NVDA	Stock	0.235	0.2372	0.2331	0.2337	66777360.0
2005-08-09 10:00:00	NVDA	Stock	0.2337	0.2357	0.2334	0.2354	44506920.0
2005-08-09 11:00:00	NVDA	Stock	0.2354	0.236	0.2351	0.2356	25830840.0
2005-08-09 12:00:00	NVDA	Stock	0.2356	0.2357	0.2341	0.2344	20797080.0
2005-08-09 13:00:00	NVDA	Stock	0.2344	0.2355	0.2342	0.2352	16880040.0
2005-08-09 14:00:00	NVDA	Stock	0.2352	0.2363	0.2345	0.2357	47872680.0
2005-08-09 15:00:00	NVDA	Stock	0.2358	0.2362	0.2346	0.2357	65917080.0
2005-08-09 16:00:00	NVDA	Stock	0.2357	0.2369	0.2356	0.2369	711600.0
2005-08-09 17:00:00	NVDA	Stock	0.2357	0.2357	0.2357	0.2357	37920.0
2005-08-09 08:00:00	AMZN	Stock	2.3	2.3	2.283	2.2875	40360.0
2005-08-09 09:00:00	AMZN	Stock	2.287	2.322	2.287	2.3135	14589240.0
2005-08-09 10:00:00	AMZN	Stock	2.3135	2.3175	2.31	2.3125	12006000.0
2005-08-09 11:00:00	AMZN	Stock	2.3125	2.316	2.312	2.3146	7118780.0
2005-08-09 12:00:00	AMZN	Stock	2.3145	2.3175	2.3125	2.313	7148000.0
2005-08-09 13:00:00	AMZN	Stock	2.313	2.317	2.3125	2.3131	7440040.0
2005-08-09 14:00:00	AMZN	Stock	2.313	2.3175	2.299	2.299	16317440.0
2005-08-09 15:00:00	AMZN	Stock	2.299	2.3005	2.292	2.297	23955600.0
2005-08-09 16:00:00	AMZN	Stock	2.2965	2.2975	2.2925	2.2965	1739580.0
2005-08-09 17:00:00	AMZN	Stock	2.2975	2.2975	2.2945	2.2965	1008000.0
2005-08-09 18:00:00	AMZN	Stock	2.2975	2.2975	2.294	2.294	73840.0
2005-08-09 09:00:00	CL	Stock	26.365	26.39	26.275	26.335	275800.0
2005-08-09 10:00:00	CL	Stock	26.34	26.365	26.31	26.365	231600.0
2005-08-09 11:00:00	CL	Stock	26.365	26.38	26.285	26.29	229400.0
2005-08-09 12:00:00	CL	Stock	26.29	26.305	26.255	26.3	241800.0
2005-08-09 13:00:00	CL	Stock	26.3	26.34	26.28	26.325	171200.0
2005-08-09 14:00:00	CL	Stock	26.325	26.385	26.28	26.29	287800.0
2005-08-09 15:00:00	CL	Stock	26.29	26.355	26.24	26.33	521400.0

> showing 50 of 26,118 rows — these rows as CSV

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