PREVIEW / stock_1hour / 2007-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-26.parquet
  size:    712 KB
  rows:    33,491
  symbols: 2,565

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
2007-03-26 07:00:00	AAPL	Stock	3.3482	3.4486	3.3446	3.3746	469000.0
2007-03-26 08:00:00	AAPL	Stock	3.3732	3.3732	3.3536	3.3643	2942212.0
2007-03-26 09:00:00	AAPL	Stock	3.3629	3.3857	3.3489	3.375	114160872.0
2007-03-26 10:00:00	AAPL	Stock	3.375	3.375	3.3321	3.3507	173938548.0
2007-03-26 11:00:00	AAPL	Stock	3.3511	3.3696	3.3461	3.3696	93753268.0
2007-03-26 12:00:00	AAPL	Stock	3.369	3.385	3.3671	3.3811	84393960.0
2007-03-26 13:00:00	AAPL	Stock	3.3811	3.3929	3.3761	3.3925	86325708.0
2007-03-26 14:00:00	AAPL	Stock	3.3925	3.4096	3.3907	3.4096	117383588.0
2007-03-26 15:00:00	AAPL	Stock	3.4096	3.425	3.4089	3.425	170101148.0
2007-03-26 16:00:00	AAPL	Stock	3.425	3.4268	3.3918	3.425	7024892.0
2007-03-26 17:00:00	AAPL	Stock	3.4246	3.425	3.3678	3.4232	5705448.0
2007-03-26 18:00:00	AAPL	Stock	3.4246	3.425	3.4218	3.425	215012.0
2007-03-26 19:00:00	AAPL	Stock	3.4246	3.425	3.4229	3.4232	485800.0
2007-03-26 07:00:00	MSFT	Stock	28.0	28.03	28.0	28.03	2651.0
2007-03-26 08:00:00	MSFT	Stock	28.0	28.02	27.98	27.99	4975.0
2007-03-26 09:00:00	MSFT	Stock	28.02	28.02	27.85	27.922	3235212.0
2007-03-26 10:00:00	MSFT	Stock	27.92	27.92	27.7	27.78	8976158.0
2007-03-26 11:00:00	MSFT	Stock	27.78	27.82	27.7	27.749	4910930.0
2007-03-26 12:00:00	MSFT	Stock	27.75	27.82	27.73	27.74	3594479.0
2007-03-26 13:00:00	MSFT	Stock	27.74	27.87	27.72	27.86	4583336.0
2007-03-26 14:00:00	MSFT	Stock	27.86	28.06	27.85	28.04	5501132.0
2007-03-26 15:00:00	MSFT	Stock	28.05	28.22	28.04	28.22	12011281.0
2007-03-26 16:00:00	MSFT	Stock	28.22	28.23	27.82	28.15	2634598.0
2007-03-26 17:00:00	MSFT	Stock	28.22	28.22	27.72	28.22	324313.0
2007-03-26 18:00:00	MSFT	Stock	28.19	28.21	28.19	28.21	2900.0
2007-03-26 19:00:00	MSFT	Stock	28.15	28.2	28.15	28.2	525.0
2007-03-26 08:00:00	NVDA	Stock	0.5038	0.5038	0.5025	0.5027	66000.0
2007-03-26 09:00:00	NVDA	Stock	0.5042	0.51	0.5035	0.5075	40271700.0
2007-03-26 10:00:00	NVDA	Stock	0.5073	0.5073	0.4967	0.5002	147862020.0
2007-03-26 11:00:00	NVDA	Stock	0.5	0.5027	0.499	0.5003	53988540.0
2007-03-26 12:00:00	NVDA	Stock	0.5003	0.5033	0.4998	0.5003	41766600.0
2007-03-26 13:00:00	NVDA	Stock	0.5002	0.5012	0.4977	0.5	44917260.0
2007-03-26 14:00:00	NVDA	Stock	0.5002	0.5028	0.5	0.5015	32833740.0
2007-03-26 15:00:00	NVDA	Stock	0.5013	0.5058	0.501	0.5058	74892060.0
2007-03-26 16:00:00	NVDA	Stock	0.5058	0.5063	0.5005	0.5063	2386200.0
2007-03-26 17:00:00	NVDA	Stock	0.5013	0.507	0.4983	0.5037	2784300.0
2007-03-26 18:00:00	NVDA	Stock	0.5067	0.507	0.5067	0.507	72000.0
2007-03-26 09:00:00	AMZN	Stock	1.947	1.9498	1.94	1.9449	5192700.0
2007-03-26 10:00:00	AMZN	Stock	1.9445	1.9465	1.9215	1.9335	13647560.0
2007-03-26 11:00:00	AMZN	Stock	1.9335	1.9425	1.927	1.9344	6889120.0
2007-03-26 12:00:00	AMZN	Stock	1.934	1.9385	1.93	1.9345	8109240.0
2007-03-26 13:00:00	AMZN	Stock	1.9345	1.9365	1.9275	1.936	7398780.0
2007-03-26 14:00:00	AMZN	Stock	1.9365	1.951	1.935	1.951	10100900.0
2007-03-26 15:00:00	AMZN	Stock	1.9515	1.9525	1.9455	1.952	14591560.0
2007-03-26 16:00:00	AMZN	Stock	1.952	1.9525	1.9376	1.9495	193520.0
2007-03-26 17:00:00	AMZN	Stock	1.9363	1.9515	1.931	1.9325	164380.0
2007-03-26 18:00:00	AMZN	Stock	1.9455	1.9455	1.9455	1.9455	2000.0
2007-03-26 09:00:00	CL	Stock	33.595	33.595	33.365	33.47	203400.0
2007-03-26 10:00:00	CL	Stock	33.475	33.475	33.165	33.21	617200.0
2007-03-26 11:00:00	CL	Stock	33.215	33.34	33.13	33.31	333200.0

> showing 50 of 33,491 rows — these rows as CSV

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