PREVIEW / etf_1hour / 2013-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-22.parquet
  size:    212 KB
  rows:    6,565

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-22 04:00:00	SPY	ETF	167.36	167.4	167.23	167.23	10865.0
2013-05-22 05:00:00	SPY	ETF	167.23	167.28	167.14	167.17	9781.0
2013-05-22 06:00:00	SPY	ETF	167.17	167.35	167.17	167.27	70150.0
2013-05-22 07:00:00	SPY	ETF	167.27	167.35	167.21	167.35	113670.0
2013-05-22 08:00:00	SPY	ETF	167.34	167.56	167.25	167.44	447618.0
2013-05-22 09:00:00	SPY	ETF	167.44	167.75	167.2965	167.74	11115166.0
2013-05-22 10:00:00	SPY	ETF	167.74	169.07	167.56	167.7	56264686.0
2013-05-22 11:00:00	SPY	ETF	167.71	168.67	167.56	168.33	21578908.0
2013-05-22 12:00:00	SPY	ETF	168.33	168.45	167.85	168.27	11984160.0
2013-05-22 13:00:00	SPY	ETF	168.24	168.28	166.81	167.09	21663757.0
2013-05-22 14:00:00	SPY	ETF	167.09	167.37	165.81	166.38	41369759.0
2013-05-22 15:00:00	SPY	ETF	166.3865	167.2171	165.17	165.85	56387198.0
2013-05-22 16:00:00	SPY	ETF	165.87	168.6948	165.7601	166.24	17953323.0
2013-05-22 17:00:00	SPY	ETF	166.24	166.3	166.2	166.26	303980.0
2013-05-22 18:00:00	SPY	ETF	166.27	166.39	166.17	166.18	253944.0
2013-05-22 19:00:00	SPY	ETF	166.18	166.3	166.14	166.27	108563.0
2013-05-22 04:00:00	QQQ	ETF	74.31	74.31	74.3	74.3	500.0
2013-05-22 05:00:00	QQQ	ETF	74.22	74.22	74.22	74.22	100.0
2013-05-22 06:00:00	QQQ	ETF	74.25	74.29	74.25	74.29	8500.0
2013-05-22 07:00:00	QQQ	ETF	74.27	74.32	74.27	74.3	9700.0
2013-05-22 08:00:00	QQQ	ETF	74.3	74.45	74.3	74.39	95132.0
2013-05-22 09:00:00	QQQ	ETF	74.41	74.54	74.23	74.5001	2859198.0
2013-05-22 10:00:00	QQQ	ETF	74.51	74.95	74.29	74.35	14779340.0
2013-05-22 11:00:00	QQQ	ETF	74.3477	74.76	74.27	74.6599	6087329.0
2013-05-22 12:00:00	QQQ	ETF	74.66	74.6941	74.405	74.54	2972570.0
2013-05-22 13:00:00	QQQ	ETF	74.55	74.55	73.9	74.06	5756471.0
2013-05-22 14:00:00	QQQ	ETF	74.05	74.18	73.48	73.7799	12411685.0
2013-05-22 15:00:00	QQQ	ETF	73.77	73.775	73.24	73.64	10524230.0
2013-05-22 16:00:00	QQQ	ETF	73.64	73.81	73.54	73.8	2527773.0
2013-05-22 17:00:00	QQQ	ETF	73.8	73.81	73.78	73.79	15195.0
2013-05-22 18:00:00	QQQ	ETF	73.79	73.84	73.77	73.77	16066.0
2013-05-22 19:00:00	QQQ	ETF	73.76	73.79	73.75	73.78	26300.0
2013-05-22 04:00:00	IWM	ETF	99.4	99.4	99.4	99.4	1500.0
2013-05-22 05:00:00	IWM	ETF	99.26	99.26	99.25	99.25	1300.0
2013-05-22 06:00:00	IWM	ETF	99.32	99.32	99.32	99.32	7100.0
2013-05-22 07:00:00	IWM	ETF	99.33	99.42	99.25	99.39	93050.0
2013-05-22 08:00:00	IWM	ETF	99.45	99.56	99.44	99.46	151049.0
2013-05-22 09:00:00	IWM	ETF	99.44	99.69	99.3	99.58	2957442.0
2013-05-22 10:00:00	IWM	ETF	99.58	100.38	99.57	99.85	15714236.0
2013-05-22 11:00:00	IWM	ETF	99.85	100.22	99.75	100.02	4260563.0
2013-05-22 12:00:00	IWM	ETF	100.02	100.1	99.56	99.86	3661906.0
2013-05-22 13:00:00	IWM	ETF	99.86	99.89	98.66	98.8266	7238617.0
2013-05-22 14:00:00	IWM	ETF	98.82	98.97	97.76	98.14	13191778.0
2013-05-22 15:00:00	IWM	ETF	98.1301	98.16	97.11	97.74	15738122.0
2013-05-22 16:00:00	IWM	ETF	97.73	99.1	97.73	98.07	1727808.0
2013-05-22 17:00:00	IWM	ETF	98.05	98.08	98.03	98.08	3766.0
2013-05-22 18:00:00	IWM	ETF	98.06	98.18	98.05	98.05	21122.0
2013-05-22 19:00:00	IWM	ETF	98.02	98.09	98.02	98.07	5549.0
2013-05-22 08:00:00	DIA	ETF	153.65	153.79	153.65	153.79	287.0
2013-05-22 09:00:00	DIA	ETF	153.73	154.04	153.63	153.99	570684.0

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

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