PREVIEW / stock_30min / 2008-11-21

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-21.parquet
  size:    1.3 MB
  rows:    74,580
  symbols: 3,379

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-11-21 04:30:00	AAPL	Stock	3.0	3.0	3.0	3.0	5600.0
2008-11-21 05:30:00	AAPL	Stock	3.0	3.0	3.0	3.0	2800.0
2008-11-21 06:00:00	AAPL	Stock	3.0	3.0	3.0	3.0	2800.0
2008-11-21 06:30:00	AAPL	Stock	2.9693	2.9821	2.9629	2.9821	8400.0
2008-11-21 07:00:00	AAPL	Stock	2.9643	2.9768	2.9643	2.9661	137480.0
2008-11-21 07:30:00	AAPL	Stock	2.9664	2.9664	2.8968	2.9107	863464.0
2008-11-21 08:00:00	AAPL	Stock	2.9196	2.9529	2.875	2.9479	3530828.0
2008-11-21 08:30:00	AAPL	Stock	2.9475	2.9621	2.9393	2.9529	3191328.0
2008-11-21 09:00:00	AAPL	Stock	2.9532	2.9607	2.9261	2.9264	2422028.0
2008-11-21 09:30:00	AAPL	Stock	2.9261	3.0043	2.9018	2.9736	195686680.0
2008-11-21 10:00:00	AAPL	Stock	2.9736	2.9914	2.9364	2.9404	127933792.0
2008-11-21 10:30:00	AAPL	Stock	2.9404	2.9643	2.9075	2.9121	101300724.0
2008-11-21 11:00:00	AAPL	Stock	2.9125	2.9514	2.8918	2.9457	93859836.0
2008-11-21 11:30:00	AAPL	Stock	2.9457	2.9557	2.9114	2.9154	68795944.0
2008-11-21 12:00:00	AAPL	Stock	2.9157	2.9393	2.9025	2.9354	70676172.0
2008-11-21 12:30:00	AAPL	Stock	2.9346	2.9518	2.9171	2.92	64817480.0
2008-11-21 13:00:00	AAPL	Stock	2.9204	2.9239	2.8761	2.8807	77122248.0
2008-11-21 13:30:00	AAPL	Stock	2.8807	2.9171	2.8493	2.8507	88874576.0
2008-11-21 14:00:00	AAPL	Stock	2.8504	2.9014	2.8393	2.8732	103428192.0
2008-11-21 14:30:00	AAPL	Stock	2.8732	2.8804	2.8264	2.845	108946572.0
2008-11-21 15:00:00	AAPL	Stock	2.8454	2.9432	2.8432	2.9096	174380584.0
2008-11-21 15:30:00	AAPL	Stock	2.91	2.9643	2.8854	2.9493	207817652.0
2008-11-21 16:00:00	AAPL	Stock	2.9521	2.9546	2.9029	2.9494	38796744.0
2008-11-21 16:30:00	AAPL	Stock	2.9446	2.95	2.9157	2.9436	3979024.0
2008-11-21 17:00:00	AAPL	Stock	2.9429	2.9468	2.8689	2.8689	224336.0
2008-11-21 17:30:00	AAPL	Stock	2.8719	2.9436	2.8625	2.9108	949032.0
2008-11-21 18:00:00	AAPL	Stock	2.9396	2.9464	2.908	2.9457	111804.0
2008-11-21 18:30:00	AAPL	Stock	2.9457	2.9461	2.9364	2.9396	131460.0
2008-11-21 19:00:00	AAPL	Stock	2.9411	2.9457	2.9411	2.9457	72828.0
2008-11-21 19:30:00	AAPL	Stock	2.9418	2.9446	2.9375	2.9379	48664.0
2008-11-21 04:00:00	MSFT	Stock	17.96	19.2	17.96	19.2	3200.0
2008-11-21 07:00:00	MSFT	Stock	18.13	18.13	18.13	18.13	600.0
2008-11-21 07:30:00	MSFT	Stock	18.02	18.02	18.0	18.0	7000.0
2008-11-21 08:00:00	MSFT	Stock	18.0	18.03	17.9	17.99	50871.0
2008-11-21 08:30:00	MSFT	Stock	17.96	18.1	17.9	18.0	38036.0
2008-11-21 09:00:00	MSFT	Stock	18.0	18.22	17.98	18.0	165553.0
2008-11-21 09:30:00	MSFT	Stock	18.02	18.64	17.98	18.59	15568302.0
2008-11-21 10:00:00	MSFT	Stock	18.59	18.62	18.3	18.31	11457939.0
2008-11-21 10:30:00	MSFT	Stock	18.31	18.52	18.07	18.26	9344313.0
2008-11-21 11:00:00	MSFT	Stock	18.25	18.56	17.98	18.51	9924560.0
2008-11-21 11:30:00	MSFT	Stock	18.49	18.75	18.49	18.64	7383021.0
2008-11-21 12:00:00	MSFT	Stock	18.63	18.78	18.56	18.77	6106506.0
2008-11-21 12:30:00	MSFT	Stock	18.78	19.0	18.71	18.885	6773366.0
2008-11-21 13:00:00	MSFT	Stock	18.886	18.9	18.57	18.69	6629597.0
2008-11-21 13:30:00	MSFT	Stock	18.7	18.86	18.63	18.64	6004568.0
2008-11-21 14:00:00	MSFT	Stock	18.63	18.88	18.55	18.65	8660881.0
2008-11-21 14:30:00	MSFT	Stock	18.66	18.84	18.45	18.67	9578919.0
2008-11-21 15:00:00	MSFT	Stock	18.67	19.16	18.65	19.09	15241274.0
2008-11-21 15:30:00	MSFT	Stock	19.092	19.7	19.02	19.69	24842312.0
2008-11-21 16:00:00	MSFT	Stock	19.69	19.81	18.279	19.682	12243568.0

> showing 50 of 74,580 rows — these rows as CSV

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