PREVIEW / stock_1hour / 2007-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-12.parquet
  size:    691 KB
  rows:    32,357
  symbols: 2,528

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-12 05:00:00	AAPL	Stock	3.1786	3.1786	3.1786	3.1786	8400.0
2007-03-12 07:00:00	AAPL	Stock	3.1607	3.1696	3.1607	3.1643	551600.0
2007-03-12 08:00:00	AAPL	Stock	3.1589	3.1607	3.1414	3.1475	1132740.0
2007-03-12 09:00:00	AAPL	Stock	3.145	3.1696	3.14	3.1596	75249328.0
2007-03-12 10:00:00	AAPL	Stock	3.16	3.1982	3.1571	3.1932	185738140.0
2007-03-12 11:00:00	AAPL	Stock	3.1932	3.21	3.1918	3.2036	137873456.0
2007-03-12 12:00:00	AAPL	Stock	3.2039	3.2125	3.2011	3.2096	70832020.0
2007-03-12 13:00:00	AAPL	Stock	3.2093	3.2139	3.1932	3.2025	79090368.0
2007-03-12 14:00:00	AAPL	Stock	3.2025	3.2118	3.1936	3.2061	76442604.0
2007-03-12 15:00:00	AAPL	Stock	3.2061	3.2104	3.195	3.21	93469124.0
2007-03-12 16:00:00	AAPL	Stock	3.2104	3.2204	3.1495	3.2107	4485852.0
2007-03-12 17:00:00	AAPL	Stock	3.2121	3.2143	3.2107	3.2143	226212.0
2007-03-12 18:00:00	AAPL	Stock	3.2129	3.2175	3.2125	3.2161	293160.0
2007-03-12 19:00:00	AAPL	Stock	3.2161	3.2161	3.2125	3.2161	175532.0
2007-03-12 08:00:00	MSFT	Stock	27.35	27.35	27.25	27.29	60120.0
2007-03-12 09:00:00	MSFT	Stock	27.28	27.37	27.13	27.24	4961383.0
2007-03-12 10:00:00	MSFT	Stock	27.24	27.34	27.21	27.28	4741322.0
2007-03-12 11:00:00	MSFT	Stock	27.28	27.29	27.19	27.2	4338390.0
2007-03-12 12:00:00	MSFT	Stock	27.21	27.45	27.19	27.44	5210320.0
2007-03-12 13:00:00	MSFT	Stock	27.45	27.45	27.32	27.37	3600803.0
2007-03-12 14:00:00	MSFT	Stock	27.37	27.45	27.35	27.42	3335792.0
2007-03-12 15:00:00	MSFT	Stock	27.42	27.48	27.35	27.46	8247754.0
2007-03-12 16:00:00	MSFT	Stock	27.44	27.47	27.195	27.448	204177.0
2007-03-12 17:00:00	MSFT	Stock	27.44	27.44	27.4	27.4	565000.0
2007-03-12 19:00:00	MSFT	Stock	27.4	27.44	27.4	27.44	1500.0
2007-03-12 08:00:00	NVDA	Stock	0.5067	0.5082	0.5067	0.5082	14400.0
2007-03-12 09:00:00	NVDA	Stock	0.5067	0.5095	0.5	0.5073	48392640.0
2007-03-12 10:00:00	NVDA	Stock	0.5072	0.5128	0.505	0.5057	69614340.0
2007-03-12 11:00:00	NVDA	Stock	0.5057	0.5065	0.5027	0.5052	52063800.0
2007-03-12 12:00:00	NVDA	Stock	0.5053	0.508	0.5032	0.5049	59031540.0
2007-03-12 13:00:00	NVDA	Stock	0.5049	0.505	0.5033	0.5037	31505940.0
2007-03-12 14:00:00	NVDA	Stock	0.5037	0.506	0.503	0.5047	68853780.0
2007-03-12 15:00:00	NVDA	Stock	0.5048	0.5057	0.502	0.5052	84934380.0
2007-03-12 16:00:00	NVDA	Stock	0.5055	0.5055	0.5038	0.505	2126280.0
2007-03-12 17:00:00	NVDA	Stock	0.5053	0.5057	0.5053	0.5057	165900.0
2007-03-12 18:00:00	NVDA	Stock	0.5052	0.506	0.5052	0.506	14400.0
2007-03-12 19:00:00	NVDA	Stock	0.506	0.5062	0.5055	0.5055	48000.0
2007-03-12 09:00:00	AMZN	Stock	1.9395	1.9525	1.93	1.9375	10396600.0
2007-03-12 10:00:00	AMZN	Stock	1.938	1.949	1.9295	1.941	12431000.0
2007-03-12 11:00:00	AMZN	Stock	1.941	1.941	1.919	1.926	19850480.0
2007-03-12 12:00:00	AMZN	Stock	1.926	1.932	1.92	1.924	11090740.0
2007-03-12 13:00:00	AMZN	Stock	1.924	1.9265	1.9225	1.9265	8390700.0
2007-03-12 14:00:00	AMZN	Stock	1.9265	1.941	1.9255	1.94	15634400.0
2007-03-12 15:00:00	AMZN	Stock	1.9396	1.944	1.933	1.9405	13918760.0
2007-03-12 16:00:00	AMZN	Stock	1.9405	1.943	1.9405	1.9415	2514700.0
2007-03-12 17:00:00	AMZN	Stock	1.949	1.95	1.9455	1.9455	132600.0
2007-03-12 09:00:00	CL	Stock	33.315	33.35	33.17	33.265	288800.0
2007-03-12 10:00:00	CL	Stock	33.28	33.325	33.205	33.24	447600.0
2007-03-12 11:00:00	CL	Stock	33.245	33.28	33.185	33.2	296000.0
2007-03-12 12:00:00	CL	Stock	33.205	33.305	33.185	33.25	231800.0

> showing 50 of 32,357 rows — these rows as CSV

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