PREVIEW / stock_1hour / 2004-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-08.parquet
  size:    503 KB
  rows:    23,719
  symbols: 1,836

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
2004-09-08 08:00:00	AAPL	Stock	0.6386	0.6386	0.6386	0.6386	11200.0
2004-09-08 09:00:00	AAPL	Stock	0.6373	0.6455	0.6373	0.6434	42114520.0
2004-09-08 10:00:00	AAPL	Stock	0.6436	0.653	0.6416	0.648	95171608.0
2004-09-08 11:00:00	AAPL	Stock	0.6482	0.6525	0.6455	0.6459	39648392.0
2004-09-08 12:00:00	AAPL	Stock	0.6461	0.6486	0.6432	0.6452	30033416.0
2004-09-08 13:00:00	AAPL	Stock	0.6452	0.6509	0.645	0.6496	22924944.0
2004-09-08 14:00:00	AAPL	Stock	0.6498	0.6527	0.6488	0.6496	38095904.0
2004-09-08 15:00:00	AAPL	Stock	0.6496	0.6516	0.6471	0.6491	50822408.0
2004-09-08 16:00:00	AAPL	Stock	0.6491	0.65	0.648	0.6493	5119184.0
2004-09-08 17:00:00	AAPL	Stock	0.6493	0.65	0.64	0.6496	575456.0
2004-09-08 18:00:00	AAPL	Stock	0.6486	0.6486	0.6486	0.6486	5600.0
2004-09-08 08:00:00	MSFT	Stock	27.29	27.31	27.29	27.29	17333.0
2004-09-08 09:00:00	MSFT	Stock	27.3	27.36	27.24	27.27	4324321.0
2004-09-08 10:00:00	MSFT	Stock	27.27	27.39	27.25	27.31	6650320.0
2004-09-08 11:00:00	MSFT	Stock	27.31	27.35	27.25	27.26	4982619.0
2004-09-08 12:00:00	MSFT	Stock	27.26	27.28	27.14	27.16	5500776.0
2004-09-08 13:00:00	MSFT	Stock	27.17	27.26	27.16	27.22	4212521.0
2004-09-08 14:00:00	MSFT	Stock	27.22	27.29	27.21	27.22	6555525.0
2004-09-08 15:00:00	MSFT	Stock	27.22	27.31	27.18	27.26	7539091.0
2004-09-08 16:00:00	MSFT	Stock	27.27	27.32	27.25	27.3	9908087.0
2004-09-08 17:00:00	MSFT	Stock	27.29	27.29	27.2258	27.28	159277.0
2004-09-08 18:00:00	MSFT	Stock	27.26	27.28	27.26	27.28	600.0
2004-09-08 09:00:00	NVDA	Stock	0.1047	0.1058	0.1028	0.1042	107429880.0
2004-09-08 10:00:00	NVDA	Stock	0.1042	0.105	0.1032	0.1034	142587360.0
2004-09-08 11:00:00	NVDA	Stock	0.1034	0.104	0.103	0.1032	100844880.0
2004-09-08 12:00:00	NVDA	Stock	0.1032	0.1037	0.1029	0.103	86465760.0
2004-09-08 13:00:00	NVDA	Stock	0.1029	0.1037	0.1028	0.1036	77113080.0
2004-09-08 14:00:00	NVDA	Stock	0.1035	0.1037	0.103	0.1033	59455440.0
2004-09-08 15:00:00	NVDA	Stock	0.1033	0.1036	0.1024	0.1027	193645800.0
2004-09-08 16:00:00	NVDA	Stock	0.1027	0.1038	0.1024	0.1027	38384400.0
2004-09-08 17:00:00	NVDA	Stock	0.1029	0.103	0.1027	0.103	1668000.0
2004-09-08 08:00:00	AMZN	Stock	1.925	1.925	1.925	1.925	40000.0
2004-09-08 09:00:00	AMZN	Stock	1.9205	1.9375	1.912	1.917	14534980.0
2004-09-08 10:00:00	AMZN	Stock	1.917	1.9405	1.911	1.914	21556600.0
2004-09-08 11:00:00	AMZN	Stock	1.914	1.921	1.9105	1.916	12449500.0
2004-09-08 12:00:00	AMZN	Stock	1.9155	1.9175	1.8935	1.9	18028780.0
2004-09-08 13:00:00	AMZN	Stock	1.9005	1.913	1.898	1.9075	13450380.0
2004-09-08 14:00:00	AMZN	Stock	1.9075	1.917	1.899	1.9005	14417220.0
2004-09-08 15:00:00	AMZN	Stock	1.9005	1.901	1.8855	1.8995	31726980.0
2004-09-08 16:00:00	AMZN	Stock	1.899	1.9375	1.8945	1.8965	1227820.0
2004-09-08 17:00:00	AMZN	Stock	1.8995	1.9146	1.8965	1.9	229420.0
2004-09-08 18:00:00	AMZN	Stock	1.9	1.9	1.9	1.9	4000.0
2004-09-08 09:00:00	CL	Stock	27.5	27.5	27.355	27.36	275400.0
2004-09-08 10:00:00	CL	Stock	27.355	27.45	27.275	27.3	730800.0
2004-09-08 11:00:00	CL	Stock	27.3	27.385	27.28	27.3	753800.0
2004-09-08 12:00:00	CL	Stock	27.3	27.315	27.255	27.27	161200.0
2004-09-08 13:00:00	CL	Stock	27.27	27.29	27.26	27.28	153400.0
2004-09-08 14:00:00	CL	Stock	27.275	27.29	27.225	27.245	391600.0
2004-09-08 15:00:00	CL	Stock	27.245	27.325	27.215	27.25	446000.0
2004-09-08 16:00:00	CL	Stock	27.25	27.25	27.25	27.25	32400.0

> showing 50 of 23,719 rows — these rows as CSV

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