PREVIEW / stock_30min / 2008-01-24

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-24.parquet
  size:    1.2 MB
  rows:    70,467
  symbols: 3,264

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-01-24 06:00:00	AAPL	Stock	5.0446	5.0893	5.0446	5.0893	119560.0
2008-01-24 06:30:00	AAPL	Stock	5.0875	5.0875	5.0679	5.0714	31500.0
2008-01-24 07:00:00	AAPL	Stock	5.0714	5.0732	5.0293	5.0443	1056972.0
2008-01-24 07:30:00	AAPL	Stock	5.0357	5.0425	5.0129	5.0129	627844.0
2008-01-24 08:00:00	AAPL	Stock	5.0161	5.0325	4.9607	4.9639	4338936.0
2008-01-24 08:30:00	AAPL	Stock	4.9643	5.0061	4.9643	4.9807	4800488.0
2008-01-24 09:00:00	AAPL	Stock	4.9857	5.0089	4.9568	4.9989	9156644.0
2008-01-24 09:30:00	AAPL	Stock	4.9993	5.025	4.9064	5.0	273686112.0
2008-01-24 10:00:00	AAPL	Stock	5.0	5.0211	4.825	4.9014	252129640.0
2008-01-24 10:30:00	AAPL	Stock	4.9004	4.9325	4.8307	4.8311	136939264.0
2008-01-24 11:00:00	AAPL	Stock	4.8321	4.8357	4.7321	4.8124	213452764.0
2008-01-24 11:30:00	AAPL	Stock	4.8125	4.8575	4.7886	4.8189	124886972.0
2008-01-24 12:00:00	AAPL	Stock	4.8186	4.8518	4.8054	4.8179	71107820.0
2008-01-24 12:30:00	AAPL	Stock	4.8171	4.8211	4.7686	4.7954	93166668.0
2008-01-24 13:00:00	AAPL	Stock	4.7957	4.7971	4.7575	4.7811	81758740.0
2008-01-24 13:30:00	AAPL	Stock	4.78	4.7832	4.7414	4.7464	95563916.0
2008-01-24 14:00:00	AAPL	Stock	4.7464	4.7839	4.7146	4.7714	123065768.0
2008-01-24 14:30:00	AAPL	Stock	4.7714	4.8279	4.7604	4.7689	140293104.0
2008-01-24 15:00:00	AAPL	Stock	4.7689	4.8425	4.75	4.8325	136891160.0
2008-01-24 15:30:00	AAPL	Stock	4.8314	4.8486	4.8107	4.8404	150955504.0
2008-01-24 16:00:00	AAPL	Stock	4.8425	4.9036	4.8025	4.9032	83495720.0
2008-01-24 16:30:00	AAPL	Stock	4.9	4.9286	4.8429	4.925	4133948.0
2008-01-24 17:00:00	AAPL	Stock	4.9268	4.9268	4.8429	4.9143	2073204.0
2008-01-24 17:30:00	AAPL	Stock	4.9143	4.9236	4.8429	4.9214	624512.0
2008-01-24 18:00:00	AAPL	Stock	4.9214	4.9225	4.9054	4.9054	593544.0
2008-01-24 18:30:00	AAPL	Stock	4.9054	4.9207	4.9054	4.9196	442344.0
2008-01-24 19:00:00	AAPL	Stock	4.9196	4.9243	4.9125	4.9179	402724.0
2008-01-24 19:30:00	AAPL	Stock	4.9196	4.9218	4.9143	4.9214	386232.0
2008-01-24 07:00:00	MSFT	Stock	32.21	32.22	32.21	32.22	400.0
2008-01-24 07:30:00	MSFT	Stock	32.24	32.3	32.24	32.25	6800.0
2008-01-24 08:00:00	MSFT	Stock	32.25	32.35	32.15	32.23	117572.0
2008-01-24 08:30:00	MSFT	Stock	32.21	32.4	32.17	32.35	170517.0
2008-01-24 09:00:00	MSFT	Stock	32.34	32.39	32.17	32.39	397330.0
2008-01-24 09:30:00	MSFT	Stock	32.39	32.64	32.15	32.42	15611022.0
2008-01-24 10:00:00	MSFT	Stock	32.43	32.56	32.12	32.21	12763629.0
2008-01-24 10:30:00	MSFT	Stock	32.21	32.42	32.17	32.32	8398957.0
2008-01-24 11:00:00	MSFT	Stock	32.32	32.64	32.25	32.64	8249965.0
2008-01-24 11:30:00	MSFT	Stock	32.63	32.87	32.5	32.762	7792236.0
2008-01-24 12:00:00	MSFT	Stock	32.76	32.79	32.5	32.55	4599360.0
2008-01-24 12:30:00	MSFT	Stock	32.55	32.7	32.53	32.69	5452052.0
2008-01-24 13:00:00	MSFT	Stock	32.69	32.69	32.54	32.6	4507836.0
2008-01-24 13:30:00	MSFT	Stock	32.6	32.73	32.54	32.68	4734227.0
2008-01-24 14:00:00	MSFT	Stock	32.68	32.87	32.58	32.87	12741502.0
2008-01-24 14:30:00	MSFT	Stock	32.86	33.17	32.81	33.11	14967692.0
2008-01-24 15:00:00	MSFT	Stock	33.11	33.11	32.695	32.88	10313551.0
2008-01-24 15:30:00	MSFT	Stock	32.88	33.36	32.88	33.24	23732463.0
2008-01-24 16:00:00	MSFT	Stock	33.24	34.99	32.39	34.82	13270032.0
2008-01-24 16:30:00	MSFT	Stock	34.82	35.32	33.25	35.3	5336479.0
2008-01-24 17:00:00	MSFT	Stock	35.29	35.31	33.25	34.75	1902604.0
2008-01-24 17:30:00	MSFT	Stock	34.77	34.9	34.75	34.81	302033.0

> showing 50 of 70,467 rows — these rows as CSV

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