PREVIEW / stock_30min / 2007-12-05

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-05.parquet
  size:    1.2 MB
  rows:    69,831
  symbols: 3,203

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-05 04:30:00	AAPL	Stock	6.4636	6.4636	6.4636	6.4636	33600.0
2007-12-05 05:00:00	AAPL	Stock	6.4718	6.4718	6.4718	6.4718	2800.0
2007-12-05 06:00:00	AAPL	Stock	6.4821	6.4821	6.4811	6.4811	25200.0
2007-12-05 06:30:00	AAPL	Stock	6.4821	6.4821	6.4821	6.4821	8400.0
2007-12-05 07:00:00	AAPL	Stock	6.5	6.5004	6.4821	6.5004	101444.0
2007-12-05 07:30:00	AAPL	Stock	6.4861	6.4911	6.4814	6.4911	142800.0
2007-12-05 08:00:00	AAPL	Stock	6.4893	6.5	6.4218	6.4921	2950052.0
2007-12-05 08:30:00	AAPL	Stock	6.4921	6.5375	6.4911	6.5268	4321856.0
2007-12-05 09:00:00	AAPL	Stock	6.5268	6.5546	6.525	6.5325	3815840.0
2007-12-05 09:30:00	AAPL	Stock	6.5329	6.5589	6.5146	6.5575	121982504.0
2007-12-05 10:00:00	AAPL	Stock	6.5571	6.5793	6.5471	6.5596	76516888.0
2007-12-05 10:30:00	AAPL	Stock	6.5596	6.5943	6.5482	6.5889	55633480.0
2007-12-05 11:00:00	AAPL	Stock	6.5889	6.6154	6.5771	6.6118	66557764.0
2007-12-05 11:30:00	AAPL	Stock	6.6125	6.6368	6.5982	6.6286	62502496.0
2007-12-05 12:00:00	AAPL	Stock	6.6286	6.6429	6.5986	6.6068	70205632.0
2007-12-05 12:30:00	AAPL	Stock	6.6064	6.6371	6.6007	6.6018	49658560.0
2007-12-05 13:00:00	AAPL	Stock	6.6007	6.6161	6.5675	6.5971	64052828.0
2007-12-05 13:30:00	AAPL	Stock	6.5971	6.6071	6.5807	6.5961	45462060.0
2007-12-05 14:00:00	AAPL	Stock	6.5961	6.6032	6.5461	6.5618	56872984.0
2007-12-05 14:30:00	AAPL	Stock	6.5609	6.5886	6.5482	6.5675	54936952.0
2007-12-05 15:00:00	AAPL	Stock	6.5682	6.6054	6.5589	6.5957	53678772.0
2007-12-05 15:30:00	AAPL	Stock	6.5957	6.6318	6.59	6.6232	83459936.0
2007-12-05 16:00:00	AAPL	Stock	6.625	6.6336	6.5782	6.6214	15377908.0
2007-12-05 16:30:00	AAPL	Stock	6.6218	6.6336	6.5959	6.6332	664440.0
2007-12-05 17:00:00	AAPL	Stock	6.6314	6.6429	6.6025	6.6393	1654016.0
2007-12-05 17:30:00	AAPL	Stock	6.6414	6.6464	6.6389	6.6429	772408.0
2007-12-05 18:00:00	AAPL	Stock	6.6432	6.6514	6.6429	6.6464	326116.0
2007-12-05 18:30:00	AAPL	Stock	6.6464	6.6571	6.6464	6.6571	203196.0
2007-12-05 19:00:00	AAPL	Stock	6.6589	6.6675	6.6589	6.6657	234920.0
2007-12-05 19:30:00	AAPL	Stock	6.6661	6.6739	6.6589	6.6696	312228.0
2007-12-05 06:00:00	MSFT	Stock	32.9	32.9	32.9	32.9	100.0
2007-12-05 07:00:00	MSFT	Stock	32.95	32.95	32.9	32.9	1200.0
2007-12-05 07:30:00	MSFT	Stock	32.97	32.97	32.94	32.96	500.0
2007-12-05 08:00:00	MSFT	Stock	32.96	32.99	32.77	32.99	932431.0
2007-12-05 08:30:00	MSFT	Stock	33.04	33.15	33.02	33.15	146601.0
2007-12-05 09:00:00	MSFT	Stock	33.13	33.17	33.11	33.13	149331.0
2007-12-05 09:30:00	MSFT	Stock	33.13	33.47	33.03	33.42	8578019.0
2007-12-05 10:00:00	MSFT	Stock	33.42	33.63	33.42	33.57	5881792.0
2007-12-05 10:30:00	MSFT	Stock	33.57	33.92	33.51	33.83	5421754.0
2007-12-05 11:00:00	MSFT	Stock	33.84	33.95	33.73	33.94	3794950.0
2007-12-05 11:30:00	MSFT	Stock	33.93	33.94	33.77	33.91	2700056.0
2007-12-05 12:00:00	MSFT	Stock	33.91	33.95	33.83	33.911	3242766.0
2007-12-05 12:30:00	MSFT	Stock	33.91	34.01	33.91	33.95	5253733.0
2007-12-05 13:00:00	MSFT	Stock	33.95	34.07	33.87	34.07	4817059.0
2007-12-05 13:30:00	MSFT	Stock	34.08	34.33	34.06	34.32	5985025.0
2007-12-05 14:00:00	MSFT	Stock	34.32	34.48	34.245	34.28	7559574.0
2007-12-05 14:30:00	MSFT	Stock	34.28	34.37	34.23	34.27	5163641.0
2007-12-05 15:00:00	MSFT	Stock	34.27	34.49	34.26	34.47	6212674.0
2007-12-05 15:30:00	MSFT	Stock	34.46	34.52	34.15	34.16	13985433.0
2007-12-05 16:00:00	MSFT	Stock	34.15	34.302	33.24	34.19	4958101.0

> showing 50 of 69,831 rows — these rows as CSV

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