PREVIEW / etf_30min / 2014-02-27

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-27.parquet
  size:    339 KB
  rows:    11,365

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-02-27 04:00:00	SPY	ETF	185.1	185.1	184.5	184.68	6070.0
2014-02-27 04:30:00	SPY	ETF	184.62	184.7	184.21	184.21	37304.0
2014-02-27 05:00:00	SPY	ETF	184.17	184.38	184.1	184.24	19572.0
2014-02-27 05:30:00	SPY	ETF	184.19	184.19	183.84	183.93	27253.0
2014-02-27 06:00:00	SPY	ETF	183.93	184.11	183.87	183.94	25359.0
2014-02-27 06:30:00	SPY	ETF	184.0	184.2	183.91	184.15	42030.0
2014-02-27 07:00:00	SPY	ETF	184.12	184.35	184.11	184.26	129274.0
2014-02-27 07:30:00	SPY	ETF	184.26	184.4	184.06	184.39	250422.0
2014-02-27 08:00:00	SPY	ETF	184.29	184.43	183.99	184.27	338303.0
2014-02-27 08:30:00	SPY	ETF	184.26	184.76	184.26	184.58	750263.0
2014-02-27 09:00:00	SPY	ETF	184.59	184.76	184.47	184.59	745789.0
2014-02-27 09:30:00	SPY	ETF	184.59	185.05	184.37	184.6899	9862543.0
2014-02-27 10:00:00	SPY	ETF	184.69	184.94	184.42	184.73	8070453.0
2014-02-27 10:30:00	SPY	ETF	184.72	185.09	184.69	184.97	6623590.0
2014-02-27 11:00:00	SPY	ETF	184.97	185.45	184.87	185.41	8093980.0
2014-02-27 11:30:00	SPY	ETF	185.42	185.43	185.11	185.23	4598941.0
2014-02-27 12:00:00	SPY	ETF	185.23	185.36	185.01	185.25	3799126.0
2014-02-27 12:30:00	SPY	ETF	185.26	185.295	185.08	185.26	2631902.0
2014-02-27 13:00:00	SPY	ETF	185.25	185.57	185.21	185.55	4865094.0
2014-02-27 13:30:00	SPY	ETF	185.5559	185.81	185.51	185.65	4810870.0
2014-02-27 14:00:00	SPY	ETF	185.655	185.75	185.34	185.355	4143495.0
2014-02-27 14:30:00	SPY	ETF	185.35	185.54	185.28	185.48	4633676.0
2014-02-27 15:00:00	SPY	ETF	185.48	185.705	185.34	185.6599	6126100.0
2014-02-27 15:30:00	SPY	ETF	185.66	185.84	185.32	185.84	12783225.0
2014-02-27 16:00:00	SPY	ETF	185.84	185.92	184.72	185.92	8042281.0
2014-02-27 16:30:00	SPY	ETF	185.93	186.04	184.8404	186.04	1075339.0
2014-02-27 17:00:00	SPY	ETF	186.03	186.07	185.98	185.98	142316.0
2014-02-27 17:30:00	SPY	ETF	186.0	186.02	185.96	185.96	34449.0
2014-02-27 18:00:00	SPY	ETF	185.95	185.95	184.9	185.87	63919.0
2014-02-27 18:30:00	SPY	ETF	185.86	185.88	185.82	185.85	36152.0
2014-02-27 19:00:00	SPY	ETF	185.82	185.92	185.82	185.92	6618.0
2014-02-27 19:30:00	SPY	ETF	185.91	185.92	185.8	185.84	53139.0
2014-02-27 04:00:00	QQQ	ETF	90.25	90.4	89.94	89.94	219676.0
2014-02-27 04:30:00	QQQ	ETF	89.75	89.75	89.67	89.67	5900.0
2014-02-27 05:30:00	QQQ	ETF	89.64	89.65	89.5	89.58	259147.0
2014-02-27 06:00:00	QQQ	ETF	89.58	89.65	89.53	89.56	127390.0
2014-02-27 06:30:00	QQQ	ETF	89.56	89.76	89.56	89.74	4700.0
2014-02-27 07:00:00	QQQ	ETF	89.73	89.76	89.63	89.76	10500.0
2014-02-27 07:30:00	QQQ	ETF	89.68	89.76	89.62	89.76	4298.0
2014-02-27 08:00:00	QQQ	ETF	89.66	89.77	89.66	89.74	70888.0
2014-02-27 08:30:00	QQQ	ETF	89.78	89.93	89.75	89.85	89316.0
2014-02-27 09:00:00	QQQ	ETF	89.87	89.93	89.81	89.87	270595.0
2014-02-27 09:30:00	QQQ	ETF	89.87	90.05	89.73	89.88	3292338.0
2014-02-27 10:00:00	QQQ	ETF	89.89	90.01	89.74	89.93	3244260.0
2014-02-27 10:30:00	QQQ	ETF	89.93	90.15	89.91	90.07	1770966.0
2014-02-27 11:00:00	QQQ	ETF	90.06	90.25	90.03	90.18	2075276.0
2014-02-27 11:30:00	QQQ	ETF	90.18	90.18	90.03	90.0834	1082827.0
2014-02-27 12:00:00	QQQ	ETF	90.0844	90.19	90.0	90.17	633118.0
2014-02-27 12:30:00	QQQ	ETF	90.17	90.25	90.11	90.21	700633.0
2014-02-27 13:00:00	QQQ	ETF	90.21	90.4	90.16	90.39	707588.0

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

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