PREVIEW / etf_1hour / 2013-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-20.parquet
  size:    195 KB
  rows:    6,186

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-20 04:00:00	SPY	ETF	154.7	155.24	154.7	155.14	25344.0
2013-03-20 05:00:00	SPY	ETF	155.18	155.24	155.06	155.14	16000.0
2013-03-20 06:00:00	SPY	ETF	155.11	155.34	155.06	155.14	72275.0
2013-03-20 07:00:00	SPY	ETF	155.09	155.19	154.93	154.97	609704.0
2013-03-20 08:00:00	SPY	ETF	154.95	155.66	154.65	155.45	3663488.0
2013-03-20 09:00:00	SPY	ETF	155.45	155.72	155.37	155.42	15505262.0
2013-03-20 10:00:00	SPY	ETF	155.42	155.64	155.26	155.55	16260832.0
2013-03-20 11:00:00	SPY	ETF	155.55	155.58	155.32	155.35	10147773.0
2013-03-20 12:00:00	SPY	ETF	155.36	155.55	155.32	155.47	7492380.0
2013-03-20 13:00:00	SPY	ETF	155.47	155.53	155.32	155.37	6439124.0
2013-03-20 14:00:00	SPY	ETF	155.37	155.94	155.3	155.685	20920245.0
2013-03-20 15:00:00	SPY	ETF	155.685	155.95	155.47	155.65	20948874.0
2013-03-20 16:00:00	SPY	ETF	155.64	155.69	154.6015	155.42	10269202.0
2013-03-20 17:00:00	SPY	ETF	155.42	155.47	155.38	155.38	89001.0
2013-03-20 18:00:00	SPY	ETF	155.38	155.43	155.24	155.4	100579.0
2013-03-20 19:00:00	SPY	ETF	155.4	155.41	155.32	155.37	30050.0
2013-03-20 04:00:00	QQQ	ETF	68.5	68.55	68.5	68.55	500.0
2013-03-20 05:00:00	QQQ	ETF	68.56	68.61	68.56	68.6	800.0
2013-03-20 06:00:00	QQQ	ETF	68.6	68.65	68.54	68.55	7320.0
2013-03-20 07:00:00	QQQ	ETF	68.56	68.57	68.5	68.52	56890.0
2013-03-20 08:00:00	QQQ	ETF	68.5	68.78	68.5	68.72	236088.0
2013-03-20 09:00:00	QQQ	ETF	68.74	68.86	68.54	68.58	4083597.0
2013-03-20 10:00:00	QQQ	ETF	68.58	68.715	68.44	68.57	4807819.0
2013-03-20 11:00:00	QQQ	ETF	68.575	68.59	68.39	68.4	1902480.0
2013-03-20 12:00:00	QQQ	ETF	68.405	68.6178	68.39	68.584	2111036.0
2013-03-20 13:00:00	QQQ	ETF	68.58	68.62	68.5337	68.544	992346.0
2013-03-20 14:00:00	QQQ	ETF	68.54	68.79	68.52	68.7	4350792.0
2013-03-20 15:00:00	QQQ	ETF	68.7	68.81	68.6	68.68	4109668.0
2013-03-20 16:00:00	QQQ	ETF	68.68	68.71	68.32	68.41	2096635.0
2013-03-20 17:00:00	QQQ	ETF	68.4	68.47	68.4	68.44	176900.0
2013-03-20 18:00:00	QQQ	ETF	68.37	68.39	68.35	68.39	28575.0
2013-03-20 19:00:00	QQQ	ETF	68.4	68.4	68.36	68.38	19250.0
2013-03-20 04:00:00	IWM	ETF	93.95	94.12	93.95	94.12	1100.0
2013-03-20 07:00:00	IWM	ETF	94.17	94.21	94.06	94.14	70900.0
2013-03-20 08:00:00	IWM	ETF	94.12	94.44	94.11	94.35	574639.0
2013-03-20 09:00:00	IWM	ETF	94.35	94.66	94.31	94.37	4755351.0
2013-03-20 10:00:00	IWM	ETF	94.37	94.52	94.29	94.48	3169126.0
2013-03-20 11:00:00	IWM	ETF	94.48	94.54	94.26	94.28	1710465.0
2013-03-20 12:00:00	IWM	ETF	94.28	94.45	94.28	94.4	1306002.0
2013-03-20 13:00:00	IWM	ETF	94.39	94.43	94.33	94.37	1905087.0
2013-03-20 14:00:00	IWM	ETF	94.36	94.69	94.2887	94.595	4296542.0
2013-03-20 15:00:00	IWM	ETF	94.59	94.74	94.48	94.69	5382944.0
2013-03-20 16:00:00	IWM	ETF	94.69	94.7266	94.27	94.41	1407809.0
2013-03-20 17:00:00	IWM	ETF	94.43	94.71	94.43	94.45	22205.0
2013-03-20 19:00:00	IWM	ETF	94.46	94.46	94.38	94.38	3049.0
2013-03-20 07:00:00	DIA	ETF	144.62	144.63	144.58	144.63	10600.0
2013-03-20 08:00:00	DIA	ETF	144.72	145.08	144.72	144.96	29000.0
2013-03-20 09:00:00	DIA	ETF	144.94	145.12	144.83	144.96	936291.0
2013-03-20 10:00:00	DIA	ETF	144.96	145.1201	144.78	145.0	914019.0
2013-03-20 11:00:00	DIA	ETF	145.0	145.0	144.74	144.78	429544.0

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

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