PREVIEW / stock_1hour / 2009-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-03.parquet
  size:    805 KB
  rows:    39,151
  symbols: 3,272

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
2009-02-03 07:00:00	AAPL	Stock	3.2679	3.2779	3.2675	3.2779	61600.0
2009-02-03 08:00:00	AAPL	Stock	3.2675	3.2829	3.2643	3.2814	440776.0
2009-02-03 09:00:00	AAPL	Stock	3.2829	3.2957	3.2243	3.2418	84080696.0
2009-02-03 10:00:00	AAPL	Stock	3.2418	3.3036	3.2396	3.2943	111107948.0
2009-02-03 11:00:00	AAPL	Stock	3.295	3.3104	3.2879	3.2925	59290336.0
2009-02-03 12:00:00	AAPL	Stock	3.2925	3.2979	3.2746	3.285	50226932.0
2009-02-03 13:00:00	AAPL	Stock	3.2846	3.2946	3.2707	3.2854	56068460.0
2009-02-03 14:00:00	AAPL	Stock	3.2857	3.3214	3.2829	3.3111	76142388.0
2009-02-03 15:00:00	AAPL	Stock	3.3107	3.335	3.3046	3.32	121171232.0
2009-02-03 16:00:00	AAPL	Stock	3.3193	3.3214	3.2755	3.3129	21416976.0
2009-02-03 17:00:00	AAPL	Stock	3.3125	3.3161	3.3125	3.3143	402500.0
2009-02-03 18:00:00	AAPL	Stock	3.3207	3.3207	3.3075	3.31	16233784.0
2009-02-03 19:00:00	AAPL	Stock	3.3125	3.3125	3.3082	3.3104	106288.0
2009-02-03 05:00:00	MSFT	Stock	17.67	17.67	17.67	17.67	100.0
2009-02-03 07:00:00	MSFT	Stock	17.8	17.85	17.8	17.85	3774.0
2009-02-03 08:00:00	MSFT	Stock	17.9	17.96	17.9	17.95	15921.0
2009-02-03 09:00:00	MSFT	Stock	17.96	17.96	17.6	17.72	5610665.0
2009-02-03 10:00:00	MSFT	Stock	17.72	18.09	17.7	18.05	9239194.0
2009-02-03 11:00:00	MSFT	Stock	18.05	18.28	18.04	18.172	10405211.0
2009-02-03 12:00:00	MSFT	Stock	18.17	18.19	18.01	18.01	9263081.0
2009-02-03 13:00:00	MSFT	Stock	18.02	18.12	17.95	18.082	5566389.0
2009-02-03 14:00:00	MSFT	Stock	18.09	18.38	18.09	18.24	12097720.0
2009-02-03 15:00:00	MSFT	Stock	18.23	18.61	18.23	18.5	25335021.0
2009-02-03 16:00:00	MSFT	Stock	18.51	18.52	18.035	18.47	7450414.0
2009-02-03 17:00:00	MSFT	Stock	18.42	18.44	18.42	18.44	3956.0
2009-02-03 18:00:00	MSFT	Stock	18.43	18.5	18.42	18.42	495313.0
2009-02-03 19:00:00	MSFT	Stock	18.42	18.45	18.42	18.42	9765.0
2009-02-03 08:00:00	NVDA	Stock	0.2095	0.2095	0.2095	0.2095	166000.0
2009-02-03 09:00:00	NVDA	Stock	0.21	0.211	0.2043	0.2075	47107080.0
2009-02-03 10:00:00	NVDA	Stock	0.2075	0.2088	0.2043	0.2068	55946160.0
2009-02-03 11:00:00	NVDA	Stock	0.2068	0.213	0.2065	0.2098	55565560.0
2009-02-03 12:00:00	NVDA	Stock	0.21	0.2105	0.2082	0.2085	20554640.0
2009-02-03 13:00:00	NVDA	Stock	0.2082	0.2088	0.2072	0.2082	20108400.0
2009-02-03 14:00:00	NVDA	Stock	0.2082	0.2125	0.2082	0.21	49258720.0
2009-02-03 15:00:00	NVDA	Stock	0.2099	0.2138	0.2092	0.212	95675760.0
2009-02-03 16:00:00	NVDA	Stock	0.2122	0.2125	0.2095	0.212	20169560.0
2009-02-03 17:00:00	NVDA	Stock	0.2102	0.2102	0.2102	0.2102	40000.0
2009-02-03 07:00:00	AMZN	Stock	3.05	3.055	3.05	3.051	14000.0
2009-02-03 08:00:00	AMZN	Stock	3.051	3.06	3.05	3.06	37100.0
2009-02-03 09:00:00	AMZN	Stock	3.067	3.0775	3.0	3.029	34296540.0
2009-02-03 10:00:00	AMZN	Stock	3.0295	3.0975	3.029	3.076	56535260.0
2009-02-03 11:00:00	AMZN	Stock	3.076	3.1385	3.075	3.123	32892000.0
2009-02-03 12:00:00	AMZN	Stock	3.124	3.1425	3.0915	3.1195	25070160.0
2009-02-03 13:00:00	AMZN	Stock	3.12	3.1335	3.09	3.106	21579440.0
2009-02-03 14:00:00	AMZN	Stock	3.106	3.176	3.1045	3.1575	37322060.0
2009-02-03 15:00:00	AMZN	Stock	3.1585	3.21	3.1475	3.178	71054740.0
2009-02-03 16:00:00	AMZN	Stock	3.1775	3.1882	3.0575	3.175	14248260.0
2009-02-03 17:00:00	AMZN	Stock	3.1735	3.1805	3.1735	3.18	102800.0
2009-02-03 18:00:00	AMZN	Stock	3.18	3.18	3.18	3.18	21500.0
2009-02-03 19:00:00	AMZN	Stock	3.1755	3.185	3.1755	3.185	26900.0

> showing 50 of 39,151 rows — these rows as CSV

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