PREVIEW / etf_1min / 2013-01-18

all etf 1-min files

  file:    by_date/etf_1min/2013/2013-01-18.parquet
  size:    2.0 MB
  rows:    106,404

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-01-18 04:00:00	SPY	ETF	148.16	148.16	148.16	148.16	100.0
2013-01-18 04:17:00	SPY	ETF	147.97	147.97	147.97	147.97	100.0
2013-01-18 04:19:00	SPY	ETF	147.93	147.93	147.93	147.93	150.0
2013-01-18 04:20:00	SPY	ETF	147.98	147.98	147.98	147.98	100.0
2013-01-18 04:52:00	SPY	ETF	148.0	148.0	148.0	148.0	1000.0
2013-01-18 05:08:00	SPY	ETF	147.96	147.96	147.96	147.96	100.0
2013-01-18 05:09:00	SPY	ETF	147.96	147.96	147.96	147.96	500.0
2013-01-18 05:11:00	SPY	ETF	147.92	147.92	147.92	147.92	100.0
2013-01-18 05:13:00	SPY	ETF	147.92	147.92	147.91	147.91	2091.0
2013-01-18 06:05:00	SPY	ETF	148.02	148.02	148.02	148.02	200.0
2013-01-18 06:09:00	SPY	ETF	148.03	148.03	148.03	148.03	199.0
2013-01-18 06:19:00	SPY	ETF	147.98	147.98	147.98	147.98	300.0
2013-01-18 06:21:00	SPY	ETF	147.94	147.94	147.93	147.93	370.0
2013-01-18 06:22:00	SPY	ETF	147.93	147.93	147.93	147.93	100.0
2013-01-18 06:27:00	SPY	ETF	147.94	147.94	147.94	147.94	200.0
2013-01-18 06:28:00	SPY	ETF	147.93	147.93	147.91	147.91	17400.0
2013-01-18 06:47:00	SPY	ETF	147.91	147.91	147.91	147.91	300.0
2013-01-18 06:50:00	SPY	ETF	147.88	147.88	147.88	147.88	4950.0
2013-01-18 06:54:00	SPY	ETF	147.95	147.95	147.95	147.95	14000.0
2013-01-18 06:56:00	SPY	ETF	147.95	147.95	147.95	147.95	2900.0
2013-01-18 07:00:00	SPY	ETF	147.91	147.91	147.91	147.91	400.0
2013-01-18 07:01:00	SPY	ETF	147.9	147.91	147.9	147.91	300.0
2013-01-18 07:03:00	SPY	ETF	147.93	147.93	147.93	147.93	300.0
2013-01-18 07:04:00	SPY	ETF	147.98	147.98	147.93	147.96	24275.0
2013-01-18 07:05:00	SPY	ETF	147.9	147.9	147.9	147.9	2199.0
2013-01-18 07:08:00	SPY	ETF	147.88	147.88	147.88	147.88	200.0
2013-01-18 07:10:00	SPY	ETF	147.87	147.87	147.87	147.87	125.0
2013-01-18 07:12:00	SPY	ETF	147.91	147.93	147.91	147.93	400.0
2013-01-18 07:15:00	SPY	ETF	147.91	147.91	147.91	147.91	400.0
2013-01-18 07:16:00	SPY	ETF	147.9	147.91	147.9	147.91	10000.0
2013-01-18 07:19:00	SPY	ETF	147.9	147.9	147.89	147.89	3200.0
2013-01-18 07:20:00	SPY	ETF	147.87	147.87	147.87	147.87	100.0
2013-01-18 07:21:00	SPY	ETF	147.89	147.89	147.89	147.89	5000.0
2013-01-18 07:22:00	SPY	ETF	147.87	147.87	147.85	147.86	4902.0
2013-01-18 07:23:00	SPY	ETF	147.85	147.89	147.85	147.89	13596.0
2013-01-18 07:24:00	SPY	ETF	147.85	147.85	147.82	147.84	5000.0
2013-01-18 07:25:00	SPY	ETF	147.84	147.85	147.8	147.82	8200.0
2013-01-18 07:26:00	SPY	ETF	147.84	147.88	147.84	147.88	2500.0
2013-01-18 07:27:00	SPY	ETF	147.88	147.88	147.82	147.88	77300.0
2013-01-18 07:28:00	SPY	ETF	147.85	147.85	147.85	147.85	500.0
2013-01-18 07:29:00	SPY	ETF	147.88	147.89	147.88	147.89	10400.0
2013-01-18 07:30:00	SPY	ETF	147.89	147.89	147.89	147.89	17500.0
2013-01-18 07:31:00	SPY	ETF	147.91	147.91	147.89	147.89	10000.0
2013-01-18 07:33:00	SPY	ETF	147.91	147.93	147.91	147.93	5100.0
2013-01-18 07:34:00	SPY	ETF	147.91	147.93	147.91	147.93	2200.0
2013-01-18 07:35:00	SPY	ETF	147.94	147.94	147.94	147.94	3100.0
2013-01-18 07:36:00	SPY	ETF	147.94	147.97	147.94	147.97	600.0
2013-01-18 07:38:00	SPY	ETF	147.97	148.0	147.97	147.99	2099.0
2013-01-18 07:39:00	SPY	ETF	148.01	148.01	148.01	148.01	100.0
2013-01-18 07:40:00	SPY	ETF	148.02	148.03	148.02	148.02	3602.0

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

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