PREVIEW / stock_1hour / 2005-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-28.parquet
  size:    543 KB
  rows:    25,403
  symbols: 1,961

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-28 07:00:00	AAPL	Stock	1.3175	1.3175	1.2939	1.2939	31640.0
2005-04-28 08:00:00	AAPL	Stock	1.2982	1.3014	1.2929	1.3014	4542664.0
2005-04-28 09:00:00	AAPL	Stock	1.3014	1.3036	1.2732	1.2789	82819856.0
2005-04-28 10:00:00	AAPL	Stock	1.2786	1.2893	1.2761	1.2804	93603776.0
2005-04-28 11:00:00	AAPL	Stock	1.2804	1.2875	1.2657	1.2675	78171296.0
2005-04-28 12:00:00	AAPL	Stock	1.2671	1.2732	1.2586	1.2711	77398048.0
2005-04-28 13:00:00	AAPL	Stock	1.2711	1.2818	1.2654	1.28	54971280.0
2005-04-28 14:00:00	AAPL	Stock	1.2793	1.2814	1.2675	1.2729	78396332.0
2005-04-28 15:00:00	AAPL	Stock	1.2729	1.2736	1.2661	1.2693	79237116.0
2005-04-28 16:00:00	AAPL	Stock	1.2682	1.2729	1.2671	1.2714	3998400.0
2005-04-28 17:00:00	AAPL	Stock	1.2671	1.275	1.2671	1.2714	693476.0
2005-04-28 18:00:00	AAPL	Stock	1.2743	1.2757	1.2743	1.2754	81760.0
2005-04-28 08:00:00	MSFT	Stock	25.03	25.03	24.89	24.9	72095.0
2005-04-28 09:00:00	MSFT	Stock	24.93	24.98	24.63	24.68	11201402.0
2005-04-28 10:00:00	MSFT	Stock	24.682	24.84	24.65	24.72	13133602.0
2005-04-28 11:00:00	MSFT	Stock	24.72	24.79	24.67	24.75	8939129.0
2005-04-28 12:00:00	MSFT	Stock	24.76	24.831	24.72	24.74	5145518.0
2005-04-28 13:00:00	MSFT	Stock	24.75	24.83	24.7	24.83	7767733.0
2005-04-28 14:00:00	MSFT	Stock	24.83	24.85	24.65	24.68	9431637.0
2005-04-28 15:00:00	MSFT	Stock	24.69	24.75	24.44	24.46	18375857.0
2005-04-28 16:00:00	MSFT	Stock	24.47	24.8	24.02	24.66	8396769.0
2005-04-28 17:00:00	MSFT	Stock	24.65	24.65	24.45	24.57	590100.0
2005-04-28 18:00:00	MSFT	Stock	24.6	24.64	24.504	24.63	147307.0
2005-04-28 09:00:00	NVDA	Stock	0.1798	0.1832	0.1779	0.1792	50890440.0
2005-04-28 10:00:00	NVDA	Stock	0.1794	0.1806	0.1783	0.1792	38807280.0
2005-04-28 11:00:00	NVDA	Stock	0.1793	0.1811	0.1792	0.1802	41759280.0
2005-04-28 12:00:00	NVDA	Stock	0.1802	0.1811	0.1794	0.1807	32140200.0
2005-04-28 13:00:00	NVDA	Stock	0.1807	0.1827	0.1806	0.1822	45867960.0
2005-04-28 14:00:00	NVDA	Stock	0.1823	0.1823	0.1799	0.1807	61682280.0
2005-04-28 15:00:00	NVDA	Stock	0.1807	0.1812	0.1802	0.1807	94187400.0
2005-04-28 16:00:00	NVDA	Stock	0.1807	0.1826	0.1803	0.1808	1140000.0
2005-04-28 17:00:00	NVDA	Stock	0.181	0.181	0.1807	0.1807	470280.0
2005-04-28 08:00:00	AMZN	Stock	1.5705	1.585	1.5705	1.5755	149000.0
2005-04-28 09:00:00	AMZN	Stock	1.5755	1.606	1.575	1.6045	40476780.0
2005-04-28 10:00:00	AMZN	Stock	1.6045	1.6175	1.5935	1.6115	42222700.0
2005-04-28 11:00:00	AMZN	Stock	1.611	1.629	1.6095	1.624	43543440.0
2005-04-28 12:00:00	AMZN	Stock	1.6235	1.639	1.6225	1.635	31335620.0
2005-04-28 13:00:00	AMZN	Stock	1.635	1.644	1.6325	1.6425	28676980.0
2005-04-28 14:00:00	AMZN	Stock	1.643	1.646	1.6275	1.6315	36884820.0
2005-04-28 15:00:00	AMZN	Stock	1.632	1.6355	1.626	1.6295	57953920.0
2005-04-28 16:00:00	AMZN	Stock	1.633	1.635	1.626	1.626	4538000.0
2005-04-28 17:00:00	AMZN	Stock	1.63	1.633	1.6285	1.633	82000.0
2005-04-28 18:00:00	AMZN	Stock	1.635	1.637	1.635	1.635	49000.0
2005-04-28 09:00:00	CL	Stock	25.315	25.35	25.18	25.195	437200.0
2005-04-28 10:00:00	CL	Stock	25.195	25.54	25.175	25.39	693400.0
2005-04-28 11:00:00	CL	Stock	25.395	25.41	25.25	25.335	465000.0
2005-04-28 12:00:00	CL	Stock	25.34	25.4	25.275	25.305	516200.0
2005-04-28 13:00:00	CL	Stock	25.31	25.44	25.2665	25.42	445000.0
2005-04-28 14:00:00	CL	Stock	25.425	25.425	25.165	25.37	868000.0
2005-04-28 15:00:00	CL	Stock	25.36	25.37	25.175	25.175	894200.0

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

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