PREVIEW / stock_1hour / 2004-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-20.parquet
  size:    528 KB
  rows:    24,191
  symbols: 1,721

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-01-20 08:00:00	AAPL	Stock	0.4054	0.4088	0.4054	0.4077	998480.0
2004-01-20 09:00:00	AAPL	Stock	0.408	0.408	0.3996	0.3996	63035168.0
2004-01-20 10:00:00	AAPL	Stock	0.3995	0.4018	0.3973	0.4013	65146928.0
2004-01-20 11:00:00	AAPL	Stock	0.4014	0.4018	0.3995	0.4016	28313432.0
2004-01-20 12:00:00	AAPL	Stock	0.4013	0.4018	0.4009	0.4016	20880552.0
2004-01-20 13:00:00	AAPL	Stock	0.4018	0.4055	0.4018	0.4052	29782032.0
2004-01-20 14:00:00	AAPL	Stock	0.4054	0.4071	0.4036	0.4068	29109696.0
2004-01-20 15:00:00	AAPL	Stock	0.4068	0.4071	0.4029	0.4063	50415512.0
2004-01-20 16:00:00	AAPL	Stock	0.4056	0.4068	0.4055	0.4061	6277824.0
2004-01-20 17:00:00	AAPL	Stock	0.4059	0.4059	0.4059	0.4059	39200.0
2004-01-20 18:00:00	AAPL	Stock	0.4054	0.4054	0.4054	0.4054	11200.0
2004-01-20 08:00:00	MSFT	Stock	28.05	28.08	27.82	27.99	165794.0
2004-01-20 09:00:00	MSFT	Stock	27.99	28.07	27.93	28.03	11801859.0
2004-01-20 10:00:00	MSFT	Stock	28.05	28.2	28.02	28.09	10667147.0
2004-01-20 11:00:00	MSFT	Stock	28.1	28.11	27.98	28.1	6789168.0
2004-01-20 12:00:00	MSFT	Stock	28.09	28.18	28.08	28.15	6281869.0
2004-01-20 13:00:00	MSFT	Stock	28.15	28.19	28.12	28.14	3874483.0
2004-01-20 14:00:00	MSFT	Stock	28.13	28.19	28.05	28.16	6142103.0
2004-01-20 15:00:00	MSFT	Stock	28.16	28.17	28.05	28.08	8062132.0
2004-01-20 16:00:00	MSFT	Stock	28.08	28.14	28.03	28.07	4480267.0
2004-01-20 17:00:00	MSFT	Stock	28.06	28.1	28.06	28.06	21710.0
2004-01-20 18:00:00	MSFT	Stock	28.05	28.09	28.03	28.03	11125.0
2004-01-20 08:00:00	NVDA	Stock	0.2065	0.2067	0.2065	0.2067	816000.0
2004-01-20 09:00:00	NVDA	Stock	0.2067	0.2103	0.2063	0.2075	107316000.0
2004-01-20 10:00:00	NVDA	Stock	0.2075	0.2091	0.2071	0.2072	82315200.0
2004-01-20 11:00:00	NVDA	Stock	0.2072	0.2079	0.2057	0.2062	39735120.0
2004-01-20 12:00:00	NVDA	Stock	0.2064	0.2082	0.2061	0.2075	34339440.0
2004-01-20 13:00:00	NVDA	Stock	0.2074	0.2077	0.2065	0.2077	37124640.0
2004-01-20 14:00:00	NVDA	Stock	0.2075	0.2107	0.2075	0.2106	64981080.0
2004-01-20 15:00:00	NVDA	Stock	0.2106	0.2116	0.2097	0.2111	101824080.0
2004-01-20 16:00:00	NVDA	Stock	0.2114	0.2114	0.2092	0.2092	4918800.0
2004-01-20 17:00:00	NVDA	Stock	0.2093	0.2112	0.2092	0.2092	228000.0
2004-01-20 08:00:00	AMZN	Stock	2.7875	2.7935	2.787	2.791	66000.0
2004-01-20 09:00:00	AMZN	Stock	2.7895	2.7995	2.7695	2.7826	24016480.0
2004-01-20 10:00:00	AMZN	Stock	2.7825	2.8095	2.7765	2.8005	18215440.0
2004-01-20 11:00:00	AMZN	Stock	2.802	2.825	2.7935	2.804	23931360.0
2004-01-20 12:00:00	AMZN	Stock	2.804	2.8325	2.804	2.821	15768140.0
2004-01-20 13:00:00	AMZN	Stock	2.821	2.8325	2.8175	2.828	9535740.0
2004-01-20 14:00:00	AMZN	Stock	2.828	2.831	2.816	2.824	23586560.0
2004-01-20 15:00:00	AMZN	Stock	2.8245	2.842	2.8225	2.8279	30902460.0
2004-01-20 16:00:00	AMZN	Stock	2.827	2.8415	2.8105	2.828	3120400.0
2004-01-20 17:00:00	AMZN	Stock	2.83	2.8305	2.8284	2.8285	117880.0
2004-01-20 18:00:00	AMZN	Stock	2.8265	2.8265	2.8265	2.8265	12000.0
2004-01-20 09:00:00	CL	Stock	25.75	25.75	25.65	25.715	626000.0
2004-01-20 10:00:00	CL	Stock	25.72	25.86	25.65	25.74	2242800.0
2004-01-20 11:00:00	CL	Stock	25.745	25.77	25.575	25.58	623600.0
2004-01-20 12:00:00	CL	Stock	25.585	25.62	25.45	25.485	715000.0
2004-01-20 13:00:00	CL	Stock	25.48	25.595	25.47	25.585	635200.0
2004-01-20 14:00:00	CL	Stock	25.585	25.59	25.485	25.54	639000.0
2004-01-20 15:00:00	CL	Stock	25.54	25.545	25.45	25.5445	883600.0

> showing 50 of 24,191 rows — these rows as CSV

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