PREVIEW / etf_30min / 2013-07-17

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-17.parquet
  size:    312 KB
  rows:    10,702

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-17 04:00:00	SPY	ETF	167.64	167.64	167.48	167.58	21600.0
2013-07-17 04:30:00	SPY	ETF	167.57	167.57	167.14	167.34	24800.0
2013-07-17 05:00:00	SPY	ETF	167.34	167.34	167.03	167.12	22650.0
2013-07-17 05:30:00	SPY	ETF	167.13	167.16	167.1	167.1	23800.0
2013-07-17 06:00:00	SPY	ETF	167.14	167.24	167.14	167.24	10200.0
2013-07-17 06:30:00	SPY	ETF	167.22	167.43	167.22	167.42	7400.0
2013-07-17 07:00:00	SPY	ETF	167.42	167.71	167.42	167.68	49867.0
2013-07-17 07:30:00	SPY	ETF	167.66	167.66	167.46	167.46	196525.0
2013-07-17 08:00:00	SPY	ETF	167.61	167.66	167.03	167.58	367040.0
2013-07-17 08:30:00	SPY	ETF	167.6	168.18	167.38	167.98	2317324.0
2013-07-17 09:00:00	SPY	ETF	167.98	168.28	167.98	168.15	1115783.0
2013-07-17 09:30:00	SPY	ETF	168.16	168.26	167.76	167.98	12048283.0
2013-07-17 10:00:00	SPY	ETF	167.98	168.27	167.96	168.24	8322088.0
2013-07-17 10:30:00	SPY	ETF	168.25	168.48	167.85	168.1	9260551.0
2013-07-17 11:00:00	SPY	ETF	168.11	168.26	167.93	167.96	5418642.0
2013-07-17 11:30:00	SPY	ETF	167.97	168.05	167.75	167.88	4336405.0
2013-07-17 12:00:00	SPY	ETF	167.88	168.23	167.86	168.08	4211076.0
2013-07-17 12:30:00	SPY	ETF	168.082	168.22	168.08	168.1499	2367359.0
2013-07-17 13:00:00	SPY	ETF	168.14	168.3	168.05	168.08	3968946.0
2013-07-17 13:30:00	SPY	ETF	168.08	168.18	168.01	168.1501	2171544.0
2013-07-17 14:00:00	SPY	ETF	168.16	168.22	168.11	168.12	2726407.0
2013-07-17 14:30:00	SPY	ETF	168.12	168.12	167.76	167.88	5287119.0
2013-07-17 15:00:00	SPY	ETF	167.871	168.01	167.79	167.92	7039509.0
2013-07-17 15:30:00	SPY	ETF	167.95	168.07	167.73	167.96	12275440.0
2013-07-17 16:00:00	SPY	ETF	167.96	168.14	167.5513	167.95	6023070.0
2013-07-17 16:30:00	SPY	ETF	167.95	168.06	167.93	167.99	346015.0
2013-07-17 17:00:00	SPY	ETF	167.99	168.13	167.97	168.1	120415.0
2013-07-17 17:30:00	SPY	ETF	168.08	168.11	168.07	168.07	21221.0
2013-07-17 18:00:00	SPY	ETF	168.09	168.13	168.04	168.09	20824.0
2013-07-17 18:30:00	SPY	ETF	168.07	168.09	168.07	168.09	1600.0
2013-07-17 19:00:00	SPY	ETF	168.07	168.07	167.85	167.85	39922.0
2013-07-17 19:30:00	SPY	ETF	167.83	167.88	167.82	167.85	45123.0
2013-07-17 04:00:00	QQQ	ETF	75.45	75.45	75.41	75.45	3000.0
2013-07-17 04:30:00	QQQ	ETF	75.42	75.42	75.32	75.36	5000.0
2013-07-17 05:00:00	QQQ	ETF	75.33	75.33	75.26	75.26	3000.0
2013-07-17 05:30:00	QQQ	ETF	75.29	75.29	75.29	75.29	100.0
2013-07-17 06:00:00	QQQ	ETF	75.29	75.33	75.29	75.33	1900.0
2013-07-17 06:30:00	QQQ	ETF	75.32	75.38	75.32	75.38	2900.0
2013-07-17 07:00:00	QQQ	ETF	75.39	75.5	75.39	75.5	7800.0
2013-07-17 07:30:00	QQQ	ETF	75.47	75.47	75.4	75.4	8525.0
2013-07-17 08:00:00	QQQ	ETF	75.49	75.49	75.42	75.44	28540.0
2013-07-17 08:30:00	QQQ	ETF	75.45	75.62	75.45	75.56	108611.0
2013-07-17 09:00:00	QQQ	ETF	75.56	75.65	75.56	75.6	180794.0
2013-07-17 09:30:00	QQQ	ETF	75.6	75.69	75.46	75.53	2316115.0
2013-07-17 10:00:00	QQQ	ETF	75.53	75.64	75.5001	75.63	2180851.0
2013-07-17 10:30:00	QQQ	ETF	75.63	75.74	75.47	75.57	2344536.0
2013-07-17 11:00:00	QQQ	ETF	75.57	75.6298	75.48	75.48	677448.0
2013-07-17 11:30:00	QQQ	ETF	75.47	75.52	75.39	75.5	1078640.0
2013-07-17 12:00:00	QQQ	ETF	75.5	75.68	75.5	75.63	1005465.0
2013-07-17 12:30:00	QQQ	ETF	75.63	75.68	75.6	75.61	570654.0

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

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