PREVIEW / etf_1min / 2011-03-15

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-03-15.parquet
  size:    2.6 MB
  rows:    131,046

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-03-15 04:00:00	SPY	ETF	127.75	127.75	127.54	127.54	6035.0
2011-03-15 04:01:00	SPY	ETF	127.51	127.61	127.51	127.61	4410.0
2011-03-15 04:02:00	SPY	ETF	127.54	127.55	127.54	127.55	600.0
2011-03-15 04:03:00	SPY	ETF	127.55	127.6	127.54	127.6	1071.0
2011-03-15 04:04:00	SPY	ETF	127.69	127.69	127.69	127.69	200.0
2011-03-15 04:05:00	SPY	ETF	127.69	127.76	127.69	127.72	4300.0
2011-03-15 04:07:00	SPY	ETF	127.74	127.74	127.74	127.74	200.0
2011-03-15 04:08:00	SPY	ETF	127.76	127.86	127.76	127.86	900.0
2011-03-15 04:10:00	SPY	ETF	127.74	127.74	127.72	127.72	1300.0
2011-03-15 04:11:00	SPY	ETF	127.81	127.82	127.81	127.82	3000.0
2011-03-15 04:12:00	SPY	ETF	127.82	127.86	127.82	127.86	12500.0
2011-03-15 04:13:00	SPY	ETF	127.85	127.85	127.85	127.85	10000.0
2011-03-15 04:14:00	SPY	ETF	127.83	127.85	127.83	127.85	10000.0
2011-03-15 04:15:00	SPY	ETF	127.81	127.85	127.81	127.85	10000.0
2011-03-15 04:16:00	SPY	ETF	127.87	127.91	127.87	127.91	5100.0
2011-03-15 04:17:00	SPY	ETF	127.9	127.91	127.88	127.9	20000.0
2011-03-15 04:18:00	SPY	ETF	127.92	127.96	127.92	127.96	20000.0
2011-03-15 04:19:00	SPY	ETF	128.0	128.02	127.96	127.96	23000.0
2011-03-15 04:20:00	SPY	ETF	127.98	128.05	127.98	128.02	22500.0
2011-03-15 04:21:00	SPY	ETF	128.05	128.08	128.05	128.05	14700.0
2011-03-15 04:22:00	SPY	ETF	128.03	128.05	128.03	128.04	12000.0
2011-03-15 04:23:00	SPY	ETF	128.02	128.02	127.98	127.98	992.0
2011-03-15 04:25:00	SPY	ETF	128.2	128.2	128.2	128.2	392.0
2011-03-15 04:27:00	SPY	ETF	128.02	128.05	128.02	128.05	7500.0
2011-03-15 04:28:00	SPY	ETF	128.08	128.08	128.08	128.08	500.0
2011-03-15 04:29:00	SPY	ETF	128.03	128.03	128.03	128.03	100.0
2011-03-15 04:30:00	SPY	ETF	128.09	128.12	128.09	128.12	15000.0
2011-03-15 04:31:00	SPY	ETF	128.03	128.07	128.02	128.07	10000.0
2011-03-15 04:32:00	SPY	ETF	128.05	128.05	128.03	128.03	3500.0
2011-03-15 04:33:00	SPY	ETF	128.04	128.1	128.0	128.0	13474.0
2011-03-15 04:34:00	SPY	ETF	128.01	128.03	128.01	128.01	2486.0
2011-03-15 04:35:00	SPY	ETF	128.09	128.1	128.03	128.1	10496.0
2011-03-15 04:36:00	SPY	ETF	128.04	128.05	128.04	128.05	5497.0
2011-03-15 04:37:00	SPY	ETF	128.06	128.06	128.06	128.06	5000.0
2011-03-15 04:38:00	SPY	ETF	128.05	128.05	128.02	128.02	10000.0
2011-03-15 04:39:00	SPY	ETF	127.91	127.91	127.91	127.91	500.0
2011-03-15 04:41:00	SPY	ETF	127.95	127.95	127.91	127.92	7000.0
2011-03-15 04:42:00	SPY	ETF	127.91	127.91	127.91	127.91	800.0
2011-03-15 04:45:00	SPY	ETF	127.91	127.91	127.9	127.9	1000.0
2011-03-15 04:46:00	SPY	ETF	127.88	127.88	127.88	127.88	100.0
2011-03-15 04:47:00	SPY	ETF	127.88	127.88	127.86	127.86	900.0
2011-03-15 04:50:00	SPY	ETF	127.87	127.87	127.87	127.87	993.0
2011-03-15 04:51:00	SPY	ETF	127.86	127.86	127.86	127.86	800.0
2011-03-15 04:52:00	SPY	ETF	127.84	127.84	127.78	127.78	786.0
2011-03-15 04:53:00	SPY	ETF	127.77	127.77	127.72	127.72	900.0
2011-03-15 04:54:00	SPY	ETF	127.7	127.7	127.68	127.68	200.0
2011-03-15 04:55:00	SPY	ETF	127.69	127.72	127.69	127.72	9000.0
2011-03-15 04:56:00	SPY	ETF	127.73	127.73	127.64	127.64	6300.0
2011-03-15 04:57:00	SPY	ETF	127.7	127.7	127.64	127.64	5597.0
2011-03-15 04:58:00	SPY	ETF	127.68	127.68	127.68	127.68	2500.0

> showing 50 of 131,046 rows — these rows as CSV

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