PREVIEW / etf_1min / 2013-06-24

all etf 1-min files

  file:    by_date/etf_1min/2013/2013-06-24.parquet
  size:    2.8 MB
  rows:    146,376

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
2013-06-24 04:00:00	SPY	ETF	158.24	158.24	158.24	158.24	460.0
2013-06-24 04:03:00	SPY	ETF	158.16	158.2	158.16	158.2	300.0
2013-06-24 04:04:00	SPY	ETF	158.03	158.03	158.03	158.03	100.0
2013-06-24 04:05:00	SPY	ETF	158.1	158.12	158.04	158.05	1900.0
2013-06-24 04:06:00	SPY	ETF	158.04	158.04	158.03	158.03	400.0
2013-06-24 04:07:00	SPY	ETF	158.0	158.0	157.92	157.92	1600.0
2013-06-24 04:08:00	SPY	ETF	157.9	157.9	157.89	157.89	300.0
2013-06-24 04:09:00	SPY	ETF	157.86	157.86	157.86	157.86	300.0
2013-06-24 04:10:00	SPY	ETF	157.84	157.85	157.84	157.85	296.0
2013-06-24 04:11:00	SPY	ETF	157.82	157.82	157.74	157.74	1500.0
2013-06-24 04:14:00	SPY	ETF	157.8	157.87	157.8	157.87	4250.0
2013-06-24 04:15:00	SPY	ETF	157.87	157.87	157.87	157.87	100.0
2013-06-24 04:16:00	SPY	ETF	157.8	157.8	157.8	157.8	200.0
2013-06-24 04:18:00	SPY	ETF	157.8	157.8	157.78	157.78	264.0
2013-06-24 04:21:00	SPY	ETF	157.85	157.86	157.85	157.86	400.0
2013-06-24 04:23:00	SPY	ETF	157.82	157.82	157.77	157.77	1100.0
2013-06-24 04:24:00	SPY	ETF	157.76	157.77	157.75	157.77	800.0
2013-06-24 04:25:00	SPY	ETF	157.78	157.78	157.78	157.78	200.0
2013-06-24 04:26:00	SPY	ETF	157.82	157.82	157.71	157.71	6600.0
2013-06-24 04:27:00	SPY	ETF	157.71	157.77	157.71	157.77	11400.0
2013-06-24 04:28:00	SPY	ETF	157.7	157.7	157.7	157.7	5300.0
2013-06-24 04:29:00	SPY	ETF	157.69	157.69	157.68	157.69	400.0
2013-06-24 04:30:00	SPY	ETF	157.69	157.71	157.68	157.71	500.0
2013-06-24 04:31:00	SPY	ETF	157.71	157.72	157.62	157.62	10500.0
2013-06-24 04:32:00	SPY	ETF	157.6	157.6	157.6	157.6	800.0
2013-06-24 04:33:00	SPY	ETF	157.57	157.57	157.45	157.5	22700.0
2013-06-24 04:34:00	SPY	ETF	157.52	157.52	157.5	157.5	4500.0
2013-06-24 04:35:00	SPY	ETF	157.5	157.55	157.5	157.55	10200.0
2013-06-24 04:36:00	SPY	ETF	157.56	157.58	157.55	157.55	10700.0
2013-06-24 04:37:00	SPY	ETF	157.58	157.58	157.53	157.53	800.0
2013-06-24 04:38:00	SPY	ETF	157.53	157.53	157.53	157.53	400.0
2013-06-24 04:39:00	SPY	ETF	157.55	157.55	157.55	157.55	100.0
2013-06-24 04:41:00	SPY	ETF	157.6	157.62	157.59	157.61	800.0
2013-06-24 04:42:00	SPY	ETF	157.67	157.69	157.67	157.69	3200.0
2013-06-24 04:43:00	SPY	ETF	157.72	157.82	157.72	157.82	2700.0
2013-06-24 04:44:00	SPY	ETF	157.83	157.88	157.83	157.88	800.0
2013-06-24 04:45:00	SPY	ETF	157.83	157.83	157.79	157.8	600.0
2013-06-24 04:47:00	SPY	ETF	157.83	157.83	157.83	157.83	200.0
2013-06-24 04:48:00	SPY	ETF	157.83	157.83	157.77	157.79	1100.0
2013-06-24 04:50:00	SPY	ETF	157.74	157.74	157.68	157.68	300.0
2013-06-24 04:52:00	SPY	ETF	157.62	157.62	157.62	157.62	200.0
2013-06-24 04:53:00	SPY	ETF	157.7	157.7	157.66	157.66	200.0
2013-06-24 04:55:00	SPY	ETF	157.66	157.66	157.66	157.66	100.0
2013-06-24 04:56:00	SPY	ETF	157.62	157.62	157.62	157.62	200.0
2013-06-24 05:01:00	SPY	ETF	157.65	157.65	157.65	157.65	200.0
2013-06-24 05:02:00	SPY	ETF	157.65	157.65	157.62	157.62	200.0
2013-06-24 05:03:00	SPY	ETF	157.6	157.6	157.53	157.53	1200.0
2013-06-24 05:04:00	SPY	ETF	157.51	157.51	157.5	157.5	300.0
2013-06-24 05:05:00	SPY	ETF	157.53	157.53	157.53	157.53	100.0
2013-06-24 05:06:00	SPY	ETF	157.5	157.58	157.5	157.58	5200.0

> showing 50 of 146,376 rows — these rows as CSV

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