PREVIEW / stock_1hour / 2005-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-22.parquet
  size:    558 KB
  rows:    27,073
  symbols: 2,076

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-08-22 08:00:00	AAPL	Stock	1.6582	1.6582	1.6439	1.6464	375704.0
2005-08-22 09:00:00	AAPL	Stock	1.6464	1.6654	1.6429	1.6614	60893784.0
2005-08-22 10:00:00	AAPL	Stock	1.6618	1.6696	1.6596	1.6629	59425212.0
2005-08-22 11:00:00	AAPL	Stock	1.6623	1.6636	1.6446	1.6461	45676008.0
2005-08-22 12:00:00	AAPL	Stock	1.6457	1.6486	1.6214	1.6282	73081092.0
2005-08-22 13:00:00	AAPL	Stock	1.6279	1.64	1.6164	1.6375	52518760.0
2005-08-22 14:00:00	AAPL	Stock	1.6379	1.6379	1.6264	1.6293	27317920.0
2005-08-22 15:00:00	AAPL	Stock	1.6293	1.6393	1.6271	1.6379	61879804.0
2005-08-22 16:00:00	AAPL	Stock	1.6382	1.645	1.6375	1.6429	1822156.0
2005-08-22 17:00:00	AAPL	Stock	1.6432	1.6636	1.6375	1.6636	449736.0
2005-08-22 18:00:00	AAPL	Stock	1.6411	1.6425	1.6411	1.6425	28000.0
2005-08-22 08:00:00	MSFT	Stock	26.75	26.85	26.52	26.8	9350.0
2005-08-22 09:00:00	MSFT	Stock	26.8	27.02	26.73	26.99	5657975.0
2005-08-22 10:00:00	MSFT	Stock	27.0	27.17	26.99	27.11	7315757.0
2005-08-22 11:00:00	MSFT	Stock	27.12	27.13	26.92	26.97	6640130.0
2005-08-22 12:00:00	MSFT	Stock	26.97	26.98	26.8	26.87	6561478.0
2005-08-22 13:00:00	MSFT	Stock	26.86	26.93	26.79	26.93	3633751.0
2005-08-22 14:00:00	MSFT	Stock	26.93	26.94	26.8	26.88	4788283.0
2005-08-22 15:00:00	MSFT	Stock	26.878	26.92	26.79	26.89	5802824.0
2005-08-22 16:00:00	MSFT	Stock	26.88	26.934	26.869	26.92	481896.0
2005-08-22 17:00:00	MSFT	Stock	26.91	27.12	26.9	27.12	52256.0
2005-08-22 18:00:00	MSFT	Stock	26.91	26.91	26.91	26.91	100.0
2005-08-22 08:00:00	NVDA	Stock	0.2433	0.2434	0.2417	0.2433	159360.0
2005-08-22 09:00:00	NVDA	Stock	0.2433	0.2451	0.2429	0.2446	91469520.0
2005-08-22 10:00:00	NVDA	Stock	0.2446	0.2468	0.2443	0.2452	93680880.0
2005-08-22 11:00:00	NVDA	Stock	0.2452	0.2453	0.2412	0.2414	64141560.0
2005-08-22 12:00:00	NVDA	Stock	0.2414	0.2417	0.2385	0.24	80592960.0
2005-08-22 13:00:00	NVDA	Stock	0.24	0.2413	0.2387	0.2408	56285520.0
2005-08-22 14:00:00	NVDA	Stock	0.2407	0.2408	0.2389	0.2407	60381480.0
2005-08-22 15:00:00	NVDA	Stock	0.2407	0.2422	0.2404	0.2413	92186400.0
2005-08-22 16:00:00	NVDA	Stock	0.2416	0.2416	0.2412	0.2412	4394400.0
2005-08-22 08:00:00	AMZN	Stock	2.169	2.195	2.169	2.195	4000.0
2005-08-22 09:00:00	AMZN	Stock	2.1875	2.2135	2.1805	2.2055	19539000.0
2005-08-22 10:00:00	AMZN	Stock	2.206	2.208	2.187	2.1875	15309980.0
2005-08-22 11:00:00	AMZN	Stock	2.1875	2.1915	2.169	2.172	15819260.0
2005-08-22 12:00:00	AMZN	Stock	2.172	2.173	2.147	2.1615	17427000.0
2005-08-22 13:00:00	AMZN	Stock	2.1615	2.1745	2.1574	2.1745	8533280.0
2005-08-22 14:00:00	AMZN	Stock	2.174	2.183	2.1695	2.1785	7569200.0
2005-08-22 15:00:00	AMZN	Stock	2.1785	2.189	2.1745	2.188	17526200.0
2005-08-22 16:00:00	AMZN	Stock	2.19	2.1915	2.1885	2.19	300340.0
2005-08-22 17:00:00	AMZN	Stock	2.1885	2.1995	2.1885	2.1995	214300.0
2005-08-22 18:00:00	AMZN	Stock	2.1925	2.195	2.1925	2.195	13840.0
2005-08-22 09:00:00	CL	Stock	26.075	26.32	26.075	26.235	412200.0
2005-08-22 10:00:00	CL	Stock	26.235	26.29	26.18	26.215	474200.0
2005-08-22 11:00:00	CL	Stock	26.21	26.285	26.205	26.285	474600.0
2005-08-22 12:00:00	CL	Stock	26.28	26.285	26.125	26.135	299400.0
2005-08-22 13:00:00	CL	Stock	26.13	26.28	26.09	26.205	652600.0
2005-08-22 14:00:00	CL	Stock	26.2	26.255	26.175	26.21	341000.0
2005-08-22 15:00:00	CL	Stock	26.21	26.235	26.19	26.21	752400.0
2005-08-22 16:00:00	CL	Stock	26.115	26.205	26.115	26.205	1800.0

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

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