PREVIEW / etf_30min / 2014-04-10

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-10.parquet
  size:    352 KB
  rows:    11,733

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
2014-04-10 04:00:00	SPY	ETF	187.17	187.2	187.11	187.11	4560.0
2014-04-10 04:30:00	SPY	ETF	187.11	187.11	186.88	186.9	10740.0
2014-04-10 05:00:00	SPY	ETF	186.85	186.85	186.46	186.54	51164.0
2014-04-10 05:30:00	SPY	ETF	186.54	186.54	186.29	186.48	57362.0
2014-04-10 06:00:00	SPY	ETF	186.5	186.59	186.37	186.59	28466.0
2014-04-10 06:30:00	SPY	ETF	186.58	186.75	186.54	186.75	160677.0
2014-04-10 07:00:00	SPY	ETF	186.75	186.95	186.7	186.95	157000.0
2014-04-10 07:30:00	SPY	ETF	186.94	187.09	186.74	186.75	593453.0
2014-04-10 08:00:00	SPY	ETF	186.89	187.08	186.62	186.68	298833.0
2014-04-10 08:30:00	SPY	ETF	186.69	186.93	186.68	186.85	750772.0
2014-04-10 09:00:00	SPY	ETF	186.89	187.1	186.85	187.09	408566.0
2014-04-10 09:30:00	SPY	ETF	187.09	187.17	186.59	186.77	11086117.0
2014-04-10 10:00:00	SPY	ETF	186.77	186.95	186.47	186.83	7538459.0
2014-04-10 10:30:00	SPY	ETF	186.835	186.87	186.05	186.055	8367996.0
2014-04-10 11:00:00	SPY	ETF	186.05	186.063	185.37	185.44	12644766.0
2014-04-10 11:30:00	SPY	ETF	185.439	185.8	185.4	185.44	8672766.0
2014-04-10 12:00:00	SPY	ETF	185.43	185.54	184.64	184.82	12781616.0
2014-04-10 12:30:00	SPY	ETF	184.83	184.965	184.4	184.41	8443668.0
2014-04-10 13:00:00	SPY	ETF	184.41	184.66	183.86	184.13	12091664.0
2014-04-10 13:30:00	SPY	ETF	184.12	184.46	184.02	184.42	7075859.0
2014-04-10 14:00:00	SPY	ETF	184.419	184.66	184.24	184.24	7544711.0
2014-04-10 14:30:00	SPY	ETF	184.24	184.24	183.68	183.78	9732730.0
2014-04-10 15:00:00	SPY	ETF	183.79	183.795	182.93	183.25	20376147.0
2014-04-10 15:30:00	SPY	ETF	183.255	183.81	183.14	183.15	26543062.0
2014-04-10 16:00:00	SPY	ETF	183.14	187.1004	183.14	183.26	9567770.0
2014-04-10 16:30:00	SPY	ETF	183.27	187.1004	183.27	183.46	5053005.0
2014-04-10 17:00:00	SPY	ETF	183.49	187.1003	183.41	183.41	1700243.0
2014-04-10 17:30:00	SPY	ETF	183.41	183.44	183.3	183.42	72359.0
2014-04-10 18:00:00	SPY	ETF	183.42	183.48	183.27	183.28	90604.0
2014-04-10 18:30:00	SPY	ETF	183.27	183.32	183.25	183.3	24392.0
2014-04-10 19:00:00	SPY	ETF	183.3	183.32	183.25	183.26	10756.0
2014-04-10 19:30:00	SPY	ETF	183.24	183.35	183.23	183.31	37943.0
2014-04-10 04:00:00	QQQ	ETF	87.92	87.95	87.92	87.95	1200.0
2014-04-10 04:30:00	QQQ	ETF	87.92	87.92	87.86	87.86	2700.0
2014-04-10 05:00:00	QQQ	ETF	87.82	87.84	87.59	87.64	12750.0
2014-04-10 05:30:00	QQQ	ETF	87.61	87.61	87.41	87.5	28200.0
2014-04-10 06:00:00	QQQ	ETF	87.48	87.53	87.43	87.53	32400.0
2014-04-10 06:30:00	QQQ	ETF	87.56	87.66	87.54	87.62	10950.0
2014-04-10 07:00:00	QQQ	ETF	87.66	87.78	87.66	87.77	110800.0
2014-04-10 07:30:00	QQQ	ETF	87.79	87.84	87.66	87.66	115110.0
2014-04-10 08:00:00	QQQ	ETF	87.74	87.77	87.58	87.59	67633.0
2014-04-10 08:30:00	QQQ	ETF	87.66	87.77	87.66	87.74	79768.0
2014-04-10 09:00:00	QQQ	ETF	87.77	87.88	87.73	87.87	197027.0
2014-04-10 09:30:00	QQQ	ETF	87.87	87.88	87.0899	87.21	6676709.0
2014-04-10 10:00:00	QQQ	ETF	87.22	87.3	86.96	87.24	4767503.0
2014-04-10 10:30:00	QQQ	ETF	87.25	87.2596	86.64	86.64	4386979.0
2014-04-10 11:00:00	QQQ	ETF	86.64	86.66	86.17	86.19	5907999.0
2014-04-10 11:30:00	QQQ	ETF	86.19	86.47	86.19	86.25	2946318.0
2014-04-10 12:00:00	QQQ	ETF	86.23	86.3	85.78	85.89	5200434.0
2014-04-10 12:30:00	QQQ	ETF	85.89	85.9799	85.67	85.671	2737885.0

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

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