PREVIEW / etf_1min / 2013-02-27

all etf 1-min files

  file:    by_date/etf_1min/2013/2013-02-27.parquet
  size:    2.2 MB
  rows:    109,069

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-27 04:00:00	SPY	ETF	149.68	149.68	149.68	149.68	302.0
2013-02-27 04:23:00	SPY	ETF	149.57	149.57	149.57	149.57	600.0
2013-02-27 04:24:00	SPY	ETF	149.61	149.61	149.59	149.59	700.0
2013-02-27 04:25:00	SPY	ETF	149.59	149.59	149.59	149.59	400.0
2013-02-27 04:26:00	SPY	ETF	149.59	149.59	149.59	149.59	200.0
2013-02-27 04:28:00	SPY	ETF	149.6	149.6	149.6	149.6	200.0
2013-02-27 04:30:00	SPY	ETF	149.59	149.59	149.58	149.58	400.0
2013-02-27 04:32:00	SPY	ETF	149.57	149.59	149.57	149.59	500.0
2013-02-27 04:34:00	SPY	ETF	149.61	149.62	149.61	149.62	200.0
2013-02-27 04:36:00	SPY	ETF	149.64	149.64	149.64	149.64	400.0
2013-02-27 04:40:00	SPY	ETF	149.52	149.54	149.52	149.54	4000.0
2013-02-27 04:41:00	SPY	ETF	149.52	149.52	149.5	149.5	300.0
2013-02-27 04:42:00	SPY	ETF	149.49	149.49	149.49	149.49	300.0
2013-02-27 04:43:00	SPY	ETF	149.49	149.49	149.49	149.49	100.0
2013-02-27 04:44:00	SPY	ETF	149.51	149.52	149.49	149.49	400.0
2013-02-27 04:48:00	SPY	ETF	149.49	149.49	149.49	149.49	100.0
2013-02-27 04:50:00	SPY	ETF	149.47	149.47	149.47	149.47	600.0
2013-02-27 04:52:00	SPY	ETF	149.47	149.52	149.47	149.52	1100.0
2013-02-27 04:53:00	SPY	ETF	149.52	149.52	149.51	149.51	900.0
2013-02-27 04:54:00	SPY	ETF	149.54	149.7	149.51	149.7	16500.0
2013-02-27 04:55:00	SPY	ETF	149.61	149.61	149.59	149.59	1000.0
2013-02-27 04:56:00	SPY	ETF	149.59	149.59	149.59	149.59	600.0
2013-02-27 04:57:00	SPY	ETF	149.59	149.59	149.59	149.59	600.0
2013-02-27 04:59:00	SPY	ETF	149.62	149.64	149.62	149.64	700.0
2013-02-27 05:00:00	SPY	ETF	149.64	149.64	149.64	149.64	400.0
2013-02-27 05:02:00	SPY	ETF	149.65	149.71	149.65	149.7	400.0
2013-02-27 05:14:00	SPY	ETF	149.74	149.74	149.73	149.73	3800.0
2013-02-27 05:18:00	SPY	ETF	149.73	149.77	149.73	149.73	3180.0
2013-02-27 05:22:00	SPY	ETF	149.73	149.76	149.72	149.76	2400.0
2013-02-27 05:25:00	SPY	ETF	149.66	149.67	149.64	149.64	11400.0
2013-02-27 05:26:00	SPY	ETF	149.61	149.61	149.61	149.61	500.0
2013-02-27 05:27:00	SPY	ETF	149.61	149.62	149.61	149.62	2500.0
2013-02-27 05:28:00	SPY	ETF	149.64	149.69	149.64	149.64	2100.0
2013-02-27 05:30:00	SPY	ETF	149.67	149.7	149.67	149.7	400.0
2013-02-27 05:31:00	SPY	ETF	149.69	149.69	149.69	149.69	400.0
2013-02-27 05:32:00	SPY	ETF	149.69	149.74	149.69	149.74	500.0
2013-02-27 05:33:00	SPY	ETF	149.72	149.72	149.72	149.72	300.0
2013-02-27 05:34:00	SPY	ETF	149.72	149.72	149.72	149.72	600.0
2013-02-27 05:35:00	SPY	ETF	149.72	149.79	149.72	149.79	400.0
2013-02-27 05:36:00	SPY	ETF	149.76	149.76	149.76	149.76	5000.0
2013-02-27 05:40:00	SPY	ETF	149.75	149.75	149.72	149.72	2200.0
2013-02-27 05:44:00	SPY	ETF	149.76	149.76	149.76	149.76	500.0
2013-02-27 05:57:00	SPY	ETF	149.67	149.67	149.62	149.63	1900.0
2013-02-27 06:01:00	SPY	ETF	149.68	149.68	149.68	149.68	2000.0
2013-02-27 06:02:00	SPY	ETF	149.66	149.66	149.66	149.66	1500.0
2013-02-27 06:07:00	SPY	ETF	149.66	149.69	149.66	149.69	10000.0
2013-02-27 06:09:00	SPY	ETF	149.71	149.71	149.71	149.71	500.0
2013-02-27 06:12:00	SPY	ETF	149.78	149.78	149.78	149.78	5000.0
2013-02-27 06:17:00	SPY	ETF	149.73	149.73	149.73	149.73	200.0
2013-02-27 06:18:00	SPY	ETF	149.75	149.77	149.75	149.76	450.0

> showing 50 of 109,069 rows — these rows as CSV

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