PREVIEW / etf_1hour / 2011-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-17.parquet
  size:    186 KB
  rows:    5,762

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-11-17 04:00:00	SPY	ETF	123.85	124.4	123.62	123.63	25925.0
2011-11-17 05:00:00	SPY	ETF	123.73	123.78	123.41	123.71	39070.0
2011-11-17 06:00:00	SPY	ETF	123.72	123.98	123.1	123.17	394839.0
2011-11-17 07:00:00	SPY	ETF	123.19	123.49	122.61	123.44	1517424.0
2011-11-17 08:00:00	SPY	ETF	123.45	123.95	122.95	123.66	5229683.0
2011-11-17 09:00:00	SPY	ETF	123.65	124.23	122.97	123.48	31408099.0
2011-11-17 10:00:00	SPY	ETF	123.47	124.16	123.19	123.765	46622485.0
2011-11-17 11:00:00	SPY	ETF	123.75	123.9	123.25	123.5885	32574812.0
2011-11-17 12:00:00	SPY	ETF	123.58	123.67	121.47	122.14	51015760.0
2011-11-17 13:00:00	SPY	ETF	122.14	122.28	121.26	121.89	37937484.0
2011-11-17 14:00:00	SPY	ETF	121.89	122.0	121.29	121.79	31663795.0
2011-11-17 15:00:00	SPY	ETF	121.79	122.14	121.23	122.09	58435261.0
2011-11-17 16:00:00	SPY	ETF	122.17	124.0435	121.5	122.14	31890673.0
2011-11-17 17:00:00	SPY	ETF	122.14	122.23	122.04	122.05	374967.0
2011-11-17 18:00:00	SPY	ETF	122.05	122.18	121.67	121.68	742483.0
2011-11-17 19:00:00	SPY	ETF	121.69	122.02	121.5	121.92	420224.0
2011-11-17 04:00:00	QQQ	ETF	57.07	57.19	56.89	56.89	2700.0
2011-11-17 05:00:00	QQQ	ETF	56.9	56.96	56.8	56.8	22600.0
2011-11-17 06:00:00	QQQ	ETF	56.93	57.01	56.7	56.7	6800.0
2011-11-17 07:00:00	QQQ	ETF	56.68	56.83	56.54	56.83	73621.0
2011-11-17 08:00:00	QQQ	ETF	56.81	57.05	56.65	56.92	937741.0
2011-11-17 09:00:00	QQQ	ETF	56.93	57.13	56.57	56.8	7204528.0
2011-11-17 10:00:00	QQQ	ETF	56.78	56.8777	56.58	56.61	11322434.0
2011-11-17 11:00:00	QQQ	ETF	56.6	56.66	56.32	56.4713	11619650.0
2011-11-17 12:00:00	QQQ	ETF	56.47	56.52	55.48	55.78	17873504.0
2011-11-17 13:00:00	QQQ	ETF	55.79	55.88	55.48	55.76	10652802.0
2011-11-17 14:00:00	QQQ	ETF	55.75	55.94	55.56	55.8	6864750.0
2011-11-17 15:00:00	QQQ	ETF	55.805	55.91	55.57	55.9	12985312.0
2011-11-17 16:00:00	QQQ	ETF	55.9	55.91	55.7326	55.86	3339487.0
2011-11-17 17:00:00	QQQ	ETF	55.84	55.85	55.76	55.79	70300.0
2011-11-17 18:00:00	QQQ	ETF	55.79	55.81	55.68	55.68	102323.0
2011-11-17 19:00:00	QQQ	ETF	55.65	55.79	55.62	55.75	79671.0
2011-11-17 04:00:00	IWM	ETF	73.24	73.24	72.85	72.85	200.0
2011-11-17 05:00:00	IWM	ETF	73.0	73.0	72.8	72.81	2407.0
2011-11-17 06:00:00	IWM	ETF	73.0	73.0	72.6	72.6	2900.0
2011-11-17 07:00:00	IWM	ETF	72.47	72.78	72.15	72.74	207600.0
2011-11-17 08:00:00	IWM	ETF	72.74	73.03	72.41	72.64	1281652.0
2011-11-17 09:00:00	IWM	ETF	72.65	73.07	72.23	72.9	7285224.0
2011-11-17 10:00:00	IWM	ETF	72.89	73.42	72.62	73.095	11684666.0
2011-11-17 11:00:00	IWM	ETF	73.09	73.44	72.83	73.1586	5870609.0
2011-11-17 12:00:00	IWM	ETF	73.15	73.2	71.69	72.19	10571538.0
2011-11-17 13:00:00	IWM	ETF	72.19	72.28	71.65	72.05	7961070.0
2011-11-17 14:00:00	IWM	ETF	72.05	72.16	71.27	72.09	6368494.0
2011-11-17 15:00:00	IWM	ETF	72.08	72.19	71.55	72.0	14606282.0
2011-11-17 16:00:00	IWM	ETF	71.99	72.9844	71.7455	72.01	4730756.0
2011-11-17 17:00:00	IWM	ETF	72.01	72.05	71.94	71.94	18505.0
2011-11-17 18:00:00	IWM	ETF	71.99	71.99	71.94	71.96	300.0
2011-11-17 19:00:00	IWM	ETF	71.74	71.94	71.68	71.94	5600.0
2011-11-17 08:00:00	DIA	ETF	118.42	119.05	118.4	118.9	21563.0
2011-11-17 09:00:00	DIA	ETF	118.98	119.31	118.35	118.878	993137.0

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

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