PREVIEW / stock_30min / 2007-07-03

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-03.parquet
  size:    730 KB
  rows:    36,489
  symbols: 2,990

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
2007-07-03 09:30:00	AAPL	Stock	4.3571	4.3746	4.3393	4.3725	126419692.0
2007-07-03 10:00:00	AAPL	Stock	4.3721	4.4896	4.3661	4.4798	311606176.0
2007-07-03 10:30:00	AAPL	Stock	4.4789	4.5443	4.4571	4.5296	228842040.0
2007-07-03 11:00:00	AAPL	Stock	4.5296	4.5343	4.5036	4.505	133756644.0
2007-07-03 11:30:00	AAPL	Stock	4.5046	4.5321	4.4946	4.5243	92333948.0
2007-07-03 12:00:00	AAPL	Stock	4.5239	4.5357	4.5054	4.5336	83758556.0
2007-07-03 12:30:00	AAPL	Stock	4.5336	4.55	4.5304	4.5407	143382008.0
2007-07-03 13:00:00	AAPL	Stock	4.5418	4.5421	4.5404	4.5418	7394492.0
2007-07-03 09:30:00	MSFT	Stock	29.785	30.0	29.78	29.99	8846050.0
2007-07-03 10:00:00	MSFT	Stock	29.98	30.13	29.97	30.11	5952746.0
2007-07-03 10:30:00	MSFT	Stock	30.12	30.22	30.07	30.11	3436977.0
2007-07-03 11:00:00	MSFT	Stock	30.1	30.12	30.04	30.05	2651842.0
2007-07-03 11:30:00	MSFT	Stock	30.05	30.08	30.03	30.05	2049422.0
2007-07-03 12:00:00	MSFT	Stock	30.04	30.13	30.03	30.09	2158738.0
2007-07-03 12:30:00	MSFT	Stock	30.09	30.11	29.99	30.04	3437339.0
2007-07-03 13:00:00	MSFT	Stock	30.02	30.02	30.02	30.02	837275.0
2007-07-03 08:00:00	NVDA	Stock	0.7213	0.7213	0.7213	0.7213	36000.0
2007-07-03 08:30:00	NVDA	Stock	0.7213	0.7213	0.7213	0.7213	18000.0
2007-07-03 09:00:00	NVDA	Stock	0.7213	0.7213	0.7167	0.7167	233580.0
2007-07-03 09:30:00	NVDA	Stock	0.7168	0.7238	0.7108	0.7238	49248780.0
2007-07-03 10:00:00	NVDA	Stock	0.7238	0.724	0.719	0.72	33586500.0
2007-07-03 10:30:00	NVDA	Stock	0.7199	0.72	0.7152	0.7152	30717060.0
2007-07-03 11:00:00	NVDA	Stock	0.715	0.7165	0.7128	0.713	27134280.0
2007-07-03 11:30:00	NVDA	Stock	0.713	0.7168	0.7125	0.7163	33752700.0
2007-07-03 12:00:00	NVDA	Stock	0.7163	0.7177	0.716	0.7177	19543620.0
2007-07-03 12:30:00	NVDA	Stock	0.7176	0.7183	0.717	0.7183	36184020.0
2007-07-03 13:00:00	NVDA	Stock	0.7178	0.7183	0.7178	0.7183	3094080.0
2007-07-03 08:00:00	AMZN	Stock	3.4945	3.4945	3.4945	3.4945	10000.0
2007-07-03 08:30:00	AMZN	Stock	3.4805	3.4895	3.4805	3.4895	54320.0
2007-07-03 09:00:00	AMZN	Stock	3.4925	3.5095	3.4925	3.5	387940.0
2007-07-03 09:30:00	AMZN	Stock	3.502	3.5025	3.467	3.4845	9826400.0
2007-07-03 10:00:00	AMZN	Stock	3.4845	3.486	3.4675	3.4755	9324080.0
2007-07-03 10:30:00	AMZN	Stock	3.4755	3.476	3.453	3.453	5682600.0
2007-07-03 11:00:00	AMZN	Stock	3.453	3.4625	3.451	3.461	4402360.0
2007-07-03 11:30:00	AMZN	Stock	3.461	3.469	3.455	3.463	3769320.0
2007-07-03 12:00:00	AMZN	Stock	3.4635	3.47	3.459	3.463	3259000.0
2007-07-03 12:30:00	AMZN	Stock	3.4635	3.4725	3.4605	3.4725	5253740.0
2007-07-03 13:00:00	AMZN	Stock	3.4725	3.4725	3.4725	3.4725	1431660.0
2007-07-03 16:00:00	AMZN	Stock	3.4725	3.4725	3.4725	3.4725	3000.0
2007-07-03 09:30:00	TLT	Stock	85.25	85.34	85.15	85.25	202400.0
2007-07-03 10:00:00	TLT	Stock	85.26	85.34	85.12	85.13	130500.0
2007-07-03 10:30:00	TLT	Stock	85.13	85.13	84.85	84.85	66045.0
2007-07-03 11:00:00	TLT	Stock	84.84	84.9	84.76	84.78	307830.0
2007-07-03 11:30:00	TLT	Stock	84.8	84.88	84.75	84.76	223100.0
2007-07-03 12:00:00	TLT	Stock	84.75	84.78	84.71	84.73	255700.0
2007-07-03 12:30:00	TLT	Stock	84.74	84.8	84.72	84.75	90300.0
2007-07-03 13:00:00	TLT	Stock	84.75	84.77	84.72	84.77	76300.0
2007-07-03 09:30:00	CL	Stock	32.7	32.745	32.645	32.72	400000.0
2007-07-03 10:00:00	CL	Stock	32.715	32.725	32.65	32.715	705800.0
2007-07-03 10:30:00	CL	Stock	32.7	32.735	32.695	32.735	207000.0

> showing 50 of 36,489 rows — these rows as CSV

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