PREVIEW / stock_30min / 2009-10-27

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-10-27.parquet
  size:    1.3 MB
  rows:    71,661
  symbols: 3,405

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
2009-10-27 04:00:00	AAPL	Stock	7.2139	7.2139	7.2139	7.2139	2800.0
2009-10-27 06:00:00	AAPL	Stock	7.2089	7.2089	7.2089	7.2089	5600.0
2009-10-27 07:00:00	AAPL	Stock	7.2143	7.2143	7.1825	7.2136	127708.0
2009-10-27 07:30:00	AAPL	Stock	7.2132	7.2132	7.1982	7.1982	19600.0
2009-10-27 08:00:00	AAPL	Stock	7.2125	7.2218	7.2	7.2	422100.0
2009-10-27 08:30:00	AAPL	Stock	7.2	7.2046	7.1961	7.1964	378112.0
2009-10-27 09:00:00	AAPL	Stock	7.1968	7.2118	7.1964	7.1975	541604.0
2009-10-27 09:30:00	AAPL	Stock	7.2021	7.2432	7.1386	7.1464	73272416.0
2009-10-27 10:00:00	AAPL	Stock	7.1368	7.1536	7.0304	7.1261	136461780.0
2009-10-27 10:30:00	AAPL	Stock	7.1243	7.1686	7.1164	7.1425	57413020.0
2009-10-27 11:00:00	AAPL	Stock	7.1425	7.1432	7.0921	7.1321	32049780.0
2009-10-27 11:30:00	AAPL	Stock	7.1318	7.1336	7.1046	7.1179	21816816.0
2009-10-27 12:00:00	AAPL	Stock	7.1179	7.1275	7.1039	7.1089	16903348.0
2009-10-27 12:30:00	AAPL	Stock	7.1089	7.1164	7.0864	7.0868	22854580.0
2009-10-27 13:00:00	AAPL	Stock	7.0868	7.1016	7.0304	7.0404	51785860.0
2009-10-27 13:30:00	AAPL	Stock	7.0404	7.0768	7.0357	7.0546	31897180.0
2009-10-27 14:00:00	AAPL	Stock	7.0557	7.0768	7.04	7.0611	33240760.0
2009-10-27 14:30:00	AAPL	Stock	7.0621	7.0786	7.0354	7.0654	51309104.0
2009-10-27 15:00:00	AAPL	Stock	7.0654	7.075	7.0539	7.0642	31127348.0
2009-10-27 15:30:00	AAPL	Stock	7.0643	7.0768	7.0161	7.0493	76758612.0
2009-10-27 16:00:00	AAPL	Stock	7.0457	7.1044	7.0332	7.0464	10778264.0
2009-10-27 16:30:00	AAPL	Stock	7.0464	7.0536	7.0411	7.0536	294252.0
2009-10-27 17:00:00	AAPL	Stock	7.0536	7.2314	7.0493	7.0536	296548.0
2009-10-27 17:30:00	AAPL	Stock	7.0564	7.0714	7.0564	7.0671	475860.0
2009-10-27 18:00:00	AAPL	Stock	7.0675	7.0679	7.0396	7.0661	1336356.0
2009-10-27 18:30:00	AAPL	Stock	7.065	7.0679	7.0618	7.0679	89432.0
2009-10-27 19:00:00	AAPL	Stock	7.0679	7.0686	7.065	7.0679	72800.0
2009-10-27 19:30:00	AAPL	Stock	7.0679	7.0739	7.0679	7.0739	117152.0
2009-10-27 20:00:00	AAPL	Stock	7.2314	7.2314	7.2314	7.2314	473200.0
2009-10-27 07:30:00	MSFT	Stock	28.58	28.58	28.58	28.58	500.0
2009-10-27 08:00:00	MSFT	Stock	28.58	28.65	28.53	28.54	15370.0
2009-10-27 08:30:00	MSFT	Stock	28.57	28.65	28.57	28.59	14797.0
2009-10-27 09:00:00	MSFT	Stock	28.68	28.78	28.67	28.73	38791.0
2009-10-27 09:30:00	MSFT	Stock	28.73	28.88	28.62	28.73	8131939.0
2009-10-27 10:00:00	MSFT	Stock	28.73	28.74	28.45	28.68	10133603.0
2009-10-27 10:30:00	MSFT	Stock	28.67	28.78	28.59	28.67	5436073.0
2009-10-27 11:00:00	MSFT	Stock	28.66	28.68	28.48	28.68	3931941.0
2009-10-27 11:30:00	MSFT	Stock	28.68	28.75	28.61	28.685	3156990.0
2009-10-27 12:00:00	MSFT	Stock	28.69	28.72	28.55	28.57	1856704.0
2009-10-27 12:30:00	MSFT	Stock	28.57	28.63	28.55	28.58	2552381.0
2009-10-27 13:00:00	MSFT	Stock	28.58	28.62	28.48	28.51	4547659.0
2009-10-27 13:30:00	MSFT	Stock	28.51	28.59	28.51	28.55	3304358.0
2009-10-27 14:00:00	MSFT	Stock	28.55	28.57	28.47	28.52	3604888.0
2009-10-27 14:30:00	MSFT	Stock	28.52	28.68	28.44	28.65	3464067.0
2009-10-27 15:00:00	MSFT	Stock	28.65	28.66	28.56	28.6	3436970.0
2009-10-27 15:30:00	MSFT	Stock	28.59	28.65	28.485	28.61	10631590.0
2009-10-27 16:00:00	MSFT	Stock	28.61	28.75	28.54	28.54	2443431.0
2009-10-27 16:30:00	MSFT	Stock	28.54	28.59	28.54	28.59	1100.0
2009-10-27 17:00:00	MSFT	Stock	28.68	28.73	28.5	28.59	5498.0
2009-10-27 17:30:00	MSFT	Stock	28.54	28.54	28.53	28.54	500.0

> showing 50 of 71,661 rows — these rows as CSV

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