PREVIEW / stock_1hour / 2001-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-20.parquet
  size:    353 KB
  rows:    16,616
  symbols: 1,309

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
2001-07-20 08:00:00	AAPL	Stock	0.3571	0.3571	0.3482	0.3532	688800.0
2001-07-20 09:00:00	AAPL	Stock	0.3554	0.3563	0.348	0.3552	59606400.0
2001-07-20 10:00:00	AAPL	Stock	0.3554	0.3582	0.3507	0.3573	125899200.0
2001-07-20 11:00:00	AAPL	Stock	0.3571	0.358	0.3545	0.3554	54157600.0
2001-07-20 12:00:00	AAPL	Stock	0.355	0.3568	0.3541	0.3545	28028000.0
2001-07-20 13:00:00	AAPL	Stock	0.3545	0.3554	0.3536	0.3539	45348800.0
2001-07-20 14:00:00	AAPL	Stock	0.3539	0.3582	0.3536	0.357	43372000.0
2001-07-20 15:00:00	AAPL	Stock	0.357	0.3577	0.3543	0.3568	56498400.0
2001-07-20 16:00:00	AAPL	Stock	0.3568	0.3575	0.3489	0.357	16156000.0
2001-07-20 17:00:00	AAPL	Stock	0.3573	0.3573	0.3563	0.3563	61600.0
2001-07-20 18:00:00	AAPL	Stock	0.3563	0.3563	0.3563	0.3563	5600.0
2001-07-20 08:00:00	MSFT	Stock	34.44	34.8	34.175	34.425	3053200.0
2001-07-20 09:00:00	MSFT	Stock	34.4	35.35	32.02	34.09	36299200.0
2001-07-20 10:00:00	MSFT	Stock	34.09	34.345	33.95	34.24	29075200.0
2001-07-20 11:00:00	MSFT	Stock	34.24	34.7	34.16	34.455	13429800.0
2001-07-20 12:00:00	MSFT	Stock	34.5	34.56	34.39	34.47	6478600.0
2001-07-20 13:00:00	MSFT	Stock	34.47	34.475	34.25	34.405	4810800.0
2001-07-20 14:00:00	MSFT	Stock	34.405	34.5	34.285	34.415	6920600.0
2001-07-20 15:00:00	MSFT	Stock	34.415	34.625	34.325	34.6	14695800.0
2001-07-20 16:00:00	MSFT	Stock	34.6	34.7	34.005	34.665	2419600.0
2001-07-20 17:00:00	MSFT	Stock	34.655	34.655	34.47	34.625	87200.0
2001-07-20 18:00:00	MSFT	Stock	34.625	34.625	34.625	34.625	400.0
2001-07-20 08:00:00	NVDA	Stock	0.3125	0.3167	0.3125	0.3163	7224000.0
2001-07-20 09:00:00	NVDA	Stock	0.3167	0.3204	0.3125	0.3148	87096000.0
2001-07-20 10:00:00	NVDA	Stock	0.3147	0.3162	0.3083	0.3144	175344000.0
2001-07-20 11:00:00	NVDA	Stock	0.3144	0.3144	0.3073	0.308	100296000.0
2001-07-20 12:00:00	NVDA	Stock	0.308	0.3088	0.3031	0.304	99360000.0
2001-07-20 13:00:00	NVDA	Stock	0.3041	0.3075	0.3021	0.3048	68088000.0
2001-07-20 14:00:00	NVDA	Stock	0.305	0.3133	0.3047	0.3119	82824000.0
2001-07-20 15:00:00	NVDA	Stock	0.3121	0.313	0.3098	0.3125	77160000.0
2001-07-20 16:00:00	NVDA	Stock	0.312	0.3133	0.312	0.3124	10248000.0
2001-07-20 17:00:00	NVDA	Stock	0.3124	0.3124	0.3124	0.3124	96000.0
2001-07-20 18:00:00	NVDA	Stock	0.3125	0.3125	0.3125	0.3125	24000.0
2001-07-20 08:00:00	AMZN	Stock	0.827	0.83	0.8255	0.83	74000.0
2001-07-20 09:00:00	AMZN	Stock	0.83	0.8445	0.8225	0.841	11756000.0
2001-07-20 10:00:00	AMZN	Stock	0.841	0.8475	0.8325	0.8425	9850000.0
2001-07-20 11:00:00	AMZN	Stock	0.8425	0.843	0.835	0.838	6662000.0
2001-07-20 12:00:00	AMZN	Stock	0.838	0.842	0.833	0.8395	2976000.0
2001-07-20 13:00:00	AMZN	Stock	0.8395	0.85	0.8335	0.847	5806000.0
2001-07-20 14:00:00	AMZN	Stock	0.8455	0.8625	0.8425	0.86	17682000.0
2001-07-20 15:00:00	AMZN	Stock	0.86	0.862	0.846	0.85	13264000.0
2001-07-20 16:00:00	AMZN	Stock	0.849	0.858	0.8445	0.8445	2234000.0
2001-07-20 17:00:00	AMZN	Stock	0.8575	0.859	0.85	0.85	50000.0
2001-07-20 18:00:00	AMZN	Stock	0.85	0.85	0.85	0.85	4000.0
2001-07-20 09:00:00	CL	Stock	27.7	27.875	27.7	27.8	305800.0
2001-07-20 10:00:00	CL	Stock	27.805	27.92	27.75	27.855	241200.0
2001-07-20 11:00:00	CL	Stock	27.825	27.9	27.75	27.81	331400.0
2001-07-20 12:00:00	CL	Stock	27.81	27.85	27.725	27.825	335400.0
2001-07-20 13:00:00	CL	Stock	27.825	27.9	27.8	27.9	270200.0
2001-07-20 14:00:00	CL	Stock	27.9	27.97	27.8	27.81	353600.0

> showing 50 of 16,616 rows — these rows as CSV

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