PREVIEW / stock_1hour / 2008-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-25.parquet
  size:    840 KB
  rows:    40,348
  symbols: 3,347

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-06-25 07:00:00	AAPL	Stock	6.2318	6.2396	6.2318	6.2396	43400.0
2008-06-25 08:00:00	AAPL	Stock	6.2396	6.2461	6.22	6.2354	2096920.0
2008-06-25 09:00:00	AAPL	Stock	6.2386	6.2839	6.21	6.2607	74501672.0
2008-06-25 10:00:00	AAPL	Stock	6.2604	6.3175	6.2336	6.2989	97421716.0
2008-06-25 11:00:00	AAPL	Stock	6.2989	6.315	6.2836	6.3018	51475844.0
2008-06-25 12:00:00	AAPL	Stock	6.3008	6.3157	6.295	6.3004	33445860.0
2008-06-25 13:00:00	AAPL	Stock	6.2993	6.3146	6.2893	6.3	30734424.0
2008-06-25 14:00:00	AAPL	Stock	6.3004	6.3554	6.2936	6.3429	148986432.0
2008-06-25 15:00:00	AAPL	Stock	6.3432	6.3868	6.3029	6.3354	155637356.0
2008-06-25 16:00:00	AAPL	Stock	6.3354	6.3354	6.1739	6.25	19550580.0
2008-06-25 17:00:00	AAPL	Stock	6.2536	6.2657	6.2407	6.2589	1309504.0
2008-06-25 18:00:00	AAPL	Stock	6.2589	6.3354	6.2529	6.2639	595112.0
2008-06-25 19:00:00	AAPL	Stock	6.2593	6.2632	6.2554	6.2554	131740.0
2008-06-25 07:00:00	MSFT	Stock	27.88	28.8	27.88	28.0	1700.0
2008-06-25 08:00:00	MSFT	Stock	27.9	28.0	27.81	27.87	28620.0
2008-06-25 09:00:00	MSFT	Stock	27.88	28.33	27.76	28.17	5222507.0
2008-06-25 10:00:00	MSFT	Stock	28.17	28.41	28.07	28.29	8332813.0
2008-06-25 11:00:00	MSFT	Stock	28.29	28.42	28.24	28.372	6635811.0
2008-06-25 12:00:00	MSFT	Stock	28.37	28.45	28.35	28.379	5270350.0
2008-06-25 13:00:00	MSFT	Stock	28.378	28.4	28.18	28.24	5698711.0
2008-06-25 14:00:00	MSFT	Stock	28.24	28.56	28.22	28.51	13062200.0
2008-06-25 15:00:00	MSFT	Stock	28.51	28.67	28.32	28.35	15105842.0
2008-06-25 16:00:00	MSFT	Stock	28.35	28.48	28.271	28.36	3295218.0
2008-06-25 17:00:00	MSFT	Stock	28.36	28.36	28.14	28.15	45535.0
2008-06-25 18:00:00	MSFT	Stock	28.15	28.35	28.15	28.18	23513.0
2008-06-25 19:00:00	MSFT	Stock	28.21	28.23	28.18	28.2	3506.0
2008-06-25 07:00:00	NVDA	Stock	0.5125	0.5125	0.5125	0.5125	12000.0
2008-06-25 08:00:00	NVDA	Stock	0.509	0.5145	0.505	0.5138	1314680.0
2008-06-25 09:00:00	NVDA	Stock	0.5138	0.5148	0.499	0.5	117965280.0
2008-06-25 10:00:00	NVDA	Stock	0.5	0.5035	0.498	0.4998	194398240.0
2008-06-25 11:00:00	NVDA	Stock	0.4998	0.501	0.4945	0.4995	122350000.0
2008-06-25 12:00:00	NVDA	Stock	0.4994	0.502	0.4975	0.501	69711840.0
2008-06-25 13:00:00	NVDA	Stock	0.5008	0.504	0.5	0.501	62012520.0
2008-06-25 14:00:00	NVDA	Stock	0.5013	0.505	0.4992	0.5045	113820880.0
2008-06-25 15:00:00	NVDA	Stock	0.5045	0.5078	0.498	0.5025	181289680.0
2008-06-25 16:00:00	NVDA	Stock	0.5025	0.5045	0.5	0.5	20621720.0
2008-06-25 17:00:00	NVDA	Stock	0.5	0.5	0.4975	0.4975	43640.0
2008-06-25 18:00:00	NVDA	Stock	0.495	0.5005	0.4938	0.5005	234680.0
2008-06-25 19:00:00	NVDA	Stock	0.499	0.499	0.499	0.499	20000.0
2008-06-25 09:00:00	AMZN	Stock	3.982	4.03	3.976	4.0234	20174340.0
2008-06-25 10:00:00	AMZN	Stock	4.0275	4.1075	4.015	4.0915	22793720.0
2008-06-25 11:00:00	AMZN	Stock	4.0925	4.098	4.0608	4.074	9089340.0
2008-06-25 12:00:00	AMZN	Stock	4.0735	4.075	4.063	4.0655	27792560.0
2008-06-25 13:00:00	AMZN	Stock	4.0655	4.0675	4.037	4.04	6379560.0
2008-06-25 14:00:00	AMZN	Stock	4.0395	4.078	4.027	4.033	25530800.0
2008-06-25 15:00:00	AMZN	Stock	4.033	4.074	3.9925	4.0255	27067220.0
2008-06-25 16:00:00	AMZN	Stock	4.0265	4.0496	3.981	4.015	2169220.0
2008-06-25 17:00:00	AMZN	Stock	3.982	4.015	3.982	4.0125	2144040.0
2008-06-25 18:00:00	AMZN	Stock	4.0005	4.0005	4.0	4.0	20020.0
2008-06-25 19:00:00	AMZN	Stock	4.0	4.0	4.0	4.0	4000.0

> showing 50 of 40,348 rows — these rows as CSV

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