PREVIEW / stock_1hour / 2004-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-16.parquet
  size:    503 KB
  rows:    23,648
  symbols: 1,820

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-16 08:00:00	AAPL	Stock	0.6293	0.6293	0.6293	0.6293	16800.0
2004-09-16 09:00:00	AAPL	Stock	0.6293	0.6402	0.6257	0.6391	49576800.0
2004-09-16 10:00:00	AAPL	Stock	0.6393	0.6564	0.6377	0.6477	129057712.0
2004-09-16 11:00:00	AAPL	Stock	0.6475	0.6518	0.6443	0.647	54505696.0
2004-09-16 12:00:00	AAPL	Stock	0.647	0.6536	0.6439	0.6486	46499376.0
2004-09-16 13:00:00	AAPL	Stock	0.6486	0.6518	0.6482	0.6507	27324920.0
2004-09-16 14:00:00	AAPL	Stock	0.6509	0.6518	0.6464	0.6468	40572448.0
2004-09-16 15:00:00	AAPL	Stock	0.6471	0.6509	0.6429	0.6482	83485416.0
2004-09-16 16:00:00	AAPL	Stock	0.6489	0.6509	0.6479	0.6509	34455792.0
2004-09-16 17:00:00	AAPL	Stock	0.6447	0.65	0.6447	0.65	89600.0
2004-09-16 18:00:00	AAPL	Stock	0.6491	0.6491	0.6491	0.6491	16800.0
2004-09-16 08:00:00	MSFT	Stock	27.1	27.31	27.1	27.22	22620.0
2004-09-16 09:00:00	MSFT	Stock	27.22	27.34	27.2	27.26	5309352.0
2004-09-16 10:00:00	MSFT	Stock	27.26	27.31	27.25	27.26	5817574.0
2004-09-16 11:00:00	MSFT	Stock	27.26	27.27	27.21	27.22	4461805.0
2004-09-16 12:00:00	MSFT	Stock	27.23	27.27	27.17	27.26	4116824.0
2004-09-16 13:00:00	MSFT	Stock	27.26	27.27	27.24	27.24	3411667.0
2004-09-16 14:00:00	MSFT	Stock	27.24	27.28	27.23	27.24	3759705.0
2004-09-16 15:00:00	MSFT	Stock	27.25	27.28	27.2	27.25	7514819.0
2004-09-16 16:00:00	MSFT	Stock	27.25	27.29	27.25	27.27	587369.0
2004-09-16 17:00:00	MSFT	Stock	27.27	27.27	27.26	27.27	16520.0
2004-09-16 18:00:00	MSFT	Stock	27.27	27.27	27.27	27.27	2200.0
2004-09-16 08:00:00	NVDA	Stock	0.1137	0.1137	0.1137	0.1137	111000.0
2004-09-16 09:00:00	NVDA	Stock	0.1137	0.1162	0.1137	0.1157	79828440.0
2004-09-16 10:00:00	NVDA	Stock	0.1157	0.1162	0.115	0.1156	94395000.0
2004-09-16 11:00:00	NVDA	Stock	0.1157	0.1157	0.1148	0.1157	85053720.0
2004-09-16 12:00:00	NVDA	Stock	0.1157	0.1158	0.1148	0.1149	45408360.0
2004-09-16 13:00:00	NVDA	Stock	0.1149	0.1162	0.1148	0.116	67029000.0
2004-09-16 14:00:00	NVDA	Stock	0.116	0.1181	0.1159	0.1173	162811560.0
2004-09-16 15:00:00	NVDA	Stock	0.1173	0.1187	0.117	0.1176	243485640.0
2004-09-16 16:00:00	NVDA	Stock	0.1176	0.1177	0.1175	0.1177	6389640.0
2004-09-16 17:00:00	NVDA	Stock	0.1177	0.1177	0.1175	0.1177	1340400.0
2004-09-16 18:00:00	NVDA	Stock	0.1178	0.1178	0.1178	0.1178	24000.0
2004-09-16 09:00:00	AMZN	Stock	2.116	2.1575	2.115	2.1555	19490060.0
2004-09-16 10:00:00	AMZN	Stock	2.1555	2.214	2.155	2.1955	71609740.0
2004-09-16 11:00:00	AMZN	Stock	2.1955	2.203	2.186	2.1935	23183400.0
2004-09-16 12:00:00	AMZN	Stock	2.1925	2.195	2.182	2.185	16869740.0
2004-09-16 13:00:00	AMZN	Stock	2.185	2.1885	2.1705	2.175	12453760.0
2004-09-16 14:00:00	AMZN	Stock	2.175	2.175	2.131	2.133	34034440.0
2004-09-16 15:00:00	AMZN	Stock	2.1325	2.139	2.12	2.1285	41462440.0
2004-09-16 16:00:00	AMZN	Stock	2.128	2.1335	2.128	2.1285	943480.0
2004-09-16 17:00:00	AMZN	Stock	2.1325	2.1375	2.1325	2.135	80000.0
2004-09-16 18:00:00	AMZN	Stock	2.1325	2.1325	2.13	2.1315	68600.0
2004-09-16 09:00:00	CL	Stock	27.17	27.275	27.105	27.11	159400.0
2004-09-16 10:00:00	CL	Stock	27.105	27.11	27.06	27.075	168200.0
2004-09-16 11:00:00	CL	Stock	27.075	27.105	27.04	27.065	172000.0
2004-09-16 12:00:00	CL	Stock	27.065	27.15	27.04	27.14	177200.0
2004-09-16 13:00:00	CL	Stock	27.14	27.165	27.13	27.16	150400.0
2004-09-16 14:00:00	CL	Stock	27.15	27.165	27.125	27.135	152800.0
2004-09-16 15:00:00	CL	Stock	27.13	27.17	27.12	27.165	510200.0

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

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