PREVIEW / stock_1hour / 2005-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-01.parquet
  size:    554 KB
  rows:    26,302
  symbols: 1,943

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-03-01 08:00:00	AAPL	Stock	1.6086	1.6111	1.6021	1.6079	3957940.0
2005-03-01 09:00:00	AAPL	Stock	1.6082	1.6111	1.5929	1.5932	90079864.0
2005-03-01 10:00:00	AAPL	Stock	1.5936	1.6071	1.5904	1.5982	83241816.0
2005-03-01 11:00:00	AAPL	Stock	1.5982	1.5986	1.5864	1.5893	77920668.0
2005-03-01 12:00:00	AAPL	Stock	1.5893	1.5921	1.5839	1.5871	43328824.0
2005-03-01 13:00:00	AAPL	Stock	1.5871	1.6107	1.5771	1.5868	53896500.0
2005-03-01 14:00:00	AAPL	Stock	1.5868	1.6107	1.5821	1.5886	37045400.0
2005-03-01 15:00:00	AAPL	Stock	1.5886	1.6107	1.5857	1.5868	60578140.0
2005-03-01 16:00:00	AAPL	Stock	1.5871	1.5936	1.5857	1.5893	4264120.0
2005-03-01 17:00:00	AAPL	Stock	1.6021	1.6021	1.5864	1.5893	630392.0
2005-03-01 08:00:00	MSFT	Stock	25.16	25.21	25.16	25.18	25215.0
2005-03-01 09:00:00	MSFT	Stock	25.19	25.24	25.15	25.18	6161129.0
2005-03-01 10:00:00	MSFT	Stock	25.17	25.311	25.13	25.29	9961416.0
2005-03-01 11:00:00	MSFT	Stock	25.281	25.32	25.19	25.3	6023158.0
2005-03-01 12:00:00	MSFT	Stock	25.3	25.311	25.2	25.23	6103460.0
2005-03-01 13:00:00	MSFT	Stock	25.23	25.26	25.16	25.25	8598200.0
2005-03-01 14:00:00	MSFT	Stock	25.25	25.41	25.2	25.29	9407427.0
2005-03-01 15:00:00	MSFT	Stock	25.28	25.34	25.26	25.27	8440478.0
2005-03-01 16:00:00	MSFT	Stock	25.27	25.29	25.21	25.26	479371.0
2005-03-01 17:00:00	MSFT	Stock	25.25	25.28	25.25	25.28	121427.0
2005-03-01 18:00:00	MSFT	Stock	25.28	25.28	25.25	25.25	153700.0
2005-03-01 08:00:00	NVDA	Stock	0.2422	0.2422	0.2417	0.242	180000.0
2005-03-01 09:00:00	NVDA	Stock	0.2423	0.2452	0.2408	0.2441	161453400.0
2005-03-01 10:00:00	NVDA	Stock	0.244	0.2467	0.2436	0.2455	183798000.0
2005-03-01 11:00:00	NVDA	Stock	0.2455	0.2456	0.242	0.244	98646240.0
2005-03-01 12:00:00	NVDA	Stock	0.244	0.2442	0.241	0.2421	52326120.0
2005-03-01 13:00:00	NVDA	Stock	0.242	0.2421	0.2386	0.2406	57313680.0
2005-03-01 14:00:00	NVDA	Stock	0.2407	0.2412	0.2388	0.2395	68433480.0
2005-03-01 15:00:00	NVDA	Stock	0.2395	0.2417	0.2392	0.2412	88536000.0
2005-03-01 16:00:00	NVDA	Stock	0.241	0.2412	0.2406	0.2406	5726880.0
2005-03-01 17:00:00	NVDA	Stock	0.2406	0.2406	0.2406	0.2406	120000.0
2005-03-01 18:00:00	NVDA	Stock	0.2408	0.2409	0.2408	0.2409	240000.0
2005-03-01 08:00:00	AMZN	Stock	1.749	1.757	1.749	1.75	46000.0
2005-03-01 09:00:00	AMZN	Stock	1.75	1.761	1.747	1.75	15099840.0
2005-03-01 10:00:00	AMZN	Stock	1.75	1.7565	1.741	1.7465	25019200.0
2005-03-01 11:00:00	AMZN	Stock	1.7465	1.756	1.742	1.7525	17984360.0
2005-03-01 12:00:00	AMZN	Stock	1.7525	1.754	1.746	1.7485	13775560.0
2005-03-01 13:00:00	AMZN	Stock	1.748	1.752	1.7415	1.7468	7636420.0
2005-03-01 14:00:00	AMZN	Stock	1.7465	1.7665	1.746	1.7645	17003420.0
2005-03-01 15:00:00	AMZN	Stock	1.7645	1.7705	1.76	1.77	18012640.0
2005-03-01 16:00:00	AMZN	Stock	1.77	1.772	1.766	1.77	300000.0
2005-03-01 17:00:00	AMZN	Stock	1.77	1.77	1.7685	1.7685	252900.0
2005-03-01 18:00:00	AMZN	Stock	1.7715	1.7715	1.771	1.771	10000.0
2005-03-01 09:00:00	CL	Stock	26.46	26.76	26.445	26.715	618600.0
2005-03-01 10:00:00	CL	Stock	26.72	26.78	26.65	26.66	839400.0
2005-03-01 11:00:00	CL	Stock	26.66	26.75	26.625	26.725	519800.0
2005-03-01 12:00:00	CL	Stock	26.72	26.735	26.63	26.645	499000.0
2005-03-01 13:00:00	CL	Stock	26.64	26.645	26.585	26.59	460800.0
2005-03-01 14:00:00	CL	Stock	26.59	26.595	26.5	26.535	547600.0
2005-03-01 15:00:00	CL	Stock	26.54	26.54	26.39	26.435	1071600.0

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

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