PREVIEW / etf_30min / 2013-04-10

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-10.parquet
  size:    316 KB
  rows:    10,629

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
2013-04-10 04:00:00	SPY	ETF	157.06	157.1	157.04	157.09	6640.0
2013-04-10 04:30:00	SPY	ETF	157.06	157.09	157.04	157.04	2499.0
2013-04-10 05:00:00	SPY	ETF	157.04	157.16	157.04	157.15	8500.0
2013-04-10 05:30:00	SPY	ETF	157.13	157.18	157.13	157.17	17200.0
2013-04-10 06:00:00	SPY	ETF	157.19	157.28	157.16	157.24	6608.0
2013-04-10 06:30:00	SPY	ETF	157.24	157.3	157.21	157.25	42410.0
2013-04-10 07:00:00	SPY	ETF	157.25	157.25	157.16	157.16	51999.0
2013-04-10 07:30:00	SPY	ETF	157.17	157.27	157.15	157.2	160634.0
2013-04-10 08:00:00	SPY	ETF	157.17	157.22	156.98	157.06	338156.0
2013-04-10 08:30:00	SPY	ETF	157.06	157.28	156.82	157.03	1182852.0
2013-04-10 09:00:00	SPY	ETF	157.03	157.28	156.94	157.17	1977294.0
2013-04-10 09:30:00	SPY	ETF	157.17	157.64	157.13	157.63	13069343.0
2013-04-10 10:00:00	SPY	ETF	157.62	157.95	157.62	157.9	12940891.0
2013-04-10 10:30:00	SPY	ETF	157.9	158.35	157.82	158.35	10544942.0
2013-04-10 11:00:00	SPY	ETF	158.35	158.53	158.22	158.3901	12073488.0
2013-04-10 11:30:00	SPY	ETF	158.4	158.6	158.33	158.47	7891785.0
2013-04-10 12:00:00	SPY	ETF	158.47	158.58	158.37	158.5	4621158.0
2013-04-10 12:30:00	SPY	ETF	158.51	158.8	158.5	158.75	5851315.0
2013-04-10 13:00:00	SPY	ETF	158.75	158.8	158.62	158.75	7079362.0
2013-04-10 13:30:00	SPY	ETF	158.77	158.84	158.61	158.68	6245617.0
2013-04-10 14:00:00	SPY	ETF	158.69	158.84	158.6	158.625	4711355.0
2013-04-10 14:30:00	SPY	ETF	158.625	158.71	158.52	158.655	6279068.0
2013-04-10 15:00:00	SPY	ETF	158.66	158.69	158.45	158.65	6352895.0
2013-04-10 15:30:00	SPY	ETF	158.65	158.87	158.53	158.7	17904557.0
2013-04-10 16:00:00	SPY	ETF	158.71	158.76	156.7929	158.67	10751881.0
2013-04-10 16:30:00	SPY	ETF	158.68	158.83	158.67	158.78	1580331.0
2013-04-10 17:00:00	SPY	ETF	158.8	158.82	158.78	158.79	128752.0
2013-04-10 17:30:00	SPY	ETF	158.79	158.8	158.77	158.79	5490.0
2013-04-10 18:00:00	SPY	ETF	158.77	158.77	158.65	158.67	98341.0
2013-04-10 18:30:00	SPY	ETF	158.67	158.71	158.67	158.67	8100.0
2013-04-10 19:00:00	SPY	ETF	158.68	158.69	158.65	158.68	12990.0
2013-04-10 19:30:00	SPY	ETF	158.69	158.7	158.62	158.63	105847.0
2013-04-10 05:00:00	QQQ	ETF	68.9	68.9	68.9	68.9	3000.0
2013-04-10 06:00:00	QQQ	ETF	68.93	68.93	68.93	68.93	900.0
2013-04-10 06:30:00	QQQ	ETF	68.95	68.95	68.92	68.92	11140.0
2013-04-10 07:00:00	QQQ	ETF	68.93	68.93	68.93	68.93	600.0
2013-04-10 07:30:00	QQQ	ETF	68.94	68.95	68.9	68.9	16500.0
2013-04-10 08:00:00	QQQ	ETF	68.9	68.95	68.84	68.87	26618.0
2013-04-10 08:30:00	QQQ	ETF	68.89	68.96	68.81	68.89	56350.0
2013-04-10 09:00:00	QQQ	ETF	68.88	68.95	68.68	68.9	152791.0
2013-04-10 09:30:00	QQQ	ETF	68.9	69.24	68.88	69.22	4352218.0
2013-04-10 10:00:00	QQQ	ETF	69.22	69.6	69.22	69.535	5577576.0
2013-04-10 10:30:00	QQQ	ETF	69.54	70.17	69.525	69.85	2586368.0
2013-04-10 11:00:00	QQQ	ETF	69.855	69.93	69.77	69.87	2908590.0
2013-04-10 11:30:00	QQQ	ETF	69.87	69.96	69.8301	69.9216	2356000.0
2013-04-10 12:00:00	QQQ	ETF	69.93	69.99	69.861	69.911	1120991.0
2013-04-10 12:30:00	QQQ	ETF	69.928	70.12	69.928	70.06	2658402.0
2013-04-10 13:00:00	QQQ	ETF	70.065	70.09	70.01	70.075	1250733.0
2013-04-10 13:30:00	QQQ	ETF	70.07	70.11	70.0	70.01	1002193.0
2013-04-10 14:00:00	QQQ	ETF	70.01	70.07	69.95	69.95	2275416.0

> showing 50 of 10,629 rows — these rows as CSV

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