PREVIEW / etf_1hour / 2013-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-15.parquet
  size:    214 KB
  rows:    6,678

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-04-15 04:00:00	SPY	ETF	158.25	158.25	157.62	157.79	31150.0
2013-04-15 05:00:00	SPY	ETF	157.93	158.09	157.65	157.72	60089.0
2013-04-15 06:00:00	SPY	ETF	157.73	157.91	157.61	157.76	185209.0
2013-04-15 07:00:00	SPY	ETF	157.73	157.93	157.66	157.92	253732.0
2013-04-15 08:00:00	SPY	ETF	157.94	158.37	157.69	158.02	1504663.0
2013-04-15 09:00:00	SPY	ETF	158.02	158.15	157.6	158.01	15137444.0
2013-04-15 10:00:00	SPY	ETF	158.01	158.03	157.46	157.93	24126076.0
2013-04-15 11:00:00	SPY	ETF	157.93	157.93	157.11	157.18	18167907.0
2013-04-15 12:00:00	SPY	ETF	157.18	157.29	156.33	156.609	21393658.0
2013-04-15 13:00:00	SPY	ETF	156.6	156.76	156.46	156.5	14263701.0
2013-04-15 14:00:00	SPY	ETF	156.5	156.77	155.95	156.03	26481495.0
2013-04-15 15:00:00	SPY	ETF	156.03	156.28	155.1	155.1	72590943.0
2013-04-15 16:00:00	SPY	ETF	155.14	158.8294	154.32	154.65	16878665.0
2013-04-15 17:00:00	SPY	ETF	154.65	154.86	154.54	154.7	839848.0
2013-04-15 18:00:00	SPY	ETF	154.7	155.09	154.7	155.04	598108.0
2013-04-15 19:00:00	SPY	ETF	155.07	155.27	155.07	155.24	450525.0
2013-04-15 04:00:00	QQQ	ETF	69.54	69.54	69.54	69.54	200.0
2013-04-15 05:00:00	QQQ	ETF	69.5	69.5	69.5	69.5	100.0
2013-04-15 06:00:00	QQQ	ETF	69.5	69.59	69.5	69.54	4500.0
2013-04-15 07:00:00	QQQ	ETF	69.5	69.58	69.5	69.58	44220.0
2013-04-15 08:00:00	QQQ	ETF	69.58	69.69	69.47	69.64	134444.0
2013-04-15 09:00:00	QQQ	ETF	69.64	69.79	69.5	69.66	4926193.0
2013-04-15 10:00:00	QQQ	ETF	69.66	69.75	69.39	69.68	5999620.0
2013-04-15 11:00:00	QQQ	ETF	69.68	69.7	69.26	69.3	5066064.0
2013-04-15 12:00:00	QQQ	ETF	69.31	69.37	68.91	69.05	5506031.0
2013-04-15 13:00:00	QQQ	ETF	69.0599	69.15	69.0	69.03	2241652.0
2013-04-15 14:00:00	QQQ	ETF	69.03	69.16	68.74	68.785	5729413.0
2013-04-15 15:00:00	QQQ	ETF	68.78	68.84	68.48	68.54	14409611.0
2013-04-15 16:00:00	QQQ	ETF	68.54	68.692	67.97	68.37	3177702.0
2013-04-15 17:00:00	QQQ	ETF	69.94	69.94	68.3	68.34	110908.0
2013-04-15 18:00:00	QQQ	ETF	68.35	68.59	68.34	68.54	316002.0
2013-04-15 19:00:00	QQQ	ETF	68.57	68.67	68.57	68.64	27124.0
2013-04-15 07:00:00	IWM	ETF	92.88	92.97	92.86	92.96	74996.0
2013-04-15 08:00:00	IWM	ETF	92.95	93.18	92.93	93.02	417920.0
2013-04-15 09:00:00	IWM	ETF	93.04	93.15	92.67	92.84	3854931.0
2013-04-15 10:00:00	IWM	ETF	92.84	92.86	91.93	92.24	12656366.0
2013-04-15 11:00:00	IWM	ETF	92.24	92.24	91.28	91.37	8471569.0
2013-04-15 12:00:00	IWM	ETF	91.38	91.4	90.74	90.96	8891053.0
2013-04-15 13:00:00	IWM	ETF	90.96	91.11	90.8651	90.95	3433039.0
2013-04-15 14:00:00	IWM	ETF	90.9506	91.02	90.28	90.37	9725453.0
2013-04-15 15:00:00	IWM	ETF	90.37	90.378	89.79	90.12	21876093.0
2013-04-15 16:00:00	IWM	ETF	90.11	93.6283	89.25	89.62	7002462.0
2013-04-15 17:00:00	IWM	ETF	89.56	89.85	89.52	89.85	12000.0
2013-04-15 18:00:00	IWM	ETF	89.85	90.0	89.85	89.94	16232.0
2013-04-15 19:00:00	IWM	ETF	90.0	90.15	90.0	90.15	9464.0
2013-04-15 04:00:00	DIA	ETF	147.74	147.74	147.74	147.74	100.0
2013-04-15 07:00:00	DIA	ETF	147.71	147.71	147.63	147.66	3600.0
2013-04-15 08:00:00	DIA	ETF	147.79	148.01	147.79	147.97	9775.0
2013-04-15 09:00:00	DIA	ETF	147.85	148.06	147.49	147.81	1381685.0
2013-04-15 10:00:00	DIA	ETF	147.77	147.819	147.29	147.79	1323654.0

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

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