PREVIEW / etf_1min / 2014-03-17

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-03-17.parquet
  size:    2.1 MB
  rows:    111,286

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
2014-03-17 04:00:00	SPY	ETF	184.32	184.32	184.32	184.32	100.0
2014-03-17 04:01:00	SPY	ETF	184.77	184.77	184.72	184.72	650.0
2014-03-17 04:02:00	SPY	ETF	184.72	184.72	184.72	184.72	375.0
2014-03-17 04:03:00	SPY	ETF	184.76	184.76	184.76	184.76	400.0
2014-03-17 04:04:00	SPY	ETF	184.77	184.77	184.77	184.77	300.0
2014-03-17 04:05:00	SPY	ETF	184.74	184.8	184.74	184.8	400.0
2014-03-17 04:06:00	SPY	ETF	184.87	184.87	184.87	184.87	400.0
2014-03-17 04:07:00	SPY	ETF	184.86	184.87	184.86	184.87	300.0
2014-03-17 04:09:00	SPY	ETF	184.85	184.85	184.85	184.85	300.0
2014-03-17 04:23:00	SPY	ETF	184.91	184.91	184.91	184.91	150.0
2014-03-17 04:24:00	SPY	ETF	184.97	184.97	184.97	184.97	500.0
2014-03-17 04:26:00	SPY	ETF	185.02	185.03	185.02	185.03	3575.0
2014-03-17 04:27:00	SPY	ETF	185.06	185.07	185.06	185.07	325.0
2014-03-17 04:28:00	SPY	ETF	185.15	185.17	185.15	185.17	2050.0
2014-03-17 04:31:00	SPY	ETF	185.2	185.25	185.2	185.25	375.0
2014-03-17 04:33:00	SPY	ETF	185.2	185.2	185.2	185.2	250.0
2014-03-17 04:34:00	SPY	ETF	185.25	185.25	185.25	185.25	600.0
2014-03-17 04:35:00	SPY	ETF	185.37	185.43	185.37	185.43	300.0
2014-03-17 04:36:00	SPY	ETF	185.41	185.45	185.41	185.45	1400.0
2014-03-17 04:37:00	SPY	ETF	185.48	185.48	185.48	185.48	200.0
2014-03-17 04:38:00	SPY	ETF	185.5	185.52	185.5	185.52	3850.0
2014-03-17 04:39:00	SPY	ETF	185.52	185.64	185.52	185.64	21025.0
2014-03-17 04:41:00	SPY	ETF	185.64	185.64	185.64	185.64	5000.0
2014-03-17 04:42:00	SPY	ETF	185.64	185.68	185.64	185.68	2200.0
2014-03-17 04:44:00	SPY	ETF	185.64	185.64	185.64	185.64	125.0
2014-03-17 04:45:00	SPY	ETF	185.62	185.62	185.62	185.62	400.0
2014-03-17 04:46:00	SPY	ETF	185.61	185.62	185.6	185.6	1300.0
2014-03-17 04:47:00	SPY	ETF	185.59	185.59	185.59	185.59	500.0
2014-03-17 04:50:00	SPY	ETF	185.57	185.57	185.57	185.57	5000.0
2014-03-17 04:52:00	SPY	ETF	185.57	185.57	185.57	185.57	300.0
2014-03-17 04:53:00	SPY	ETF	185.57	185.57	185.57	185.57	300.0
2014-03-17 04:54:00	SPY	ETF	185.57	185.58	185.57	185.58	425.0
2014-03-17 04:57:00	SPY	ETF	185.57	185.57	185.57	185.57	300.0
2014-03-17 04:59:00	SPY	ETF	185.57	185.57	185.57	185.57	100.0
2014-03-17 05:00:00	SPY	ETF	185.58	185.58	185.58	185.58	4845.0
2014-03-17 05:01:00	SPY	ETF	185.66	185.66	185.66	185.66	200.0
2014-03-17 05:02:00	SPY	ETF	185.67	185.7	185.67	185.7	1088.0
2014-03-17 05:03:00	SPY	ETF	185.74	185.77	185.74	185.77	15600.0
2014-03-17 05:04:00	SPY	ETF	185.74	185.76	185.74	185.76	2200.0
2014-03-17 05:05:00	SPY	ETF	185.74	185.74	185.74	185.74	5000.0
2014-03-17 05:06:00	SPY	ETF	185.74	185.74	185.74	185.74	1000.0
2014-03-17 05:08:00	SPY	ETF	185.75	185.76	185.75	185.76	900.0
2014-03-17 05:09:00	SPY	ETF	185.74	185.74	185.74	185.74	5000.0
2014-03-17 05:10:00	SPY	ETF	185.74	185.74	185.74	185.74	500.0
2014-03-17 05:12:00	SPY	ETF	185.67	185.67	185.67	185.67	100.0
2014-03-17 05:13:00	SPY	ETF	185.64	185.65	185.64	185.65	3611.0
2014-03-17 05:15:00	SPY	ETF	185.63	185.64	185.63	185.64	658.0
2014-03-17 05:16:00	SPY	ETF	185.64	185.64	185.64	185.64	100.0
2014-03-17 05:18:00	SPY	ETF	185.64	185.64	185.64	185.64	110.0
2014-03-17 05:20:00	SPY	ETF	185.66	185.66	185.66	185.66	8000.0

> showing 50 of 111,286 rows — these rows as CSV

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