PREVIEW / stock_1hour / 2006-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-05.parquet
  size:    617 KB
  rows:    29,413
  symbols: 2,381

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
2006-10-05 06:00:00	AAPL	Stock	2.6864	2.6964	2.6804	2.6804	103600.0
2006-10-05 07:00:00	AAPL	Stock	2.6611	2.675	2.6554	2.6671	458080.0
2006-10-05 08:00:00	AAPL	Stock	2.6611	2.6696	2.6554	2.6607	5058676.0
2006-10-05 09:00:00	AAPL	Stock	2.6607	2.6854	2.6475	2.6818	122937948.0
2006-10-05 10:00:00	AAPL	Stock	2.6818	2.72	2.6654	2.7129	179518948.0
2006-10-05 11:00:00	AAPL	Stock	2.7129	2.7196	2.6857	2.6946	112754488.0
2006-10-05 12:00:00	AAPL	Stock	2.6943	2.6968	2.6696	2.6732	66505236.0
2006-10-05 13:00:00	AAPL	Stock	2.6732	2.6854	2.6696	2.6743	49068208.0
2006-10-05 14:00:00	AAPL	Stock	2.6743	2.7089	2.6693	2.6764	40621196.0
2006-10-05 15:00:00	AAPL	Stock	2.6764	2.6829	2.6657	2.6696	77049112.0
2006-10-05 16:00:00	AAPL	Stock	2.6682	2.6725	2.6679	2.67	10982300.0
2006-10-05 17:00:00	AAPL	Stock	2.6696	2.6725	2.6689	2.6689	10010756.0
2006-10-05 18:00:00	AAPL	Stock	2.6689	2.6732	2.6689	2.6732	53172.0
2006-10-05 19:00:00	AAPL	Stock	2.6714	2.6714	2.6682	2.6682	35000.0
2006-10-05 06:00:00	MSFT	Stock	27.9	27.9	27.9	27.9	400.0
2006-10-05 08:00:00	MSFT	Stock	27.9	27.9	27.83	27.86	17870.0
2006-10-05 09:00:00	MSFT	Stock	27.85	28.11	27.83	28.07	15569028.0
2006-10-05 10:00:00	MSFT	Stock	28.08	28.1	27.8	27.93	14429147.0
2006-10-05 11:00:00	MSFT	Stock	27.93	28.0	27.83	27.95	14656899.0
2006-10-05 12:00:00	MSFT	Stock	27.95	27.99	27.87	27.9	9734975.0
2006-10-05 13:00:00	MSFT	Stock	27.902	28.08	27.82	27.84	5928539.0
2006-10-05 14:00:00	MSFT	Stock	27.84	27.91	27.78	27.9	6293443.0
2006-10-05 15:00:00	MSFT	Stock	27.9	27.95	27.86	27.94	10078745.0
2006-10-05 16:00:00	MSFT	Stock	27.93	27.94	27.807	27.88	1041434.0
2006-10-05 17:00:00	MSFT	Stock	27.9	27.94	27.9	27.93	601351.0
2006-10-05 18:00:00	MSFT	Stock	27.92	27.94	27.92	27.92	11913.0
2006-10-05 08:00:00	NVDA	Stock	0.518	0.5248	0.5135	0.5192	1681080.0
2006-10-05 09:00:00	NVDA	Stock	0.5208	0.5232	0.5108	0.5187	119356680.0
2006-10-05 10:00:00	NVDA	Stock	0.5187	0.5187	0.505	0.5102	133858020.0
2006-10-05 11:00:00	NVDA	Stock	0.5102	0.5163	0.5055	0.5099	96971400.0
2006-10-05 12:00:00	NVDA	Stock	0.5097	0.5107	0.502	0.5027	80392800.0
2006-10-05 13:00:00	NVDA	Stock	0.5025	0.5083	0.5023	0.5062	53078760.0
2006-10-05 14:00:00	NVDA	Stock	0.5063	0.5077	0.5025	0.5043	61825740.0
2006-10-05 15:00:00	NVDA	Stock	0.5043	0.5073	0.503	0.5043	82254600.0
2006-10-05 16:00:00	NVDA	Stock	0.5042	0.5042	0.5033	0.5038	812760.0
2006-10-05 17:00:00	NVDA	Stock	0.5033	0.5042	0.5008	0.5017	2189280.0
2006-10-05 18:00:00	NVDA	Stock	0.5	0.5043	0.5	0.5025	507000.0
2006-10-05 19:00:00	NVDA	Stock	0.5025	0.5048	0.5017	0.5022	201000.0
2006-10-05 08:00:00	AMZN	Stock	1.64	1.64	1.64	1.64	20000.0
2006-10-05 09:00:00	AMZN	Stock	1.6275	1.6485	1.62	1.636	15984480.0
2006-10-05 10:00:00	AMZN	Stock	1.6355	1.6375	1.625	1.63	23372660.0
2006-10-05 11:00:00	AMZN	Stock	1.63	1.662	1.628	1.6505	23464020.0
2006-10-05 12:00:00	AMZN	Stock	1.651	1.6575	1.6465	1.6545	14523440.0
2006-10-05 13:00:00	AMZN	Stock	1.655	1.67	1.654	1.662	17502560.0
2006-10-05 14:00:00	AMZN	Stock	1.662	1.663	1.6225	1.655	43067440.0
2006-10-05 15:00:00	AMZN	Stock	1.655	1.6685	1.6515	1.665	25042360.0
2006-10-05 16:00:00	AMZN	Stock	1.665	1.674	1.6524	1.674	1242420.0
2006-10-05 17:00:00	AMZN	Stock	1.668	1.668	1.665	1.665	39000.0
2006-10-05 18:00:00	AMZN	Stock	1.6625	1.6625	1.6625	1.6625	19080.0
2006-10-05 19:00:00	AMZN	Stock	1.665	1.665	1.665	1.665	32000.0

> showing 50 of 29,413 rows — these rows as CSV

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