PREVIEW / etf_1hour / 2013-03-21

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-21.parquet
  size:    198 KB
  rows:    6,173

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-03-21 04:00:00	SPY	ETF	155.4	155.42	155.02	155.02	44181.0
2013-03-21 05:00:00	SPY	ETF	155.24	155.24	155.11	155.15	6800.0
2013-03-21 06:00:00	SPY	ETF	155.09	155.21	155.0	155.21	12650.0
2013-03-21 07:00:00	SPY	ETF	155.21	155.39	155.2	155.31	359760.0
2013-03-21 08:00:00	SPY	ETF	155.31	155.44	155.14	155.18	834116.0
2013-03-21 09:00:00	SPY	ETF	155.16	155.26	154.7	155.12	12560450.0
2013-03-21 10:00:00	SPY	ETF	155.12	155.2	154.57	154.86	17779053.0
2013-03-21 11:00:00	SPY	ETF	154.87	155.31	154.68	155.16	13338852.0
2013-03-21 12:00:00	SPY	ETF	155.16	155.22	154.93	155.002	9761767.0
2013-03-21 13:00:00	SPY	ETF	155.0	155.095	154.45	154.552	18025154.0
2013-03-21 14:00:00	SPY	ETF	154.55	154.77	154.1	154.6829	20021534.0
2013-03-21 15:00:00	SPY	ETF	154.688	155.6389	154.33	154.36	26559038.0
2013-03-21 16:00:00	SPY	ETF	154.36	154.86	154.3	154.37	6248929.0
2013-03-21 17:00:00	SPY	ETF	154.4	154.41	154.29	154.31	131114.0
2013-03-21 18:00:00	SPY	ETF	154.31	154.31	154.21	154.22	117371.0
2013-03-21 19:00:00	SPY	ETF	154.25	154.34	154.23	154.34	63147.0
2013-03-21 04:00:00	QQQ	ETF	68.35	68.4	68.15	68.15	6240.0
2013-03-21 05:00:00	QQQ	ETF	68.19	68.19	68.19	68.19	200.0
2013-03-21 06:00:00	QQQ	ETF	68.16	68.24	68.16	68.23	16500.0
2013-03-21 07:00:00	QQQ	ETF	68.25	68.34	68.25	68.3	53500.0
2013-03-21 08:00:00	QQQ	ETF	68.32	68.32	68.17	68.19	184367.0
2013-03-21 09:00:00	QQQ	ETF	68.18	68.23	68.04	68.19	3975150.0
2013-03-21 10:00:00	QQQ	ETF	68.2	68.2199	67.92	68.02	4799433.0
2013-03-21 11:00:00	QQQ	ETF	68.0201	68.22	67.95	68.17	2422143.0
2013-03-21 12:00:00	QQQ	ETF	68.165	68.25	68.07	68.19	2482990.0
2013-03-21 13:00:00	QQQ	ETF	68.19	68.24	67.9441	67.992	3386572.0
2013-03-21 14:00:00	QQQ	ETF	68.0	68.065	67.77	68.04	3871845.0
2013-03-21 15:00:00	QQQ	ETF	68.04	68.13	67.91	67.92	5525540.0
2013-03-21 16:00:00	QQQ	ETF	67.93	68.07	67.91	67.97	2350519.0
2013-03-21 17:00:00	QQQ	ETF	68.0	68.01	67.97	67.97	12700.0
2013-03-21 18:00:00	QQQ	ETF	67.97	67.97	67.92	67.93	46300.0
2013-03-21 19:00:00	QQQ	ETF	67.93	67.95	67.93	67.95	2100.0
2013-03-21 07:00:00	IWM	ETF	94.27	94.32	94.25	94.32	48100.0
2013-03-21 08:00:00	IWM	ETF	94.27	94.32	94.215	94.22	149697.0
2013-03-21 09:00:00	IWM	ETF	94.21	94.7	93.98	94.44	5026599.0
2013-03-21 10:00:00	IWM	ETF	94.43	94.47	93.99	94.12	5070310.0
2013-03-21 11:00:00	IWM	ETF	94.12	94.357	94.01	94.2684	2497323.0
2013-03-21 12:00:00	IWM	ETF	94.27	94.31	94.145	94.179	1250521.0
2013-03-21 13:00:00	IWM	ETF	94.17	94.21	93.74	93.87	4080928.0
2013-03-21 14:00:00	IWM	ETF	93.86	94.11	93.5401	94.05	4549615.0
2013-03-21 15:00:00	IWM	ETF	94.055	94.16	93.88	93.88	4663475.0
2013-03-21 16:00:00	IWM	ETF	93.88	93.94	93.84	93.9	2855345.0
2013-03-21 17:00:00	IWM	ETF	93.9	93.91	93.84	93.85	34020.0
2013-03-21 18:00:00	IWM	ETF	93.85	93.85	93.85	93.85	709.0
2013-03-21 19:00:00	IWM	ETF	93.82	93.85	93.82	93.85	2500.0
2013-03-21 04:00:00	DIA	ETF	144.65	144.65	144.65	144.65	100.0
2013-03-21 05:00:00	DIA	ETF	144.43	144.5	144.43	144.5	4600.0
2013-03-21 06:00:00	DIA	ETF	144.45	144.45	144.45	144.45	200.0
2013-03-21 07:00:00	DIA	ETF	144.64	144.64	144.62	144.62	3500.0
2013-03-21 08:00:00	DIA	ETF	144.63	144.74	144.52	144.52	7242.0

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

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