PREVIEW / stock_1hour / 2005-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-05.parquet
  size:    534 KB
  rows:    25,681
  symbols: 1,963

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-05-05 08:00:00	AAPL	Stock	1.3268	1.3321	1.3261	1.3304	523740.0
2005-05-05 09:00:00	AAPL	Stock	1.3279	1.3314	1.3154	1.3196	57623076.0
2005-05-05 10:00:00	AAPL	Stock	1.3194	1.3286	1.3157	1.3182	67036368.0
2005-05-05 11:00:00	AAPL	Stock	1.3182	1.3239	1.3143	1.3218	39180148.0
2005-05-05 12:00:00	AAPL	Stock	1.3218	1.3243	1.3071	1.3082	47021688.0
2005-05-05 13:00:00	AAPL	Stock	1.3082	1.3136	1.3025	1.3075	64882384.0
2005-05-05 14:00:00	AAPL	Stock	1.3079	1.3114	1.3029	1.3036	34656132.0
2005-05-05 15:00:00	AAPL	Stock	1.3036	1.3121	1.3032	1.3104	70148288.0
2005-05-05 16:00:00	AAPL	Stock	1.3107	1.3132	1.3083	1.3104	1643824.0
2005-05-05 17:00:00	AAPL	Stock	1.3093	1.3114	1.3089	1.3114	485800.0
2005-05-05 18:00:00	AAPL	Stock	1.3093	1.31	1.3093	1.3093	28000.0
2005-05-05 08:00:00	MSFT	Stock	25.28	25.28	25.19	25.24	21120.0
2005-05-05 09:00:00	MSFT	Stock	25.24	25.33	25.16	25.26	4916270.0
2005-05-05 10:00:00	MSFT	Stock	25.08	25.31	25.08	25.2	11269021.0
2005-05-05 11:00:00	MSFT	Stock	25.2	25.23	25.16	25.19	7127868.0
2005-05-05 12:00:00	MSFT	Stock	25.19	25.29	25.17	25.19	11659312.0
2005-05-05 13:00:00	MSFT	Stock	25.19	25.29	25.18	25.24	7319655.0
2005-05-05 14:00:00	MSFT	Stock	25.25	25.25	25.16	25.17	5913554.0
2005-05-05 15:00:00	MSFT	Stock	25.16	25.27	25.14	25.23	9847467.0
2005-05-05 16:00:00	MSFT	Stock	25.22	25.352	25.211	25.24	493812.0
2005-05-05 17:00:00	MSFT	Stock	25.24	25.24	25.22	25.22	17288.0
2005-05-05 18:00:00	MSFT	Stock	25.23	25.24	25.22	25.22	5509.0
2005-05-05 08:00:00	NVDA	Stock	0.1868	0.1868	0.1868	0.1868	12000.0
2005-05-05 09:00:00	NVDA	Stock	0.1871	0.1905	0.1869	0.19	81311520.0
2005-05-05 10:00:00	NVDA	Stock	0.1901	0.1909	0.1877	0.1902	90043680.0
2005-05-05 11:00:00	NVDA	Stock	0.1902	0.1912	0.19	0.191	67896600.0
2005-05-05 12:00:00	NVDA	Stock	0.1908	0.1928	0.1897	0.1897	76765800.0
2005-05-05 13:00:00	NVDA	Stock	0.1897	0.1902	0.1877	0.1889	101381880.0
2005-05-05 14:00:00	NVDA	Stock	0.1891	0.1892	0.1881	0.1892	38512200.0
2005-05-05 15:00:00	NVDA	Stock	0.1892	0.1904	0.1887	0.1904	132512400.0
2005-05-05 16:00:00	NVDA	Stock	0.1901	0.1909	0.1895	0.1897	11010000.0
2005-05-05 17:00:00	NVDA	Stock	0.1894	0.1894	0.1894	0.1894	120000.0
2005-05-05 18:00:00	NVDA	Stock	0.1932	0.1932	0.1932	0.1932	600000.0
2005-05-05 08:00:00	AMZN	Stock	1.7	1.7	1.7	1.7	10000.0
2005-05-05 09:00:00	AMZN	Stock	1.698	1.7025	1.69	1.702	15210680.0
2005-05-05 10:00:00	AMZN	Stock	1.702	1.709	1.693	1.693	14662700.0
2005-05-05 11:00:00	AMZN	Stock	1.693	1.697	1.689	1.693	10031940.0
2005-05-05 12:00:00	AMZN	Stock	1.693	1.697	1.6865	1.6865	11145560.0
2005-05-05 13:00:00	AMZN	Stock	1.6865	1.691	1.6795	1.69	13725820.0
2005-05-05 14:00:00	AMZN	Stock	1.6895	1.6945	1.687	1.689	13345580.0
2005-05-05 15:00:00	AMZN	Stock	1.6885	1.6995	1.6885	1.698	12601160.0
2005-05-05 16:00:00	AMZN	Stock	1.6965	1.6995	1.6948	1.6985	240140.0
2005-05-05 17:00:00	AMZN	Stock	1.6995	1.6995	1.6995	1.6995	20000.0
2005-05-05 18:00:00	AMZN	Stock	1.6985	1.6985	1.6985	1.6985	12600.0
2005-05-05 09:00:00	CL	Stock	25.035	25.035	24.865	24.91	352000.0
2005-05-05 10:00:00	CL	Stock	24.91	24.93	24.875	24.88	641600.0
2005-05-05 11:00:00	CL	Stock	24.885	24.915	24.85	24.905	697800.0
2005-05-05 12:00:00	CL	Stock	24.905	24.915	24.775	24.8	623400.0
2005-05-05 13:00:00	CL	Stock	24.8	24.825	24.75	24.78	734000.0
2005-05-05 14:00:00	CL	Stock	24.78	24.795	24.67	24.68	663600.0

> showing 50 of 25,681 rows — these rows as CSV

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