PREVIEW / etf_1hour / 2012-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-13.parquet
  size:    188 KB
  rows:    5,834

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-11-13 04:00:00	SPY	ETF	137.4	137.76	137.4	137.7	410804.0
2012-11-13 05:00:00	SPY	ETF	137.6	137.6	137.44	137.46	66525.0
2012-11-13 06:00:00	SPY	ETF	137.45	137.9	137.24	137.89	244916.0
2012-11-13 07:00:00	SPY	ETF	137.89	138.14	137.67	137.74	743658.0
2012-11-13 08:00:00	SPY	ETF	137.77	137.93	137.6	137.65	618716.0
2012-11-13 09:00:00	SPY	ETF	137.65	138.43	137.36	138.33	19784694.0
2012-11-13 10:00:00	SPY	ETF	138.34	139.09	138.07	139.06	22567726.0
2012-11-13 11:00:00	SPY	ETF	139.06	139.25	138.85	139.02	12280031.0
2012-11-13 12:00:00	SPY	ETF	139.03	139.07	138.51	138.635	10072748.0
2012-11-13 13:00:00	SPY	ETF	138.635	138.97	138.5	138.92	9166298.0
2012-11-13 14:00:00	SPY	ETF	138.92	139.005	138.45	138.6	11540075.0
2012-11-13 15:00:00	SPY	ETF	138.605	138.7001	137.73	137.83	25701024.0
2012-11-13 16:00:00	SPY	ETF	137.82	138.514	137.6164	138.14	8906770.0
2012-11-13 17:00:00	SPY	ETF	138.13	138.14	137.7	138.12	129430.0
2012-11-13 18:00:00	SPY	ETF	138.11	138.11	137.89	137.95	138179.0
2012-11-13 19:00:00	SPY	ETF	137.95	138.1	137.95	138.08	61039.0
2012-11-13 04:00:00	QQQ	ETF	63.06	63.11	63.06	63.11	807.0
2012-11-13 05:00:00	QQQ	ETF	63.04	63.05	62.98	63.04	2200.0
2012-11-13 06:00:00	QQQ	ETF	62.98	63.19	62.97	63.15	3600.0
2012-11-13 07:00:00	QQQ	ETF	63.2	63.25	63.06	63.06	24388.0
2012-11-13 08:00:00	QQQ	ETF	63.05	63.09	62.97	62.98	166418.0
2012-11-13 09:00:00	QQQ	ETF	62.98	63.35	62.7801	63.3	6064175.0
2012-11-13 10:00:00	QQQ	ETF	63.31	63.5	63.13	63.4769	6472754.0
2012-11-13 11:00:00	QQQ	ETF	63.47	63.58	63.39	63.54	4053149.0
2012-11-13 12:00:00	QQQ	ETF	63.54	63.5599	63.26	63.31	2429348.0
2012-11-13 13:00:00	QQQ	ETF	63.31	63.49	63.25	63.47	2590655.0
2012-11-13 14:00:00	QQQ	ETF	63.48	63.5	63.24	63.34	3730619.0
2012-11-13 15:00:00	QQQ	ETF	63.34	63.39	62.93	62.99	7224946.0
2012-11-13 16:00:00	QQQ	ETF	62.99	63.4763	62.9386	63.29	6102515.0
2012-11-13 17:00:00	QQQ	ETF	63.3	63.33	63.28	63.31	144645.0
2012-11-13 18:00:00	QQQ	ETF	63.29	63.29	63.22	63.22	14810.0
2012-11-13 19:00:00	QQQ	ETF	63.23	63.3	63.23	63.28	35050.0
2012-11-13 05:00:00	IWM	ETF	78.82	78.82	78.7	78.75	1200.0
2012-11-13 06:00:00	IWM	ETF	79.05	79.05	78.84	78.99	9000.0
2012-11-13 07:00:00	IWM	ETF	79.09	79.09	78.95	79.02	58700.0
2012-11-13 08:00:00	IWM	ETF	78.96	79.01	78.8	78.8	112260.0
2012-11-13 09:00:00	IWM	ETF	78.8	79.33	78.58	79.29	4527270.0
2012-11-13 10:00:00	IWM	ETF	79.3	79.43	78.855	79.39	6106208.0
2012-11-13 11:00:00	IWM	ETF	79.39	79.56	79.2	79.33	3188035.0
2012-11-13 12:00:00	IWM	ETF	79.33	79.35	79.01	79.13	2206810.0
2012-11-13 13:00:00	IWM	ETF	79.13	79.315	79.06	79.29	2224580.0
2012-11-13 14:00:00	IWM	ETF	79.29	79.33	79.03	79.11	2487920.0
2012-11-13 15:00:00	IWM	ETF	79.11	79.17	78.68	78.77	7401066.0
2012-11-13 16:00:00	IWM	ETF	78.77	79.2227	78.65	78.91	2038913.0
2012-11-13 17:00:00	IWM	ETF	78.92	78.92	78.73	78.91	22480.0
2012-11-13 18:00:00	IWM	ETF	78.89	78.89	78.89	78.89	100.0
2012-11-13 19:00:00	IWM	ETF	78.9	79.0	78.9	78.99	15689.0
2012-11-13 04:00:00	DIA	ETF	127.32	127.32	127.32	127.32	100.0
2012-11-13 05:00:00	DIA	ETF	127.5	127.5	127.35	127.35	200.0
2012-11-13 06:00:00	DIA	ETF	127.62	127.63	127.62	127.63	10000.0

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

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