PREVIEW / stock_1hour / 2005-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-09.parquet
  size:    536 KB
  rows:    25,979
  symbols: 1,983

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
2005-06-09 08:00:00	AAPL	Stock	1.3143	1.3157	1.3143	1.3157	51100.0
2005-06-09 09:00:00	AAPL	Stock	1.3168	1.3339	1.3164	1.3311	42531608.0
2005-06-09 10:00:00	AAPL	Stock	1.3307	1.3325	1.315	1.3246	65037868.0
2005-06-09 11:00:00	AAPL	Stock	1.3246	1.3346	1.3236	1.3346	57093260.0
2005-06-09 12:00:00	AAPL	Stock	1.3343	1.3507	1.3343	1.3493	67551876.0
2005-06-09 13:00:00	AAPL	Stock	1.35	1.355	1.3439	1.3475	63560448.0
2005-06-09 14:00:00	AAPL	Stock	1.3471	1.3482	1.3396	1.3454	44150148.0
2005-06-09 15:00:00	AAPL	Stock	1.3457	1.35	1.3421	1.345	44944956.0
2005-06-09 16:00:00	AAPL	Stock	1.3446	1.3464	1.3421	1.3425	2275112.0
2005-06-09 17:00:00	AAPL	Stock	1.3425	1.3436	1.3254	1.3375	1754396.0
2005-06-09 18:00:00	AAPL	Stock	1.3393	1.3396	1.3371	1.3371	119700.0
2005-06-09 07:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	400.0
2005-06-09 08:00:00	MSFT	Stock	25.4	25.42	25.38	25.39	5296.0
2005-06-09 09:00:00	MSFT	Stock	25.38	25.48	25.35	25.42	5660278.0
2005-06-09 10:00:00	MSFT	Stock	25.42	25.47	25.36	25.38	7616939.0
2005-06-09 11:00:00	MSFT	Stock	25.38	25.45	25.35	25.432	6522033.0
2005-06-09 12:00:00	MSFT	Stock	25.43	25.611	25.43	25.49	8778156.0
2005-06-09 13:00:00	MSFT	Stock	25.48	25.49	25.36	25.42	5775565.0
2005-06-09 14:00:00	MSFT	Stock	25.41	25.49	25.4	25.442	5638090.0
2005-06-09 15:00:00	MSFT	Stock	25.44	25.52	25.43	25.5	10507310.0
2005-06-09 16:00:00	MSFT	Stock	25.5	25.58	25.44	25.49	366779.0
2005-06-09 17:00:00	MSFT	Stock	25.535	25.535	25.47	25.47	11846.0
2005-06-09 18:00:00	MSFT	Stock	25.47	25.48	25.47	25.48	507.0
2005-06-09 09:00:00	NVDA	Stock	0.2275	0.2275	0.2243	0.2274	49670760.0
2005-06-09 10:00:00	NVDA	Stock	0.2274	0.2292	0.2268	0.229	96983400.0
2005-06-09 11:00:00	NVDA	Stock	0.229	0.2312	0.2285	0.2311	72256080.0
2005-06-09 12:00:00	NVDA	Stock	0.2311	0.2339	0.2311	0.2336	112042200.0
2005-06-09 13:00:00	NVDA	Stock	0.2336	0.2337	0.2317	0.2327	46816320.0
2005-06-09 14:00:00	NVDA	Stock	0.2328	0.2348	0.2324	0.2343	81051360.0
2005-06-09 15:00:00	NVDA	Stock	0.2342	0.2359	0.2338	0.2359	144214920.0
2005-06-09 16:00:00	NVDA	Stock	0.2357	0.2358	0.2258	0.235	6388560.0
2005-06-09 17:00:00	NVDA	Stock	0.2354	0.2356	0.235	0.2356	1139520.0
2005-06-09 18:00:00	NVDA	Stock	0.2354	0.2354	0.2347	0.2347	120000.0
2005-06-09 09:00:00	AMZN	Stock	1.745	1.7465	1.7235	1.7235	10361860.0
2005-06-09 10:00:00	AMZN	Stock	1.7235	1.7395	1.72	1.7385	12576060.0
2005-06-09 11:00:00	AMZN	Stock	1.739	1.75	1.7385	1.7445	13847860.0
2005-06-09 12:00:00	AMZN	Stock	1.7375	1.7635	1.7375	1.753	8398900.0
2005-06-09 13:00:00	AMZN	Stock	1.753	1.753	1.742	1.75	4822340.0
2005-06-09 14:00:00	AMZN	Stock	1.7465	1.753	1.7415	1.748	5431580.0
2005-06-09 15:00:00	AMZN	Stock	1.748	1.764	1.746	1.7595	19976580.0
2005-06-09 16:00:00	AMZN	Stock	1.759	1.7615	1.7565	1.7615	182780.0
2005-06-09 17:00:00	AMZN	Stock	1.7582	1.76	1.7582	1.76	12000.0
2005-06-09 18:00:00	AMZN	Stock	1.76	1.7625	1.76	1.7625	96000.0
2005-06-09 09:00:00	CL	Stock	24.825	24.865	24.77	24.825	354000.0
2005-06-09 10:00:00	CL	Stock	24.8295	24.88	24.8	24.87	667400.0
2005-06-09 11:00:00	CL	Stock	24.865	24.9	24.835	24.88	519400.0
2005-06-09 12:00:00	CL	Stock	24.88	24.94	24.84	24.905	730000.0
2005-06-09 13:00:00	CL	Stock	24.905	24.94	24.845	24.875	412200.0
2005-06-09 14:00:00	CL	Stock	24.9	24.915	24.835	24.9	731400.0
2005-06-09 15:00:00	CL	Stock	24.905	24.915	24.82	24.855	611600.0

> showing 50 of 25,979 rows — these rows as CSV

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