PREVIEW / stock_1hour / 2008-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-26.parquet
  size:    806 KB
  rows:    39,780
  symbols: 3,256

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-02-26 04:00:00	AAPL	Stock	4.2843	4.2946	4.2843	4.2946	49140.0
2008-02-26 05:00:00	AAPL	Stock	4.29	4.2911	4.2854	4.2911	92512.0
2008-02-26 06:00:00	AAPL	Stock	4.2886	4.2957	4.2821	4.2857	56000.0
2008-02-26 07:00:00	AAPL	Stock	4.2864	4.3	4.28	4.2807	514976.0
2008-02-26 08:00:00	AAPL	Stock	4.2764	4.2807	4.2236	4.2436	4249952.0
2008-02-26 09:00:00	AAPL	Stock	4.245	4.2482	4.1696	4.1739	161685972.0
2008-02-26 10:00:00	AAPL	Stock	4.1743	4.2064	4.1229	4.1907	312749808.0
2008-02-26 11:00:00	AAPL	Stock	4.1911	4.2714	4.1704	4.2589	200635036.0
2008-02-26 12:00:00	AAPL	Stock	4.2589	4.3246	4.25	4.2871	235070892.0
2008-02-26 13:00:00	AAPL	Stock	4.2864	4.3082	4.2625	4.2736	161045836.0
2008-02-26 14:00:00	AAPL	Stock	4.2736	4.3157	4.2629	4.3125	150523912.0
2008-02-26 15:00:00	AAPL	Stock	4.3121	4.3136	4.2179	4.2554	241314108.0
2008-02-26 16:00:00	AAPL	Stock	4.255	4.2861	4.2367	4.255	32333280.0
2008-02-26 17:00:00	AAPL	Stock	4.2525	4.2554	4.2386	4.2504	9087596.0
2008-02-26 18:00:00	AAPL	Stock	4.2464	4.2479	4.2379	4.2429	286020.0
2008-02-26 19:00:00	AAPL	Stock	4.2429	4.2429	4.2375	4.2393	364980.0
2008-02-26 04:00:00	MSFT	Stock	27.95	27.95	27.95	27.95	100.0
2008-02-26 06:00:00	MSFT	Stock	27.95	28.05	27.95	28.05	2500.0
2008-02-26 07:00:00	MSFT	Stock	27.9	27.95	27.82	27.95	6100.0
2008-02-26 08:00:00	MSFT	Stock	27.95	27.95	27.75	27.8	38462.0
2008-02-26 09:00:00	MSFT	Stock	27.84	27.94	27.65	27.84	7680618.0
2008-02-26 10:00:00	MSFT	Stock	27.85	28.2	27.8	28.18	17124419.0
2008-02-26 11:00:00	MSFT	Stock	28.18	28.37	28.12	28.35	11670851.0
2008-02-26 12:00:00	MSFT	Stock	28.35	28.51	28.29	28.5	10246084.0
2008-02-26 13:00:00	MSFT	Stock	28.49	28.69	28.42	28.66	13148713.0
2008-02-26 14:00:00	MSFT	Stock	28.66	28.86	28.59	28.81	16549034.0
2008-02-26 15:00:00	MSFT	Stock	28.81	28.82	28.37	28.4	19938600.0
2008-02-26 16:00:00	MSFT	Stock	28.4	28.498	28.2	28.2	11797733.0
2008-02-26 17:00:00	MSFT	Stock	28.25	28.38	28.23	28.38	704171.0
2008-02-26 18:00:00	MSFT	Stock	28.38	28.38	28.28	28.37	15190.0
2008-02-26 19:00:00	MSFT	Stock	28.34	28.36	28.33	28.36	2870.0
2008-02-26 08:00:00	NVDA	Stock	0.5562	0.5562	0.55	0.5502	342000.0
2008-02-26 09:00:00	NVDA	Stock	0.5502	0.563	0.55	0.5582	47492360.0
2008-02-26 10:00:00	NVDA	Stock	0.5582	0.5605	0.546	0.5568	122299840.0
2008-02-26 11:00:00	NVDA	Stock	0.5568	0.5648	0.553	0.5642	73450240.0
2008-02-26 12:00:00	NVDA	Stock	0.5642	0.5698	0.5622	0.566	75363680.0
2008-02-26 13:00:00	NVDA	Stock	0.5662	0.57	0.5618	0.563	47294520.0
2008-02-26 14:00:00	NVDA	Stock	0.5632	0.5698	0.5622	0.5695	55268840.0
2008-02-26 15:00:00	NVDA	Stock	0.5695	0.571	0.5595	0.5625	123212160.0
2008-02-26 16:00:00	NVDA	Stock	0.5625	0.566	0.561	0.5625	14790080.0
2008-02-26 17:00:00	NVDA	Stock	0.5625	0.5628	0.56	0.5628	324160.0
2008-02-26 19:00:00	NVDA	Stock	0.5625	0.5625	0.5625	0.5625	4000.0
2008-02-26 08:00:00	AMZN	Stock	3.664	3.664	3.6185	3.6185	73000.0
2008-02-26 09:00:00	AMZN	Stock	3.6235	3.663	3.563	3.564	20812900.0
2008-02-26 10:00:00	AMZN	Stock	3.564	3.5815	3.514	3.5535	45140860.0
2008-02-26 11:00:00	AMZN	Stock	3.555	3.6245	3.548	3.6135	26925200.0
2008-02-26 12:00:00	AMZN	Stock	3.6145	3.675	3.605	3.617	22500340.0
2008-02-26 13:00:00	AMZN	Stock	3.6175	3.636	3.5975	3.603	11629180.0
2008-02-26 14:00:00	AMZN	Stock	3.6045	3.624	3.5805	3.6075	20287120.0
2008-02-26 15:00:00	AMZN	Stock	3.607	3.608	3.544	3.586	37866520.0

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

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