PREVIEW / etf_1hour / 2013-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-15.parquet
  size:    206 KB
  rows:    6,375

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-15 04:00:00	SPY	ETF	165.23	165.23	164.95	165.0	6520.0
2013-05-15 05:00:00	SPY	ETF	164.98	165.11	164.9	165.1	39840.0
2013-05-15 06:00:00	SPY	ETF	165.16	165.3	165.11	165.275	53214.0
2013-05-15 07:00:00	SPY	ETF	165.27	165.3	165.07	165.13	89650.0
2013-05-15 08:00:00	SPY	ETF	165.15	165.28	164.9	165.05	842849.0
2013-05-15 09:00:00	SPY	ETF	165.05	165.23	164.77	165.13	10461421.0
2013-05-15 10:00:00	SPY	ETF	165.13	165.39	165.06	165.38	12056688.0
2013-05-15 11:00:00	SPY	ETF	165.37	165.99	165.37	165.97	13381649.0
2013-05-15 12:00:00	SPY	ETF	165.97	166.45	165.9	166.275	14292489.0
2013-05-15 13:00:00	SPY	ETF	166.28	166.29	165.73	165.74	13923409.0
2013-05-15 14:00:00	SPY	ETF	165.731	165.855	165.35	165.54	17842044.0
2013-05-15 15:00:00	SPY	ETF	165.53	166.19	165.39	166.1	23797926.0
2013-05-15 16:00:00	SPY	ETF	166.08	166.31	165.3031	165.95	10759681.0
2013-05-15 17:00:00	SPY	ETF	165.96	166.05	165.93	166.05	272297.0
2013-05-15 18:00:00	SPY	ETF	166.04	166.04	165.86	165.93	81460.0
2013-05-15 19:00:00	SPY	ETF	165.92	166.02	165.9	166.0	34528.0
2013-05-15 05:00:00	QQQ	ETF	73.44	73.44	73.44	73.44	100.0
2013-05-15 06:00:00	QQQ	ETF	73.52	73.52	73.5	73.5	1000.0
2013-05-15 07:00:00	QQQ	ETF	73.55	73.55	73.49	73.49	12700.0
2013-05-15 08:00:00	QQQ	ETF	73.54	73.54	73.43	73.43	38244.0
2013-05-15 09:00:00	QQQ	ETF	73.42	73.6399	73.33	73.46	2105962.0
2013-05-15 10:00:00	QQQ	ETF	73.451	73.63	73.38	73.62	2777196.0
2013-05-15 11:00:00	QQQ	ETF	73.63	73.74	73.59	73.629	2357822.0
2013-05-15 12:00:00	QQQ	ETF	73.62	73.73	73.58	73.68	2354324.0
2013-05-15 13:00:00	QQQ	ETF	73.67	73.68	73.37	73.37	2807715.0
2013-05-15 14:00:00	QQQ	ETF	73.3717	73.459	73.2	73.315	3208013.0
2013-05-15 15:00:00	QQQ	ETF	73.32	73.7	73.2201	73.66	4219878.0
2013-05-15 16:00:00	QQQ	ETF	73.66	73.76	73.5145	73.76	2955643.0
2013-05-15 17:00:00	QQQ	ETF	73.76	73.84	73.75	73.84	26200.0
2013-05-15 18:00:00	QQQ	ETF	73.83	73.83	73.75	73.76	29817.0
2013-05-15 19:00:00	QQQ	ETF	73.76	73.84	73.76	73.83	107159.0
2013-05-15 05:00:00	IWM	ETF	97.81	97.81	97.81	97.81	500.0
2013-05-15 06:00:00	IWM	ETF	97.88	97.88	97.88	97.88	500.0
2013-05-15 07:00:00	IWM	ETF	97.91	97.93	97.85	97.9	5973.0
2013-05-15 08:00:00	IWM	ETF	97.84	97.88	97.53	97.83	97271.0
2013-05-15 09:00:00	IWM	ETF	97.79	97.98	97.68	97.97	3216221.0
2013-05-15 10:00:00	IWM	ETF	97.98	98.16	97.84	98.16	4257099.0
2013-05-15 11:00:00	IWM	ETF	98.16	98.52	98.16	98.449	3623778.0
2013-05-15 12:00:00	IWM	ETF	98.44	98.67	98.4	98.53	2942006.0
2013-05-15 13:00:00	IWM	ETF	98.5299	98.54	98.29	98.29	3347837.0
2013-05-15 14:00:00	IWM	ETF	98.295	98.3699	97.87	98.06	4942438.0
2013-05-15 15:00:00	IWM	ETF	98.06	98.3	97.95	98.19	6004119.0
2013-05-15 16:00:00	IWM	ETF	98.21	98.2591	98.0082	98.15	1879379.0
2013-05-15 17:00:00	IWM	ETF	98.18	98.24	98.16	98.16	90097.0
2013-05-15 18:00:00	IWM	ETF	98.24	98.24	98.16	98.16	2775.0
2013-05-15 19:00:00	IWM	ETF	98.2	98.2	98.2	98.2	950.0
2013-05-15 05:00:00	DIA	ETF	152.03	152.03	152.03	152.03	100.0
2013-05-15 06:00:00	DIA	ETF	152.1	152.1	152.1	152.1	100.0
2013-05-15 08:00:00	DIA	ETF	152.0	152.0	151.94	151.94	900.0
2013-05-15 09:00:00	DIA	ETF	151.9	152.15	151.81	152.1	522204.0

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

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