PREVIEW / stock_30min / 2007-08-03

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-03.parquet
  size:    1.2 MB
  rows:    66,555
  symbols: 3,117

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-08-03 09:30:00	AAPL	Stock	4.8307	4.8554	4.8054	4.8121	86638440.0
2007-08-03 10:00:00	AAPL	Stock	4.8129	4.83	4.7954	4.825	57191932.0
2007-08-03 10:30:00	AAPL	Stock	4.8254	4.834	4.8036	4.8114	41337604.0
2007-08-03 11:00:00	AAPL	Stock	4.81	4.8249	4.8036	4.8193	37468452.0
2007-08-03 11:30:00	AAPL	Stock	4.8193	4.8218	4.7964	4.8082	36515052.0
2007-08-03 12:00:00	AAPL	Stock	4.8082	4.8393	4.8082	4.8194	46558792.0
2007-08-03 12:30:00	AAPL	Stock	4.8189	4.8275	4.8107	4.8136	22404312.0
2007-08-03 13:00:00	AAPL	Stock	4.8143	4.8196	4.8107	4.815	17448984.0
2007-08-03 13:30:00	AAPL	Stock	4.815	4.8214	4.8071	4.8185	21318192.0
2007-08-03 14:00:00	AAPL	Stock	4.8182	4.8307	4.7679	4.7714	56013356.0
2007-08-03 14:30:00	AAPL	Stock	4.7714	4.7971	4.7696	4.7861	48638828.0
2007-08-03 15:00:00	AAPL	Stock	4.7868	4.79	4.7618	4.7631	55577256.0
2007-08-03 15:30:00	AAPL	Stock	4.7629	4.7839	4.6964	4.7011	88074000.0
2007-08-03 16:00:00	AAPL	Stock	4.7071	4.7089	4.7015	4.7089	15939084.0
2007-08-03 09:30:00	MSFT	Stock	29.45	29.78	29.41	29.58	3812921.0
2007-08-03 10:00:00	MSFT	Stock	29.58	29.75	29.46	29.61	4020469.0
2007-08-03 10:30:00	MSFT	Stock	29.62	29.65	29.421	29.49	2931216.0
2007-08-03 11:00:00	MSFT	Stock	29.49	29.6	29.45	29.583	2813815.0
2007-08-03 11:30:00	MSFT	Stock	29.59	29.63	29.53	29.56	2906653.0
2007-08-03 12:00:00	MSFT	Stock	29.56	29.66	29.46	29.48	4184804.0
2007-08-03 12:30:00	MSFT	Stock	29.48	29.52	29.39	29.44	2402563.0
2007-08-03 13:00:00	MSFT	Stock	29.44	29.44	29.33	29.34	1974755.0
2007-08-03 13:30:00	MSFT	Stock	29.34	29.39	29.32	29.35	2533299.0
2007-08-03 14:00:00	MSFT	Stock	29.355	29.43	29.14	29.14	4643705.0
2007-08-03 14:30:00	MSFT	Stock	29.15	29.25	29.13	29.213	5647969.0
2007-08-03 15:00:00	MSFT	Stock	29.22	29.24	29.05	29.1	6387615.0
2007-08-03 15:30:00	MSFT	Stock	29.09	29.19	28.9	28.9	9464453.0
2007-08-03 16:00:00	MSFT	Stock	28.9	28.96	28.9	28.96	2647855.0
2007-08-03 09:00:00	NVDA	Stock	0.7537	0.7587	0.75	0.7575	188040.0
2007-08-03 09:30:00	NVDA	Stock	0.753	0.7567	0.7345	0.7402	46305120.0
2007-08-03 10:00:00	NVDA	Stock	0.7402	0.7427	0.733	0.7363	51500100.0
2007-08-03 10:30:00	NVDA	Stock	0.7365	0.7388	0.7287	0.734	38840760.0
2007-08-03 11:00:00	NVDA	Stock	0.7337	0.7362	0.7292	0.732	36252360.0
2007-08-03 11:30:00	NVDA	Stock	0.7322	0.7358	0.7302	0.7347	37684140.0
2007-08-03 12:00:00	NVDA	Stock	0.7345	0.7365	0.7263	0.7265	52129620.0
2007-08-03 12:30:00	NVDA	Stock	0.7267	0.728	0.7228	0.7237	30990900.0
2007-08-03 13:00:00	NVDA	Stock	0.7238	0.7273	0.7218	0.7268	28742400.0
2007-08-03 13:30:00	NVDA	Stock	0.727	0.7272	0.7235	0.7253	29300460.0
2007-08-03 14:00:00	NVDA	Stock	0.7255	0.7272	0.7202	0.7205	38748840.0
2007-08-03 14:30:00	NVDA	Stock	0.7205	0.7233	0.7175	0.7178	44940840.0
2007-08-03 15:00:00	NVDA	Stock	0.718	0.721	0.7128	0.7133	73412580.0
2007-08-03 15:30:00	NVDA	Stock	0.7135	0.7205	0.7087	0.7092	92566020.0
2007-08-03 16:00:00	NVDA	Stock	0.7085	0.7142	0.7075	0.7075	1615620.0
2007-08-03 16:30:00	NVDA	Stock	0.7083	0.7115	0.7083	0.7107	1119480.0
2007-08-03 17:00:00	NVDA	Stock	0.7115	0.7115	0.7115	0.7115	36000.0
2007-08-03 17:30:00	NVDA	Stock	0.7125	0.7125	0.7123	0.7123	28260.0
2007-08-03 18:00:00	NVDA	Stock	0.71	0.71	0.7097	0.7097	66000.0
2007-08-03 19:00:00	NVDA	Stock	0.7097	0.7097	0.7097	0.7097	10800.0
2007-08-03 07:00:00	AMZN	Stock	3.9975	4.005	3.9975	4.005	16000.0
2007-08-03 07:30:00	AMZN	Stock	4.0025	4.025	4.0025	4.02	18000.0

> showing 50 of 66,555 rows — these rows as CSV

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