PREVIEW / etf_30min / 2012-11-02

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-02.parquet
  size:    287 KB
  rows:    9,545

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
2012-11-02 04:00:00	SPY	ETF	142.82	142.82	142.82	142.82	2500.0
2012-11-02 04:30:00	SPY	ETF	142.86	142.86	142.69	142.69	25940.0
2012-11-02 05:00:00	SPY	ETF	142.74	142.76	142.68	142.76	1100.0
2012-11-02 05:30:00	SPY	ETF	142.76	142.76	142.76	142.76	100.0
2012-11-02 06:00:00	SPY	ETF	142.93	142.98	142.93	142.98	700.0
2012-11-02 06:30:00	SPY	ETF	142.96	142.96	142.96	142.96	500.0
2012-11-02 07:00:00	SPY	ETF	142.98	143.01	142.92	143.01	37680.0
2012-11-02 07:30:00	SPY	ETF	142.97	143.01	142.94	142.94	60300.0
2012-11-02 08:00:00	SPY	ETF	142.94	143.13	142.81	142.95	612888.0
2012-11-02 08:30:00	SPY	ETF	142.94	143.76	142.8	143.63	4519204.0
2012-11-02 09:00:00	SPY	ETF	143.62	143.74	143.48	143.68	834607.0
2012-11-02 09:30:00	SPY	ETF	143.68	143.72	143.0	143.21	12699650.0
2012-11-02 10:00:00	SPY	ETF	143.2	143.25	142.58	142.73	11425703.0
2012-11-02 10:30:00	SPY	ETF	142.73	142.94	142.53	142.63	7990716.0
2012-11-02 11:00:00	SPY	ETF	142.625	142.76	142.47	142.71	6241187.0
2012-11-02 11:30:00	SPY	ETF	142.71	142.84	142.53	142.72	6501726.0
2012-11-02 12:00:00	SPY	ETF	142.72	142.8	142.58	142.74	5481421.0
2012-11-02 12:30:00	SPY	ETF	142.74	142.86	142.64	142.68	2998353.0
2012-11-02 13:00:00	SPY	ETF	142.68	142.75	142.54	142.576	3430845.0
2012-11-02 13:30:00	SPY	ETF	142.58	142.69	142.33	142.3532	6773906.0
2012-11-02 14:00:00	SPY	ETF	142.35	142.36	142.12	142.27	8135894.0
2012-11-02 14:30:00	SPY	ETF	142.27	142.27	141.74	141.97	9345395.0
2012-11-02 15:00:00	SPY	ETF	141.97	142.06	141.82	141.89	10752926.0
2012-11-02 15:30:00	SPY	ETF	141.88	141.885	141.41	141.54	21930604.0
2012-11-02 16:00:00	SPY	ETF	141.54	142.5553	141.14	141.14	14932759.0
2012-11-02 16:30:00	SPY	ETF	141.14	141.35	141.11	141.34	2120704.0
2012-11-02 17:00:00	SPY	ETF	141.33	141.38	141.32	141.37	282064.0
2012-11-02 17:30:00	SPY	ETF	141.38	141.38	141.32	141.32	33922.0
2012-11-02 18:00:00	SPY	ETF	141.33	141.35	141.32	141.35	14724.0
2012-11-02 18:30:00	SPY	ETF	141.33	141.37	141.32	141.37	4275.0
2012-11-02 19:00:00	SPY	ETF	141.34	141.35	141.32	141.32	12365.0
2012-11-02 19:30:00	SPY	ETF	141.31	141.33	141.29	141.3	18842.0
2012-11-02 06:00:00	QQQ	ETF	66.0	66.0	66.0	66.0	100.0
2012-11-02 07:00:00	QQQ	ETF	66.01	66.03	66.01	66.03	5400.0
2012-11-02 07:30:00	QQQ	ETF	66.03	66.04	65.99	66.0	131712.0
2012-11-02 08:00:00	QQQ	ETF	66.01	66.06	65.92	65.98	784216.0
2012-11-02 08:30:00	QQQ	ETF	66.04	66.23	66.04	66.19	1982576.0
2012-11-02 09:00:00	QQQ	ETF	66.19	66.23	66.1	66.2	274098.0
2012-11-02 09:30:00	QQQ	ETF	66.21	66.21	65.85	66.03	4604547.0
2012-11-02 10:00:00	QQQ	ETF	66.03	66.04	65.8	65.84	2899048.0
2012-11-02 10:30:00	QQQ	ETF	65.84	65.97	65.8	65.88	1918179.0
2012-11-02 11:00:00	QQQ	ETF	65.88	65.92	65.8001	65.89	1432664.0
2012-11-02 11:30:00	QQQ	ETF	65.88	65.91	65.7417	65.84	1357747.0
2012-11-02 12:00:00	QQQ	ETF	65.83	65.89	65.7801	65.86	1480621.0
2012-11-02 12:30:00	QQQ	ETF	65.8501	65.93	65.83	65.84	450961.0
2012-11-02 13:00:00	QQQ	ETF	65.85	65.88	65.71	65.73	1086079.0
2012-11-02 13:30:00	QQQ	ETF	65.73	65.8	65.65	65.67	1515145.0
2012-11-02 14:00:00	QQQ	ETF	65.67	65.67	65.55	65.58	2224955.0
2012-11-02 14:30:00	QQQ	ETF	65.58	65.59	65.311	65.45	2578449.0
2012-11-02 15:00:00	QQQ	ETF	65.45	65.52	65.35	65.3501	1911249.0

> showing 50 of 9,545 rows — these rows as CSV

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