PREVIEW / etf_1hour / 2011-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-21.parquet
  size:    183 KB
  rows:    5,633

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
2011-07-21 04:00:00	SPY	ETF	132.52	132.64	132.52	132.6	500.0
2011-07-21 05:00:00	SPY	ETF	132.6	132.6	132.1	132.18	20161.0
2011-07-21 06:00:00	SPY	ETF	132.19	132.56	132.05	132.56	92900.0
2011-07-21 07:00:00	SPY	ETF	132.61	133.0	132.57	133.0	1476220.0
2011-07-21 08:00:00	SPY	ETF	132.98	133.63	132.87	133.5	9105276.0
2011-07-21 09:00:00	SPY	ETF	133.5	133.95	133.14	133.83	22963190.0
2011-07-21 10:00:00	SPY	ETF	133.84	134.61	133.68	134.37	43199432.0
2011-07-21 11:00:00	SPY	ETF	134.38	134.44	133.92	134.085	24467135.0
2011-07-21 12:00:00	SPY	ETF	134.08	134.82	133.93	134.57	42367031.0
2011-07-21 13:00:00	SPY	ETF	134.57	134.77	134.41	134.6	23708413.0
2011-07-21 14:00:00	SPY	ETF	134.6	134.68	134.37	134.63	17451310.0
2011-07-21 15:00:00	SPY	ETF	134.63	134.72	134.38	134.49	39202970.0
2011-07-21 16:00:00	SPY	ETF	134.49	134.89	134.3168	134.79	18782627.0
2011-07-21 17:00:00	SPY	ETF	134.79	134.9	134.76	134.84	107160.0
2011-07-21 18:00:00	SPY	ETF	134.84	134.9	134.52	134.83	435123.0
2011-07-21 19:00:00	SPY	ETF	134.85	134.9	134.8	134.9	66060.0
2011-07-21 06:00:00	QQQ	ETF	58.25	58.25	58.2	58.25	12400.0
2011-07-21 07:00:00	QQQ	ETF	58.36	58.54	58.32	58.54	574204.0
2011-07-21 08:00:00	QQQ	ETF	58.41	58.86	58.41	58.76	2785892.0
2011-07-21 09:00:00	QQQ	ETF	58.77	58.87	58.34	58.73	12179584.0
2011-07-21 10:00:00	QQQ	ETF	58.72	59.32	58.64	59.2	13069830.0
2011-07-21 11:00:00	QQQ	ETF	59.2	59.24	58.79	58.88	6715598.0
2011-07-21 12:00:00	QQQ	ETF	58.8899	59.245	58.85	59.11	7201313.0
2011-07-21 13:00:00	QQQ	ETF	59.11	59.16	59.0	59.1	2368977.0
2011-07-21 14:00:00	QQQ	ETF	59.1	59.14	58.94	59.11	4220243.0
2011-07-21 15:00:00	QQQ	ETF	59.1	59.15	58.97	58.995	10834403.0
2011-07-21 16:00:00	QQQ	ETF	58.99	59.24	58.86	59.18	4951206.0
2011-07-21 17:00:00	QQQ	ETF	59.15	59.24	59.15	59.21	61216.0
2011-07-21 18:00:00	QQQ	ETF	59.21	59.22	58.99	59.19	54085.0
2011-07-21 19:00:00	QQQ	ETF	59.2	59.23	59.18	59.23	45048.0
2011-07-21 05:00:00	IWM	ETF	82.8	82.8	82.7	82.7	500.0
2011-07-21 06:00:00	IWM	ETF	82.56	82.74	82.51	82.74	4300.0
2011-07-21 07:00:00	IWM	ETF	82.98	83.17	82.93	83.17	17900.0
2011-07-21 08:00:00	IWM	ETF	83.11	83.61	83.1	83.55	1019005.0
2011-07-21 09:00:00	IWM	ETF	83.55	83.93	83.24	83.78	5122754.0
2011-07-21 10:00:00	IWM	ETF	83.79	84.3	83.64	84.12	12553850.0
2011-07-21 11:00:00	IWM	ETF	84.12	84.18	83.59	83.7	7397443.0
2011-07-21 12:00:00	IWM	ETF	83.7	84.15	83.63	83.91	7200379.0
2011-07-21 13:00:00	IWM	ETF	83.9	84.03	83.82	83.96	3413100.0
2011-07-21 14:00:00	IWM	ETF	83.96	84.07	83.84	84.03	3505862.0
2011-07-21 15:00:00	IWM	ETF	84.04	84.12	83.88	83.96	10652897.0
2011-07-21 16:00:00	IWM	ETF	83.95	84.25	83.9	84.18	2290849.0
2011-07-21 17:00:00	IWM	ETF	84.15	84.3	84.12	84.3	29729.0
2011-07-21 18:00:00	IWM	ETF	84.12	84.12	84.12	84.12	200.0
2011-07-21 19:00:00	IWM	ETF	84.12	84.17	84.12	84.17	749.0
2011-07-21 04:00:00	DIA	ETF	125.63	125.63	125.34	125.34	400.0
2011-07-21 05:00:00	DIA	ETF	125.26	125.26	125.12	125.12	200.0
2011-07-21 06:00:00	DIA	ETF	125.04	125.04	125.04	125.04	200.0
2011-07-21 07:00:00	DIA	ETF	125.4	125.6	125.37	125.6	51600.0
2011-07-21 08:00:00	DIA	ETF	125.57	126.21	125.4	126.1	481650.0

> showing 50 of 5,633 rows — these rows as CSV

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