PREVIEW / etf_1min / 2011-08-05

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-08-05.parquet
  size:    2.9 MB
  rows:    150,276

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-08-05 04:00:00	SPY	ETF	120.26	120.51	120.26	120.51	225.0
2011-08-05 04:02:00	SPY	ETF	120.44	120.51	120.44	120.51	900.0
2011-08-05 04:03:00	SPY	ETF	120.28	120.28	120.28	120.28	2000.0
2011-08-05 04:07:00	SPY	ETF	120.28	120.28	120.28	120.28	100.0
2011-08-05 04:19:00	SPY	ETF	119.85	119.85	119.85	119.85	1000.0
2011-08-05 04:20:00	SPY	ETF	119.85	119.85	119.78	119.78	400.0
2011-08-05 04:23:00	SPY	ETF	119.57	119.57	119.57	119.57	200.0
2011-08-05 04:27:00	SPY	ETF	119.56	119.56	119.53	119.53	1600.0
2011-08-05 04:28:00	SPY	ETF	119.51	119.51	119.51	119.51	100.0
2011-08-05 04:31:00	SPY	ETF	119.55	119.55	119.55	119.55	300.0
2011-08-05 04:33:00	SPY	ETF	119.44	119.5	119.44	119.45	3605.0
2011-08-05 04:34:00	SPY	ETF	119.45	119.45	119.45	119.45	300.0
2011-08-05 04:38:00	SPY	ETF	119.63	119.63	119.63	119.63	500.0
2011-08-05 04:41:00	SPY	ETF	119.7	119.75	119.7	119.75	300.0
2011-08-05 04:43:00	SPY	ETF	119.79	119.79	119.79	119.79	500.0
2011-08-05 04:44:00	SPY	ETF	119.79	119.79	119.79	119.79	100.0
2011-08-05 04:45:00	SPY	ETF	119.77	119.77	119.75	119.75	250.0
2011-08-05 04:47:00	SPY	ETF	119.85	119.92	119.85	119.92	1800.0
2011-08-05 04:48:00	SPY	ETF	119.91	119.91	119.91	119.91	150.0
2011-08-05 04:53:00	SPY	ETF	119.9	119.95	119.9	119.95	500.0
2011-08-05 04:58:00	SPY	ETF	119.95	119.95	119.95	119.95	250.0
2011-08-05 04:59:00	SPY	ETF	119.93	119.93	119.93	119.93	100.0
2011-08-05 05:02:00	SPY	ETF	119.88	119.88	119.88	119.88	150.0
2011-08-05 05:05:00	SPY	ETF	119.95	119.95	119.95	119.95	300.0
2011-08-05 05:08:00	SPY	ETF	119.94	119.94	119.94	119.94	100.0
2011-08-05 05:09:00	SPY	ETF	119.98	119.98	119.98	119.98	100.0
2011-08-05 05:10:00	SPY	ETF	120.05	120.05	120.05	120.05	200.0
2011-08-05 05:16:00	SPY	ETF	119.88	119.88	119.88	119.88	200.0
2011-08-05 05:23:00	SPY	ETF	120.04	120.04	120.04	120.04	200.0
2011-08-05 05:27:00	SPY	ETF	120.14	120.15	120.14	120.15	450.0
2011-08-05 05:37:00	SPY	ETF	119.94	119.94	119.94	119.94	100.0
2011-08-05 05:47:00	SPY	ETF	119.68	119.68	119.68	119.68	100.0
2011-08-05 05:48:00	SPY	ETF	119.66	119.66	119.6	119.6	200.0
2011-08-05 05:50:00	SPY	ETF	119.6	119.6	119.6	119.6	500.0
2011-08-05 05:51:00	SPY	ETF	119.61	119.61	119.61	119.61	200.0
2011-08-05 05:54:00	SPY	ETF	119.61	119.61	119.61	119.61	100.0
2011-08-05 05:56:00	SPY	ETF	119.6	119.6	119.6	119.6	200.0
2011-08-05 05:58:00	SPY	ETF	119.59	119.59	119.59	119.59	100.0
2011-08-05 06:00:00	SPY	ETF	119.55	119.55	119.5	119.5	800.0
2011-08-05 06:02:00	SPY	ETF	119.55	119.62	119.5	119.5	2400.0
2011-08-05 06:03:00	SPY	ETF	119.52	119.52	119.45	119.45	1200.0
2011-08-05 06:04:00	SPY	ETF	119.56	119.56	119.56	119.56	100.0
2011-08-05 06:05:00	SPY	ETF	119.53	119.56	119.53	119.56	300.0
2011-08-05 06:07:00	SPY	ETF	119.53	119.53	119.53	119.53	200.0
2011-08-05 06:10:00	SPY	ETF	119.6	119.64	119.6	119.64	200.0
2011-08-05 06:11:00	SPY	ETF	119.65	119.72	119.65	119.72	10100.0
2011-08-05 06:12:00	SPY	ETF	119.65	119.65	119.65	119.65	1100.0
2011-08-05 06:17:00	SPY	ETF	119.65	119.65	119.65	119.65	1350.0
2011-08-05 06:18:00	SPY	ETF	119.63	119.78	119.63	119.78	3700.0
2011-08-05 06:20:00	SPY	ETF	119.79	119.79	119.79	119.79	450.0

> showing 50 of 150,276 rows — these rows as CSV

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