PREVIEW / stock_1hour / 2002-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-19.parquet
  size:    396 KB
  rows:    18,756
  symbols: 1,456

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-19 09:00:00	AAPL	Stock	0.2818	0.2857	0.2807	0.2845	20625080.0
2002-08-19 10:00:00	AAPL	Stock	0.2845	0.2886	0.283	0.2868	43327032.0
2002-08-19 11:00:00	AAPL	Stock	0.2866	0.2902	0.2864	0.2882	25628344.0
2002-08-19 12:00:00	AAPL	Stock	0.2884	0.2891	0.2877	0.2886	15443960.0
2002-08-19 13:00:00	AAPL	Stock	0.2887	0.2902	0.2882	0.2898	21315896.0
2002-08-19 14:00:00	AAPL	Stock	0.29	0.29	0.2832	0.2848	26667872.0
2002-08-19 15:00:00	AAPL	Stock	0.2848	0.2864	0.2823	0.2855	45391920.0
2002-08-19 16:00:00	AAPL	Stock	0.2854	0.2855	0.2832	0.2832	7688800.0
2002-08-19 18:00:00	AAPL	Stock	0.2854	0.2854	0.2854	0.2854	22400.0
2002-08-19 08:00:00	MSFT	Stock	24.99	25.075	24.875	25.05	186420.0
2002-08-19 09:00:00	MSFT	Stock	25.055	25.315	24.925	25.235	8168924.0
2002-08-19 10:00:00	MSFT	Stock	25.24	25.665	25.225	25.595	17376984.0
2002-08-19 11:00:00	MSFT	Stock	25.595	25.8	25.57	25.7	9395942.0
2002-08-19 12:00:00	MSFT	Stock	25.7	25.765	25.65	25.7005	4971330.0
2002-08-19 13:00:00	MSFT	Stock	25.6995	26.0	25.6995	25.98	10333494.0
2002-08-19 14:00:00	MSFT	Stock	25.97	26.025	25.77	25.866	14344490.0
2002-08-19 15:00:00	MSFT	Stock	25.865	26.01	25.8	25.9945	12142360.0
2002-08-19 16:00:00	MSFT	Stock	25.99	26.0	25.88	25.97	1060158.0
2002-08-19 17:00:00	MSFT	Stock	25.975	25.99	25.945	25.99	11196.0
2002-08-19 18:00:00	MSFT	Stock	26.0	26.0	25.961	26.0	9000.0
2002-08-19 08:00:00	NVDA	Stock	0.0903	0.0913	0.0887	0.0913	1934400.0
2002-08-19 09:00:00	NVDA	Stock	0.0912	0.0997	0.0908	0.0977	344468640.0
2002-08-19 10:00:00	NVDA	Stock	0.0978	0.1007	0.0972	0.0998	352212840.0
2002-08-19 11:00:00	NVDA	Stock	0.0999	0.1013	0.0989	0.0999	209395800.0
2002-08-19 12:00:00	NVDA	Stock	0.0999	0.1022	0.0999	0.1016	139039080.0
2002-08-19 13:00:00	NVDA	Stock	0.1016	0.1099	0.1014	0.1098	341068320.0
2002-08-19 14:00:00	NVDA	Stock	0.1098	0.1121	0.1054	0.1067	424822800.0
2002-08-19 15:00:00	NVDA	Stock	0.1069	0.1077	0.1047	0.1054	330499920.0
2002-08-19 16:00:00	NVDA	Stock	0.1053	0.1058	0.1047	0.1054	39523800.0
2002-08-19 17:00:00	NVDA	Stock	0.1054	0.1062	0.1053	0.106	2259840.0
2002-08-19 18:00:00	NVDA	Stock	0.1062	0.1067	0.1051	0.1062	3792000.0
2002-08-19 08:00:00	AMZN	Stock	0.746	0.7475	0.7455	0.7455	64000.0
2002-08-19 09:00:00	AMZN	Stock	0.745	0.7525	0.7335	0.749	9638220.0
2002-08-19 10:00:00	AMZN	Stock	0.7495	0.7535	0.7395	0.745	13558660.0
2002-08-19 11:00:00	AMZN	Stock	0.7455	0.7515	0.7425	0.748	10461260.0
2002-08-19 12:00:00	AMZN	Stock	0.748	0.751	0.745	0.747	4709000.0
2002-08-19 13:00:00	AMZN	Stock	0.7471	0.767	0.747	0.767	11523780.0
2002-08-19 14:00:00	AMZN	Stock	0.767	0.7725	0.762	0.7675	12318840.0
2002-08-19 15:00:00	AMZN	Stock	0.768	0.776	0.765	0.773	18201160.0
2002-08-19 16:00:00	AMZN	Stock	0.7745	0.775	0.7692	0.7715	726000.0
2002-08-19 17:00:00	AMZN	Stock	0.7725	0.775	0.7715	0.7715	38000.0
2002-08-19 18:00:00	AMZN	Stock	0.7738	0.775	0.7738	0.775	76000.0
2002-08-19 09:00:00	CL	Stock	26.975	26.975	26.825	26.83	183200.0
2002-08-19 10:00:00	CL	Stock	26.83	27.295	26.825	27.225	706400.0
2002-08-19 11:00:00	CL	Stock	27.215	27.25	27.085	27.23	355600.0
2002-08-19 12:00:00	CL	Stock	27.215	27.35	27.12	27.34	261600.0
2002-08-19 13:00:00	CL	Stock	27.345	27.435	27.31	27.4	474400.0
2002-08-19 14:00:00	CL	Stock	27.4	27.425	27.335	27.375	362000.0
2002-08-19 15:00:00	CL	Stock	27.37	27.46	27.35	27.45	419000.0
2002-08-19 16:00:00	CL	Stock	27.45	27.45	27.45	27.45	92800.0

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

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