PREVIEW / etf_1hour / 2011-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-26.parquet
  size:    179 KB
  rows:    5,528

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-04-26 04:00:00	SPY	ETF	133.76	134.03	133.76	134.03	4800.0
2011-04-26 05:00:00	SPY	ETF	133.94	134.18	133.94	134.11	5300.0
2011-04-26 06:00:00	SPY	ETF	134.09	134.09	133.98	134.0	113670.0
2011-04-26 07:00:00	SPY	ETF	134.01	134.16	133.9	134.16	306040.0
2011-04-26 08:00:00	SPY	ETF	134.13	134.16	134.02	134.08	1239782.0
2011-04-26 09:00:00	SPY	ETF	134.08	134.26	133.91	134.14	16568464.0
2011-04-26 10:00:00	SPY	ETF	134.14	134.66	133.96	134.65	23120161.0
2011-04-26 11:00:00	SPY	ETF	134.65	134.94	134.61	134.93	15370384.0
2011-04-26 12:00:00	SPY	ETF	134.93	135.06	134.81	134.86	14869596.0
2011-04-26 13:00:00	SPY	ETF	134.86	134.87	134.61	134.7	12611069.0
2011-04-26 14:00:00	SPY	ETF	134.71	134.86	134.65	134.84	10689380.0
2011-04-26 15:00:00	SPY	ETF	134.845	134.99	134.7	134.78	28310584.0
2011-04-26 16:00:00	SPY	ETF	134.79	134.8156	133.5941	134.66	19711728.0
2011-04-26 17:00:00	SPY	ETF	134.66	134.85	134.6	134.7	186210.0
2011-04-26 18:00:00	SPY	ETF	134.66	134.79	134.62	134.72	165053.0
2011-04-26 19:00:00	SPY	ETF	134.71	134.77	134.7	134.77	23294.0
2011-04-26 04:00:00	QQQ	ETF	58.6	58.6	58.6	58.6	100.0
2011-04-26 05:00:00	QQQ	ETF	58.62	58.69	58.62	58.64	300.0
2011-04-26 06:00:00	QQQ	ETF	58.62	58.62	58.6	58.6	700.0
2011-04-26 07:00:00	QQQ	ETF	58.62	58.66	58.57	58.66	14713.0
2011-04-26 08:00:00	QQQ	ETF	58.65	58.66	58.61	58.63	70772.0
2011-04-26 09:00:00	QQQ	ETF	58.63	58.73	58.51	58.69	5867735.0
2011-04-26 10:00:00	QQQ	ETF	58.69	58.9	58.57	58.9	7272058.0
2011-04-26 11:00:00	QQQ	ETF	58.9	58.95	58.835	58.95	2896259.0
2011-04-26 12:00:00	QQQ	ETF	58.95	59.03	58.84	58.8402	5447554.0
2011-04-26 13:00:00	QQQ	ETF	58.843	58.85	58.66	58.75	3295525.0
2011-04-26 14:00:00	QQQ	ETF	58.75	58.89	58.7	58.84	3546424.0
2011-04-26 15:00:00	QQQ	ETF	58.84	58.93	58.7	58.82	9622131.0
2011-04-26 16:00:00	QQQ	ETF	58.82	58.88	58.47	58.77	4379496.0
2011-04-26 17:00:00	QQQ	ETF	58.76	58.8	58.72	58.72	54373.0
2011-04-26 18:00:00	QQQ	ETF	58.72	58.79	58.72	58.78	33492.0
2011-04-26 19:00:00	QQQ	ETF	58.79	58.82	58.79	58.82	19409.0
2011-04-26 06:00:00	IWM	ETF	84.55	84.55	84.55	84.55	250.0
2011-04-26 07:00:00	IWM	ETF	84.52	84.66	84.49	84.66	7103.0
2011-04-26 08:00:00	IWM	ETF	84.64	84.67	84.58	84.58	145233.0
2011-04-26 09:00:00	IWM	ETF	84.58	84.82	84.35	84.69	5799993.0
2011-04-26 10:00:00	IWM	ETF	84.69	85.28	84.64	85.27	8207976.0
2011-04-26 11:00:00	IWM	ETF	85.28	85.59	85.24	85.57	5942284.0
2011-04-26 12:00:00	IWM	ETF	85.57	85.67	85.37	85.43	7553789.0
2011-04-26 13:00:00	IWM	ETF	85.43	85.48	85.31	85.435	4022237.0
2011-04-26 14:00:00	IWM	ETF	85.44	85.51	85.28	85.34	3787403.0
2011-04-26 15:00:00	IWM	ETF	85.33	85.4	85.11	85.15	7607865.0
2011-04-26 16:00:00	IWM	ETF	85.15	85.3459	84.83	84.97	1580967.0
2011-04-26 17:00:00	IWM	ETF	84.97	85.0	84.95	84.95	7734.0
2011-04-26 18:00:00	IWM	ETF	84.97	84.99	84.97	84.99	1100.0
2011-04-26 19:00:00	IWM	ETF	84.98	85.0	84.97	85.0	1386.0
2011-04-26 04:00:00	DIA	ETF	124.68	124.83	124.68	124.83	1200.0
2011-04-26 05:00:00	DIA	ETF	124.91	124.95	124.9	124.95	2800.0
2011-04-26 07:00:00	DIA	ETF	124.83	124.95	124.78	124.95	1000.0
2011-04-26 08:00:00	DIA	ETF	124.91	124.97	124.9	124.94	52390.0

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

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