PREVIEW / etf_1hour / 2013-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-09.parquet
  size:    208 KB
  rows:    6,472

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-10-09 04:00:00	SPY	ETF	165.98	166.12	165.91	166.08	39613.0
2013-10-09 05:00:00	SPY	ETF	166.09	166.29	166.07	166.07	17919.0
2013-10-09 06:00:00	SPY	ETF	166.05	166.18	166.05	166.12	70104.0
2013-10-09 07:00:00	SPY	ETF	166.15	166.26	165.9	165.9	650545.0
2013-10-09 08:00:00	SPY	ETF	166.25	166.25	165.7	165.83	958173.0
2013-10-09 09:00:00	SPY	ETF	165.83	166.0	165.175	165.62	17565032.0
2013-10-09 10:00:00	SPY	ETF	165.6199	165.79	164.97	165.0	23811941.0
2013-10-09 11:00:00	SPY	ETF	165.01	165.26	164.53	165.17	19599643.0
2013-10-09 12:00:00	SPY	ETF	165.18	165.41	164.99	165.06	14767663.0
2013-10-09 13:00:00	SPY	ETF	165.06	166.0	165.06	165.8775	18759796.0
2013-10-09 14:00:00	SPY	ETF	165.87	166.2	165.65	166.15	23403446.0
2013-10-09 15:00:00	SPY	ETF	166.16	166.2	165.365	165.58	31241849.0
2013-10-09 16:00:00	SPY	ETF	165.56	166.03	165.29	165.4	9184023.0
2013-10-09 17:00:00	SPY	ETF	165.39	165.4	165.28	165.35	1182667.0
2013-10-09 18:00:00	SPY	ETF	165.36	165.83	165.32	165.83	521064.0
2013-10-09 19:00:00	SPY	ETF	165.83	165.86	165.68	165.72	193819.0
2013-10-09 04:00:00	QQQ	ETF	77.22	77.6	77.22	77.59	38430.0
2013-10-09 05:00:00	QQQ	ETF	77.6	77.65	77.57	77.57	10850.0
2013-10-09 06:00:00	QQQ	ETF	77.58	77.62	77.55	77.6	16600.0
2013-10-09 07:00:00	QQQ	ETF	77.6	77.63	77.49	77.51	45840.0
2013-10-09 08:00:00	QQQ	ETF	77.51	77.59	77.42	77.49	76144.0
2013-10-09 09:00:00	QQQ	ETF	77.49	77.54	76.84	77.07	5741929.0
2013-10-09 10:00:00	QQQ	ETF	77.075	77.2	76.7	76.73	8907848.0
2013-10-09 11:00:00	QQQ	ETF	76.73	76.82	76.35	76.59	8904839.0
2013-10-09 12:00:00	QQQ	ETF	76.59	76.779	76.45	76.52	6328480.0
2013-10-09 13:00:00	QQQ	ETF	76.53	77.13	76.53	77.04	6489301.0
2013-10-09 14:00:00	QQQ	ETF	77.05	77.28	76.91	77.25	8446210.0
2013-10-09 15:00:00	QQQ	ETF	77.26	77.31	76.88	76.98	8385765.0
2013-10-09 16:00:00	QQQ	ETF	76.975	77.26	76.774	76.93	1445598.0
2013-10-09 17:00:00	QQQ	ETF	76.93	76.96	76.86	76.89	16700.0
2013-10-09 18:00:00	QQQ	ETF	76.91	77.1	76.91	77.1	19690.0
2013-10-09 19:00:00	QQQ	ETF	77.09	77.11	77.03	77.05	12050.0
2013-10-09 07:00:00	IWM	ETF	104.55	104.55	104.39	104.4	115960.0
2013-10-09 08:00:00	IWM	ETF	104.41	104.55	104.29	104.35	265224.0
2013-10-09 09:00:00	IWM	ETF	104.37	104.48	103.45	103.83	7411452.0
2013-10-09 10:00:00	IWM	ETF	103.83	104.04	103.29	103.31	9002048.0
2013-10-09 11:00:00	IWM	ETF	103.3	103.53	103.0	103.359	7948708.0
2013-10-09 12:00:00	IWM	ETF	103.36	103.8	103.31	103.39	4644159.0
2013-10-09 13:00:00	IWM	ETF	103.4	104.34	103.395	104.1	5813723.0
2013-10-09 14:00:00	IWM	ETF	104.1	104.21	103.85	104.1	5745749.0
2013-10-09 15:00:00	IWM	ETF	104.1	104.12	103.39	103.64	8109363.0
2013-10-09 16:00:00	IWM	ETF	103.64	104.0824	103.3831	103.58	2397771.0
2013-10-09 18:00:00	IWM	ETF	103.8	103.9	103.8	103.9	3400.0
2013-10-09 19:00:00	IWM	ETF	103.9	103.91	103.9	103.91	650.0
2013-10-09 04:00:00	DIA	ETF	147.9	147.9	147.8	147.8	450.0
2013-10-09 07:00:00	DIA	ETF	147.96	147.96	147.95	147.95	24931.0
2013-10-09 08:00:00	DIA	ETF	147.74	147.9	147.74	147.77	3248.0
2013-10-09 09:00:00	DIA	ETF	147.73	147.86	147.34	147.7	1064560.0
2013-10-09 10:00:00	DIA	ETF	147.7	147.92	147.25	147.2684	1711705.0
2013-10-09 11:00:00	DIA	ETF	147.2742	147.615	146.96	147.52	1192102.0

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

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