PREVIEW / etf_1min / 2012-06-05

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-06-05.parquet
  size:    2.0 MB
  rows:    106,734

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
2012-06-05 04:00:00	SPY	ETF	128.29	128.29	128.12	128.12	651.0
2012-06-05 04:06:00	SPY	ETF	128.24	128.24	128.24	128.24	300.0
2012-06-05 04:07:00	SPY	ETF	128.19	128.19	128.19	128.19	100.0
2012-06-05 04:11:00	SPY	ETF	128.12	128.12	128.12	128.12	100.0
2012-06-05 04:13:00	SPY	ETF	128.14	128.14	128.14	128.14	100.0
2012-06-05 04:28:00	SPY	ETF	127.96	127.96	127.96	127.96	173.0
2012-06-05 04:31:00	SPY	ETF	127.91	127.91	127.91	127.91	218.0
2012-06-05 04:32:00	SPY	ETF	127.81	127.81	127.81	127.81	149.0
2012-06-05 04:33:00	SPY	ETF	127.71	127.71	127.71	127.71	300.0
2012-06-05 04:36:00	SPY	ETF	127.73	127.73	127.71	127.71	1057.0
2012-06-05 04:39:00	SPY	ETF	127.66	127.66	127.66	127.66	100.0
2012-06-05 04:45:00	SPY	ETF	127.59	127.59	127.59	127.59	200.0
2012-06-05 04:49:00	SPY	ETF	127.54	127.54	127.54	127.54	600.0
2012-06-05 04:54:00	SPY	ETF	127.69	127.69	127.69	127.69	300.0
2012-06-05 05:12:00	SPY	ETF	127.75	127.75	127.75	127.75	163.0
2012-06-05 05:13:00	SPY	ETF	127.76	127.76	127.76	127.76	500.0
2012-06-05 05:20:00	SPY	ETF	127.71	127.71	127.71	127.71	10000.0
2012-06-05 05:23:00	SPY	ETF	127.78	127.82	127.78	127.82	300.0
2012-06-05 05:24:00	SPY	ETF	127.83	127.84	127.83	127.83	5167.0
2012-06-05 05:25:00	SPY	ETF	127.82	127.82	127.8	127.8	1100.0
2012-06-05 05:38:00	SPY	ETF	127.69	127.69	127.69	127.69	200.0
2012-06-05 05:40:00	SPY	ETF	127.68	127.68	127.68	127.68	200.0
2012-06-05 05:44:00	SPY	ETF	127.69	127.69	127.69	127.69	200.0
2012-06-05 05:46:00	SPY	ETF	127.71	127.71	127.71	127.71	200.0
2012-06-05 05:47:00	SPY	ETF	127.69	127.69	127.69	127.69	5000.0
2012-06-05 05:48:00	SPY	ETF	127.59	127.59	127.59	127.59	500.0
2012-06-05 05:49:00	SPY	ETF	127.53	127.53	127.53	127.53	102.0
2012-06-05 05:50:00	SPY	ETF	127.55	127.55	127.55	127.55	202.0
2012-06-05 05:51:00	SPY	ETF	127.55	127.55	127.55	127.55	1298.0
2012-06-05 05:54:00	SPY	ETF	127.64	127.64	127.64	127.64	1000.0
2012-06-05 05:56:00	SPY	ETF	127.68	127.7	127.68	127.68	1400.0
2012-06-05 05:57:00	SPY	ETF	127.68	127.68	127.68	127.68	1000.0
2012-06-05 05:58:00	SPY	ETF	127.64	127.64	127.64	127.64	2000.0
2012-06-05 06:02:00	SPY	ETF	127.69	127.69	127.69	127.69	1000.0
2012-06-05 06:07:00	SPY	ETF	127.67	127.67	127.67	127.67	200.0
2012-06-05 06:09:00	SPY	ETF	127.64	127.64	127.64	127.64	200.0
2012-06-05 06:16:00	SPY	ETF	127.71	127.71	127.71	127.71	800.0
2012-06-05 06:17:00	SPY	ETF	127.69	127.69	127.69	127.69	500.0
2012-06-05 06:19:00	SPY	ETF	127.67	127.67	127.66	127.66	500.0
2012-06-05 06:21:00	SPY	ETF	127.7	127.7	127.7	127.7	1500.0
2012-06-05 06:22:00	SPY	ETF	127.7	127.7	127.7	127.7	200.0
2012-06-05 06:36:00	SPY	ETF	127.69	127.69	127.69	127.69	6000.0
2012-06-05 06:41:00	SPY	ETF	127.66	127.66	127.66	127.66	12000.0
2012-06-05 06:47:00	SPY	ETF	127.66	127.66	127.65	127.65	2700.0
2012-06-05 06:51:00	SPY	ETF	127.68	127.68	127.68	127.68	1940.0
2012-06-05 06:57:00	SPY	ETF	127.58	127.58	127.58	127.58	150.0
2012-06-05 06:59:00	SPY	ETF	127.62	127.62	127.62	127.62	200.0
2012-06-05 07:00:00	SPY	ETF	127.6	127.6	127.6	127.6	400.0
2012-06-05 07:02:00	SPY	ETF	127.59	127.59	127.58	127.58	2550.0
2012-06-05 07:03:00	SPY	ETF	127.58	127.59	127.57	127.57	1900.0

> showing 50 of 106,734 rows — these rows as CSV

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