PREVIEW / stock_1hour / 2009-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-07.parquet
  size:    829 KB
  rows:    40,592
  symbols: 3,325

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
2009-01-07 07:00:00	AAPL	Stock	3.2875	3.2875	3.2875	3.2875	23800.0
2009-01-07 08:00:00	AAPL	Stock	3.3	3.3036	3.2704	3.2904	2242072.0
2009-01-07 09:00:00	AAPL	Stock	3.2879	3.295	3.2386	3.29	122595816.0
2009-01-07 10:00:00	AAPL	Stock	3.2904	3.2979	3.2321	3.2721	130734268.0
2009-01-07 11:00:00	AAPL	Stock	3.2721	3.2911	3.2596	3.2739	80769164.0
2009-01-07 12:00:00	AAPL	Stock	3.2743	3.3036	3.2661	3.2857	68534004.0
2009-01-07 13:00:00	AAPL	Stock	3.2864	3.2907	3.2454	3.2471	80455620.0
2009-01-07 14:00:00	AAPL	Stock	3.2468	3.2596	3.2275	3.2425	94920980.0
2009-01-07 15:00:00	AAPL	Stock	3.2421	3.25	3.2236	3.25	134393560.0
2009-01-07 16:00:00	AAPL	Stock	3.25	3.2594	3.2375	3.2536	21296268.0
2009-01-07 17:00:00	AAPL	Stock	3.2532	3.2536	3.25	3.2507	11076240.0
2009-01-07 18:00:00	AAPL	Stock	3.2507	3.2507	3.2464	3.2464	4025812.0
2009-01-07 19:00:00	AAPL	Stock	3.2464	3.2564	3.2464	3.2564	173992.0
2009-01-07 08:00:00	MSFT	Stock	20.56	20.56	20.39	20.44	14828.0
2009-01-07 09:00:00	MSFT	Stock	20.44	20.44	19.98	20.151	7281885.0
2009-01-07 10:00:00	MSFT	Stock	20.158	20.25	20.0	20.23	7307470.0
2009-01-07 11:00:00	MSFT	Stock	20.23	20.29	20.12	20.15	5807891.0
2009-01-07 12:00:00	MSFT	Stock	20.15	20.182	20.06	20.08	4706515.0
2009-01-07 13:00:00	MSFT	Stock	20.07	20.17	19.74	19.78	7200054.0
2009-01-07 14:00:00	MSFT	Stock	19.78	19.83	19.63	19.695	10962431.0
2009-01-07 15:00:00	MSFT	Stock	19.7	19.7	19.48	19.505	22375929.0
2009-01-07 16:00:00	MSFT	Stock	19.51	19.882	19.49	19.6	6045074.0
2009-01-07 17:00:00	MSFT	Stock	19.51	20.802	19.51	19.6	555516.0
2009-01-07 18:00:00	MSFT	Stock	19.6	19.64	19.59	19.64	15272.0
2009-01-07 19:00:00	MSFT	Stock	19.63	19.65	19.61	19.63	23803.0
2009-01-07 04:00:00	NVDA	Stock	0.2325	0.2325	0.2325	0.2325	8000.0
2009-01-07 08:00:00	NVDA	Stock	0.2338	0.2338	0.2263	0.2285	390000.0
2009-01-07 09:00:00	NVDA	Stock	0.2275	0.2275	0.2145	0.22	107519280.0
2009-01-07 10:00:00	NVDA	Stock	0.22	0.2215	0.2138	0.2165	146480200.0
2009-01-07 11:00:00	NVDA	Stock	0.2163	0.2235	0.215	0.222	93187000.0
2009-01-07 12:00:00	NVDA	Stock	0.2223	0.223	0.2192	0.2195	56725360.0
2009-01-07 13:00:00	NVDA	Stock	0.2193	0.2212	0.2175	0.2178	40279800.0
2009-01-07 14:00:00	NVDA	Stock	0.2179	0.2179	0.2125	0.2135	139046520.0
2009-01-07 15:00:00	NVDA	Stock	0.2135	0.216	0.2077	0.2152	249309440.0
2009-01-07 16:00:00	NVDA	Stock	0.2155	0.2165	0.2148	0.2148	22182920.0
2009-01-07 17:00:00	NVDA	Stock	0.2148	0.216	0.2148	0.2148	117680.0
2009-01-07 18:00:00	NVDA	Stock	0.2145	0.2145	0.2138	0.214	76000.0
2009-01-07 19:00:00	NVDA	Stock	0.2125	0.2125	0.2125	0.2125	12000.0
2009-01-07 07:00:00	AMZN	Stock	2.858	2.858	2.858	2.858	3600.0
2009-01-07 08:00:00	AMZN	Stock	2.855	2.87	2.8205	2.827	109000.0
2009-01-07 09:00:00	AMZN	Stock	2.823	2.84	2.792	2.8315	24300820.0
2009-01-07 10:00:00	AMZN	Stock	2.8335	2.8475	2.791	2.8125	29724620.0
2009-01-07 11:00:00	AMZN	Stock	2.8125	2.8365	2.805	2.8265	13158220.0
2009-01-07 12:00:00	AMZN	Stock	2.8265	2.8445	2.82	2.821	13878400.0
2009-01-07 13:00:00	AMZN	Stock	2.8205	2.825	2.8005	2.805	13300320.0
2009-01-07 14:00:00	AMZN	Stock	2.806	2.812	2.787	2.803	19363340.0
2009-01-07 15:00:00	AMZN	Stock	2.802	2.818	2.7675	2.81	29630720.0
2009-01-07 16:00:00	AMZN	Stock	2.81	2.81	2.807	2.81	1933780.0
2009-01-07 17:00:00	AMZN	Stock	2.81	2.81	2.805	2.81	8235000.0
2009-01-07 18:00:00	AMZN	Stock	2.8095	2.8095	2.8095	2.8095	2000.0

> showing 50 of 40,592 rows — these rows as CSV

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