PREVIEW / stock_1hour / 2002-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-20.parquet
  size:    418 KB
  rows:    19,531
  symbols: 1,514

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-11-20 08:00:00	AAPL	Stock	0.2732	0.2732	0.273	0.273	33600.0
2002-11-20 09:00:00	AAPL	Stock	0.273	0.2764	0.2723	0.2736	13037584.0
2002-11-20 10:00:00	AAPL	Stock	0.2738	0.2768	0.273	0.2766	31858344.0
2002-11-20 11:00:00	AAPL	Stock	0.2766	0.2777	0.2759	0.2766	16093112.0
2002-11-20 12:00:00	AAPL	Stock	0.2766	0.2785	0.2763	0.2777	23960832.0
2002-11-20 13:00:00	AAPL	Stock	0.2779	0.2804	0.2768	0.2786	18500720.0
2002-11-20 14:00:00	AAPL	Stock	0.2793	0.2802	0.2777	0.2788	19833744.0
2002-11-20 15:00:00	AAPL	Stock	0.2789	0.2791	0.2745	0.2782	40760944.0
2002-11-20 16:00:00	AAPL	Stock	0.2782	0.2821	0.2761	0.2821	7968800.0
2002-11-20 17:00:00	AAPL	Stock	0.283	0.283	0.2773	0.2821	143752.0
2002-11-20 18:00:00	AAPL	Stock	0.283	0.283	0.283	0.283	78400.0
2002-11-20 08:00:00	MSFT	Stock	27.415	27.5005	27.415	27.4845	4030.0
2002-11-20 09:00:00	MSFT	Stock	27.4555	27.72	27.44	27.655	7432242.0
2002-11-20 10:00:00	MSFT	Stock	27.655	27.97	27.655	27.91	12250040.0
2002-11-20 11:00:00	MSFT	Stock	27.915	28.195	27.855	28.1345	11535418.0
2002-11-20 12:00:00	MSFT	Stock	28.133	28.258	28.1	28.155	7259890.0
2002-11-20 13:00:00	MSFT	Stock	28.17	28.315	28.14	28.315	8229196.0
2002-11-20 14:00:00	MSFT	Stock	28.315	28.45	28.25	28.395	9964446.0
2002-11-20 15:00:00	MSFT	Stock	28.395	28.42	28.165	28.31	15000424.0
2002-11-20 16:00:00	MSFT	Stock	28.33	28.55	28.275	28.515	1982568.0
2002-11-20 17:00:00	MSFT	Stock	28.515	28.525	28.31	28.475	223030.0
2002-11-20 18:00:00	MSFT	Stock	28.475	28.52	28.47	28.515	29076.0
2002-11-20 08:00:00	NVDA	Stock	0.1196	0.1229	0.1196	0.1216	4713960.0
2002-11-20 09:00:00	NVDA	Stock	0.1216	0.1217	0.1197	0.1202	163561920.0
2002-11-20 10:00:00	NVDA	Stock	0.1202	0.1232	0.1202	0.1224	269051400.0
2002-11-20 11:00:00	NVDA	Stock	0.1223	0.1245	0.1222	0.1244	176244840.0
2002-11-20 12:00:00	NVDA	Stock	0.1243	0.1245	0.1232	0.1233	133183080.0
2002-11-20 13:00:00	NVDA	Stock	0.1233	0.1241	0.1222	0.1229	149469240.0
2002-11-20 14:00:00	NVDA	Stock	0.1229	0.1238	0.1229	0.1234	77762880.0
2002-11-20 15:00:00	NVDA	Stock	0.1235	0.1246	0.1222	0.124	183895320.0
2002-11-20 16:00:00	NVDA	Stock	0.124	0.1271	0.1237	0.1271	52339440.0
2002-11-20 17:00:00	NVDA	Stock	0.1271	0.1279	0.1262	0.1271	5797320.0
2002-11-20 18:00:00	NVDA	Stock	0.1271	0.1275	0.1271	0.1272	851640.0
2002-11-20 08:00:00	AMZN	Stock	1.06	1.0726	1.06	1.0725	107940.0
2002-11-20 09:00:00	AMZN	Stock	1.0695	1.0875	1.061	1.082	26088800.0
2002-11-20 10:00:00	AMZN	Stock	1.0824	1.1125	1.0824	1.109	42888380.0
2002-11-20 11:00:00	AMZN	Stock	1.1075	1.1345	1.1075	1.134	28966500.0
2002-11-20 12:00:00	AMZN	Stock	1.1335	1.15	1.128	1.139	34082080.0
2002-11-20 13:00:00	AMZN	Stock	1.14	1.148	1.138	1.142	31382600.0
2002-11-20 14:00:00	AMZN	Stock	1.1415	1.1445	1.1295	1.1385	37037360.0
2002-11-20 15:00:00	AMZN	Stock	1.1395	1.146	1.1365	1.145	33562300.0
2002-11-20 16:00:00	AMZN	Stock	1.146	1.162	1.1425	1.1615	3223480.0
2002-11-20 17:00:00	AMZN	Stock	1.1615	1.175	1.145	1.17	902840.0
2002-11-20 18:00:00	AMZN	Stock	1.17	1.1715	1.1655	1.169	48000.0
2002-11-20 09:00:00	CL	Stock	26.575	26.575	26.25	26.26	360000.0
2002-11-20 10:00:00	CL	Stock	26.265	26.35	26.13	26.275	461200.0
2002-11-20 11:00:00	CL	Stock	26.275	26.295	25.975	26.225	1029000.0
2002-11-20 12:00:00	CL	Stock	26.225	26.325	26.145	26.285	239000.0
2002-11-20 13:00:00	CL	Stock	26.3	26.57	26.25	26.545	269200.0
2002-11-20 14:00:00	CL	Stock	26.54	26.7	26.53	26.605	315600.0

> showing 50 of 19,531 rows — these rows as CSV

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