PREVIEW / etf_1min / 2011-06-14

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-06-14.parquet
  size:    1.9 MB
  rows:    102,397

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-06-14 04:00:00	SPY	ETF	128.35	128.35	128.35	128.35	300.0
2011-06-14 04:03:00	SPY	ETF	128.63	128.7	128.63	128.7	600.0
2011-06-14 04:06:00	SPY	ETF	128.81	128.81	128.81	128.81	190.0
2011-06-14 04:13:00	SPY	ETF	128.74	128.8	128.74	128.8	200.0
2011-06-14 04:14:00	SPY	ETF	128.83	128.83	128.82	128.82	300.0
2011-06-14 04:16:00	SPY	ETF	128.88	128.88	128.88	128.88	500.0
2011-06-14 04:17:00	SPY	ETF	128.84	128.84	128.84	128.84	200.0
2011-06-14 04:27:00	SPY	ETF	128.8	128.8	128.8	128.8	100.0
2011-06-14 04:28:00	SPY	ETF	128.8	128.8	128.8	128.8	100.0
2011-06-14 04:29:00	SPY	ETF	128.8	128.8	128.8	128.8	200.0
2011-06-14 04:34:00	SPY	ETF	128.8	128.8	128.8	128.8	200.0
2011-06-14 04:38:00	SPY	ETF	128.77	128.77	128.7	128.7	1750.0
2011-06-14 04:40:00	SPY	ETF	128.74	128.75	128.72	128.75	300.0
2011-06-14 04:41:00	SPY	ETF	128.72	128.72	128.72	128.72	315.0
2011-06-14 04:48:00	SPY	ETF	128.74	128.74	128.74	128.74	400.0
2011-06-14 04:54:00	SPY	ETF	128.78	128.78	128.78	128.78	700.0
2011-06-14 04:58:00	SPY	ETF	128.84	128.84	128.84	128.84	100.0
2011-06-14 05:00:00	SPY	ETF	128.8	128.8	128.8	128.8	500.0
2011-06-14 05:01:00	SPY	ETF	128.82	128.87	128.82	128.87	1547.0
2011-06-14 05:02:00	SPY	ETF	128.91	128.91	128.86	128.86	297.0
2011-06-14 05:06:00	SPY	ETF	128.92	128.92	128.89	128.89	200.0
2011-06-14 05:09:00	SPY	ETF	128.89	128.89	128.89	128.89	200.0
2011-06-14 05:12:00	SPY	ETF	128.85	128.85	128.85	128.85	500.0
2011-06-14 05:16:00	SPY	ETF	128.88	128.9	128.88	128.9	200.0
2011-06-14 05:19:00	SPY	ETF	128.83	128.83	128.83	128.83	100.0
2011-06-14 05:21:00	SPY	ETF	128.71	128.71	128.71	128.71	100.0
2011-06-14 05:22:00	SPY	ETF	128.71	128.71	128.71	128.71	800.0
2011-06-14 05:30:00	SPY	ETF	128.71	128.71	128.71	128.71	1915.0
2011-06-14 05:32:00	SPY	ETF	128.71	128.71	128.71	128.71	585.0
2011-06-14 05:37:00	SPY	ETF	128.7	128.7	128.7	128.7	500.0
2011-06-14 05:46:00	SPY	ETF	128.68	128.68	128.68	128.68	500.0
2011-06-14 05:48:00	SPY	ETF	128.68	128.68	128.68	128.68	100.0
2011-06-14 05:51:00	SPY	ETF	128.74	128.74	128.74	128.74	200.0
2011-06-14 05:52:00	SPY	ETF	128.69	128.69	128.64	128.64	500.0
2011-06-14 06:04:00	SPY	ETF	128.66	128.66	128.66	128.66	800.0
2011-06-14 06:14:00	SPY	ETF	128.65	128.65	128.65	128.65	300.0
2011-06-14 06:15:00	SPY	ETF	128.71	128.71	128.71	128.71	500.0
2011-06-14 06:21:00	SPY	ETF	128.66	128.66	128.66	128.66	300.0
2011-06-14 06:26:00	SPY	ETF	128.65	128.65	128.65	128.65	2000.0
2011-06-14 06:28:00	SPY	ETF	128.65	128.7	128.65	128.7	300.0
2011-06-14 06:35:00	SPY	ETF	128.68	128.68	128.65	128.65	983.0
2011-06-14 06:36:00	SPY	ETF	128.65	128.65	128.65	128.65	6617.0
2011-06-14 06:39:00	SPY	ETF	128.68	128.68	128.68	128.68	500.0
2011-06-14 06:40:00	SPY	ETF	128.66	128.66	128.66	128.66	500.0
2011-06-14 06:42:00	SPY	ETF	128.69	128.69	128.65	128.65	1700.0
2011-06-14 06:43:00	SPY	ETF	128.68	128.68	128.68	128.68	100.0
2011-06-14 06:44:00	SPY	ETF	128.69	128.69	128.69	128.69	300.0
2011-06-14 06:46:00	SPY	ETF	128.65	128.65	128.61	128.61	1400.0
2011-06-14 06:47:00	SPY	ETF	128.61	128.61	128.61	128.61	100.0
2011-06-14 06:49:00	SPY	ETF	128.56	128.56	128.46	128.47	10400.0

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

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