PREVIEW / stock_1hour / 2000-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-05-23.parquet
  size:    272 KB
  rows:    14,303
  symbols: 1,163

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
2000-05-23 09:00:00	AAPL	Stock	0.808	0.8326	0.808	0.817	86027200.0
2000-05-23 10:00:00	AAPL	Stock	0.817	0.8237	0.7924	0.8108	107744000.0
2000-05-23 11:00:00	AAPL	Stock	0.8103	0.8337	0.8103	0.8281	81278400.0
2000-05-23 12:00:00	AAPL	Stock	0.8281	0.8281	0.8002	0.8097	35358400.0
2000-05-23 13:00:00	AAPL	Stock	0.8092	0.8276	0.7991	0.8253	28750400.0
2000-05-23 14:00:00	AAPL	Stock	0.8253	0.8281	0.7969	0.7969	51318400.0
2000-05-23 15:00:00	AAPL	Stock	0.7969	0.8047	0.7645	0.7662	108752000.0
2000-05-23 16:00:00	AAPL	Stock	0.7656	0.7662	0.7656	0.7662	201600.0
2000-05-23 09:00:00	MSFT	Stock	31.9375	32.1875	31.75	31.7812	6949200.0
2000-05-23 10:00:00	MSFT	Stock	31.7812	32.3125	31.625	32.1875	9920400.0
2000-05-23 11:00:00	MSFT	Stock	32.1875	32.7812	32.0625	32.5938	9416400.0
2000-05-23 12:00:00	MSFT	Stock	32.5938	32.5938	32.0938	32.3438	5813200.0
2000-05-23 13:00:00	MSFT	Stock	32.3594	32.5312	32.125	32.5	5765600.0
2000-05-23 14:00:00	MSFT	Stock	32.5	32.5938	31.9062	31.9375	7389000.0
2000-05-23 15:00:00	MSFT	Stock	31.9375	32.2188	31.5312	31.5938	10148400.0
2000-05-23 16:00:00	MSFT	Stock	31.5938	31.625	31.5938	31.625	157000.0
2000-05-23 09:00:00	NVDA	Stock	0.2208	0.2411	0.2172	0.2368	205968000.0
2000-05-23 10:00:00	NVDA	Stock	0.2361	0.2457	0.2333	0.2385	156192000.0
2000-05-23 11:00:00	NVDA	Stock	0.2366	0.2411	0.2336	0.238	74256000.0
2000-05-23 12:00:00	NVDA	Stock	0.238	0.2383	0.2323	0.2333	54048000.0
2000-05-23 13:00:00	NVDA	Stock	0.2323	0.2396	0.2299	0.2375	60864000.0
2000-05-23 14:00:00	NVDA	Stock	0.2375	0.2388	0.2312	0.232	45648000.0
2000-05-23 15:00:00	NVDA	Stock	0.2319	0.2344	0.2229	0.2249	157008000.0
2000-05-23 16:00:00	NVDA	Stock	0.2253	0.2253	0.2247	0.2247	5088000.0
2000-05-23 09:00:00	AMZN	Stock	2.525	2.5938	2.4625	2.475	14788000.0
2000-05-23 10:00:00	AMZN	Stock	2.4625	2.525	2.4406	2.5031	28788000.0
2000-05-23 11:00:00	AMZN	Stock	2.5031	2.5188	2.475	2.4812	16818000.0
2000-05-23 12:00:00	AMZN	Stock	2.4781	2.4891	2.4375	2.4563	6266000.0
2000-05-23 13:00:00	AMZN	Stock	2.4563	2.4938	2.4219	2.4938	8012000.0
2000-05-23 14:00:00	AMZN	Stock	2.4938	2.5031	2.4125	2.4125	11190000.0
2000-05-23 15:00:00	AMZN	Stock	2.4125	2.425	2.325	2.3313	28442000.0
2000-05-23 16:00:00	AMZN	Stock	2.3313	2.3344	2.3313	2.3344	130000.0
2000-05-23 09:00:00	CL	Stock	28.2812	28.3125	28.0312	28.0312	324800.0
2000-05-23 10:00:00	CL	Stock	28.0312	28.6875	27.8438	28.3438	653400.0
2000-05-23 11:00:00	CL	Stock	28.3438	28.5938	28.0312	28.125	630800.0
2000-05-23 12:00:00	CL	Stock	28.125	28.3125	28.0625	28.3125	169800.0
2000-05-23 13:00:00	CL	Stock	28.2812	28.3125	28.125	28.3125	250200.0
2000-05-23 14:00:00	CL	Stock	28.3125	28.3125	28.0938	28.2188	152400.0
2000-05-23 15:00:00	CL	Stock	28.2188	28.3438	27.9688	28.0	423400.0
2000-05-23 16:00:00	CL	Stock	27.9688	27.9688	27.9688	27.9688	51200.0

> showing 40 of 14,303 rows — these rows as CSV

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