PREVIEW / stock_1hour / 2005-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-22.parquet
  size:    543 KB
  rows:    25,268
  symbols: 1,956

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-04-22 08:00:00	AAPL	Stock	1.325	1.3271	1.3079	1.3214	1567972.0
2005-04-22 09:00:00	AAPL	Stock	1.3171	1.3214	1.2718	1.2732	172572904.0
2005-04-22 10:00:00	AAPL	Stock	1.2732	1.3143	1.2686	1.2839	145606524.0
2005-04-22 11:00:00	AAPL	Stock	1.2836	1.2936	1.2707	1.2736	111786220.0
2005-04-22 12:00:00	AAPL	Stock	1.2736	1.2854	1.2679	1.2789	75857964.0
2005-04-22 13:00:00	AAPL	Stock	1.2789	1.2843	1.2754	1.2839	28707896.0
2005-04-22 14:00:00	AAPL	Stock	1.2839	1.2839	1.2725	1.2736	57988392.0
2005-04-22 15:00:00	AAPL	Stock	1.2732	1.2761	1.2464	1.2675	227608668.0
2005-04-22 16:00:00	AAPL	Stock	1.2689	1.275	1.2661	1.2693	4666228.0
2005-04-22 17:00:00	AAPL	Stock	1.2693	1.2704	1.2679	1.2686	408968.0
2005-04-22 18:00:00	AAPL	Stock	1.2704	1.2704	1.2675	1.2675	162008.0
2005-04-22 07:00:00	MSFT	Stock	25.24	25.24	25.2	25.2	3400.0
2005-04-22 08:00:00	MSFT	Stock	25.24	25.24	25.15	25.16	15026.0
2005-04-22 09:00:00	MSFT	Stock	25.16	25.25	25.04	25.21	6908317.0
2005-04-22 10:00:00	MSFT	Stock	25.2	25.24	25.08	25.16	9558194.0
2005-04-22 11:00:00	MSFT	Stock	25.16	25.19	25.07	25.09	9548094.0
2005-04-22 12:00:00	MSFT	Stock	25.09	25.14	24.98	25.09	8060364.0
2005-04-22 13:00:00	MSFT	Stock	25.09	25.16	25.07	25.13	6387021.0
2005-04-22 14:00:00	MSFT	Stock	25.13	25.14	24.9	24.93	13342803.0
2005-04-22 15:00:00	MSFT	Stock	24.93	25.1	24.78	24.99	24358451.0
2005-04-22 16:00:00	MSFT	Stock	25.0	25.04	24.93	24.93	418745.0
2005-04-22 17:00:00	MSFT	Stock	25.03	25.04	24.98	25.02	104900.0
2005-04-22 18:00:00	MSFT	Stock	25.02	25.02	24.98	24.98	8800.0
2005-04-22 09:00:00	NVDA	Stock	0.1857	0.1871	0.1836	0.1842	35157000.0
2005-04-22 10:00:00	NVDA	Stock	0.1842	0.1872	0.1842	0.186	72603840.0
2005-04-22 11:00:00	NVDA	Stock	0.1861	0.1862	0.1842	0.1846	37010400.0
2005-04-22 12:00:00	NVDA	Stock	0.1846	0.1857	0.1842	0.1847	20230320.0
2005-04-22 13:00:00	NVDA	Stock	0.1847	0.1854	0.1845	0.1854	11849040.0
2005-04-22 14:00:00	NVDA	Stock	0.1854	0.1857	0.1845	0.1845	23013960.0
2005-04-22 15:00:00	NVDA	Stock	0.1845	0.1861	0.1832	0.1851	124693920.0
2005-04-22 16:00:00	NVDA	Stock	0.1852	0.1855	0.1852	0.1853	1019880.0
2005-04-22 17:00:00	NVDA	Stock	0.1853	0.1853	0.1853	0.1853	240000.0
2005-04-22 08:00:00	AMZN	Stock	1.679	1.68	1.679	1.68	12000.0
2005-04-22 09:00:00	AMZN	Stock	1.6775	1.6815	1.65	1.6575	17599220.0
2005-04-22 10:00:00	AMZN	Stock	1.6575	1.67	1.6455	1.665	24911880.0
2005-04-22 11:00:00	AMZN	Stock	1.6655	1.6675	1.6605	1.663	9495040.0
2005-04-22 12:00:00	AMZN	Stock	1.663	1.6695	1.6595	1.6645	10681720.0
2005-04-22 13:00:00	AMZN	Stock	1.6645	1.6655	1.66	1.6625	5809060.0
2005-04-22 14:00:00	AMZN	Stock	1.6625	1.6625	1.655	1.657	18931600.0
2005-04-22 15:00:00	AMZN	Stock	1.6575	1.6608	1.6515	1.652	35805940.0
2005-04-22 16:00:00	AMZN	Stock	1.655	1.6585	1.6505	1.6515	719680.0
2005-04-22 17:00:00	AMZN	Stock	1.652	1.6535	1.6505	1.6535	72000.0
2005-04-22 18:00:00	AMZN	Stock	1.6515	1.6515	1.6515	1.6515	10000.0
2005-04-22 09:00:00	CL	Stock	25.81	25.815	25.59	25.67	300800.0
2005-04-22 10:00:00	CL	Stock	25.655	25.805	25.635	25.785	322600.0
2005-04-22 11:00:00	CL	Stock	25.785	25.785	25.585	25.634	411200.0
2005-04-22 12:00:00	CL	Stock	25.64	25.755	25.595	25.72	343200.0
2005-04-22 13:00:00	CL	Stock	25.715	25.745	25.65	25.715	207600.0
2005-04-22 14:00:00	CL	Stock	25.71	25.715	25.605	25.65	451400.0
2005-04-22 15:00:00	CL	Stock	25.64	25.685	25.42	25.65	934000.0

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

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