PREVIEW / stock_30min / 2008-09-23

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-09-23.parquet
  size:    1.2 MB
  rows:    69,261
  symbols: 3,346

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
2008-09-23 06:30:00	AAPL	Stock	4.6786	4.6786	4.6786	4.6786	5600.0
2008-09-23 07:30:00	AAPL	Stock	4.6857	4.6857	4.6857	4.6857	2800.0
2008-09-23 08:00:00	AAPL	Stock	4.6821	4.7032	4.6682	4.6729	1107232.0
2008-09-23 08:30:00	AAPL	Stock	4.6739	4.7061	4.6625	4.7054	1099616.0
2008-09-23 09:00:00	AAPL	Stock	4.7071	4.7386	4.6968	4.7082	2079924.0
2008-09-23 09:30:00	AAPL	Stock	4.7068	4.7946	4.6711	4.7739	146120408.0
2008-09-23 10:00:00	AAPL	Stock	4.7733	4.8461	4.7546	4.8214	108186932.0
2008-09-23 10:30:00	AAPL	Stock	4.8214	4.85	4.7521	4.7639	90805036.0
2008-09-23 11:00:00	AAPL	Stock	4.7646	4.8304	4.7414	4.7907	71967168.0
2008-09-23 11:30:00	AAPL	Stock	4.79	4.8079	4.7482	4.7543	45880100.0
2008-09-23 12:00:00	AAPL	Stock	4.7543	4.8393	4.7143	4.715	55606964.0
2008-09-23 12:30:00	AAPL	Stock	4.7154	4.7275	4.6664	4.6879	64751316.0
2008-09-23 13:00:00	AAPL	Stock	4.6882	4.6896	4.5957	4.6189	106228164.0
2008-09-23 13:30:00	AAPL	Stock	4.6196	4.63	4.5586	4.6214	94606260.0
2008-09-23 14:00:00	AAPL	Stock	4.6232	4.685	4.5964	4.6738	104206816.0
2008-09-23 14:30:00	AAPL	Stock	4.6739	4.7071	4.6332	4.6696	102611460.0
2008-09-23 15:00:00	AAPL	Stock	4.6693	4.7143	4.65	4.6757	111747412.0
2008-09-23 15:30:00	AAPL	Stock	4.6757	4.6882	4.5236	4.5296	149183384.0
2008-09-23 16:00:00	AAPL	Stock	4.5304	4.6953	4.5239	4.53	9584148.0
2008-09-23 16:30:00	AAPL	Stock	4.5311	4.5461	4.53	4.5446	10379908.0
2008-09-23 17:00:00	AAPL	Stock	4.5425	4.5425	4.5357	4.5357	405272.0
2008-09-23 17:30:00	AAPL	Stock	4.5357	4.5936	4.5357	4.5936	964684.0
2008-09-23 18:00:00	AAPL	Stock	4.5929	4.6268	4.59	4.5929	1377656.0
2008-09-23 18:30:00	AAPL	Stock	4.5964	4.6246	4.5964	4.6089	812980.0
2008-09-23 19:00:00	AAPL	Stock	4.6071	4.6304	4.6036	4.6186	500948.0
2008-09-23 19:30:00	AAPL	Stock	4.6193	4.6318	4.6036	4.6079	800996.0
2008-09-23 07:00:00	MSFT	Stock	25.52	25.52	25.52	25.52	700.0
2008-09-23 07:30:00	MSFT	Stock	25.52	25.6	25.41	25.52	5150.0
2008-09-23 08:00:00	MSFT	Stock	25.51	25.7	25.5	25.59	64199.0
2008-09-23 08:30:00	MSFT	Stock	25.6	25.65	25.55	25.6	22696.0
2008-09-23 09:00:00	MSFT	Stock	25.64	25.75	25.6	25.68	56196.0
2008-09-23 09:30:00	MSFT	Stock	25.63	25.91	25.55	25.82	7157244.0
2008-09-23 10:00:00	MSFT	Stock	25.83	26.17	25.79	26.09	7624252.0
2008-09-23 10:30:00	MSFT	Stock	26.082	26.15	25.81	25.87	4695540.0
2008-09-23 11:00:00	MSFT	Stock	25.86	26.12	25.8	26.0	4817480.0
2008-09-23 11:30:00	MSFT	Stock	26.0	26.06	25.93	25.992	4247144.0
2008-09-23 12:00:00	MSFT	Stock	25.998	26.07	25.94	26.032	3024976.0
2008-09-23 12:30:00	MSFT	Stock	26.035	26.06	25.92	25.94	3772553.0
2008-09-23 13:00:00	MSFT	Stock	25.93	25.94	25.68	25.78	5306446.0
2008-09-23 13:30:00	MSFT	Stock	25.78	25.8	25.51	25.65	4244743.0
2008-09-23 14:00:00	MSFT	Stock	25.64	25.86	25.57	25.84	5128657.0
2008-09-23 14:30:00	MSFT	Stock	25.84	25.99	25.73	25.85	6480034.0
2008-09-23 15:00:00	MSFT	Stock	25.84	26.07	25.81	25.88	5864228.0
2008-09-23 15:30:00	MSFT	Stock	25.89	25.94	25.34	25.49	9273591.0
2008-09-23 16:00:00	MSFT	Stock	25.48	26.032	25.4	25.44	2662892.0
2008-09-23 16:30:00	MSFT	Stock	25.44	25.49	25.38	25.48	967464.0
2008-09-23 17:00:00	MSFT	Stock	25.47	25.53	25.44	25.5	12738.0
2008-09-23 17:30:00	MSFT	Stock	25.52	25.89	25.52	25.85	63394.0
2008-09-23 18:00:00	MSFT	Stock	25.85	25.9	25.7	25.77	41468.0
2008-09-23 18:30:00	MSFT	Stock	25.77	25.9	25.75	25.78	28001.0

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

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