PREVIEW / stock_30min / 2009-09-04

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-09-04.parquet
  size:    1.3 MB
  rows:    69,691
  symbols: 3,331

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
2009-09-04 04:00:00	AAPL	Stock	6.0	6.0	6.0	6.0	2800.0
2009-09-04 06:30:00	AAPL	Stock	5.95	5.95	5.95	5.95	2800.0
2009-09-04 07:00:00	AAPL	Stock	5.95	5.9643	5.9464	5.9464	54320.0
2009-09-04 07:30:00	AAPL	Stock	5.9471	5.9643	5.9464	5.9643	33880.0
2009-09-04 08:00:00	AAPL	Stock	5.9754	5.9821	5.9596	5.9625	601244.0
2009-09-04 08:30:00	AAPL	Stock	5.9586	5.9811	5.9225	5.9786	2040024.0
2009-09-04 09:00:00	AAPL	Stock	5.9786	5.9836	5.9679	5.9729	1518552.0
2009-09-04 09:30:00	AAPL	Stock	5.9721	6.0214	5.9675	5.9954	46053392.0
2009-09-04 10:00:00	AAPL	Stock	5.9946	6.021	5.9939	6.0129	24343480.0
2009-09-04 10:30:00	AAPL	Stock	6.0125	6.045	6.0125	6.0407	38690820.0
2009-09-04 11:00:00	AAPL	Stock	6.0407	6.0418	6.025	6.0388	21286944.0
2009-09-04 11:30:00	AAPL	Stock	6.0375	6.0704	6.0343	6.0704	27281912.0
2009-09-04 12:00:00	AAPL	Stock	6.0707	6.0964	6.0664	6.08	49049644.0
2009-09-04 12:30:00	AAPL	Stock	6.0807	6.085	6.07	6.0839	23058700.0
2009-09-04 13:00:00	AAPL	Stock	6.0843	6.09	6.0718	6.0786	20726300.0
2009-09-04 13:30:00	AAPL	Stock	6.0793	6.0839	6.0636	6.0704	20129116.0
2009-09-04 14:00:00	AAPL	Stock	6.0704	6.075	6.0632	6.0643	13820240.0
2009-09-04 14:30:00	AAPL	Stock	6.0632	6.0775	6.0564	6.0725	17919888.0
2009-09-04 15:00:00	AAPL	Stock	6.0721	6.0807	6.0618	6.0768	18189332.0
2009-09-04 15:30:00	AAPL	Stock	6.0764	6.0854	6.0686	6.0804	35067200.0
2009-09-04 16:00:00	AAPL	Stock	6.0843	6.0871	6.0143	6.0814	8952300.0
2009-09-04 16:30:00	AAPL	Stock	6.0832	6.0832	6.0804	6.0832	180852.0
2009-09-04 17:00:00	AAPL	Stock	6.0832	6.0882	6.0821	6.0882	165396.0
2009-09-04 17:30:00	AAPL	Stock	6.0857	6.0857	6.0821	6.085	169008.0
2009-09-04 18:00:00	AAPL	Stock	6.0836	6.0882	6.0825	6.0882	963788.0
2009-09-04 18:30:00	AAPL	Stock	6.0875	6.0893	6.0868	6.0893	70336.0
2009-09-04 19:00:00	AAPL	Stock	6.0893	6.0911	6.0893	6.0907	57204.0
2009-09-04 19:30:00	AAPL	Stock	6.0925	6.0929	6.09	6.0929	126812.0
2009-09-04 04:00:00	MSFT	Stock	24.07	24.07	24.07	24.07	500.0
2009-09-04 04:30:00	MSFT	Stock	24.07	24.07	24.07	24.07	10000.0
2009-09-04 05:30:00	MSFT	Stock	24.07	24.07	24.07	24.07	500.0
2009-09-04 08:00:00	MSFT	Stock	24.11	24.15	24.11	24.15	36300.0
2009-09-04 08:30:00	MSFT	Stock	24.15	24.15	24.06	24.11	14900.0
2009-09-04 09:00:00	MSFT	Stock	24.1	24.11	24.06	24.08	7900.0
2009-09-04 09:30:00	MSFT	Stock	24.09	24.32	24.08	24.18	6392932.0
2009-09-04 10:00:00	MSFT	Stock	24.17	24.31	24.17	24.3	2871437.0
2009-09-04 10:30:00	MSFT	Stock	24.3	24.4	24.27	24.32	2671224.0
2009-09-04 11:00:00	MSFT	Stock	24.32	24.335	24.21	24.24	1828004.0
2009-09-04 11:30:00	MSFT	Stock	24.245	24.34	24.22	24.34	1950750.0
2009-09-04 12:00:00	MSFT	Stock	24.34	24.57	24.33	24.55	3163006.0
2009-09-04 12:30:00	MSFT	Stock	24.56	24.59	24.53	24.56	1761665.0
2009-09-04 13:00:00	MSFT	Stock	24.56	24.711	24.549	24.68	4208564.0
2009-09-04 13:30:00	MSFT	Stock	24.68	24.72	24.68	24.68	3790808.0
2009-09-04 14:00:00	MSFT	Stock	24.68	24.8	24.68	24.792	3507505.0
2009-09-04 14:30:00	MSFT	Stock	24.79	24.8	24.72	24.75	1861745.0
2009-09-04 15:00:00	MSFT	Stock	24.75	24.77	24.62	24.643	2303648.0
2009-09-04 15:30:00	MSFT	Stock	24.65	24.65	24.57	24.63	5967165.0
2009-09-04 16:00:00	MSFT	Stock	24.63	24.64	24.11	24.6	1661718.0
2009-09-04 16:30:00	MSFT	Stock	24.62	24.62	24.6	24.6	6280.0
2009-09-04 17:00:00	MSFT	Stock	24.6	24.6	24.58	24.58	6292.0

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

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