PREVIEW / etf_30min / 2013-09-27

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-27.parquet
  size:    300 KB
  rows:    10,350

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-09-27 04:00:00	SPY	ETF	169.65	169.65	169.32	169.33	89600.0
2013-09-27 04:30:00	SPY	ETF	169.33	169.34	169.26	169.26	32005.0
2013-09-27 05:00:00	SPY	ETF	169.25	169.3	169.04	169.11	26364.0
2013-09-27 05:30:00	SPY	ETF	169.09	169.09	169.02	169.06	27171.0
2013-09-27 06:00:00	SPY	ETF	169.08	169.24	169.04	169.12	14094.0
2013-09-27 06:30:00	SPY	ETF	169.1	169.11	168.92	168.96	91209.0
2013-09-27 07:00:00	SPY	ETF	168.96	169.08	168.94	169.01	109774.0
2013-09-27 07:30:00	SPY	ETF	169.04	169.06	168.9	169.04	198627.0
2013-09-27 08:00:00	SPY	ETF	169.04	169.06	168.85	168.96	372443.0
2013-09-27 08:30:00	SPY	ETF	168.94	169.09	168.93	169.07	461255.0
2013-09-27 09:00:00	SPY	ETF	169.07	169.11	168.74	168.82	826213.0
2013-09-27 09:30:00	SPY	ETF	168.84	168.99	168.59	168.72	13419287.0
2013-09-27 10:00:00	SPY	ETF	168.72	168.87	168.47	168.77	8514560.0
2013-09-27 10:30:00	SPY	ETF	168.77	169.04	168.73	168.9095	6644046.0
2013-09-27 11:00:00	SPY	ETF	168.91	168.96	168.64	168.85	7104168.0
2013-09-27 11:30:00	SPY	ETF	168.85	169.14	168.8	168.95	5709825.0
2013-09-27 12:00:00	SPY	ETF	168.96	169.08	168.85	169.018	3153710.0
2013-09-27 12:30:00	SPY	ETF	169.02	169.13	168.92	169.03	2722940.0
2013-09-27 13:00:00	SPY	ETF	169.03	169.13	168.91	168.925	2363724.0
2013-09-27 13:30:00	SPY	ETF	168.93	169.02	168.88	168.92	2074066.0
2013-09-27 14:00:00	SPY	ETF	168.92	168.96	168.68	168.8201	5068221.0
2013-09-27 14:30:00	SPY	ETF	168.829	168.9	168.69	168.78	4974187.0
2013-09-27 15:00:00	SPY	ETF	168.78	168.851	168.64	168.83	5467817.0
2013-09-27 15:30:00	SPY	ETF	168.84	169.11	168.79	168.94	14360062.0
2013-09-27 16:00:00	SPY	ETF	168.97	169.6569	168.92	169.02	5599547.0
2013-09-27 16:30:00	SPY	ETF	169.02	169.06	168.8734	168.98	1576314.0
2013-09-27 17:00:00	SPY	ETF	168.98	169.03	168.95	168.95	982213.0
2013-09-27 17:30:00	SPY	ETF	169.0	169.02	168.91	168.94	38278.0
2013-09-27 18:00:00	SPY	ETF	168.92	168.94	168.8621	168.94	276286.0
2013-09-27 18:30:00	SPY	ETF	168.93	168.97	168.93	168.97	3420.0
2013-09-27 19:00:00	SPY	ETF	168.95	169.06	168.95	169.06	119938.0
2013-09-27 19:30:00	SPY	ETF	169.06	169.06	169.01	169.01	25844.0
2013-09-27 04:00:00	QQQ	ETF	79.11	79.11	79.09	79.09	11000.0
2013-09-27 04:30:00	QQQ	ETF	79.08	79.09	79.05	79.05	6100.0
2013-09-27 05:00:00	QQQ	ETF	79.06	79.07	78.89	78.9	21761.0
2013-09-27 05:30:00	QQQ	ETF	78.89	78.89	78.85	78.88	6350.0
2013-09-27 06:00:00	QQQ	ETF	78.87	78.96	78.87	78.93	9100.0
2013-09-27 06:30:00	QQQ	ETF	78.92	78.92	78.86	78.86	18300.0
2013-09-27 07:00:00	QQQ	ETF	78.87	78.93	78.87	78.89	11493.0
2013-09-27 07:30:00	QQQ	ETF	78.9	78.91	78.84	78.88	29250.0
2013-09-27 08:00:00	QQQ	ETF	78.88	78.89	78.82	78.82	74050.0
2013-09-27 08:30:00	QQQ	ETF	78.84	78.9	78.83	78.89	110224.0
2013-09-27 09:00:00	QQQ	ETF	78.89	78.9	78.7	78.74	140803.0
2013-09-27 09:30:00	QQQ	ETF	78.74	78.85	78.59	78.75	4870143.0
2013-09-27 10:00:00	QQQ	ETF	78.75	78.98	78.67	78.96	2287672.0
2013-09-27 10:30:00	QQQ	ETF	78.955	79.11	78.93	79.06	1934484.0
2013-09-27 11:00:00	QQQ	ETF	79.06	79.11	78.95	79.08	899108.0
2013-09-27 11:30:00	QQQ	ETF	79.09	79.19	79.051	79.11	2002774.0
2013-09-27 12:00:00	QQQ	ETF	79.11	79.21	79.08	79.16	563627.0
2013-09-27 12:30:00	QQQ	ETF	79.17	79.2099	79.1201	79.1714	671983.0

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

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