PREVIEW / stock_1hour / 2002-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-07.parquet
  size:    400 KB
  rows:    18,587
  symbols: 1,357

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
2002-01-07 08:00:00	AAPL	Stock	0.4236	0.4254	0.4198	0.4232	1237600.0
2002-01-07 09:00:00	AAPL	Stock	0.4232	0.4286	0.417	0.4177	70156800.0
2002-01-07 10:00:00	AAPL	Stock	0.4175	0.4241	0.4157	0.4188	76636000.0
2002-01-07 11:00:00	AAPL	Stock	0.4188	0.4193	0.41	0.4111	68499200.0
2002-01-07 12:00:00	AAPL	Stock	0.4111	0.415	0.4063	0.4139	36568000.0
2002-01-07 13:00:00	AAPL	Stock	0.4138	0.4164	0.4116	0.4134	28011200.0
2002-01-07 14:00:00	AAPL	Stock	0.4127	0.4189	0.4111	0.4163	64775200.0
2002-01-07 15:00:00	AAPL	Stock	0.4157	0.417	0.4077	0.4091	79850400.0
2002-01-07 16:00:00	AAPL	Stock	0.4095	0.4147	0.408	0.4089	6742400.0
2002-01-07 17:00:00	AAPL	Stock	0.4116	0.4116	0.4089	0.4107	84000.0
2002-01-07 18:00:00	AAPL	Stock	0.4107	0.4123	0.4089	0.4107	72800.0
2002-01-07 08:00:00	MSFT	Stock	35.0	35.15	34.4525	35.025	435000.0
2002-01-07 09:00:00	MSFT	Stock	35.025	35.045	34.55	34.93	11594200.0
2002-01-07 10:00:00	MSFT	Stock	34.93	34.975	34.7345	34.835	10863000.0
2002-01-07 11:00:00	MSFT	Stock	34.835	34.95	34.55	34.6	7278000.0
2002-01-07 12:00:00	MSFT	Stock	34.61	34.785	34.595	34.61	5103200.0
2002-01-07 13:00:00	MSFT	Stock	34.61	34.81	34.54	34.685	4655000.0
2002-01-07 14:00:00	MSFT	Stock	34.685	34.8105	34.36	34.515	6570800.0
2002-01-07 15:00:00	MSFT	Stock	34.5	34.575	34.175	34.28	8568400.0
2002-01-07 16:00:00	MSFT	Stock	34.275	34.905	34.225	34.28	1862000.0
2002-01-07 17:00:00	MSFT	Stock	34.32	34.375	34.28	34.35	70200.0
2002-01-07 18:00:00	MSFT	Stock	34.37	34.37	34.26	34.3	9600.0
2002-01-07 08:00:00	NVDA	Stock	0.5792	0.5858	0.5792	0.5858	492000.0
2002-01-07 09:00:00	NVDA	Stock	0.5837	0.5876	0.5647	0.5654	170460000.0
2002-01-07 10:00:00	NVDA	Stock	0.5656	0.5737	0.5613	0.5632	218568000.0
2002-01-07 11:00:00	NVDA	Stock	0.5632	0.5645	0.5567	0.5593	170856000.0
2002-01-07 12:00:00	NVDA	Stock	0.5594	0.5662	0.5594	0.5643	58824000.0
2002-01-07 13:00:00	NVDA	Stock	0.5643	0.5688	0.5592	0.5671	79800000.0
2002-01-07 14:00:00	NVDA	Stock	0.5668	0.5723	0.5588	0.5628	114696000.0
2002-01-07 15:00:00	NVDA	Stock	0.5628	0.5663	0.5595	0.5644	121728000.0
2002-01-07 16:00:00	NVDA	Stock	0.5644	0.5704	0.5629	0.565	21096000.0
2002-01-07 17:00:00	NVDA	Stock	0.5653	0.5658	0.565	0.565	192000.0
2002-01-07 18:00:00	NVDA	Stock	0.565	0.5654	0.565	0.5654	84000.0
2002-01-07 08:00:00	AMZN	Stock	0.61	0.6175	0.61	0.611	298000.0
2002-01-07 09:00:00	AMZN	Stock	0.6125	0.625	0.604	0.6105	34998000.0
2002-01-07 10:00:00	AMZN	Stock	0.6115	0.6175	0.606	0.609	32898000.0
2002-01-07 11:00:00	AMZN	Stock	0.6085	0.6165	0.6075	0.613	30612000.0
2002-01-07 12:00:00	AMZN	Stock	0.613	0.6175	0.6105	0.614	32868000.0
2002-01-07 13:00:00	AMZN	Stock	0.614	0.615	0.6105	0.614	13574000.0
2002-01-07 14:00:00	AMZN	Stock	0.614	0.6175	0.61	0.6115	21172000.0
2002-01-07 15:00:00	AMZN	Stock	0.612	0.6215	0.611	0.6175	52398000.0
2002-01-07 16:00:00	AMZN	Stock	0.6176	0.6198	0.614	0.615	15076000.0
2002-01-07 17:00:00	AMZN	Stock	0.619	0.6245	0.617	0.6195	302000.0
2002-01-07 09:00:00	CL	Stock	27.875	28.025	27.775	27.82	358200.0
2002-01-07 10:00:00	CL	Stock	27.81	27.975	27.725	27.955	801000.0
2002-01-07 11:00:00	CL	Stock	27.925	27.94	27.775	27.87	299600.0
2002-01-07 12:00:00	CL	Stock	27.87	27.89	27.735	27.81	525400.0
2002-01-07 13:00:00	CL	Stock	27.805	27.91	27.725	27.765	340800.0
2002-01-07 14:00:00	CL	Stock	27.755	27.84	27.7	27.735	435600.0
2002-01-07 15:00:00	CL	Stock	27.73	27.885	27.7	27.85	728000.0

> showing 50 of 18,587 rows — these rows as CSV

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