PREVIEW / stock_1hour / 2005-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-18.parquet
  size:    543 KB
  rows:    25,498
  symbols: 1,970

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-18 07:00:00	AAPL	Stock	1.2411	1.2536	1.2411	1.2529	177800.0
2005-04-18 08:00:00	AAPL	Stock	1.2529	1.2675	1.2357	1.2668	10884916.0
2005-04-18 09:00:00	AAPL	Stock	1.2671	1.2746	1.2143	1.2571	286531056.0
2005-04-18 10:00:00	AAPL	Stock	1.2579	1.2739	1.2411	1.2611	328432580.0
2005-04-18 11:00:00	AAPL	Stock	1.2614	1.2789	1.2579	1.265	178579352.0
2005-04-18 12:00:00	AAPL	Stock	1.265	1.2943	1.2636	1.2896	163350544.0
2005-04-18 13:00:00	AAPL	Stock	1.29	1.2964	1.2793	1.2811	127133300.0
2005-04-18 14:00:00	AAPL	Stock	1.2811	1.2882	1.2636	1.2671	101926804.0
2005-04-18 15:00:00	AAPL	Stock	1.2671	1.2818	1.2596	1.2721	171406060.0
2005-04-18 16:00:00	AAPL	Stock	1.2721	1.2779	1.2696	1.2768	3116120.0
2005-04-18 17:00:00	AAPL	Stock	1.2757	1.2775	1.2721	1.275	413532.0
2005-04-18 18:00:00	AAPL	Stock	1.275	1.2771	1.275	1.2771	40600.0
2005-04-18 07:00:00	MSFT	Stock	24.36	24.36	24.36	24.36	200.0
2005-04-18 08:00:00	MSFT	Stock	24.36	24.49	24.36	24.48	72925.0
2005-04-18 09:00:00	MSFT	Stock	24.47	24.74	24.4	24.7	9921721.0
2005-04-18 10:00:00	MSFT	Stock	24.69	24.71	24.54	24.61	12428394.0
2005-04-18 11:00:00	MSFT	Stock	24.61	24.7	24.61	24.641	9026692.0
2005-04-18 12:00:00	MSFT	Stock	24.64	24.83	24.63	24.78	9514454.0
2005-04-18 13:00:00	MSFT	Stock	24.79	24.84	24.71	24.74	8943200.0
2005-04-18 14:00:00	MSFT	Stock	24.73	24.78	24.58	24.65	11104637.0
2005-04-18 15:00:00	MSFT	Stock	24.64	24.71	24.61	24.67	11673959.0
2005-04-18 16:00:00	MSFT	Stock	24.67	24.78	24.65	24.67	3240485.0
2005-04-18 17:00:00	MSFT	Stock	24.73	24.74	24.71	24.74	4343.0
2005-04-18 18:00:00	MSFT	Stock	24.74	24.92	24.74	24.74	2459.0
2005-04-18 08:00:00	NVDA	Stock	0.178	0.178	0.1766	0.1766	253200.0
2005-04-18 09:00:00	NVDA	Stock	0.1779	0.1799	0.1762	0.1787	57258240.0
2005-04-18 10:00:00	NVDA	Stock	0.1787	0.1807	0.1758	0.1777	102472920.0
2005-04-18 11:00:00	NVDA	Stock	0.1778	0.1791	0.1763	0.177	55377840.0
2005-04-18 12:00:00	NVDA	Stock	0.1769	0.1784	0.1762	0.1778	44536800.0
2005-04-18 13:00:00	NVDA	Stock	0.1778	0.1782	0.1773	0.1777	37476720.0
2005-04-18 14:00:00	NVDA	Stock	0.1777	0.1785	0.1769	0.177	55348320.0
2005-04-18 15:00:00	NVDA	Stock	0.177	0.1779	0.1765	0.177	111984840.0
2005-04-18 16:00:00	NVDA	Stock	0.1768	0.1772	0.176	0.1772	4253880.0
2005-04-18 07:00:00	AMZN	Stock	1.649	1.649	1.649	1.649	10000.0
2005-04-18 08:00:00	AMZN	Stock	1.651	1.651	1.635	1.6425	2599740.0
2005-04-18 09:00:00	AMZN	Stock	1.6425	1.672	1.642	1.662	17895720.0
2005-04-18 10:00:00	AMZN	Stock	1.6625	1.6745	1.656	1.669	30477080.0
2005-04-18 11:00:00	AMZN	Stock	1.67	1.679	1.6635	1.6665	20805920.0
2005-04-18 12:00:00	AMZN	Stock	1.666	1.6745	1.662	1.6735	11645160.0
2005-04-18 13:00:00	AMZN	Stock	1.6721	1.676	1.665	1.666	13441800.0
2005-04-18 14:00:00	AMZN	Stock	1.6655	1.6685	1.646	1.651	19477200.0
2005-04-18 15:00:00	AMZN	Stock	1.6515	1.657	1.6475	1.6505	26919280.0
2005-04-18 16:00:00	AMZN	Stock	1.6505	1.6625	1.6485	1.65	1551500.0
2005-04-18 17:00:00	AMZN	Stock	1.65	1.65	1.65	1.65	350000.0
2005-04-18 08:00:00	CL	Stock	26.35	26.35	26.35	26.35	1000.0
2005-04-18 09:00:00	CL	Stock	26.36	26.45	26.135	26.255	377800.0
2005-04-18 10:00:00	CL	Stock	26.255	26.285	26.0	26.095	831200.0
2005-04-18 11:00:00	CL	Stock	26.115	26.17	26.05	26.135	439800.0
2005-04-18 12:00:00	CL	Stock	26.135	26.235	26.13	26.18	431600.0
2005-04-18 13:00:00	CL	Stock	26.18	26.25	26.15	26.215	351600.0

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

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