PREVIEW / stock_1hour / 2004-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-10-01.parquet
  size:    534 KB
  rows:    25,867
  symbols: 1,840

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-10-01 08:00:00	AAPL	Stock	0.6925	0.7009	0.6925	0.7	375200.0
2004-10-01 09:00:00	AAPL	Stock	0.6991	0.7007	0.6889	0.6896	51014152.0
2004-10-01 10:00:00	AAPL	Stock	0.69	0.6959	0.6895	0.6941	62407632.0
2004-10-01 11:00:00	AAPL	Stock	0.6941	0.6964	0.6911	0.6932	47416432.0
2004-10-01 12:00:00	AAPL	Stock	0.6932	0.6979	0.692	0.6971	39841928.0
2004-10-01 13:00:00	AAPL	Stock	0.6971	0.6982	0.6955	0.6966	46016600.0
2004-10-01 14:00:00	AAPL	Stock	0.6968	0.6988	0.6952	0.6957	63291872.0
2004-10-01 15:00:00	AAPL	Stock	0.6957	0.6961	0.69	0.6905	85862280.0
2004-10-01 16:00:00	AAPL	Stock	0.6905	0.6964	0.6548	0.6964	47033728.0
2004-10-01 17:00:00	AAPL	Stock	0.6905	0.6905	0.69	0.69	253568.0
2004-10-01 18:00:00	AAPL	Stock	0.69	0.6905	0.69	0.6905	141176.0
2004-10-01 08:00:00	MSFT	Stock	27.7	27.79	27.65	27.76	26700.0
2004-10-01 09:00:00	MSFT	Stock	27.76	27.99	27.65	27.97	8139895.0
2004-10-01 10:00:00	MSFT	Stock	27.98	28.14	27.97	28.09	17914626.0
2004-10-01 11:00:00	MSFT	Stock	28.09	28.18	28.06	28.13	7887984.0
2004-10-01 12:00:00	MSFT	Stock	28.13	28.16	28.07	28.09	4330632.0
2004-10-01 13:00:00	MSFT	Stock	28.09	28.21	28.05	28.14	4679630.0
2004-10-01 14:00:00	MSFT	Stock	28.14	28.3	28.11	28.26	8172750.0
2004-10-01 15:00:00	MSFT	Stock	28.26	28.3	28.15	28.26	11998896.0
2004-10-01 16:00:00	MSFT	Stock	28.26	28.31	28.09	28.25	1318463.0
2004-10-01 17:00:00	MSFT	Stock	28.28	28.28	28.25	28.25	60093.0
2004-10-01 18:00:00	MSFT	Stock	28.25	28.25	28.25	28.25	31456.0
2004-10-01 08:00:00	NVDA	Stock	0.1207	0.1232	0.1207	0.1232	5509320.0
2004-10-01 09:00:00	NVDA	Stock	0.1232	0.1237	0.121	0.1233	65694960.0
2004-10-01 10:00:00	NVDA	Stock	0.1232	0.1244	0.1227	0.124	97893240.0
2004-10-01 11:00:00	NVDA	Stock	0.124	0.1255	0.1239	0.1246	104978160.0
2004-10-01 12:00:00	NVDA	Stock	0.1247	0.1253	0.1243	0.125	55166760.0
2004-10-01 13:00:00	NVDA	Stock	0.1251	0.1252	0.1245	0.1248	36164760.0
2004-10-01 14:00:00	NVDA	Stock	0.1247	0.1254	0.1243	0.1251	78202080.0
2004-10-01 15:00:00	NVDA	Stock	0.1252	0.1267	0.125	0.1262	132525000.0
2004-10-01 16:00:00	NVDA	Stock	0.1262	0.1265	0.1253	0.126	3509040.0
2004-10-01 17:00:00	NVDA	Stock	0.1263	0.1263	0.1263	0.1263	72000.0
2004-10-01 18:00:00	NVDA	Stock	0.126	0.126	0.126	0.126	52080.0
2004-10-01 08:00:00	AMZN	Stock	2.035	2.064	2.035	2.0375	7621700.0
2004-10-01 09:00:00	AMZN	Stock	2.0625	2.065	2.023	2.0335	30885140.0
2004-10-01 10:00:00	AMZN	Stock	2.033	2.0505	2.022	2.0465	46055100.0
2004-10-01 11:00:00	AMZN	Stock	2.047	2.06	2.0435	2.0565	23655240.0
2004-10-01 12:00:00	AMZN	Stock	2.057	2.0585	2.04	2.049	18157720.0
2004-10-01 13:00:00	AMZN	Stock	2.049	2.05	2.0255	2.0345	27146620.0
2004-10-01 14:00:00	AMZN	Stock	2.034	2.043	2.0285	2.036	20902640.0
2004-10-01 15:00:00	AMZN	Stock	2.036	2.039	2.0195	2.0215	41719000.0
2004-10-01 16:00:00	AMZN	Stock	2.022	2.0245	2.008	2.023	1697220.0
2004-10-01 17:00:00	AMZN	Stock	2.0235	2.0235	2.023	2.0235	70000.0
2004-10-01 18:00:00	AMZN	Stock	2.0235	2.0235	2.02	2.02	108800.0
2004-10-01 09:00:00	CL	Stock	22.6	22.715	22.595	22.675	688400.0
2004-10-01 10:00:00	CL	Stock	22.655	22.875	22.655	22.79	1605200.0
2004-10-01 11:00:00	CL	Stock	22.79	22.815	22.695	22.725	1025600.0
2004-10-01 12:00:00	CL	Stock	22.725	22.775	22.67	22.77	957400.0
2004-10-01 13:00:00	CL	Stock	22.77	22.82	22.75	22.8	903600.0
2004-10-01 14:00:00	CL	Stock	22.8	22.8435	22.75	22.825	1252800.0

> showing 50 of 25,867 rows — these rows as CSV

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