PREVIEW / etf_1min / 2012-01-11

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-01-11.parquet
  size:    1.9 MB
  rows:    103,729

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-11 04:56:00	SPY	ETF	129.17	129.17	129.17	129.17	800.0
2012-01-11 04:59:00	SPY	ETF	129.21	129.22	129.21	129.22	1000.0
2012-01-11 05:29:00	SPY	ETF	129.1	129.1	129.1	129.1	1000.0
2012-01-11 05:52:00	SPY	ETF	129.07	129.07	129.07	129.07	400.0
2012-01-11 06:10:00	SPY	ETF	129.07	129.07	129.07	129.07	1500.0
2012-01-11 06:15:00	SPY	ETF	129.03	129.03	129.03	129.03	1500.0
2012-01-11 06:17:00	SPY	ETF	129.03	129.03	129.03	129.03	100.0
2012-01-11 06:22:00	SPY	ETF	128.87	128.87	128.83	128.83	850.0
2012-01-11 06:23:00	SPY	ETF	128.8	128.8	128.8	128.8	450.0
2012-01-11 06:26:00	SPY	ETF	128.8	128.8	128.8	128.8	1000.0
2012-01-11 06:29:00	SPY	ETF	128.76	128.76	128.76	128.76	100.0
2012-01-11 06:30:00	SPY	ETF	128.63	128.63	128.63	128.63	10000.0
2012-01-11 06:32:00	SPY	ETF	128.71	128.71	128.68	128.68	40000.0
2012-01-11 06:34:00	SPY	ETF	128.65	128.65	128.65	128.65	5000.0
2012-01-11 06:37:00	SPY	ETF	128.7	128.7	128.7	128.7	10000.0
2012-01-11 06:38:00	SPY	ETF	128.75	128.75	128.75	128.75	5000.0
2012-01-11 06:39:00	SPY	ETF	128.7	128.75	128.7	128.75	1600.0
2012-01-11 06:43:00	SPY	ETF	128.61	128.61	128.61	128.61	200.0
2012-01-11 06:44:00	SPY	ETF	128.63	128.63	128.63	128.63	100.0
2012-01-11 06:45:00	SPY	ETF	128.63	128.63	128.62	128.62	1200.0
2012-01-11 06:47:00	SPY	ETF	128.64	128.64	128.64	128.64	100.0
2012-01-11 06:48:00	SPY	ETF	128.64	128.64	128.64	128.64	5000.0
2012-01-11 06:49:00	SPY	ETF	128.66	128.66	128.66	128.66	10500.0
2012-01-11 06:59:00	SPY	ETF	128.62	128.65	128.62	128.65	850.0
2012-01-11 07:00:00	SPY	ETF	128.62	128.64	128.59	128.6	2800.0
2012-01-11 07:01:00	SPY	ETF	128.6	128.6	128.56	128.56	6800.0
2012-01-11 07:02:00	SPY	ETF	128.56	128.6	128.55	128.55	11165.0
2012-01-11 07:03:00	SPY	ETF	128.55	128.55	128.49	128.49	4120.0
2012-01-11 07:04:00	SPY	ETF	128.5	128.56	128.47	128.47	2200.0
2012-01-11 07:05:00	SPY	ETF	128.46	128.46	128.4	128.4	17950.0
2012-01-11 07:06:00	SPY	ETF	128.4	128.41	128.37	128.41	8437.0
2012-01-11 07:07:00	SPY	ETF	128.4	128.41	128.36	128.36	44000.0
2012-01-11 07:08:00	SPY	ETF	128.38	128.38	128.38	128.38	800.0
2012-01-11 07:09:00	SPY	ETF	128.41	128.42	128.41	128.41	12200.0
2012-01-11 07:10:00	SPY	ETF	128.48	128.52	128.48	128.49	4050.0
2012-01-11 07:11:00	SPY	ETF	128.53	128.53	128.53	128.53	5100.0
2012-01-11 07:12:00	SPY	ETF	128.52	128.52	128.51	128.51	1100.0
2012-01-11 07:14:00	SPY	ETF	128.53	128.53	128.53	128.53	20000.0
2012-01-11 07:15:00	SPY	ETF	128.53	128.55	128.53	128.53	9400.0
2012-01-11 07:16:00	SPY	ETF	128.55	128.55	128.55	128.55	100.0
2012-01-11 07:17:00	SPY	ETF	128.56	128.58	128.56	128.58	575.0
2012-01-11 07:18:00	SPY	ETF	128.58	128.59	128.56	128.59	6000.0
2012-01-11 07:19:00	SPY	ETF	128.6	128.6	128.55	128.55	3694.0
2012-01-11 07:20:00	SPY	ETF	128.57	128.63	128.57	128.63	18600.0
2012-01-11 07:21:00	SPY	ETF	128.59	128.59	128.59	128.59	200.0
2012-01-11 07:22:00	SPY	ETF	128.62	128.62	128.59	128.6	33700.0
2012-01-11 07:23:00	SPY	ETF	128.59	128.6	128.59	128.59	10100.0
2012-01-11 07:24:00	SPY	ETF	128.6	128.6	128.6	128.6	800.0
2012-01-11 07:25:00	SPY	ETF	128.6	128.62	128.6	128.62	9700.0
2012-01-11 07:26:00	SPY	ETF	128.63	128.64	128.61	128.63	12854.0

> showing 50 of 103,729 rows — these rows as CSV

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