PREVIEW / stock_1hour / 2005-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-06.parquet
  size:    568 KB
  rows:    27,121
  symbols: 2,067

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-09-06 08:00:00	AAPL	Stock	1.6561	1.6686	1.6507	1.6625	1313620.0
2005-09-06 09:00:00	AAPL	Stock	1.6507	1.6725	1.6507	1.6707	44086308.0
2005-09-06 10:00:00	AAPL	Stock	1.6704	1.7268	1.67	1.7139	179903248.0
2005-09-06 11:00:00	AAPL	Stock	1.7139	1.7396	1.7121	1.7379	181026944.0
2005-09-06 12:00:00	AAPL	Stock	1.7379	1.7432	1.7329	1.7368	113901312.0
2005-09-06 13:00:00	AAPL	Stock	1.7371	1.7382	1.7264	1.7354	80012184.0
2005-09-06 14:00:00	AAPL	Stock	1.7354	1.7418	1.7325	1.7361	70363188.0
2005-09-06 15:00:00	AAPL	Stock	1.7361	1.7457	1.7346	1.7429	126890960.0
2005-09-06 16:00:00	AAPL	Stock	1.7425	1.75	1.6507	1.7482	6902644.0
2005-09-06 17:00:00	AAPL	Stock	1.7482	1.7489	1.7446	1.7489	491008.0
2005-09-06 18:00:00	AAPL	Stock	1.7428	1.7496	1.7428	1.7493	141764.0
2005-09-06 08:00:00	MSFT	Stock	27.08	27.14	27.02	27.11	65236.0
2005-09-06 09:00:00	MSFT	Stock	27.11	27.13	27.0	27.11	5213968.0
2005-09-06 10:00:00	MSFT	Stock	27.11	27.29	27.09	27.17	9226678.0
2005-09-06 11:00:00	MSFT	Stock	27.17	27.2	27.12	27.15	4303638.0
2005-09-06 12:00:00	MSFT	Stock	27.14	27.2	27.12	27.16	2797824.0
2005-09-06 13:00:00	MSFT	Stock	27.17	27.2	27.04	27.11	3877284.0
2005-09-06 14:00:00	MSFT	Stock	27.12	27.13	27.02	27.03	5767644.0
2005-09-06 15:00:00	MSFT	Stock	27.04	27.09	26.98	27.01	11931539.0
2005-09-06 16:00:00	MSFT	Stock	27.0	27.126	26.98	26.98	729831.0
2005-09-06 17:00:00	MSFT	Stock	27.0	27.01	27.0	27.0	4657.0
2005-09-06 18:00:00	MSFT	Stock	27.01	27.02	27.0	27.02	3700.0
2005-09-06 08:00:00	NVDA	Stock	0.2542	0.2542	0.2542	0.2542	144000.0
2005-09-06 09:00:00	NVDA	Stock	0.2516	0.2545	0.2487	0.2497	98140560.0
2005-09-06 10:00:00	NVDA	Stock	0.2498	0.255	0.2495	0.2527	94810680.0
2005-09-06 11:00:00	NVDA	Stock	0.2528	0.2538	0.2527	0.2528	39402840.0
2005-09-06 12:00:00	NVDA	Stock	0.2528	0.2537	0.2527	0.2535	20951880.0
2005-09-06 13:00:00	NVDA	Stock	0.2535	0.2544	0.2532	0.2538	26636040.0
2005-09-06 14:00:00	NVDA	Stock	0.2539	0.254	0.2527	0.2528	24940080.0
2005-09-06 15:00:00	NVDA	Stock	0.2529	0.2537	0.2517	0.2537	106556040.0
2005-09-06 16:00:00	NVDA	Stock	0.2537	0.2537	0.2525	0.2525	1877640.0
2005-09-06 17:00:00	NVDA	Stock	0.254	0.254	0.254	0.254	1236720.0
2005-09-06 08:00:00	AMZN	Stock	2.0755	2.0755	2.0755	2.0755	28300.0
2005-09-06 09:00:00	AMZN	Stock	2.077	2.1035	2.0725	2.099	12734540.0
2005-09-06 10:00:00	AMZN	Stock	2.099	2.1525	2.094	2.1475	31657060.0
2005-09-06 11:00:00	AMZN	Stock	2.148	2.168	2.142	2.1625	23651600.0
2005-09-06 12:00:00	AMZN	Stock	2.163	2.174	2.1565	2.167	23099640.0
2005-09-06 13:00:00	AMZN	Stock	2.168	2.1705	2.1635	2.1645	9672800.0
2005-09-06 14:00:00	AMZN	Stock	2.1645	2.174	2.164	2.174	14262260.0
2005-09-06 15:00:00	AMZN	Stock	2.174	2.1825	2.169	2.181	39688200.0
2005-09-06 16:00:00	AMZN	Stock	2.1795	2.183	2.175	2.183	441240.0
2005-09-06 17:00:00	AMZN	Stock	2.1825	2.1825	2.17	2.181	287900.0
2005-09-06 18:00:00	AMZN	Stock	2.1775	2.1775	2.17	2.17	65800.0
2005-09-06 08:00:00	CL	Stock	26.24	26.24	26.24	26.24	800.0
2005-09-06 09:00:00	CL	Stock	26.59	26.595	26.5	26.575	623600.0
2005-09-06 10:00:00	CL	Stock	26.595	26.765	26.545	26.74	877800.0
2005-09-06 11:00:00	CL	Stock	26.74	26.74	26.65	26.72	451600.0
2005-09-06 12:00:00	CL	Stock	26.72	26.82	26.715	26.755	430000.0
2005-09-06 13:00:00	CL	Stock	26.755	26.77	26.68	26.74	436200.0
2005-09-06 14:00:00	CL	Stock	26.745	26.75	26.665	26.67	422600.0

> showing 50 of 27,121 rows — these rows as CSV

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