PREVIEW / stock_30min / 2008-04-24

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-24.parquet
  size:    1.2 MB
  rows:    68,451
  symbols: 3,292

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
2008-04-24 05:30:00	AAPL	Stock	5.7796	5.785	5.7796	5.7836	39200.0
2008-04-24 06:00:00	AAPL	Stock	5.7893	5.7929	5.7754	5.7754	146020.0
2008-04-24 06:30:00	AAPL	Stock	5.775	5.775	5.7321	5.7357	218904.0
2008-04-24 07:00:00	AAPL	Stock	5.7325	5.7643	5.7182	5.7632	645344.0
2008-04-24 07:30:00	AAPL	Stock	5.7625	5.8393	5.7539	5.8393	3649464.0
2008-04-24 08:00:00	AAPL	Stock	5.8393	5.9018	5.7929	5.8636	27405000.0
2008-04-24 08:30:00	AAPL	Stock	5.8636	5.8939	5.8571	5.8821	14791420.0
2008-04-24 09:00:00	AAPL	Stock	5.8821	5.9568	5.8821	5.9057	35163688.0
2008-04-24 09:30:00	AAPL	Stock	5.9061	5.9214	5.6855	5.8329	289002756.0
2008-04-24 10:00:00	AAPL	Stock	5.8329	5.8382	5.7804	5.8207	128630684.0
2008-04-24 10:30:00	AAPL	Stock	5.8204	5.825	5.7757	5.7864	78412516.0
2008-04-24 11:00:00	AAPL	Stock	5.7857	5.8718	5.7768	5.8554	93595572.0
2008-04-24 11:30:00	AAPL	Stock	5.8546	5.9286	5.8546	5.9114	121976400.0
2008-04-24 12:00:00	AAPL	Stock	5.9104	5.9964	5.9046	5.9639	145178320.0
2008-04-24 12:30:00	AAPL	Stock	5.9646	5.9943	5.9536	5.9857	78069488.0
2008-04-24 13:00:00	AAPL	Stock	5.9857	6.0086	5.9643	6.0076	80146276.0
2008-04-24 13:30:00	AAPL	Stock	6.0071	6.0689	5.9929	6.0529	126629664.0
2008-04-24 14:00:00	AAPL	Stock	6.0532	6.0707	6.0232	6.0421	93082724.0
2008-04-24 14:30:00	AAPL	Stock	6.0421	6.07	6.0339	6.0632	82648188.0
2008-04-24 15:00:00	AAPL	Stock	6.0625	6.0689	6.0389	6.0521	96169304.0
2008-04-24 15:30:00	AAPL	Stock	6.0521	6.0536	6.0082	6.0329	148697640.0
2008-04-24 16:00:00	AAPL	Stock	6.033	6.0604	5.9231	6.04	18454856.0
2008-04-24 16:30:00	AAPL	Stock	6.0404	6.0536	6.0071	6.0114	4405436.0
2008-04-24 17:00:00	AAPL	Stock	6.0129	6.0357	6.0125	6.0286	1372728.0
2008-04-24 17:30:00	AAPL	Stock	6.0314	6.0375	6.0111	6.0143	1144612.0
2008-04-24 18:00:00	AAPL	Stock	6.0243	6.0336	6.0107	6.0107	437388.0
2008-04-24 18:30:00	AAPL	Stock	6.0111	6.0179	6.0107	6.0143	91476.0
2008-04-24 19:00:00	AAPL	Stock	6.0125	6.0143	6.0107	6.0143	74088.0
2008-04-24 19:30:00	AAPL	Stock	6.0143	6.0168	6.0089	6.0089	199136.0
2008-04-24 07:00:00	MSFT	Stock	31.49	31.49	31.38	31.47	1300.0
2008-04-24 07:30:00	MSFT	Stock	31.45	31.46	31.43	31.43	2200.0
2008-04-24 08:00:00	MSFT	Stock	31.42	31.75	31.42	31.65	124844.0
2008-04-24 08:30:00	MSFT	Stock	31.65	31.75	31.6	31.6	195766.0
2008-04-24 09:00:00	MSFT	Stock	31.6	31.63	31.56	31.63	173932.0
2008-04-24 09:30:00	MSFT	Stock	31.64	31.84	31.29	31.33	10744525.0
2008-04-24 10:00:00	MSFT	Stock	31.33	31.36	31.16	31.32	6441360.0
2008-04-24 10:30:00	MSFT	Stock	31.32	31.69	31.28	31.69	7156680.0
2008-04-24 11:00:00	MSFT	Stock	31.69	31.79	31.59	31.69	8043252.0
2008-04-24 11:30:00	MSFT	Stock	31.68	31.89	31.65	31.82	6500362.0
2008-04-24 12:00:00	MSFT	Stock	31.82	31.97	31.82	31.9	6746586.0
2008-04-24 12:30:00	MSFT	Stock	31.902	31.91	31.77	31.848	4766553.0
2008-04-24 13:00:00	MSFT	Stock	31.849	31.93	31.65	31.71	6096082.0
2008-04-24 13:30:00	MSFT	Stock	31.71	31.87	31.55	31.759	5951978.0
2008-04-24 14:00:00	MSFT	Stock	31.75	31.87	31.64	31.861	5093597.0
2008-04-24 14:30:00	MSFT	Stock	31.861	31.89	31.76	31.88	5473504.0
2008-04-24 15:00:00	MSFT	Stock	31.87	32.1	31.8	31.83	12882627.0
2008-04-24 15:30:00	MSFT	Stock	31.82	32.0	31.63	31.68	15829000.0
2008-04-24 16:00:00	MSFT	Stock	31.68	32.5	30.39	30.45	7974813.0
2008-04-24 16:30:00	MSFT	Stock	30.44	31.872	30.0	30.27	3251036.0
2008-04-24 17:00:00	MSFT	Stock	30.26	30.49	30.22	30.3	660897.0

> showing 50 of 68,451 rows — these rows as CSV

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