PREVIEW / etf_1min / 2011-06-23

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-06-23.parquet
  size:    2.2 MB
  rows:    112,057

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
2011-06-23 04:06:00	SPY	ETF	128.0	128.0	128.0	128.0	100.0
2011-06-23 04:11:00	SPY	ETF	128.17	128.17	128.17	128.17	100.0
2011-06-23 04:28:00	SPY	ETF	128.09	128.09	128.07	128.08	2100.0
2011-06-23 04:29:00	SPY	ETF	128.08	128.14	128.08	128.14	500.0
2011-06-23 04:53:00	SPY	ETF	128.0	128.06	128.0	128.06	2600.0
2011-06-23 05:00:00	SPY	ETF	128.0	128.0	128.0	128.0	100.0
2011-06-23 05:09:00	SPY	ETF	128.02	128.02	128.02	128.02	500.0
2011-06-23 05:18:00	SPY	ETF	127.94	127.94	127.94	127.94	100.0
2011-06-23 05:27:00	SPY	ETF	127.93	127.93	127.93	127.93	100.0
2011-06-23 05:28:00	SPY	ETF	127.85	127.85	127.85	127.85	200.0
2011-06-23 05:29:00	SPY	ETF	127.82	127.82	127.81	127.81	200.0
2011-06-23 05:31:00	SPY	ETF	127.81	127.81	127.81	127.81	100.0
2011-06-23 05:34:00	SPY	ETF	127.81	127.81	127.81	127.81	200.0
2011-06-23 05:42:00	SPY	ETF	127.8	127.8	127.8	127.8	200.0
2011-06-23 05:51:00	SPY	ETF	127.86	127.86	127.86	127.86	300.0
2011-06-23 05:52:00	SPY	ETF	127.86	127.86	127.86	127.86	300.0
2011-06-23 05:53:00	SPY	ETF	127.92	127.92	127.92	127.92	500.0
2011-06-23 05:54:00	SPY	ETF	127.93	127.93	127.93	127.93	9500.0
2011-06-23 05:56:00	SPY	ETF	127.9	127.9	127.9	127.9	300.0
2011-06-23 05:58:00	SPY	ETF	127.82	127.82	127.82	127.82	200.0
2011-06-23 06:01:00	SPY	ETF	127.84	127.84	127.84	127.84	100.0
2011-06-23 06:08:00	SPY	ETF	128.05	128.05	128.05	128.05	100.0
2011-06-23 06:09:00	SPY	ETF	128.05	128.05	128.05	128.05	400.0
2011-06-23 06:10:00	SPY	ETF	127.97	127.97	127.97	127.97	100.0
2011-06-23 06:15:00	SPY	ETF	127.92	127.92	127.92	127.92	200.0
2011-06-23 06:27:00	SPY	ETF	127.91	127.91	127.91	127.91	100.0
2011-06-23 06:32:00	SPY	ETF	127.85	127.85	127.82	127.82	3115.0
2011-06-23 06:34:00	SPY	ETF	127.83	127.83	127.83	127.83	200.0
2011-06-23 06:35:00	SPY	ETF	127.81	127.81	127.81	127.81	100.0
2011-06-23 06:37:00	SPY	ETF	127.82	127.82	127.82	127.82	1800.0
2011-06-23 06:42:00	SPY	ETF	127.79	127.79	127.77	127.77	400.0
2011-06-23 06:43:00	SPY	ETF	127.79	127.79	127.77	127.77	400.0
2011-06-23 06:44:00	SPY	ETF	127.81	127.81	127.81	127.81	100.0
2011-06-23 06:45:00	SPY	ETF	127.78	127.78	127.78	127.78	300.0
2011-06-23 06:46:00	SPY	ETF	127.81	127.81	127.72	127.81	20315.0
2011-06-23 06:48:00	SPY	ETF	127.72	127.78	127.72	127.78	200.0
2011-06-23 06:50:00	SPY	ETF	127.76	127.81	127.75	127.81	3700.0
2011-06-23 06:51:00	SPY	ETF	127.75	127.84	127.75	127.84	11500.0
2011-06-23 06:53:00	SPY	ETF	127.77	127.77	127.77	127.77	200.0
2011-06-23 06:56:00	SPY	ETF	127.75	127.75	127.7	127.7	2200.0
2011-06-23 06:58:00	SPY	ETF	127.76	127.76	127.7	127.7	6000.0
2011-06-23 07:00:00	SPY	ETF	127.75	127.75	127.72	127.72	3850.0
2011-06-23 07:01:00	SPY	ETF	127.72	127.72	127.69	127.69	1500.0
2011-06-23 07:02:00	SPY	ETF	127.71	127.72	127.68	127.68	2250.0
2011-06-23 07:03:00	SPY	ETF	127.72	127.72	127.63	127.63	40850.0
2011-06-23 07:04:00	SPY	ETF	127.67	127.67	127.65	127.67	52240.0
2011-06-23 07:05:00	SPY	ETF	127.67	127.72	127.66	127.72	1937.0
2011-06-23 07:06:00	SPY	ETF	127.74	127.74	127.69	127.69	9000.0
2011-06-23 07:07:00	SPY	ETF	127.72	127.72	127.72	127.72	6200.0
2011-06-23 07:08:00	SPY	ETF	127.72	127.72	127.7	127.7	1900.0

> showing 50 of 112,057 rows — these rows as CSV

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