PREVIEW / stock_1hour / 2005-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-26.parquet
  size:    551 KB
  rows:    26,338
  symbols: 2,054

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-07-26 08:00:00	AAPL	Stock	1.5671	1.5743	1.5654	1.5711	247856.0
2005-07-26 09:00:00	AAPL	Stock	1.5704	1.5746	1.5639	1.57	48564852.0
2005-07-26 10:00:00	AAPL	Stock	1.5704	1.5754	1.5507	1.5529	72683828.0
2005-07-26 11:00:00	AAPL	Stock	1.5532	1.5589	1.5486	1.5564	35854140.0
2005-07-26 12:00:00	AAPL	Stock	1.5564	1.5568	1.5486	1.5536	22969884.0
2005-07-26 13:00:00	AAPL	Stock	1.5532	1.5636	1.5511	1.5632	23624048.0
2005-07-26 14:00:00	AAPL	Stock	1.5632	1.5664	1.5618	1.5636	25190704.0
2005-07-26 15:00:00	AAPL	Stock	1.5636	1.5639	1.5564	1.5564	31532088.0
2005-07-26 16:00:00	AAPL	Stock	1.5568	1.5607	1.5564	1.5564	987756.0
2005-07-26 17:00:00	AAPL	Stock	1.5571	1.5593	1.5543	1.5593	879760.0
2005-07-26 08:00:00	MSFT	Stock	25.75	26.1	25.66	25.7	44621.0
2005-07-26 09:00:00	MSFT	Stock	25.7	25.74	25.65	25.72	5392731.0
2005-07-26 10:00:00	MSFT	Stock	25.73	25.73	25.61	25.65	9516026.0
2005-07-26 11:00:00	MSFT	Stock	25.65	25.7	25.64	25.68	4638032.0
2005-07-26 12:00:00	MSFT	Stock	25.67	25.7	25.56	25.57	6071321.0
2005-07-26 13:00:00	MSFT	Stock	25.57	25.62	25.53	25.6	5706028.0
2005-07-26 14:00:00	MSFT	Stock	25.6	25.62	25.53	25.56	6405417.0
2005-07-26 15:00:00	MSFT	Stock	25.56	25.66	25.539	25.54	11161861.0
2005-07-26 16:00:00	MSFT	Stock	25.55	25.583	25.52	25.54	573000.0
2005-07-26 17:00:00	MSFT	Stock	25.53	25.55	25.53	25.55	586528.0
2005-07-26 18:00:00	MSFT	Stock	25.542	25.55	25.52	25.55	2595139.0
2005-07-26 07:00:00	NVDA	Stock	0.215	0.215	0.2133	0.2133	288000.0
2005-07-26 08:00:00	NVDA	Stock	0.2133	0.2171	0.2133	0.2167	3318000.0
2005-07-26 09:00:00	NVDA	Stock	0.2164	0.2189	0.2147	0.2183	103380840.0
2005-07-26 10:00:00	NVDA	Stock	0.2182	0.2185	0.2163	0.2168	146013720.0
2005-07-26 11:00:00	NVDA	Stock	0.2168	0.2184	0.2166	0.218	90733920.0
2005-07-26 12:00:00	NVDA	Stock	0.2181	0.2192	0.2172	0.2177	79839360.0
2005-07-26 13:00:00	NVDA	Stock	0.2177	0.22	0.2177	0.2199	58025880.0
2005-07-26 14:00:00	NVDA	Stock	0.2199	0.2207	0.2194	0.2202	118836960.0
2005-07-26 15:00:00	NVDA	Stock	0.2202	0.2213	0.2197	0.2211	136649400.0
2005-07-26 16:00:00	NVDA	Stock	0.2211	0.2211	0.2205	0.2208	14873280.0
2005-07-26 17:00:00	NVDA	Stock	0.2206	0.2206	0.2197	0.2199	396000.0
2005-07-26 08:00:00	AMZN	Stock	1.9	1.9125	1.9	1.9025	70000.0
2005-07-26 09:00:00	AMZN	Stock	1.9025	1.9255	1.9025	1.9245	14526940.0
2005-07-26 10:00:00	AMZN	Stock	1.924	1.9375	1.915	1.9215	25085760.0
2005-07-26 11:00:00	AMZN	Stock	1.9205	1.9275	1.907	1.916	17119720.0
2005-07-26 12:00:00	AMZN	Stock	1.916	1.9195	1.9045	1.9175	13874660.0
2005-07-26 13:00:00	AMZN	Stock	1.9185	1.9265	1.91	1.9165	22940700.0
2005-07-26 14:00:00	AMZN	Stock	1.9165	1.917	1.9105	1.9145	29720600.0
2005-07-26 15:00:00	AMZN	Stock	1.9145	1.915	1.886	1.887	69986840.0
2005-07-26 16:00:00	AMZN	Stock	1.8875	2.0715	1.8855	2.0525	102053640.0
2005-07-26 17:00:00	AMZN	Stock	2.0535	2.09	1.8875	2.0875	21524200.0
2005-07-26 18:00:00	AMZN	Stock	2.0855	2.092	2.075	2.092	5767640.0
2005-07-26 09:00:00	CL	Stock	25.89	25.985	25.86	25.96	338600.0
2005-07-26 10:00:00	CL	Stock	25.96	26.07	25.935	25.96	804800.0
2005-07-26 11:00:00	CL	Stock	25.96	25.97	25.84	25.92	369200.0
2005-07-26 12:00:00	CL	Stock	25.92	25.945	25.875	25.92	258000.0
2005-07-26 13:00:00	CL	Stock	25.92	25.975	25.87	25.975	302600.0
2005-07-26 14:00:00	CL	Stock	25.97	26.115	25.935	26.095	825800.0
2005-07-26 15:00:00	CL	Stock	26.09	26.09	25.89	25.89	1294200.0

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

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