PREVIEW / stock_30min / 2007-10-31

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-31.parquet
  size:    1.2 MB
  rows:    69,728
  symbols: 3,180

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-10-31 07:00:00	AAPL	Stock	6.7071	6.7143	6.7071	6.7107	53200.0
2007-10-31 07:30:00	AAPL	Stock	6.71	6.7286	6.71	6.7286	72800.0
2007-10-31 08:00:00	AAPL	Stock	6.7196	6.7268	6.6964	6.7111	2172772.0
2007-10-31 08:30:00	AAPL	Stock	6.7111	6.7143	6.7036	6.7057	1869336.0
2007-10-31 09:00:00	AAPL	Stock	6.7057	6.7096	6.6932	6.7029	1564892.0
2007-10-31 09:30:00	AAPL	Stock	6.7029	6.7489	6.6925	6.7329	76615896.0
2007-10-31 10:00:00	AAPL	Stock	6.7329	6.7486	6.725	6.7436	35870156.0
2007-10-31 10:30:00	AAPL	Stock	6.7436	6.7482	6.7304	6.732	33298104.0
2007-10-31 11:00:00	AAPL	Stock	6.7311	6.7421	6.7254	6.7357	24813908.0
2007-10-31 11:30:00	AAPL	Stock	6.7357	6.7446	6.7325	6.7432	21894544.0
2007-10-31 12:00:00	AAPL	Stock	6.7432	6.7571	6.7357	6.7439	37299052.0
2007-10-31 12:30:00	AAPL	Stock	6.7436	6.7804	6.7361	6.7375	18033596.0
2007-10-31 13:00:00	AAPL	Stock	6.7375	6.7382	6.7236	6.7307	29701364.0
2007-10-31 13:30:00	AAPL	Stock	6.7307	6.7382	6.7182	6.7261	33205928.0
2007-10-31 14:00:00	AAPL	Stock	6.7268	6.7354	6.6054	6.6793	141422232.0
2007-10-31 14:30:00	AAPL	Stock	6.6786	6.79	6.6682	6.7764	138683580.0
2007-10-31 15:00:00	AAPL	Stock	6.7789	6.7839	6.7286	6.7432	103355476.0
2007-10-31 15:30:00	AAPL	Stock	6.7432	6.7857	6.73	6.7811	91231700.0
2007-10-31 16:00:00	AAPL	Stock	6.7814	6.7889	6.6786	6.7793	25025980.0
2007-10-31 16:30:00	AAPL	Stock	6.7818	6.7854	6.7649	6.78	1584688.0
2007-10-31 17:00:00	AAPL	Stock	6.7825	6.7875	6.7821	6.7857	15018276.0
2007-10-31 17:30:00	AAPL	Stock	6.7836	6.7889	6.7829	6.7875	403284.0
2007-10-31 18:00:00	AAPL	Stock	6.7341	6.7893	6.7341	6.7861	496776.0
2007-10-31 18:30:00	AAPL	Stock	6.7875	6.7875	6.7807	6.7821	444332.0
2007-10-31 19:00:00	AAPL	Stock	6.7804	6.7889	6.7804	6.7886	364532.0
2007-10-31 19:30:00	AAPL	Stock	6.7886	6.7893	6.7857	6.7857	129556.0
2007-10-31 07:00:00	MSFT	Stock	35.6	35.6	35.6	35.6	1500.0
2007-10-31 07:30:00	MSFT	Stock	35.6	35.61	35.6	35.61	2232.0
2007-10-31 08:00:00	MSFT	Stock	35.66	35.68	35.56	35.66	34115.0
2007-10-31 08:30:00	MSFT	Stock	35.65	35.66	35.6	35.63	5570.0
2007-10-31 09:00:00	MSFT	Stock	35.63	35.68	35.47	35.62	218983.0
2007-10-31 09:30:00	MSFT	Stock	35.54	35.96	35.51	35.95	14934747.0
2007-10-31 10:00:00	MSFT	Stock	35.95	35.98	35.7	35.905	7611196.0
2007-10-31 10:30:00	MSFT	Stock	35.91	36.25	35.86	36.18	19487026.0
2007-10-31 11:00:00	MSFT	Stock	36.18	36.27	36.05	36.25	8860260.0
2007-10-31 11:30:00	MSFT	Stock	36.25	36.67	36.25	36.57	19212572.0
2007-10-31 12:00:00	MSFT	Stock	36.57	36.64	36.47	36.622	11257243.0
2007-10-31 12:30:00	MSFT	Stock	36.62	36.63	36.39	36.45	12050963.0
2007-10-31 13:00:00	MSFT	Stock	36.442	36.54	36.4	36.48	5612108.0
2007-10-31 13:30:00	MSFT	Stock	36.49	36.65	35.7	36.621	11463433.0
2007-10-31 14:00:00	MSFT	Stock	36.62	36.75	36.4	36.6	15662897.0
2007-10-31 14:30:00	MSFT	Stock	36.6	37.0	36.58	36.97	17923810.0
2007-10-31 15:00:00	MSFT	Stock	36.96	37.0	36.72	36.84	15991851.0
2007-10-31 15:30:00	MSFT	Stock	36.84	36.94	36.62	36.802	16494340.0
2007-10-31 16:00:00	MSFT	Stock	36.79	36.862	35.57	36.72	7875246.0
2007-10-31 16:30:00	MSFT	Stock	36.81	36.817	35.57	36.72	831908.0
2007-10-31 17:00:00	MSFT	Stock	36.72	36.81	36.72	36.75	711822.0
2007-10-31 17:30:00	MSFT	Stock	36.77	36.81	36.72	36.79	10089.0
2007-10-31 18:00:00	MSFT	Stock	36.79	36.92	36.17	36.91	31515.0
2007-10-31 18:30:00	MSFT	Stock	36.9	36.92	36.9	36.9	17962.0

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

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