PREVIEW / stock_1hour / 2008-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-08.parquet
  size:    840 KB
  rows:    40,527
  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-07-08 04:00:00	AAPL	Stock	6.2393	6.2393	6.2179	6.2179	14000.0
2008-07-08 07:00:00	AAPL	Stock	6.2268	6.2393	6.2161	6.2161	175028.0
2008-07-08 08:00:00	AAPL	Stock	6.2196	6.2804	6.2179	6.26	3537212.0
2008-07-08 09:00:00	AAPL	Stock	6.2618	6.3304	6.2264	6.2868	113087044.0
2008-07-08 10:00:00	AAPL	Stock	6.2854	6.3036	6.2018	6.2096	165117848.0
2008-07-08 11:00:00	AAPL	Stock	6.21	6.2775	6.1693	6.2411	117990544.0
2008-07-08 12:00:00	AAPL	Stock	6.2411	6.3161	6.2214	6.3089	88772628.0
2008-07-08 13:00:00	AAPL	Stock	6.3089	6.3214	6.2571	6.2796	82531204.0
2008-07-08 14:00:00	AAPL	Stock	6.2808	6.3907	6.2761	6.3857	140081480.0
2008-07-08 15:00:00	AAPL	Stock	6.3854	6.4179	6.36	6.4175	150010896.0
2008-07-08 16:00:00	AAPL	Stock	6.4175	6.4175	6.2996	6.4175	16269260.0
2008-07-08 17:00:00	AAPL	Stock	6.4114	6.4218	6.4071	6.4143	547764.0
2008-07-08 18:00:00	AAPL	Stock	6.4143	6.4161	6.4111	6.4157	212520.0
2008-07-08 19:00:00	AAPL	Stock	6.4161	6.4218	6.4157	6.42	128716.0
2008-07-08 07:00:00	MSFT	Stock	26.03	26.03	25.9	25.9	3600.0
2008-07-08 08:00:00	MSFT	Stock	25.9	26.15	25.9	26.03	11010.0
2008-07-08 09:00:00	MSFT	Stock	26.05	26.14	25.73	25.96	6890309.0
2008-07-08 10:00:00	MSFT	Stock	25.95	26.2	25.822	25.951	8351795.0
2008-07-08 11:00:00	MSFT	Stock	25.96	26.04	25.82	25.9	7204452.0
2008-07-08 12:00:00	MSFT	Stock	25.91	26.06	25.875	25.97	4566333.0
2008-07-08 13:00:00	MSFT	Stock	25.972	26.05	25.54	25.54	8222862.0
2008-07-08 14:00:00	MSFT	Stock	25.54	25.7	25.51	25.68	11309710.0
2008-07-08 15:00:00	MSFT	Stock	25.68	25.89	25.63	25.84	14709456.0
2008-07-08 16:00:00	MSFT	Stock	25.83	25.915	25.7	25.85	3346413.0
2008-07-08 17:00:00	MSFT	Stock	25.73	25.8	25.73	25.79	19778.0
2008-07-08 18:00:00	MSFT	Stock	25.75	25.82	25.75	25.82	12379.0
2008-07-08 19:00:00	MSFT	Stock	25.83	25.83	25.75	25.8	4583.0
2008-07-08 08:00:00	NVDA	Stock	0.3012	0.304	0.3	0.3025	334800.0
2008-07-08 09:00:00	NVDA	Stock	0.3025	0.312	0.3012	0.3083	117915280.0
2008-07-08 10:00:00	NVDA	Stock	0.3083	0.309	0.295	0.2985	251143360.0
2008-07-08 11:00:00	NVDA	Stock	0.2988	0.3005	0.297	0.2975	136476480.0
2008-07-08 12:00:00	NVDA	Stock	0.2974	0.2982	0.296	0.297	204792920.0
2008-07-08 13:00:00	NVDA	Stock	0.2968	0.3008	0.2968	0.2998	196537480.0
2008-07-08 14:00:00	NVDA	Stock	0.3	0.3038	0.2994	0.3038	258752680.0
2008-07-08 15:00:00	NVDA	Stock	0.3035	0.3038	0.3	0.3008	531403080.0
2008-07-08 16:00:00	NVDA	Stock	0.3005	0.3018	0.299	0.3008	83219160.0
2008-07-08 17:00:00	NVDA	Stock	0.2995	0.3012	0.2995	0.3012	146080.0
2008-07-08 18:00:00	NVDA	Stock	0.3012	0.302	0.3012	0.302	336680.0
2008-07-08 19:00:00	NVDA	Stock	0.302	0.302	0.3012	0.3012	208000.0
2008-07-08 08:00:00	AMZN	Stock	3.605	3.605	3.605	3.605	3000.0
2008-07-08 09:00:00	AMZN	Stock	3.615	3.699	3.596	3.6455	14900240.0
2008-07-08 10:00:00	AMZN	Stock	3.6455	3.659	3.5875	3.633	26562740.0
2008-07-08 11:00:00	AMZN	Stock	3.632	3.6845	3.608	3.6648	18613540.0
2008-07-08 12:00:00	AMZN	Stock	3.663	3.7005	3.6615	3.671	13944320.0
2008-07-08 13:00:00	AMZN	Stock	3.671	3.697	3.6345	3.649	17134660.0
2008-07-08 14:00:00	AMZN	Stock	3.649	3.73	3.644	3.7285	21419420.0
2008-07-08 15:00:00	AMZN	Stock	3.7265	3.7745	3.718	3.752	35512620.0
2008-07-08 16:00:00	AMZN	Stock	3.752	3.752	3.6245	3.752	3358620.0
2008-07-08 17:00:00	AMZN	Stock	3.742	3.7505	3.742	3.7505	43940.0
2008-07-08 18:00:00	AMZN	Stock	3.751	3.751	3.751	3.751	6000.0

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

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