PREVIEW / stock_1hour / 2007-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-10.parquet
  size:    763 KB
  rows:    37,274
  symbols: 3,066

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
2007-07-10 09:00:00	AAPL	Stock	4.6029	4.7429	4.6004	4.7336	264353376.0
2007-07-10 10:00:00	AAPL	Stock	4.7332	4.8036	4.7286	4.7779	350295568.0
2007-07-10 11:00:00	AAPL	Stock	4.7779	4.7868	4.7671	4.7732	108815420.0
2007-07-10 12:00:00	AAPL	Stock	4.7736	4.7764	4.7023	4.7589	82774104.0
2007-07-10 13:00:00	AAPL	Stock	4.7593	4.7646	4.7061	4.7204	157273480.0
2007-07-10 14:00:00	AAPL	Stock	4.7207	4.7536	4.7107	4.7336	111484520.0
2007-07-10 15:00:00	AAPL	Stock	4.7339	4.7354	4.7171	4.7293	126396340.0
2007-07-10 16:00:00	AAPL	Stock	4.7283	4.7293	4.7268	4.7268	12811344.0
2007-07-10 09:00:00	MSFT	Stock	29.7	29.92	29.69	29.89	3874507.0
2007-07-10 10:00:00	MSFT	Stock	29.89	29.99	29.83	29.86	5990861.0
2007-07-10 11:00:00	MSFT	Stock	29.86	29.95	29.8	29.825	5407556.0
2007-07-10 12:00:00	MSFT	Stock	29.821	29.88	29.786	29.82	3528310.0
2007-07-10 13:00:00	MSFT	Stock	29.825	29.84	29.5	29.53	10413534.0
2007-07-10 14:00:00	MSFT	Stock	29.53	29.61	29.35	29.42	11220965.0
2007-07-10 15:00:00	MSFT	Stock	29.43	29.43	29.18	29.37	20063765.0
2007-07-10 16:00:00	MSFT	Stock	29.37	29.37	29.33	29.33	1561563.0
2007-07-10 09:00:00	NVDA	Stock	0.7482	0.7517	0.7388	0.7508	81721320.0
2007-07-10 10:00:00	NVDA	Stock	0.7508	0.761	0.7495	0.7598	133000860.0
2007-07-10 11:00:00	NVDA	Stock	0.7598	0.7625	0.758	0.7597	59717340.0
2007-07-10 12:00:00	NVDA	Stock	0.7597	0.76	0.7517	0.7587	46796400.0
2007-07-10 13:00:00	NVDA	Stock	0.7587	0.7595	0.752	0.7532	57461400.0
2007-07-10 14:00:00	NVDA	Stock	0.753	0.757	0.7515	0.7553	46093680.0
2007-07-10 15:00:00	NVDA	Stock	0.7553	0.7595	0.754	0.7582	103109340.0
2007-07-10 16:00:00	NVDA	Stock	0.758	0.7583	0.7549	0.7583	2661600.0
2007-07-10 17:00:00	NVDA	Stock	0.7583	0.7583	0.7575	0.7575	84120.0
2007-07-10 18:00:00	NVDA	Stock	0.7592	0.7592	0.7583	0.7583	143100.0
2007-07-10 19:00:00	NVDA	Stock	0.7582	0.7582	0.7582	0.7582	12000.0
2007-07-10 07:00:00	AMZN	Stock	3.5805	3.5805	3.575	3.5785	11500.0
2007-07-10 08:00:00	AMZN	Stock	3.5935	3.595	3.575	3.585	291900.0
2007-07-10 09:00:00	AMZN	Stock	3.5825	3.597	3.525	3.5375	43556300.0
2007-07-10 10:00:00	AMZN	Stock	3.5375	3.5825	3.532	3.549	35893180.0
2007-07-10 11:00:00	AMZN	Stock	3.5485	3.5525	3.5335	3.5485	11736160.0
2007-07-10 12:00:00	AMZN	Stock	3.5485	3.5719	3.5405	3.544	9473640.0
2007-07-10 13:00:00	AMZN	Stock	3.5435	3.55	3.508	3.5145	18776360.0
2007-07-10 14:00:00	AMZN	Stock	3.5135	3.5265	3.506	3.51	15920260.0
2007-07-10 15:00:00	AMZN	Stock	3.5098	3.52	3.5035	3.5145	25560360.0
2007-07-10 16:00:00	AMZN	Stock	3.515	3.5376	3.5103	3.5245	2965160.0
2007-07-10 17:00:00	AMZN	Stock	3.5205	3.5295	3.52	3.5295	187000.0
2007-07-10 18:00:00	AMZN	Stock	3.5295	3.5295	3.525	3.5295	28000.0
2007-07-10 09:00:00	TLT	Stock	84.48	84.64	84.44	84.44	316200.0
2007-07-10 10:00:00	TLT	Stock	84.45	84.7	84.43	84.61	783600.0
2007-07-10 11:00:00	TLT	Stock	84.63	84.65	84.48	84.51	115700.0
2007-07-10 12:00:00	TLT	Stock	84.49	84.65	84.48	84.58	69568.0
2007-07-10 13:00:00	TLT	Stock	84.6	84.84	84.51	84.8	223900.0
2007-07-10 14:00:00	TLT	Stock	84.81	84.93	84.77	84.93	201900.0
2007-07-10 15:00:00	TLT	Stock	84.94	85.08	84.92	85.03	476400.0
2007-07-10 16:00:00	TLT	Stock	85.07	85.2	85.04	85.2	38900.0
2007-07-10 09:00:00	CL	Stock	32.98	33.015	32.84	32.91	469936.0
2007-07-10 10:00:00	CL	Stock	32.9	33.03	32.875	33.01	584200.0
2007-07-10 11:00:00	CL	Stock	33.0	33.105	32.985	33.095	584400.0

> showing 50 of 37,274 rows — these rows as CSV

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