PREVIEW / stock_30min / 2006-07-06

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-07-06.parquet
  size:    892 KB
  rows:    49,000
  symbols: 2,298

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
2006-07-06 05:30:00	AAPL	Stock	2.0286	2.0286	2.0286	2.0286	22400.0
2006-07-06 06:00:00	AAPL	Stock	2.0357	2.0357	2.0357	2.0357	19600.0
2006-07-06 07:30:00	AAPL	Stock	2.0286	2.0286	2.0286	2.0286	5600.0
2006-07-06 08:00:00	AAPL	Stock	2.0357	2.0393	2.0268	2.0321	227976.0
2006-07-06 08:30:00	AAPL	Stock	2.0321	2.0393	2.0261	2.035	508592.0
2006-07-06 09:00:00	AAPL	Stock	2.0346	2.045	2.0307	2.0418	611688.0
2006-07-06 09:30:00	AAPL	Stock	2.0389	2.0489	2.0211	2.0218	74154948.0
2006-07-06 10:00:00	AAPL	Stock	2.0214	2.05	2.0179	2.0321	76851208.0
2006-07-06 10:30:00	AAPL	Stock	2.0321	2.0343	2.0064	2.0111	72786588.0
2006-07-06 11:00:00	AAPL	Stock	2.0111	2.0404	2.0032	2.0139	49128576.0
2006-07-06 11:30:00	AAPL	Stock	2.0136	2.0143	1.9971	1.9996	41973904.0
2006-07-06 12:00:00	AAPL	Stock	2.0	2.0229	1.9982	2.0025	33707772.0
2006-07-06 12:30:00	AAPL	Stock	2.0029	2.0182	1.9964	2.0071	45432688.0
2006-07-06 13:00:00	AAPL	Stock	2.0071	2.0089	2.0011	2.0036	21016044.0
2006-07-06 13:30:00	AAPL	Stock	2.0036	2.0089	2.0018	2.0021	18220524.0
2006-07-06 14:00:00	AAPL	Stock	2.0021	2.0025	1.9921	1.9946	39403336.0
2006-07-06 14:30:00	AAPL	Stock	1.9943	1.9946	1.9861	1.9882	41157060.0
2006-07-06 15:00:00	AAPL	Stock	1.9879	1.995	1.9864	1.9889	35919548.0
2006-07-06 15:30:00	AAPL	Stock	1.9893	1.9993	1.9868	1.9921	69455624.0
2006-07-06 16:00:00	AAPL	Stock	1.9914	1.9918	1.9857	1.9857	1874432.0
2006-07-06 16:30:00	AAPL	Stock	1.9854	1.9918	1.9825	1.9886	2340184.0
2006-07-06 17:00:00	AAPL	Stock	1.9879	1.9893	1.9875	1.9889	221592.0
2006-07-06 17:30:00	AAPL	Stock	1.9889	1.9889	1.9879	1.9889	88172.0
2006-07-06 18:00:00	AAPL	Stock	1.9875	1.9907	1.9875	1.9896	154140.0
2006-07-06 08:00:00	MSFT	Stock	23.35	23.37	23.33	23.37	30312.0
2006-07-06 08:30:00	MSFT	Stock	23.35	23.41	23.35	23.36	22485.0
2006-07-06 09:00:00	MSFT	Stock	23.35	23.45	23.31	23.44	95390.0
2006-07-06 09:30:00	MSFT	Stock	23.45	23.5	23.42	23.47	4882708.0
2006-07-06 10:00:00	MSFT	Stock	23.47	23.56	23.45	23.55	4262263.0
2006-07-06 10:30:00	MSFT	Stock	23.54	23.57	23.5	23.54	5430136.0
2006-07-06 11:00:00	MSFT	Stock	23.55	23.61	23.47	23.58	2763658.0
2006-07-06 11:30:00	MSFT	Stock	23.59	23.59	23.47	23.48	3483222.0
2006-07-06 12:00:00	MSFT	Stock	23.48	23.55	23.48	23.5	2352609.0
2006-07-06 12:30:00	MSFT	Stock	23.5	23.52	23.48	23.51	1539111.0
2006-07-06 13:00:00	MSFT	Stock	23.51	23.56	23.5	23.55	1537486.0
2006-07-06 13:30:00	MSFT	Stock	23.55	23.56	23.5	23.5	1515046.0
2006-07-06 14:00:00	MSFT	Stock	23.5	23.51	23.43	23.472	4713039.0
2006-07-06 14:30:00	MSFT	Stock	23.47	23.5	23.46	23.482	1992757.0
2006-07-06 15:00:00	MSFT	Stock	23.48	23.52	23.45	23.49	3115093.0
2006-07-06 15:30:00	MSFT	Stock	23.49	23.55	23.45	23.5	5684621.0
2006-07-06 16:00:00	MSFT	Stock	23.47	23.5	23.45	23.48	200344.0
2006-07-06 16:30:00	MSFT	Stock	23.48	23.48	23.46	23.48	22846.0
2006-07-06 17:00:00	MSFT	Stock	23.48	23.48	23.48	23.48	1000.0
2006-07-06 17:30:00	MSFT	Stock	23.48	23.48	23.48	23.48	700.0
2006-07-06 18:00:00	MSFT	Stock	23.48	23.48	23.48	23.48	650.0
2006-07-06 08:30:00	NVDA	Stock	0.345	0.3458	0.345	0.3458	120000.0
2006-07-06 09:00:00	NVDA	Stock	0.3458	0.3458	0.3442	0.3442	168000.0
2006-07-06 09:30:00	NVDA	Stock	0.3438	0.3472	0.3402	0.3423	34115040.0
2006-07-06 10:00:00	NVDA	Stock	0.3423	0.3452	0.3412	0.3447	36688320.0
2006-07-06 10:30:00	NVDA	Stock	0.3447	0.3452	0.3407	0.3418	23933940.0

> showing 50 of 49,000 rows — these rows as CSV

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