PREVIEW / stock_1hour / 2009-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-10.parquet
  size:    807 KB
  rows:    39,476
  symbols: 3,317

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-02-10 04:00:00	AAPL	Stock	3.6307	3.6325	3.6307	3.6325	7000.0
2009-02-10 07:00:00	AAPL	Stock	3.6357	3.6404	3.6357	3.6404	14000.0
2009-02-10 08:00:00	AAPL	Stock	3.655	3.655	3.6143	3.6143	1180704.0
2009-02-10 09:00:00	AAPL	Stock	3.615	3.66	3.6	3.645	90986924.0
2009-02-10 10:00:00	AAPL	Stock	3.645	3.6554	3.595	3.6107	116373796.0
2009-02-10 11:00:00	AAPL	Stock	3.6107	3.6221	3.5271	3.5529	167484912.0
2009-02-10 12:00:00	AAPL	Stock	3.5529	3.5804	3.5307	3.5386	71844164.0
2009-02-10 13:00:00	AAPL	Stock	3.5386	3.5386	3.4882	3.5014	99343720.0
2009-02-10 14:00:00	AAPL	Stock	3.5004	3.515	3.4679	3.4854	103226928.0
2009-02-10 15:00:00	AAPL	Stock	3.4854	3.5071	3.4664	3.4986	153077512.0
2009-02-10 16:00:00	AAPL	Stock	3.4986	3.5511	3.4929	3.4929	28930188.0
2009-02-10 17:00:00	AAPL	Stock	3.4989	3.5018	3.4961	3.5018	152516.0
2009-02-10 18:00:00	AAPL	Stock	3.5018	3.5075	3.4939	3.5075	10923696.0
2009-02-10 19:00:00	AAPL	Stock	3.5025	3.5143	3.5	3.5143	146160.0
2009-02-10 08:00:00	MSFT	Stock	19.44	19.44	19.2	19.23	55753.0
2009-02-10 09:00:00	MSFT	Stock	19.23	19.8	19.23	19.612	8532623.0
2009-02-10 10:00:00	MSFT	Stock	19.61	19.71	19.54	19.6	9189803.0
2009-02-10 11:00:00	MSFT	Stock	19.592	19.68	19.05	19.24	20002859.0
2009-02-10 12:00:00	MSFT	Stock	19.25	19.35	19.1	19.19	6929523.0
2009-02-10 13:00:00	MSFT	Stock	19.19	19.2	18.94	19.03	7716378.0
2009-02-10 14:00:00	MSFT	Stock	19.03	19.1	18.86	18.86	6902551.0
2009-02-10 15:00:00	MSFT	Stock	18.87	19.03	18.7	18.8	19527349.0
2009-02-10 16:00:00	MSFT	Stock	18.79	19.228	18.78	18.85	4834950.0
2009-02-10 17:00:00	MSFT	Stock	18.92	18.92	18.9	18.9	14700.0
2009-02-10 18:00:00	MSFT	Stock	18.8	18.91	18.8	18.91	14677.0
2009-02-10 19:00:00	MSFT	Stock	18.91	18.99	18.9	18.99	4825.0
2009-02-10 08:00:00	NVDA	Stock	0.2388	0.2408	0.2388	0.2408	24000.0
2009-02-10 09:00:00	NVDA	Stock	0.24	0.245	0.2378	0.2448	126064520.0
2009-02-10 10:00:00	NVDA	Stock	0.2448	0.2465	0.2385	0.241	185646200.0
2009-02-10 11:00:00	NVDA	Stock	0.2412	0.2435	0.2295	0.2356	215015680.0
2009-02-10 12:00:00	NVDA	Stock	0.236	0.24	0.2335	0.2385	109831400.0
2009-02-10 13:00:00	NVDA	Stock	0.2385	0.2385	0.2312	0.2342	104788320.0
2009-02-10 14:00:00	NVDA	Stock	0.234	0.2362	0.23	0.2303	84206280.0
2009-02-10 15:00:00	NVDA	Stock	0.2305	0.235	0.2285	0.233	228905680.0
2009-02-10 16:00:00	NVDA	Stock	0.2332	0.2375	0.2112	0.2163	43343080.0
2009-02-10 17:00:00	NVDA	Stock	0.218	0.233	0.2163	0.2252	26068200.0
2009-02-10 18:00:00	NVDA	Stock	0.2265	0.2275	0.2208	0.2232	1654000.0
2009-02-10 19:00:00	NVDA	Stock	0.2238	0.2265	0.2225	0.225	1132000.0
2009-02-10 04:00:00	AMZN	Stock	3.3025	3.3025	3.3025	3.3025	14000.0
2009-02-10 08:00:00	AMZN	Stock	3.325	3.35	3.3005	3.3025	443860.0
2009-02-10 09:00:00	AMZN	Stock	3.31	3.3615	3.29	3.3445	21079280.0
2009-02-10 10:00:00	AMZN	Stock	3.344	3.351	3.2875	3.293	24250940.0
2009-02-10 11:00:00	AMZN	Stock	3.293	3.3355	3.2025	3.242	46046500.0
2009-02-10 12:00:00	AMZN	Stock	3.2425	3.254	3.228	3.234	16347960.0
2009-02-10 13:00:00	AMZN	Stock	3.234	3.235	3.1665	3.1885	29998740.0
2009-02-10 14:00:00	AMZN	Stock	3.188	3.2	3.154	3.1705	24328880.0
2009-02-10 15:00:00	AMZN	Stock	3.1715	3.1991	3.1535	3.165	44847240.0
2009-02-10 16:00:00	AMZN	Stock	3.1685	3.2309	3.1575	3.1625	1523800.0
2009-02-10 17:00:00	AMZN	Stock	3.1655	3.3355	3.165	3.165	371000.0
2009-02-10 18:00:00	AMZN	Stock	3.165	3.165	3.165	3.165	52300.0

> showing 50 of 39,476 rows — these rows as CSV

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