PREVIEW / stock_1hour / 2005-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-16.parquet
  size:    577 KB
  rows:    27,300
  symbols: 2,122

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-11-16 07:00:00	AAPL	Stock	2.2475	2.2475	2.2386	2.2436	170800.0
2005-11-16 08:00:00	AAPL	Stock	2.2411	2.2561	2.2364	2.2561	3483760.0
2005-11-16 09:00:00	AAPL	Stock	2.2529	2.2836	2.2482	2.2729	149082332.0
2005-11-16 10:00:00	AAPL	Stock	2.2732	2.2996	2.2696	2.294	172932732.0
2005-11-16 11:00:00	AAPL	Stock	2.2936	2.3032	2.2789	2.3	94957128.0
2005-11-16 12:00:00	AAPL	Stock	2.2996	2.3032	2.2871	2.2914	53246228.0
2005-11-16 13:00:00	AAPL	Stock	2.2911	2.3011	2.2875	2.2989	50637888.0
2005-11-16 14:00:00	AAPL	Stock	2.2989	2.3014	2.2904	2.3007	58858828.0
2005-11-16 15:00:00	AAPL	Stock	2.3007	2.3236	2.2954	2.3204	168947912.0
2005-11-16 16:00:00	AAPL	Stock	2.3196	2.335	2.3161	2.3196	9455012.0
2005-11-16 17:00:00	AAPL	Stock	2.3321	2.3357	2.2917	2.3286	2056460.0
2005-11-16 18:00:00	AAPL	Stock	2.3307	2.3332	2.3296	2.3332	194096.0
2005-11-16 07:00:00	MSFT	Stock	26.5	27.49	26.5	27.43	11000.0
2005-11-16 08:00:00	MSFT	Stock	27.45	27.58	27.42	27.44	80524.0
2005-11-16 09:00:00	MSFT	Stock	27.44	27.6	27.44	27.6	6509558.0
2005-11-16 10:00:00	MSFT	Stock	27.59	27.67	27.54	27.6	10016250.0
2005-11-16 11:00:00	MSFT	Stock	27.6	27.62	27.52	27.59	8134105.0
2005-11-16 12:00:00	MSFT	Stock	27.59	27.63	27.55	27.62	5073877.0
2005-11-16 13:00:00	MSFT	Stock	27.61	27.8	27.53	27.76	17860183.0
2005-11-16 14:00:00	MSFT	Stock	27.76	27.851	27.71	27.85	12971348.0
2005-11-16 15:00:00	MSFT	Stock	27.84	27.88	27.7	27.75	20083980.0
2005-11-16 16:00:00	MSFT	Stock	27.75	27.82	27.64	27.81	1684449.0
2005-11-16 17:00:00	MSFT	Stock	27.77	27.804	27.689	27.77	1065966.0
2005-11-16 18:00:00	MSFT	Stock	27.77	27.78	27.76	27.77	1395.0
2005-11-16 09:00:00	NVDA	Stock	0.2906	0.2922	0.2873	0.2879	80341800.0
2005-11-16 10:00:00	NVDA	Stock	0.2879	0.2904	0.2837	0.2893	125372520.0
2005-11-16 11:00:00	NVDA	Stock	0.2892	0.2901	0.2877	0.2895	44751480.0
2005-11-16 12:00:00	NVDA	Stock	0.2895	0.2911	0.2884	0.2889	63552720.0
2005-11-16 13:00:00	NVDA	Stock	0.2889	0.2896	0.2868	0.2881	31425960.0
2005-11-16 14:00:00	NVDA	Stock	0.288	0.2887	0.2873	0.2882	15178320.0
2005-11-16 15:00:00	NVDA	Stock	0.2882	0.2897	0.2882	0.2885	60369840.0
2005-11-16 16:00:00	NVDA	Stock	0.2887	0.2893	0.2883	0.2886	3945480.0
2005-11-16 17:00:00	NVDA	Stock	0.2891	0.2891	0.2891	0.2891	384000.0
2005-11-16 08:00:00	AMZN	Stock	2.205	2.2215	2.2025	2.2175	355600.0
2005-11-16 09:00:00	AMZN	Stock	2.2175	2.247	2.212	2.231	26691420.0
2005-11-16 10:00:00	AMZN	Stock	2.231	2.264	2.226	2.2585	30851760.0
2005-11-16 11:00:00	AMZN	Stock	2.258	2.263	2.2465	2.26	22660640.0
2005-11-16 12:00:00	AMZN	Stock	2.2605	2.2625	2.254	2.2545	16893620.0
2005-11-16 13:00:00	AMZN	Stock	2.255	2.258	2.2505	2.256	10222940.0
2005-11-16 14:00:00	AMZN	Stock	2.2555	2.268	2.255	2.264	17647220.0
2005-11-16 15:00:00	AMZN	Stock	2.2635	2.27	2.2585	2.265	27854940.0
2005-11-16 16:00:00	AMZN	Stock	2.265	2.265	2.2605	2.265	3379760.0
2005-11-16 17:00:00	AMZN	Stock	2.26	2.2639	2.26	2.2639	250000.0
2005-11-16 18:00:00	AMZN	Stock	2.264	2.264	2.2503	2.264	294000.0
2005-11-16 09:00:00	CL	Stock	26.9	26.9	26.7	26.71	270400.0
2005-11-16 10:00:00	CL	Stock	26.715	26.87	26.715	26.86	389600.0
2005-11-16 11:00:00	CL	Stock	26.86	26.865	26.795	26.805	376800.0
2005-11-16 12:00:00	CL	Stock	26.8	26.82	26.75	26.755	185800.0
2005-11-16 13:00:00	CL	Stock	26.76	26.815	26.735	26.795	186000.0
2005-11-16 14:00:00	CL	Stock	26.8	26.825	26.755	26.795	208200.0

> showing 50 of 27,300 rows — these rows as CSV

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