PREVIEW / stock_1hour / 2005-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-21.parquet
  size:    547 KB
  rows:    26,078
  symbols: 1,997

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
2005-06-21 07:00:00	AAPL	Stock	1.3432	1.3432	1.3382	1.3382	44800.0
2005-06-21 08:00:00	AAPL	Stock	1.3304	1.3454	1.3304	1.3429	265412.0
2005-06-21 09:00:00	AAPL	Stock	1.3429	1.3536	1.3361	1.3382	72279704.0
2005-06-21 10:00:00	AAPL	Stock	1.3379	1.3536	1.335	1.3514	74675412.0
2005-06-21 11:00:00	AAPL	Stock	1.3514	1.3521	1.3457	1.3496	31566584.0
2005-06-21 12:00:00	AAPL	Stock	1.35	1.3532	1.3493	1.3507	17136560.0
2005-06-21 13:00:00	AAPL	Stock	1.3507	1.3575	1.3489	1.3557	28661164.0
2005-06-21 14:00:00	AAPL	Stock	1.3557	1.3639	1.3536	1.3611	51668484.0
2005-06-21 15:00:00	AAPL	Stock	1.3611	1.3621	1.3446	1.3521	83583836.0
2005-06-21 16:00:00	AAPL	Stock	1.352	1.3529	1.3497	1.3529	2586836.0
2005-06-21 17:00:00	AAPL	Stock	1.3521	1.3554	1.3504	1.3536	249200.0
2005-06-21 18:00:00	AAPL	Stock	1.3504	1.3514	1.3489	1.3514	123200.0
2005-06-21 08:00:00	MSFT	Stock	25.11	25.12	25.1	25.1	3619.0
2005-06-21 09:00:00	MSFT	Stock	25.1	25.15	25.05	25.07	5194349.0
2005-06-21 10:00:00	MSFT	Stock	25.07	25.14	25.04	25.07	9889483.0
2005-06-21 11:00:00	MSFT	Stock	25.06	25.1	25.05	25.09	8420080.0
2005-06-21 12:00:00	MSFT	Stock	25.081	25.19	25.05	25.15	18151917.0
2005-06-21 13:00:00	MSFT	Stock	25.14	25.19	25.08	25.12	6455229.0
2005-06-21 14:00:00	MSFT	Stock	25.125	25.15	25.1	25.14	7787388.0
2005-06-21 15:00:00	MSFT	Stock	25.15	25.17	25.07	25.1	15768358.0
2005-06-21 16:00:00	MSFT	Stock	25.15	25.15	25.04	25.11	515431.0
2005-06-21 17:00:00	MSFT	Stock	25.09	25.15	25.09	25.11	7361.0
2005-06-21 18:00:00	MSFT	Stock	25.11	25.11	25.1	25.11	13400.0
2005-06-21 08:00:00	NVDA	Stock	0.228	0.228	0.228	0.228	24000.0
2005-06-21 09:00:00	NVDA	Stock	0.2302	0.2304	0.227	0.228	77213040.0
2005-06-21 10:00:00	NVDA	Stock	0.2279	0.2298	0.2276	0.2285	56786760.0
2005-06-21 11:00:00	NVDA	Stock	0.2285	0.2287	0.2272	0.2275	37112880.0
2005-06-21 12:00:00	NVDA	Stock	0.2273	0.228	0.2272	0.2279	22779000.0
2005-06-21 13:00:00	NVDA	Stock	0.2279	0.2286	0.2271	0.2286	50161560.0
2005-06-21 14:00:00	NVDA	Stock	0.2286	0.2301	0.2283	0.2297	54240000.0
2005-06-21 15:00:00	NVDA	Stock	0.2296	0.2309	0.229	0.2298	119965920.0
2005-06-21 16:00:00	NVDA	Stock	0.23	0.2303	0.2297	0.2297	1598160.0
2005-06-21 17:00:00	NVDA	Stock	0.2298	0.2301	0.2298	0.2301	709440.0
2005-06-21 08:00:00	AMZN	Stock	1.785	1.785	1.785	1.785	2000.0
2005-06-21 09:00:00	AMZN	Stock	1.781	1.785	1.772	1.7845	12663240.0
2005-06-21 10:00:00	AMZN	Stock	1.7845	1.7845	1.773	1.779	11384860.0
2005-06-21 11:00:00	AMZN	Stock	1.7785	1.779	1.765	1.769	9479400.0
2005-06-21 12:00:00	AMZN	Stock	1.769	1.7775	1.7685	1.777	8867640.0
2005-06-21 13:00:00	AMZN	Stock	1.7765	1.7905	1.7765	1.7835	10432060.0
2005-06-21 14:00:00	AMZN	Stock	1.7835	1.7895	1.7785	1.784	11747520.0
2005-06-21 15:00:00	AMZN	Stock	1.784	1.7845	1.764	1.769	23271740.0
2005-06-21 16:00:00	AMZN	Stock	1.769	1.775	1.7665	1.77	312000.0
2005-06-21 17:00:00	AMZN	Stock	1.769	1.769	1.769	1.769	100420.0
2005-06-21 18:00:00	AMZN	Stock	1.77	1.77	1.77	1.77	9120.0
2005-06-21 09:00:00	CL	Stock	25.325	25.43	25.265	25.315	424600.0
2005-06-21 10:00:00	CL	Stock	25.31	25.36	25.25	25.255	570800.0
2005-06-21 11:00:00	CL	Stock	25.255	25.26	25.14	25.22	434200.0
2005-06-21 12:00:00	CL	Stock	25.22	25.28	25.2	25.235	375000.0
2005-06-21 13:00:00	CL	Stock	25.235	25.27	25.16	25.265	383600.0
2005-06-21 14:00:00	CL	Stock	25.27	25.34	25.265	25.31	525600.0

> showing 50 of 26,078 rows — these rows as CSV

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