PREVIEW / stock_30min / 2010-04-14

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-14.parquet
  size:    1.4 MB
  rows:    76,466
  symbols: 3,486

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
2010-04-14 04:00:00	AAPL	Stock	8.7054	8.7186	8.7054	8.7186	25200.0
2010-04-14 05:30:00	AAPL	Stock	8.7143	8.7143	8.7061	8.7061	16800.0
2010-04-14 06:00:00	AAPL	Stock	8.7071	8.7125	8.7071	8.7125	11200.0
2010-04-14 06:30:00	AAPL	Stock	8.7071	8.7104	8.7061	8.7104	30800.0
2010-04-14 07:00:00	AAPL	Stock	8.7107	8.7107	8.6879	8.6879	95956.0
2010-04-14 07:30:00	AAPL	Stock	8.6918	8.6961	8.6857	8.6929	120372.0
2010-04-14 08:00:00	AAPL	Stock	8.6964	8.71	8.6946	8.6993	1867880.0
2010-04-14 08:30:00	AAPL	Stock	8.7	8.8014	8.6971	8.7814	17369660.0
2010-04-14 09:00:00	AAPL	Stock	8.7811	8.7854	8.7543	8.7586	5086144.0
2010-04-14 09:30:00	AAPL	Stock	8.76	8.7682	8.7259	8.74	80226692.0
2010-04-14 10:00:00	AAPL	Stock	8.74	8.7768	8.7168	8.7686	66599596.0
2010-04-14 10:30:00	AAPL	Stock	8.7696	8.775	8.7475	8.7557	35894236.0
2010-04-14 11:00:00	AAPL	Stock	8.7561	8.7629	8.7493	8.7607	27570172.0
2010-04-14 11:30:00	AAPL	Stock	8.7611	8.7745	8.7582	8.7636	19761112.0
2010-04-14 12:00:00	AAPL	Stock	8.7643	8.7657	8.7521	8.7611	13918156.0
2010-04-14 12:30:00	AAPL	Stock	8.7611	8.7664	8.7586	8.7654	10523072.0
2010-04-14 13:00:00	AAPL	Stock	8.7646	8.7671	8.76	8.7671	10136504.0
2010-04-14 13:30:00	AAPL	Stock	8.7668	8.7679	8.75	8.7511	14156016.0
2010-04-14 14:00:00	AAPL	Stock	8.7511	8.7664	8.75	8.7661	12888876.0
2010-04-14 14:30:00	AAPL	Stock	8.7661	8.7711	8.7439	8.7643	14494564.0
2010-04-14 15:00:00	AAPL	Stock	8.7646	8.7689	8.7589	8.7682	15441356.0
2010-04-14 15:30:00	AAPL	Stock	8.7682	8.7789	8.7618	8.7725	46644556.0
2010-04-14 16:00:00	AAPL	Stock	8.7704	8.775	8.7547	8.7743	6793024.0
2010-04-14 16:30:00	AAPL	Stock	8.7671	8.775	8.7671	8.7748	1024212.0
2010-04-14 17:00:00	AAPL	Stock	8.7689	8.7811	8.7689	8.7807	442344.0
2010-04-14 17:30:00	AAPL	Stock	8.7771	8.7821	8.7768	8.7786	187964.0
2010-04-14 18:00:00	AAPL	Stock	8.7768	8.7818	8.7746	8.7786	156128.0
2010-04-14 18:30:00	AAPL	Stock	8.7786	8.7793	8.7786	8.7793	68768.0
2010-04-14 19:00:00	AAPL	Stock	8.7804	8.7818	8.7793	8.7811	101136.0
2010-04-14 19:30:00	AAPL	Stock	8.7811	8.7821	8.7786	8.7821	182784.0
2010-04-14 07:00:00	MSFT	Stock	30.74	30.75	30.7	30.75	1700.0
2010-04-14 07:30:00	MSFT	Stock	30.75	30.8	30.75	30.8	3700.0
2010-04-14 08:00:00	MSFT	Stock	30.8	30.9	30.76	30.83	54012.0
2010-04-14 08:30:00	MSFT	Stock	30.88	30.92	30.85	30.89	40482.0
2010-04-14 09:00:00	MSFT	Stock	30.89	30.9	30.77	30.8	394251.0
2010-04-14 09:30:00	MSFT	Stock	30.81	31.0	30.66	30.988	14194868.0
2010-04-14 10:00:00	MSFT	Stock	30.98	30.99	30.77	30.775	7214710.0
2010-04-14 10:30:00	MSFT	Stock	30.78	30.81	30.75	30.78	4890948.0
2010-04-14 11:00:00	MSFT	Stock	30.785	30.84	30.73	30.78	3690108.0
2010-04-14 11:30:00	MSFT	Stock	30.789	30.89	30.77	30.89	3902330.0
2010-04-14 12:00:00	MSFT	Stock	30.885	30.89	30.81	30.88	2456350.0
2010-04-14 12:30:00	MSFT	Stock	30.88	30.9	30.8	30.81	2346098.0
2010-04-14 13:00:00	MSFT	Stock	30.81	30.88	30.81	30.835	2180967.0
2010-04-14 13:30:00	MSFT	Stock	30.835	30.86	30.75	30.76	2547221.0
2010-04-14 14:00:00	MSFT	Stock	30.77	30.79	30.73	30.77	2221640.0
2010-04-14 14:30:00	MSFT	Stock	30.77	30.81	30.72	30.8	2801837.0
2010-04-14 15:00:00	MSFT	Stock	30.8	30.81	30.72	30.79	2788085.0
2010-04-14 15:30:00	MSFT	Stock	30.78	30.87	30.77	30.83	6264510.0
2010-04-14 16:00:00	MSFT	Stock	30.82	30.872	30.78	30.824	4790427.0
2010-04-14 16:30:00	MSFT	Stock	30.769	30.853	30.769	30.82	159439.0

> showing 50 of 76,466 rows — these rows as CSV

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