PREVIEW / etf_1min / 2012-01-19

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-01-19.parquet
  size:    2.1 MB
  rows:    109,032

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-01-19 04:01:00	SPY	ETF	130.6	130.6	130.6	130.6	400.0
2012-01-19 04:12:00	SPY	ETF	130.6	130.6	130.56	130.56	700.0
2012-01-19 04:21:00	SPY	ETF	130.53	130.53	130.53	130.53	2500.0
2012-01-19 04:25:00	SPY	ETF	130.58	130.58	130.58	130.58	200.0
2012-01-19 04:26:00	SPY	ETF	130.52	130.52	130.52	130.52	2000.0
2012-01-19 04:29:00	SPY	ETF	130.53	130.53	130.5	130.5	1750.0
2012-01-19 04:43:00	SPY	ETF	130.68	130.68	130.68	130.68	300.0
2012-01-19 04:51:00	SPY	ETF	130.6	130.6	130.6	130.6	2700.0
2012-01-19 05:01:00	SPY	ETF	130.48	130.48	130.48	130.48	200.0
2012-01-19 05:02:00	SPY	ETF	130.43	130.43	130.43	130.43	200.0
2012-01-19 05:10:00	SPY	ETF	130.5	130.5	130.5	130.5	2500.0
2012-01-19 05:14:00	SPY	ETF	130.53	130.53	130.51	130.51	2000.0
2012-01-19 05:16:00	SPY	ETF	130.48	130.48	130.48	130.48	2000.0
2012-01-19 05:23:00	SPY	ETF	130.58	130.58	130.58	130.58	100.0
2012-01-19 05:30:00	SPY	ETF	130.66	130.66	130.66	130.66	100.0
2012-01-19 05:36:00	SPY	ETF	130.61	130.61	130.61	130.61	200.0
2012-01-19 05:50:00	SPY	ETF	130.67	130.67	130.67	130.67	5000.0
2012-01-19 05:55:00	SPY	ETF	130.68	130.68	130.68	130.68	2000.0
2012-01-19 05:58:00	SPY	ETF	130.73	130.73	130.73	130.73	100.0
2012-01-19 05:59:00	SPY	ETF	130.78	130.78	130.78	130.78	1000.0
2012-01-19 06:00:00	SPY	ETF	130.74	130.74	130.74	130.74	200.0
2012-01-19 06:10:00	SPY	ETF	130.73	130.73	130.73	130.73	100.0
2012-01-19 06:37:00	SPY	ETF	130.8	130.8	130.8	130.8	4960.0
2012-01-19 06:40:00	SPY	ETF	130.78	130.78	130.78	130.78	100.0
2012-01-19 06:44:00	SPY	ETF	130.8	130.8	130.8	130.8	5000.0
2012-01-19 06:47:00	SPY	ETF	130.83	130.85	130.83	130.85	4600.0
2012-01-19 06:53:00	SPY	ETF	130.79	130.79	130.79	130.79	180.0
2012-01-19 07:00:00	SPY	ETF	130.78	130.8	130.75	130.8	2100.0
2012-01-19 07:02:00	SPY	ETF	130.83	130.83	130.81	130.81	12600.0
2012-01-19 07:03:00	SPY	ETF	130.8	130.85	130.8	130.84	10700.0
2012-01-19 07:04:00	SPY	ETF	130.84	130.85	130.8	130.8	19950.0
2012-01-19 07:05:00	SPY	ETF	130.84	130.84	130.84	130.84	100.0
2012-01-19 07:06:00	SPY	ETF	130.84	130.84	130.83	130.83	6150.0
2012-01-19 07:07:00	SPY	ETF	130.82	130.87	130.82	130.85	18750.0
2012-01-19 07:08:00	SPY	ETF	130.85	130.9	130.85	130.9	33450.0
2012-01-19 07:09:00	SPY	ETF	130.85	130.85	130.85	130.85	5600.0
2012-01-19 07:11:00	SPY	ETF	130.85	130.85	130.83	130.83	11300.0
2012-01-19 07:15:00	SPY	ETF	130.79	130.79	130.77	130.77	300.0
2012-01-19 07:16:00	SPY	ETF	130.79	130.79	130.76	130.76	5700.0
2012-01-19 07:17:00	SPY	ETF	130.77	130.77	130.77	130.77	600.0
2012-01-19 07:18:00	SPY	ETF	130.88	130.9	130.88	130.9	900.0
2012-01-19 07:19:00	SPY	ETF	130.91	130.97	130.91	130.96	3270.0
2012-01-19 07:20:00	SPY	ETF	130.96	130.99	130.96	130.96	16730.0
2012-01-19 07:21:00	SPY	ETF	130.94	130.99	130.94	130.98	14250.0
2012-01-19 07:22:00	SPY	ETF	130.98	131.04	130.98	131.04	5104.0
2012-01-19 07:23:00	SPY	ETF	131.04	131.04	131.01	131.02	31400.0
2012-01-19 07:24:00	SPY	ETF	131.03	131.04	131.02	131.04	2588.0
2012-01-19 07:25:00	SPY	ETF	131.04	131.04	130.99	131.0	4500.0
2012-01-19 07:26:00	SPY	ETF	131.01	131.02	131.01	131.02	200.0
2012-01-19 07:27:00	SPY	ETF	131.04	131.05	131.02	131.02	2000.0

> showing 50 of 109,032 rows — these rows as CSV

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