PREVIEW / stock_30min / 2006-07-18

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-07-18.parquet
  size:    905 KB
  rows:    49,202
  symbols: 2,312

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
2006-07-18 07:00:00	AAPL	Stock	1.8768	1.8768	1.8768	1.8768	64400.0
2006-07-18 07:30:00	AAPL	Stock	1.8786	1.8893	1.8786	1.8893	98000.0
2006-07-18 08:00:00	AAPL	Stock	1.8896	1.9036	1.8864	1.8921	1662276.0
2006-07-18 08:30:00	AAPL	Stock	1.89	1.8921	1.8825	1.8854	1196328.0
2006-07-18 09:00:00	AAPL	Stock	1.8839	1.9018	1.8821	1.8996	5331676.0
2006-07-18 09:30:00	AAPL	Stock	1.8986	1.9232	1.8929	1.9053	182466704.0
2006-07-18 10:00:00	AAPL	Stock	1.9043	1.905	1.8846	1.8964	99789480.0
2006-07-18 10:30:00	AAPL	Stock	1.8957	1.9021	1.8864	1.8896	69394444.0
2006-07-18 11:00:00	AAPL	Stock	1.8896	1.8907	1.8786	1.8861	55827716.0
2006-07-18 11:30:00	AAPL	Stock	1.8864	1.8986	1.8861	1.8918	51010176.0
2006-07-18 12:00:00	AAPL	Stock	1.8911	1.8914	1.8789	1.8868	42096712.0
2006-07-18 12:30:00	AAPL	Stock	1.8864	1.8946	1.8786	1.88	37902312.0
2006-07-18 13:00:00	AAPL	Stock	1.8796	1.88	1.8629	1.8636	65690688.0
2006-07-18 13:30:00	AAPL	Stock	1.8636	1.8664	1.8518	1.8546	62883044.0
2006-07-18 14:00:00	AAPL	Stock	1.8543	1.8682	1.8536	1.8642	66870804.0
2006-07-18 14:30:00	AAPL	Stock	1.8639	1.8804	1.8614	1.8696	95139128.0
2006-07-18 15:00:00	AAPL	Stock	1.8696	1.8789	1.8618	1.8782	53067616.0
2006-07-18 15:30:00	AAPL	Stock	1.8779	1.8936	1.8754	1.8925	100408504.0
2006-07-18 16:00:00	AAPL	Stock	1.8921	1.9018	1.8896	1.8964	1827560.0
2006-07-18 16:30:00	AAPL	Stock	1.8993	1.8993	1.8821	1.8864	1102444.0
2006-07-18 17:00:00	AAPL	Stock	1.8854	1.8879	1.8836	1.8854	678860.0
2006-07-18 17:30:00	AAPL	Stock	1.8893	1.8893	1.8854	1.8854	506744.0
2006-07-18 18:00:00	AAPL	Stock	1.8843	1.8843	1.8793	1.8793	231112.0
2006-07-18 07:00:00	MSFT	Stock	22.41	22.41	22.41	22.41	200.0
2006-07-18 08:00:00	MSFT	Stock	22.49	22.49	22.49	22.49	1580.0
2006-07-18 08:30:00	MSFT	Stock	22.49	22.56	22.49	22.56	7071.0
2006-07-18 09:00:00	MSFT	Stock	22.57	22.64	22.52	22.6	94196.0
2006-07-18 09:30:00	MSFT	Stock	22.59	22.72	22.58	22.64	6239852.0
2006-07-18 10:00:00	MSFT	Stock	22.645	22.74	22.62	22.68	4188006.0
2006-07-18 10:30:00	MSFT	Stock	22.68	22.69	22.63	22.64	2791958.0
2006-07-18 11:00:00	MSFT	Stock	22.64	22.72	22.6	22.69	4133265.0
2006-07-18 11:30:00	MSFT	Stock	22.69	22.72	22.65	22.68	1994963.0
2006-07-18 12:00:00	MSFT	Stock	22.67	22.74	22.65	22.73	2233760.0
2006-07-18 12:30:00	MSFT	Stock	22.74	22.76	22.66	22.67	3418275.0
2006-07-18 13:00:00	MSFT	Stock	22.66	22.74	22.54	22.6	7548360.0
2006-07-18 13:30:00	MSFT	Stock	22.6	22.62	22.48	22.52	3678751.0
2006-07-18 14:00:00	MSFT	Stock	22.51	22.62	22.51	22.59	4011839.0
2006-07-18 14:30:00	MSFT	Stock	22.59	22.69	22.59	22.643	3698412.0
2006-07-18 15:00:00	MSFT	Stock	22.65	22.65	22.58	22.59	3454243.0
2006-07-18 15:30:00	MSFT	Stock	22.59	22.76	22.55	22.73	7996390.0
2006-07-18 16:00:00	MSFT	Stock	22.66	22.77	22.66	22.76	108391.0
2006-07-18 16:30:00	MSFT	Stock	22.74	22.74	22.6	22.69	40100.0
2006-07-18 17:00:00	MSFT	Stock	22.61	22.66	22.61	22.63	29300.0
2006-07-18 17:30:00	MSFT	Stock	22.64	22.64	22.56	22.57	44937.0
2006-07-18 18:00:00	MSFT	Stock	22.63	22.63	22.58	22.58	3800.0
2006-07-18 08:00:00	NVDA	Stock	0.298	0.308	0.298	0.308	1175400.0
2006-07-18 08:30:00	NVDA	Stock	0.3067	0.3083	0.3047	0.3075	5687700.0
2006-07-18 09:00:00	NVDA	Stock	0.3075	0.3092	0.305	0.3067	2579040.0
2006-07-18 09:30:00	NVDA	Stock	0.307	0.3162	0.3067	0.3077	109517040.0
2006-07-18 10:00:00	NVDA	Stock	0.3078	0.3085	0.3032	0.3045	69611700.0

> showing 50 of 49,202 rows — these rows as CSV

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