PREVIEW / etf_1min / 2012-03-29

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-03-29.parquet
  size:    2.0 MB
  rows:    106,197

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
2012-03-29 04:00:00	SPY	ETF	140.52	140.7	140.5	140.55	8300.0
2012-03-29 04:35:00	SPY	ETF	140.49	140.49	140.49	140.49	200.0
2012-03-29 04:41:00	SPY	ETF	140.48	140.48	140.48	140.48	402.0
2012-03-29 05:06:00	SPY	ETF	140.36	140.36	140.34	140.34	500.0
2012-03-29 05:07:00	SPY	ETF	140.32	140.32	140.3	140.3	330.0
2012-03-29 05:08:00	SPY	ETF	140.34	140.35	140.34	140.35	75000.0
2012-03-29 05:20:00	SPY	ETF	140.3	140.3	140.3	140.3	1100.0
2012-03-29 05:21:00	SPY	ETF	140.2	140.2	140.2	140.2	230.0
2012-03-29 05:24:00	SPY	ETF	140.17	140.17	140.12	140.12	15690.0
2012-03-29 05:25:00	SPY	ETF	140.12	140.12	140.12	140.12	5000.0
2012-03-29 05:42:00	SPY	ETF	140.16	140.16	140.16	140.16	100.0
2012-03-29 05:43:00	SPY	ETF	140.09	140.09	140.09	140.09	200.0
2012-03-29 05:44:00	SPY	ETF	140.08	140.08	140.08	140.08	240.0
2012-03-29 05:46:00	SPY	ETF	140.09	140.09	140.09	140.09	10000.0
2012-03-29 06:00:00	SPY	ETF	140.0	140.0	139.99	139.99	700.0
2012-03-29 06:01:00	SPY	ETF	140.0	140.0	140.0	140.0	500.0
2012-03-29 06:02:00	SPY	ETF	140.02	140.04	139.97	139.97	37000.0
2012-03-29 06:03:00	SPY	ETF	139.98	139.98	139.98	139.98	500.0
2012-03-29 06:05:00	SPY	ETF	139.98	139.98	139.95	139.95	14500.0
2012-03-29 06:06:00	SPY	ETF	139.99	139.99	139.99	139.99	500.0
2012-03-29 06:11:00	SPY	ETF	139.99	139.99	139.98	139.98	14100.0
2012-03-29 06:13:00	SPY	ETF	139.97	139.97	139.97	139.97	5000.0
2012-03-29 06:15:00	SPY	ETF	140.0	140.0	139.98	139.98	7600.0
2012-03-29 06:17:00	SPY	ETF	140.0	140.0	140.0	140.0	600.0
2012-03-29 06:27:00	SPY	ETF	140.05	140.05	140.05	140.05	214.0
2012-03-29 06:39:00	SPY	ETF	140.03	140.03	140.03	140.03	7500.0
2012-03-29 06:40:00	SPY	ETF	140.03	140.03	140.03	140.03	7500.0
2012-03-29 06:41:00	SPY	ETF	140.02	140.02	139.98	139.98	10000.0
2012-03-29 06:47:00	SPY	ETF	140.02	140.02	140.0	140.0	9500.0
2012-03-29 07:00:00	SPY	ETF	140.0	140.0	140.0	140.0	900.0
2012-03-29 07:01:00	SPY	ETF	140.02	140.02	139.98	139.98	6600.0
2012-03-29 07:03:00	SPY	ETF	139.99	140.0	139.99	140.0	2200.0
2012-03-29 07:04:00	SPY	ETF	140.06	140.06	140.05	140.05	1100.0
2012-03-29 07:05:00	SPY	ETF	140.0	140.0	139.98	139.98	350.0
2012-03-29 07:06:00	SPY	ETF	140.0	140.0	140.0	140.0	500.0
2012-03-29 07:07:00	SPY	ETF	139.98	140.0	139.94	139.94	2090.0
2012-03-29 07:08:00	SPY	ETF	139.93	139.98	139.93	139.98	5210.0
2012-03-29 07:09:00	SPY	ETF	139.94	139.94	139.93	139.93	7000.0
2012-03-29 07:11:00	SPY	ETF	140.0	140.0	140.0	140.0	200.0
2012-03-29 07:12:00	SPY	ETF	140.05	140.05	140.05	140.05	656.0
2012-03-29 07:13:00	SPY	ETF	140.01	140.01	140.01	140.01	360.0
2012-03-29 07:14:00	SPY	ETF	140.03	140.03	140.03	140.03	100.0
2012-03-29 07:15:00	SPY	ETF	140.04	140.05	140.04	140.05	200.0
2012-03-29 07:16:00	SPY	ETF	140.04	140.04	140.04	140.04	400.0
2012-03-29 07:18:00	SPY	ETF	140.1	140.1	140.1	140.1	800.0
2012-03-29 07:19:00	SPY	ETF	140.1	140.1	140.1	140.1	4200.0
2012-03-29 07:21:00	SPY	ETF	140.09	140.12	140.09	140.12	5710.0
2012-03-29 07:22:00	SPY	ETF	140.14	140.14	140.14	140.14	3000.0
2012-03-29 07:23:00	SPY	ETF	140.14	140.14	140.14	140.14	2000.0
2012-03-29 07:25:00	SPY	ETF	140.12	140.12	140.12	140.12	300.0

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

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