PREVIEW / etf_1min / 2011-09-27

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-09-27.parquet
  size:    2.3 MB
  rows:    121,747

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-27 04:00:00	SPY	ETF	116.7	117.23	116.7	117.23	2400.0
2011-09-27 04:02:00	SPY	ETF	117.4	117.4	117.4	117.4	800.0
2011-09-27 04:03:00	SPY	ETF	117.44	117.44	117.44	117.44	142.0
2011-09-27 04:09:00	SPY	ETF	117.41	117.49	117.41	117.49	2220.0
2011-09-27 04:12:00	SPY	ETF	117.57	117.57	117.56	117.56	200.0
2011-09-27 04:15:00	SPY	ETF	117.69	117.69	117.69	117.69	100.0
2011-09-27 04:19:00	SPY	ETF	117.64	117.64	117.64	117.64	100.0
2011-09-27 04:25:00	SPY	ETF	117.64	117.64	117.64	117.64	320.0
2011-09-27 04:35:00	SPY	ETF	117.45	117.5	117.45	117.5	300.0
2011-09-27 04:36:00	SPY	ETF	117.51	117.51	117.51	117.51	100.0
2011-09-27 04:39:00	SPY	ETF	117.61	117.61	117.61	117.61	300.0
2011-09-27 04:42:00	SPY	ETF	117.51	117.51	117.51	117.51	100.0
2011-09-27 04:46:00	SPY	ETF	117.54	117.54	117.5	117.5	300.0
2011-09-27 04:47:00	SPY	ETF	117.5	117.5	117.5	117.5	1500.0
2011-09-27 04:48:00	SPY	ETF	117.5	117.5	117.5	117.5	4250.0
2011-09-27 04:50:00	SPY	ETF	117.4	117.41	117.4	117.4	12100.0
2011-09-27 04:51:00	SPY	ETF	117.41	117.41	117.41	117.41	200.0
2011-09-27 04:53:00	SPY	ETF	117.39	117.39	117.35	117.35	200.0
2011-09-27 04:55:00	SPY	ETF	117.33	117.33	117.33	117.33	2000.0
2011-09-27 04:58:00	SPY	ETF	117.47	117.48	117.47	117.48	1400.0
2011-09-27 04:59:00	SPY	ETF	117.5	117.54	117.5	117.54	3100.0
2011-09-27 05:00:00	SPY	ETF	117.62	117.62	117.61	117.61	400.0
2011-09-27 05:05:00	SPY	ETF	117.53	117.53	117.53	117.53	200.0
2011-09-27 05:06:00	SPY	ETF	117.61	117.61	117.61	117.61	200.0
2011-09-27 05:07:00	SPY	ETF	117.65	117.66	117.65	117.66	2060.0
2011-09-27 05:09:00	SPY	ETF	117.61	117.61	117.61	117.61	2000.0
2011-09-27 05:12:00	SPY	ETF	117.62	117.68	117.62	117.68	200.0
2011-09-27 05:18:00	SPY	ETF	117.65	117.65	117.65	117.65	1500.0
2011-09-27 05:19:00	SPY	ETF	117.69	117.7	117.69	117.7	2400.0
2011-09-27 05:20:00	SPY	ETF	117.63	117.63	117.63	117.63	100.0
2011-09-27 05:22:00	SPY	ETF	117.62	117.62	117.62	117.62	200.0
2011-09-27 05:27:00	SPY	ETF	117.69	117.69	117.68	117.68	300.0
2011-09-27 05:28:00	SPY	ETF	117.68	117.68	117.68	117.68	200.0
2011-09-27 05:30:00	SPY	ETF	117.66	117.66	117.66	117.66	300.0
2011-09-27 05:31:00	SPY	ETF	117.71	117.78	117.71	117.78	1495.0
2011-09-27 05:32:00	SPY	ETF	117.79	117.79	117.78	117.78	2200.0
2011-09-27 05:34:00	SPY	ETF	117.85	117.85	117.85	117.85	1000.0
2011-09-27 05:35:00	SPY	ETF	117.9	117.9	117.9	117.9	100.0
2011-09-27 05:37:00	SPY	ETF	117.75	117.75	117.75	117.75	138.0
2011-09-27 05:38:00	SPY	ETF	117.75	117.75	117.75	117.75	4862.0
2011-09-27 05:39:00	SPY	ETF	117.75	117.75	117.75	117.75	5000.0
2011-09-27 05:41:00	SPY	ETF	117.83	117.83	117.83	117.83	200.0
2011-09-27 05:42:00	SPY	ETF	117.84	117.84	117.83	117.83	5200.0
2011-09-27 05:47:00	SPY	ETF	117.63	117.63	117.63	117.63	190.0
2011-09-27 05:48:00	SPY	ETF	117.61	117.61	117.6	117.6	10350.0
2011-09-27 05:50:00	SPY	ETF	117.63	117.63	117.63	117.63	400.0
2011-09-27 05:52:00	SPY	ETF	117.73	117.73	117.73	117.73	201.0
2011-09-27 05:59:00	SPY	ETF	117.9	117.9	117.8	117.8	600.0
2011-09-27 06:03:00	SPY	ETF	117.78	117.78	117.78	117.78	397.0
2011-09-27 06:04:00	SPY	ETF	117.7	117.7	117.7	117.7	200.0

> showing 50 of 121,747 rows — these rows as CSV

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