PREVIEW / stock_30min / 2007-08-06

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-06.parquet
  size:    1.2 MB
  rows:    66,506
  symbols: 3,108

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-06 09:30:00	AAPL	Stock	4.7464	4.7679	4.5821	4.6625	171756312.0
2007-08-06 10:00:00	AAPL	Stock	4.6632	4.6961	4.6225	4.6432	98385112.0
2007-08-06 10:30:00	AAPL	Stock	4.6432	4.7446	4.6293	4.6739	76217988.0
2007-08-06 11:00:00	AAPL	Stock	4.6744	4.7218	4.6536	4.7064	67700528.0
2007-08-06 11:30:00	AAPL	Stock	4.7068	4.7393	4.6357	4.7096	58514792.0
2007-08-06 12:00:00	AAPL	Stock	4.7096	4.7143	4.6839	4.7	33992896.0
2007-08-06 12:30:00	AAPL	Stock	4.7	4.7704	4.6989	4.755	64795052.0
2007-08-06 13:00:00	AAPL	Stock	4.7543	4.7646	4.7354	4.7529	36403108.0
2007-08-06 13:30:00	AAPL	Stock	4.7521	4.7632	4.7232	4.7318	44408756.0
2007-08-06 14:00:00	AAPL	Stock	4.7318	4.7854	4.7246	4.777	52447248.0
2007-08-06 14:30:00	AAPL	Stock	4.7777	4.8139	4.7771	4.7968	66571232.0
2007-08-06 15:00:00	AAPL	Stock	4.7968	4.8064	4.7864	4.8061	43190280.0
2007-08-06 15:30:00	AAPL	Stock	4.8064	4.8311	4.7918	4.8311	74488792.0
2007-08-06 16:00:00	AAPL	Stock	4.8282	4.8304	4.825	4.8304	10071376.0
2007-08-06 09:30:00	MSFT	Stock	29.05	29.18	29.018	29.18	5648893.0
2007-08-06 10:00:00	MSFT	Stock	29.18	29.22	29.04	29.08	5825158.0
2007-08-06 10:30:00	MSFT	Stock	29.07	29.19	28.97	28.99	5156663.0
2007-08-06 11:00:00	MSFT	Stock	28.98	29.0	28.75	28.95	4963818.0
2007-08-06 11:30:00	MSFT	Stock	28.96	29.22	28.86	29.18	3949113.0
2007-08-06 12:00:00	MSFT	Stock	29.18	29.22	29.13	29.173	2594438.0
2007-08-06 12:30:00	MSFT	Stock	29.18	29.38	29.17	29.3	3443110.0
2007-08-06 13:00:00	MSFT	Stock	29.3	29.32	29.15	29.16	1850829.0
2007-08-06 13:30:00	MSFT	Stock	29.16	29.2	29.05	29.065	2715652.0
2007-08-06 14:00:00	MSFT	Stock	29.075	29.2	29.05	29.15	3938345.0
2007-08-06 14:30:00	MSFT	Stock	29.15	29.34	29.15	29.29	3092786.0
2007-08-06 15:00:00	MSFT	Stock	29.28	29.4	29.28	29.34	3107384.0
2007-08-06 15:30:00	MSFT	Stock	29.343	29.54	29.24	29.54	7774703.0
2007-08-06 16:00:00	MSFT	Stock	29.52	29.54	29.52	29.54	3034290.0
2007-08-06 08:00:00	NVDA	Stock	0.7162	0.7225	0.7162	0.7225	1026000.0
2007-08-06 08:30:00	NVDA	Stock	0.7177	0.7212	0.7147	0.7158	272400.0
2007-08-06 09:00:00	NVDA	Stock	0.7167	0.7203	0.7155	0.7182	392400.0
2007-08-06 09:30:00	NVDA	Stock	0.7167	0.7203	0.7033	0.717	70609080.0
2007-08-06 10:00:00	NVDA	Stock	0.7167	0.717	0.695	0.6985	55005000.0
2007-08-06 10:30:00	NVDA	Stock	0.6985	0.7055	0.6972	0.7045	35911020.0
2007-08-06 11:00:00	NVDA	Stock	0.7043	0.7107	0.7025	0.7083	34152300.0
2007-08-06 11:30:00	NVDA	Stock	0.7085	0.71	0.6987	0.7075	38168460.0
2007-08-06 12:00:00	NVDA	Stock	0.7072	0.7111	0.6993	0.7007	29994180.0
2007-08-06 12:30:00	NVDA	Stock	0.701	0.7147	0.6998	0.705	22211580.0
2007-08-06 13:00:00	NVDA	Stock	0.705	0.7083	0.705	0.7077	19971720.0
2007-08-06 13:30:00	NVDA	Stock	0.7075	0.7098	0.7007	0.7017	26896080.0
2007-08-06 14:00:00	NVDA	Stock	0.7013	0.7137	0.701	0.7033	26359980.0
2007-08-06 14:30:00	NVDA	Stock	0.703	0.708	0.7015	0.7025	32337600.0
2007-08-06 15:00:00	NVDA	Stock	0.7027	0.7102	0.7025	0.7093	46455480.0
2007-08-06 15:30:00	NVDA	Stock	0.7095	0.715	0.7058	0.7148	66698460.0
2007-08-06 16:00:00	NVDA	Stock	0.7135	0.7148	0.7108	0.7148	587280.0
2007-08-06 16:30:00	NVDA	Stock	0.7125	0.7148	0.7125	0.7148	666300.0
2007-08-06 17:30:00	NVDA	Stock	0.7148	0.715	0.7142	0.7142	364800.0
2007-08-06 19:30:00	NVDA	Stock	0.715	0.715	0.715	0.715	27000.0
2007-08-06 08:00:00	AMZN	Stock	3.8505	3.8755	3.8505	3.8675	105960.0
2007-08-06 08:30:00	AMZN	Stock	3.87	3.872	3.86	3.86	28600.0

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

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