PREVIEW / stock_1hour / 2004-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-28.parquet
  size:    503 KB
  rows:    23,774
  symbols: 1,807

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-07-28 08:00:00	AAPL	Stock	0.5791	0.5791	0.5777	0.5784	45472.0
2004-07-28 09:00:00	AAPL	Stock	0.5777	0.5784	0.5709	0.5745	24949288.0
2004-07-28 10:00:00	AAPL	Stock	0.5745	0.5759	0.563	0.5663	42231056.0
2004-07-28 11:00:00	AAPL	Stock	0.5663	0.5725	0.5604	0.5627	40627552.0
2004-07-28 12:00:00	AAPL	Stock	0.5629	0.565	0.5564	0.5607	35378560.0
2004-07-28 13:00:00	AAPL	Stock	0.5607	0.5666	0.5604	0.5657	24892224.0
2004-07-28 14:00:00	AAPL	Stock	0.5657	0.5732	0.5655	0.5714	38176880.0
2004-07-28 15:00:00	AAPL	Stock	0.5716	0.5788	0.5693	0.5763	61950840.0
2004-07-28 16:00:00	AAPL	Stock	0.5763	0.5763	0.5752	0.5763	1429904.0
2004-07-28 08:00:00	MSFT	Stock	28.42	28.44	28.4	28.43	45653.0
2004-07-28 09:00:00	MSFT	Stock	28.41	28.54	28.32	28.5	4979934.0
2004-07-28 10:00:00	MSFT	Stock	28.5	28.5	28.28	28.37	9557842.0
2004-07-28 11:00:00	MSFT	Stock	28.37	28.52	28.35	28.42	8185659.0
2004-07-28 12:00:00	MSFT	Stock	28.41	28.42	28.32	28.34	6778060.0
2004-07-28 13:00:00	MSFT	Stock	28.33	28.43	28.32	28.35	6457713.0
2004-07-28 14:00:00	MSFT	Stock	28.35	28.451	28.3199	28.421	6556403.0
2004-07-28 15:00:00	MSFT	Stock	28.429	28.79	28.4	28.6	17170857.0
2004-07-28 16:00:00	MSFT	Stock	28.59	28.65	28.45	28.528	949206.0
2004-07-28 17:00:00	MSFT	Stock	28.6	28.62	28.58	28.58	11466.0
2004-07-28 18:00:00	MSFT	Stock	28.58	28.59	28.58	28.58	2200.0
2004-07-28 08:00:00	NVDA	Stock	0.1219	0.1219	0.1217	0.1217	94320.0
2004-07-28 09:00:00	NVDA	Stock	0.1217	0.1225	0.1199	0.1207	36143040.0
2004-07-28 10:00:00	NVDA	Stock	0.1206	0.1211	0.1158	0.1165	141838320.0
2004-07-28 11:00:00	NVDA	Stock	0.1166	0.1172	0.1161	0.1164	90731760.0
2004-07-28 12:00:00	NVDA	Stock	0.1163	0.1169	0.1158	0.1165	50938440.0
2004-07-28 13:00:00	NVDA	Stock	0.1166	0.1179	0.1166	0.1167	32424000.0
2004-07-28 14:00:00	NVDA	Stock	0.1167	0.1185	0.1165	0.1182	37017360.0
2004-07-28 15:00:00	NVDA	Stock	0.1182	0.1204	0.118	0.1192	95758080.0
2004-07-28 16:00:00	NVDA	Stock	0.1192	0.1193	0.1189	0.1193	2716800.0
2004-07-28 17:00:00	NVDA	Stock	0.1195	0.1196	0.1195	0.1196	120000.0
2004-07-28 08:00:00	AMZN	Stock	1.9555	1.958	1.9555	1.958	5200.0
2004-07-28 09:00:00	AMZN	Stock	1.9555	1.9785	1.946	1.969	23942940.0
2004-07-28 10:00:00	AMZN	Stock	1.969	1.9745	1.9065	1.9125	45524160.0
2004-07-28 11:00:00	AMZN	Stock	1.9125	1.9175	1.8875	1.8985	26061220.0
2004-07-28 12:00:00	AMZN	Stock	1.8985	1.8985	1.885	1.898	16066980.0
2004-07-28 13:00:00	AMZN	Stock	1.898	1.9035	1.8775	1.8785	16006520.0
2004-07-28 14:00:00	AMZN	Stock	1.8785	1.9015	1.869	1.901	23448680.0
2004-07-28 15:00:00	AMZN	Stock	1.901	1.9134	1.893	1.895	40665080.0
2004-07-28 16:00:00	AMZN	Stock	1.896	1.918	1.89	1.8965	1533460.0
2004-07-28 17:00:00	AMZN	Stock	1.894	1.8985	1.891	1.894	134820.0
2004-07-28 18:00:00	AMZN	Stock	1.8925	1.8925	1.89	1.8925	48520.0
2004-07-28 09:00:00	CL	Stock	26.42	26.585	26.325	26.355	244400.0
2004-07-28 10:00:00	CL	Stock	26.355	26.43	26.28	26.285	832600.0
2004-07-28 11:00:00	CL	Stock	26.285	26.315	26.245	26.305	987600.0
2004-07-28 12:00:00	CL	Stock	26.305	26.36	26.295	26.31	156800.0
2004-07-28 13:00:00	CL	Stock	26.3	26.335	26.265	26.275	413400.0
2004-07-28 14:00:00	CL	Stock	26.275	26.545	26.275	26.535	673200.0
2004-07-28 15:00:00	CL	Stock	26.535	26.8	26.53	26.725	1403200.0
2004-07-28 16:00:00	CL	Stock	26.73	26.73	26.7255	26.7255	145400.0

> showing 49 of 23,774 rows — these rows as CSV

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