PREVIEW / etf_30min / 2010-08-20

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-20.parquet
  size:    248 KB
  rows:    8,283

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-08-20 04:00:00	SPY	ETF	107.79	107.79	107.62	107.7	2200.0
2010-08-20 04:30:00	SPY	ETF	107.6	107.62	107.55	107.55	2400.0
2010-08-20 05:00:00	SPY	ETF	107.61	107.67	107.53	107.53	400.0
2010-08-20 05:30:00	SPY	ETF	107.5	107.5	107.32	107.32	9930.0
2010-08-20 06:00:00	SPY	ETF	107.4	107.42	106.95	106.95	16150.0
2010-08-20 06:30:00	SPY	ETF	107.02	107.16	106.97	106.97	43467.0
2010-08-20 07:00:00	SPY	ETF	106.95	107.25	106.95	107.23	143592.0
2010-08-20 07:30:00	SPY	ETF	107.25	107.31	107.08	107.18	209061.0
2010-08-20 08:00:00	SPY	ETF	107.16	107.35	107.13	107.13	680315.0
2010-08-20 08:30:00	SPY	ETF	107.13	107.38	107.03	107.38	2031067.0
2010-08-20 09:00:00	SPY	ETF	107.38	107.58	107.23	107.56	2313916.0
2010-08-20 09:30:00	SPY	ETF	107.56	107.69	107.0	107.28	28294509.0
2010-08-20 10:00:00	SPY	ETF	107.28	107.5	107.05	107.21	22349400.0
2010-08-20 10:30:00	SPY	ETF	107.21	107.45	107.19	107.27	10695754.0
2010-08-20 11:00:00	SPY	ETF	107.26	107.35	107.0	107.14	9504166.0
2010-08-20 11:30:00	SPY	ETF	107.13	107.9376	106.7499	106.8026	16952278.0
2010-08-20 12:00:00	SPY	ETF	106.81	107.08	106.8	107.05	7500092.0
2010-08-20 12:30:00	SPY	ETF	107.05	107.1	106.93	107.08	5090063.0
2010-08-20 13:00:00	SPY	ETF	107.08	107.26	107.06	107.18	5178628.0
2010-08-20 13:30:00	SPY	ETF	107.185	107.29	107.05	107.15	7499914.0
2010-08-20 14:00:00	SPY	ETF	107.15	107.36	107.14	107.26	7386092.0
2010-08-20 14:30:00	SPY	ETF	107.2599	107.71	107.2	107.53	16651099.0
2010-08-20 15:00:00	SPY	ETF	107.54	107.65	107.4	107.54	12066609.0
2010-08-20 15:30:00	SPY	ETF	107.549	107.7	107.5	107.54	25045881.0
2010-08-20 16:00:00	SPY	ETF	107.54	108.42	106.885	107.72	17969408.0
2010-08-20 16:30:00	SPY	ETF	107.72	107.9376	107.5438	107.63	8443383.0
2010-08-20 17:00:00	SPY	ETF	107.61	107.71	107.6	107.61	2303923.0
2010-08-20 17:30:00	SPY	ETF	107.61	107.65	107.51	107.61	116157.0
2010-08-20 18:00:00	SPY	ETF	107.62	108.0	107.52	107.65	127379.0
2010-08-20 18:30:00	SPY	ETF	107.65	107.69	107.61	107.62	15132.0
2010-08-20 19:00:00	SPY	ETF	107.64	107.68	107.62	107.65	2725.0
2010-08-20 19:30:00	SPY	ETF	107.64	107.7	107.61	107.7	12490.0
2010-08-20 05:30:00	QQQ	ETF	44.7	44.7	44.69	44.69	300.0
2010-08-20 06:00:00	QQQ	ETF	44.62	44.62	44.53	44.53	1262.0
2010-08-20 06:30:00	QQQ	ETF	44.56	44.61	44.51	44.51	25276.0
2010-08-20 07:00:00	QQQ	ETF	44.53	44.68	44.53	44.66	21924.0
2010-08-20 07:30:00	QQQ	ETF	44.68	44.69	44.61	44.65	37400.0
2010-08-20 08:00:00	QQQ	ETF	44.65	44.69	44.62	44.62	86279.0
2010-08-20 08:30:00	QQQ	ETF	44.61	44.7	44.59	44.7	268069.0
2010-08-20 09:00:00	QQQ	ETF	44.7	44.81	44.64	44.79	680316.0
2010-08-20 09:30:00	QQQ	ETF	44.79	44.89	44.61	44.8	7612582.0
2010-08-20 10:00:00	QQQ	ETF	44.8	44.95	44.64	44.68	12350537.0
2010-08-20 10:30:00	QQQ	ETF	44.69	44.81	44.69	44.73	4478017.0
2010-08-20 11:00:00	QQQ	ETF	44.73	44.77	44.63	44.68	2792812.0
2010-08-20 11:30:00	QQQ	ETF	44.68	44.69	44.54	44.56	3124423.0
2010-08-20 12:00:00	QQQ	ETF	44.5589	44.69	44.55	44.6666	2008368.0
2010-08-20 12:30:00	QQQ	ETF	44.67	44.72	44.63	44.71	1231806.0
2010-08-20 13:00:00	QQQ	ETF	44.7105	44.8	44.71	44.76	2637128.0
2010-08-20 13:30:00	QQQ	ETF	44.76	44.82	44.7	44.77	1744117.0
2010-08-20 14:00:00	QQQ	ETF	44.7705	44.88	44.76	44.8334	2810972.0

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

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