PREVIEW / stock_1hour / 2008-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-28.parquet
  size:    811 KB
  rows:    39,491
  symbols: 3,296

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-07-28 07:00:00	AAPL	Stock	5.8036	5.8393	5.7982	5.8232	210280.0
2008-07-28 08:00:00	AAPL	Stock	5.8232	5.8304	5.8021	5.8171	2154796.0
2008-07-28 09:00:00	AAPL	Stock	5.8179	5.8179	5.7257	5.7411	72665656.0
2008-07-28 10:00:00	AAPL	Stock	5.7414	5.7496	5.6814	5.6939	114445968.0
2008-07-28 11:00:00	AAPL	Stock	5.6932	5.7014	5.6014	5.6239	127797544.0
2008-07-28 12:00:00	AAPL	Stock	5.6236	5.6246	5.5407	5.5511	95888464.0
2008-07-28 13:00:00	AAPL	Stock	5.5511	5.6157	5.5436	5.6093	96174148.0
2008-07-28 14:00:00	AAPL	Stock	5.6082	5.6129	5.5507	5.5579	92975792.0
2008-07-28 15:00:00	AAPL	Stock	5.5582	5.5668	5.5007	5.5286	144650044.0
2008-07-28 16:00:00	AAPL	Stock	5.5261	5.7901	5.5143	5.5211	17253432.0
2008-07-28 17:00:00	AAPL	Stock	5.5182	5.5211	5.5046	5.5089	645036.0
2008-07-28 18:00:00	AAPL	Stock	5.5089	5.5214	5.5071	5.5214	194684.0
2008-07-28 19:00:00	AAPL	Stock	5.515	5.5282	5.5143	5.5282	204400.0
2008-07-28 08:00:00	MSFT	Stock	26.1	26.15	26.1	26.14	1400.0
2008-07-28 09:00:00	MSFT	Stock	26.13	26.14	25.85	25.85	4786984.0
2008-07-28 10:00:00	MSFT	Stock	25.85	26.09	25.84	26.0	5692829.0
2008-07-28 11:00:00	MSFT	Stock	26.0	26.01	25.68	25.791	7228659.0
2008-07-28 12:00:00	MSFT	Stock	25.79	25.85	25.58	25.62	7193483.0
2008-07-28 13:00:00	MSFT	Stock	25.62	25.68	25.56	25.63	5829508.0
2008-07-28 14:00:00	MSFT	Stock	25.635	25.65	25.5	25.51	8279474.0
2008-07-28 15:00:00	MSFT	Stock	25.51	25.611	25.34	25.5	15188351.0
2008-07-28 16:00:00	MSFT	Stock	25.5	25.686	25.47	25.49	3793234.0
2008-07-28 17:00:00	MSFT	Stock	25.5	25.5	25.46	25.5	9652.0
2008-07-28 18:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	13700.0
2008-07-28 19:00:00	MSFT	Stock	25.5	25.5	25.48	25.48	3030.0
2008-07-28 20:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	2400.0
2008-07-28 07:00:00	NVDA	Stock	0.288	0.288	0.288	0.288	12000.0
2008-07-28 08:00:00	NVDA	Stock	0.2888	0.289	0.2875	0.2875	101480.0
2008-07-28 09:00:00	NVDA	Stock	0.286	0.2912	0.283	0.288	63567080.0
2008-07-28 10:00:00	NVDA	Stock	0.288	0.2958	0.2875	0.2958	102631400.0
2008-07-28 11:00:00	NVDA	Stock	0.2955	0.2978	0.2935	0.297	136568640.0
2008-07-28 12:00:00	NVDA	Stock	0.297	0.2978	0.2932	0.2938	84410160.0
2008-07-28 13:00:00	NVDA	Stock	0.2938	0.2962	0.2922	0.2925	91575240.0
2008-07-28 14:00:00	NVDA	Stock	0.2922	0.2935	0.2902	0.2905	81893600.0
2008-07-28 15:00:00	NVDA	Stock	0.2902	0.2912	0.2875	0.2885	156379440.0
2008-07-28 16:00:00	NVDA	Stock	0.2888	0.2921	0.2882	0.2882	7586600.0
2008-07-28 17:00:00	NVDA	Stock	0.2895	0.2895	0.2895	0.2895	20000.0
2008-07-28 18:00:00	NVDA	Stock	0.2922	0.2922	0.2888	0.2888	89000.0
2008-07-28 19:00:00	NVDA	Stock	0.2915	0.2915	0.2915	0.2915	4000.0
2008-07-28 20:00:00	NVDA	Stock	0.2882	0.2882	0.2882	0.2882	444000.0
2008-07-28 07:00:00	AMZN	Stock	3.8725	3.887	3.8725	3.887	40000.0
2008-07-28 08:00:00	AMZN	Stock	3.905	3.905	3.875	3.887	689200.0
2008-07-28 09:00:00	AMZN	Stock	3.885	3.885	3.8075	3.8075	38024040.0
2008-07-28 10:00:00	AMZN	Stock	3.8065	3.8695	3.7835	3.793	41481640.0
2008-07-28 11:00:00	AMZN	Stock	3.7935	3.797	3.743	3.7766	31469440.0
2008-07-28 12:00:00	AMZN	Stock	3.777	3.802	3.773	3.7875	19150660.0
2008-07-28 13:00:00	AMZN	Stock	3.786	3.823	3.78	3.8158	20770340.0
2008-07-28 14:00:00	AMZN	Stock	3.8158	3.823	3.79	3.794	21353140.0
2008-07-28 15:00:00	AMZN	Stock	3.795	3.825	3.7915	3.7995	30052200.0
2008-07-28 16:00:00	AMZN	Stock	3.8045	3.8097	3.775	3.7964	2495660.0

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

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