PREVIEW / stock_1hour / 2000-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-19.parquet
  size:    295 KB
  rows:    15,165
  symbols: 1,171

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-06-19 09:00:00	AAPL	Stock	0.8125	0.8164	0.8019	0.8092	43243200.0
2000-06-19 10:00:00	AAPL	Stock	0.8103	0.8164	0.8064	0.8125	51284800.0
2000-06-19 11:00:00	AAPL	Stock	0.8142	0.8147	0.8086	0.8114	17852800.0
2000-06-19 12:00:00	AAPL	Stock	0.8114	0.8147	0.8097	0.8136	15467200.0
2000-06-19 13:00:00	AAPL	Stock	0.8125	0.8393	0.8125	0.8393	56795200.0
2000-06-19 14:00:00	AAPL	Stock	0.8393	0.8694	0.8387	0.865	102816000.0
2000-06-19 15:00:00	AAPL	Stock	0.8672	0.8739	0.8594	0.8633	94595200.0
2000-06-19 16:00:00	AAPL	Stock	0.8633	0.8795	0.8627	0.8633	6126400.0
2000-06-19 17:00:00	AAPL	Stock	0.875	0.875	0.8627	0.8705	1736000.0
2000-06-19 18:00:00	AAPL	Stock	0.875	0.8761	0.875	0.875	392000.0
2000-06-19 08:00:00	MSFT	Stock	36.3125	36.5	36.1562	36.25	42200.0
2000-06-19 09:00:00	MSFT	Stock	36.25	36.375	36.0312	36.1562	7771200.0
2000-06-19 10:00:00	MSFT	Stock	36.1562	36.25	36.0938	36.1875	5074600.0
2000-06-19 11:00:00	MSFT	Stock	36.1875	36.2188	36.0312	36.1875	4208200.0
2000-06-19 12:00:00	MSFT	Stock	36.2188	36.25	36.0312	36.0625	3654600.0
2000-06-19 13:00:00	MSFT	Stock	36.0312	36.25	36.0	36.2188	4706200.0
2000-06-19 14:00:00	MSFT	Stock	36.2188	36.5625	36.1875	36.5	6061000.0
2000-06-19 15:00:00	MSFT	Stock	36.4688	36.9062	36.3438	36.875	11908600.0
2000-06-19 16:00:00	MSFT	Stock	36.875	36.9062	36.1562	36.75	2523200.0
2000-06-19 17:00:00	MSFT	Stock	36.75	36.8438	36.7188	36.75	234000.0
2000-06-19 18:00:00	MSFT	Stock	36.8438	36.8438	36.7188	36.8438	5600.0
2000-06-19 08:00:00	NVDA	Stock	0.3099	0.3104	0.3099	0.3104	432000.0
2000-06-19 09:00:00	NVDA	Stock	0.3104	0.3288	0.3083	0.3187	181056000.0
2000-06-19 10:00:00	NVDA	Stock	0.3182	0.3219	0.3034	0.3195	151392000.0
2000-06-19 11:00:00	NVDA	Stock	0.3195	0.325	0.3134	0.323	63744000.0
2000-06-19 12:00:00	NVDA	Stock	0.3229	0.3331	0.3219	0.3301	88512000.0
2000-06-19 13:00:00	NVDA	Stock	0.3297	0.3375	0.3271	0.3333	88992000.0
2000-06-19 14:00:00	NVDA	Stock	0.3331	0.351	0.332	0.3474	140784000.0
2000-06-19 15:00:00	NVDA	Stock	0.3474	0.3568	0.3289	0.3326	263136000.0
2000-06-19 16:00:00	NVDA	Stock	0.3323	0.3354	0.3187	0.3271	50688000.0
2000-06-19 17:00:00	NVDA	Stock	0.3292	0.3299	0.3289	0.3289	288000.0
2000-06-19 18:00:00	NVDA	Stock	0.3286	0.3289	0.3281	0.3281	144000.0
2000-06-19 08:00:00	AMZN	Stock	2.3156	2.325	2.25	2.25	170000.0
2000-06-19 09:00:00	AMZN	Stock	2.25	2.2875	2.2125	2.2281	13134000.0
2000-06-19 10:00:00	AMZN	Stock	2.2281	2.2531	2.2	2.2156	13138000.0
2000-06-19 11:00:00	AMZN	Stock	2.2156	2.2188	2.175	2.1906	13340000.0
2000-06-19 12:00:00	AMZN	Stock	2.1938	2.1938	2.1812	2.1906	9836000.0
2000-06-19 13:00:00	AMZN	Stock	2.1938	2.2562	2.1875	2.2438	18314000.0
2000-06-19 14:00:00	AMZN	Stock	2.2406	2.2938	2.225	2.2406	15552000.0
2000-06-19 15:00:00	AMZN	Stock	2.2406	2.2719	2.2281	2.2656	17040000.0
2000-06-19 16:00:00	AMZN	Stock	2.2656	2.2984	2.2281	2.275	1798000.0
2000-06-19 17:00:00	AMZN	Stock	2.2469	2.275	2.2469	2.2688	414000.0
2000-06-19 18:00:00	AMZN	Stock	2.275	2.275	2.275	2.275	2000.0
2000-06-19 09:00:00	CL	Stock	28.875	29.0625	28.8125	29.0	124400.0
2000-06-19 10:00:00	CL	Stock	28.9375	29.0938	28.6562	28.6562	250200.0
2000-06-19 11:00:00	CL	Stock	28.7188	28.75	28.5938	28.6875	246600.0
2000-06-19 12:00:00	CL	Stock	28.6875	28.875	28.6562	28.875	364000.0
2000-06-19 13:00:00	CL	Stock	28.875	29.0312	28.875	28.9062	197000.0
2000-06-19 14:00:00	CL	Stock	28.9062	29.125	28.875	29.125	246600.0
2000-06-19 15:00:00	CL	Stock	29.0938	29.0938	28.7812	28.7812	424600.0

> showing 50 of 15,165 rows — these rows as CSV

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