PREVIEW / stock_1hour / 2006-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-31.parquet
  size:    614 KB
  rows:    30,086
  symbols: 2,341

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-08-31 07:00:00	AAPL	Stock	2.39	2.3961	2.39	2.3961	70000.0
2006-08-31 08:00:00	AAPL	Stock	2.3929	2.4025	2.3921	2.4011	799400.0
2006-08-31 09:00:00	AAPL	Stock	2.4011	2.4071	2.3936	2.3993	63161308.0
2006-08-31 10:00:00	AAPL	Stock	2.3993	2.4054	2.3807	2.395	97983928.0
2006-08-31 11:00:00	AAPL	Stock	2.3946	2.4136	2.3907	2.4093	77623812.0
2006-08-31 12:00:00	AAPL	Stock	2.4096	2.4229	2.4096	2.4179	73977820.0
2006-08-31 13:00:00	AAPL	Stock	2.4175	2.4186	2.4039	2.4086	42980308.0
2006-08-31 14:00:00	AAPL	Stock	2.4082	2.4254	2.4057	2.4243	57447740.0
2006-08-31 15:00:00	AAPL	Stock	2.4243	2.4393	2.4221	2.4232	148004192.0
2006-08-31 16:00:00	AAPL	Stock	2.4246	2.4257	2.4196	2.4221	1690696.0
2006-08-31 17:00:00	AAPL	Stock	2.4221	2.4246	2.4204	2.4246	168616.0
2006-08-31 18:00:00	AAPL	Stock	2.4229	2.4232	2.4207	2.4214	101724.0
2006-08-31 08:00:00	MSFT	Stock	25.78	25.86	25.78	25.86	1100.0
2006-08-31 09:00:00	MSFT	Stock	25.84	25.98	25.8	25.92	3641943.0
2006-08-31 10:00:00	MSFT	Stock	25.92	25.96	25.8	25.88	5178888.0
2006-08-31 11:00:00	MSFT	Stock	25.88	25.89	25.76	25.78	2180807.0
2006-08-31 12:00:00	MSFT	Stock	25.78	25.83	25.76	25.77	2113854.0
2006-08-31 13:00:00	MSFT	Stock	25.77	25.8	25.75	25.78	1659847.0
2006-08-31 14:00:00	MSFT	Stock	25.78	25.82	25.75	25.76	2842951.0
2006-08-31 15:00:00	MSFT	Stock	25.76	25.816	25.68	25.68	5826938.0
2006-08-31 16:00:00	MSFT	Stock	25.67	25.73	25.67	25.7	126513.0
2006-08-31 18:00:00	MSFT	Stock	25.69	25.71	25.69	25.71	40732.0
2006-08-31 08:00:00	NVDA	Stock	0.485	0.4872	0.485	0.4858	394500.0
2006-08-31 09:00:00	NVDA	Stock	0.4858	0.4858	0.4802	0.4833	46989180.0
2006-08-31 10:00:00	NVDA	Stock	0.4833	0.4865	0.4778	0.4792	106911420.0
2006-08-31 11:00:00	NVDA	Stock	0.4792	0.4793	0.4747	0.4788	66072900.0
2006-08-31 12:00:00	NVDA	Stock	0.4787	0.4808	0.4763	0.4805	43246560.0
2006-08-31 13:00:00	NVDA	Stock	0.4805	0.4807	0.4763	0.4767	33870600.0
2006-08-31 14:00:00	NVDA	Stock	0.4765	0.4815	0.4765	0.4805	43951200.0
2006-08-31 15:00:00	NVDA	Stock	0.4805	0.488	0.4805	0.4843	149064900.0
2006-08-31 16:00:00	NVDA	Stock	0.4843	0.4867	0.4838	0.4852	4521540.0
2006-08-31 17:00:00	NVDA	Stock	0.4852	0.4933	0.4852	0.4933	494400.0
2006-08-31 18:00:00	NVDA	Stock	0.4852	0.4882	0.4852	0.4882	621120.0
2006-08-31 09:00:00	AMZN	Stock	1.5425	1.5425	1.5235	1.5335	16125440.0
2006-08-31 10:00:00	AMZN	Stock	1.5335	1.5455	1.5255	1.531	30721540.0
2006-08-31 11:00:00	AMZN	Stock	1.531	1.5385	1.5265	1.5375	11574760.0
2006-08-31 12:00:00	AMZN	Stock	1.538	1.547	1.5325	1.546	13999560.0
2006-08-31 13:00:00	AMZN	Stock	1.5455	1.5455	1.5345	1.5345	12450900.0
2006-08-31 14:00:00	AMZN	Stock	1.5345	1.542	1.5345	1.5375	9298720.0
2006-08-31 15:00:00	AMZN	Stock	1.537	1.5495	1.5365	1.541	19862600.0
2006-08-31 16:00:00	AMZN	Stock	1.5405	1.542	1.5365	1.541	585560.0
2006-08-31 17:00:00	AMZN	Stock	1.5415	1.5415	1.541	1.541	26000.0
2006-08-31 18:00:00	AMZN	Stock	1.5415	1.5415	1.5415	1.5415	396580.0
2006-08-31 09:00:00	CL	Stock	29.765	29.865	29.72	29.855	223600.0
2006-08-31 10:00:00	CL	Stock	29.855	29.96	29.835	29.94	469800.0
2006-08-31 11:00:00	CL	Stock	29.935	29.975	29.9	29.945	392200.0
2006-08-31 12:00:00	CL	Stock	29.96	30.025	29.935	29.975	332400.0
2006-08-31 13:00:00	CL	Stock	29.97	30.035	29.93	29.965	283000.0
2006-08-31 14:00:00	CL	Stock	29.965	30.005	29.93	29.975	309200.0
2006-08-31 15:00:00	CL	Stock	29.97	30.0	29.93	29.935	630800.0

> showing 50 of 30,086 rows — these rows as CSV

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