PREVIEW / etf_1min / 2011-09-09

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-09-09.parquet
  size:    2.2 MB
  rows:    111,582

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
2011-09-09 04:00:00	SPY	ETF	119.2	119.2	119.2	119.2	400.0
2011-09-09 04:03:00	SPY	ETF	119.0	119.0	118.88	118.88	300.0
2011-09-09 04:09:00	SPY	ETF	119.01	119.01	119.01	119.01	100.0
2011-09-09 04:11:00	SPY	ETF	118.94	118.94	118.94	118.94	200.0
2011-09-09 04:16:00	SPY	ETF	119.01	119.01	119.01	119.01	1031.0
2011-09-09 04:19:00	SPY	ETF	118.9	118.9	118.9	118.9	261.0
2011-09-09 04:25:00	SPY	ETF	118.74	118.74	118.74	118.74	126.0
2011-09-09 04:39:00	SPY	ETF	118.8	118.8	118.8	118.8	500.0
2011-09-09 04:42:00	SPY	ETF	118.7	118.7	118.7	118.7	250.0
2011-09-09 04:59:00	SPY	ETF	118.73	118.82	118.73	118.82	351.0
2011-09-09 05:06:00	SPY	ETF	118.95	118.95	118.95	118.95	10000.0
2011-09-09 05:07:00	SPY	ETF	119.05	119.07	119.05	119.07	3500.0
2011-09-09 05:08:00	SPY	ETF	119.07	119.07	119.07	119.07	6501.0
2011-09-09 05:09:00	SPY	ETF	119.05	119.05	119.05	119.05	9999.0
2011-09-09 05:10:00	SPY	ETF	118.95	118.95	118.95	118.95	10000.0
2011-09-09 05:12:00	SPY	ETF	118.9	118.9	118.9	118.9	4500.0
2011-09-09 05:13:00	SPY	ETF	118.9	118.9	118.9	118.9	700.0
2011-09-09 05:14:00	SPY	ETF	118.88	118.88	118.88	118.88	100.0
2011-09-09 05:16:00	SPY	ETF	118.95	118.95	118.95	118.95	5000.0
2011-09-09 05:18:00	SPY	ETF	118.91	118.91	118.91	118.91	5000.0
2011-09-09 05:19:00	SPY	ETF	118.71	118.71	118.71	118.71	100.0
2011-09-09 05:20:00	SPY	ETF	118.71	118.71	118.71	118.71	100.0
2011-09-09 05:23:00	SPY	ETF	118.81	118.81	118.81	118.81	4800.0
2011-09-09 05:43:00	SPY	ETF	118.73	118.73	118.73	118.73	1000.0
2011-09-09 05:44:00	SPY	ETF	118.68	118.68	118.68	118.68	100.0
2011-09-09 05:47:00	SPY	ETF	118.59	118.59	118.59	118.59	100.0
2011-09-09 05:54:00	SPY	ETF	118.65	118.65	118.65	118.65	100.0
2011-09-09 06:01:00	SPY	ETF	118.59	118.59	118.59	118.59	500.0
2011-09-09 06:04:00	SPY	ETF	118.54	118.54	118.54	118.54	2950.0
2011-09-09 06:06:00	SPY	ETF	118.6	118.6	118.6	118.6	1000.0
2011-09-09 06:12:00	SPY	ETF	118.7	118.7	118.69	118.69	450.0
2011-09-09 06:21:00	SPY	ETF	118.89	118.89	118.89	118.89	4500.0
2011-09-09 06:26:00	SPY	ETF	118.94	118.97	118.94	118.97	500.0
2011-09-09 06:34:00	SPY	ETF	118.84	118.85	118.84	118.85	600.0
2011-09-09 06:36:00	SPY	ETF	118.84	118.84	118.83	118.83	500.0
2011-09-09 06:38:00	SPY	ETF	118.84	118.84	118.84	118.84	1000.0
2011-09-09 06:42:00	SPY	ETF	118.8	118.8	118.8	118.8	200.0
2011-09-09 06:47:00	SPY	ETF	118.65	118.65	118.65	118.65	100.0
2011-09-09 06:48:00	SPY	ETF	118.6	118.6	118.49	118.51	38867.0
2011-09-09 06:49:00	SPY	ETF	118.49	118.51	118.49	118.51	400.0
2011-09-09 06:50:00	SPY	ETF	118.46	118.6	118.4	118.6	16000.0
2011-09-09 06:51:00	SPY	ETF	118.4	118.4	118.4	118.4	100.0
2011-09-09 06:52:00	SPY	ETF	118.5	118.5	118.45	118.45	16500.0
2011-09-09 06:53:00	SPY	ETF	118.4	118.4	118.4	118.4	37600.0
2011-09-09 06:54:00	SPY	ETF	118.5	118.5	118.5	118.5	100.0
2011-09-09 06:55:00	SPY	ETF	118.5	118.5	118.5	118.5	1000.0
2011-09-09 06:58:00	SPY	ETF	118.5	118.5	118.5	118.5	3800.0
2011-09-09 07:00:00	SPY	ETF	118.51	118.53	118.51	118.53	450.0
2011-09-09 07:01:00	SPY	ETF	118.6	118.6	118.55	118.55	4100.0
2011-09-09 07:02:00	SPY	ETF	118.6	118.6	118.55	118.59	4645.0

> showing 50 of 111,582 rows — these rows as CSV

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