PREVIEW / etf_1min / 2011-08-09

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-08-09.parquet
  size:    3.0 MB
  rows:    151,068

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-08-09 04:00:00	SPY	ETF	111.6	111.82	111.6	111.82	1500.0
2011-08-09 04:01:00	SPY	ETF	111.94	111.94	111.94	111.94	200.0
2011-08-09 04:02:00	SPY	ETF	111.98	112.15	111.98	112.15	1197.0
2011-08-09 04:03:00	SPY	ETF	112.23	112.23	112.23	112.23	350.0
2011-08-09 04:04:00	SPY	ETF	112.24	112.24	112.2	112.2	1582.0
2011-08-09 04:05:00	SPY	ETF	112.2	112.2	112.18	112.18	1600.0
2011-08-09 04:06:00	SPY	ETF	112.37	112.39	112.37	112.39	300.0
2011-08-09 04:07:00	SPY	ETF	112.49	112.69	112.49	112.69	1700.0
2011-08-09 04:08:00	SPY	ETF	112.74	112.74	112.74	112.74	800.0
2011-08-09 04:09:00	SPY	ETF	112.79	112.89	112.79	112.89	500.0
2011-08-09 04:10:00	SPY	ETF	112.98	113.09	112.98	113.09	2100.0
2011-08-09 04:11:00	SPY	ETF	112.81	112.81	112.66	112.66	1000.0
2011-08-09 04:12:00	SPY	ETF	112.75	112.77	112.75	112.77	200.0
2011-08-09 04:17:00	SPY	ETF	112.48	112.48	112.4	112.4	200.0
2011-08-09 04:19:00	SPY	ETF	112.55	112.65	112.55	112.65	700.0
2011-08-09 04:21:00	SPY	ETF	111.91	111.91	111.89	111.89	2000.0
2011-08-09 04:22:00	SPY	ETF	111.84	111.84	111.83	111.83	200.0
2011-08-09 04:23:00	SPY	ETF	112.23	112.23	112.23	112.23	100.0
2011-08-09 04:24:00	SPY	ETF	112.21	112.21	112.21	112.21	301.0
2011-08-09 04:29:00	SPY	ETF	112.5	112.5	112.5	112.5	100.0
2011-08-09 04:30:00	SPY	ETF	112.25	112.27	112.05	112.05	7000.0
2011-08-09 04:31:00	SPY	ETF	111.95	111.95	111.33	111.33	5400.0
2011-08-09 04:32:00	SPY	ETF	111.17	111.17	110.97	110.97	2901.0
2011-08-09 04:33:00	SPY	ETF	110.95	110.95	110.75	110.75	3200.0
2011-08-09 04:34:00	SPY	ETF	110.76	110.76	110.66	110.66	400.0
2011-08-09 04:35:00	SPY	ETF	110.84	111.15	110.84	111.15	2120.0
2011-08-09 04:36:00	SPY	ETF	111.3	111.34	111.27	111.27	1224.0
2011-08-09 04:37:00	SPY	ETF	111.19	111.19	111.19	111.19	100.0
2011-08-09 04:38:00	SPY	ETF	111.3	111.41	111.3	111.41	1100.0
2011-08-09 04:39:00	SPY	ETF	111.25	111.25	111.25	111.25	148.0
2011-08-09 04:42:00	SPY	ETF	111.26	111.39	111.26	111.39	2600.0
2011-08-09 04:43:00	SPY	ETF	111.34	111.35	111.34	111.35	700.0
2011-08-09 04:46:00	SPY	ETF	111.47	111.47	111.42	111.42	3000.0
2011-08-09 04:47:00	SPY	ETF	111.7	111.92	111.7	111.92	6200.0
2011-08-09 04:48:00	SPY	ETF	111.54	111.54	111.54	111.54	100.0
2011-08-09 04:49:00	SPY	ETF	111.55	111.55	111.19	111.19	3600.0
2011-08-09 04:53:00	SPY	ETF	111.46	111.52	111.46	111.52	1300.0
2011-08-09 04:55:00	SPY	ETF	111.65	111.65	111.65	111.65	500.0
2011-08-09 04:56:00	SPY	ETF	111.7	111.94	111.7	111.94	6200.0
2011-08-09 04:57:00	SPY	ETF	111.94	111.99	111.93	111.99	500.0
2011-08-09 04:58:00	SPY	ETF	111.72	111.77	111.72	111.77	1000.0
2011-08-09 05:00:00	SPY	ETF	111.6	111.6	111.6	111.6	100.0
2011-08-09 05:01:00	SPY	ETF	111.49	111.49	111.33	111.36	4500.0
2011-08-09 05:02:00	SPY	ETF	110.72	110.72	110.72	110.72	500.0
2011-08-09 05:03:00	SPY	ETF	110.5	110.5	110.39	110.5	1502.0
2011-08-09 05:04:00	SPY	ETF	110.52	110.52	110.52	110.52	100.0
2011-08-09 05:07:00	SPY	ETF	110.65	110.65	110.65	110.65	500.0
2011-08-09 05:09:00	SPY	ETF	111.0	111.0	111.0	111.0	500.0
2011-08-09 05:11:00	SPY	ETF	110.83	110.83	110.83	110.83	2000.0
2011-08-09 05:12:00	SPY	ETF	110.79	110.79	110.66	110.76	3100.0

> showing 50 of 151,068 rows — these rows as CSV

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