PREVIEW / etf_30min / 2013-02-22

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-22.parquet
  size:    305 KB
  rows:    10,413

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-02-22 04:00:00	SPY	ETF	151.04	151.15	151.04	151.09	67576.0
2013-02-22 04:30:00	SPY	ETF	151.09	151.09	150.97	150.98	41888.0
2013-02-22 05:00:00	SPY	ETF	150.96	151.07	150.89	151.07	49100.0
2013-02-22 06:00:00	SPY	ETF	151.05	151.15	150.95	151.11	24297.0
2013-02-22 06:30:00	SPY	ETF	151.14	151.26	151.12	151.19	980226.0
2013-02-22 07:00:00	SPY	ETF	151.19	151.37	151.19	151.28	247302.0
2013-02-22 07:30:00	SPY	ETF	151.27	151.33	151.24	151.31	172116.0
2013-02-22 08:00:00	SPY	ETF	151.3	151.38	151.19	151.33	356771.0
2013-02-22 08:30:00	SPY	ETF	151.32	151.36	151.26	151.27	351089.0
2013-02-22 09:00:00	SPY	ETF	151.27	151.29	151.08	151.15	1120587.0
2013-02-22 09:30:00	SPY	ETF	151.15	151.37	150.88	151.02	15111855.0
2013-02-22 10:00:00	SPY	ETF	151.0	151.13	150.82	150.96	7157141.0
2013-02-22 10:30:00	SPY	ETF	150.96	151.19	150.85	150.952	6248713.0
2013-02-22 11:00:00	SPY	ETF	150.95	151.1	150.761	151.06	4857394.0
2013-02-22 11:30:00	SPY	ETF	151.07	151.29	151.03	151.225	4760784.0
2013-02-22 12:00:00	SPY	ETF	151.22	151.32	151.14	151.26	3713794.0
2013-02-22 12:30:00	SPY	ETF	151.26	151.62	151.255	151.54	5578763.0
2013-02-22 13:00:00	SPY	ETF	151.55	151.62	151.36	151.39	5917577.0
2013-02-22 13:30:00	SPY	ETF	151.4	151.57	151.38	151.52	2885339.0
2013-02-22 14:00:00	SPY	ETF	151.52	151.52	151.3	151.36	4622138.0
2013-02-22 14:30:00	SPY	ETF	151.37	151.5	151.32	151.42	3350524.0
2013-02-22 15:00:00	SPY	ETF	151.43	151.58	151.41	151.53	5197846.0
2013-02-22 15:30:00	SPY	ETF	151.54	151.84	151.48	151.84	16892324.0
2013-02-22 16:00:00	SPY	ETF	151.84	151.92	151.2376	151.88	6677951.0
2013-02-22 16:30:00	SPY	ETF	151.88	151.89	151.4864	151.77	2646543.0
2013-02-22 17:00:00	SPY	ETF	151.77	151.88	151.75	151.88	113828.0
2013-02-22 17:30:00	SPY	ETF	151.86	151.93	151.86	151.92	170221.0
2013-02-22 18:00:00	SPY	ETF	151.89	151.95	151.89	151.91	63459.0
2013-02-22 18:30:00	SPY	ETF	151.91	151.92	151.89	151.9	20630.0
2013-02-22 19:00:00	SPY	ETF	151.89	151.9	151.85	151.85	11990.0
2013-02-22 19:30:00	SPY	ETF	151.89	151.93	151.88	151.9	21002.0
2013-02-22 04:00:00	QQQ	ETF	66.8	66.8	66.78	66.78	300.0
2013-02-22 05:00:00	QQQ	ETF	66.75	66.77	66.75	66.77	300.0
2013-02-22 06:00:00	QQQ	ETF	66.75	66.8	66.75	66.8	800.0
2013-02-22 06:30:00	QQQ	ETF	66.82	66.83	66.8	66.83	13600.0
2013-02-22 07:00:00	QQQ	ETF	66.82	66.88	66.82	66.85	23907.0
2013-02-22 07:30:00	QQQ	ETF	66.85	66.91	66.85	66.89	113000.0
2013-02-22 08:00:00	QQQ	ETF	66.85	66.94	66.84	66.92	99530.0
2013-02-22 08:30:00	QQQ	ETF	66.92	66.96	66.9	66.93	55957.0
2013-02-22 09:00:00	QQQ	ETF	66.93	66.94	66.8	66.84	237425.0
2013-02-22 09:30:00	QQQ	ETF	66.84	66.96	66.59	66.75	4391832.0
2013-02-22 10:00:00	QQQ	ETF	66.75	66.85	66.68	66.75	1706674.0
2013-02-22 10:30:00	QQQ	ETF	66.76	66.835	66.69	66.73	1127383.0
2013-02-22 11:00:00	QQQ	ETF	66.72	66.79	66.63	66.77	1235630.0
2013-02-22 11:30:00	QQQ	ETF	66.77	66.8906	66.73	66.84	1017688.0
2013-02-22 12:00:00	QQQ	ETF	66.84	66.9	66.81	66.85	930231.0
2013-02-22 12:30:00	QQQ	ETF	66.85	67.06	66.84	67.03	1556438.0
2013-02-22 13:00:00	QQQ	ETF	67.03	67.06	66.94	66.97	977281.0
2013-02-22 13:30:00	QQQ	ETF	66.98	67.05	66.96	67.0245	583098.0
2013-02-22 14:00:00	QQQ	ETF	67.02	67.02	66.92	66.9545	857495.0

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

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