PREVIEW / stock_1hour / 2009-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-02.parquet
  size:    841 KB
  rows:    41,134
  symbols: 3,320

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-02 07:00:00	AAPL	Stock	3.0696	3.0796	3.0696	3.0768	34860.0
2009-01-02 08:00:00	AAPL	Stock	3.0768	3.0768	3.0482	3.0661	3117632.0
2009-01-02 09:00:00	AAPL	Stock	3.0661	3.1179	3.0414	3.1064	83806828.0
2009-01-02 10:00:00	AAPL	Stock	3.1054	3.1379	3.0954	3.1271	106860488.0
2009-01-02 11:00:00	AAPL	Stock	3.1279	3.1464	3.1182	3.1443	77626332.0
2009-01-02 12:00:00	AAPL	Stock	3.1439	3.2064	3.1396	3.1946	113268512.0
2009-01-02 13:00:00	AAPL	Stock	3.1946	3.2104	3.1875	3.1982	67800852.0
2009-01-02 14:00:00	AAPL	Stock	3.1989	3.2143	3.19	3.2132	82588380.0
2009-01-02 15:00:00	AAPL	Stock	3.2132	3.2514	3.2132	3.2386	182642432.0
2009-01-02 16:00:00	AAPL	Stock	3.2386	3.2421	3.1747	3.2304	19292056.0
2009-01-02 17:00:00	AAPL	Stock	3.2296	3.2321	3.2286	3.2314	140000.0
2009-01-02 18:00:00	AAPL	Stock	3.2289	3.2411	3.2289	3.2307	8713768.0
2009-01-02 19:00:00	AAPL	Stock	3.2325	3.2336	3.2254	3.2304	252112.0
2009-01-02 07:00:00	MSFT	Stock	19.45	19.45	19.45	19.45	100.0
2009-01-02 08:00:00	MSFT	Stock	19.48	19.48	19.36	19.39	293967.0
2009-01-02 09:00:00	MSFT	Stock	19.44	19.6	19.37	19.55	4092063.0
2009-01-02 10:00:00	MSFT	Stock	19.55	19.94	19.54	19.9	7463336.0
2009-01-02 11:00:00	MSFT	Stock	19.9	20.04	19.86	20.01	4901215.0
2009-01-02 12:00:00	MSFT	Stock	20.0	20.05	19.93	20.02	3770519.0
2009-01-02 13:00:00	MSFT	Stock	20.012	20.13	19.97	20.095	3762370.0
2009-01-02 14:00:00	MSFT	Stock	20.1	20.2	20.07	20.14	8500164.0
2009-01-02 15:00:00	MSFT	Stock	20.15	20.4	20.14	20.32	12312594.0
2009-01-02 16:00:00	MSFT	Stock	20.33	20.37	20.02	20.33	4431749.0
2009-01-02 17:00:00	MSFT	Stock	20.23	20.28	20.23	20.28	5750.0
2009-01-02 18:00:00	MSFT	Stock	20.33	20.33	20.3	20.3	29775.0
2009-01-02 19:00:00	MSFT	Stock	20.28	20.31	20.28	20.28	5900.0
2009-01-02 06:00:00	NVDA	Stock	0.2025	0.2025	0.2025	0.2025	4800.0
2009-01-02 08:00:00	NVDA	Stock	0.1992	0.2018	0.1988	0.2018	4607000.0
2009-01-02 09:00:00	NVDA	Stock	0.2023	0.2085	0.201	0.2043	71564880.0
2009-01-02 10:00:00	NVDA	Stock	0.2043	0.213	0.2033	0.2122	78408800.0
2009-01-02 11:00:00	NVDA	Stock	0.2125	0.215	0.212	0.2145	63673760.0
2009-01-02 12:00:00	NVDA	Stock	0.2145	0.2168	0.2138	0.2163	39089000.0
2009-01-02 13:00:00	NVDA	Stock	0.216	0.218	0.215	0.2152	39473040.0
2009-01-02 14:00:00	NVDA	Stock	0.2154	0.2175	0.2131	0.217	60698240.0
2009-01-02 15:00:00	NVDA	Stock	0.217	0.2192	0.2168	0.2172	114220040.0
2009-01-02 16:00:00	NVDA	Stock	0.2172	0.2185	0.2134	0.2178	19378360.0
2009-01-02 17:00:00	NVDA	Stock	0.2165	0.2165	0.2165	0.2165	8000.0
2009-01-02 18:00:00	NVDA	Stock	0.217	0.217	0.2165	0.2165	88080.0
2009-01-02 19:00:00	NVDA	Stock	0.2165	0.2183	0.2165	0.2183	36920.0
2009-01-02 08:00:00	AMZN	Stock	2.568	2.568	2.55	2.55	44200.0
2009-01-02 09:00:00	AMZN	Stock	2.55	2.606	2.55	2.5995	17048780.0
2009-01-02 10:00:00	AMZN	Stock	2.6	2.6745	2.594	2.657	26412540.0
2009-01-02 11:00:00	AMZN	Stock	2.6575	2.669	2.641	2.646	15033900.0
2009-01-02 12:00:00	AMZN	Stock	2.646	2.673	2.639	2.669	14672180.0
2009-01-02 13:00:00	AMZN	Stock	2.6695	2.6925	2.664	2.689	11728740.0
2009-01-02 14:00:00	AMZN	Stock	2.6895	2.7125	2.684	2.6965	17748300.0
2009-01-02 15:00:00	AMZN	Stock	2.697	2.7265	2.6875	2.718	36974080.0
2009-01-02 16:00:00	AMZN	Stock	2.718	2.7188	2.6656	2.718	841040.0
2009-01-02 17:00:00	AMZN	Stock	2.712	2.7125	2.712	2.7125	16000.0
2009-01-02 19:00:00	AMZN	Stock	2.698	2.699	2.698	2.699	6500.0

> showing 50 of 41,134 rows — these rows as CSV

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