PREVIEW / etf_30min / 2010-08-06

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-06.parquet
  size:    257 KB
  rows:    8,474

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-06 04:00:00	SPY	ETF	113.0	113.04	113.0	113.02	978.0
2010-08-06 04:30:00	SPY	ETF	112.94	113.02	112.94	113.0	800.0
2010-08-06 05:00:00	SPY	ETF	112.86	112.86	112.86	112.86	500.0
2010-08-06 05:30:00	SPY	ETF	112.87	112.87	112.87	112.87	1100.0
2010-08-06 06:00:00	SPY	ETF	112.94	113.0	112.85	113.0	7619.0
2010-08-06 06:30:00	SPY	ETF	112.98	113.0	112.97	112.98	70300.0
2010-08-06 07:00:00	SPY	ETF	112.96	113.18	112.91	113.09	1268162.0
2010-08-06 07:30:00	SPY	ETF	113.08	113.15	113.01	113.12	184100.0
2010-08-06 08:00:00	SPY	ETF	113.09	113.2	112.9	113.2	2229248.0
2010-08-06 08:30:00	SPY	ETF	113.04	113.09	111.66	111.87	15027403.0
2010-08-06 09:00:00	SPY	ETF	111.86	111.99	111.71	111.74	2937180.0
2010-08-06 09:30:00	SPY	ETF	111.74	112.56	111.67	112.5	28844912.0
2010-08-06 10:00:00	SPY	ETF	112.51	112.57	112.14	112.23	14734270.0
2010-08-06 10:30:00	SPY	ETF	112.22	112.35	111.05	111.17	30085335.0
2010-08-06 11:00:00	SPY	ETF	111.18	111.37	110.92	111.299	22104841.0
2010-08-06 11:30:00	SPY	ETF	111.29	111.46	111.2	111.28	10554014.0
2010-08-06 12:00:00	SPY	ETF	111.28	111.33	111.12	111.14	8253393.0
2010-08-06 12:30:00	SPY	ETF	111.14	111.36	111.1	111.22	5391545.0
2010-08-06 13:00:00	SPY	ETF	111.2181	111.33	111.13	111.22	6280009.0
2010-08-06 13:30:00	SPY	ETF	111.22	111.38	111.12	111.2698	7976392.0
2010-08-06 14:00:00	SPY	ETF	111.26	111.43	111.13	111.42	7340949.0
2010-08-06 14:30:00	SPY	ETF	111.42	112.0	111.35	111.93	14985366.0
2010-08-06 15:00:00	SPY	ETF	111.93	112.28	111.8	112.1	20061954.0
2010-08-06 15:30:00	SPY	ETF	112.11	112.43	112.01	112.39	26105081.0
2010-08-06 16:00:00	SPY	ETF	112.38	112.8236	111.103	112.46	6426795.0
2010-08-06 16:30:00	SPY	ETF	112.45	112.8237	112.41	112.41	2669764.0
2010-08-06 17:00:00	SPY	ETF	112.45	112.7	112.44	112.66	433347.0
2010-08-06 17:30:00	SPY	ETF	112.67	112.68	112.43	112.5	58237.0
2010-08-06 18:00:00	SPY	ETF	112.53	112.62	112.5	112.5	35984.0
2010-08-06 18:30:00	SPY	ETF	112.5	112.55	112.46	112.52	20350.0
2010-08-06 19:00:00	SPY	ETF	112.52	112.54	112.5	112.54	24488.0
2010-08-06 19:30:00	SPY	ETF	112.54	112.54	112.48	112.5	29068.0
2010-08-06 05:00:00	QQQ	ETF	46.76	46.76	46.76	46.76	404.0
2010-08-06 05:30:00	QQQ	ETF	46.73	46.73	46.73	46.73	19275.0
2010-08-06 07:00:00	QQQ	ETF	46.89	46.89	46.89	46.89	600.0
2010-08-06 07:30:00	QQQ	ETF	46.88	46.89	46.87	46.87	51214.0
2010-08-06 08:00:00	QQQ	ETF	46.89	46.95	46.83	46.91	325752.0
2010-08-06 08:30:00	QQQ	ETF	46.91	46.91	46.28	46.36	2899938.0
2010-08-06 09:00:00	QQQ	ETF	46.37	46.4	46.29	46.32	584183.0
2010-08-06 09:30:00	QQQ	ETF	46.32	46.82	46.3	46.8	9132430.0
2010-08-06 10:00:00	QQQ	ETF	46.81	46.85	46.64	46.67	4571198.0
2010-08-06 10:30:00	QQQ	ETF	46.67	46.73	46.1	46.16	10702219.0
2010-08-06 11:00:00	QQQ	ETF	46.15	46.31	46.05	46.26	4950926.0
2010-08-06 11:30:00	QQQ	ETF	46.25	46.37	46.22	46.31	2430664.0
2010-08-06 12:00:00	QQQ	ETF	46.3	46.33	46.19	46.2015	2953790.0
2010-08-06 12:30:00	QQQ	ETF	46.2	46.35	46.19	46.3101	1604301.0
2010-08-06 13:00:00	QQQ	ETF	46.32	46.3602	46.255	46.32	1799448.0
2010-08-06 13:30:00	QQQ	ETF	46.32	46.4	46.27	46.332	1803266.0
2010-08-06 14:00:00	QQQ	ETF	46.34	46.37	46.27	46.37	2186553.0
2010-08-06 14:30:00	QQQ	ETF	46.37	46.67	46.37	46.65	4884049.0

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

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