PREVIEW / etf_30min / 2014-06-02

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-02.parquet
  size:    325 KB
  rows:    11,383

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-06-02 04:00:00	SPY	ETF	192.85	192.85	192.78	192.78	550.0
2014-06-02 04:30:00	SPY	ETF	192.83	192.83	192.83	192.83	100.0
2014-06-02 05:00:00	SPY	ETF	192.83	192.85	192.83	192.85	351.0
2014-06-02 05:30:00	SPY	ETF	192.86	192.86	192.86	192.86	4000.0
2014-06-02 06:00:00	SPY	ETF	192.97	192.98	192.97	192.98	17729.0
2014-06-02 06:30:00	SPY	ETF	192.9	192.96	192.88	192.96	24026.0
2014-06-02 07:00:00	SPY	ETF	192.9	192.92	192.82	192.85	110368.0
2014-06-02 07:30:00	SPY	ETF	192.85	192.87	192.8	192.82	127543.0
2014-06-02 08:00:00	SPY	ETF	192.83	192.9	192.81	192.85	157454.0
2014-06-02 08:30:00	SPY	ETF	192.82	192.9	192.82	192.84	152570.0
2014-06-02 09:00:00	SPY	ETF	192.86	192.97	192.85	192.95	542087.0
2014-06-02 09:30:00	SPY	ETF	192.95	192.98	192.48	192.52	9296675.0
2014-06-02 10:00:00	SPY	ETF	192.5	192.55	191.97	192.33	8013996.0
2014-06-02 10:30:00	SPY	ETF	192.32	192.41	192.16	192.38	4648472.0
2014-06-02 11:00:00	SPY	ETF	192.38	192.91	192.3	192.86	7516832.0
2014-06-02 11:30:00	SPY	ETF	192.8699	192.94	192.75	192.85	4425035.0
2014-06-02 12:00:00	SPY	ETF	192.85	192.86	192.71	192.8	2020779.0
2014-06-02 12:30:00	SPY	ETF	192.8	192.85	192.76	192.78	1368002.0
2014-06-02 13:00:00	SPY	ETF	192.78	192.85	192.66	192.82	2461152.0
2014-06-02 13:30:00	SPY	ETF	192.825	192.85	192.7	192.805	1671654.0
2014-06-02 14:00:00	SPY	ETF	192.81	192.9	192.71	192.88	2111053.0
2014-06-02 14:30:00	SPY	ETF	192.89	192.94	192.82	192.85	1635592.0
2014-06-02 15:00:00	SPY	ETF	192.86	192.86	192.66	192.73	3566511.0
2014-06-02 15:30:00	SPY	ETF	192.73	192.99	192.72	192.9	7173619.0
2014-06-02 16:00:00	SPY	ETF	192.88	192.91	192.669	192.77	5151759.0
2014-06-02 16:30:00	SPY	ETF	192.77	192.895	192.77	192.81	1128138.0
2014-06-02 17:00:00	SPY	ETF	192.81	192.84	192.78	192.82	34184.0
2014-06-02 17:30:00	SPY	ETF	192.79	192.8951	192.76	192.8	207093.0
2014-06-02 18:00:00	SPY	ETF	192.78	192.8	192.68	192.69	145192.0
2014-06-02 18:30:00	SPY	ETF	192.73	192.73	192.68	192.72	41300.0
2014-06-02 19:00:00	SPY	ETF	192.71	192.72	192.69	192.71	18595.0
2014-06-02 19:30:00	SPY	ETF	192.7	192.74	192.69	192.73	27515.0
2014-06-02 05:00:00	QQQ	ETF	91.36	91.36	91.36	91.36	2000.0
2014-06-02 06:00:00	QQQ	ETF	91.4	91.4	91.4	91.4	2500.0
2014-06-02 06:30:00	QQQ	ETF	91.45	91.45	91.42	91.42	1600.0
2014-06-02 07:30:00	QQQ	ETF	91.4	91.4	91.4	91.4	960.0
2014-06-02 08:00:00	QQQ	ETF	91.57	91.57	91.33	91.37	566724.0
2014-06-02 08:30:00	QQQ	ETF	91.37	91.41	91.35	91.39	65805.0
2014-06-02 09:00:00	QQQ	ETF	91.4	91.48	91.38	91.45	75761.0
2014-06-02 09:30:00	QQQ	ETF	91.43	91.44	90.95	90.975	5217332.0
2014-06-02 10:00:00	QQQ	ETF	90.97	91.02	90.64	90.93	3777543.0
2014-06-02 10:30:00	QQQ	ETF	90.92	91.05	90.81	90.97	1915977.0
2014-06-02 11:00:00	QQQ	ETF	90.9799	91.27	90.93	91.24	1617789.0
2014-06-02 11:30:00	QQQ	ETF	91.24	91.33	91.17	91.25	1112131.0
2014-06-02 12:00:00	QQQ	ETF	91.26	91.275	91.12	91.141	884410.0
2014-06-02 12:30:00	QQQ	ETF	91.149	91.185	91.1	91.13	555047.0
2014-06-02 13:00:00	QQQ	ETF	91.1299	91.155	91.015	91.12	804312.0
2014-06-02 13:30:00	QQQ	ETF	91.115	91.155	90.98	91.065	841261.0
2014-06-02 14:00:00	QQQ	ETF	91.069	91.0999	90.87	91.03	1272124.0
2014-06-02 14:30:00	QQQ	ETF	91.04	91.16	91.03	91.07	860461.0

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

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