PREVIEW / etf_30min / 2014-02-05

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-05.parquet
  size:    348 KB
  rows:    11,609

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-02-05 04:00:00	SPY	ETF	174.76	174.92	174.69	174.9	30884.0
2014-02-05 04:30:00	SPY	ETF	174.86	174.88	174.79	174.79	114012.0
2014-02-05 05:00:00	SPY	ETF	174.75	174.87	174.61	174.83	29793.0
2014-02-05 05:30:00	SPY	ETF	174.81	174.88	174.62	174.62	7971.0
2014-02-05 06:00:00	SPY	ETF	174.6	174.62	174.42	174.52	32408.0
2014-02-05 06:30:00	SPY	ETF	174.55	174.76	174.5	174.52	51625.0
2014-02-05 07:00:00	SPY	ETF	174.55	174.71	174.3	174.55	202234.0
2014-02-05 07:30:00	SPY	ETF	174.57	174.63	174.31	174.37	409941.0
2014-02-05 08:00:00	SPY	ETF	174.37	174.63	173.94	174.06	1683056.0
2014-02-05 08:30:00	SPY	ETF	174.05	174.87	173.99	174.76	1850644.0
2014-02-05 09:00:00	SPY	ETF	174.75	174.88	174.62	174.78	1889176.0
2014-02-05 09:30:00	SPY	ETF	174.79	175.19	174.37	174.52	19307807.0
2014-02-05 10:00:00	SPY	ETF	174.53	175.4	173.71	174.062	27226073.0
2014-02-05 10:30:00	SPY	ETF	174.06	174.61	173.93	174.31	14025625.0
2014-02-05 11:00:00	SPY	ETF	174.32	174.76	173.92	174.75	9829727.0
2014-02-05 11:30:00	SPY	ETF	174.745	175.26	174.62	175.14	10413393.0
2014-02-05 12:00:00	SPY	ETF	175.1399	175.36	174.91	175.02	6970298.0
2014-02-05 12:30:00	SPY	ETF	175.02	175.2	174.9799	175.18	6992617.0
2014-02-05 13:00:00	SPY	ETF	175.18	175.56	175.16	175.305	7433026.0
2014-02-05 13:30:00	SPY	ETF	175.3	175.55	175.26	175.41	7648294.0
2014-02-05 14:00:00	SPY	ETF	175.41	175.56	175.16	175.39	6856341.0
2014-02-05 14:30:00	SPY	ETF	175.39	175.5	174.93	175.0199	5726065.0
2014-02-05 15:00:00	SPY	ETF	175.0199	175.4	174.92	175.39	8661286.0
2014-02-05 15:30:00	SPY	ETF	175.4	175.54	175.08	175.14	16036295.0
2014-02-05 16:00:00	SPY	ETF	175.14	175.4866	174.8	174.86	6813111.0
2014-02-05 16:30:00	SPY	ETF	174.87	175.515	174.87	175.07	1199021.0
2014-02-05 17:00:00	SPY	ETF	175.08	175.12	175.02	175.09	281153.0
2014-02-05 17:30:00	SPY	ETF	175.07	175.07	174.95	174.95	49078.0
2014-02-05 18:00:00	SPY	ETF	174.95	175.1	174.94	175.1	87861.0
2014-02-05 18:30:00	SPY	ETF	175.08	175.1	174.98	175.1	58284.0
2014-02-05 19:00:00	SPY	ETF	175.02	175.24	175.02	175.24	71404.0
2014-02-05 19:30:00	SPY	ETF	175.24	175.39	175.2	175.24	375319.0
2014-02-05 05:30:00	QQQ	ETF	84.67	84.67	84.57	84.57	3800.0
2014-02-05 06:00:00	QQQ	ETF	84.51	84.51	84.48	84.48	3100.0
2014-02-05 06:30:00	QQQ	ETF	84.56	84.56	84.56	84.56	100.0
2014-02-05 07:00:00	QQQ	ETF	84.57	84.67	84.57	84.63	53800.0
2014-02-05 07:30:00	QQQ	ETF	84.58	84.59	84.51	84.51	14400.0
2014-02-05 08:00:00	QQQ	ETF	84.54	84.62	84.35	84.38	149870.0
2014-02-05 08:30:00	QQQ	ETF	84.39	84.77	84.39	84.75	62445.0
2014-02-05 09:00:00	QQQ	ETF	84.73	84.74	84.65	84.65	172022.0
2014-02-05 09:30:00	QQQ	ETF	84.64	84.89	84.33	84.43	6189395.0
2014-02-05 10:00:00	QQQ	ETF	84.38	84.8199	83.74	84.02	7279793.0
2014-02-05 10:30:00	QQQ	ETF	84.02	84.22	83.89	84.09	4145696.0
2014-02-05 11:00:00	QQQ	ETF	84.09	84.4	83.87	84.39	2862138.0
2014-02-05 11:30:00	QQQ	ETF	84.39	84.77	84.33	84.7203	2884375.0
2014-02-05 12:00:00	QQQ	ETF	84.73	84.87	84.59	84.69	2745929.0
2014-02-05 12:30:00	QQQ	ETF	84.69	84.82	84.68	84.789	1055122.0
2014-02-05 13:00:00	QQQ	ETF	84.8	84.9901	84.77	84.82	1643183.0
2014-02-05 13:30:00	QQQ	ETF	84.829	84.97	84.81	84.9	973811.0
2014-02-05 14:00:00	QQQ	ETF	84.9	84.97	84.75	84.91	1183942.0

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

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