PREVIEW / stock_1hour / 2006-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-15.parquet
  size:    605 KB
  rows:    28,527
  symbols: 2,192

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-15 07:00:00	AAPL	Stock	2.4161	2.4161	2.4071	2.4125	11200.0
2006-03-15 08:00:00	AAPL	Stock	2.4107	2.425	2.4107	2.42	2011548.0
2006-03-15 09:00:00	AAPL	Stock	2.4196	2.43	2.3979	2.4117	121666692.0
2006-03-15 10:00:00	AAPL	Stock	2.4121	2.4154	2.3714	2.3718	152610080.0
2006-03-15 11:00:00	AAPL	Stock	2.3714	2.3882	2.3714	2.3767	79026808.0
2006-03-15 12:00:00	AAPL	Stock	2.3764	2.38	2.3418	2.36	165113088.0
2006-03-15 13:00:00	AAPL	Stock	2.3604	2.3661	2.34	2.3561	109522588.0
2006-03-15 14:00:00	AAPL	Stock	2.3561	2.3639	2.3411	2.3457	118486788.0
2006-03-15 15:00:00	AAPL	Stock	2.3457	2.3671	2.3436	2.3664	125820912.0
2006-03-15 16:00:00	AAPL	Stock	2.3661	2.3704	2.355	2.3625	7767844.0
2006-03-15 17:00:00	AAPL	Stock	2.3625	2.3693	2.3625	2.3643	476616.0
2006-03-15 18:00:00	AAPL	Stock	2.3643	2.3654	2.3632	2.3636	248808.0
2006-03-15 04:00:00	MSFT	Stock	27.27	27.27	27.27	27.27	1000.0
2006-03-15 07:00:00	MSFT	Stock	27.28	27.29	27.28	27.29	5700.0
2006-03-15 08:00:00	MSFT	Stock	27.31	27.32	27.26	27.27	111635.0
2006-03-15 09:00:00	MSFT	Stock	27.27	27.29	27.05	27.16	8278721.0
2006-03-15 10:00:00	MSFT	Stock	27.16	27.19	27.03	27.05	8568636.0
2006-03-15 11:00:00	MSFT	Stock	27.04	27.16	27.01	27.03	6271185.0
2006-03-15 12:00:00	MSFT	Stock	27.03	27.17	27.02	27.15	4865245.0
2006-03-15 13:00:00	MSFT	Stock	27.16	27.16	27.07	27.14	3821985.0
2006-03-15 14:00:00	MSFT	Stock	27.13	27.45	27.13	27.34	11983877.0
2006-03-15 15:00:00	MSFT	Stock	27.34	27.44	27.27	27.35	9764925.0
2006-03-15 16:00:00	MSFT	Stock	27.36	27.39	27.33	27.33	102487.0
2006-03-15 17:00:00	MSFT	Stock	27.33	27.34	27.33	27.33	7000.0
2006-03-15 18:00:00	MSFT	Stock	27.34	27.34	27.33	27.34	7359.0
2006-03-15 08:00:00	NVDA	Stock	0.4104	0.4106	0.4083	0.409	1068000.0
2006-03-15 09:00:00	NVDA	Stock	0.4098	0.4146	0.4092	0.4135	56091840.0
2006-03-15 10:00:00	NVDA	Stock	0.4136	0.4146	0.4105	0.4111	85743120.0
2006-03-15 11:00:00	NVDA	Stock	0.411	0.4132	0.41	0.4118	55627440.0
2006-03-15 12:00:00	NVDA	Stock	0.4119	0.4132	0.4106	0.4132	62068440.0
2006-03-15 13:00:00	NVDA	Stock	0.4131	0.4137	0.4121	0.4133	35015280.0
2006-03-15 14:00:00	NVDA	Stock	0.4134	0.4156	0.4132	0.4152	46559520.0
2006-03-15 15:00:00	NVDA	Stock	0.4152	0.4179	0.4149	0.4171	132046800.0
2006-03-15 16:00:00	NVDA	Stock	0.4172	0.4178	0.4158	0.4162	6544800.0
2006-03-15 17:00:00	NVDA	Stock	0.4159	0.4162	0.4158	0.4162	300000.0
2006-03-15 18:00:00	NVDA	Stock	0.4173	0.4173	0.4173	0.4173	1330080.0
2006-03-15 09:00:00	AMZN	Stock	1.8445	1.85	1.8265	1.831	8001100.0
2006-03-15 10:00:00	AMZN	Stock	1.831	1.845	1.8215	1.836	10891960.0
2006-03-15 11:00:00	AMZN	Stock	1.835	1.8415	1.831	1.8355	8973620.0
2006-03-15 12:00:00	AMZN	Stock	1.8355	1.8395	1.833	1.8335	2762640.0
2006-03-15 13:00:00	AMZN	Stock	1.8331	1.838	1.832	1.8345	2510800.0
2006-03-15 14:00:00	AMZN	Stock	1.8335	1.844	1.8305	1.8305	7277180.0
2006-03-15 15:00:00	AMZN	Stock	1.831	1.8475	1.8285	1.845	13189320.0
2006-03-15 16:00:00	AMZN	Stock	1.8445	1.8465	1.839	1.839	58520.0
2006-03-15 17:00:00	AMZN	Stock	1.844	1.844	1.844	1.844	8000.0
2006-03-15 18:00:00	AMZN	Stock	1.8445	1.8445	1.8445	1.8445	6000.0
2006-03-15 09:00:00	CL	Stock	28.325	28.495	28.305	28.49	507600.0
2006-03-15 10:00:00	CL	Stock	28.49	28.585	28.44	28.47	637600.0
2006-03-15 11:00:00	CL	Stock	28.465	28.495	28.38	28.43	577000.0
2006-03-15 12:00:00	CL	Stock	28.425	28.445	28.38	28.415	304200.0

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

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