PREVIEW / etf_1hour / 2013-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-28.parquet
  size:    199 KB
  rows:    6,260

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-28 04:00:00	SPY	ETF	155.95	156.04	155.68	155.68	9830.0
2013-03-28 05:00:00	SPY	ETF	155.68	155.85	155.56	155.85	35677.0
2013-03-28 06:00:00	SPY	ETF	155.8	156.26	155.75	156.26	89322.0
2013-03-28 07:00:00	SPY	ETF	156.27	156.31	156.14	156.21	230133.0
2013-03-28 08:00:00	SPY	ETF	156.25	156.31	155.97	155.98	1646810.0
2013-03-28 09:00:00	SPY	ETF	155.98	156.37	155.75	156.15	15114031.0
2013-03-28 10:00:00	SPY	ETF	156.15	156.68	156.07	156.56	13550579.0
2013-03-28 11:00:00	SPY	ETF	156.56	156.69	156.44	156.52	10492215.0
2013-03-28 12:00:00	SPY	ETF	156.525	156.55	156.24	156.45	9065206.0
2013-03-28 13:00:00	SPY	ETF	156.445	156.48	156.33	156.44	4833907.0
2013-03-28 14:00:00	SPY	ETF	156.44	156.64	156.44	156.63	6404346.0
2013-03-28 15:00:00	SPY	ETF	156.63	156.85	156.44	156.58	26465126.0
2013-03-28 16:00:00	SPY	ETF	156.6	156.77	156.1107	156.75	12276173.0
2013-03-28 17:00:00	SPY	ETF	156.75	156.83	156.73	156.83	164420.0
2013-03-28 18:00:00	SPY	ETF	156.82	156.85	156.66	156.8	89967.0
2013-03-28 19:00:00	SPY	ETF	156.8	156.82	156.75	156.8	23301.0
2013-03-28 04:00:00	QQQ	ETF	68.74	68.79	68.74	68.79	2500.0
2013-03-28 05:00:00	QQQ	ETF	68.62	68.7	68.6	68.7	8295.0
2013-03-28 06:00:00	QQQ	ETF	68.75	68.86	68.75	68.86	9100.0
2013-03-28 07:00:00	QQQ	ETF	68.89	68.93	68.83	68.88	47257.0
2013-03-28 08:00:00	QQQ	ETF	68.91	68.92	68.79	68.8	1336680.0
2013-03-28 09:00:00	QQQ	ETF	68.79	68.86	68.64	68.79	4763714.0
2013-03-28 10:00:00	QQQ	ETF	68.79	68.94	68.71	68.89	3061548.0
2013-03-28 11:00:00	QQQ	ETF	68.89	68.93	68.82	68.86	1850242.0
2013-03-28 12:00:00	QQQ	ETF	68.85	68.87	68.75	68.84	1773168.0
2013-03-28 13:00:00	QQQ	ETF	68.84	68.88	68.785	68.85	631624.0
2013-03-28 14:00:00	QQQ	ETF	68.85	68.92	68.84	68.9199	1463932.0
2013-03-28 15:00:00	QQQ	ETF	68.92	69.06	68.84	68.98	6096513.0
2013-03-28 16:00:00	QQQ	ETF	68.98	69.03	68.9	69.03	1776056.0
2013-03-28 17:00:00	QQQ	ETF	69.01	69.04	69.01	69.01	205151.0
2013-03-28 18:00:00	QQQ	ETF	69.02	69.06	69.01	69.01	3625.0
2013-03-28 19:00:00	QQQ	ETF	69.05	69.07	68.97	69.07	6066.0
2013-03-28 06:00:00	IWM	ETF	94.37	94.39	94.36	94.36	1032.0
2013-03-28 07:00:00	IWM	ETF	94.42	94.45	94.35	94.35	52400.0
2013-03-28 08:00:00	IWM	ETF	94.35	94.47	94.23	94.23	683572.0
2013-03-28 09:00:00	IWM	ETF	94.23	94.58	94.14	94.29	2958616.0
2013-03-28 10:00:00	IWM	ETF	94.28	94.5	94.16	94.45	1792134.0
2013-03-28 11:00:00	IWM	ETF	94.442	94.48	94.31	94.3825	2394006.0
2013-03-28 12:00:00	IWM	ETF	94.37	94.3999	94.16	94.28	2039028.0
2013-03-28 13:00:00	IWM	ETF	94.28	94.45	94.231	94.45	1240115.0
2013-03-28 14:00:00	IWM	ETF	94.45	94.49	94.41	94.441	1729263.0
2013-03-28 15:00:00	IWM	ETF	94.44	94.66	94.33	94.36	7479333.0
2013-03-28 16:00:00	IWM	ETF	94.36	94.4678	94.26	94.38	1539259.0
2013-03-28 17:00:00	IWM	ETF	94.37	94.4	94.37	94.4	2400.0
2013-03-28 18:00:00	IWM	ETF	94.35	94.38	94.35	94.38	1400.0
2013-03-28 19:00:00	IWM	ETF	94.38	94.38	94.38	94.38	2000.0
2013-03-28 04:00:00	DIA	ETF	144.94	144.94	144.94	144.94	100.0
2013-03-28 06:00:00	DIA	ETF	145.07	145.07	145.07	145.07	2500.0
2013-03-28 07:00:00	DIA	ETF	145.11	145.11	145.11	145.11	250.0
2013-03-28 08:00:00	DIA	ETF	145.1	145.17	144.86	144.89	40076.0

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

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