PREVIEW / stock_1hour / 2005-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-19.parquet
  size:    582 KB
  rows:    27,547
  symbols: 2,099

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-10-19 07:00:00	AAPL	Stock	1.8461	1.8464	1.8461	1.8464	43680.0
2005-10-19 08:00:00	AAPL	Stock	1.845	1.8571	1.8357	1.8514	3026240.0
2005-10-19 09:00:00	AAPL	Stock	1.8518	1.8632	1.8375	1.8518	65556232.0
2005-10-19 10:00:00	AAPL	Stock	1.8518	1.8661	1.8457	1.8557	92429316.0
2005-10-19 11:00:00	AAPL	Stock	1.8554	1.8586	1.8289	1.8314	70795256.0
2005-10-19 12:00:00	AAPL	Stock	1.8318	1.8504	1.8314	1.8443	57264984.0
2005-10-19 13:00:00	AAPL	Stock	1.8439	1.9043	1.8382	1.8975	162706544.0
2005-10-19 14:00:00	AAPL	Stock	1.8975	1.9264	1.8929	1.9204	220162712.0
2005-10-19 15:00:00	AAPL	Stock	1.92	1.9629	1.9171	1.9596	313729752.0
2005-10-19 16:00:00	AAPL	Stock	1.9596	1.9907	1.9564	1.9625	9389548.0
2005-10-19 17:00:00	AAPL	Stock	1.9607	1.9636	1.9589	1.9636	2388092.0
2005-10-19 18:00:00	AAPL	Stock	1.9625	1.9625	1.9579	1.9625	385924.0
2005-10-19 07:00:00	MSFT	Stock	24.41	24.41	24.41	24.41	5000.0
2005-10-19 08:00:00	MSFT	Stock	24.43	24.57	24.43	24.48	73699.0
2005-10-19 09:00:00	MSFT	Stock	24.48	24.76	24.47	24.74	7671089.0
2005-10-19 10:00:00	MSFT	Stock	24.74	24.94	24.73	24.86	11770129.0
2005-10-19 11:00:00	MSFT	Stock	24.85	24.94	24.8	24.83	8976918.0
2005-10-19 12:00:00	MSFT	Stock	24.83	24.93	24.81	24.84	5779746.0
2005-10-19 13:00:00	MSFT	Stock	24.85	24.87	24.8	24.81	4796316.0
2005-10-19 14:00:00	MSFT	Stock	24.8	24.98	24.78	24.95	10323324.0
2005-10-19 15:00:00	MSFT	Stock	24.95	25.09	24.93	25.07	14698605.0
2005-10-19 16:00:00	MSFT	Stock	25.08	25.1	25.04	25.07	813710.0
2005-10-19 17:00:00	MSFT	Stock	25.06	25.09	25.06	25.08	32535.0
2005-10-19 18:00:00	MSFT	Stock	25.1	25.1	24.865	25.06	32180.0
2005-10-19 08:00:00	NVDA	Stock	0.2625	0.2633	0.2612	0.2612	228000.0
2005-10-19 09:00:00	NVDA	Stock	0.2624	0.2625	0.2542	0.2575	75098040.0
2005-10-19 10:00:00	NVDA	Stock	0.2575	0.2583	0.2554	0.2564	88328520.0
2005-10-19 11:00:00	NVDA	Stock	0.2563	0.2567	0.2543	0.2554	48117840.0
2005-10-19 12:00:00	NVDA	Stock	0.2554	0.2567	0.2549	0.2554	54824760.0
2005-10-19 13:00:00	NVDA	Stock	0.2553	0.2577	0.2548	0.2572	70534800.0
2005-10-19 14:00:00	NVDA	Stock	0.2573	0.2608	0.2572	0.2593	169816440.0
2005-10-19 15:00:00	NVDA	Stock	0.2593	0.2632	0.2593	0.2628	120549120.0
2005-10-19 16:00:00	NVDA	Stock	0.2628	0.263	0.2626	0.2626	1989240.0
2005-10-19 17:00:00	NVDA	Stock	0.2626	0.2626	0.2626	0.2626	60000.0
2005-10-19 08:00:00	AMZN	Stock	2.225	2.225	2.2225	2.2225	6000.0
2005-10-19 09:00:00	AMZN	Stock	2.2235	2.2745	2.214	2.2635	17106920.0
2005-10-19 10:00:00	AMZN	Stock	2.2632	2.2775	2.2515	2.26	17079240.0
2005-10-19 11:00:00	AMZN	Stock	2.26	2.2625	2.236	2.2515	14290280.0
2005-10-19 12:00:00	AMZN	Stock	2.2515	2.274	2.25	2.259	11282760.0
2005-10-19 13:00:00	AMZN	Stock	2.2595	2.2725	2.2505	2.262	11810180.0
2005-10-19 14:00:00	AMZN	Stock	2.2625	2.2895	2.2595	2.2865	20428600.0
2005-10-19 15:00:00	AMZN	Stock	2.2865	2.293	2.275	2.2915	25207920.0
2005-10-19 16:00:00	AMZN	Stock	2.292	2.299	2.254	2.2575	2800720.0
2005-10-19 17:00:00	AMZN	Stock	2.262	2.293	2.2555	2.2625	4654000.0
2005-10-19 18:00:00	AMZN	Stock	2.275	2.275	2.275	2.275	31600.0
2005-10-19 08:00:00	CL	Stock	26.1435	26.1435	26.1435	26.1435	147800.0
2005-10-19 09:00:00	CL	Stock	25.88	25.965	25.855	25.915	352200.0
2005-10-19 10:00:00	CL	Stock	25.915	26.05	25.885	25.925	448000.0
2005-10-19 11:00:00	CL	Stock	25.92	25.935	25.85	25.865	415400.0
2005-10-19 12:00:00	CL	Stock	25.865	25.99	25.86	25.95	408600.0

> showing 50 of 27,547 rows — these rows as CSV

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