PREVIEW / etf_30min / 2011-04-25

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-25.parquet
  size:    276 KB
  rows:    9,265

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
2011-04-25 04:00:00	SPY	ETF	133.85	133.95	133.85	133.95	2735.0
2011-04-25 04:30:00	SPY	ETF	133.91	133.91	133.91	133.91	100.0
2011-04-25 05:30:00	SPY	ETF	133.92	133.92	133.91	133.91	500.0
2011-04-25 06:00:00	SPY	ETF	133.92	133.92	133.91	133.91	300.0
2011-04-25 06:30:00	SPY	ETF	133.93	133.94	133.9	133.94	22800.0
2011-04-25 07:00:00	SPY	ETF	133.95	133.96	133.92	133.94	52798.0
2011-04-25 07:30:00	SPY	ETF	133.94	133.96	133.88	133.91	81718.0
2011-04-25 08:00:00	SPY	ETF	133.93	133.93	133.8	133.81	132916.0
2011-04-25 08:30:00	SPY	ETF	133.79	133.81	133.61	133.67	405883.0
2011-04-25 09:00:00	SPY	ETF	133.68	133.76	133.62	133.68	499694.0
2011-04-25 09:30:00	SPY	ETF	133.68	133.86	133.49	133.76	8572836.0
2011-04-25 10:00:00	SPY	ETF	133.76	133.83	133.3	133.4	8087644.0
2011-04-25 10:30:00	SPY	ETF	133.4	133.46	133.23	133.32	6940455.0
2011-04-25 11:00:00	SPY	ETF	133.32	133.38	133.2	133.35	3554014.0
2011-04-25 11:30:00	SPY	ETF	133.35	133.54	133.33	133.505	4343453.0
2011-04-25 12:00:00	SPY	ETF	133.5	133.58	133.48	133.56	2738517.0
2011-04-25 12:30:00	SPY	ETF	133.55	133.61	133.48	133.55	1833782.0
2011-04-25 13:00:00	SPY	ETF	133.54	133.56	133.5	133.55	933880.0
2011-04-25 13:30:00	SPY	ETF	133.555	133.64	133.55	133.62	1956105.0
2011-04-25 14:00:00	SPY	ETF	133.62	133.72	133.61	133.63	2919158.0
2011-04-25 14:30:00	SPY	ETF	133.6332	133.66	133.58	133.65	2076381.0
2011-04-25 15:00:00	SPY	ETF	133.66	133.8066	133.49	133.61	3965807.0
2011-04-25 15:30:00	SPY	ETF	133.6	133.68	133.52	133.61	8321549.0
2011-04-25 16:00:00	SPY	ETF	133.63	133.71	133.46	133.5	5483342.0
2011-04-25 16:30:00	SPY	ETF	133.53	133.69	133.53	133.67	321813.0
2011-04-25 17:00:00	SPY	ETF	133.65	133.73	133.65	133.73	74679.0
2011-04-25 17:30:00	SPY	ETF	133.73	133.73	133.62	133.65	40020.0
2011-04-25 18:00:00	SPY	ETF	133.67	133.78	133.62	133.75	243701.0
2011-04-25 18:30:00	SPY	ETF	133.75	133.77	133.73	133.75	54255.0
2011-04-25 19:00:00	SPY	ETF	133.76	133.78	133.73	133.78	68992.0
2011-04-25 19:30:00	SPY	ETF	133.77	133.78	133.7	133.74	45984.0
2011-04-25 04:00:00	QQQ	ETF	58.48	58.5	58.48	58.5	929.0
2011-04-25 04:30:00	QQQ	ETF	58.51	58.52	58.51	58.52	200.0
2011-04-25 06:30:00	QQQ	ETF	58.5	58.51	58.5	58.51	800.0
2011-04-25 07:00:00	QQQ	ETF	58.54	58.55	58.52	58.55	18513.0
2011-04-25 07:30:00	QQQ	ETF	58.54	58.54	58.52	58.52	28400.0
2011-04-25 08:00:00	QQQ	ETF	58.5	58.51	58.48	58.48	77157.0
2011-04-25 08:30:00	QQQ	ETF	58.45	58.46	58.39	58.42	143641.0
2011-04-25 09:00:00	QQQ	ETF	58.42	58.44	58.38	58.4	391684.0
2011-04-25 09:30:00	QQQ	ETF	58.4	58.52	58.33	58.481	2558423.0
2011-04-25 10:00:00	QQQ	ETF	58.49	58.51	58.3	58.35	2855378.0
2011-04-25 10:30:00	QQQ	ETF	58.3501	58.39	58.29	58.34	3282541.0
2011-04-25 11:00:00	QQQ	ETF	58.34	58.35	58.28	58.325	899731.0
2011-04-25 11:30:00	QQQ	ETF	58.325	58.41	58.32	58.405	813548.0
2011-04-25 12:00:00	QQQ	ETF	58.4038	58.44	58.39	58.402	805491.0
2011-04-25 12:30:00	QQQ	ETF	58.405	58.42	58.36	58.392	308571.0
2011-04-25 13:00:00	QQQ	ETF	58.4	58.42	58.37	58.405	294267.0
2011-04-25 13:30:00	QQQ	ETF	58.41	58.45	58.4	58.43	393371.0
2011-04-25 14:00:00	QQQ	ETF	58.435	58.52	58.43	58.49	2523792.0
2011-04-25 14:30:00	QQQ	ETF	58.49	58.52	58.47	58.51	674697.0

> showing 50 of 9,265 rows — these rows as CSV

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