PREVIEW / stock_30min / 2008-04-28

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-28.parquet
  size:    1.2 MB
  rows:    68,020
  symbols: 3,283

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-28 05:30:00	AAPL	Stock	6.1018	6.1018	6.1018	6.1018	5600.0
2008-04-28 06:30:00	AAPL	Stock	6.11	6.11	6.11	6.11	2800.0
2008-04-28 07:00:00	AAPL	Stock	6.1089	6.1161	6.1071	6.1071	74480.0
2008-04-28 07:30:00	AAPL	Stock	6.1071	6.1071	6.0893	6.1071	133504.0
2008-04-28 08:00:00	AAPL	Stock	6.1086	6.1086	6.0625	6.0789	2281804.0
2008-04-28 08:30:00	AAPL	Stock	6.08	6.1	6.0789	6.0861	1181404.0
2008-04-28 09:00:00	AAPL	Stock	6.0879	6.0896	6.0604	6.0632	1445808.0
2008-04-28 09:30:00	AAPL	Stock	6.0636	6.1207	6.0404	6.1036	114076396.0
2008-04-28 10:00:00	AAPL	Stock	6.1029	6.1246	6.0721	6.0982	72402176.0
2008-04-28 10:30:00	AAPL	Stock	6.0982	6.1446	6.0964	6.1386	71706292.0
2008-04-28 11:00:00	AAPL	Stock	6.1389	6.1518	6.1021	6.1229	59996972.0
2008-04-28 11:30:00	AAPL	Stock	6.1221	6.1511	6.1147	6.1271	43392608.0
2008-04-28 12:00:00	AAPL	Stock	6.1268	6.1411	6.1214	6.1364	30068108.0
2008-04-28 12:30:00	AAPL	Stock	6.1368	6.1682	6.1346	6.1554	60626104.0
2008-04-28 13:00:00	AAPL	Stock	6.1568	6.1918	6.1564	6.1911	53465132.0
2008-04-28 13:30:00	AAPL	Stock	6.1914	6.2054	6.1811	6.1932	48938344.0
2008-04-28 14:00:00	AAPL	Stock	6.1939	6.1989	6.1682	6.1725	36108464.0
2008-04-28 14:30:00	AAPL	Stock	6.1725	6.1957	6.1661	6.1804	44044924.0
2008-04-28 15:00:00	AAPL	Stock	6.1806	6.1882	6.1532	6.1582	48406792.0
2008-04-28 15:30:00	AAPL	Stock	6.1586	6.1736	6.1421	6.1518	74987360.0
2008-04-28 16:00:00	AAPL	Stock	6.1518	6.1631	6.1355	6.1518	9470608.0
2008-04-28 16:30:00	AAPL	Stock	6.1514	6.1532	6.1486	6.15	337036.0
2008-04-28 17:00:00	AAPL	Stock	6.15	6.1518	6.1404	6.1482	356132.0
2008-04-28 17:30:00	AAPL	Stock	6.1514	6.1514	6.1486	6.1486	656096.0
2008-04-28 18:00:00	AAPL	Stock	6.1486	6.1486	6.1393	6.1393	190848.0
2008-04-28 18:30:00	AAPL	Stock	6.1411	6.1425	6.1389	6.1389	109788.0
2008-04-28 19:00:00	AAPL	Stock	6.1393	6.1429	6.1364	6.1411	91476.0
2008-04-28 19:30:00	AAPL	Stock	6.1418	6.1479	6.1404	6.1414	45920.0
2008-04-28 20:00:00	AAPL	Stock	6.1139	6.1139	6.1139	6.1139	117600.0
2008-04-28 07:00:00	MSFT	Stock	29.95	30.09	29.9	29.93	2900.0
2008-04-28 07:30:00	MSFT	Stock	29.9	29.9	29.9	29.9	500.0
2008-04-28 08:00:00	MSFT	Stock	29.9	29.99	29.8	29.9	59213.0
2008-04-28 08:30:00	MSFT	Stock	29.88	29.92	29.87	29.87	22729.0
2008-04-28 09:00:00	MSFT	Stock	29.86	29.9	29.8	29.81	23878.0
2008-04-28 09:30:00	MSFT	Stock	29.81	29.835	29.4	29.505	9565740.0
2008-04-28 10:00:00	MSFT	Stock	29.51	29.51	29.31	29.32	7026175.0
2008-04-28 10:30:00	MSFT	Stock	29.33	29.45	29.28	29.401	5650093.0
2008-04-28 11:00:00	MSFT	Stock	29.41	29.45	29.28	29.3	4078728.0
2008-04-28 11:30:00	MSFT	Stock	29.3	29.55	29.21	29.21	5011026.0
2008-04-28 12:00:00	MSFT	Stock	29.21	29.22	29.05	29.13	7906491.0
2008-04-28 12:30:00	MSFT	Stock	29.13	29.15	29.07	29.108	4489158.0
2008-04-28 13:00:00	MSFT	Stock	29.1	29.2	29.07	29.165	5752767.0
2008-04-28 13:30:00	MSFT	Stock	29.16	29.2	29.13	29.15	6082481.0
2008-04-28 14:00:00	MSFT	Stock	29.15	29.16	29.09	29.1	5525290.0
2008-04-28 14:30:00	MSFT	Stock	29.1	29.14	29.01	29.07	7306997.0
2008-04-28 15:00:00	MSFT	Stock	29.07	29.08	28.86	28.88	9805569.0
2008-04-28 15:30:00	MSFT	Stock	28.87	29.03	28.82	28.95	14832559.0
2008-04-28 16:00:00	MSFT	Stock	28.95	29.216	28.93	28.93	2417920.0
2008-04-28 16:30:00	MSFT	Stock	28.92	29.186	28.92	28.95	28970.0
2008-04-28 17:00:00	MSFT	Stock	28.94	29.186	28.93	28.95	19405.0

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

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