PREVIEW / stock_1hour / 2007-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-17.parquet
  size:    683 KB
  rows:    32,105
  symbols: 2,582

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-04-17 07:00:00	AAPL	Stock	3.2518	3.2518	3.2232	3.2357	684600.0
2007-04-17 08:00:00	AAPL	Stock	3.2425	3.305	3.2357	3.2982	6523384.0
2007-04-17 09:00:00	AAPL	Stock	3.2971	3.2982	3.2379	3.2511	117469212.0
2007-04-17 10:00:00	AAPL	Stock	3.2511	3.2543	3.2357	3.2471	111332704.0
2007-04-17 11:00:00	AAPL	Stock	3.2475	3.25	3.225	3.2282	98247800.0
2007-04-17 12:00:00	AAPL	Stock	3.2286	3.2289	3.2039	3.2105	125848212.0
2007-04-17 13:00:00	AAPL	Stock	3.2104	3.2189	3.2036	3.2171	70430276.0
2007-04-17 14:00:00	AAPL	Stock	3.2175	3.2411	3.2168	3.2329	104266288.0
2007-04-17 15:00:00	AAPL	Stock	3.2332	3.2857	3.22	3.2268	103945156.0
2007-04-17 16:00:00	AAPL	Stock	3.2268	3.2304	3.2214	3.225	3228736.0
2007-04-17 17:00:00	AAPL	Stock	3.2221	3.2268	3.2179	3.2264	1789592.0
2007-04-17 18:00:00	AAPL	Stock	3.2268	3.2268	3.2186	3.2196	316736.0
2007-04-17 19:00:00	AAPL	Stock	3.2179	3.2179	3.2143	3.2143	124600.0
2007-04-17 08:00:00	MSFT	Stock	28.7	28.77	28.63	28.77	18495.0
2007-04-17 09:00:00	MSFT	Stock	28.77	28.78	28.56	28.69	4637960.0
2007-04-17 10:00:00	MSFT	Stock	28.69	28.75	28.63	28.71	4958802.0
2007-04-17 11:00:00	MSFT	Stock	28.71	28.75	28.67	28.74	2287548.0
2007-04-17 12:00:00	MSFT	Stock	28.73	28.74	28.65	28.67	2438974.0
2007-04-17 13:00:00	MSFT	Stock	28.67	28.75	28.65	28.74	2341093.0
2007-04-17 14:00:00	MSFT	Stock	28.75	28.89	28.7	28.87	6123389.0
2007-04-17 15:00:00	MSFT	Stock	28.87	28.89	28.78	28.87	7862618.0
2007-04-17 16:00:00	MSFT	Stock	28.87	28.89	28.75	28.84	223288.0
2007-04-17 17:00:00	MSFT	Stock	28.84	28.85	28.75	28.84	1311.0
2007-04-17 08:00:00	NVDA	Stock	0.5067	0.5163	0.505	0.5163	2993640.0
2007-04-17 09:00:00	NVDA	Stock	0.5145	0.5317	0.5133	0.5238	205919460.0
2007-04-17 10:00:00	NVDA	Stock	0.5238	0.527	0.517	0.5202	222097800.0
2007-04-17 11:00:00	NVDA	Stock	0.5203	0.5245	0.515	0.5183	123010740.0
2007-04-17 12:00:00	NVDA	Stock	0.5183	0.5237	0.5132	0.5133	104264220.0
2007-04-17 13:00:00	NVDA	Stock	0.5135	0.5135	0.5093	0.5117	94508580.0
2007-04-17 14:00:00	NVDA	Stock	0.5118	0.5137	0.5113	0.5122	105883440.0
2007-04-17 15:00:00	NVDA	Stock	0.5122	0.5132	0.5095	0.5117	147778320.0
2007-04-17 16:00:00	NVDA	Stock	0.5115	0.518	0.5103	0.5157	23814960.0
2007-04-17 17:00:00	NVDA	Stock	0.5158	0.5158	0.5135	0.5135	189420.0
2007-04-17 18:00:00	NVDA	Stock	0.5153	0.5167	0.515	0.5157	135780.0
2007-04-17 19:00:00	NVDA	Stock	0.5143	0.5143	0.5143	0.5143	90000.0
2007-04-17 08:00:00	AMZN	Stock	2.25	2.2575	2.247	2.2575	238600.0
2007-04-17 09:00:00	AMZN	Stock	2.2555	2.267	2.2425	2.2475	21662160.0
2007-04-17 10:00:00	AMZN	Stock	2.248	2.2555	2.245	2.25	24004040.0
2007-04-17 11:00:00	AMZN	Stock	2.25	2.2525	2.2455	2.2475	14306940.0
2007-04-17 12:00:00	AMZN	Stock	2.248	2.2515	2.2435	2.244	11251140.0
2007-04-17 13:00:00	AMZN	Stock	2.244	2.248	2.2375	2.2424	15770980.0
2007-04-17 14:00:00	AMZN	Stock	2.2425	2.25	2.238	2.2496	22161180.0
2007-04-17 15:00:00	AMZN	Stock	2.2496	2.253	2.242	2.253	28697960.0
2007-04-17 16:00:00	AMZN	Stock	2.253	2.2565	2.24	2.247	2645900.0
2007-04-17 17:00:00	AMZN	Stock	2.246	2.2495	2.2405	2.2495	314800.0
2007-04-17 18:00:00	AMZN	Stock	2.2485	2.253	2.245	2.246	324000.0
2007-04-17 19:00:00	AMZN	Stock	2.246	2.247	2.246	2.246	32000.0
2007-04-17 09:00:00	CL	Stock	33.055	33.24	32.99	33.235	432600.0
2007-04-17 10:00:00	CL	Stock	33.245	33.305	33.14	33.15	562800.0
2007-04-17 11:00:00	CL	Stock	33.145	33.22	33.115	33.22	297800.0

> showing 50 of 32,105 rows — these rows as CSV

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