PREVIEW / stock_1hour / 2004-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-01.parquet
  size:    500 KB
  rows:    23,371
  symbols: 1,827

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-01 08:00:00	AAPL	Stock	0.6149	0.6157	0.6149	0.6157	174048.0
2004-09-01 09:00:00	AAPL	Stock	0.6141	0.6168	0.6107	0.6163	28686616.0
2004-09-01 10:00:00	AAPL	Stock	0.6161	0.6268	0.6157	0.6241	60954320.0
2004-09-01 11:00:00	AAPL	Stock	0.6241	0.6261	0.6193	0.6257	32198152.0
2004-09-01 12:00:00	AAPL	Stock	0.6257	0.6416	0.625	0.6371	129172288.0
2004-09-01 13:00:00	AAPL	Stock	0.6371	0.6427	0.6293	0.637	108497760.0
2004-09-01 14:00:00	AAPL	Stock	0.6368	0.64	0.6336	0.6398	48860168.0
2004-09-01 15:00:00	AAPL	Stock	0.64	0.6416	0.6338	0.6402	77974176.0
2004-09-01 16:00:00	AAPL	Stock	0.64	0.6425	0.6396	0.6414	3367224.0
2004-09-01 17:00:00	AAPL	Stock	0.6404	0.6443	0.6404	0.6432	1621760.0
2004-09-01 18:00:00	AAPL	Stock	0.6432	0.6443	0.6432	0.6443	128800.0
2004-09-01 08:00:00	MSFT	Stock	27.295	27.295	27.28	27.28	2444.0
2004-09-01 09:00:00	MSFT	Stock	27.28	27.28	27.179	27.25	3221105.0
2004-09-01 10:00:00	MSFT	Stock	27.25	27.52	27.24	27.4	9167482.0
2004-09-01 11:00:00	MSFT	Stock	27.39	27.5	27.38	27.43	6066471.0
2004-09-01 12:00:00	MSFT	Stock	27.42	27.48	27.38	27.42	4517738.0
2004-09-01 13:00:00	MSFT	Stock	27.42	27.43	27.14	27.35	10485693.0
2004-09-01 14:00:00	MSFT	Stock	27.36	27.38	27.26	27.31	5343764.0
2004-09-01 15:00:00	MSFT	Stock	27.32	27.4	27.24	27.38	7178535.0
2004-09-01 16:00:00	MSFT	Stock	27.38	27.4	27.35	27.39	475967.0
2004-09-01 17:00:00	MSFT	Stock	27.39	27.39	27.39	27.39	14995.0
2004-09-01 18:00:00	MSFT	Stock	27.4	27.4	27.4	27.4	2000.0
2004-09-01 08:00:00	NVDA	Stock	0.1029	0.1038	0.1027	0.1038	601200.0
2004-09-01 09:00:00	NVDA	Stock	0.1037	0.1055	0.1013	0.105	71322240.0
2004-09-01 10:00:00	NVDA	Stock	0.1049	0.1073	0.1044	0.1071	80605800.0
2004-09-01 11:00:00	NVDA	Stock	0.1071	0.1072	0.1051	0.1053	59766480.0
2004-09-01 12:00:00	NVDA	Stock	0.1054	0.1062	0.1052	0.1054	38189040.0
2004-09-01 13:00:00	NVDA	Stock	0.1054	0.1056	0.1027	0.1044	98058720.0
2004-09-01 14:00:00	NVDA	Stock	0.1045	0.106	0.1039	0.1057	59719920.0
2004-09-01 15:00:00	NVDA	Stock	0.1056	0.1065	0.1054	0.1058	135650760.0
2004-09-01 16:00:00	NVDA	Stock	0.1058	0.1065	0.1058	0.1065	8413440.0
2004-09-01 17:00:00	NVDA	Stock	0.1065	0.1065	0.1065	0.1065	311400.0
2004-09-01 08:00:00	AMZN	Stock	1.9052	1.9085	1.9052	1.9085	57400.0
2004-09-01 09:00:00	AMZN	Stock	1.9085	1.9185	1.9015	1.9102	10869100.0
2004-09-01 10:00:00	AMZN	Stock	1.9075	1.9505	1.901	1.9385	27266340.0
2004-09-01 11:00:00	AMZN	Stock	1.9395	1.9455	1.925	1.932	13958480.0
2004-09-01 12:00:00	AMZN	Stock	1.932	1.9345	1.92	1.9215	9128560.0
2004-09-01 13:00:00	AMZN	Stock	1.9215	1.9255	1.9055	1.9205	15108360.0
2004-09-01 14:00:00	AMZN	Stock	1.9195	1.924	1.91	1.9155	7100060.0
2004-09-01 15:00:00	AMZN	Stock	1.9155	1.92	1.91	1.912	16988500.0
2004-09-01 16:00:00	AMZN	Stock	1.912	1.9145	1.9075	1.912	411100.0
2004-09-01 17:00:00	AMZN	Stock	1.91	1.912	1.908	1.908	142000.0
2004-09-01 18:00:00	AMZN	Stock	1.907	1.9175	1.905	1.905	77540.0
2004-09-01 09:00:00	CL	Stock	26.955	27.1	26.955	27.015	154400.0
2004-09-01 10:00:00	CL	Stock	27.015	27.24	27.01	27.21	445400.0
2004-09-01 11:00:00	CL	Stock	27.21	27.275	27.175	27.19	251400.0
2004-09-01 12:00:00	CL	Stock	27.195	27.215	27.14	27.17	167000.0
2004-09-01 13:00:00	CL	Stock	27.175	27.2	26.885	27.195	217000.0
2004-09-01 14:00:00	CL	Stock	27.195	27.22	27.15	27.205	138000.0
2004-09-01 15:00:00	CL	Stock	27.205	27.205	27.12	27.185	521800.0

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

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