PREVIEW / stock_30min / 2007-12-27

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-27.parquet
  size:    1.2 MB
  rows:    70,940
  symbols: 3,260

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
2007-12-27 04:00:00	AAPL	Stock	7.0982	7.0982	7.0982	7.0982	2800.0
2007-12-27 07:00:00	AAPL	Stock	7.1179	7.1339	7.1179	7.1339	88732.0
2007-12-27 07:30:00	AAPL	Stock	7.1357	7.1429	7.1214	7.1268	216580.0
2007-12-27 08:00:00	AAPL	Stock	7.1268	7.1475	7.1071	7.1179	2526552.0
2007-12-27 08:30:00	AAPL	Stock	7.1179	7.1211	7.0804	7.1204	2849504.0
2007-12-27 09:00:00	AAPL	Stock	7.1204	7.1221	7.0964	7.1068	1890280.0
2007-12-27 09:30:00	AAPL	Stock	7.1054	7.1757	7.0896	7.1404	104071464.0
2007-12-27 10:00:00	AAPL	Stock	7.1407	7.2486	7.1393	7.2271	124053944.0
2007-12-27 10:30:00	AAPL	Stock	7.2268	7.2446	7.19	7.1918	65865044.0
2007-12-27 11:00:00	AAPL	Stock	7.1925	7.2068	7.1561	7.2007	64382864.0
2007-12-27 11:30:00	AAPL	Stock	7.2014	7.2143	7.1804	7.2129	32060364.0
2007-12-27 12:00:00	AAPL	Stock	7.2129	7.2168	7.185	7.1864	30612260.0
2007-12-27 12:30:00	AAPL	Stock	7.1886	7.2032	7.1664	7.1893	33000016.0
2007-12-27 13:00:00	AAPL	Stock	7.1893	7.2114	7.1625	7.2064	30848244.0
2007-12-27 13:30:00	AAPL	Stock	7.2061	7.2096	7.1907	7.2029	21733208.0
2007-12-27 14:00:00	AAPL	Stock	7.2018	7.2307	7.1946	7.2304	40127892.0
2007-12-27 14:30:00	AAPL	Stock	7.2304	7.2321	7.1679	7.1707	45629332.0
2007-12-27 15:00:00	AAPL	Stock	7.1711	7.1854	7.1339	7.1343	49907060.0
2007-12-27 15:30:00	AAPL	Stock	7.1343	7.1361	7.0643	7.1061	130487896.0
2007-12-27 16:00:00	AAPL	Stock	7.0961	7.2038	7.0793	7.0857	13600916.0
2007-12-27 16:30:00	AAPL	Stock	7.0893	7.2018	7.0893	7.0943	592676.0
2007-12-27 17:00:00	AAPL	Stock	7.0964	7.0982	7.0893	7.0929	286916.0
2007-12-27 17:30:00	AAPL	Stock	7.09	7.1021	7.0893	7.0996	155876.0
2007-12-27 18:00:00	AAPL	Stock	7.0982	7.1036	7.0918	7.1011	210084.0
2007-12-27 18:30:00	AAPL	Stock	7.1011	7.1071	7.1011	7.1025	178248.0
2007-12-27 19:00:00	AAPL	Stock	7.1064	7.1071	7.1036	7.1039	82460.0
2007-12-27 19:30:00	AAPL	Stock	7.1021	7.1054	7.0982	7.0982	306880.0
2007-12-27 07:30:00	MSFT	Stock	36.79	36.79	36.5	36.5	1200.0
2007-12-27 08:00:00	MSFT	Stock	36.52	36.55	36.52	36.52	2574.0
2007-12-27 08:30:00	MSFT	Stock	36.32	36.41	36.32	36.38	6436.0
2007-12-27 09:00:00	MSFT	Stock	36.44	36.47	36.29	36.3	42875.0
2007-12-27 09:30:00	MSFT	Stock	36.31	36.52	36.29	36.5	2786252.0
2007-12-27 10:00:00	MSFT	Stock	36.51	36.55	36.45	36.47	1811370.0
2007-12-27 10:30:00	MSFT	Stock	36.47	36.48	36.29	36.31	2310795.0
2007-12-27 11:00:00	MSFT	Stock	36.32	36.34	36.24	36.33	1628883.0
2007-12-27 11:30:00	MSFT	Stock	36.34	36.44	36.3	36.44	1554966.0
2007-12-27 12:00:00	MSFT	Stock	36.44	36.45	36.3	36.35	2181666.0
2007-12-27 12:30:00	MSFT	Stock	36.35	36.366	36.27	36.31	1548849.0
2007-12-27 13:00:00	MSFT	Stock	36.31	36.38	36.26	36.38	1102728.0
2007-12-27 13:30:00	MSFT	Stock	36.38	36.39	36.24	36.27	1857139.0
2007-12-27 14:00:00	MSFT	Stock	36.27	36.36	36.26	36.29	1497624.0
2007-12-27 14:30:00	MSFT	Stock	36.29	36.3	36.25	36.27	1685832.0
2007-12-27 15:00:00	MSFT	Stock	36.27	36.31	36.22	36.23	1842537.0
2007-12-27 15:30:00	MSFT	Stock	36.23	36.23	35.94	36.05	8354934.0
2007-12-27 16:00:00	MSFT	Stock	36.03	36.344	35.95	35.97	3971544.0
2007-12-27 16:30:00	MSFT	Stock	36.224	36.224	35.97	35.97	64427.0
2007-12-27 17:00:00	MSFT	Stock	35.97	36.0	35.97	36.0	4655.0
2007-12-27 17:30:00	MSFT	Stock	36.0	36.0	36.0	36.0	500.0
2007-12-27 18:00:00	MSFT	Stock	35.97	36.04	35.97	36.04	3858.0
2007-12-27 19:00:00	MSFT	Stock	36.03	36.04	36.03	36.04	1240.0

> showing 50 of 70,940 rows — these rows as CSV

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