PREVIEW / stock_1hour / 2006-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-13.parquet
  size:    592 KB
  rows:    28,005
  symbols: 2,196

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
2006-03-13 07:00:00	AAPL	Stock	2.2689	2.3354	2.2689	2.3214	1199996.0
2006-03-13 08:00:00	AAPL	Stock	2.3214	2.3279	2.3107	2.3243	15875748.0
2006-03-13 09:00:00	AAPL	Stock	2.3236	2.3607	2.3139	2.3568	241045700.0
2006-03-13 10:00:00	AAPL	Stock	2.3568	2.3657	2.3439	2.3604	176257340.0
2006-03-13 11:00:00	AAPL	Stock	2.3604	2.3671	2.3368	2.3425	111464192.0
2006-03-13 12:00:00	AAPL	Stock	2.3429	2.3482	2.3286	2.3471	68096924.0
2006-03-13 13:00:00	AAPL	Stock	2.3475	2.3525	2.3343	2.3411	50297184.0
2006-03-13 14:00:00	AAPL	Stock	2.3414	2.3564	2.3404	2.3464	64797012.0
2006-03-13 15:00:00	AAPL	Stock	2.3468	2.3596	2.3411	2.3443	117210968.0
2006-03-13 16:00:00	AAPL	Stock	2.3457	2.3457	2.34	2.3446	2153732.0
2006-03-13 17:00:00	AAPL	Stock	2.3446	2.3454	2.3429	2.3439	439600.0
2006-03-13 18:00:00	AAPL	Stock	2.3443	2.3457	2.3429	2.345	217420.0
2006-03-13 07:00:00	MSFT	Stock	27.23	27.29	27.23	27.29	2200.0
2006-03-13 08:00:00	MSFT	Stock	27.29	27.35	27.25	27.3	43955.0
2006-03-13 09:00:00	MSFT	Stock	27.27	27.29	27.11	27.18	4135276.0
2006-03-13 10:00:00	MSFT	Stock	27.18	27.22	26.96	27.04	5910898.0
2006-03-13 11:00:00	MSFT	Stock	27.04	27.04	26.94	27.0	4532062.0
2006-03-13 12:00:00	MSFT	Stock	27.0	27.01	26.97	27.0	3066640.0
2006-03-13 13:00:00	MSFT	Stock	26.99	27.05	26.94	27.0	5774012.0
2006-03-13 14:00:00	MSFT	Stock	27.01	27.08	26.99	27.01	7190141.0
2006-03-13 15:00:00	MSFT	Stock	27.01	27.11	27.0	27.11	8021373.0
2006-03-13 16:00:00	MSFT	Stock	27.11	27.11	27.06	27.11	441806.0
2006-03-13 17:00:00	MSFT	Stock	27.11	27.11	27.11	27.11	1684.0
2006-03-13 18:00:00	MSFT	Stock	27.09	27.1	27.09	27.1	475.0
2006-03-13 08:00:00	NVDA	Stock	0.3958	0.3958	0.3958	0.3958	691440.0
2006-03-13 09:00:00	NVDA	Stock	0.3989	0.4016	0.3962	0.3977	49254000.0
2006-03-13 10:00:00	NVDA	Stock	0.3976	0.3997	0.3965	0.3991	55179120.0
2006-03-13 11:00:00	NVDA	Stock	0.3992	0.4	0.3971	0.3987	53964840.0
2006-03-13 12:00:00	NVDA	Stock	0.3987	0.4012	0.3976	0.4011	38290560.0
2006-03-13 13:00:00	NVDA	Stock	0.401	0.4011	0.3959	0.3978	37652160.0
2006-03-13 14:00:00	NVDA	Stock	0.3977	0.3988	0.3963	0.3979	49013040.0
2006-03-13 15:00:00	NVDA	Stock	0.3979	0.4001	0.3975	0.3996	73173120.0
2006-03-13 16:00:00	NVDA	Stock	0.3992	0.3999	0.3992	0.3997	1125960.0
2006-03-13 17:00:00	NVDA	Stock	0.3997	0.3997	0.3997	0.3997	24000.0
2006-03-13 18:00:00	NVDA	Stock	0.3998	0.4	0.3997	0.3997	252000.0
2006-03-13 08:00:00	AMZN	Stock	1.813	1.813	1.813	1.813	10000.0
2006-03-13 09:00:00	AMZN	Stock	1.8125	1.8315	1.8125	1.8235	6769940.0
2006-03-13 10:00:00	AMZN	Stock	1.8245	1.8315	1.808	1.811	8858040.0
2006-03-13 11:00:00	AMZN	Stock	1.811	1.824	1.806	1.816	8930700.0
2006-03-13 12:00:00	AMZN	Stock	1.816	1.8165	1.8125	1.8145	4483720.0
2006-03-13 13:00:00	AMZN	Stock	1.814	1.815	1.7985	1.8025	6414160.0
2006-03-13 14:00:00	AMZN	Stock	1.8025	1.81	1.7985	1.802	9182240.0
2006-03-13 15:00:00	AMZN	Stock	1.8015	1.815	1.8	1.809	19461360.0
2006-03-13 16:00:00	AMZN	Stock	1.812	1.8135	1.808	1.8095	203080.0
2006-03-13 08:00:00	CL	Stock	28.87	28.87	28.87	28.87	600.0
2006-03-13 09:00:00	CL	Stock	29.0	29.08	28.91	28.995	437200.0
2006-03-13 10:00:00	CL	Stock	28.99	29.145	28.97	29.02	714800.0
2006-03-13 11:00:00	CL	Stock	29.02	29.055	28.945	28.97	588800.0
2006-03-13 12:00:00	CL	Stock	28.98	29.12	28.95	29.04	362000.0
2006-03-13 13:00:00	CL	Stock	29.0445	29.045	28.84	28.855	478800.0

> showing 50 of 28,005 rows — these rows as CSV

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