PREVIEW / stock_1hour / 2005-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-11.parquet
  size:    539 KB
  rows:    25,496
  symbols: 1,974

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-05-11 05:00:00	AAPL	Stock	1.3	1.3	1.3	1.3	11200.0
2005-05-11 07:00:00	AAPL	Stock	1.2764	1.2764	1.2714	1.2714	392000.0
2005-05-11 08:00:00	AAPL	Stock	1.2746	1.2821	1.2686	1.2714	8231188.0
2005-05-11 09:00:00	AAPL	Stock	1.2714	1.2714	1.2493	1.2574	187816692.0
2005-05-11 10:00:00	AAPL	Stock	1.2575	1.2607	1.1825	1.1914	549921512.0
2005-05-11 11:00:00	AAPL	Stock	1.1914	1.2225	1.1896	1.2214	388537268.0
2005-05-11 12:00:00	AAPL	Stock	1.2214	1.2325	1.2182	1.2307	224974624.0
2005-05-11 13:00:00	AAPL	Stock	1.2304	1.2482	1.2296	1.2393	200463732.0
2005-05-11 14:00:00	AAPL	Stock	1.2393	1.2629	1.2371	1.2486	223417796.0
2005-05-11 15:00:00	AAPL	Stock	1.2486	1.2739	1.2468	1.2714	233767464.0
2005-05-11 16:00:00	AAPL	Stock	1.2704	1.2729	1.2679	1.2696	3006332.0
2005-05-11 17:00:00	AAPL	Stock	1.2696	1.2736	1.2679	1.27	9254280.0
2005-05-11 18:00:00	AAPL	Stock	1.2732	1.2732	1.27	1.27	193200.0
2005-05-11 07:00:00	MSFT	Stock	24.9	24.9	24.9	24.9	100.0
2005-05-11 08:00:00	MSFT	Stock	24.91	24.95	24.89	24.9	32341.0
2005-05-11 09:00:00	MSFT	Stock	24.91	24.97	24.82	24.83	4758147.0
2005-05-11 10:00:00	MSFT	Stock	24.83	24.89	24.699	24.76	12529089.0
2005-05-11 11:00:00	MSFT	Stock	24.76	24.78	24.69	24.74	6866508.0
2005-05-11 12:00:00	MSFT	Stock	24.731	24.79	24.64	24.75	8371920.0
2005-05-11 13:00:00	MSFT	Stock	24.75	24.8	24.69	24.71	4815916.0
2005-05-11 14:00:00	MSFT	Stock	24.71	24.94	24.7	24.85	10789265.0
2005-05-11 15:00:00	MSFT	Stock	24.85	24.94	24.79	24.91	8895497.0
2005-05-11 16:00:00	MSFT	Stock	24.9	24.94	24.89	24.9	451418.0
2005-05-11 17:00:00	MSFT	Stock	24.9	24.92	24.9	24.91	39356.0
2005-05-11 18:00:00	MSFT	Stock	24.91	24.91	24.91	24.91	200.0
2005-05-11 08:00:00	NVDA	Stock	0.19	0.1912	0.1896	0.1912	228000.0
2005-05-11 09:00:00	NVDA	Stock	0.1892	0.1912	0.1879	0.1888	71829480.0
2005-05-11 10:00:00	NVDA	Stock	0.1887	0.1899	0.1872	0.1878	72482160.0
2005-05-11 11:00:00	NVDA	Stock	0.1878	0.1891	0.1872	0.1874	40217040.0
2005-05-11 12:00:00	NVDA	Stock	0.1874	0.1877	0.1861	0.1863	49660440.0
2005-05-11 13:00:00	NVDA	Stock	0.1862	0.1875	0.1862	0.1865	51931200.0
2005-05-11 14:00:00	NVDA	Stock	0.1865	0.1877	0.1864	0.1869	95123760.0
2005-05-11 15:00:00	NVDA	Stock	0.1869	0.1872	0.1855	0.1856	160572960.0
2005-05-11 16:00:00	NVDA	Stock	0.1858	0.1858	0.1853	0.1854	6463560.0
2005-05-11 17:00:00	NVDA	Stock	0.1858	0.1867	0.185	0.1867	1020600.0
2005-05-11 18:00:00	NVDA	Stock	0.1867	0.1867	0.1867	0.1867	280200.0
2005-05-11 08:00:00	AMZN	Stock	1.712	1.712	1.712	1.712	2000.0
2005-05-11 09:00:00	AMZN	Stock	1.715	1.7255	1.7115	1.7203	8328760.0
2005-05-11 10:00:00	AMZN	Stock	1.7205	1.7235	1.7045	1.705	17562720.0
2005-05-11 11:00:00	AMZN	Stock	1.7045	1.7055	1.693	1.693	25915520.0
2005-05-11 12:00:00	AMZN	Stock	1.693	1.695	1.6825	1.6825	16696680.0
2005-05-11 13:00:00	AMZN	Stock	1.683	1.6915	1.6825	1.6875	10204460.0
2005-05-11 14:00:00	AMZN	Stock	1.688	1.702	1.686	1.6935	20788740.0
2005-05-11 15:00:00	AMZN	Stock	1.694	1.7005	1.689	1.692	16394460.0
2005-05-11 16:00:00	AMZN	Stock	1.694	1.6965	1.6914	1.6915	354960.0
2005-05-11 17:00:00	AMZN	Stock	1.691	1.6975	1.691	1.6975	1986000.0
2005-05-11 09:00:00	CL	Stock	24.36	24.54	24.35	24.415	738400.0
2005-05-11 10:00:00	CL	Stock	24.41	24.525	24.375	24.41	753600.0
2005-05-11 11:00:00	CL	Stock	24.4115	24.445	24.375	24.395	424200.0
2005-05-11 12:00:00	CL	Stock	24.3995	24.5	24.3	24.475	560600.0

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

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