PREVIEW / stock_1hour / 2008-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-20.parquet
  size:    838 KB
  rows:    41,618
  symbols: 3,269

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
2008-03-20 04:00:00	AAPL	Stock	4.6107	4.6107	4.6107	4.6107	2800.0
2008-03-20 05:00:00	AAPL	Stock	4.6346	4.6346	4.6346	4.6346	28000.0
2008-03-20 06:00:00	AAPL	Stock	4.6314	4.6314	4.6314	4.6314	14000.0
2008-03-20 07:00:00	AAPL	Stock	4.6339	4.6564	4.6339	4.65	58912.0
2008-03-20 08:00:00	AAPL	Stock	4.65	4.6571	4.615	4.6186	2131864.0
2008-03-20 09:00:00	AAPL	Stock	4.6211	4.69	4.6179	4.6654	173008836.0
2008-03-20 10:00:00	AAPL	Stock	4.665	4.6868	4.6439	4.6721	129009244.0
2008-03-20 11:00:00	AAPL	Stock	4.6718	4.6725	4.6136	4.62	99581300.0
2008-03-20 12:00:00	AAPL	Stock	4.62	4.6518	4.62	4.6411	69100360.0
2008-03-20 13:00:00	AAPL	Stock	4.6411	4.6821	4.6357	4.6754	78610588.0
2008-03-20 14:00:00	AAPL	Stock	4.6761	4.7361	4.6625	4.7268	118473488.0
2008-03-20 15:00:00	AAPL	Stock	4.7264	4.7604	4.7054	4.7596	163339764.0
2008-03-20 16:00:00	AAPL	Stock	4.7532	4.7636	4.6781	4.7596	55865488.0
2008-03-20 17:00:00	AAPL	Stock	4.7593	4.7671	4.682	4.7604	1599640.0
2008-03-20 18:00:00	AAPL	Stock	4.7589	4.7604	4.7514	4.7539	453852.0
2008-03-20 19:00:00	AAPL	Stock	4.7521	4.7543	4.7411	4.7529	412692.0
2008-03-20 07:00:00	MSFT	Stock	28.68	28.68	28.65	28.66	1300.0
2008-03-20 08:00:00	MSFT	Stock	28.75	28.75	28.45	28.58	71874.0
2008-03-20 09:00:00	MSFT	Stock	28.6	29.08	28.56	28.92	6058186.0
2008-03-20 10:00:00	MSFT	Stock	28.93	29.09	28.78	28.87	6793744.0
2008-03-20 11:00:00	MSFT	Stock	28.86	28.96	28.75	28.778	4490030.0
2008-03-20 12:00:00	MSFT	Stock	28.78	28.9	28.74	28.77	4686385.0
2008-03-20 13:00:00	MSFT	Stock	28.78	29.01	28.74	28.96	3237593.0
2008-03-20 14:00:00	MSFT	Stock	28.97	29.05	28.89	28.99	4842781.0
2008-03-20 15:00:00	MSFT	Stock	28.98	29.19	28.92	29.19	10987554.0
2008-03-20 16:00:00	MSFT	Stock	29.19	29.23	28.872	29.15	4852377.0
2008-03-20 17:00:00	MSFT	Stock	29.18	29.25	28.974	29.12	53715.0
2008-03-20 18:00:00	MSFT	Stock	29.23	29.28	29.2	29.2	2567.0
2008-03-20 19:00:00	MSFT	Stock	29.2	29.25	29.2	29.25	2595.0
2008-03-20 08:00:00	NVDA	Stock	0.445	0.4495	0.4428	0.4428	301400.0
2008-03-20 09:00:00	NVDA	Stock	0.4438	0.449	0.4388	0.4468	114416760.0
2008-03-20 10:00:00	NVDA	Stock	0.4465	0.4552	0.4455	0.4512	78737080.0
2008-03-20 11:00:00	NVDA	Stock	0.4512	0.4535	0.448	0.4498	49481360.0
2008-03-20 12:00:00	NVDA	Stock	0.45	0.4535	0.4488	0.4488	50351080.0
2008-03-20 13:00:00	NVDA	Stock	0.449	0.456	0.4476	0.4541	44241320.0
2008-03-20 14:00:00	NVDA	Stock	0.4542	0.4585	0.4535	0.4568	67679760.0
2008-03-20 15:00:00	NVDA	Stock	0.4565	0.464	0.4565	0.4638	178879120.0
2008-03-20 16:00:00	NVDA	Stock	0.4648	0.465	0.4549	0.464	24159680.0
2008-03-20 17:00:00	NVDA	Stock	0.462	0.464	0.4575	0.4638	485240.0
2008-03-20 18:00:00	NVDA	Stock	0.4625	0.4625	0.4625	0.4625	20000.0
2008-03-20 19:00:00	NVDA	Stock	0.4625	0.4625	0.4603	0.4603	23280.0
2008-03-20 07:00:00	AMZN	Stock	3.5125	3.5125	3.5125	3.5125	4000.0
2008-03-20 08:00:00	AMZN	Stock	3.5085	3.5135	3.4745	3.4745	1018100.0
2008-03-20 09:00:00	AMZN	Stock	3.495	3.547	3.4775	3.5332	29935180.0
2008-03-20 10:00:00	AMZN	Stock	3.5335	3.62	3.469	3.614	46163540.0
2008-03-20 11:00:00	AMZN	Stock	3.612	3.617	3.5075	3.5165	23663120.0
2008-03-20 12:00:00	AMZN	Stock	3.5175	3.5495	3.5	3.5015	15671140.0
2008-03-20 13:00:00	AMZN	Stock	3.5049	3.573	3.5035	3.5635	17945300.0
2008-03-20 14:00:00	AMZN	Stock	3.5635	3.6375	3.561	3.628	28456000.0
2008-03-20 15:00:00	AMZN	Stock	3.627	3.6745	3.624	3.661	48489500.0

> showing 50 of 41,618 rows — these rows as CSV

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