PREVIEW / etf_1min / 2012-08-10

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-08-10.parquet
  size:    1.6 MB
  rows:    87,448

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-08-10 04:00:00	SPY	ETF	140.19	140.33	140.14	140.17	6923.0
2012-08-10 04:12:00	SPY	ETF	140.22	140.22	140.22	140.22	100.0
2012-08-10 04:14:00	SPY	ETF	140.26	140.26	140.26	140.26	333.0
2012-08-10 04:36:00	SPY	ETF	140.33	140.33	140.33	140.33	1000.0
2012-08-10 04:45:00	SPY	ETF	140.31	140.31	140.31	140.31	200.0
2012-08-10 04:46:00	SPY	ETF	140.28	140.28	140.28	140.28	100.0
2012-08-10 04:48:00	SPY	ETF	140.24	140.24	140.24	140.24	500.0
2012-08-10 05:09:00	SPY	ETF	140.23	140.23	140.23	140.23	500.0
2012-08-10 05:11:00	SPY	ETF	140.23	140.23	140.23	140.23	500.0
2012-08-10 05:12:00	SPY	ETF	140.23	140.23	140.23	140.23	500.0
2012-08-10 05:13:00	SPY	ETF	140.23	140.23	140.23	140.23	1000.0
2012-08-10 05:16:00	SPY	ETF	140.31	140.31	140.31	140.31	1000.0
2012-08-10 05:22:00	SPY	ETF	140.31	140.31	140.31	140.31	100.0
2012-08-10 05:34:00	SPY	ETF	140.24	140.24	140.24	140.24	100.0
2012-08-10 05:38:00	SPY	ETF	140.18	140.23	140.18	140.23	2600.0
2012-08-10 05:40:00	SPY	ETF	140.19	140.19	140.18	140.18	3000.0
2012-08-10 05:46:00	SPY	ETF	140.16	140.16	140.16	140.16	3000.0
2012-08-10 05:48:00	SPY	ETF	140.18	140.18	140.18	140.18	400.0
2012-08-10 05:50:00	SPY	ETF	140.14	140.14	140.14	140.14	3000.0
2012-08-10 05:59:00	SPY	ETF	140.21	140.21	140.21	140.21	20000.0
2012-08-10 06:11:00	SPY	ETF	140.22	140.22	140.21	140.21	400.0
2012-08-10 06:12:00	SPY	ETF	140.2	140.2	140.2	140.2	100.0
2012-08-10 06:21:00	SPY	ETF	140.23	140.23	140.23	140.23	100.0
2012-08-10 06:22:00	SPY	ETF	140.21	140.21	140.21	140.21	9900.0
2012-08-10 06:23:00	SPY	ETF	140.25	140.25	140.25	140.25	500.0
2012-08-10 06:25:00	SPY	ETF	140.23	140.23	140.23	140.23	100.0
2012-08-10 06:32:00	SPY	ETF	140.23	140.23	140.23	140.23	200.0
2012-08-10 06:33:00	SPY	ETF	140.19	140.19	140.18	140.18	1100.0
2012-08-10 06:34:00	SPY	ETF	140.17	140.17	140.17	140.17	100.0
2012-08-10 06:36:00	SPY	ETF	140.21	140.21	140.21	140.21	25000.0
2012-08-10 06:37:00	SPY	ETF	140.18	140.18	140.15	140.15	25500.0
2012-08-10 06:38:00	SPY	ETF	140.15	140.15	140.15	140.15	44500.0
2012-08-10 06:39:00	SPY	ETF	140.13	140.13	140.13	140.13	9900.0
2012-08-10 06:41:00	SPY	ETF	140.1	140.1	140.1	140.1	15000.0
2012-08-10 06:46:00	SPY	ETF	140.03	140.03	140.03	140.03	10300.0
2012-08-10 06:47:00	SPY	ETF	140.03	140.06	140.03	140.06	3650.0
2012-08-10 06:48:00	SPY	ETF	140.07	140.07	140.07	140.07	2000.0
2012-08-10 06:49:00	SPY	ETF	140.08	140.08	140.08	140.08	22000.0
2012-08-10 06:51:00	SPY	ETF	140.06	140.06	140.06	140.06	100.0
2012-08-10 06:53:00	SPY	ETF	140.07	140.07	140.07	140.07	5000.0
2012-08-10 06:54:00	SPY	ETF	140.05	140.05	140.05	140.05	4900.0
2012-08-10 06:58:00	SPY	ETF	140.05	140.05	140.01	140.01	1276.0
2012-08-10 06:59:00	SPY	ETF	140.02	140.02	140.02	140.02	376.0
2012-08-10 07:00:00	SPY	ETF	140.05	140.05	140.05	140.05	600.0
2012-08-10 07:01:00	SPY	ETF	140.07	140.07	139.98	139.98	14809.0
2012-08-10 07:02:00	SPY	ETF	139.98	140.0	139.98	140.0	3600.0
2012-08-10 07:04:00	SPY	ETF	140.02	140.02	140.01	140.01	1000.0
2012-08-10 07:05:00	SPY	ETF	140.05	140.05	140.05	140.05	150.0
2012-08-10 07:07:00	SPY	ETF	140.09	140.09	140.09	140.09	425.0
2012-08-10 07:08:00	SPY	ETF	140.07	140.08	140.07	140.08	15300.0

> showing 50 of 87,448 rows — these rows as CSV

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