PREVIEW / etf_1hour / 2013-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-28.parquet
  size:    209 KB
  rows:    6,606

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
2013-05-28 04:00:00	SPY	ETF	166.68	166.91	166.68	166.75	44267.0
2013-05-28 05:00:00	SPY	ETF	166.77	166.83	166.68	166.78	19555.0
2013-05-28 06:00:00	SPY	ETF	166.75	166.78	166.61	166.67	111490.0
2013-05-28 07:00:00	SPY	ETF	166.69	166.96	166.65	166.75	1201323.0
2013-05-28 08:00:00	SPY	ETF	166.72	166.99	166.67	166.95	1040537.0
2013-05-28 09:00:00	SPY	ETF	166.95	167.49	165.293	167.49	19204829.0
2013-05-28 10:00:00	SPY	ETF	167.48	167.78	167.25	167.321	20919800.0
2013-05-28 11:00:00	SPY	ETF	167.325	167.358	166.74	166.76	16861070.0
2013-05-28 12:00:00	SPY	ETF	166.76	166.99	166.71	166.85	8124391.0
2013-05-28 13:00:00	SPY	ETF	166.85	167.02	166.02	166.13	17971396.0
2013-05-28 14:00:00	SPY	ETF	166.13	166.35	165.81	166.22	17470029.0
2013-05-28 15:00:00	SPY	ETF	166.215	166.65	166.09	166.3	26790311.0
2013-05-28 16:00:00	SPY	ETF	166.32	166.4711	165.92	166.19	10490511.0
2013-05-28 17:00:00	SPY	ETF	166.2	166.2	165.98	165.98	657612.0
2013-05-28 18:00:00	SPY	ETF	165.98	166.0	165.8	165.94	240617.0
2013-05-28 19:00:00	SPY	ETF	165.94	166.06	165.94	166.03	52299.0
2013-05-28 04:00:00	QQQ	ETF	74.08	74.17	74.08	74.13	4930.0
2013-05-28 06:00:00	QQQ	ETF	74.12	74.12	74.06	74.08	3011.0
2013-05-28 07:00:00	QQQ	ETF	74.08	74.16	74.08	74.1	22164.0
2013-05-28 08:00:00	QQQ	ETF	74.08	74.2	74.06	74.13	173440.0
2013-05-28 09:00:00	QQQ	ETF	74.14	74.45	74.11	74.44	4003052.0
2013-05-28 10:00:00	QQQ	ETF	74.44	74.54	74.27	74.33	5204486.0
2013-05-28 11:00:00	QQQ	ETF	74.34	74.3894	74.09	74.1	3525514.0
2013-05-28 12:00:00	QQQ	ETF	74.101	74.19	74.02	74.11	2041389.0
2013-05-28 13:00:00	QQQ	ETF	74.115	74.19	73.73	73.78	3762329.0
2013-05-28 14:00:00	QQQ	ETF	73.77	73.93	73.66	73.875	2413347.0
2013-05-28 15:00:00	QQQ	ETF	73.871	74.06	73.82	73.9	4729051.0
2013-05-28 16:00:00	QQQ	ETF	73.89	74.4801	73.72	73.83	1119491.0
2013-05-28 17:00:00	QQQ	ETF	73.81	73.82	73.78	73.78	7679.0
2013-05-28 18:00:00	QQQ	ETF	73.76	73.77	73.69	73.74	14561.0
2013-05-28 19:00:00	QQQ	ETF	73.8	73.82	73.78	73.78	8425.0
2013-05-28 04:00:00	IWM	ETF	98.86	98.94	98.75	98.94	1179.0
2013-05-28 05:00:00	IWM	ETF	98.9	98.9	98.9	98.9	273.0
2013-05-28 06:00:00	IWM	ETF	98.95	98.95	98.95	98.95	100.0
2013-05-28 07:00:00	IWM	ETF	98.9	99.13	98.9	99.02	86465.0
2013-05-28 08:00:00	IWM	ETF	98.97	99.15	98.96	99.15	243117.0
2013-05-28 09:00:00	IWM	ETF	99.15	99.92	99.07	99.81	6947957.0
2013-05-28 10:00:00	IWM	ETF	99.81	100.095	99.78	99.82	6260817.0
2013-05-28 11:00:00	IWM	ETF	99.83	99.85	99.44	99.45	4431748.0
2013-05-28 12:00:00	IWM	ETF	99.4599	99.66	99.43	99.53	2067045.0
2013-05-28 13:00:00	IWM	ETF	99.52	99.59	98.8976	98.93	3768200.0
2013-05-28 14:00:00	IWM	ETF	98.92	98.95	98.4807	98.8701	4932777.0
2013-05-28 15:00:00	IWM	ETF	98.88	99.25	98.78	99.1801	6549314.0
2013-05-28 16:00:00	IWM	ETF	99.18	99.24	98.85	99.04	6261187.0
2013-05-28 17:00:00	IWM	ETF	99.0	99.01	99.0	99.0	1300.0
2013-05-28 18:00:00	IWM	ETF	98.92	99.0	98.84	98.96	12285.0
2013-05-28 19:00:00	IWM	ETF	99.02	99.02	98.99	98.99	600.0
2013-05-28 04:00:00	DIA	ETF	154.03	154.03	154.03	154.03	152.0
2013-05-28 05:00:00	DIA	ETF	153.94	153.94	153.94	153.94	2500.0
2013-05-28 06:00:00	DIA	ETF	153.91	153.91	153.87	153.87	5125.0

> showing 50 of 6,606 rows — these rows as CSV

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