PREVIEW / etf_30min / 2010-09-13

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-13.parquet
  size:    255 KB
  rows:    8,591

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-09-13 04:00:00	SPY	ETF	111.87	112.58	111.87	112.58	3320.0
2010-09-13 04:30:00	SPY	ETF	112.5	112.61	112.5	112.61	2110.0
2010-09-13 05:00:00	SPY	ETF	112.6	112.73	112.57	112.62	36395.0
2010-09-13 05:30:00	SPY	ETF	112.6	112.64	112.53	112.61	8401.0
2010-09-13 06:00:00	SPY	ETF	112.54	112.56	112.49	112.5	5055.0
2010-09-13 06:30:00	SPY	ETF	112.5	112.6	112.47	112.49	32610.0
2010-09-13 07:00:00	SPY	ETF	112.53	112.54	112.45	112.45	138500.0
2010-09-13 07:30:00	SPY	ETF	112.47	112.59	112.43	112.46	602850.0
2010-09-13 08:00:00	SPY	ETF	112.44	112.53	112.4	112.44	494218.0
2010-09-13 08:30:00	SPY	ETF	112.44	112.46	112.32	112.37	1047636.0
2010-09-13 09:00:00	SPY	ETF	112.36	112.6	112.35	112.58	1052322.0
2010-09-13 09:30:00	SPY	ETF	112.58	112.78	112.42	112.5	19696362.0
2010-09-13 10:00:00	SPY	ETF	112.49	112.82	112.49	112.79	10130389.0
2010-09-13 10:30:00	SPY	ETF	112.79	112.95	112.78	112.8	10532995.0
2010-09-13 11:00:00	SPY	ETF	112.8	112.83	112.7	112.798	6656130.0
2010-09-13 11:30:00	SPY	ETF	112.8	112.81	112.52	112.64	10670462.0
2010-09-13 12:00:00	SPY	ETF	112.65	112.66	112.13	112.29	8915088.0
2010-09-13 12:30:00	SPY	ETF	112.29	112.4	112.21	112.34	6914024.0
2010-09-13 13:00:00	SPY	ETF	112.34	112.53	112.26	112.47	15472488.0
2010-09-13 13:30:00	SPY	ETF	112.46	112.53	112.36	112.36	5583945.0
2010-09-13 14:00:00	SPY	ETF	112.37	112.5	112.21	112.47	12564312.0
2010-09-13 14:30:00	SPY	ETF	112.47	112.58	112.43	112.53	6491790.0
2010-09-13 15:00:00	SPY	ETF	112.53	112.63	112.41	112.6039	10008846.0
2010-09-13 15:30:00	SPY	ETF	112.61	112.86	112.56	112.74	19607983.0
2010-09-13 16:00:00	SPY	ETF	112.74	112.845	111.4971	112.7	18499588.0
2010-09-13 16:30:00	SPY	ETF	112.69	112.83	112.65	112.82	11256279.0
2010-09-13 17:00:00	SPY	ETF	112.8	113.0	112.8	112.94	262993.0
2010-09-13 17:30:00	SPY	ETF	112.9	112.92	112.84	112.86	65516.0
2010-09-13 18:00:00	SPY	ETF	112.88	112.98	112.84	112.89	274295.0
2010-09-13 18:30:00	SPY	ETF	112.9	112.9	112.72	112.84	55185.0
2010-09-13 19:00:00	SPY	ETF	112.86	112.88	112.84	112.86	135781.0
2010-09-13 19:30:00	SPY	ETF	112.85	112.86	112.76	112.76	178893.0
2010-09-13 04:00:00	QQQ	ETF	46.75	47.0	46.75	47.0	1100.0
2010-09-13 04:30:00	QQQ	ETF	46.98	46.98	46.98	46.98	100.0
2010-09-13 05:00:00	QQQ	ETF	47.04	47.04	47.04	47.04	300.0
2010-09-13 06:30:00	QQQ	ETF	46.94	46.97	46.94	46.96	7801.0
2010-09-13 07:00:00	QQQ	ETF	46.94	46.95	46.92	46.92	45235.0
2010-09-13 07:30:00	QQQ	ETF	46.92	46.97	46.9	46.92	12055.0
2010-09-13 08:00:00	QQQ	ETF	46.92	46.93	46.88	46.9	239586.0
2010-09-13 08:30:00	QQQ	ETF	46.9	46.91	46.84	46.85	44166.0
2010-09-13 09:00:00	QQQ	ETF	46.85	46.94	46.85	46.94	359990.0
2010-09-13 09:30:00	QQQ	ETF	46.95	47.23	46.94	47.07	8841258.0
2010-09-13 10:00:00	QQQ	ETF	47.08	47.25	47.08	47.2005	3813378.0
2010-09-13 10:30:00	QQQ	ETF	47.21	47.33	47.2089	47.27	4572547.0
2010-09-13 11:00:00	QQQ	ETF	47.27	47.31	47.25	47.3	3278760.0
2010-09-13 11:30:00	QQQ	ETF	47.2981	47.3	47.18	47.2301	4228247.0
2010-09-13 12:00:00	QQQ	ETF	47.23	47.23	47.04	47.1	2971773.0
2010-09-13 12:30:00	QQQ	ETF	47.1	47.15	47.04	47.1	2269090.0
2010-09-13 13:00:00	QQQ	ETF	47.1	47.2	47.07	47.14	2604481.0
2010-09-13 13:30:00	QQQ	ETF	47.15	47.185	47.12	47.145	4633073.0

> showing 50 of 8,591 rows — these rows as CSV

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