PREVIEW / stock_30min / 2007-06-19

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-19.parquet
  size:    1.1 MB
  rows:    63,270
  symbols: 3,042

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-06-19 09:30:00	AAPL	Stock	4.4532	4.4646	4.3975	4.4164	155806728.0
2007-06-19 10:00:00	AAPL	Stock	4.4154	4.4239	4.3993	4.41	75274444.0
2007-06-19 10:30:00	AAPL	Stock	4.4096	4.4196	4.3896	4.4	95187148.0
2007-06-19 11:00:00	AAPL	Stock	4.4	4.4179	4.3921	4.4057	60395328.0
2007-06-19 11:30:00	AAPL	Stock	4.4054	4.4329	4.4018	4.4318	57954092.0
2007-06-19 12:00:00	AAPL	Stock	4.4318	4.4479	4.4264	4.4304	65497236.0
2007-06-19 12:30:00	AAPL	Stock	4.4306	4.435	4.4214	4.4311	36910160.0
2007-06-19 13:00:00	AAPL	Stock	4.4304	4.4461	4.4171	4.4268	43076264.0
2007-06-19 13:30:00	AAPL	Stock	4.4257	4.4307	4.4093	4.4279	63380492.0
2007-06-19 14:00:00	AAPL	Stock	4.4275	4.4293	4.4125	4.4139	34680100.0
2007-06-19 14:30:00	AAPL	Stock	4.4139	4.4175	4.3957	4.4132	74520096.0
2007-06-19 15:00:00	AAPL	Stock	4.4132	4.4336	4.4079	4.4279	57882440.0
2007-06-19 15:30:00	AAPL	Stock	4.4282	4.4386	4.4143	4.4164	80458728.0
2007-06-19 16:00:00	AAPL	Stock	4.4182	4.4182	4.4164	4.4164	2359644.0
2007-06-19 09:30:00	MSFT	Stock	30.48	30.54	30.41	30.48	3426110.0
2007-06-19 10:00:00	MSFT	Stock	30.47	30.48	30.38	30.42	3470036.0
2007-06-19 10:30:00	MSFT	Stock	30.42	30.52	30.41	30.45	3096111.0
2007-06-19 11:00:00	MSFT	Stock	30.45	30.47	30.399	30.42	2671271.0
2007-06-19 11:30:00	MSFT	Stock	30.43	30.49	30.42	30.47	2006754.0
2007-06-19 12:00:00	MSFT	Stock	30.47	30.572	30.46	30.469	2872577.0
2007-06-19 12:30:00	MSFT	Stock	30.46	30.59	30.44	30.56	2169446.0
2007-06-19 13:00:00	MSFT	Stock	30.562	30.66	30.5	30.54	2184483.0
2007-06-19 13:30:00	MSFT	Stock	30.55	30.57	30.49	30.527	2056804.0
2007-06-19 14:00:00	MSFT	Stock	30.52	30.55	30.42	30.49	2244974.0
2007-06-19 14:30:00	MSFT	Stock	30.489	30.52	30.43	30.47	3223307.0
2007-06-19 15:00:00	MSFT	Stock	30.48	30.49	30.44	30.473	2704244.0
2007-06-19 15:30:00	MSFT	Stock	30.47	30.51	30.42	30.46	6677104.0
2007-06-19 16:00:00	MSFT	Stock	30.46	30.46	30.46	30.46	4392682.0
2007-06-19 08:00:00	NVDA	Stock	0.6595	0.6615	0.6527	0.6542	183240.0
2007-06-19 08:30:00	NVDA	Stock	0.6567	0.6567	0.6567	0.6567	6000.0
2007-06-19 09:00:00	NVDA	Stock	0.6533	0.6572	0.6533	0.6557	720180.0
2007-06-19 09:30:00	NVDA	Stock	0.655	0.6592	0.6508	0.6527	77183580.0
2007-06-19 10:00:00	NVDA	Stock	0.6527	0.6562	0.652	0.6547	45639540.0
2007-06-19 10:30:00	NVDA	Stock	0.6548	0.6577	0.6535	0.6552	30852540.0
2007-06-19 11:00:00	NVDA	Stock	0.655	0.6557	0.6537	0.6553	25877820.0
2007-06-19 11:30:00	NVDA	Stock	0.6553	0.6565	0.6543	0.6555	28457700.0
2007-06-19 12:00:00	NVDA	Stock	0.6555	0.6608	0.6555	0.6595	39007260.0
2007-06-19 12:30:00	NVDA	Stock	0.6593	0.6605	0.6583	0.6597	20085900.0
2007-06-19 13:00:00	NVDA	Stock	0.6598	0.6637	0.6595	0.661	36143400.0
2007-06-19 13:30:00	NVDA	Stock	0.661	0.6615	0.6587	0.6592	15535500.0
2007-06-19 14:00:00	NVDA	Stock	0.6592	0.6607	0.658	0.66	33827580.0
2007-06-19 14:30:00	NVDA	Stock	0.66	0.6608	0.6598	0.6603	29493120.0
2007-06-19 15:00:00	NVDA	Stock	0.6603	0.6648	0.66	0.6635	32676300.0
2007-06-19 15:30:00	NVDA	Stock	0.6633	0.6652	0.6625	0.6637	54135600.0
2007-06-19 16:00:00	NVDA	Stock	0.6637	0.6638	0.6637	0.6637	2955660.0
2007-06-19 16:30:00	NVDA	Stock	0.6642	0.6642	0.6642	0.6642	13320.0
2007-06-19 17:00:00	NVDA	Stock	0.6637	0.6637	0.6637	0.6637	1120800.0
2007-06-19 17:30:00	NVDA	Stock	0.6647	0.6658	0.6647	0.6658	27960.0
2007-06-19 18:00:00	NVDA	Stock	0.6658	0.6658	0.6658	0.6658	6420.0
2007-06-19 19:30:00	NVDA	Stock	0.664	0.6658	0.664	0.6658	53400.0

> showing 50 of 63,270 rows — these rows as CSV

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