PREVIEW / etf_1min / 2013-05-31

all etf 1-min files

  file:    by_date/etf_1min/2013/2013-05-31.parquet
  size:    2.3 MB
  rows:    121,952

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-05-31 04:00:00	SPY	ETF	165.18	165.18	165.18	165.18	990.0
2013-05-31 04:01:00	SPY	ETF	165.0	165.0	165.0	165.0	1198.0
2013-05-31 04:02:00	SPY	ETF	165.03	165.03	165.03	165.03	1000.0
2013-05-31 04:04:00	SPY	ETF	165.0	165.0	165.0	165.0	1000.0
2013-05-31 04:05:00	SPY	ETF	165.07	165.07	165.03	165.03	1228.0
2013-05-31 04:06:00	SPY	ETF	165.06	165.06	165.06	165.06	1000.0
2013-05-31 04:08:00	SPY	ETF	165.12	165.12	165.12	165.12	10000.0
2013-05-31 04:19:00	SPY	ETF	165.0	165.0	165.0	165.0	1000.0
2013-05-31 04:21:00	SPY	ETF	164.99	164.99	164.99	164.99	100.0
2013-05-31 04:22:00	SPY	ETF	164.94	164.94	164.94	164.94	1000.0
2013-05-31 04:23:00	SPY	ETF	164.94	164.94	164.94	164.94	2300.0
2013-05-31 04:24:00	SPY	ETF	164.91	164.91	164.91	164.91	150.0
2013-05-31 04:25:00	SPY	ETF	164.91	164.91	164.9	164.9	1750.0
2013-05-31 04:28:00	SPY	ETF	164.86	164.86	164.86	164.86	1000.0
2013-05-31 04:30:00	SPY	ETF	164.93	164.93	164.93	164.93	100.0
2013-05-31 04:32:00	SPY	ETF	164.93	164.93	164.91	164.91	1100.0
2013-05-31 04:39:00	SPY	ETF	164.9	164.9	164.9	164.9	15000.0
2013-05-31 04:40:00	SPY	ETF	164.94	164.94	164.94	164.94	300.0
2013-05-31 04:45:00	SPY	ETF	164.97	164.97	164.97	164.97	100.0
2013-05-31 04:51:00	SPY	ETF	164.86	164.86	164.85	164.85	3700.0
2013-05-31 04:58:00	SPY	ETF	164.85	164.85	164.85	164.85	8100.0
2013-05-31 05:00:00	SPY	ETF	164.81	164.81	164.8	164.8	50080.0
2013-05-31 05:01:00	SPY	ETF	164.74	164.74	164.72	164.72	300.0
2013-05-31 05:03:00	SPY	ETF	164.74	164.74	164.74	164.74	960.0
2013-05-31 05:05:00	SPY	ETF	164.77	164.77	164.77	164.77	500.0
2013-05-31 05:10:00	SPY	ETF	164.72	164.72	164.71	164.71	300.0
2013-05-31 05:16:00	SPY	ETF	164.74	164.74	164.74	164.74	400.0
2013-05-31 05:18:00	SPY	ETF	164.77	164.77	164.77	164.77	100.0
2013-05-31 05:19:00	SPY	ETF	164.79	164.79	164.77	164.77	715.0
2013-05-31 05:20:00	SPY	ETF	164.76	164.76	164.76	164.76	1400.0
2013-05-31 05:22:00	SPY	ETF	164.78	164.78	164.78	164.78	5000.0
2013-05-31 05:23:00	SPY	ETF	164.84	164.84	164.84	164.84	300.0
2013-05-31 05:24:00	SPY	ETF	164.82	164.82	164.82	164.82	5000.0
2013-05-31 05:26:00	SPY	ETF	164.82	164.82	164.77	164.77	10200.0
2013-05-31 05:27:00	SPY	ETF	164.77	164.77	164.77	164.77	100.0
2013-05-31 05:28:00	SPY	ETF	164.8	164.8	164.8	164.8	100.0
2013-05-31 05:29:00	SPY	ETF	164.79	164.79	164.77	164.77	2800.0
2013-05-31 05:30:00	SPY	ETF	164.77	164.77	164.74	164.74	5000.0
2013-05-31 05:33:00	SPY	ETF	164.71	164.71	164.7	164.7	49000.0
2013-05-31 05:34:00	SPY	ETF	164.71	164.71	164.7	164.7	2500.0
2013-05-31 05:35:00	SPY	ETF	164.7	164.7	164.67	164.67	2100.0
2013-05-31 05:36:00	SPY	ETF	164.67	164.67	164.67	164.67	100.0
2013-05-31 05:38:00	SPY	ETF	164.64	164.64	164.61	164.61	700.0
2013-05-31 05:39:00	SPY	ETF	164.63	164.63	164.63	164.63	1200.0
2013-05-31 05:40:00	SPY	ETF	164.69	164.69	164.69	164.69	100.0
2013-05-31 05:43:00	SPY	ETF	164.64	164.64	164.64	164.64	100.0
2013-05-31 05:44:00	SPY	ETF	164.61	164.61	164.61	164.61	300.0
2013-05-31 05:45:00	SPY	ETF	164.62	164.62	164.57	164.59	3350.0
2013-05-31 05:46:00	SPY	ETF	164.59	164.67	164.59	164.67	1700.0
2013-05-31 05:47:00	SPY	ETF	164.67	164.69	164.67	164.69	400.0

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

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