PREVIEW / stock_1hour / 2004-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-06.parquet
  size:    527 KB
  rows:    24,567
  symbols: 1,795

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-06 08:00:00	AAPL	Stock	0.5532	0.5534	0.5509	0.5529	200200.0
2004-07-06 09:00:00	AAPL	Stock	0.552	0.5588	0.5509	0.557	45551296.0
2004-07-06 10:00:00	AAPL	Stock	0.5571	0.5611	0.5554	0.5564	64667960.0
2004-07-06 11:00:00	AAPL	Stock	0.5564	0.5589	0.5536	0.5561	51968784.0
2004-07-06 12:00:00	AAPL	Stock	0.5561	0.5566	0.5545	0.5563	23170448.0
2004-07-06 13:00:00	AAPL	Stock	0.5561	0.5564	0.5534	0.5536	18352208.0
2004-07-06 14:00:00	AAPL	Stock	0.5536	0.5538	0.55	0.5523	35282800.0
2004-07-06 15:00:00	AAPL	Stock	0.5523	0.5575	0.5518	0.5529	78217440.0
2004-07-06 16:00:00	AAPL	Stock	0.5538	0.5554	0.5521	0.5528	8604064.0
2004-07-06 17:00:00	AAPL	Stock	0.5527	0.557	0.5527	0.5527	1349992.0
2004-07-06 08:00:00	MSFT	Stock	28.5	28.5	28.25	28.33	130505.0
2004-07-06 09:00:00	MSFT	Stock	28.3	28.39	28.13	28.18	8538376.0
2004-07-06 10:00:00	MSFT	Stock	28.18	28.31	28.1	28.27	9576535.0
2004-07-06 11:00:00	MSFT	Stock	28.27	28.28	28.04	28.08	11019259.0
2004-07-06 12:00:00	MSFT	Stock	28.08	28.19	28.02	28.1	8548867.0
2004-07-06 13:00:00	MSFT	Stock	28.1	28.15	28.04	28.06	3646148.0
2004-07-06 14:00:00	MSFT	Stock	28.05	28.07	27.94	28.02	9147526.0
2004-07-06 15:00:00	MSFT	Stock	28.03	28.15	28.01	28.05	13392885.0
2004-07-06 16:00:00	MSFT	Stock	28.05	28.13	27.95	28.01	1651446.0
2004-07-06 17:00:00	MSFT	Stock	28.01	28.03	28.0	28.0	568437.0
2004-07-06 18:00:00	MSFT	Stock	28.01	28.02	28.01	28.02	3400.0
2004-07-06 09:00:00	NVDA	Stock	0.161	0.161	0.1557	0.1567	82351080.0
2004-07-06 10:00:00	NVDA	Stock	0.1567	0.1567	0.1528	0.1529	91116360.0
2004-07-06 11:00:00	NVDA	Stock	0.1529	0.153	0.1504	0.1511	93845760.0
2004-07-06 12:00:00	NVDA	Stock	0.1509	0.1519	0.1507	0.1508	49960920.0
2004-07-06 13:00:00	NVDA	Stock	0.1508	0.151	0.1501	0.1502	28467240.0
2004-07-06 14:00:00	NVDA	Stock	0.1502	0.1506	0.1493	0.1501	49465800.0
2004-07-06 15:00:00	NVDA	Stock	0.1502	0.1522	0.15	0.151	131205720.0
2004-07-06 16:00:00	NVDA	Stock	0.1511	0.1522	0.1509	0.151	15977760.0
2004-07-06 17:00:00	NVDA	Stock	0.151	0.151	0.151	0.151	1124400.0
2004-07-06 08:00:00	AMZN	Stock	2.61	2.613	2.61	2.61	20000.0
2004-07-06 09:00:00	AMZN	Stock	2.6035	2.6304	2.5655	2.5775	17931120.0
2004-07-06 10:00:00	AMZN	Stock	2.5775	2.5775	2.553	2.5545	22450480.0
2004-07-06 11:00:00	AMZN	Stock	2.5545	2.5565	2.528	2.528	18207540.0
2004-07-06 12:00:00	AMZN	Stock	2.5285	2.537	2.5245	2.5345	13310500.0
2004-07-06 13:00:00	AMZN	Stock	2.5355	2.5415	2.531	2.532	6370640.0
2004-07-06 14:00:00	AMZN	Stock	2.531	2.551	2.527	2.5475	11490940.0
2004-07-06 15:00:00	AMZN	Stock	2.5475	2.5785	2.5475	2.5635	25195840.0
2004-07-06 16:00:00	AMZN	Stock	2.563	2.5745	2.5573	2.5625	2709560.0
2004-07-06 17:00:00	AMZN	Stock	2.562	2.574	2.562	2.5725	79980.0
2004-07-06 18:00:00	AMZN	Stock	2.5745	2.5745	2.5745	2.5745	6660.0
2004-07-06 09:00:00	CL	Stock	29.085	29.085	29.025	29.025	178200.0
2004-07-06 10:00:00	CL	Stock	29.025	29.04	28.93	28.945	314000.0
2004-07-06 11:00:00	CL	Stock	28.945	29.0	28.925	28.98	407200.0
2004-07-06 12:00:00	CL	Stock	28.99	29.005	28.95	28.985	391200.0
2004-07-06 13:00:00	CL	Stock	28.985	29.01	28.955	29.0	248200.0
2004-07-06 14:00:00	CL	Stock	29.0	29.175	28.97	29.15	347600.0
2004-07-06 15:00:00	CL	Stock	29.15	29.2	29.125	29.15	605000.0
2004-07-06 16:00:00	CL	Stock	29.15	29.15	29.145	29.145	73400.0
2004-07-06 17:00:00	CL	Stock	29.145	29.145	29.145	29.145	50400.0

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

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