PREVIEW / stock_1hour / 2007-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-20.parquet
  size:    691 KB
  rows:    32,696
  symbols: 2,587

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-20 06:00:00	AAPL	Stock	3.25	3.25	3.2414	3.2414	16800.0
2007-04-20 07:00:00	AAPL	Stock	3.255	3.2564	3.2489	3.2518	206444.0
2007-04-20 08:00:00	AAPL	Stock	3.2489	3.2504	3.2432	3.2475	2125116.0
2007-04-20 09:00:00	AAPL	Stock	3.2475	3.2536	3.2354	3.24	136274712.0
2007-04-20 10:00:00	AAPL	Stock	3.2396	3.2521	3.2343	3.2382	77271628.0
2007-04-20 11:00:00	AAPL	Stock	3.2382	3.2429	3.2343	3.2368	50024464.0
2007-04-20 12:00:00	AAPL	Stock	3.2368	3.2411	3.2339	3.2386	32834424.0
2007-04-20 13:00:00	AAPL	Stock	3.2389	3.2479	3.2375	3.2413	47960780.0
2007-04-20 14:00:00	AAPL	Stock	3.2411	3.2439	3.2375	3.2429	50009960.0
2007-04-20 15:00:00	AAPL	Stock	3.2425	3.2564	3.2371	3.2486	109485992.0
2007-04-20 16:00:00	AAPL	Stock	3.2486	3.2529	3.2454	3.2489	7658840.0
2007-04-20 17:00:00	AAPL	Stock	3.2489	3.2532	3.2482	3.2496	397068.0
2007-04-20 18:00:00	AAPL	Stock	3.2496	3.25	3.2482	3.2482	236768.0
2007-04-20 19:00:00	AAPL	Stock	3.2482	3.2532	3.2471	3.25	193144.0
2007-04-20 07:00:00	MSFT	Stock	28.81	28.81	28.81	28.81	500.0
2007-04-20 08:00:00	MSFT	Stock	28.84	28.84	28.7	28.83	16160.0
2007-04-20 09:00:00	MSFT	Stock	28.83	29.0	28.7	28.98	17366734.0
2007-04-20 10:00:00	MSFT	Stock	28.97	29.1	28.95	28.97	10227121.0
2007-04-20 11:00:00	MSFT	Stock	28.97	28.99	28.89	28.89	4770473.0
2007-04-20 12:00:00	MSFT	Stock	28.892	28.95	28.79	28.841	5960861.0
2007-04-20 13:00:00	MSFT	Stock	28.84	28.9	28.8	28.83	3765211.0
2007-04-20 14:00:00	MSFT	Stock	28.83	28.99	28.82	28.97	4135229.0
2007-04-20 15:00:00	MSFT	Stock	28.97	29.03	28.9	29.02	10091372.0
2007-04-20 16:00:00	MSFT	Stock	29.02	29.06	29.0	29.02	748669.0
2007-04-20 17:00:00	MSFT	Stock	29.03	29.05	29.03	29.05	2700.0
2007-04-20 18:00:00	MSFT	Stock	29.05	29.05	29.03	29.03	3567.0
2007-04-20 19:00:00	MSFT	Stock	29.03	29.05	29.03	29.03	2199.0
2007-04-20 08:00:00	NVDA	Stock	0.5317	0.5333	0.5317	0.5325	72000.0
2007-04-20 09:00:00	NVDA	Stock	0.5302	0.5333	0.5292	0.5313	121631280.0
2007-04-20 10:00:00	NVDA	Stock	0.5313	0.5327	0.5245	0.5258	147700800.0
2007-04-20 11:00:00	NVDA	Stock	0.5258	0.5277	0.5245	0.5253	71069280.0
2007-04-20 12:00:00	NVDA	Stock	0.5253	0.527	0.525	0.5263	42340200.0
2007-04-20 13:00:00	NVDA	Stock	0.5263	0.5307	0.5258	0.5293	46709880.0
2007-04-20 14:00:00	NVDA	Stock	0.5295	0.5323	0.5292	0.5322	59036340.0
2007-04-20 15:00:00	NVDA	Stock	0.5322	0.5325	0.5305	0.5315	86354940.0
2007-04-20 16:00:00	NVDA	Stock	0.5315	0.535	0.5285	0.5312	3420240.0
2007-04-20 19:00:00	NVDA	Stock	0.5308	0.5308	0.5292	0.5292	90000.0
2007-04-20 08:00:00	AMZN	Stock	2.2375	2.2475	2.2375	2.2455	58000.0
2007-04-20 09:00:00	AMZN	Stock	2.2455	2.2585	2.2395	2.249	22304560.0
2007-04-20 10:00:00	AMZN	Stock	2.2485	2.252	2.2425	2.246	10746740.0
2007-04-20 11:00:00	AMZN	Stock	2.246	2.247	2.2335	2.236	13672420.0
2007-04-20 12:00:00	AMZN	Stock	2.236	2.245	2.226	2.234	11840360.0
2007-04-20 13:00:00	AMZN	Stock	2.2336	2.2455	2.2325	2.2431	8960780.0
2007-04-20 14:00:00	AMZN	Stock	2.2425	2.25	2.2425	2.249	8116720.0
2007-04-20 15:00:00	AMZN	Stock	2.249	2.25	2.24	2.2485	28293440.0
2007-04-20 16:00:00	AMZN	Stock	2.2485	2.2485	2.24	2.2415	2648260.0
2007-04-20 17:00:00	AMZN	Stock	2.244	2.244	2.244	2.244	4000.0
2007-04-20 18:00:00	AMZN	Stock	2.245	2.245	2.245	2.245	6000.0
2007-04-20 19:00:00	AMZN	Stock	2.245	2.245	2.245	2.245	6000.0
2007-04-20 08:00:00	CL	Stock	33.49	33.5	33.49	33.5	2800.0

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

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