PREVIEW / etf_1min / 2012-05-29

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-05-29.parquet
  size:    1.9 MB
  rows:    102,274

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-05-29 04:00:00	SPY	ETF	133.28	133.31	133.28	133.31	200.0
2012-05-29 04:02:00	SPY	ETF	133.31	133.31	133.31	133.31	400.0
2012-05-29 04:03:00	SPY	ETF	133.35	133.35	133.35	133.35	100.0
2012-05-29 04:04:00	SPY	ETF	133.12	133.12	133.12	133.12	300.0
2012-05-29 04:19:00	SPY	ETF	133.23	133.23	133.23	133.23	159.0
2012-05-29 04:28:00	SPY	ETF	133.12	133.14	133.12	133.14	2931.0
2012-05-29 04:34:00	SPY	ETF	132.99	132.99	132.99	132.99	241.0
2012-05-29 04:36:00	SPY	ETF	132.98	132.99	132.98	132.99	600.0
2012-05-29 04:48:00	SPY	ETF	132.99	132.99	132.99	132.99	100.0
2012-05-29 04:51:00	SPY	ETF	132.97	132.97	132.97	132.97	446.0
2012-05-29 04:52:00	SPY	ETF	133.1	133.1	133.1	133.1	2500.0
2012-05-29 04:58:00	SPY	ETF	132.95	132.95	132.95	132.95	100.0
2012-05-29 05:04:00	SPY	ETF	133.08	133.08	133.08	133.08	100.0
2012-05-29 05:07:00	SPY	ETF	132.99	133.0	132.99	133.0	1200.0
2012-05-29 05:09:00	SPY	ETF	132.98	132.98	132.98	132.98	158.0
2012-05-29 05:17:00	SPY	ETF	133.09	133.09	133.09	133.09	150.0
2012-05-29 05:22:00	SPY	ETF	133.08	133.08	133.06	133.07	1700.0
2012-05-29 05:24:00	SPY	ETF	133.09	133.09	133.09	133.09	500.0
2012-05-29 05:33:00	SPY	ETF	132.95	132.95	132.95	132.95	250.0
2012-05-29 05:35:00	SPY	ETF	132.89	132.89	132.89	132.89	5000.0
2012-05-29 05:44:00	SPY	ETF	132.86	132.86	132.86	132.86	1000.0
2012-05-29 05:45:00	SPY	ETF	132.86	132.86	132.86	132.86	200.0
2012-05-29 05:47:00	SPY	ETF	132.75	132.75	132.75	132.75	1000.0
2012-05-29 05:55:00	SPY	ETF	132.69	132.69	132.69	132.69	1000.0
2012-05-29 06:18:00	SPY	ETF	132.79	132.79	132.79	132.79	1000.0
2012-05-29 06:24:00	SPY	ETF	132.86	132.87	132.86	132.87	1100.0
2012-05-29 06:29:00	SPY	ETF	132.87	132.87	132.87	132.87	400.0
2012-05-29 06:30:00	SPY	ETF	132.87	132.9	132.87	132.9	200.0
2012-05-29 06:31:00	SPY	ETF	132.88	132.88	132.88	132.88	200.0
2012-05-29 06:33:00	SPY	ETF	132.89	132.89	132.89	132.89	100.0
2012-05-29 06:36:00	SPY	ETF	132.82	132.82	132.77	132.77	400.0
2012-05-29 06:37:00	SPY	ETF	132.72	132.72	132.71	132.71	25000.0
2012-05-29 06:38:00	SPY	ETF	132.73	132.73	132.73	132.73	200.0
2012-05-29 06:40:00	SPY	ETF	132.77	132.77	132.77	132.77	2000.0
2012-05-29 06:44:00	SPY	ETF	132.79	132.79	132.79	132.79	10000.0
2012-05-29 06:45:00	SPY	ETF	132.74	132.74	132.74	132.74	5100.0
2012-05-29 06:47:00	SPY	ETF	132.79	132.79	132.79	132.79	1000.0
2012-05-29 06:49:00	SPY	ETF	132.78	132.8	132.78	132.8	5700.0
2012-05-29 06:51:00	SPY	ETF	132.86	132.86	132.86	132.86	1947.0
2012-05-29 06:52:00	SPY	ETF	132.88	132.88	132.86	132.86	1100.0
2012-05-29 06:53:00	SPY	ETF	132.88	132.88	132.88	132.88	400.0
2012-05-29 06:54:00	SPY	ETF	132.89	132.89	132.89	132.89	200.0
2012-05-29 06:55:00	SPY	ETF	132.9	132.9	132.9	132.9	2000.0
2012-05-29 06:59:00	SPY	ETF	132.89	132.98	132.89	132.98	1100.0
2012-05-29 07:00:00	SPY	ETF	132.98	132.99	132.96	132.96	27727.0
2012-05-29 07:01:00	SPY	ETF	132.97	132.98	132.97	132.97	7121.0
2012-05-29 07:02:00	SPY	ETF	132.95	132.95	132.95	132.95	100.0
2012-05-29 07:03:00	SPY	ETF	132.95	132.95	132.94	132.94	2900.0
2012-05-29 07:04:00	SPY	ETF	132.92	132.94	132.91	132.91	33500.0
2012-05-29 07:06:00	SPY	ETF	132.9	132.9	132.87	132.87	3500.0

> showing 50 of 102,274 rows — these rows as CSV

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