PREVIEW / stock_30min / 2009-10-16

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-10-16.parquet
  size:    1.3 MB
  rows:    71,430
  symbols: 3,391

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-10-16 06:30:00	AAPL	Stock	6.8286	6.8286	6.7857	6.8057	215600.0
2009-10-16 07:00:00	AAPL	Stock	6.8025	6.8025	6.7857	6.7857	85400.0
2009-10-16 07:30:00	AAPL	Stock	6.7857	6.7857	6.7686	6.7686	135912.0
2009-10-16 08:00:00	AAPL	Stock	6.7818	6.7836	6.7446	6.7539	2020396.0
2009-10-16 08:30:00	AAPL	Stock	6.7536	6.7607	6.7461	6.7489	780920.0
2009-10-16 09:00:00	AAPL	Stock	6.75	6.7664	6.75	6.7604	872228.0
2009-10-16 09:30:00	AAPL	Stock	6.7621	6.7986	6.7282	6.7721	90065976.0
2009-10-16 10:00:00	AAPL	Stock	6.7721	6.7729	6.7339	6.7525	44557856.0
2009-10-16 10:30:00	AAPL	Stock	6.7525	6.7607	6.7386	6.7386	27326320.0
2009-10-16 11:00:00	AAPL	Stock	6.7382	6.7504	6.7354	6.7436	22918336.0
2009-10-16 11:30:00	AAPL	Stock	6.7429	6.7475	6.7293	6.7355	19682796.0
2009-10-16 12:00:00	AAPL	Stock	6.7364	6.75	6.7336	6.7429	19339684.0
2009-10-16 12:30:00	AAPL	Stock	6.7429	6.7446	6.7339	6.7443	14011116.0
2009-10-16 13:00:00	AAPL	Stock	6.7438	6.75	6.7339	6.7493	20482364.0
2009-10-16 13:30:00	AAPL	Stock	6.7493	6.7693	6.7486	6.7552	24331216.0
2009-10-16 14:00:00	AAPL	Stock	6.755	6.76	6.745	6.7554	18141760.0
2009-10-16 14:30:00	AAPL	Stock	6.7539	6.7596	6.7432	6.7453	11704420.0
2009-10-16 15:00:00	AAPL	Stock	6.7453	6.7554	6.7432	6.7539	22059016.0
2009-10-16 15:30:00	AAPL	Stock	6.7539	6.7607	6.7086	6.7179	66329060.0
2009-10-16 16:00:00	AAPL	Stock	6.7182	6.7472	6.6982	6.7036	11693472.0
2009-10-16 16:30:00	AAPL	Stock	6.7036	6.7089	6.7029	6.7089	274988.0
2009-10-16 17:00:00	AAPL	Stock	6.7086	6.7121	6.7054	6.7054	374360.0
2009-10-16 17:30:00	AAPL	Stock	6.7036	6.7186	6.6964	6.7179	714056.0
2009-10-16 18:00:00	AAPL	Stock	6.7182	6.7221	6.6793	6.6839	1981420.0
2009-10-16 18:30:00	AAPL	Stock	6.6839	6.6875	6.6804	6.6821	294196.0
2009-10-16 19:00:00	AAPL	Stock	6.685	6.6857	6.6786	6.6789	133616.0
2009-10-16 19:30:00	AAPL	Stock	6.6789	6.6904	6.6775	6.6857	181888.0
2009-10-16 07:00:00	MSFT	Stock	26.58	26.58	26.58	26.58	100.0
2009-10-16 07:30:00	MSFT	Stock	26.58	26.58	26.58	26.58	900.0
2009-10-16 08:00:00	MSFT	Stock	26.6	26.6	26.45	26.45	7809.0
2009-10-16 08:30:00	MSFT	Stock	26.49	26.49	26.45	26.48	11382.0
2009-10-16 09:00:00	MSFT	Stock	26.48	26.71	26.42	26.46	83521.0
2009-10-16 09:30:00	MSFT	Stock	26.45	26.63	26.41	26.44	5056850.0
2009-10-16 10:00:00	MSFT	Stock	26.44	26.44	26.19	26.31	5264754.0
2009-10-16 10:30:00	MSFT	Stock	26.3	26.55	26.16	26.165	3399691.0
2009-10-16 11:00:00	MSFT	Stock	26.16	26.19	26.1	26.14	3180769.0
2009-10-16 11:30:00	MSFT	Stock	26.14	26.2	26.1	26.19	2730216.0
2009-10-16 12:00:00	MSFT	Stock	26.18	26.27	26.15	26.15	2532935.0
2009-10-16 12:30:00	MSFT	Stock	26.155	26.18	26.1	26.17	2118197.0
2009-10-16 13:00:00	MSFT	Stock	26.171	26.43	26.15	26.42	4130425.0
2009-10-16 13:30:00	MSFT	Stock	26.42	26.56	26.41	26.44	3224740.0
2009-10-16 14:00:00	MSFT	Stock	26.44	26.53	26.38	26.5	2975261.0
2009-10-16 14:30:00	MSFT	Stock	26.5	26.52	26.41	26.43	1724802.0
2009-10-16 15:00:00	MSFT	Stock	26.42	26.53	26.42	26.5	2756291.0
2009-10-16 15:30:00	MSFT	Stock	26.49	26.54	26.41	26.49	5987942.0
2009-10-16 16:00:00	MSFT	Stock	26.49	26.567	26.344	26.48	4891432.0
2009-10-16 16:30:00	MSFT	Stock	26.46	26.47	26.46	26.47	693.0
2009-10-16 17:00:00	MSFT	Stock	26.45	26.47	26.4	26.47	1750.0
2009-10-16 17:30:00	MSFT	Stock	26.4	26.4	26.32	26.32	7900.0
2009-10-16 18:00:00	MSFT	Stock	26.32	26.5	26.32	26.36	13909.0

> showing 50 of 71,430 rows — these rows as CSV

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