PREVIEW / etf_1min / 2013-04-11

all etf 1-min files

  file:    by_date/etf_1min/2013/2013-04-11.parquet
  size:    2.2 MB
  rows:    114,967

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-04-11 04:04:00	SPY	ETF	158.61	158.61	158.61	158.61	2000.0
2013-04-11 04:05:00	SPY	ETF	158.64	158.64	158.64	158.64	1000.0
2013-04-11 04:06:00	SPY	ETF	158.64	158.65	158.64	158.64	2499.0
2013-04-11 04:07:00	SPY	ETF	158.64	158.64	158.64	158.64	500.0
2013-04-11 04:11:00	SPY	ETF	158.64	158.66	158.64	158.66	1000.0
2013-04-11 04:13:00	SPY	ETF	158.66	158.66	158.66	158.66	600.0
2013-04-11 04:15:00	SPY	ETF	158.69	158.69	158.69	158.69	600.0
2013-04-11 04:17:00	SPY	ETF	158.71	158.72	158.69	158.69	3500.0
2013-04-11 04:19:00	SPY	ETF	158.74	158.76	158.74	158.76	850.0
2013-04-11 04:21:00	SPY	ETF	158.75	158.75	158.75	158.75	200.0
2013-04-11 04:22:00	SPY	ETF	158.75	158.75	158.75	158.75	600.0
2013-04-11 04:23:00	SPY	ETF	158.74	158.74	158.74	158.74	100.0
2013-04-11 04:41:00	SPY	ETF	158.79	158.81	158.79	158.81	400.0
2013-04-11 04:43:00	SPY	ETF	158.82	158.82	158.82	158.82	200.0
2013-04-11 04:44:00	SPY	ETF	158.84	158.85	158.84	158.85	2888.0
2013-04-11 04:45:00	SPY	ETF	158.84	158.84	158.84	158.84	300.0
2013-04-11 04:46:00	SPY	ETF	158.84	158.84	158.84	158.84	1900.0
2013-04-11 04:50:00	SPY	ETF	158.86	158.86	158.86	158.86	21000.0
2013-04-11 04:51:00	SPY	ETF	158.86	158.88	158.86	158.88	43000.0
2013-04-11 04:52:00	SPY	ETF	158.89	158.92	158.89	158.92	6580.0
2013-04-11 04:53:00	SPY	ETF	158.93	158.93	158.93	158.93	100.0
2013-04-11 04:57:00	SPY	ETF	158.92	158.92	158.92	158.92	43555.0
2013-04-11 04:59:00	SPY	ETF	158.92	158.95	158.92	158.95	253300.0
2013-04-11 05:00:00	SPY	ETF	158.95	158.96	158.95	158.96	10825.0
2013-04-11 05:01:00	SPY	ETF	158.97	158.97	158.97	158.97	1000.0
2013-04-11 05:03:00	SPY	ETF	158.99	159.02	158.99	159.01	2000.0
2013-04-11 05:04:00	SPY	ETF	158.98	158.98	158.98	158.98	970.0
2013-04-11 05:05:00	SPY	ETF	158.97	158.97	158.97	158.97	100.0
2013-04-11 05:06:00	SPY	ETF	158.95	158.95	158.95	158.95	300.0
2013-04-11 05:09:00	SPY	ETF	158.95	158.98	158.95	158.98	1300.0
2013-04-11 05:15:00	SPY	ETF	158.95	158.95	158.95	158.95	25060.0
2013-04-11 05:17:00	SPY	ETF	158.95	158.95	158.95	158.95	21000.0
2013-04-11 05:18:00	SPY	ETF	158.95	158.95	158.91	158.91	85360.0
2013-04-11 05:28:00	SPY	ETF	158.99	158.99	158.99	158.99	1000.0
2013-04-11 05:33:00	SPY	ETF	158.91	158.91	158.91	158.91	5700.0
2013-04-11 05:46:00	SPY	ETF	158.9	158.9	158.86	158.9	2900.0
2013-04-11 05:47:00	SPY	ETF	158.9	158.9	158.9	158.9	100.0
2013-04-11 05:49:00	SPY	ETF	158.89	158.89	158.88	158.88	6800.0
2013-04-11 05:50:00	SPY	ETF	158.9	158.9	158.88	158.88	200.0
2013-04-11 05:53:00	SPY	ETF	158.88	158.88	158.88	158.88	1100.0
2013-04-11 06:00:00	SPY	ETF	158.85	158.85	158.85	158.85	100.0
2013-04-11 06:01:00	SPY	ETF	158.82	158.82	158.82	158.82	100.0
2013-04-11 06:05:00	SPY	ETF	158.81	158.81	158.81	158.81	300.0
2013-04-11 06:07:00	SPY	ETF	158.86	158.86	158.86	158.86	300.0
2013-04-11 06:16:00	SPY	ETF	158.81	158.81	158.81	158.81	300.0
2013-04-11 06:27:00	SPY	ETF	158.76	158.76	158.76	158.76	100.0
2013-04-11 06:30:00	SPY	ETF	158.78	158.78	158.78	158.78	300.0
2013-04-11 06:43:00	SPY	ETF	158.76	158.76	158.76	158.76	300.0
2013-04-11 06:44:00	SPY	ETF	158.75	158.75	158.75	158.75	901.0
2013-04-11 06:45:00	SPY	ETF	158.74	158.74	158.74	158.74	102.0

> showing 50 of 114,967 rows — these rows as CSV

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