PREVIEW / stock_1hour / 2002-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-24.parquet
  size:    405 KB
  rows:    19,098
  symbols: 1,409

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-04-24 08:00:00	AAPL	Stock	0.4328	0.4328	0.4328	0.4328	498400.0
2002-04-24 09:00:00	AAPL	Stock	0.4364	0.4371	0.4322	0.4332	19796000.0
2002-04-24 10:00:00	AAPL	Stock	0.433	0.4375	0.4304	0.4375	22724800.0
2002-04-24 11:00:00	AAPL	Stock	0.4375	0.4375	0.4327	0.4341	10595200.0
2002-04-24 12:00:00	AAPL	Stock	0.4345	0.4363	0.4332	0.4341	8724800.0
2002-04-24 13:00:00	AAPL	Stock	0.4341	0.4359	0.4325	0.4341	9021600.0
2002-04-24 14:00:00	AAPL	Stock	0.4341	0.4359	0.4277	0.4295	21705600.0
2002-04-24 15:00:00	AAPL	Stock	0.4291	0.4305	0.4229	0.4245	37100000.0
2002-04-24 16:00:00	AAPL	Stock	0.4243	0.4282	0.4239	0.4282	2615200.0
2002-04-24 18:00:00	AAPL	Stock	0.4239	0.4239	0.4152	0.4152	44800.0
2002-04-24 08:00:00	MSFT	Stock	27.0	27.125	26.9	27.065	81400.0
2002-04-24 09:00:00	MSFT	Stock	27.085	27.12	26.675	26.705	7161800.0
2002-04-24 10:00:00	MSFT	Stock	26.705	26.826	26.545	26.725	13093000.0
2002-04-24 11:00:00	MSFT	Stock	26.72	27.125	26.63	27.09	6274400.0
2002-04-24 12:00:00	MSFT	Stock	27.085	27.215	26.925	27.02	4676000.0
2002-04-24 13:00:00	MSFT	Stock	27.025	27.125	26.8	26.825	4478200.0
2002-04-24 14:00:00	MSFT	Stock	26.825	26.93	26.625	26.66	8364800.0
2002-04-24 15:00:00	MSFT	Stock	26.66	26.721	26.5	26.505	11788800.0
2002-04-24 16:00:00	MSFT	Stock	26.505	26.97	26.5	26.6	1942600.0
2002-04-24 17:00:00	MSFT	Stock	26.6	26.7652	26.575	26.6	34800.0
2002-04-24 18:00:00	MSFT	Stock	26.615	26.65	26.55	26.55	14400.0
2002-04-24 08:00:00	NVDA	Stock	0.2987	0.3021	0.2984	0.3004	2088000.0
2002-04-24 09:00:00	NVDA	Stock	0.3011	0.3045	0.297	0.2972	111384000.0
2002-04-24 10:00:00	NVDA	Stock	0.2976	0.2996	0.2883	0.2923	232284000.0
2002-04-24 11:00:00	NVDA	Stock	0.2922	0.2923	0.2846	0.2907	216708000.0
2002-04-24 12:00:00	NVDA	Stock	0.2904	0.2907	0.2851	0.2854	119592000.0
2002-04-24 13:00:00	NVDA	Stock	0.2854	0.2871	0.2792	0.2812	207528000.0
2002-04-24 14:00:00	NVDA	Stock	0.2814	0.2841	0.2755	0.2782	212004000.0
2002-04-24 15:00:00	NVDA	Stock	0.2778	0.2786	0.2699	0.2707	322680000.0
2002-04-24 16:00:00	NVDA	Stock	0.2707	0.2757	0.27	0.2704	61572000.0
2002-04-24 17:00:00	NVDA	Stock	0.27	0.2849	0.2687	0.2712	9288000.0
2002-04-24 18:00:00	NVDA	Stock	0.2712	0.2717	0.2703	0.2712	696000.0
2002-04-24 08:00:00	AMZN	Stock	0.77	0.781	0.746	0.7575	14526140.0
2002-04-24 09:00:00	AMZN	Stock	0.7575	0.8005	0.744	0.794	143634000.0
2002-04-24 10:00:00	AMZN	Stock	0.794	0.8145	0.7825	0.8065	141062000.0
2002-04-24 11:00:00	AMZN	Stock	0.805	0.825	0.8037	0.8205	83660000.0
2002-04-24 12:00:00	AMZN	Stock	0.82	0.8295	0.8146	0.82	54918000.0
2002-04-24 13:00:00	AMZN	Stock	0.8195	0.826	0.8185	0.8241	37874000.0
2002-04-24 14:00:00	AMZN	Stock	0.8245	0.834	0.8225	0.8245	45764000.0
2002-04-24 15:00:00	AMZN	Stock	0.825	0.8425	0.8245	0.84	105090000.0
2002-04-24 16:00:00	AMZN	Stock	0.8395	0.8495	0.7525	0.8495	22598000.0
2002-04-24 17:00:00	AMZN	Stock	0.8495	0.855	0.8092	0.8485	918000.0
2002-04-24 18:00:00	AMZN	Stock	0.8475	0.85	0.8395	0.85	162000.0
2002-04-24 09:00:00	CL	Stock	27.46	27.73	27.46	27.725	337200.0
2002-04-24 10:00:00	CL	Stock	27.725	27.765	27.6	27.665	1060000.0
2002-04-24 11:00:00	CL	Stock	27.675	27.75	27.63	27.725	1239800.0
2002-04-24 12:00:00	CL	Stock	27.725	27.725	27.625	27.63	545600.0
2002-04-24 13:00:00	CL	Stock	27.63	27.67	27.62	27.655	668000.0
2002-04-24 14:00:00	CL	Stock	27.66	27.685	27.555	27.6	2826800.0
2002-04-24 15:00:00	CL	Stock	27.59	27.67	27.55	27.67	1032200.0

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

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