PREVIEW / stock_1hour / 2010-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-06.parquet
  size:    887 KB
  rows:    42,331
  symbols: 3,455

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
2010-08-06 07:00:00	AAPL	Stock	9.3479	9.3479	9.3479	9.3479	3360.0
2010-08-06 08:00:00	AAPL	Stock	9.3432	9.3529	9.2729	9.2911	4736368.0
2010-08-06 09:00:00	AAPL	Stock	9.2904	9.3332	9.2357	9.3304	67481064.0
2010-08-06 10:00:00	AAPL	Stock	9.3289	9.3389	9.2296	9.2364	93251116.0
2010-08-06 11:00:00	AAPL	Stock	9.2346	9.2614	9.2196	9.2479	58242100.0
2010-08-06 12:00:00	AAPL	Stock	9.2486	9.255	9.2339	9.2432	21133896.0
2010-08-06 13:00:00	AAPL	Stock	9.2432	9.2546	9.2204	9.2236	33709704.0
2010-08-06 14:00:00	AAPL	Stock	9.2232	9.2782	9.2011	9.2746	67821012.0
2010-08-06 15:00:00	AAPL	Stock	9.2729	9.2968	9.2579	9.2911	88103568.0
2010-08-06 16:00:00	AAPL	Stock	9.2886	9.2948	9.2482	9.285	4208260.0
2010-08-06 17:00:00	AAPL	Stock	9.2854	9.2886	9.2821	9.2821	139944.0
2010-08-06 18:00:00	AAPL	Stock	9.2854	9.2889	9.2854	9.2857	260960.0
2010-08-06 19:00:00	AAPL	Stock	9.2843	9.2875	9.2821	9.2821	69076.0
2010-08-06 04:00:00	MSFT	Stock	25.44	25.44	25.44	25.44	500.0
2010-08-06 07:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	400.0
2010-08-06 08:00:00	MSFT	Stock	25.4	25.4	25.12	25.16	51850.0
2010-08-06 09:00:00	MSFT	Stock	25.16	25.31	25.03	25.26	5931981.0
2010-08-06 10:00:00	MSFT	Stock	25.26	25.31	25.03	25.03	10895488.0
2010-08-06 11:00:00	MSFT	Stock	25.04	25.17	25.02	25.11	7661368.0
2010-08-06 12:00:00	MSFT	Stock	25.11	25.14	25.05	25.1	4413263.0
2010-08-06 13:00:00	MSFT	Stock	25.105	25.16	25.06	25.095	4294216.0
2010-08-06 14:00:00	MSFT	Stock	25.095	25.33	25.07	25.31	6473844.0
2010-08-06 15:00:00	MSFT	Stock	25.32	25.56	25.29	25.56	14598133.0
2010-08-06 16:00:00	MSFT	Stock	25.55	25.6	25.105	25.55	1358057.0
2010-08-06 17:00:00	MSFT	Stock	25.53	25.55	25.5	25.5	8336.0
2010-08-06 18:00:00	MSFT	Stock	25.5	25.55	25.46	25.52	8359.0
2010-08-06 19:00:00	MSFT	Stock	25.53	25.53	25.52	25.52	1100.0
2010-08-06 04:00:00	NVDA	Stock	0.2388	0.2388	0.2388	0.2388	8000.0
2010-08-06 06:00:00	NVDA	Stock	0.235	0.235	0.235	0.235	6000.0
2010-08-06 08:00:00	NVDA	Stock	0.235	0.2392	0.2332	0.234	1707840.0
2010-08-06 09:00:00	NVDA	Stock	0.234	0.2392	0.2328	0.2378	98574040.0
2010-08-06 10:00:00	NVDA	Stock	0.238	0.2412	0.2342	0.2355	203490120.0
2010-08-06 11:00:00	NVDA	Stock	0.2355	0.2382	0.2342	0.237	92074680.0
2010-08-06 12:00:00	NVDA	Stock	0.2368	0.237	0.235	0.235	42894840.0
2010-08-06 13:00:00	NVDA	Stock	0.2352	0.2359	0.2342	0.2355	50404360.0
2010-08-06 14:00:00	NVDA	Stock	0.2358	0.239	0.235	0.2382	76441920.0
2010-08-06 15:00:00	NVDA	Stock	0.2382	0.239	0.2371	0.2388	164272400.0
2010-08-06 16:00:00	NVDA	Stock	0.238	0.2388	0.238	0.2385	2167080.0
2010-08-06 17:00:00	NVDA	Stock	0.2385	0.2392	0.2385	0.2392	740360.0
2010-08-06 18:00:00	NVDA	Stock	0.2392	0.2398	0.2375	0.2375	261560.0
2010-08-06 08:00:00	AMZN	Stock	6.385	6.3925	6.335	6.34	683000.0
2010-08-06 09:00:00	AMZN	Stock	6.34	6.393	6.314	6.3904	16397060.0
2010-08-06 10:00:00	AMZN	Stock	6.3915	6.42	6.295	6.3025	26965760.0
2010-08-06 11:00:00	AMZN	Stock	6.299	6.3575	6.295	6.3465	10882180.0
2010-08-06 12:00:00	AMZN	Stock	6.3463	6.3495	6.31	6.323	4925740.0
2010-08-06 13:00:00	AMZN	Stock	6.3255	6.3375	6.3075	6.334	6238080.0
2010-08-06 14:00:00	AMZN	Stock	6.3355	6.3845	6.3195	6.382	9427820.0
2010-08-06 15:00:00	AMZN	Stock	6.382	6.418	6.3715	6.4145	22154340.0
2010-08-06 16:00:00	AMZN	Stock	6.416	6.424	6.3632	6.4225	3384600.0
2010-08-06 17:00:00	AMZN	Stock	6.419	6.4235	6.419	6.423	19600.0

> showing 50 of 42,331 rows — these rows as CSV

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