PREVIEW / stock_30min / 2007-06-18

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-18.parquet
  size:    1.1 MB
  rows:    64,145
  symbols: 3,046

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-18 09:30:00	AAPL	Stock	4.4029	4.4379	4.3764	4.4107	170521484.0
2007-06-18 10:00:00	AAPL	Stock	4.4107	4.4411	4.4011	4.4325	100436504.0
2007-06-18 10:30:00	AAPL	Stock	4.4325	4.435	4.4196	4.4279	62419000.0
2007-06-18 11:00:00	AAPL	Stock	4.4279	4.43	4.4036	4.4143	58510984.0
2007-06-18 11:30:00	AAPL	Stock	4.4154	4.4261	4.4071	4.4232	35875924.0
2007-06-18 12:00:00	AAPL	Stock	4.4232	4.4246	4.4139	4.415	21282660.0
2007-06-18 12:30:00	AAPL	Stock	4.415	4.4375	4.415	4.4357	34991236.0
2007-06-18 13:00:00	AAPL	Stock	4.4357	4.4489	4.4275	4.4389	54316528.0
2007-06-18 13:30:00	AAPL	Stock	4.439	4.4436	4.425	4.429	36819720.0
2007-06-18 14:00:00	AAPL	Stock	4.4296	4.4371	4.4268	4.4325	32296348.0
2007-06-18 14:30:00	AAPL	Stock	4.4325	4.4371	4.4271	4.4357	31435852.0
2007-06-18 15:00:00	AAPL	Stock	4.4357	4.455	4.4332	4.4482	79544780.0
2007-06-18 15:30:00	AAPL	Stock	4.4486	4.4707	4.4464	4.4661	125705188.0
2007-06-18 16:00:00	AAPL	Stock	4.4657	4.4675	4.465	4.4675	4078564.0
2007-06-18 09:30:00	MSFT	Stock	30.69	30.72	30.59	30.71	4082389.0
2007-06-18 10:00:00	MSFT	Stock	30.71	30.71	30.42	30.45	7518064.0
2007-06-18 10:30:00	MSFT	Stock	30.44	30.54	30.44	30.482	3933585.0
2007-06-18 11:00:00	MSFT	Stock	30.49	30.57	30.47	30.53	1888915.0
2007-06-18 11:30:00	MSFT	Stock	30.53	30.57	30.51	30.57	1317405.0
2007-06-18 12:00:00	MSFT	Stock	30.56	30.58	30.52	30.56	1441959.0
2007-06-18 12:30:00	MSFT	Stock	30.56	30.65	30.55	30.63	2682372.0
2007-06-18 13:00:00	MSFT	Stock	30.64	30.64	30.55	30.56	1934143.0
2007-06-18 13:30:00	MSFT	Stock	30.56	30.6	30.51	30.58	3029980.0
2007-06-18 14:00:00	MSFT	Stock	30.59	30.59	30.52	30.55	1585429.0
2007-06-18 14:30:00	MSFT	Stock	30.56	30.565	30.49	30.52	1574994.0
2007-06-18 15:00:00	MSFT	Stock	30.52	30.58	30.486	30.55	2094514.0
2007-06-18 15:30:00	MSFT	Stock	30.55	30.56	30.48	30.51	9162774.0
2007-06-18 16:00:00	MSFT	Stock	30.51	30.51	30.51	30.51	812705.0
2007-06-18 08:00:00	NVDA	Stock	0.669	0.6807	0.6675	0.6765	1980660.0
2007-06-18 08:30:00	NVDA	Stock	0.6752	0.6767	0.6742	0.6747	1176900.0
2007-06-18 09:00:00	NVDA	Stock	0.6742	0.6742	0.6592	0.6658	1843500.0
2007-06-18 09:30:00	NVDA	Stock	0.6658	0.667	0.6567	0.6597	127787520.0
2007-06-18 10:00:00	NVDA	Stock	0.6597	0.6615	0.6542	0.6562	83232360.0
2007-06-18 10:30:00	NVDA	Stock	0.6562	0.6613	0.6548	0.66	41931360.0
2007-06-18 11:00:00	NVDA	Stock	0.66	0.6643	0.6572	0.6637	46186620.0
2007-06-18 11:30:00	NVDA	Stock	0.6635	0.6658	0.6628	0.6655	39744000.0
2007-06-18 12:00:00	NVDA	Stock	0.6655	0.6658	0.661	0.6615	27612420.0
2007-06-18 12:30:00	NVDA	Stock	0.6615	0.6682	0.6567	0.6663	64622940.0
2007-06-18 13:00:00	NVDA	Stock	0.6663	0.6678	0.6627	0.6637	27673680.0
2007-06-18 13:30:00	NVDA	Stock	0.6637	0.6655	0.6618	0.6638	45134280.0
2007-06-18 14:00:00	NVDA	Stock	0.664	0.6642	0.6618	0.6636	22041660.0
2007-06-18 14:30:00	NVDA	Stock	0.6637	0.6642	0.6613	0.662	21848040.0
2007-06-18 15:00:00	NVDA	Stock	0.6622	0.6628	0.6612	0.662	23492700.0
2007-06-18 15:30:00	NVDA	Stock	0.6622	0.6627	0.6593	0.6595	47534220.0
2007-06-18 16:00:00	NVDA	Stock	0.6595	0.6612	0.6588	0.6593	28174320.0
2007-06-18 16:30:00	NVDA	Stock	0.6608	0.6608	0.656	0.656	486960.0
2007-06-18 17:00:00	NVDA	Stock	0.656	0.656	0.655	0.6555	64980.0
2007-06-18 17:30:00	NVDA	Stock	0.6555	0.6568	0.6555	0.6568	15000.0
2007-06-18 18:30:00	NVDA	Stock	0.6558	0.6558	0.655	0.6557	61860.0
2007-06-18 19:00:00	NVDA	Stock	0.6595	0.6595	0.6583	0.6583	85920.0

> showing 50 of 64,145 rows — these rows as CSV

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