PREVIEW / etf_1min / 2012-04-23

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-04-23.parquet
  size:    2.0 MB
  rows:    105,299

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-04-23 04:00:00	SPY	ETF	137.14	137.14	137.0	137.0	1100.0
2012-04-23 04:05:00	SPY	ETF	136.63	136.63	136.63	136.63	100.0
2012-04-23 04:06:00	SPY	ETF	136.74	136.74	136.74	136.74	300.0
2012-04-23 04:07:00	SPY	ETF	136.73	136.73	136.73	136.73	100.0
2012-04-23 04:08:00	SPY	ETF	136.78	136.78	136.78	136.78	200.0
2012-04-23 04:09:00	SPY	ETF	136.82	136.82	136.82	136.82	12000.0
2012-04-23 04:10:00	SPY	ETF	136.82	136.82	136.82	136.82	18000.0
2012-04-23 04:11:00	SPY	ETF	136.77	136.82	136.77	136.79	3100.0
2012-04-23 04:12:00	SPY	ETF	136.83	136.83	136.83	136.83	400.0
2012-04-23 04:14:00	SPY	ETF	136.91	136.91	136.91	136.91	600.0
2012-04-23 04:21:00	SPY	ETF	136.93	136.93	136.93	136.93	15000.0
2012-04-23 04:29:00	SPY	ETF	136.89	136.92	136.89	136.92	1000.0
2012-04-23 04:37:00	SPY	ETF	136.93	136.93	136.93	136.93	100.0
2012-04-23 04:42:00	SPY	ETF	136.94	136.94	136.94	136.94	700.0
2012-04-23 04:45:00	SPY	ETF	136.88	136.88	136.88	136.88	400.0
2012-04-23 04:46:00	SPY	ETF	136.84	136.84	136.84	136.84	100.0
2012-04-23 04:55:00	SPY	ETF	136.8	136.8	136.8	136.8	100.0
2012-04-23 05:01:00	SPY	ETF	136.78	136.78	136.78	136.78	1500.0
2012-04-23 05:02:00	SPY	ETF	136.78	136.78	136.78	136.78	3500.0
2012-04-23 05:07:00	SPY	ETF	136.75	136.75	136.71	136.71	892.0
2012-04-23 05:12:00	SPY	ETF	136.79	136.79	136.79	136.79	170.0
2012-04-23 05:20:00	SPY	ETF	136.71	136.71	136.71	136.71	300.0
2012-04-23 05:21:00	SPY	ETF	136.71	136.71	136.71	136.71	300.0
2012-04-23 05:22:00	SPY	ETF	136.69	136.69	136.68	136.68	300.0
2012-04-23 05:29:00	SPY	ETF	136.63	136.63	136.62	136.62	4300.0
2012-04-23 05:31:00	SPY	ETF	136.66	136.66	136.62	136.62	3100.0
2012-04-23 05:34:00	SPY	ETF	136.56	136.56	136.56	136.56	300.0
2012-04-23 05:35:00	SPY	ETF	136.56	136.56	136.56	136.56	30000.0
2012-04-23 05:37:00	SPY	ETF	136.61	136.61	136.61	136.61	100.0
2012-04-23 05:40:00	SPY	ETF	136.62	136.62	136.62	136.62	100.0
2012-04-23 05:49:00	SPY	ETF	136.66	136.66	136.66	136.66	16000.0
2012-04-23 05:55:00	SPY	ETF	136.66	136.66	136.66	136.66	200.0
2012-04-23 05:58:00	SPY	ETF	136.74	136.74	136.74	136.74	100.0
2012-04-23 05:59:00	SPY	ETF	136.78	136.78	136.74	136.74	1395.0
2012-04-23 06:00:00	SPY	ETF	136.73	136.74	136.72	136.72	20500.0
2012-04-23 06:03:00	SPY	ETF	136.7	136.7	136.7	136.7	100.0
2012-04-23 06:04:00	SPY	ETF	136.7	136.7	136.66	136.66	24700.0
2012-04-23 06:06:00	SPY	ETF	136.62	136.62	136.62	136.62	500.0
2012-04-23 06:07:00	SPY	ETF	136.67	136.67	136.66	136.66	15000.0
2012-04-23 06:08:00	SPY	ETF	136.67	136.71	136.67	136.71	1200.0
2012-04-23 06:12:00	SPY	ETF	136.76	136.76	136.76	136.76	195.0
2012-04-23 06:14:00	SPY	ETF	136.73	136.73	136.73	136.73	100.0
2012-04-23 06:18:00	SPY	ETF	136.72	136.72	136.72	136.72	300.0
2012-04-23 06:19:00	SPY	ETF	136.72	136.74	136.72	136.74	51000.0
2012-04-23 06:29:00	SPY	ETF	136.68	136.68	136.68	136.68	100.0
2012-04-23 06:30:00	SPY	ETF	136.66	136.66	136.66	136.66	100.0
2012-04-23 06:31:00	SPY	ETF	136.67	136.67	136.67	136.67	100.0
2012-04-23 06:33:00	SPY	ETF	136.64	136.64	136.64	136.64	495.0
2012-04-23 06:34:00	SPY	ETF	136.67	136.67	136.67	136.67	900.0
2012-04-23 06:38:00	SPY	ETF	136.67	136.67	136.67	136.67	100.0

> showing 50 of 105,299 rows — these rows as CSV

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