PREVIEW / stock_1hour / 2002-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-05.parquet
  size:    396 KB
  rows:    18,546
  symbols: 1,458

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-08-05 08:00:00	AAPL	Stock	0.2573	0.2573	0.2573	0.2573	78400.0
2002-08-05 09:00:00	AAPL	Stock	0.2573	0.2625	0.2573	0.2593	13824328.0
2002-08-05 10:00:00	AAPL	Stock	0.2593	0.2618	0.2554	0.2554	32827704.0
2002-08-05 11:00:00	AAPL	Stock	0.2554	0.2568	0.2527	0.2561	28016576.0
2002-08-05 12:00:00	AAPL	Stock	0.2559	0.2584	0.2532	0.2534	18179280.0
2002-08-05 13:00:00	AAPL	Stock	0.2536	0.257	0.2534	0.2538	14013216.0
2002-08-05 14:00:00	AAPL	Stock	0.2538	0.2543	0.2518	0.2527	19777240.0
2002-08-05 15:00:00	AAPL	Stock	0.2527	0.2529	0.2496	0.25	30008664.0
2002-08-05 16:00:00	AAPL	Stock	0.25	0.2513	0.2495	0.25	8220800.0
2002-08-05 17:00:00	AAPL	Stock	0.2502	0.2502	0.2502	0.2502	336000.0
2002-08-05 08:00:00	MSFT	Stock	22.0	22.2	21.905	21.975	59460.0
2002-08-05 09:00:00	MSFT	Stock	22.19	22.245	21.905	22.175	10509066.0
2002-08-05 10:00:00	MSFT	Stock	22.1705	22.585	22.05	22.13	16227514.0
2002-08-05 11:00:00	MSFT	Stock	22.14	22.29	22.02	22.225	10847178.0
2002-08-05 12:00:00	MSFT	Stock	22.225	22.325	22.0	22.06	6340004.0
2002-08-05 13:00:00	MSFT	Stock	22.06	22.46	22.05	22.375	10260128.0
2002-08-05 14:00:00	MSFT	Stock	22.38	22.4	22.05	22.215	8453042.0
2002-08-05 15:00:00	MSFT	Stock	22.2115	22.3	21.96	21.99	13562412.0
2002-08-05 16:00:00	MSFT	Stock	21.985	22.12	21.9605	22.05	1734868.0
2002-08-05 17:00:00	MSFT	Stock	22.03	22.1644	22.025	22.03	272746.0
2002-08-05 18:00:00	MSFT	Stock	22.025	22.03	22.025	22.025	9400.0
2002-08-05 08:00:00	NVDA	Stock	0.0758	0.0789	0.0758	0.0764	621480.0
2002-08-05 09:00:00	NVDA	Stock	0.0767	0.0779	0.0722	0.0724	353435760.0
2002-08-05 10:00:00	NVDA	Stock	0.0724	0.0742	0.0713	0.0733	261017280.0
2002-08-05 11:00:00	NVDA	Stock	0.0732	0.075	0.0718	0.0742	170402640.0
2002-08-05 12:00:00	NVDA	Stock	0.0742	0.0753	0.0734	0.0738	127337880.0
2002-08-05 13:00:00	NVDA	Stock	0.0738	0.0744	0.0736	0.0742	92806200.0
2002-08-05 14:00:00	NVDA	Stock	0.0742	0.0742	0.0708	0.0714	126736080.0
2002-08-05 15:00:00	NVDA	Stock	0.0714	0.0721	0.0707	0.0715	174169080.0
2002-08-05 16:00:00	NVDA	Stock	0.0714	0.0724	0.0711	0.0717	11537280.0
2002-08-05 17:00:00	NVDA	Stock	0.0717	0.0717	0.0712	0.0712	2279880.0
2002-08-05 18:00:00	NVDA	Stock	0.0712	0.0717	0.0712	0.0717	192000.0
2002-08-05 08:00:00	AMZN	Stock	0.69	0.69	0.69	0.69	2000.0
2002-08-05 09:00:00	AMZN	Stock	0.6786	0.6875	0.6625	0.664	9127880.0
2002-08-05 10:00:00	AMZN	Stock	0.666	0.671	0.654	0.655	15185260.0
2002-08-05 11:00:00	AMZN	Stock	0.654	0.662	0.6515	0.6515	12003260.0
2002-08-05 12:00:00	AMZN	Stock	0.6525	0.6545	0.6425	0.6435	11981080.0
2002-08-05 13:00:00	AMZN	Stock	0.644	0.6495	0.6425	0.6445	6834600.0
2002-08-05 14:00:00	AMZN	Stock	0.645	0.6475	0.641	0.6415	7293660.0
2002-08-05 15:00:00	AMZN	Stock	0.642	0.653	0.639	0.6425	12214960.0
2002-08-05 16:00:00	AMZN	Stock	0.6435	0.65	0.6375	0.6435	833220.0
2002-08-05 17:00:00	AMZN	Stock	0.6465	0.6465	0.6465	0.6465	6000.0
2002-08-05 18:00:00	AMZN	Stock	0.645	0.645	0.645	0.645	2000.0
2002-08-05 09:00:00	CL	Stock	26.1	26.145	25.7	25.705	570800.0
2002-08-05 10:00:00	CL	Stock	25.705	26.06	25.69	25.9	779200.0
2002-08-05 11:00:00	CL	Stock	25.9	25.995	25.795	25.87	495000.0
2002-08-05 12:00:00	CL	Stock	25.9	25.95	25.75	25.75	395400.0
2002-08-05 13:00:00	CL	Stock	25.755	25.955	25.755	25.805	452800.0
2002-08-05 14:00:00	CL	Stock	25.785	25.825	25.65	25.71	649000.0
2002-08-05 15:00:00	CL	Stock	25.71	25.71	25.385	25.46	820600.0

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

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