PREVIEW / etf_1min / 2012-09-19

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-09-19.parquet
  size:    1.9 MB
  rows:    100,624

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-09-19 04:04:00	SPY	ETF	147.02	147.02	147.02	147.02	250.0
2012-09-19 04:07:00	SPY	ETF	147.04	147.06	147.04	147.06	1599.0
2012-09-19 04:31:00	SPY	ETF	146.93	146.93	146.93	146.93	399.0
2012-09-19 04:32:00	SPY	ETF	146.93	146.93	146.93	146.93	500.0
2012-09-19 04:36:00	SPY	ETF	146.91	146.91	146.91	146.91	1000.0
2012-09-19 04:53:00	SPY	ETF	146.77	146.77	146.71	146.71	6100.0
2012-09-19 04:54:00	SPY	ETF	146.72	146.72	146.72	146.72	150.0
2012-09-19 05:19:00	SPY	ETF	146.8	146.8	146.8	146.8	200.0
2012-09-19 05:33:00	SPY	ETF	146.81	146.81	146.81	146.81	145.0
2012-09-19 05:35:00	SPY	ETF	146.85	146.85	146.85	146.85	1000.0
2012-09-19 05:41:00	SPY	ETF	146.8	146.8	146.8	146.8	100.0
2012-09-19 05:44:00	SPY	ETF	146.77	146.77	146.77	146.77	1000.0
2012-09-19 05:49:00	SPY	ETF	146.78	146.78	146.78	146.78	100.0
2012-09-19 05:52:00	SPY	ETF	146.77	146.77	146.77	146.77	1000.0
2012-09-19 05:54:00	SPY	ETF	146.77	146.77	146.77	146.77	1000.0
2012-09-19 05:57:00	SPY	ETF	146.75	146.75	146.75	146.75	100.0
2012-09-19 05:59:00	SPY	ETF	146.75	146.76	146.75	146.76	3000.0
2012-09-19 06:00:00	SPY	ETF	146.69	146.69	146.69	146.69	500.0
2012-09-19 06:06:00	SPY	ETF	146.8	146.8	146.8	146.8	100.0
2012-09-19 06:16:00	SPY	ETF	146.74	146.74	146.74	146.74	100.0
2012-09-19 06:19:00	SPY	ETF	146.77	146.77	146.77	146.77	1000.0
2012-09-19 06:21:00	SPY	ETF	146.77	146.77	146.77	146.77	1000.0
2012-09-19 06:23:00	SPY	ETF	146.77	146.77	146.77	146.77	1000.0
2012-09-19 06:35:00	SPY	ETF	146.77	146.77	146.77	146.77	1000.0
2012-09-19 06:36:00	SPY	ETF	146.74	146.74	146.74	146.74	900.0
2012-09-19 06:37:00	SPY	ETF	146.77	146.8	146.77	146.8	1200.0
2012-09-19 06:39:00	SPY	ETF	146.77	146.77	146.77	146.77	1000.0
2012-09-19 06:43:00	SPY	ETF	146.77	146.77	146.77	146.77	10000.0
2012-09-19 06:45:00	SPY	ETF	146.77	146.77	146.77	146.77	10000.0
2012-09-19 06:49:00	SPY	ETF	146.77	146.82	146.77	146.82	6000.0
2012-09-19 06:50:00	SPY	ETF	146.81	146.82	146.81	146.82	3000.0
2012-09-19 06:53:00	SPY	ETF	146.79	146.79	146.79	146.79	100.0
2012-09-19 06:56:00	SPY	ETF	146.75	146.78	146.75	146.75	4000.0
2012-09-19 06:57:00	SPY	ETF	146.77	146.77	146.77	146.77	1000.0
2012-09-19 06:58:00	SPY	ETF	146.77	146.77	146.75	146.75	2000.0
2012-09-19 06:59:00	SPY	ETF	146.75	146.75	146.75	146.75	100.0
2012-09-19 07:09:00	SPY	ETF	146.75	146.75	146.75	146.75	100.0
2012-09-19 07:11:00	SPY	ETF	146.7	146.7	146.7	146.7	100.0
2012-09-19 07:12:00	SPY	ETF	146.71	146.71	146.68	146.68	1000.0
2012-09-19 07:13:00	SPY	ETF	146.67	146.67	146.65	146.65	1000.0
2012-09-19 07:14:00	SPY	ETF	146.68	146.7	146.68	146.7	233.0
2012-09-19 07:15:00	SPY	ETF	146.69	146.69	146.69	146.69	100.0
2012-09-19 07:16:00	SPY	ETF	146.67	146.7	146.67	146.7	4585.0
2012-09-19 07:18:00	SPY	ETF	146.72	146.72	146.72	146.72	1000.0
2012-09-19 07:20:00	SPY	ETF	146.73	146.73	146.73	146.73	100.0
2012-09-19 07:21:00	SPY	ETF	146.75	146.75	146.74	146.74	20100.0
2012-09-19 07:23:00	SPY	ETF	146.75	146.77	146.75	146.77	800.0
2012-09-19 07:24:00	SPY	ETF	146.78	146.78	146.77	146.77	2700.0
2012-09-19 07:26:00	SPY	ETF	146.76	146.76	146.74	146.74	900.0
2012-09-19 07:28:00	SPY	ETF	146.72	146.75	146.72	146.75	16000.0

> showing 50 of 100,624 rows — these rows as CSV

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