PREVIEW / stock_1hour / 2005-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-23.parquet
  size:    533 KB
  rows:    25,516
  symbols: 1,981

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
2005-05-23 07:00:00	AAPL	Stock	1.3464	1.3486	1.3464	1.3486	78652.0
2005-05-23 08:00:00	AAPL	Stock	1.3561	1.375	1.3529	1.3668	4269104.0
2005-05-23 09:00:00	AAPL	Stock	1.3668	1.3811	1.3489	1.3803	159128032.0
2005-05-23 10:00:00	AAPL	Stock	1.3804	1.3932	1.3768	1.3864	232246252.0
2005-05-23 11:00:00	AAPL	Stock	1.3861	1.4057	1.3814	1.4046	141006684.0
2005-05-23 12:00:00	AAPL	Stock	1.405	1.4182	1.4018	1.4121	153861260.0
2005-05-23 13:00:00	AAPL	Stock	1.4118	1.4196	1.4086	1.4157	96937372.0
2005-05-23 14:00:00	AAPL	Stock	1.4154	1.4218	1.3875	1.4164	88148200.0
2005-05-23 15:00:00	AAPL	Stock	1.4164	1.425	1.4071	1.4186	153210568.0
2005-05-23 16:00:00	AAPL	Stock	1.4189	1.4229	1.4164	1.4225	6740020.0
2005-05-23 17:00:00	AAPL	Stock	1.4221	1.4282	1.4221	1.4264	654500.0
2005-05-23 18:00:00	AAPL	Stock	1.4261	1.4264	1.425	1.4257	93632.0
2005-05-23 07:00:00	MSFT	Stock	25.85	25.9	25.85	25.9	14603.0
2005-05-23 08:00:00	MSFT	Stock	25.93	25.95	25.86	25.88	76900.0
2005-05-23 09:00:00	MSFT	Stock	25.87	26.07	25.74	25.97	13620716.0
2005-05-23 10:00:00	MSFT	Stock	25.97	26.0	25.82	25.86	13291454.0
2005-05-23 11:00:00	MSFT	Stock	25.87	26.0	25.82	25.88	10813053.0
2005-05-23 12:00:00	MSFT	Stock	25.89	25.91	25.82	25.85	6645112.0
2005-05-23 13:00:00	MSFT	Stock	25.84	25.91	25.81	25.84	6201751.0
2005-05-23 14:00:00	MSFT	Stock	25.84	25.92	25.81	25.87	10330178.0
2005-05-23 15:00:00	MSFT	Stock	25.86	25.92	25.79	25.86	12694660.0
2005-05-23 16:00:00	MSFT	Stock	25.86	25.89	25.82	25.85	600102.0
2005-05-23 17:00:00	MSFT	Stock	25.87	25.89	25.82	25.85	6674.0
2005-05-23 18:00:00	MSFT	Stock	25.88	25.88	25.84	25.88	1140.0
2005-05-23 08:00:00	NVDA	Stock	0.2225	0.2225	0.221	0.221	132000.0
2005-05-23 09:00:00	NVDA	Stock	0.2217	0.2249	0.22	0.2247	141506520.0
2005-05-23 10:00:00	NVDA	Stock	0.2247	0.2258	0.2233	0.2238	168432360.0
2005-05-23 11:00:00	NVDA	Stock	0.2239	0.2247	0.2227	0.2239	71680560.0
2005-05-23 12:00:00	NVDA	Stock	0.2239	0.2242	0.2229	0.2232	43023000.0
2005-05-23 13:00:00	NVDA	Stock	0.2232	0.224	0.2222	0.224	36153120.0
2005-05-23 14:00:00	NVDA	Stock	0.2239	0.2262	0.2237	0.2257	98262120.0
2005-05-23 15:00:00	NVDA	Stock	0.2257	0.2265	0.2238	0.2242	135288960.0
2005-05-23 16:00:00	NVDA	Stock	0.2242	0.2252	0.2242	0.2252	1678200.0
2005-05-23 17:00:00	NVDA	Stock	0.2239	0.2239	0.2239	0.2239	58200.0
2005-05-23 09:00:00	AMZN	Stock	1.761	1.7795	1.7605	1.7765	16101180.0
2005-05-23 10:00:00	AMZN	Stock	1.7775	1.785	1.7725	1.7825	24280040.0
2005-05-23 11:00:00	AMZN	Stock	1.7825	1.8	1.779	1.8	14342540.0
2005-05-23 12:00:00	AMZN	Stock	1.8	1.801	1.7955	1.7975	11871820.0
2005-05-23 13:00:00	AMZN	Stock	1.798	1.8	1.785	1.7915	11969540.0
2005-05-23 14:00:00	AMZN	Stock	1.7915	1.7965	1.7895	1.7925	11057440.0
2005-05-23 15:00:00	AMZN	Stock	1.7925	1.7935	1.7815	1.7825	19100420.0
2005-05-23 16:00:00	AMZN	Stock	1.7825	1.8006	1.782	1.784	2294220.0
2005-05-23 17:00:00	AMZN	Stock	1.7845	1.7845	1.7845	1.7845	3360.0
2005-05-23 18:00:00	AMZN	Stock	1.782	1.7825	1.7815	1.7825	24120.0
2005-05-23 09:00:00	CL	Stock	25.56	25.575	25.465	25.49	347800.0
2005-05-23 10:00:00	CL	Stock	25.47	25.495	25.28	25.32	817200.0
2005-05-23 11:00:00	CL	Stock	25.329	25.42	25.305	25.4	556000.0
2005-05-23 12:00:00	CL	Stock	25.4	25.42	25.35	25.4	605200.0
2005-05-23 13:00:00	CL	Stock	25.4	25.4	25.345	25.36	272800.0
2005-05-23 14:00:00	CL	Stock	25.355	25.48	25.35	25.439	500400.0

> showing 50 of 25,516 rows — these rows as CSV

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