PREVIEW / stock_30min / 2006-03-29

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-03-29.parquet
  size:    911 KB
  rows:    48,743
  symbols: 2,227

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
2006-03-29 04:00:00	AAPL	Stock	2.1	2.1	2.0939	2.0939	16800.0
2006-03-29 04:30:00	AAPL	Stock	2.0893	2.0893	2.0839	2.0839	16800.0
2006-03-29 05:30:00	AAPL	Stock	2.0875	2.0875	2.0875	2.0875	67200.0
2006-03-29 06:00:00	AAPL	Stock	2.1032	2.1032	2.1032	2.1032	5600.0
2006-03-29 06:30:00	AAPL	Stock	2.0911	2.0911	2.0911	2.0911	8400.0
2006-03-29 07:00:00	AAPL	Stock	2.0943	2.1054	2.0943	2.1	100716.0
2006-03-29 07:30:00	AAPL	Stock	2.1	2.1	2.0975	2.0975	30800.0
2006-03-29 08:00:00	AAPL	Stock	2.0982	2.1071	2.0971	2.1043	1667764.0
2006-03-29 08:30:00	AAPL	Stock	2.1043	2.1104	2.1029	2.1086	2002980.0
2006-03-29 09:00:00	AAPL	Stock	2.1079	2.1139	2.1075	2.1114	4429628.0
2006-03-29 09:30:00	AAPL	Stock	2.1118	2.115	2.0829	2.0882	164619952.0
2006-03-29 10:00:00	AAPL	Stock	2.0882	2.0907	2.0732	2.0857	198845640.0
2006-03-29 10:30:00	AAPL	Stock	2.0854	2.0879	2.0596	2.0629	154677264.0
2006-03-29 11:00:00	AAPL	Stock	2.0629	2.1393	2.0625	2.1346	386419264.0
2006-03-29 11:30:00	AAPL	Stock	2.1346	2.1657	2.1346	2.1579	295422652.0
2006-03-29 12:00:00	AAPL	Stock	2.1579	2.1768	2.1564	2.1689	200892524.0
2006-03-29 12:30:00	AAPL	Stock	2.1693	2.1893	2.1671	2.1832	138436620.0
2006-03-29 13:00:00	AAPL	Stock	2.1832	2.2064	2.1821	2.1964	137100264.0
2006-03-29 13:30:00	AAPL	Stock	2.1964	2.2075	2.1786	2.2025	107107728.0
2006-03-29 14:00:00	AAPL	Stock	2.2021	2.2164	2.2	2.2054	132050632.0
2006-03-29 14:30:00	AAPL	Stock	2.2057	2.2196	2.1946	2.2154	124457676.0
2006-03-29 15:00:00	AAPL	Stock	2.215	2.2329	2.2114	2.2242	115179904.0
2006-03-29 15:30:00	AAPL	Stock	2.2236	2.2282	2.2104	2.2246	159899348.0
2006-03-29 16:00:00	AAPL	Stock	2.225	2.2271	2.2114	2.2193	7434252.0
2006-03-29 16:30:00	AAPL	Stock	2.2146	2.2211	2.1273	2.2182	1848168.0
2006-03-29 17:00:00	AAPL	Stock	2.2154	2.2261	2.2036	2.2157	1398824.0
2006-03-29 17:30:00	AAPL	Stock	2.2161	2.2161	2.2107	2.2143	993356.0
2006-03-29 18:00:00	AAPL	Stock	2.2132	2.2164	2.2114	2.2118	408800.0
2006-03-29 07:00:00	MSFT	Stock	26.93	26.93	26.93	26.93	1000.0
2006-03-29 08:00:00	MSFT	Stock	26.94	26.95	26.93	26.95	21768.0
2006-03-29 08:30:00	MSFT	Stock	26.95	26.97	26.94	26.96	27786.0
2006-03-29 09:00:00	MSFT	Stock	26.96	26.99	26.94	26.95	72950.0
2006-03-29 09:30:00	MSFT	Stock	26.95	27.01	26.92	26.96	5659434.0
2006-03-29 10:00:00	MSFT	Stock	26.96	27.14	26.93	27.07	5949800.0
2006-03-29 10:30:00	MSFT	Stock	27.07	27.09	27.0	27.01	2424642.0
2006-03-29 11:00:00	MSFT	Stock	27.02	27.12	27.01	27.11	2580616.0
2006-03-29 11:30:00	MSFT	Stock	27.11	27.15	27.05	27.07	2950549.0
2006-03-29 12:00:00	MSFT	Stock	27.08	27.12	27.07	27.1	1730836.0
2006-03-29 12:30:00	MSFT	Stock	27.1	27.11	27.03	27.041	1087927.0
2006-03-29 13:00:00	MSFT	Stock	27.05	27.18	27.02	27.142	2393926.0
2006-03-29 13:30:00	MSFT	Stock	27.141	27.19	27.11	27.13	1424674.0
2006-03-29 14:00:00	MSFT	Stock	27.14	27.2	27.07	27.1	3169756.0
2006-03-29 14:30:00	MSFT	Stock	27.09	27.12	27.07	27.08	3060836.0
2006-03-29 15:00:00	MSFT	Stock	27.08	27.11	27.05	27.11	2965030.0
2006-03-29 15:30:00	MSFT	Stock	27.1	27.11	27.01	27.02	9743827.0
2006-03-29 16:00:00	MSFT	Stock	27.02	27.06	27.0	27.02	833461.0
2006-03-29 16:30:00	MSFT	Stock	27.02	27.09	27.01	27.04	1502600.0
2006-03-29 17:00:00	MSFT	Stock	27.03	27.05	27.01	27.01	8820.0
2006-03-29 17:30:00	MSFT	Stock	27.01	27.01	27.01	27.01	500.0
2006-03-29 18:00:00	MSFT	Stock	27.03	27.03	27.019	27.019	582029.0

> showing 50 of 48,743 rows — these rows as CSV

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