PREVIEW / stock_30min / 2008-04-17

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-17.parquet
  size:    1.2 MB
  rows:    68,254
  symbols: 3,287

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-04-17 05:00:00	AAPL	Stock	5.5357	5.5357	5.5357	5.5357	15680.0
2008-04-17 06:00:00	AAPL	Stock	5.4896	5.4957	5.4896	5.4957	5600.0
2008-04-17 06:30:00	AAPL	Stock	5.5011	5.5011	5.5011	5.5011	2800.0
2008-04-17 07:00:00	AAPL	Stock	5.4896	5.4896	5.4861	5.4879	19600.0
2008-04-17 07:30:00	AAPL	Stock	5.4946	5.5096	5.4946	5.5089	168000.0
2008-04-17 08:00:00	AAPL	Stock	5.5082	5.5179	5.4893	5.4929	1610812.0
2008-04-17 08:30:00	AAPL	Stock	5.4929	5.4964	5.4732	5.4739	1331652.0
2008-04-17 09:00:00	AAPL	Stock	5.4739	5.5046	5.4729	5.5046	2472316.0
2008-04-17 09:30:00	AAPL	Stock	5.5054	5.5529	5.4768	5.5357	120495788.0
2008-04-17 10:00:00	AAPL	Stock	5.5357	5.5632	5.5107	5.5525	90597836.0
2008-04-17 10:30:00	AAPL	Stock	5.5532	5.5714	5.5304	5.5389	59947776.0
2008-04-17 11:00:00	AAPL	Stock	5.5382	5.5496	5.515	5.525	45318392.0
2008-04-17 11:30:00	AAPL	Stock	5.5243	5.5382	5.5079	5.5257	43267084.0
2008-04-17 12:00:00	AAPL	Stock	5.525	5.5321	5.5093	5.5104	22506988.0
2008-04-17 12:30:00	AAPL	Stock	5.5102	5.5339	5.4911	5.5311	35749476.0
2008-04-17 13:00:00	AAPL	Stock	5.5318	5.5393	5.5143	5.5271	32790576.0
2008-04-17 13:30:00	AAPL	Stock	5.5268	5.5293	5.5036	5.5082	32104464.0
2008-04-17 14:00:00	AAPL	Stock	5.5082	5.515	5.4993	5.5069	30986144.0
2008-04-17 14:30:00	AAPL	Stock	5.5059	5.5343	5.4979	5.5029	42062104.0
2008-04-17 15:00:00	AAPL	Stock	5.5043	5.5625	5.4989	5.5204	51187388.0
2008-04-17 15:30:00	AAPL	Stock	5.5204	5.5371	5.5114	5.5196	64074360.0
2008-04-17 16:00:00	AAPL	Stock	5.5171	5.6171	5.5095	5.5964	13000484.0
2008-04-17 16:30:00	AAPL	Stock	5.5964	5.625	5.5209	5.62	2657200.0
2008-04-17 17:00:00	AAPL	Stock	5.6161	5.6271	5.6	5.6161	1396808.0
2008-04-17 17:30:00	AAPL	Stock	5.6111	5.6139	5.5187	5.6107	1209852.0
2008-04-17 18:00:00	AAPL	Stock	5.6114	5.6225	5.6082	5.6143	822052.0
2008-04-17 18:30:00	AAPL	Stock	5.6143	5.6143	5.6107	5.6125	168840.0
2008-04-17 19:00:00	AAPL	Stock	5.6071	5.6107	5.6071	5.6107	180824.0
2008-04-17 19:30:00	AAPL	Stock	5.6107	5.6214	5.6107	5.6161	342748.0
2008-04-17 07:00:00	MSFT	Stock	29.07	29.1	29.07	29.1	2700.0
2008-04-17 07:30:00	MSFT	Stock	29.1	29.1	29.07	29.07	4300.0
2008-04-17 08:00:00	MSFT	Stock	29.1	29.2	28.98	29.12	60577.0
2008-04-17 08:30:00	MSFT	Stock	29.08	29.09	28.99	28.99	6750.0
2008-04-17 09:00:00	MSFT	Stock	28.99	29.11	28.91	29.11	75204.0
2008-04-17 09:30:00	MSFT	Stock	29.11	29.21	28.9	29.0	5348938.0
2008-04-17 10:00:00	MSFT	Stock	29.0	29.1	28.92	29.058	4437704.0
2008-04-17 10:30:00	MSFT	Stock	29.05	29.09	29.0	29.02	2648177.0
2008-04-17 11:00:00	MSFT	Stock	29.01	29.05	28.9	28.95	2244092.0
2008-04-17 11:30:00	MSFT	Stock	28.94	29.069	28.91	29.069	3558781.0
2008-04-17 12:00:00	MSFT	Stock	29.06	29.07	28.98	29.03	1553128.0
2008-04-17 12:30:00	MSFT	Stock	29.03	29.08	29.02	29.048	2076272.0
2008-04-17 13:00:00	MSFT	Stock	29.04	29.14	29.02	29.13	2552969.0
2008-04-17 13:30:00	MSFT	Stock	29.13	29.18	29.08	29.135	2604465.0
2008-04-17 14:00:00	MSFT	Stock	29.14	29.17	29.09	29.16	2165115.0
2008-04-17 14:30:00	MSFT	Stock	29.17	29.25	29.15	29.18	3310237.0
2008-04-17 15:00:00	MSFT	Stock	29.18	29.29	29.17	29.24	4959372.0
2008-04-17 15:30:00	MSFT	Stock	29.24	29.34	29.22	29.24	7085079.0
2008-04-17 16:00:00	MSFT	Stock	29.23	29.44	29.112	29.43	2270019.0
2008-04-17 16:30:00	MSFT	Stock	29.015	29.66	29.015	29.55	119259.0
2008-04-17 17:00:00	MSFT	Stock	29.6	29.6	29.45	29.55	411232.0

> showing 50 of 68,254 rows — these rows as CSV

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