PREVIEW / etf_1min / 2011-07-28

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-07-28.parquet
  size:    2.1 MB
  rows:    108,208

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-07-28 04:00:00	SPY	ETF	130.77	130.87	130.77	130.87	300.0
2011-07-28 04:03:00	SPY	ETF	130.91	131.0	130.91	131.0	500.0
2011-07-28 04:28:00	SPY	ETF	130.95	130.95	130.95	130.95	562.0
2011-07-28 04:38:00	SPY	ETF	130.95	130.95	130.95	130.95	1438.0
2011-07-28 04:45:00	SPY	ETF	130.92	130.92	130.92	130.92	550.0
2011-07-28 05:05:00	SPY	ETF	130.62	130.62	130.62	130.62	1000.0
2011-07-28 05:10:00	SPY	ETF	130.8	130.8	130.8	130.8	500.0
2011-07-28 05:30:00	SPY	ETF	130.7	130.7	130.7	130.7	400.0
2011-07-28 05:32:00	SPY	ETF	130.66	130.66	130.6	130.6	500.0
2011-07-28 05:40:00	SPY	ETF	130.48	130.48	130.48	130.48	100.0
2011-07-28 05:42:00	SPY	ETF	130.48	130.48	130.48	130.48	200.0
2011-07-28 05:43:00	SPY	ETF	130.48	130.48	130.48	130.48	700.0
2011-07-28 05:44:00	SPY	ETF	130.4	130.4	130.4	130.4	200.0
2011-07-28 06:02:00	SPY	ETF	130.3	130.3	130.3	130.3	960.0
2011-07-28 06:08:00	SPY	ETF	130.44	130.44	130.44	130.44	100.0
2011-07-28 06:16:00	SPY	ETF	130.3	130.3	130.3	130.3	150.0
2011-07-28 06:18:00	SPY	ETF	130.3	130.3	130.28	130.28	221.0
2011-07-28 06:20:00	SPY	ETF	130.28	130.28	130.28	130.28	500.0
2011-07-28 06:22:00	SPY	ETF	130.3	130.3	130.3	130.3	100.0
2011-07-28 06:25:00	SPY	ETF	130.33	130.33	130.3	130.3	900.0
2011-07-28 06:29:00	SPY	ETF	130.18	130.18	130.11	130.11	1190.0
2011-07-28 06:30:00	SPY	ETF	130.11	130.11	130.11	130.11	200.0
2011-07-28 06:36:00	SPY	ETF	130.36	130.36	130.22	130.22	1100.0
2011-07-28 06:38:00	SPY	ETF	130.37	130.37	130.37	130.37	200.0
2011-07-28 06:39:00	SPY	ETF	130.37	130.37	130.37	130.37	100.0
2011-07-28 06:52:00	SPY	ETF	130.43	130.43	130.43	130.43	5000.0
2011-07-28 06:53:00	SPY	ETF	130.49	130.5	130.49	130.5	700.0
2011-07-28 06:54:00	SPY	ETF	130.47	130.55	130.47	130.55	4700.0
2011-07-28 06:55:00	SPY	ETF	130.55	130.62	130.55	130.62	4450.0
2011-07-28 06:57:00	SPY	ETF	130.69	130.7	130.69	130.7	50000.0
2011-07-28 06:58:00	SPY	ETF	130.7	130.7	130.65	130.65	31500.0
2011-07-28 06:59:00	SPY	ETF	130.63	130.63	130.6	130.6	21600.0
2011-07-28 07:00:00	SPY	ETF	130.64	130.65	130.61	130.61	25299.0
2011-07-28 07:01:00	SPY	ETF	130.61	130.62	130.58	130.6	2350.0
2011-07-28 07:02:00	SPY	ETF	130.65	130.65	130.65	130.65	1300.0
2011-07-28 07:03:00	SPY	ETF	130.62	130.62	130.59	130.59	2400.0
2011-07-28 07:04:00	SPY	ETF	130.6	130.6	130.6	130.6	900.0
2011-07-28 07:05:00	SPY	ETF	130.56	130.57	130.56	130.57	2600.0
2011-07-28 07:06:00	SPY	ETF	130.55	130.55	130.54	130.54	1480.0
2011-07-28 07:07:00	SPY	ETF	130.53	130.57	130.52	130.57	3350.0
2011-07-28 07:08:00	SPY	ETF	130.54	130.54	130.54	130.54	700.0
2011-07-28 07:10:00	SPY	ETF	130.51	130.51	130.51	130.51	500.0
2011-07-28 07:13:00	SPY	ETF	130.51	130.52	130.51	130.52	3000.0
2011-07-28 07:14:00	SPY	ETF	130.52	130.52	130.48	130.48	2300.0
2011-07-28 07:15:00	SPY	ETF	130.52	130.55	130.52	130.55	7900.0
2011-07-28 07:16:00	SPY	ETF	130.52	130.52	130.5	130.5	400.0
2011-07-28 07:17:00	SPY	ETF	130.49	130.5	130.48	130.5	7000.0
2011-07-28 07:18:00	SPY	ETF	130.48	130.48	130.48	130.48	100.0
2011-07-28 07:19:00	SPY	ETF	130.5	130.5	130.48	130.48	1900.0
2011-07-28 07:20:00	SPY	ETF	130.48	130.48	130.47	130.47	11100.0

> showing 50 of 108,208 rows — these rows as CSV

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