PREVIEW / etf_1hour / 2012-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-31.parquet
  size:    191 KB
  rows:    5,970

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-10-31 04:00:00	SPY	ETF	141.95	142.31	141.94	142.2	103820.0
2012-10-31 05:00:00	SPY	ETF	142.2	142.31	142.17	142.29	85004.0
2012-10-31 06:00:00	SPY	ETF	142.29	142.35	142.205	142.23	227035.0
2012-10-31 07:00:00	SPY	ETF	142.22	142.28	142.09	142.14	187385.0
2012-10-31 08:00:00	SPY	ETF	142.14	142.26	140.55	141.98	1013427.0
2012-10-31 09:00:00	SPY	ETF	141.98	142.03	141.56	141.755	13714459.0
2012-10-31 10:00:00	SPY	ETF	141.75	141.83	141.17	141.26	13906225.0
2012-10-31 11:00:00	SPY	ETF	141.27	141.311	140.84	141.1	14843856.0
2012-10-31 12:00:00	SPY	ETF	141.09	141.11	140.68	140.97	11738836.0
2012-10-31 13:00:00	SPY	ETF	140.97	141.11	140.8	141.04	6715907.0
2012-10-31 14:00:00	SPY	ETF	141.05	141.3	141.03	141.09	6957752.0
2012-10-31 15:00:00	SPY	ETF	141.08	141.58	140.95	141.25	18794100.0
2012-10-31 16:00:00	SPY	ETF	141.24	141.3456	140.73	140.8	8368280.0
2012-10-31 17:00:00	SPY	ETF	140.8	140.84	140.73	140.8	168082.0
2012-10-31 18:00:00	SPY	ETF	140.79	141.1484	140.71	140.87	110913.0
2012-10-31 19:00:00	SPY	ETF	140.87	140.92	140.77	140.78	75914.0
2012-10-31 04:00:00	QQQ	ETF	65.5	65.72	65.5	65.72	1400.0
2012-10-31 05:00:00	QQQ	ETF	65.75	65.75	65.69	65.69	900.0
2012-10-31 06:00:00	QQQ	ETF	65.65	65.68	65.64	65.64	74900.0
2012-10-31 07:00:00	QQQ	ETF	65.635	65.635	65.55	65.56	108645.0
2012-10-31 08:00:00	QQQ	ETF	65.56	65.57	65.33	65.4	173497.0
2012-10-31 09:00:00	QQQ	ETF	65.39	65.44	65.1101	65.15	5893090.0
2012-10-31 10:00:00	QQQ	ETF	65.15	65.22	64.83	64.895	7452652.0
2012-10-31 11:00:00	QQQ	ETF	64.89	65.04	64.73	64.89	4215554.0
2012-10-31 12:00:00	QQQ	ETF	64.88	64.93	64.73	64.93	3285658.0
2012-10-31 13:00:00	QQQ	ETF	64.93	64.95	64.8	64.9	2168136.0
2012-10-31 14:00:00	QQQ	ETF	64.895	65.07	64.895	64.94	3503594.0
2012-10-31 15:00:00	QQQ	ETF	64.93	65.09	64.86	64.93	6446050.0
2012-10-31 16:00:00	QQQ	ETF	64.94	65.3796	64.72	64.75	3804826.0
2012-10-31 17:00:00	QQQ	ETF	64.76	65.3796	64.71	64.72	771250.0
2012-10-31 18:00:00	QQQ	ETF	64.74	64.9318	64.73	64.73	123600.0
2012-10-31 19:00:00	QQQ	ETF	64.78	64.78	64.73	64.76	7550.0
2012-10-31 04:00:00	IWM	ETF	81.45	81.45	81.43	81.45	5500.0
2012-10-31 05:00:00	IWM	ETF	81.35	81.54	81.27	81.54	6300.0
2012-10-31 06:00:00	IWM	ETF	81.48	81.48	81.31	81.31	4100.0
2012-10-31 07:00:00	IWM	ETF	81.23	81.26	81.18	81.21	24744.0
2012-10-31 08:00:00	IWM	ETF	81.22	81.22	81.12	81.18	56766.0
2012-10-31 09:00:00	IWM	ETF	81.19	81.62	80.96	81.27	4116064.0
2012-10-31 10:00:00	IWM	ETF	81.27	81.45	81.01	81.15	3672965.0
2012-10-31 11:00:00	IWM	ETF	81.15	81.3	80.95	81.1	2471049.0
2012-10-31 12:00:00	IWM	ETF	81.09	81.13	80.88	81.0	2145000.0
2012-10-31 13:00:00	IWM	ETF	80.99	81.115	80.89	81.05	1527946.0
2012-10-31 14:00:00	IWM	ETF	81.05	81.385	81.049	81.24	2610319.0
2012-10-31 15:00:00	IWM	ETF	81.25	81.65	81.16	81.52	4967673.0
2012-10-31 16:00:00	IWM	ETF	81.53	81.651	81.23	81.23	2255508.0
2012-10-31 17:00:00	IWM	ETF	81.23	81.23	81.2	81.2	18195.0
2012-10-31 18:00:00	IWM	ETF	81.273	81.273	81.273	81.273	25000.0
2012-10-31 19:00:00	IWM	ETF	81.29	81.37	81.29	81.37	1700.0
2012-10-31 07:00:00	DIA	ETF	131.4	131.4	131.4	131.4	100.0
2012-10-31 08:00:00	DIA	ETF	131.2	131.5	131.2	131.34	7672.0

> showing 50 of 5,970 rows — these rows as CSV

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