PREVIEW / stock_30min / 2009-06-17

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-06-17.parquet
  size:    1.3 MB
  rows:    69,972
  symbols: 3,329

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-06-17 05:30:00	AAPL	Stock	4.8636	4.8636	4.8636	4.8636	16800.0
2009-06-17 06:30:00	AAPL	Stock	4.8536	4.8536	4.8536	4.8536	5600.0
2009-06-17 07:00:00	AAPL	Stock	4.8571	4.8768	4.8571	4.8768	31080.0
2009-06-17 07:30:00	AAPL	Stock	4.8804	4.8854	4.8571	4.8571	152768.0
2009-06-17 08:00:00	AAPL	Stock	4.8679	4.875	4.8607	4.875	198100.0
2009-06-17 08:30:00	AAPL	Stock	4.8768	4.8968	4.875	4.8968	334068.0
2009-06-17 09:00:00	AAPL	Stock	4.8929	4.8964	4.8696	4.8793	1670004.0
2009-06-17 09:30:00	AAPL	Stock	4.8796	4.9089	4.8046	4.8104	113304464.0
2009-06-17 10:00:00	AAPL	Stock	4.8104	4.87	4.8075	4.8496	57864520.0
2009-06-17 10:30:00	AAPL	Stock	4.8489	4.8496	4.8075	4.8368	41515208.0
2009-06-17 11:00:00	AAPL	Stock	4.8364	4.8892	4.8346	4.8779	46960340.0
2009-06-17 11:30:00	AAPL	Stock	4.8793	4.8793	4.8536	4.865	30169356.0
2009-06-17 12:00:00	AAPL	Stock	4.8652	4.8882	4.8607	4.8743	29874572.0
2009-06-17 12:30:00	AAPL	Stock	4.8739	4.8761	4.8629	4.8711	20507676.0
2009-06-17 13:00:00	AAPL	Stock	4.8704	4.8814	4.8604	4.8768	17341408.0
2009-06-17 13:30:00	AAPL	Stock	4.8768	4.8864	4.8707	4.8789	32857972.0
2009-06-17 14:00:00	AAPL	Stock	4.8789	4.8836	4.8654	4.8832	21691684.0
2009-06-17 14:30:00	AAPL	Stock	4.8839	4.8868	4.8514	4.8621	31099264.0
2009-06-17 15:00:00	AAPL	Stock	4.8625	4.875	4.8471	4.8471	44910992.0
2009-06-17 15:30:00	AAPL	Stock	4.8489	4.8546	4.8368	4.8446	56150416.0
2009-06-17 16:00:00	AAPL	Stock	4.8407	4.8857	4.8382	4.8421	17438680.0
2009-06-17 16:30:00	AAPL	Stock	4.8443	4.8555	4.8411	4.845	317044.0
2009-06-17 17:00:00	AAPL	Stock	4.8446	4.8555	4.8421	4.8429	765828.0
2009-06-17 17:30:00	AAPL	Stock	4.8653	4.8653	4.8421	4.8421	119980.0
2009-06-17 18:00:00	AAPL	Stock	4.8432	4.8457	4.8414	4.8457	502236.0
2009-06-17 18:30:00	AAPL	Stock	4.8446	4.8496	4.8425	4.8446	170688.0
2009-06-17 19:00:00	AAPL	Stock	4.8446	4.8464	4.8386	4.8464	55104.0
2009-06-17 19:30:00	AAPL	Stock	4.8464	4.8507	4.8464	4.8507	125972.0
2009-06-17 05:00:00	MSFT	Stock	23.57	23.57	23.57	23.57	1000.0
2009-06-17 05:30:00	MSFT	Stock	23.55	23.65	23.55	23.65	1400.0
2009-06-17 06:00:00	MSFT	Stock	23.65	23.65	23.56	23.56	1300.0
2009-06-17 06:30:00	MSFT	Stock	23.55	23.55	23.55	23.55	200.0
2009-06-17 07:30:00	MSFT	Stock	23.5	23.5	23.45	23.45	4475.0
2009-06-17 08:00:00	MSFT	Stock	23.47	23.59	23.46	23.54	17515.0
2009-06-17 08:30:00	MSFT	Stock	23.54	23.58	23.5	23.58	21524.0
2009-06-17 09:00:00	MSFT	Stock	23.53	23.6	23.46	23.56	37560.0
2009-06-17 09:30:00	MSFT	Stock	23.52	23.57	23.25	23.295	12903753.0
2009-06-17 10:00:00	MSFT	Stock	23.29	23.39	23.27	23.34	8241081.0
2009-06-17 10:30:00	MSFT	Stock	23.34	23.35	23.17	23.225	6726036.0
2009-06-17 11:00:00	MSFT	Stock	23.22	23.46	23.2	23.412	5612702.0
2009-06-17 11:30:00	MSFT	Stock	23.417	23.45	23.33	23.421	3728321.0
2009-06-17 12:00:00	MSFT	Stock	23.43	23.54	23.39	23.45	4938370.0
2009-06-17 12:30:00	MSFT	Stock	23.45	23.53	23.43	23.509	3459944.0
2009-06-17 13:00:00	MSFT	Stock	23.5	23.7	23.5	23.698	4887474.0
2009-06-17 13:30:00	MSFT	Stock	23.7	23.82	23.67	23.72	6255154.0
2009-06-17 14:00:00	MSFT	Stock	23.72	23.82	23.68	23.761	4744392.0
2009-06-17 14:30:00	MSFT	Stock	23.77	23.77	23.6	23.7	4090608.0
2009-06-17 15:00:00	MSFT	Stock	23.7	23.79	23.62	23.63	5975471.0
2009-06-17 15:30:00	MSFT	Stock	23.62	23.77	23.6	23.67	10027122.0
2009-06-17 16:00:00	MSFT	Stock	23.71	23.74	23.332	23.509	2686287.0

> showing 50 of 69,972 rows — these rows as CSV

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