PREVIEW / stock_1hour / 2005-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-21.parquet
  size:    558 KB
  rows:    26,235
  symbols: 1,957

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-21 08:00:00	AAPL	Stock	1.2857	1.2964	1.2857	1.2914	1688680.0
2005-04-21 09:00:00	AAPL	Stock	1.2914	1.3039	1.2821	1.2914	110754924.0
2005-04-21 10:00:00	AAPL	Stock	1.2914	1.3057	1.2839	1.3032	133283556.0
2005-04-21 11:00:00	AAPL	Stock	1.3029	1.3036	1.2889	1.2964	75318712.0
2005-04-21 12:00:00	AAPL	Stock	1.2964	1.3189	1.2961	1.3107	110930400.0
2005-04-21 13:00:00	AAPL	Stock	1.3107	1.3154	1.3079	1.3136	71214780.0
2005-04-21 14:00:00	AAPL	Stock	1.3139	1.3279	1.3125	1.3229	109047708.0
2005-04-21 15:00:00	AAPL	Stock	1.3232	1.3289	1.3171	1.3282	127640940.0
2005-04-21 16:00:00	AAPL	Stock	1.3282	1.3304	1.3229	1.3257	5436088.0
2005-04-21 17:00:00	AAPL	Stock	1.3257	1.3279	1.3168	1.3232	898800.0
2005-04-21 18:00:00	AAPL	Stock	1.3232	1.3232	1.3218	1.3218	179200.0
2005-04-21 07:00:00	MSFT	Stock	24.46	24.46	24.46	24.46	4000.0
2005-04-21 08:00:00	MSFT	Stock	24.4	24.54	24.4	24.49	99561.0
2005-04-21 09:00:00	MSFT	Stock	24.49	24.64	24.47	24.61	8629587.0
2005-04-21 10:00:00	MSFT	Stock	24.62	24.77	24.53	24.73	15476773.0
2005-04-21 11:00:00	MSFT	Stock	24.74	24.9	24.68	24.88	13181952.0
2005-04-21 12:00:00	MSFT	Stock	24.89	25.09	24.88	25.01	15147562.0
2005-04-21 13:00:00	MSFT	Stock	25.01	25.15	25.01	25.15	7121182.0
2005-04-21 14:00:00	MSFT	Stock	25.15	25.39	25.11	25.16	13001179.0
2005-04-21 15:00:00	MSFT	Stock	25.16	25.32	25.1	25.31	16770676.0
2005-04-21 16:00:00	MSFT	Stock	25.29	25.4	25.085	25.31	906257.0
2005-04-21 17:00:00	MSFT	Stock	25.28	25.28	25.26	25.28	4550.0
2005-04-21 18:00:00	MSFT	Stock	25.29	25.29	25.24	25.25	21029.0
2005-04-21 08:00:00	NVDA	Stock	0.178	0.1788	0.178	0.1788	72000.0
2005-04-21 09:00:00	NVDA	Stock	0.1797	0.1822	0.1792	0.1816	76252560.0
2005-04-21 10:00:00	NVDA	Stock	0.1816	0.1822	0.1805	0.1809	71275080.0
2005-04-21 11:00:00	NVDA	Stock	0.181	0.1829	0.1799	0.1825	40018320.0
2005-04-21 12:00:00	NVDA	Stock	0.1825	0.1852	0.1825	0.1842	60942600.0
2005-04-21 13:00:00	NVDA	Stock	0.1842	0.1859	0.1842	0.1859	49242240.0
2005-04-21 14:00:00	NVDA	Stock	0.1859	0.1877	0.1858	0.1872	91165200.0
2005-04-21 15:00:00	NVDA	Stock	0.1873	0.1877	0.1853	0.1871	140697720.0
2005-04-21 16:00:00	NVDA	Stock	0.1869	0.1887	0.1854	0.1854	1958520.0
2005-04-21 17:00:00	NVDA	Stock	0.185	0.1875	0.185	0.1871	1757040.0
2005-04-21 08:00:00	AMZN	Stock	1.675	1.6845	1.675	1.675	50000.0
2005-04-21 09:00:00	AMZN	Stock	1.675	1.69	1.664	1.69	16444000.0
2005-04-21 10:00:00	AMZN	Stock	1.6895	1.6945	1.6615	1.666	18618500.0
2005-04-21 11:00:00	AMZN	Stock	1.666	1.666	1.6445	1.65	22360600.0
2005-04-21 12:00:00	AMZN	Stock	1.6495	1.67	1.6495	1.667	16500580.0
2005-04-21 13:00:00	AMZN	Stock	1.667	1.684	1.664	1.68	16998060.0
2005-04-21 14:00:00	AMZN	Stock	1.68	1.687	1.6615	1.681	36580620.0
2005-04-21 15:00:00	AMZN	Stock	1.6805	1.694	1.6805	1.69	22453720.0
2005-04-21 16:00:00	AMZN	Stock	1.6865	1.705	1.6865	1.6896	1343400.0
2005-04-21 17:00:00	AMZN	Stock	1.7025	1.7025	1.7025	1.7025	45000.0
2005-04-21 18:00:00	AMZN	Stock	1.7075	1.7075	1.7075	1.7075	18200.0
2005-04-21 09:00:00	CL	Stock	25.8	25.925	25.715	25.81	349200.0
2005-04-21 10:00:00	CL	Stock	25.85	25.985	25.74	25.93	678600.0
2005-04-21 11:00:00	CL	Stock	25.93	25.975	25.83	25.905	445400.0
2005-04-21 12:00:00	CL	Stock	25.905	26.0	25.845	25.865	548200.0
2005-04-21 13:00:00	CL	Stock	25.875	25.97	25.8	25.92	284600.0
2005-04-21 14:00:00	CL	Stock	25.93	26.125	25.9	25.975	534400.0

> showing 50 of 26,235 rows — these rows as CSV

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