PREVIEW / etf_30min / 2014-04-28

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-28.parquet
  size:    341 KB
  rows:    11,606

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-28 04:00:00	SPY	ETF	186.94	187.2	186.66	187.12	4385.0
2014-04-28 04:30:00	SPY	ETF	187.1	187.32	187.1	187.3	3198.0
2014-04-28 05:00:00	SPY	ETF	187.26	187.3	187.09	187.25	14653.0
2014-04-28 05:30:00	SPY	ETF	187.2	187.21	187.1	187.21	3490.0
2014-04-28 06:00:00	SPY	ETF	187.24	187.26	187.05	187.05	3467.0
2014-04-28 06:30:00	SPY	ETF	187.04	187.08	186.97	187.04	3623.0
2014-04-28 07:00:00	SPY	ETF	187.05	187.28	187.05	187.28	30896.0
2014-04-28 07:30:00	SPY	ETF	187.28	187.28	187.18	187.26	303585.0
2014-04-28 08:00:00	SPY	ETF	187.26	187.27	187.1	187.16	338706.0
2014-04-28 08:30:00	SPY	ETF	187.17	187.2	186.845	186.85	766638.0
2014-04-28 09:00:00	SPY	ETF	186.85	187.09	186.8	187.06	902362.0
2014-04-28 09:30:00	SPY	ETF	187.05	187.23	186.4	186.95	13998461.0
2014-04-28 10:00:00	SPY	ETF	186.96	187.627	186.84	187.49	9014490.0
2014-04-28 10:30:00	SPY	ETF	187.47	187.69	187.16	187.2	6314745.0
2014-04-28 11:00:00	SPY	ETF	187.2	187.39	186.51	186.515	7285591.0
2014-04-28 11:30:00	SPY	ETF	186.52	186.83	186.14	186.18	7504031.0
2014-04-28 12:00:00	SPY	ETF	186.18	186.46	186.08	186.37	6015389.0
2014-04-28 12:30:00	SPY	ETF	186.38	186.49	186.16	186.2	4669640.0
2014-04-28 13:00:00	SPY	ETF	186.195	186.195	185.12	185.329	11750573.0
2014-04-28 13:30:00	SPY	ETF	185.3269	185.62	184.96	185.43	9166121.0
2014-04-28 14:00:00	SPY	ETF	185.42	186.03	185.15	186.0	7406251.0
2014-04-28 14:30:00	SPY	ETF	186.0	186.28	185.77	186.04	7198201.0
2014-04-28 15:00:00	SPY	ETF	186.03	187.17	186.01	187.03	14780788.0
2014-04-28 15:30:00	SPY	ETF	187.03	187.28	186.87	186.9	16634665.0
2014-04-28 16:00:00	SPY	ETF	186.91	187.15	186.84	187.09	3219337.0
2014-04-28 16:30:00	SPY	ETF	187.1	187.17	186.2921	187.14	3545044.0
2014-04-28 17:00:00	SPY	ETF	187.14	187.2	187.14	187.17	27425.0
2014-04-28 17:30:00	SPY	ETF	187.17	187.17	187.12	187.12	8904.0
2014-04-28 18:00:00	SPY	ETF	187.12	187.2	187.06	187.17	52665.0
2014-04-28 18:30:00	SPY	ETF	187.19	187.37	187.19	187.3	78119.0
2014-04-28 19:00:00	SPY	ETF	187.28	187.32	187.28	187.32	12179.0
2014-04-28 19:30:00	SPY	ETF	187.32	187.32	187.23	187.24	43324.0
2014-04-28 04:30:00	QQQ	ETF	86.69	86.69	86.69	86.69	100.0
2014-04-28 06:00:00	QQQ	ETF	86.62	86.62	86.58	86.58	16000.0
2014-04-28 06:30:00	QQQ	ETF	86.6	86.6	86.54	86.54	35000.0
2014-04-28 07:00:00	QQQ	ETF	86.64	86.72	86.64	86.72	3500.0
2014-04-28 07:30:00	QQQ	ETF	86.72	86.72	86.65	86.68	29315.0
2014-04-28 08:00:00	QQQ	ETF	86.68	86.68	86.55	86.57	59326.0
2014-04-28 08:30:00	QQQ	ETF	86.55	86.55	86.4	86.41	56856.0
2014-04-28 09:00:00	QQQ	ETF	86.41	86.62	86.39	86.59	397214.0
2014-04-28 09:30:00	QQQ	ETF	86.58	86.69	86.09	86.6	6870275.0
2014-04-28 10:00:00	QQQ	ETF	86.62	87.11	86.49	87.02	5123084.0
2014-04-28 10:30:00	QQQ	ETF	87.025	87.1	86.64	86.73	2494201.0
2014-04-28 11:00:00	QQQ	ETF	86.735	86.8744	86.16	86.16	2497796.0
2014-04-28 11:30:00	QQQ	ETF	86.16	86.34	85.83	85.9	4355493.0
2014-04-28 12:00:00	QQQ	ETF	85.89	85.985	85.685	85.91	3763121.0
2014-04-28 12:30:00	QQQ	ETF	85.91	86.03	85.74	85.8	2272339.0
2014-04-28 13:00:00	QQQ	ETF	85.79	85.79	85.13	85.31	4803958.0
2014-04-28 13:30:00	QQQ	ETF	85.31	85.58	85.11	85.49	3955390.0
2014-04-28 14:00:00	QQQ	ETF	85.48	85.88	85.31	85.87	3272526.0

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

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