PREVIEW / etf_1min / 2011-03-16

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-03-16.parquet
  size:    2.5 MB
  rows:    125,578

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-03-16 04:00:00	SPY	ETF	128.7	128.7	128.68	128.68	200.0
2011-03-16 04:01:00	SPY	ETF	128.73	128.73	128.73	128.73	200.0
2011-03-16 04:04:00	SPY	ETF	128.75	128.75	128.72	128.72	1100.0
2011-03-16 04:07:00	SPY	ETF	128.86	128.87	128.86	128.87	300.0
2011-03-16 04:20:00	SPY	ETF	128.77	128.77	128.77	128.77	100.0
2011-03-16 04:22:00	SPY	ETF	128.83	128.83	128.83	128.83	100.0
2011-03-16 04:24:00	SPY	ETF	128.74	128.74	128.74	128.74	700.0
2011-03-16 04:34:00	SPY	ETF	128.55	128.55	128.55	128.55	100.0
2011-03-16 04:37:00	SPY	ETF	128.6	128.6	128.6	128.6	100.0
2011-03-16 04:38:00	SPY	ETF	128.68	128.68	128.68	128.68	200.0
2011-03-16 04:41:00	SPY	ETF	128.67	128.67	128.67	128.67	350.0
2011-03-16 04:50:00	SPY	ETF	128.82	128.82	128.82	128.82	100.0
2011-03-16 04:57:00	SPY	ETF	128.79	128.82	128.79	128.82	400.0
2011-03-16 04:59:00	SPY	ETF	128.8	128.8	128.8	128.8	500.0
2011-03-16 05:04:00	SPY	ETF	128.72	128.72	128.72	128.72	100.0
2011-03-16 05:09:00	SPY	ETF	128.74	128.74	128.74	128.74	1000.0
2011-03-16 05:31:00	SPY	ETF	128.57	128.57	128.57	128.57	200.0
2011-03-16 05:39:00	SPY	ETF	128.31	128.31	128.31	128.31	200.0
2011-03-16 05:40:00	SPY	ETF	128.32	128.32	128.27	128.27	400.0
2011-03-16 05:41:00	SPY	ETF	128.26	128.26	128.26	128.26	600.0
2011-03-16 05:42:00	SPY	ETF	128.26	128.26	128.23	128.23	200.0
2011-03-16 05:46:00	SPY	ETF	128.18	128.18	128.18	128.18	150.0
2011-03-16 05:48:00	SPY	ETF	128.25	128.25	128.25	128.25	500.0
2011-03-16 05:50:00	SPY	ETF	128.38	128.38	128.36	128.36	5000.0
2011-03-16 05:52:00	SPY	ETF	128.33	128.33	128.31	128.31	5000.0
2011-03-16 05:59:00	SPY	ETF	128.36	128.36	128.36	128.36	500.0
2011-03-16 06:00:00	SPY	ETF	128.39	128.39	128.39	128.39	775.0
2011-03-16 06:02:00	SPY	ETF	128.22	128.22	128.22	128.22	100.0
2011-03-16 06:07:00	SPY	ETF	128.12	128.12	128.11	128.11	5000.0
2011-03-16 06:12:00	SPY	ETF	128.07	128.07	128.07	128.07	700.0
2011-03-16 06:14:00	SPY	ETF	128.0	128.05	128.0	128.05	400.0
2011-03-16 06:15:00	SPY	ETF	128.07	128.07	128.07	128.07	400.0
2011-03-16 06:16:00	SPY	ETF	128.09	128.09	128.09	128.09	5000.0
2011-03-16 06:17:00	SPY	ETF	128.04	128.04	128.01	128.01	2400.0
2011-03-16 06:20:00	SPY	ETF	128.0	128.0	128.0	128.0	2500.0
2011-03-16 06:21:00	SPY	ETF	127.95	127.95	127.9	127.9	5000.0
2011-03-16 06:25:00	SPY	ETF	128.08	128.11	128.08	128.11	4490.0
2011-03-16 06:27:00	SPY	ETF	128.18	128.18	128.16	128.16	2800.0
2011-03-16 06:30:00	SPY	ETF	128.1	128.1	128.1	128.1	100.0
2011-03-16 06:36:00	SPY	ETF	128.16	128.16	128.16	128.16	10000.0
2011-03-16 06:37:00	SPY	ETF	128.16	128.18	128.14	128.14	20500.0
2011-03-16 06:39:00	SPY	ETF	128.09	128.09	128.09	128.09	29500.0
2011-03-16 06:40:00	SPY	ETF	128.11	128.16	128.09	128.15	44200.0
2011-03-16 06:41:00	SPY	ETF	128.1	128.1	128.05	128.06	31690.0
2011-03-16 06:42:00	SPY	ETF	128.06	128.06	127.96	127.98	48310.0
2011-03-16 06:43:00	SPY	ETF	127.93	127.93	127.9	127.9	21725.0
2011-03-16 06:44:00	SPY	ETF	127.9	127.91	127.9	127.9	8375.0
2011-03-16 06:45:00	SPY	ETF	127.91	127.91	127.91	127.91	200.0
2011-03-16 06:46:00	SPY	ETF	127.87	127.88	127.86	127.88	9925.0
2011-03-16 06:47:00	SPY	ETF	127.85	127.85	127.81	127.81	14225.0

> showing 50 of 125,578 rows — these rows as CSV

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