PREVIEW / etf_1min / 2013-04-15

all etf 1-min files

  file:    by_date/etf_1min/2013/2013-04-15.parquet
  size:    2.6 MB
  rows:    130,848

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-04-15 04:00:00	SPY	ETF	158.25	158.25	158.15	158.15	450.0
2013-04-15 04:01:00	SPY	ETF	158.06	158.06	158.06	158.06	200.0
2013-04-15 04:04:00	SPY	ETF	158.02	158.02	158.02	158.02	200.0
2013-04-15 04:05:00	SPY	ETF	158.02	158.02	158.02	158.02	100.0
2013-04-15 04:06:00	SPY	ETF	157.97	157.97	157.97	157.97	100.0
2013-04-15 04:07:00	SPY	ETF	157.94	157.94	157.94	157.94	100.0
2013-04-15 04:12:00	SPY	ETF	157.92	157.92	157.92	157.92	10000.0
2013-04-15 04:13:00	SPY	ETF	157.89	157.89	157.84	157.84	1000.0
2013-04-15 04:17:00	SPY	ETF	157.72	157.72	157.69	157.69	8300.0
2013-04-15 04:18:00	SPY	ETF	157.67	157.67	157.62	157.62	1000.0
2013-04-15 04:19:00	SPY	ETF	157.69	157.72	157.69	157.72	800.0
2013-04-15 04:22:00	SPY	ETF	157.85	157.87	157.85	157.87	400.0
2013-04-15 04:24:00	SPY	ETF	157.89	157.89	157.89	157.89	500.0
2013-04-15 04:27:00	SPY	ETF	157.89	157.89	157.89	157.89	200.0
2013-04-15 04:31:00	SPY	ETF	157.8	157.8	157.8	157.8	7500.0
2013-04-15 04:32:00	SPY	ETF	157.79	157.79	157.77	157.77	200.0
2013-04-15 04:34:00	SPY	ETF	157.79	157.79	157.79	157.79	100.0
2013-04-15 05:05:00	SPY	ETF	157.93	157.93	157.93	157.93	100.0
2013-04-15 05:07:00	SPY	ETF	157.99	158.09	157.99	158.09	200.0
2013-04-15 05:14:00	SPY	ETF	157.96	157.96	157.96	157.96	100.0
2013-04-15 05:15:00	SPY	ETF	157.94	157.94	157.94	157.94	6000.0
2013-04-15 05:16:00	SPY	ETF	157.94	157.94	157.94	157.94	100.0
2013-04-15 05:20:00	SPY	ETF	158.0	158.0	158.0	158.0	100.0
2013-04-15 05:23:00	SPY	ETF	157.95	157.95	157.95	157.95	200.0
2013-04-15 05:27:00	SPY	ETF	158.0	158.0	157.99	157.99	1390.0
2013-04-15 05:28:00	SPY	ETF	158.01	158.01	158.01	158.01	200.0
2013-04-15 05:30:00	SPY	ETF	157.98	157.98	157.98	157.98	100.0
2013-04-15 05:33:00	SPY	ETF	157.96	157.96	157.96	157.96	4000.0
2013-04-15 05:36:00	SPY	ETF	157.92	157.98	157.92	157.98	3000.0
2013-04-15 05:38:00	SPY	ETF	157.99	157.99	157.99	157.99	100.0
2013-04-15 05:41:00	SPY	ETF	157.9	157.9	157.86	157.86	500.0
2013-04-15 05:42:00	SPY	ETF	157.85	157.85	157.83	157.83	400.0
2013-04-15 05:44:00	SPY	ETF	157.82	157.82	157.77	157.77	500.0
2013-04-15 05:45:00	SPY	ETF	157.77	157.77	157.75	157.75	499.0
2013-04-15 05:46:00	SPY	ETF	157.75	157.75	157.75	157.75	1100.0
2013-04-15 05:47:00	SPY	ETF	157.75	157.75	157.71	157.71	1100.0
2013-04-15 05:48:00	SPY	ETF	157.71	157.71	157.71	157.71	2500.0
2013-04-15 05:49:00	SPY	ETF	157.74	157.74	157.74	157.74	100.0
2013-04-15 05:52:00	SPY	ETF	157.71	157.71	157.69	157.69	2800.0
2013-04-15 05:55:00	SPY	ETF	157.71	157.71	157.71	157.71	100.0
2013-04-15 05:56:00	SPY	ETF	157.69	157.69	157.65	157.66	17700.0
2013-04-15 05:57:00	SPY	ETF	157.66	157.68	157.66	157.68	15200.0
2013-04-15 05:59:00	SPY	ETF	157.72	157.72	157.72	157.72	2000.0
2013-04-15 06:01:00	SPY	ETF	157.73	157.73	157.73	157.73	100.0
2013-04-15 06:03:00	SPY	ETF	157.65	157.65	157.64	157.64	300.0
2013-04-15 06:04:00	SPY	ETF	157.65	157.67	157.65	157.67	200.0
2013-04-15 06:05:00	SPY	ETF	157.66	157.66	157.63	157.63	700.0
2013-04-15 06:06:00	SPY	ETF	157.62	157.63	157.61	157.63	1500.0
2013-04-15 06:07:00	SPY	ETF	157.64	157.64	157.64	157.64	10100.0
2013-04-15 06:09:00	SPY	ETF	157.69	157.69	157.69	157.69	500.0

> showing 50 of 130,848 rows — these rows as CSV

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