PREVIEW / stock_30min / 2007-11-13

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-13.parquet
  size:    1.2 MB
  rows:    68,909
  symbols: 3,197

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
2007-11-13 04:30:00	AAPL	Stock	5.5107	5.5107	5.5107	5.5107	14000.0
2007-11-13 05:00:00	AAPL	Stock	5.5143	5.525	5.5143	5.525	28000.0
2007-11-13 05:30:00	AAPL	Stock	5.5168	5.5275	5.5168	5.5179	28000.0
2007-11-13 06:00:00	AAPL	Stock	5.5179	5.5643	5.5179	5.55	123480.0
2007-11-13 06:30:00	AAPL	Stock	5.5714	5.6071	5.5714	5.5986	115192.0
2007-11-13 07:00:00	AAPL	Stock	5.5714	5.6021	5.5679	5.5939	406028.0
2007-11-13 07:30:00	AAPL	Stock	5.5861	5.6518	5.5839	5.6429	2617720.0
2007-11-13 08:00:00	AAPL	Stock	5.6429	5.7143	5.6214	5.7025	17226552.0
2007-11-13 08:30:00	AAPL	Stock	5.7004	5.75	5.6946	5.7454	14899164.0
2007-11-13 09:00:00	AAPL	Stock	5.7468	5.7639	5.7236	5.745	14297276.0
2007-11-13 09:30:00	AAPL	Stock	5.7454	5.8271	5.7193	5.8129	284434052.0
2007-11-13 10:00:00	AAPL	Stock	5.8129	5.9164	5.7982	5.8925	182271152.0
2007-11-13 10:30:00	AAPL	Stock	5.8921	5.9403	5.8411	5.9354	127765176.0
2007-11-13 11:00:00	AAPL	Stock	5.935	6.0243	5.8714	6.0104	133916524.0
2007-11-13 11:30:00	AAPL	Stock	6.0129	6.0721	6.0071	6.0232	140451220.0
2007-11-13 12:00:00	AAPL	Stock	6.0232	6.0571	6.0004	6.0164	78770412.0
2007-11-13 12:30:00	AAPL	Stock	6.0164	6.0168	5.9214	5.9393	87208912.0
2007-11-13 13:00:00	AAPL	Stock	5.9393	6.0225	5.9332	6.0171	88634280.0
2007-11-13 13:30:00	AAPL	Stock	6.0168	6.0496	6.0046	6.0089	86596832.0
2007-11-13 14:00:00	AAPL	Stock	6.0079	6.0307	5.9682	5.9686	81955412.0
2007-11-13 14:30:00	AAPL	Stock	5.9686	6.0568	5.9643	6.0418	93385264.0
2007-11-13 15:00:00	AAPL	Stock	6.0425	6.1021	6.0425	6.0911	118321896.0
2007-11-13 15:30:00	AAPL	Stock	6.0911	6.1064	6.0411	6.0666	145953248.0
2007-11-13 16:00:00	AAPL	Stock	6.0671	6.0896	5.4914	6.0582	33493656.0
2007-11-13 16:30:00	AAPL	Stock	6.0575	6.073	6.0536	6.0671	812056.0
2007-11-13 17:00:00	AAPL	Stock	6.0689	6.07	6.0259	6.0671	4941832.0
2007-11-13 17:30:00	AAPL	Stock	6.0643	6.0661	6.0539	6.0571	379148.0
2007-11-13 18:00:00	AAPL	Stock	6.0554	6.0718	6.0539	6.0707	472304.0
2007-11-13 18:30:00	AAPL	Stock	6.0704	6.0889	6.0704	6.0714	756448.0
2007-11-13 19:00:00	AAPL	Stock	6.0714	6.0886	6.0679	6.0879	346164.0
2007-11-13 19:30:00	AAPL	Stock	6.0857	6.0893	6.0839	6.0857	729652.0
2007-11-13 06:30:00	MSFT	Stock	33.4	33.4	33.4	33.4	140.0
2007-11-13 07:00:00	MSFT	Stock	33.63	33.64	33.51	33.51	3100.0
2007-11-13 07:30:00	MSFT	Stock	33.52	33.63	33.5	33.63	3700.0
2007-11-13 08:00:00	MSFT	Stock	33.59	33.64	33.27	33.57	25909.0
2007-11-13 08:30:00	MSFT	Stock	33.59	33.64	33.38	33.62	23844.0
2007-11-13 09:00:00	MSFT	Stock	33.64	33.7	33.54	33.54	206808.0
2007-11-13 09:30:00	MSFT	Stock	33.54	33.6	33.44	33.48	12873940.0
2007-11-13 10:00:00	MSFT	Stock	33.48	33.59	33.47	33.59	8690806.0
2007-11-13 10:30:00	MSFT	Stock	33.58	33.78	33.55	33.66	7650967.0
2007-11-13 11:00:00	MSFT	Stock	33.65	33.69	33.53	33.62	7564180.0
2007-11-13 11:30:00	MSFT	Stock	33.625	33.68	33.55	33.59	4701786.0
2007-11-13 12:00:00	MSFT	Stock	33.59	33.63	33.56	33.57	2732676.0
2007-11-13 12:30:00	MSFT	Stock	33.58	33.6	33.55	33.57	4357901.0
2007-11-13 13:00:00	MSFT	Stock	33.58	33.68	33.54	33.67	5459168.0
2007-11-13 13:30:00	MSFT	Stock	33.68	33.87	33.63	33.81	5872731.0
2007-11-13 14:00:00	MSFT	Stock	33.81	33.98	33.7	33.812	6129081.0
2007-11-13 14:30:00	MSFT	Stock	33.81	34.08	33.79	34.06	6356920.0
2007-11-13 15:00:00	MSFT	Stock	34.07	34.23	33.845	34.19	9759901.0
2007-11-13 15:30:00	MSFT	Stock	34.19	34.67	34.16	34.42	16424643.0

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

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