PREVIEW / etf_30min / 2013-07-31

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-31.parquet
  size:    319 KB
  rows:    10,744

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-07-31 04:00:00	SPY	ETF	168.83	169.1	168.83	169.03	3400.0
2013-07-31 04:30:00	SPY	ETF	169.08	169.18	169.03	169.15	3900.0
2013-07-31 05:00:00	SPY	ETF	169.13	169.13	168.93	168.99	40300.0
2013-07-31 05:30:00	SPY	ETF	169.03	169.04	168.98	168.98	1600.0
2013-07-31 06:00:00	SPY	ETF	168.98	169.13	168.98	169.13	97700.0
2013-07-31 06:30:00	SPY	ETF	169.08	169.14	168.98	168.98	9125.0
2013-07-31 07:00:00	SPY	ETF	168.94	169.02	168.93	168.93	22200.0
2013-07-31 07:30:00	SPY	ETF	168.93	168.93	168.83	168.83	80080.0
2013-07-31 08:00:00	SPY	ETF	168.89	169.0	168.77	168.88	566442.0
2013-07-31 08:30:00	SPY	ETF	168.86	169.1	168.58	168.96	1090611.0
2013-07-31 09:00:00	SPY	ETF	168.95	169.03	168.82	168.97	587392.0
2013-07-31 09:30:00	SPY	ETF	168.94	169.2499	168.91	169.13	10732350.0
2013-07-31 10:00:00	SPY	ETF	169.13	169.49	168.98	169.45	8229173.0
2013-07-31 10:30:00	SPY	ETF	169.46	169.69	169.4	169.62	8963368.0
2013-07-31 11:00:00	SPY	ETF	169.625	169.68	169.32	169.33	5624637.0
2013-07-31 11:30:00	SPY	ETF	169.33	169.49	169.29	169.31	4907381.0
2013-07-31 12:00:00	SPY	ETF	169.3	169.32	169.18	169.21	4129368.0
2013-07-31 12:30:00	SPY	ETF	169.21	169.2199	168.92	168.97	3663318.0
2013-07-31 13:00:00	SPY	ETF	168.97	169.02	168.86	168.91	3852221.0
2013-07-31 13:30:00	SPY	ETF	168.91	169.03	168.9	168.99	3465206.0
2013-07-31 14:00:00	SPY	ETF	168.99	169.48	168.57	169.18	18948060.0
2013-07-31 14:30:00	SPY	ETF	169.18	169.84	169.17	169.835	10155482.0
2013-07-31 15:00:00	SPY	ETF	169.84	169.85	169.23	169.45	8729187.0
2013-07-31 15:30:00	SPY	ETF	169.45	169.47	168.49	168.61	29898675.0
2013-07-31 16:00:00	SPY	ETF	168.61	169.381	168.55	168.96	14107597.0
2013-07-31 16:30:00	SPY	ETF	168.96	169.06	168.5607	169.01	1065233.0
2013-07-31 17:00:00	SPY	ETF	169.03	169.05	168.95	168.97	89337.0
2013-07-31 17:30:00	SPY	ETF	168.95	168.98	168.94	168.98	34073.0
2013-07-31 18:00:00	SPY	ETF	168.98	169.04	168.94	169.02	21773.0
2013-07-31 18:30:00	SPY	ETF	169.01	169.01	168.97	168.99	6600.0
2013-07-31 19:00:00	SPY	ETF	168.97	169.0	168.92	169.0	4400.0
2013-07-31 19:30:00	SPY	ETF	169.0	169.03	168.97	169.01	28180.0
2013-07-31 04:00:00	QQQ	ETF	75.72	75.78	75.72	75.76	4000.0
2013-07-31 04:30:00	QQQ	ETF	75.78	75.8	75.78	75.8	2000.0
2013-07-31 05:00:00	QQQ	ETF	75.78	75.78	75.72	75.74	4800.0
2013-07-31 05:30:00	QQQ	ETF	75.76	75.76	75.76	75.76	1000.0
2013-07-31 06:00:00	QQQ	ETF	75.77	75.78	75.77	75.78	1800.0
2013-07-31 06:30:00	QQQ	ETF	75.79	75.79	75.74	75.74	2800.0
2013-07-31 07:00:00	QQQ	ETF	75.76	75.8	75.76	75.8	5800.0
2013-07-31 07:30:00	QQQ	ETF	75.78	75.78	75.72	75.73	36100.0
2013-07-31 08:00:00	QQQ	ETF	75.72	75.77	75.72	75.74	90074.0
2013-07-31 08:30:00	QQQ	ETF	75.75	75.81	75.64	75.76	75516.0
2013-07-31 09:00:00	QQQ	ETF	75.76	75.79	75.72	75.77	66700.0
2013-07-31 09:30:00	QQQ	ETF	75.77	76.03	75.76	75.95	3341095.0
2013-07-31 10:00:00	QQQ	ETF	75.94	75.98	75.778	75.94	1996081.0
2013-07-31 10:30:00	QQQ	ETF	75.94	75.97	75.87	75.93	1171491.0
2013-07-31 11:00:00	QQQ	ETF	75.93	75.97	75.8399	75.8399	776791.0
2013-07-31 11:30:00	QQQ	ETF	75.84	75.95	75.84	75.8925	647786.0
2013-07-31 12:00:00	QQQ	ETF	75.899	75.899	75.79	75.82	785774.0
2013-07-31 12:30:00	QQQ	ETF	75.82	75.82	75.72	75.75	497187.0

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

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