PREVIEW / stock_1hour / 2004-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-23.parquet
  size:    484 KB
  rows:    23,392
  symbols: 1,823

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-08-23 09:00:00	AAPL	Stock	0.5509	0.5518	0.5464	0.5496	26020848.0
2004-08-23 10:00:00	AAPL	Stock	0.5493	0.5584	0.5488	0.5561	40926200.0
2004-08-23 11:00:00	AAPL	Stock	0.5559	0.5564	0.552	0.5521	33794152.0
2004-08-23 12:00:00	AAPL	Stock	0.5521	0.5536	0.5491	0.5509	24153024.0
2004-08-23 13:00:00	AAPL	Stock	0.5509	0.5545	0.5505	0.5541	33517008.0
2004-08-23 14:00:00	AAPL	Stock	0.5543	0.5555	0.5509	0.5511	30442776.0
2004-08-23 15:00:00	AAPL	Stock	0.5511	0.5554	0.5488	0.555	50113056.0
2004-08-23 16:00:00	AAPL	Stock	0.555	0.5555	0.5541	0.555	5081328.0
2004-08-23 08:00:00	MSFT	Stock	27.25	27.3	27.115	27.19	163303.0
2004-08-23 09:00:00	MSFT	Stock	27.22	28.0	27.13	27.18	3839170.0
2004-08-23 10:00:00	MSFT	Stock	27.17	27.27	27.16	27.24	5199991.0
2004-08-23 11:00:00	MSFT	Stock	27.24	27.33	27.19	27.29	5393194.0
2004-08-23 12:00:00	MSFT	Stock	27.3	27.32	27.2	27.2	3568536.0
2004-08-23 13:00:00	MSFT	Stock	27.2	27.28	27.17	27.24	6938583.0
2004-08-23 14:00:00	MSFT	Stock	27.24	27.3	27.21	27.23	5455859.0
2004-08-23 15:00:00	MSFT	Stock	27.24	27.26	27.12	27.25	7129624.0
2004-08-23 16:00:00	MSFT	Stock	27.24	27.3	27.24	27.26	495752.0
2004-08-23 17:00:00	MSFT	Stock	27.25	27.28	27.25	27.28	2701.0
2004-08-23 18:00:00	MSFT	Stock	27.25	27.25	27.25	27.25	100.0
2004-08-23 08:00:00	NVDA	Stock	0.1025	0.1046	0.0983	0.1046	954000.0
2004-08-23 09:00:00	NVDA	Stock	0.1048	0.106	0.104	0.1041	167733480.0
2004-08-23 10:00:00	NVDA	Stock	0.1041	0.1062	0.104	0.1058	159553560.0
2004-08-23 11:00:00	NVDA	Stock	0.1058	0.1061	0.1052	0.1056	98975400.0
2004-08-23 12:00:00	NVDA	Stock	0.1056	0.1059	0.1054	0.1056	57767760.0
2004-08-23 13:00:00	NVDA	Stock	0.1055	0.1058	0.1047	0.1057	65306640.0
2004-08-23 14:00:00	NVDA	Stock	0.1056	0.1057	0.1052	0.1053	62693280.0
2004-08-23 15:00:00	NVDA	Stock	0.1053	0.1057	0.1047	0.105	154547760.0
2004-08-23 16:00:00	NVDA	Stock	0.105	0.1055	0.1048	0.1052	4938360.0
2004-08-23 17:00:00	NVDA	Stock	0.1052	0.1052	0.1052	0.1052	66000.0
2004-08-23 18:00:00	NVDA	Stock	0.1047	0.1047	0.1047	0.1047	84000.0
2004-08-23 08:00:00	AMZN	Stock	1.9825	1.9875	1.9825	1.9875	109000.0
2004-08-23 09:00:00	AMZN	Stock	1.9875	2.0	1.971	1.973	22884680.0
2004-08-23 10:00:00	AMZN	Stock	1.9725	1.984	1.9625	1.9675	22537920.0
2004-08-23 11:00:00	AMZN	Stock	1.967	1.9755	1.9625	1.967	11386020.0
2004-08-23 12:00:00	AMZN	Stock	1.9665	1.969	1.9555	1.9625	10015600.0
2004-08-23 13:00:00	AMZN	Stock	1.963	1.967	1.9585	1.964	7611580.0
2004-08-23 14:00:00	AMZN	Stock	1.9645	1.979	1.964	1.977	12500240.0
2004-08-23 15:00:00	AMZN	Stock	1.9775	1.9775	1.9635	1.9725	20858200.0
2004-08-23 16:00:00	AMZN	Stock	1.9715	1.9745	1.9705	1.9705	882600.0
2004-08-23 17:00:00	AMZN	Stock	1.97	1.97	1.9685	1.97	42000.0
2004-08-23 18:00:00	AMZN	Stock	1.97	1.97	1.97	1.97	43980.0
2004-08-23 09:00:00	CL	Stock	26.455	26.49	26.325	26.415	292200.0
2004-08-23 10:00:00	CL	Stock	26.415	26.605	26.4	26.56	560200.0
2004-08-23 11:00:00	CL	Stock	26.57	26.625	26.555	26.61	399600.0
2004-08-23 12:00:00	CL	Stock	26.615	26.67	26.615	26.64	267000.0
2004-08-23 13:00:00	CL	Stock	26.64	26.765	26.635	26.765	635800.0
2004-08-23 14:00:00	CL	Stock	26.765	26.775	26.655	26.71	475000.0
2004-08-23 15:00:00	CL	Stock	26.715	26.745	26.635	26.67	1361800.0
2004-08-23 17:00:00	CL	Stock	26.67	26.67	26.67	26.67	600.0

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

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