PREVIEW / stock_1hour / 2009-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-05.parquet
  size:    832 KB
  rows:    40,641
  symbols: 3,335

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-05 07:00:00	AAPL	Stock	3.2486	3.2568	3.2261	3.2261	159740.0
2009-01-05 08:00:00	AAPL	Stock	3.2332	3.3554	3.2107	3.3471	30497600.0
2009-01-05 09:00:00	AAPL	Stock	3.3464	3.3771	3.3111	3.3375	218054116.0
2009-01-05 10:00:00	AAPL	Stock	3.3375	3.3896	3.3218	3.3757	190952356.0
2009-01-05 11:00:00	AAPL	Stock	3.3754	3.3911	3.3643	3.3664	99802752.0
2009-01-05 12:00:00	AAPL	Stock	3.3657	3.4036	3.365	3.3957	102494896.0
2009-01-05 13:00:00	AAPL	Stock	3.3961	3.4236	3.3882	3.4227	107875964.0
2009-01-05 14:00:00	AAPL	Stock	3.4225	3.435	3.3607	3.3786	213919580.0
2009-01-05 15:00:00	AAPL	Stock	3.3779	3.4036	3.3671	3.3786	187074916.0
2009-01-05 16:00:00	AAPL	Stock	3.3789	3.3961	3.375	3.3807	15009652.0
2009-01-05 17:00:00	AAPL	Stock	3.3796	3.3836	3.375	3.3832	727076.0
2009-01-05 18:00:00	AAPL	Stock	3.3821	3.3889	3.3779	3.3839	6941872.0
2009-01-05 19:00:00	AAPL	Stock	3.3854	3.3889	3.3786	3.3804	368900.0
2009-01-05 20:00:00	AAPL	Stock	3.3779	3.3779	3.3779	3.3779	14000.0
2009-01-05 08:00:00	MSFT	Stock	20.28	20.28	20.1	20.13	8664.0
2009-01-05 09:00:00	MSFT	Stock	20.2	20.23	20.06	20.11	6019911.0
2009-01-05 10:00:00	MSFT	Stock	20.11	20.31	20.11	20.29	10325172.0
2009-01-05 11:00:00	MSFT	Stock	20.28	20.45	20.27	20.39	6882895.0
2009-01-05 12:00:00	MSFT	Stock	20.38	20.52	20.35	20.39	4965407.0
2009-01-05 13:00:00	MSFT	Stock	20.39	20.6	20.35	20.6	7614307.0
2009-01-05 14:00:00	MSFT	Stock	20.6	20.67	20.35	20.39	9569481.0
2009-01-05 15:00:00	MSFT	Stock	20.39	20.52	20.31	20.52	11288065.0
2009-01-05 16:00:00	MSFT	Stock	20.51	20.55	20.189	20.48	3423617.0
2009-01-05 17:00:00	MSFT	Stock	20.52	20.52	20.47	20.47	149125.0
2009-01-05 18:00:00	MSFT	Stock	20.49	20.5	20.47	20.47	1296.0
2009-01-05 19:00:00	MSFT	Stock	20.47	20.47	20.36	20.36	1040.0
2009-01-05 08:00:00	NVDA	Stock	0.2185	0.2185	0.2138	0.2145	120000.0
2009-01-05 09:00:00	NVDA	Stock	0.2145	0.222	0.2138	0.2185	74008760.0
2009-01-05 10:00:00	NVDA	Stock	0.2188	0.2268	0.218	0.2238	101706440.0
2009-01-05 11:00:00	NVDA	Stock	0.2235	0.2245	0.2198	0.2203	76639520.0
2009-01-05 12:00:00	NVDA	Stock	0.2201	0.2223	0.2191	0.2205	73302160.0
2009-01-05 13:00:00	NVDA	Stock	0.2205	0.224	0.2188	0.2232	70229640.0
2009-01-05 14:00:00	NVDA	Stock	0.2235	0.2245	0.2205	0.2208	103115760.0
2009-01-05 15:00:00	NVDA	Stock	0.221	0.2225	0.2185	0.2223	166641920.0
2009-01-05 16:00:00	NVDA	Stock	0.2223	0.2228	0.2212	0.2218	38771280.0
2009-01-05 18:00:00	NVDA	Stock	0.2203	0.2203	0.22	0.22	40000.0
2009-01-05 19:00:00	NVDA	Stock	0.22	0.22	0.219	0.219	245680.0
2009-01-05 07:00:00	AMZN	Stock	2.7895	2.79	2.77	2.785	219900.0
2009-01-05 08:00:00	AMZN	Stock	2.7755	2.785	2.743	2.7675	744460.0
2009-01-05 09:00:00	AMZN	Stock	2.77	2.787	2.653	2.6595	32664900.0
2009-01-05 10:00:00	AMZN	Stock	2.659	2.7435	2.6515	2.71	40754940.0
2009-01-05 11:00:00	AMZN	Stock	2.71	2.7125	2.6685	2.6765	18115580.0
2009-01-05 12:00:00	AMZN	Stock	2.675	2.6955	2.6645	2.6925	14709940.0
2009-01-05 13:00:00	AMZN	Stock	2.692	2.705	2.6801	2.6995	17849340.0
2009-01-05 14:00:00	AMZN	Stock	2.6985	2.724	2.673	2.692	24013860.0
2009-01-05 15:00:00	AMZN	Stock	2.692	2.7095	2.677	2.703	36013200.0
2009-01-05 16:00:00	AMZN	Stock	2.703	2.7038	2.688	2.7038	2370940.0
2009-01-05 17:00:00	AMZN	Stock	2.6975	2.7	2.6975	2.6975	30880.0
2009-01-05 18:00:00	AMZN	Stock	2.697	2.697	2.697	2.697	4300.0
2009-01-05 19:00:00	AMZN	Stock	2.6855	2.6855	2.675	2.675	39780.0

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

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