PREVIEW / stock_1hour / 2007-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-19.parquet
  size:    693 KB
  rows:    32,689
  symbols: 2,575

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-19 04:00:00	AAPL	Stock	3.2057	3.2057	3.2057	3.2057	2800.0
2007-04-19 06:00:00	AAPL	Stock	3.2143	3.2143	3.2075	3.2075	16800.0
2007-04-19 07:00:00	AAPL	Stock	3.2236	3.2236	3.2236	3.2236	26628.0
2007-04-19 08:00:00	AAPL	Stock	3.2179	3.2211	3.2107	3.215	639520.0
2007-04-19 09:00:00	AAPL	Stock	3.215	3.2525	3.2082	3.2461	84543228.0
2007-04-19 10:00:00	AAPL	Stock	3.2461	3.2536	3.2321	3.2407	77167300.0
2007-04-19 11:00:00	AAPL	Stock	3.2411	3.2589	3.2371	3.2475	68714772.0
2007-04-19 12:00:00	AAPL	Stock	3.2475	3.2518	3.2364	3.2386	45376492.0
2007-04-19 13:00:00	AAPL	Stock	3.2386	3.2432	3.2236	3.2275	40515720.0
2007-04-19 14:00:00	AAPL	Stock	3.2271	3.2318	3.215	3.2161	41882092.0
2007-04-19 15:00:00	AAPL	Stock	3.2161	3.2304	3.2146	3.2239	54835648.0
2007-04-19 16:00:00	AAPL	Stock	3.22	3.2286	3.215	3.2246	4536588.0
2007-04-19 17:00:00	AAPL	Stock	3.2246	3.2275	3.2214	3.2214	1242696.0
2007-04-19 18:00:00	AAPL	Stock	3.2214	3.225	3.2214	3.225	279888.0
2007-04-19 19:00:00	AAPL	Stock	3.2192	3.2282	3.2189	3.2282	121604.0
2007-04-19 08:00:00	MSFT	Stock	28.45	28.45	28.37	28.39	11670.0
2007-04-19 09:00:00	MSFT	Stock	28.39	28.66	28.26	28.55	5599990.0
2007-04-19 10:00:00	MSFT	Stock	28.545	28.74	28.5	28.7	7248802.0
2007-04-19 11:00:00	MSFT	Stock	28.7	28.89	28.65	28.86	5026774.0
2007-04-19 12:00:00	MSFT	Stock	28.85	28.88	28.74	28.76	4290078.0
2007-04-19 13:00:00	MSFT	Stock	28.76	28.77	28.66	28.69	3009142.0
2007-04-19 14:00:00	MSFT	Stock	28.69	28.76	28.64	28.67	7208838.0
2007-04-19 15:00:00	MSFT	Stock	28.67	28.71	28.56	28.68	8237881.0
2007-04-19 16:00:00	MSFT	Stock	28.69	28.72	28.68	28.68	1268544.0
2007-04-19 17:00:00	MSFT	Stock	28.68	28.74	28.68	28.74	1179503.0
2007-04-19 18:00:00	MSFT	Stock	28.71	28.73	28.71	28.73	4200.0
2007-04-19 19:00:00	MSFT	Stock	28.73	28.73	28.71	28.71	2600.0
2007-04-19 08:00:00	NVDA	Stock	0.5167	0.5167	0.512	0.512	257880.0
2007-04-19 09:00:00	NVDA	Stock	0.5125	0.5212	0.5118	0.5205	57708840.0
2007-04-19 10:00:00	NVDA	Stock	0.5203	0.5217	0.5168	0.5192	69327420.0
2007-04-19 11:00:00	NVDA	Stock	0.5192	0.5235	0.5173	0.5228	64932360.0
2007-04-19 12:00:00	NVDA	Stock	0.5227	0.5265	0.5218	0.5242	68970780.0
2007-04-19 13:00:00	NVDA	Stock	0.5242	0.527	0.5242	0.5255	60549540.0
2007-04-19 14:00:00	NVDA	Stock	0.5254	0.5283	0.5242	0.5263	120694620.0
2007-04-19 15:00:00	NVDA	Stock	0.5263	0.5268	0.5237	0.5255	110429040.0
2007-04-19 16:00:00	NVDA	Stock	0.5255	0.5255	0.5247	0.5247	1856160.0
2007-04-19 17:00:00	NVDA	Stock	0.525	0.5267	0.525	0.5253	1566000.0
2007-04-19 19:00:00	NVDA	Stock	0.525	0.525	0.525	0.525	12000.0
2007-04-19 08:00:00	AMZN	Stock	2.245	2.245	2.23	2.23	54840.0
2007-04-19 09:00:00	AMZN	Stock	2.2325	2.2425	2.2205	2.2325	13804960.0
2007-04-19 10:00:00	AMZN	Stock	2.2316	2.2475	2.2305	2.24	10899700.0
2007-04-19 11:00:00	AMZN	Stock	2.2396	2.245	2.2305	2.242	13022920.0
2007-04-19 12:00:00	AMZN	Stock	2.2421	2.2535	2.241	2.252	8734000.0
2007-04-19 13:00:00	AMZN	Stock	2.252	2.2575	2.2385	2.239	11506700.0
2007-04-19 14:00:00	AMZN	Stock	2.239	2.2411	2.231	2.233	8607740.0
2007-04-19 15:00:00	AMZN	Stock	2.233	2.236	2.2245	2.2315	25644960.0
2007-04-19 16:00:00	AMZN	Stock	2.232	2.24	2.2305	2.2375	349480.0
2007-04-19 18:00:00	AMZN	Stock	2.2325	2.2325	2.2325	2.2325	6000.0
2007-04-19 19:00:00	AMZN	Stock	2.2305	2.2305	2.2305	2.2305	10000.0
2007-04-19 09:00:00	CL	Stock	33.795	33.795	33.25	33.4	373800.0

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

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