PREVIEW / etf_1min / 2012-06-04

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-06-04.parquet
  size:    2.3 MB
  rows:    120,041

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-06-04 04:00:00	SPY	ETF	127.65	127.65	127.53	127.53	700.0
2012-06-04 04:01:00	SPY	ETF	127.38	127.38	127.38	127.38	150.0
2012-06-04 04:02:00	SPY	ETF	127.47	127.47	127.47	127.47	200.0
2012-06-04 04:05:00	SPY	ETF	127.39	127.39	127.39	127.39	100.0
2012-06-04 04:10:00	SPY	ETF	127.38	127.38	127.36	127.36	1500.0
2012-06-04 04:12:00	SPY	ETF	127.4	127.4	127.4	127.4	400.0
2012-06-04 04:13:00	SPY	ETF	127.4	127.4	127.4	127.4	150.0
2012-06-04 04:16:00	SPY	ETF	127.45	127.45	127.45	127.45	100.0
2012-06-04 04:17:00	SPY	ETF	127.49	127.51	127.49	127.51	700.0
2012-06-04 04:18:00	SPY	ETF	127.49	127.49	127.49	127.49	100.0
2012-06-04 04:19:00	SPY	ETF	127.44	127.44	127.44	127.44	100.0
2012-06-04 04:24:00	SPY	ETF	127.54	127.54	127.54	127.54	500.0
2012-06-04 04:26:00	SPY	ETF	127.49	127.49	127.49	127.49	100.0
2012-06-04 04:27:00	SPY	ETF	127.47	127.47	127.41	127.41	400.0
2012-06-04 04:28:00	SPY	ETF	127.42	127.42	127.42	127.42	500.0
2012-06-04 04:29:00	SPY	ETF	127.41	127.41	127.41	127.41	500.0
2012-06-04 04:30:00	SPY	ETF	127.41	127.41	127.41	127.41	500.0
2012-06-04 04:51:00	SPY	ETF	127.49	127.49	127.49	127.49	100.0
2012-06-04 04:52:00	SPY	ETF	127.43	127.43	127.43	127.43	700.0
2012-06-04 04:59:00	SPY	ETF	127.49	127.49	127.49	127.49	500.0
2012-06-04 05:00:00	SPY	ETF	127.49	127.49	127.49	127.49	10088.0
2012-06-04 05:02:00	SPY	ETF	127.5	127.5	127.5	127.5	500.0
2012-06-04 05:06:00	SPY	ETF	127.5	127.5	127.49	127.49	400.0
2012-06-04 05:10:00	SPY	ETF	127.62	127.62	127.62	127.62	300.0
2012-06-04 05:15:00	SPY	ETF	127.56	127.56	127.56	127.56	300.0
2012-06-04 05:16:00	SPY	ETF	127.6	127.6	127.6	127.6	200.0
2012-06-04 05:25:00	SPY	ETF	127.57	127.57	127.57	127.57	200.0
2012-06-04 05:26:00	SPY	ETF	127.65	127.65	127.65	127.65	200.0
2012-06-04 05:29:00	SPY	ETF	127.64	127.64	127.64	127.64	200.0
2012-06-04 05:32:00	SPY	ETF	127.6	127.6	127.6	127.6	100.0
2012-06-04 05:34:00	SPY	ETF	127.64	127.64	127.64	127.64	500.0
2012-06-04 05:35:00	SPY	ETF	127.64	127.64	127.64	127.64	700.0
2012-06-04 05:37:00	SPY	ETF	127.59	127.59	127.55	127.55	700.0
2012-06-04 05:39:00	SPY	ETF	127.59	127.59	127.59	127.59	1500.0
2012-06-04 05:41:00	SPY	ETF	127.62	127.62	127.62	127.62	400.0
2012-06-04 05:43:00	SPY	ETF	127.75	127.75	127.75	127.75	2000.0
2012-06-04 05:46:00	SPY	ETF	127.75	127.75	127.75	127.75	100.0
2012-06-04 05:52:00	SPY	ETF	127.68	127.68	127.68	127.68	1000.0
2012-06-04 05:55:00	SPY	ETF	127.67	127.67	127.67	127.67	200.0
2012-06-04 05:58:00	SPY	ETF	127.7	127.7	127.7	127.7	110.0
2012-06-04 06:00:00	SPY	ETF	127.72	127.72	127.72	127.72	148.0
2012-06-04 06:04:00	SPY	ETF	127.69	127.69	127.69	127.69	200.0
2012-06-04 06:06:00	SPY	ETF	127.72	127.72	127.72	127.72	200.0
2012-06-04 06:12:00	SPY	ETF	127.81	127.81	127.81	127.81	100.0
2012-06-04 06:15:00	SPY	ETF	127.76	127.78	127.76	127.78	200.0
2012-06-04 06:24:00	SPY	ETF	127.88	127.99	127.88	127.96	16088.0
2012-06-04 06:26:00	SPY	ETF	127.98	127.98	127.98	127.98	100.0
2012-06-04 06:28:00	SPY	ETF	128.02	128.03	128.01	128.01	14100.0
2012-06-04 06:29:00	SPY	ETF	128.01	128.01	128.0	128.0	600.0
2012-06-04 06:32:00	SPY	ETF	127.95	127.95	127.95	127.95	600.0

> showing 50 of 120,041 rows — these rows as CSV

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