PREVIEW / stock_30min / 2008-11-06

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-06.parquet
  size:    1.2 MB
  rows:    69,441
  symbols: 3,307

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-06 05:30:00	AAPL	Stock	3.5836	3.5836	3.5836	3.5836	54320.0
2008-11-06 07:00:00	AAPL	Stock	3.6129	3.6321	3.6046	3.6321	226352.0
2008-11-06 07:30:00	AAPL	Stock	3.635	3.6443	3.6143	3.6161	397880.0
2008-11-06 08:00:00	AAPL	Stock	3.6186	3.6186	3.5804	3.6071	1604820.0
2008-11-06 08:30:00	AAPL	Stock	3.6071	3.6421	3.6054	3.6321	2083004.0
2008-11-06 09:00:00	AAPL	Stock	3.6311	3.6429	3.6075	3.6107	3006836.0
2008-11-06 09:30:00	AAPL	Stock	3.6107	3.6707	3.5714	3.5718	187274444.0
2008-11-06 10:00:00	AAPL	Stock	3.5718	3.5921	3.5143	3.5675	162845200.0
2008-11-06 10:30:00	AAPL	Stock	3.5682	3.575	3.5357	3.5679	85168888.0
2008-11-06 11:00:00	AAPL	Stock	3.5682	3.5775	3.5268	3.565	84124264.0
2008-11-06 11:30:00	AAPL	Stock	3.565	3.5889	3.5414	3.5646	67606896.0
2008-11-06 12:00:00	AAPL	Stock	3.5657	3.5714	3.5082	3.5175	67498144.0
2008-11-06 12:30:00	AAPL	Stock	3.5179	3.5471	3.5	3.5361	71684564.0
2008-11-06 13:00:00	AAPL	Stock	3.5368	3.5443	3.5	3.5369	61741624.0
2008-11-06 13:30:00	AAPL	Stock	3.5371	3.5643	3.5175	3.5611	73517500.0
2008-11-06 14:00:00	AAPL	Stock	3.5611	3.5811	3.5482	3.5606	78958404.0
2008-11-06 14:30:00	AAPL	Stock	3.5611	3.6193	3.5582	3.5761	100480968.0
2008-11-06 15:00:00	AAPL	Stock	3.5766	3.585	3.5196	3.5275	101829532.0
2008-11-06 15:30:00	AAPL	Stock	3.5268	3.5632	3.5111	3.5411	126383824.0
2008-11-06 16:00:00	AAPL	Stock	3.5425	3.6429	3.5286	3.5357	25727352.0
2008-11-06 16:30:00	AAPL	Stock	3.5339	3.5623	3.525	3.5357	1546776.0
2008-11-06 17:00:00	AAPL	Stock	3.5357	3.5439	3.535	3.5439	3437336.0
2008-11-06 17:30:00	AAPL	Stock	3.5454	3.5618	3.5393	3.5446	745360.0
2008-11-06 18:00:00	AAPL	Stock	3.5446	3.5511	3.5293	3.5293	204932.0
2008-11-06 18:30:00	AAPL	Stock	3.5296	3.5411	3.5286	3.5407	174160.0
2008-11-06 19:00:00	AAPL	Stock	3.5314	3.5404	3.5304	3.5361	85344.0
2008-11-06 19:30:00	AAPL	Stock	3.5357	3.5411	3.5329	3.5361	110460.0
2008-11-06 07:30:00	MSFT	Stock	22.0	22.0	21.97	21.97	1400.0
2008-11-06 08:00:00	MSFT	Stock	22.08	22.08	21.9	21.95	31884.0
2008-11-06 08:30:00	MSFT	Stock	21.95	22.07	21.91	22.0	5997.0
2008-11-06 09:00:00	MSFT	Stock	21.99	22.05	21.8	21.92	135481.0
2008-11-06 09:30:00	MSFT	Stock	21.92	22.08	21.64	21.731	7906238.0
2008-11-06 10:00:00	MSFT	Stock	21.72	21.87	21.5	21.71	5924105.0
2008-11-06 10:30:00	MSFT	Stock	21.71	21.8	21.55	21.68	5406314.0
2008-11-06 11:00:00	MSFT	Stock	21.67	21.7	21.46	21.63	4671017.0
2008-11-06 11:30:00	MSFT	Stock	21.631	21.65	21.44	21.578	5610778.0
2008-11-06 12:00:00	MSFT	Stock	21.575	21.65	21.31	21.32	4479109.0
2008-11-06 12:30:00	MSFT	Stock	21.32	21.41	21.25	21.39	4627182.0
2008-11-06 13:00:00	MSFT	Stock	21.39	21.42	21.16	21.22	5511311.0
2008-11-06 13:30:00	MSFT	Stock	21.23	21.23	21.04	21.14	5226899.0
2008-11-06 14:00:00	MSFT	Stock	21.14	21.28	21.05	21.079	7391386.0
2008-11-06 14:30:00	MSFT	Stock	21.08	21.3	21.05	21.09	6709770.0
2008-11-06 15:00:00	MSFT	Stock	21.09	21.15	20.93	20.97	8115105.0
2008-11-06 15:30:00	MSFT	Stock	20.97	21.181	20.86	20.97	15428799.0
2008-11-06 16:00:00	MSFT	Stock	20.95	21.47	20.87	20.95	6689769.0
2008-11-06 16:30:00	MSFT	Stock	20.99	21.03	20.88	21.02	74160.0
2008-11-06 17:00:00	MSFT	Stock	21.03	21.03	20.88	21.0	763358.0
2008-11-06 17:30:00	MSFT	Stock	21.175	21.73	20.88	21.73	77319.0
2008-11-06 18:00:00	MSFT	Stock	21.02	21.05	21.0	21.0	12766.0
2008-11-06 18:30:00	MSFT	Stock	21.04	21.14	21.03	21.05	31266.0

> showing 50 of 69,441 rows — these rows as CSV

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