PREVIEW / etf_1hour / 2011-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-15.parquet
  size:    181 KB
  rows:    5,639

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-12-15 04:00:00	SPY	ETF	122.02	122.53	121.81	122.0	17410.0
2011-12-15 05:00:00	SPY	ETF	122.06	122.41	122.06	122.34	11400.0
2011-12-15 06:00:00	SPY	ETF	122.47	122.49	122.21	122.23	98900.0
2011-12-15 07:00:00	SPY	ETF	122.23	122.7	122.21	122.62	644844.0
2011-12-15 08:00:00	SPY	ETF	122.62	123.25	122.24	123.16	4816922.0
2011-12-15 09:00:00	SPY	ETF	123.17	123.25	122.79	122.96	19104636.0
2011-12-15 10:00:00	SPY	ETF	122.95	123.2	121.99	122.2	31386090.0
2011-12-15 11:00:00	SPY	ETF	122.21	122.64	122.14	122.31	18655123.0
2011-12-15 12:00:00	SPY	ETF	122.31	122.78	122.3	122.48	16483098.0
2011-12-15 13:00:00	SPY	ETF	122.47	122.66	122.19	122.4	20788732.0
2011-12-15 14:00:00	SPY	ETF	122.39	122.57	122.07	122.18	13567482.0
2011-12-15 15:00:00	SPY	ETF	122.18	122.55	122.02	122.189	44219274.0
2011-12-15 16:00:00	SPY	ETF	122.17	122.9	121.7652	122.34	17259190.0
2011-12-15 17:00:00	SPY	ETF	122.36	122.53	122.1568	122.47	2725304.0
2011-12-15 18:00:00	SPY	ETF	122.47	122.65	122.15	122.6	395161.0
2011-12-15 19:00:00	SPY	ETF	122.63	122.71	122.58	122.6	175123.0
2011-12-15 05:00:00	QQQ	ETF	55.08	55.15	55.08	55.15	5200.0
2011-12-15 06:00:00	QQQ	ETF	55.15	55.15	55.02	55.02	2200.0
2011-12-15 07:00:00	QQQ	ETF	55.08	55.3	55.04	55.28	132314.0
2011-12-15 08:00:00	QQQ	ETF	55.27	55.47	55.25	55.44	851630.0
2011-12-15 09:00:00	QQQ	ETF	55.43	55.46	55.13	55.17	4484701.0
2011-12-15 10:00:00	QQQ	ETF	55.16	55.26	54.72	54.78	12837773.0
2011-12-15 11:00:00	QQQ	ETF	54.789	54.92	54.66	54.71	7975901.0
2011-12-15 12:00:00	QQQ	ETF	54.7081	54.99	54.7075	54.88	4395309.0
2011-12-15 13:00:00	QQQ	ETF	54.88	54.99	54.79	54.88	3885609.0
2011-12-15 14:00:00	QQQ	ETF	54.89	54.97	54.74	54.77	3596771.0
2011-12-15 15:00:00	QQQ	ETF	54.77	54.95	54.71	54.75	13235292.0
2011-12-15 16:00:00	QQQ	ETF	54.76	54.82	54.71	54.75	925588.0
2011-12-15 17:00:00	QQQ	ETF	54.76	54.78	54.75	54.78	29929.0
2011-12-15 18:00:00	QQQ	ETF	54.78	54.85	54.78	54.85	24900.0
2011-12-15 19:00:00	QQQ	ETF	54.88	54.9	54.86	54.9	78053.0
2011-12-15 06:00:00	IWM	ETF	71.54	71.54	71.37	71.37	2200.0
2011-12-15 07:00:00	IWM	ETF	71.44	71.67	71.42	71.61	16952.0
2011-12-15 08:00:00	IWM	ETF	71.62	72.09	71.57	72.03	663333.0
2011-12-15 09:00:00	IWM	ETF	72.08	72.14	71.68	71.77	4988299.0
2011-12-15 10:00:00	IWM	ETF	71.78	72.08	71.04	71.33	8703835.0
2011-12-15 11:00:00	IWM	ETF	71.34	71.66	71.23	71.525	3488545.0
2011-12-15 12:00:00	IWM	ETF	71.52	71.91	71.49	71.64	3816511.0
2011-12-15 13:00:00	IWM	ETF	71.63	71.96	71.39	71.74	4749209.0
2011-12-15 14:00:00	IWM	ETF	71.74	71.88	71.42	71.54	3179032.0
2011-12-15 15:00:00	IWM	ETF	71.52	71.88	71.465	71.69	9282927.0
2011-12-15 16:00:00	IWM	ETF	71.69	71.88	71.2143	71.79	3290949.0
2011-12-15 17:00:00	IWM	ETF	71.81	71.88	71.8	71.84	22845.0
2011-12-15 18:00:00	IWM	ETF	71.84	71.9	71.8	71.84	11295.0
2011-12-15 19:00:00	IWM	ETF	71.9	71.96	71.9	71.96	4399.0
2011-12-15 08:00:00	DIA	ETF	119.0	119.62	118.74	119.55	26750.0
2011-12-15 09:00:00	DIA	ETF	119.42	119.73	119.36	119.55	833668.0
2011-12-15 10:00:00	DIA	ETF	119.52	119.75	118.58	118.82	1068550.0
2011-12-15 11:00:00	DIA	ETF	118.81	119.18	118.749	118.88	372631.0
2011-12-15 12:00:00	DIA	ETF	118.87	119.32	118.87	119.06	447781.0

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

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