PREVIEW / etf_30min / 2012-11-01

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-01.parquet
  size:    285 KB
  rows:    9,721

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
2012-11-01 04:00:00	SPY	ETF	141.15	141.15	140.77	141.07	29060.0
2012-11-01 04:30:00	SPY	ETF	140.93	140.93	140.93	140.93	100.0
2012-11-01 05:00:00	SPY	ETF	140.94	140.94	140.94	140.94	100.0
2012-11-01 05:30:00	SPY	ETF	140.74	140.83	140.74	140.83	900.0
2012-11-01 06:00:00	SPY	ETF	140.89	141.16	140.89	141.09	59279.0
2012-11-01 06:30:00	SPY	ETF	141.14	141.19	141.12	141.17	36156.0
2012-11-01 07:00:00	SPY	ETF	141.17	141.25	141.12	141.19	46115.0
2012-11-01 07:30:00	SPY	ETF	141.2	141.41	141.15	141.38	327879.0
2012-11-01 08:00:00	SPY	ETF	141.35	141.38	141.19	141.25	332875.0
2012-11-01 08:30:00	SPY	ETF	141.26	141.62	141.26	141.48	1176666.0
2012-11-01 09:00:00	SPY	ETF	141.48	141.65	141.18	141.64	605985.0
2012-11-01 09:30:00	SPY	ETF	141.65	142.31	141.52	142.16	12037304.0
2012-11-01 10:00:00	SPY	ETF	142.16	142.755	142.14	142.56	13215623.0
2012-11-01 10:30:00	SPY	ETF	142.56	142.948	142.552	142.79	6274323.0
2012-11-01 11:00:00	SPY	ETF	142.79	142.87	142.57	142.71	6463323.0
2012-11-01 11:30:00	SPY	ETF	142.71	143.01	142.68	142.86	5447678.0
2012-11-01 12:00:00	SPY	ETF	142.86	142.93	142.77	142.845	3374351.0
2012-11-01 12:30:00	SPY	ETF	142.86	142.92	142.62	142.67	4963418.0
2012-11-01 13:00:00	SPY	ETF	142.66	142.68	142.51	142.575	3581219.0
2012-11-01 13:30:00	SPY	ETF	142.58	142.74	142.52	142.56	3848166.0
2012-11-01 14:00:00	SPY	ETF	142.5636	142.77	142.47	142.67	5801097.0
2012-11-01 14:30:00	SPY	ETF	142.67	142.9	142.58	142.82	5565377.0
2012-11-01 15:00:00	SPY	ETF	142.8201	142.92	142.68	142.75	5642634.0
2012-11-01 15:30:00	SPY	ETF	142.745	142.92	142.58	142.88	12279235.0
2012-11-01 16:00:00	SPY	ETF	142.87	143.1	142.77	142.87	5099434.0
2012-11-01 16:30:00	SPY	ETF	142.87	143.15	141.3476	143.07	2053598.0
2012-11-01 17:00:00	SPY	ETF	143.06	143.09	142.91	142.97	444835.0
2012-11-01 17:30:00	SPY	ETF	143.01	143.08	141.348	143.03	1069737.0
2012-11-01 18:00:00	SPY	ETF	143.03	143.03	142.94	142.94	49652.0
2012-11-01 18:30:00	SPY	ETF	143.0	143.05	142.94	142.95	9000.0
2012-11-01 19:00:00	SPY	ETF	142.95	142.98	142.92	142.98	16961.0
2012-11-01 19:30:00	SPY	ETF	142.93	143.05	142.9	143.05	10730.0
2012-11-01 06:00:00	QQQ	ETF	64.91	64.99	64.91	64.99	6800.0
2012-11-01 06:30:00	QQQ	ETF	65.03	65.03	64.99	64.99	800.0
2012-11-01 07:00:00	QQQ	ETF	65.01	65.04	64.97	65.0	3000.0
2012-11-01 07:30:00	QQQ	ETF	65.0	65.12	64.98	65.11	22095.0
2012-11-01 08:00:00	QQQ	ETF	65.1	65.5	65.05	65.15	17909.0
2012-11-01 08:30:00	QQQ	ETF	65.15	65.24	65.08	65.15	106075.0
2012-11-01 09:00:00	QQQ	ETF	65.16	65.34	65.12	65.32	155124.0
2012-11-01 09:30:00	QQQ	ETF	65.33	65.5	65.17	65.46	3169999.0
2012-11-01 10:00:00	QQQ	ETF	65.47	65.76	65.46	65.71	3258141.0
2012-11-01 10:30:00	QQQ	ETF	65.71	65.93	65.7	65.89	1910545.0
2012-11-01 11:00:00	QQQ	ETF	65.89	65.92	65.76	65.81	1098634.0
2012-11-01 11:30:00	QQQ	ETF	65.81	66.0	65.79	65.94	2463411.0
2012-11-01 12:00:00	QQQ	ETF	65.945	65.98	65.87	65.92	952788.0
2012-11-01 12:30:00	QQQ	ETF	65.93	65.945	65.8	65.82	811391.0
2012-11-01 13:00:00	QQQ	ETF	65.815	65.83	65.73	65.7601	1287193.0
2012-11-01 13:30:00	QQQ	ETF	65.76	65.8699	65.73	65.82	799724.0
2012-11-01 14:00:00	QQQ	ETF	65.8101	65.9	65.76	65.87	1059417.0
2012-11-01 14:30:00	QQQ	ETF	65.87	65.96	65.77	65.93	1156413.0

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

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