PREVIEW / stock_1hour / 2002-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-28.parquet
  size:    395 KB
  rows:    18,735
  symbols: 1,459

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-28 08:00:00	AAPL	Stock	0.2643	0.266	0.2593	0.2593	75600.0
2002-08-28 09:00:00	AAPL	Stock	0.2659	0.2686	0.2616	0.2673	20974912.0
2002-08-28 10:00:00	AAPL	Stock	0.2675	0.2679	0.2648	0.2675	30977520.0
2002-08-28 11:00:00	AAPL	Stock	0.2673	0.2689	0.263	0.2661	48844152.0
2002-08-28 12:00:00	AAPL	Stock	0.2664	0.2693	0.265	0.2691	23959488.0
2002-08-28 13:00:00	AAPL	Stock	0.2689	0.27	0.267	0.2673	24314304.0
2002-08-28 14:00:00	AAPL	Stock	0.2673	0.2677	0.2616	0.2618	32317320.0
2002-08-28 15:00:00	AAPL	Stock	0.2621	0.2657	0.2616	0.2632	45436496.0
2002-08-28 16:00:00	AAPL	Stock	0.263	0.263	0.2621	0.2625	7386400.0
2002-08-28 17:00:00	AAPL	Stock	0.2625	0.2625	0.2625	0.2625	2973600.0
2002-08-28 08:00:00	MSFT	Stock	25.17	25.4175	25.15	25.295	289876.0
2002-08-28 09:00:00	MSFT	Stock	25.325	25.405	25.155	25.195	9156050.0
2002-08-28 10:00:00	MSFT	Stock	25.2	25.285	25.1	25.18	9942224.0
2002-08-28 11:00:00	MSFT	Stock	25.18	25.2015	24.815	24.895	8817204.0
2002-08-28 12:00:00	MSFT	Stock	24.8945	24.99	24.785	24.886	8472632.0
2002-08-28 13:00:00	MSFT	Stock	24.89	25.094	24.8	24.915	8874856.0
2002-08-28 14:00:00	MSFT	Stock	24.9155	24.955	24.625	24.725	10104166.0
2002-08-28 15:00:00	MSFT	Stock	24.725	24.9995	24.655	24.7	12105480.0
2002-08-28 16:00:00	MSFT	Stock	24.695	24.825	24.655	24.66	2219642.0
2002-08-28 17:00:00	MSFT	Stock	24.69	24.724	24.625	24.665	424840.0
2002-08-28 18:00:00	MSFT	Stock	24.665	24.675	24.655	24.67	3800.0
2002-08-28 08:00:00	NVDA	Stock	0.091	0.0917	0.0903	0.0903	3026400.0
2002-08-28 09:00:00	NVDA	Stock	0.0902	0.0907	0.0883	0.0883	96480480.0
2002-08-28 10:00:00	NVDA	Stock	0.0884	0.0887	0.0875	0.0886	104617920.0
2002-08-28 11:00:00	NVDA	Stock	0.0887	0.0888	0.0867	0.0871	89545560.0
2002-08-28 12:00:00	NVDA	Stock	0.0871	0.0883	0.0861	0.0875	91593960.0
2002-08-28 13:00:00	NVDA	Stock	0.0875	0.0889	0.0867	0.0874	70744560.0
2002-08-28 14:00:00	NVDA	Stock	0.0874	0.0874	0.0856	0.0857	78211320.0
2002-08-28 15:00:00	NVDA	Stock	0.0857	0.0871	0.085	0.0854	137251320.0
2002-08-28 16:00:00	NVDA	Stock	0.0854	0.0855	0.0847	0.0847	19215360.0
2002-08-28 17:00:00	NVDA	Stock	0.0852	0.0858	0.085	0.0854	3515880.0
2002-08-28 18:00:00	NVDA	Stock	0.0853	0.0853	0.0853	0.0853	720000.0
2002-08-28 08:00:00	AMZN	Stock	0.7175	0.7245	0.7175	0.7245	12000.0
2002-08-28 09:00:00	AMZN	Stock	0.7201	0.743	0.718	0.7394	8663520.0
2002-08-28 10:00:00	AMZN	Stock	0.7395	0.7485	0.727	0.733	18084080.0
2002-08-28 11:00:00	AMZN	Stock	0.7325	0.7375	0.728	0.736	11056520.0
2002-08-28 12:00:00	AMZN	Stock	0.736	0.7375	0.728	0.7345	7799740.0
2002-08-28 13:00:00	AMZN	Stock	0.7345	0.7395	0.7325	0.7365	6775600.0
2002-08-28 14:00:00	AMZN	Stock	0.736	0.7405	0.726	0.7325	15149020.0
2002-08-28 15:00:00	AMZN	Stock	0.7326	0.7385	0.7255	0.732	20915800.0
2002-08-28 16:00:00	AMZN	Stock	0.7315	0.738	0.7255	0.7285	2104000.0
2002-08-28 17:00:00	AMZN	Stock	0.7285	0.729	0.7285	0.7285	546000.0
2002-08-28 09:00:00	CL	Stock	27.04	27.18	26.975	27.1	252000.0
2002-08-28 10:00:00	CL	Stock	27.075	27.125	26.975	27.05	413000.0
2002-08-28 11:00:00	CL	Stock	27.05	27.075	26.85	27.03	448400.0
2002-08-28 12:00:00	CL	Stock	27.015	27.14	26.975	27.05	380200.0
2002-08-28 13:00:00	CL	Stock	27.04	27.1	26.92	26.945	378000.0
2002-08-28 14:00:00	CL	Stock	26.935	26.935	26.69	26.78	339200.0
2002-08-28 15:00:00	CL	Stock	26.76	26.9	26.66	26.86	486400.0
2002-08-28 16:00:00	CL	Stock	26.855	26.855	26.83	26.83	92200.0

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

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