PREVIEW / etf_1hour / 2011-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-03.parquet
  size:    182 KB
  rows:    5,557

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-03-03 04:00:00	SPY	ETF	131.5	131.71	131.5	131.69	12350.0
2011-03-03 05:00:00	SPY	ETF	131.66	132.0	131.66	131.93	40912.0
2011-03-03 06:00:00	SPY	ETF	131.99	132.33	131.92	132.29	263981.0
2011-03-03 07:00:00	SPY	ETF	132.33	132.33	132.11	132.24	568299.0
2011-03-03 08:00:00	SPY	ETF	132.21	132.54	123.03	132.24	5261151.0
2011-03-03 09:00:00	SPY	ETF	132.23	132.98	132.17	132.83	25728724.0
2011-03-03 10:00:00	SPY	ETF	132.83	133.07	132.53	132.9	29047417.0
2011-03-03 11:00:00	SPY	ETF	132.91	133.23	132.39	133.19	18926118.0
2011-03-03 12:00:00	SPY	ETF	133.19	133.33	133.06	133.249	14041248.0
2011-03-03 13:00:00	SPY	ETF	133.24	133.325	133.13	133.195	13650812.0
2011-03-03 14:00:00	SPY	ETF	133.2	133.61	133.19	133.58	17286224.0
2011-03-03 15:00:00	SPY	ETF	133.57	133.62	133.35	133.47	29367480.0
2011-03-03 16:00:00	SPY	ETF	133.45	133.5	130.3271	133.39	18533362.0
2011-03-03 17:00:00	SPY	ETF	133.41	133.45	133.39	133.41	1140532.0
2011-03-03 18:00:00	SPY	ETF	133.42	133.7	133.42	133.65	537281.0
2011-03-03 19:00:00	SPY	ETF	133.62	133.62	133.47	133.52	49657.0
2011-03-03 04:00:00	QQQ	ETF	57.26	57.26	57.26	57.26	442.0
2011-03-03 05:00:00	QQQ	ETF	57.29	57.42	57.29	57.42	15100.0
2011-03-03 06:00:00	QQQ	ETF	57.41	57.6	57.38	57.6	14968.0
2011-03-03 07:00:00	QQQ	ETF	57.6	57.6	57.49	57.57	792781.0
2011-03-03 08:00:00	QQQ	ETF	57.57	57.7	57.5	57.61	980132.0
2011-03-03 09:00:00	QQQ	ETF	57.61	58.05	57.57	58.0206	9609412.0
2011-03-03 10:00:00	QQQ	ETF	58.02	58.2	57.92	58.14	12889699.0
2011-03-03 11:00:00	QQQ	ETF	58.14	58.27	58.11	58.26	5461669.0
2011-03-03 12:00:00	QQQ	ETF	58.255	58.31	58.21	58.26	2777183.0
2011-03-03 13:00:00	QQQ	ETF	58.26	58.3	58.21	58.22	4376444.0
2011-03-03 14:00:00	QQQ	ETF	58.22	58.36	58.22	58.35	5508386.0
2011-03-03 15:00:00	QQQ	ETF	58.35	58.365	58.24	58.27	8533226.0
2011-03-03 16:00:00	QQQ	ETF	58.27	58.3411	58.23	58.3	2146370.0
2011-03-03 17:00:00	QQQ	ETF	58.29	58.3	58.26	58.26	21361.0
2011-03-03 18:00:00	QQQ	ETF	58.28	58.42	58.26	58.37	66479.0
2011-03-03 19:00:00	QQQ	ETF	58.36	58.36	58.31	58.32	44805.0
2011-03-03 05:00:00	IWM	ETF	81.45	81.45	81.39	81.44	12800.0
2011-03-03 06:00:00	IWM	ETF	81.41	81.76	81.41	81.74	35900.0
2011-03-03 07:00:00	IWM	ETF	81.74	81.74	81.64	81.67	76020.0
2011-03-03 08:00:00	IWM	ETF	81.71	81.89	81.6	81.69	820806.0
2011-03-03 09:00:00	IWM	ETF	81.71	82.4184	81.64	82.32	8775810.0
2011-03-03 10:00:00	IWM	ETF	82.31	82.6	82.11	82.49	11843845.0
2011-03-03 11:00:00	IWM	ETF	82.5	82.9	82.45	82.89	8288278.0
2011-03-03 12:00:00	IWM	ETF	82.89	83.02	82.78	82.87	4190196.0
2011-03-03 13:00:00	IWM	ETF	82.88	82.95	82.68	82.72	4209768.0
2011-03-03 14:00:00	IWM	ETF	82.72	82.97	82.71	82.84	6802458.0
2011-03-03 15:00:00	IWM	ETF	82.8401	82.92	81.0263	82.8	16187617.0
2011-03-03 16:00:00	IWM	ETF	82.79	82.92	82.72	82.85	2081489.0
2011-03-03 17:00:00	IWM	ETF	82.87	82.95	82.8	82.88	70740.0
2011-03-03 18:00:00	IWM	ETF	82.94	83.0	82.86	83.0	4900.0
2011-03-03 19:00:00	IWM	ETF	82.95	82.95	82.91	82.93	600.0
2011-03-03 05:00:00	DIA	ETF	121.04	121.16	121.04	121.16	300.0
2011-03-03 07:00:00	DIA	ETF	121.32	121.33	121.23	121.23	2960.0
2011-03-03 08:00:00	DIA	ETF	121.26	121.49	121.18	121.29	54020.0

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

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