PREVIEW / stock_1hour / 2000-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-03-28.parquet
  size:    282 KB
  rows:    14,695
  symbols: 1,142

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
2000-03-28 09:00:00	AAPL	Stock	1.2254	1.2679	1.2243	1.2679	32043200.0
2000-03-28 10:00:00	AAPL	Stock	1.2667	1.2667	1.2366	1.2522	49694400.0
2000-03-28 11:00:00	AAPL	Stock	1.2533	1.2533	1.2366	1.2455	20865600.0
2000-03-28 12:00:00	AAPL	Stock	1.2455	1.2489	1.2366	1.2405	9374400.0
2000-03-28 13:00:00	AAPL	Stock	1.2405	1.2589	1.2388	1.2533	16766400.0
2000-03-28 14:00:00	AAPL	Stock	1.2533	1.2656	1.2472	1.2656	23273600.0
2000-03-28 15:00:00	AAPL	Stock	1.2662	1.2662	1.2411	1.2425	35291200.0
2000-03-28 16:00:00	AAPL	Stock	1.2425	1.2427	1.2422	1.2422	2632000.0
2000-03-28 09:00:00	MSFT	Stock	51.8125	52.3594	51.1875	51.9062	12735200.0
2000-03-28 10:00:00	MSFT	Stock	51.9375	53.625	51.5625	53.5	24884800.0
2000-03-28 11:00:00	MSFT	Stock	53.5	53.7188	53.0	53.1875	13743600.0
2000-03-28 12:00:00	MSFT	Stock	53.125	53.375	52.6562	52.8438	5735600.0
2000-03-28 13:00:00	MSFT	Stock	52.8125	53.2812	52.75	53.125	4885000.0
2000-03-28 14:00:00	MSFT	Stock	53.1562	53.25	52.6875	52.75	5612400.0
2000-03-28 15:00:00	MSFT	Stock	52.75	53.125	52.125	52.1562	8771200.0
2000-03-28 16:00:00	MSFT	Stock	52.2031	52.2344	52.1562	52.1562	434200.0
2000-03-28 09:00:00	NVDA	Stock	0.1751	0.1771	0.1677	0.175	72192000.0
2000-03-28 10:00:00	NVDA	Stock	0.175	0.175	0.1667	0.1732	71328000.0
2000-03-28 11:00:00	NVDA	Stock	0.171	0.1732	0.1708	0.1717	43680000.0
2000-03-28 12:00:00	NVDA	Stock	0.1717	0.1724	0.1656	0.1682	50928000.0
2000-03-28 13:00:00	NVDA	Stock	0.1698	0.1698	0.1646	0.1693	47568000.0
2000-03-28 14:00:00	NVDA	Stock	0.1693	0.1699	0.1669	0.1681	34800000.0
2000-03-28 15:00:00	NVDA	Stock	0.1682	0.1708	0.1667	0.1681	43632000.0
2000-03-28 16:00:00	NVDA	Stock	0.1678	0.1678	0.1678	0.1678	240000.0
2000-03-28 09:00:00	AMZN	Stock	3.6188	3.6375	3.5844	3.5844	9800000.0
2000-03-28 10:00:00	AMZN	Stock	3.5844	3.5938	3.525	3.5469	24422000.0
2000-03-28 11:00:00	AMZN	Stock	3.5469	3.5562	3.4734	3.525	34554000.0
2000-03-28 12:00:00	AMZN	Stock	3.5281	3.5406	3.4938	3.5094	11702000.0
2000-03-28 13:00:00	AMZN	Stock	3.5125	3.55	3.5062	3.5312	4772000.0
2000-03-28 14:00:00	AMZN	Stock	3.5281	3.5375	3.4938	3.5	4374000.0
2000-03-28 15:00:00	AMZN	Stock	3.5031	3.525	3.4875	3.5062	9882000.0
2000-03-28 16:00:00	AMZN	Stock	3.5062	3.5094	3.5062	3.5062	508000.0
2000-03-28 09:00:00	CL	Stock	26.6875	27.3125	26.6875	27.3125	410600.0
2000-03-28 10:00:00	CL	Stock	27.3125	28.1562	27.25	28.1562	765200.0
2000-03-28 11:00:00	CL	Stock	28.125	28.25	27.9375	27.9375	453800.0
2000-03-28 12:00:00	CL	Stock	27.9375	27.9688	27.7812	27.9062	465600.0
2000-03-28 13:00:00	CL	Stock	27.8438	27.9062	27.7188	27.7812	234400.0
2000-03-28 14:00:00	CL	Stock	27.8125	28.375	27.7812	28.3125	1014200.0
2000-03-28 15:00:00	CL	Stock	28.3438	28.375	27.9688	28.3438	701800.0
2000-03-28 16:00:00	CL	Stock	28.3125	28.4375	28.3125	28.4375	231000.0

> showing 40 of 14,695 rows — these rows as CSV

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