PREVIEW / stock_30min / 2010-11-22

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-22.parquet
  size:    1.4 MB
  rows:    74,054
  symbols: 3,521

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
2010-11-22 05:00:00	AAPL	Stock	10.9857	10.9857	10.9857	10.9857	2800.0
2010-11-22 05:30:00	AAPL	Stock	11.0	11.0	11.0	11.0	33600.0
2010-11-22 06:30:00	AAPL	Stock	10.9925	10.9925	10.9643	10.9643	39200.0
2010-11-22 07:00:00	AAPL	Stock	10.9639	10.9782	10.95	10.95	159936.0
2010-11-22 07:30:00	AAPL	Stock	10.9679	10.9782	10.9679	10.975	76104.0
2010-11-22 08:00:00	AAPL	Stock	10.975	11.0	10.9339	10.9411	1257928.0
2010-11-22 08:30:00	AAPL	Stock	10.9429	10.9461	10.9339	10.9418	155568.0
2010-11-22 09:00:00	AAPL	Stock	10.9393	10.9464	10.9164	10.9461	1152144.0
2010-11-22 09:30:00	AAPL	Stock	10.9454	11.1018	10.9239	11.0907	60147696.0
2010-11-22 10:00:00	AAPL	Stock	11.0893	11.0939	11.0314	11.0314	39898404.0
2010-11-22 10:30:00	AAPL	Stock	11.0311	11.0389	10.9946	11.025	30710988.0
2010-11-22 11:00:00	AAPL	Stock	11.0227	11.0461	10.9911	11.0451	19949076.0
2010-11-22 11:30:00	AAPL	Stock	11.0446	11.06	11.0254	11.0534	13366584.0
2010-11-22 12:00:00	AAPL	Stock	11.053	11.0582	11.0	11.0025	21658896.0
2010-11-22 12:30:00	AAPL	Stock	11.0004	11.0075	10.9721	11.0021	26170648.0
2010-11-22 13:00:00	AAPL	Stock	11.0021	11.0143	10.9804	10.9993	12610920.0
2010-11-22 13:30:00	AAPL	Stock	11.0011	11.0385	11.0	11.0311	13653136.0
2010-11-22 14:00:00	AAPL	Stock	11.0293	11.07	11.0236	11.0482	17486644.0
2010-11-22 14:30:00	AAPL	Stock	11.0482	11.0975	11.0436	11.0968	27543600.0
2010-11-22 15:00:00	AAPL	Stock	11.0975	11.105	11.0796	11.0857	24133676.0
2010-11-22 15:30:00	AAPL	Stock	11.0893	11.1914	11.0732	11.1914	64021888.0
2010-11-22 16:00:00	AAPL	Stock	11.1914	11.2068	10.9405	11.2046	11418316.0
2010-11-22 16:30:00	AAPL	Stock	11.1993	11.2036	11.0877	11.2014	366016.0
2010-11-22 17:00:00	AAPL	Stock	11.2014	11.2129	11.2011	11.2086	716716.0
2010-11-22 17:30:00	AAPL	Stock	11.2086	11.2107	11.2046	11.2104	177884.0
2010-11-22 18:00:00	AAPL	Stock	11.2104	11.2104	11.1914	11.2071	300104.0
2010-11-22 18:30:00	AAPL	Stock	11.2071	11.2086	11.1893	11.1943	488292.0
2010-11-22 19:00:00	AAPL	Stock	11.1957	11.1957	11.1857	11.1914	246456.0
2010-11-22 19:30:00	AAPL	Stock	11.1904	11.1946	11.1857	11.1857	370160.0
2010-11-22 06:00:00	MSFT	Stock	25.85	25.85	25.65	25.85	1100.0
2010-11-22 06:30:00	MSFT	Stock	25.91	25.91	25.91	25.91	100.0
2010-11-22 08:00:00	MSFT	Stock	25.74	25.74	25.66	25.66	10905.0
2010-11-22 08:30:00	MSFT	Stock	25.67	25.68	25.66	25.68	7200.0
2010-11-22 09:00:00	MSFT	Stock	25.67	25.67	25.63	25.64	26078.0
2010-11-22 09:30:00	MSFT	Stock	25.65	25.7	25.51	25.67	4036807.0
2010-11-22 10:00:00	MSFT	Stock	25.67	25.72	25.63	25.65	4034230.0
2010-11-22 10:30:00	MSFT	Stock	25.64	25.642	25.55	25.58	3750614.0
2010-11-22 11:00:00	MSFT	Stock	25.58	25.59	25.52	25.56	4329195.0
2010-11-22 11:30:00	MSFT	Stock	25.565	25.615	25.54	25.61	1786128.0
2010-11-22 12:00:00	MSFT	Stock	25.605	25.61	25.52	25.52	3417518.0
2010-11-22 12:30:00	MSFT	Stock	25.52	25.54	25.49	25.5	5257794.0
2010-11-22 13:00:00	MSFT	Stock	25.5	25.51	25.44	25.486	3699760.0
2010-11-22 13:30:00	MSFT	Stock	25.485	25.56	25.48	25.55	2514062.0
2010-11-22 14:00:00	MSFT	Stock	25.55	25.59	25.53	25.57	2530145.0
2010-11-22 14:30:00	MSFT	Stock	25.57	25.7	25.56	25.665	2545887.0
2010-11-22 15:00:00	MSFT	Stock	25.67	25.68	25.59	25.6	4100660.0
2010-11-22 15:30:00	MSFT	Stock	25.6	25.74	25.6	25.74	5871759.0
2010-11-22 16:00:00	MSFT	Stock	25.74	25.93	25.587	25.76	3353452.0
2010-11-22 16:30:00	MSFT	Stock	25.689	25.77	25.605	25.77	2400.0
2010-11-22 17:00:00	MSFT	Stock	25.78	25.78	25.76	25.77	4300.0

> showing 50 of 74,054 rows — these rows as CSV

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