PREVIEW / etf_30min / 2013-10-17

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-17.parquet
  size:    349 KB
  rows:    11,669

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-10-17 04:00:00	SPY	ETF	171.77	171.77	171.14	171.33	33053.0
2013-10-17 04:30:00	SPY	ETF	171.35	171.45	171.35	171.41	201308.0
2013-10-17 05:00:00	SPY	ETF	171.43	171.47	171.33	171.33	16912.0
2013-10-17 05:30:00	SPY	ETF	171.32	171.39	171.32	171.39	26688.0
2013-10-17 06:00:00	SPY	ETF	171.41	171.62	171.4	171.59	30100.0
2013-10-17 06:30:00	SPY	ETF	171.57	171.69	171.57	171.65	30500.0
2013-10-17 07:00:00	SPY	ETF	171.67	171.68	171.55	171.57	75466.0
2013-10-17 07:30:00	SPY	ETF	171.57	171.73	171.57	171.68	170853.0
2013-10-17 08:00:00	SPY	ETF	171.67	171.68	171.41	171.55	369669.0
2013-10-17 08:30:00	SPY	ETF	171.55	171.55	171.29	171.3	1037004.0
2013-10-17 09:00:00	SPY	ETF	171.3	171.38	171.15	171.37	901729.0
2013-10-17 09:30:00	SPY	ETF	171.37	171.82	171.34	171.65	14798244.0
2013-10-17 10:00:00	SPY	ETF	171.65	172.1	171.62	172.02	10224796.0
2013-10-17 10:30:00	SPY	ETF	172.03	172.16	171.96	172.05	8050501.0
2013-10-17 11:00:00	SPY	ETF	172.06	172.35	172.04	172.32	9260271.0
2013-10-17 11:30:00	SPY	ETF	172.32	172.68	172.32	172.5683	8284719.0
2013-10-17 12:00:00	SPY	ETF	172.565	172.78	172.5	172.728	5513274.0
2013-10-17 12:30:00	SPY	ETF	172.725	172.95	172.6901	172.94	5448320.0
2013-10-17 13:00:00	SPY	ETF	172.95	172.95	172.63	172.66	5744745.0
2013-10-17 13:30:00	SPY	ETF	172.665	172.78	172.6	172.61	3549880.0
2013-10-17 14:00:00	SPY	ETF	172.605	172.73	172.55	172.635	5463113.0
2013-10-17 14:30:00	SPY	ETF	172.63	172.78	172.61	172.77	4137548.0
2013-10-17 15:00:00	SPY	ETF	172.76	173.02	172.66	172.955	7504839.0
2013-10-17 15:30:00	SPY	ETF	172.96	173.32	172.91	173.22	22256723.0
2013-10-17 16:00:00	SPY	ETF	173.22	173.39	171.4	173.35	8238181.0
2013-10-17 16:30:00	SPY	ETF	173.35	173.35	172.1155	173.26	2895692.0
2013-10-17 17:00:00	SPY	ETF	173.26	173.34	172.1155	173.25	1137332.0
2013-10-17 17:30:00	SPY	ETF	173.25	173.29	173.22	173.22	148159.0
2013-10-17 18:00:00	SPY	ETF	173.23	173.29	173.2	173.24	84797.0
2013-10-17 18:30:00	SPY	ETF	173.22	173.45	173.2	173.41	49366.0
2013-10-17 19:00:00	SPY	ETF	173.4	173.82	173.38	173.68	161201.0
2013-10-17 19:30:00	SPY	ETF	173.63	173.64	173.5	173.62	90487.0
2013-10-17 04:00:00	QQQ	ETF	80.0	80.06	79.95	80.04	9000.0
2013-10-17 04:30:00	QQQ	ETF	80.05	80.09	80.05	80.07	68100.0
2013-10-17 05:00:00	QQQ	ETF	80.08	80.08	80.03	80.04	23072.0
2013-10-17 05:30:00	QQQ	ETF	80.04	80.06	80.0	80.05	12900.0
2013-10-17 06:00:00	QQQ	ETF	80.06	80.16	80.06	80.15	5300.0
2013-10-17 06:30:00	QQQ	ETF	80.14	80.16	80.12	80.16	5000.0
2013-10-17 07:00:00	QQQ	ETF	80.15	80.16	80.12	80.14	35300.0
2013-10-17 07:30:00	QQQ	ETF	80.15	80.16	80.11	80.14	165215.0
2013-10-17 08:00:00	QQQ	ETF	80.15	80.15	80.06	80.08	73318.0
2013-10-17 08:30:00	QQQ	ETF	80.1	80.1	79.98	79.99	137776.0
2013-10-17 09:00:00	QQQ	ETF	79.99	80.03	79.91	80.01	264420.0
2013-10-17 09:30:00	QQQ	ETF	80.0	80.27	79.95	80.17	6007389.0
2013-10-17 10:00:00	QQQ	ETF	80.18	80.37	80.11	80.34	3643376.0
2013-10-17 10:30:00	QQQ	ETF	80.34	80.38	80.26	80.35	1716305.0
2013-10-17 11:00:00	QQQ	ETF	80.35	80.55	80.349	80.51	2269670.0
2013-10-17 11:30:00	QQQ	ETF	80.5099	80.65	80.5051	80.61	1619936.0
2013-10-17 12:00:00	QQQ	ETF	80.62	80.73	80.591	80.71	1413065.0
2013-10-17 12:30:00	QQQ	ETF	80.701	80.78	80.685	80.75	1388885.0

> showing 50 of 11,669 rows — these rows as CSV

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