PREVIEW / etf_1hour / 2011-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-04.parquet
  size:    178 KB
  rows:    5,407

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-04 04:00:00	SPY	ETF	133.57	133.61	133.55	133.56	3300.0
2011-03-04 05:00:00	SPY	ETF	133.73	133.73	133.68	133.68	2400.0
2011-03-04 06:00:00	SPY	ETF	133.69	133.69	133.41	133.41	148765.0
2011-03-04 07:00:00	SPY	ETF	133.43	133.7	133.41	133.57	537206.0
2011-03-04 08:00:00	SPY	ETF	133.54	133.9	133.12	133.27	6855718.0
2011-03-04 09:00:00	SPY	ETF	133.27	133.58	133.09	133.25	21879979.0
2011-03-04 10:00:00	SPY	ETF	133.25	133.63	132.16	132.82	40406774.0
2011-03-04 11:00:00	SPY	ETF	132.82	132.87	131.79	132.32	35061381.0
2011-03-04 12:00:00	SPY	ETF	132.33	132.36	131.61	131.815	38388054.0
2011-03-04 13:00:00	SPY	ETF	131.82	133.4619	131.63	131.81	24093608.0
2011-03-04 14:00:00	SPY	ETF	131.81	132.06	131.6	132.04	16948598.0
2011-03-04 15:00:00	SPY	ETF	132.04	132.55	131.61	132.44	45106685.0
2011-03-04 16:00:00	SPY	ETF	132.45	133.4619	132.4	132.45	32319534.0
2011-03-04 17:00:00	SPY	ETF	132.43	133.4619	132.25	132.25	13520576.0
2011-03-04 18:00:00	SPY	ETF	132.3	132.48	132.25	132.35	305783.0
2011-03-04 19:00:00	SPY	ETF	132.35	132.4	132.34	132.39	79736.0
2011-03-04 04:00:00	QQQ	ETF	58.32	58.37	58.32	58.33	696.0
2011-03-04 05:00:00	QQQ	ETF	58.39	58.39	58.39	58.39	100.0
2011-03-04 06:00:00	QQQ	ETF	58.35	58.35	58.22	58.24	9226.0
2011-03-04 07:00:00	QQQ	ETF	58.24	58.37	58.23	58.32	31293.0
2011-03-04 08:00:00	QQQ	ETF	58.34	58.43	58.14	58.21	1803449.0
2011-03-04 09:00:00	QQQ	ETF	58.2	58.29	58.01	58.16	8958213.0
2011-03-04 10:00:00	QQQ	ETF	58.16	58.2	57.86	58.12	9594052.0
2011-03-04 11:00:00	QQQ	ETF	58.13	58.15	57.91	57.94	6122483.0
2011-03-04 12:00:00	QQQ	ETF	57.94	57.9599	57.59	57.7098	8573657.0
2011-03-04 13:00:00	QQQ	ETF	57.71	57.83	57.66	57.7575	4691118.0
2011-03-04 14:00:00	QQQ	ETF	57.75	57.82	57.65	57.82	5171856.0
2011-03-04 15:00:00	QQQ	ETF	57.8162	58.0	57.65	57.97	11573690.0
2011-03-04 16:00:00	QQQ	ETF	57.96	58.02	57.8614	57.99	1941389.0
2011-03-04 17:00:00	QQQ	ETF	57.99	57.99	57.91	57.91	112050.0
2011-03-04 18:00:00	QQQ	ETF	57.92	57.97	57.92	57.97	7955.0
2011-03-04 19:00:00	QQQ	ETF	57.97	57.99	57.96	57.96	8310.0
2011-03-04 06:00:00	IWM	ETF	83.01	83.01	82.89	82.89	11000.0
2011-03-04 07:00:00	IWM	ETF	82.88	83.08	82.88	83.02	56190.0
2011-03-04 08:00:00	IWM	ETF	83.0	83.19	82.64	82.76	1384691.0
2011-03-04 09:00:00	IWM	ETF	82.76	83.07	82.26	82.59	10105675.0
2011-03-04 10:00:00	IWM	ETF	82.58	82.67	82.18	82.62	8236350.0
2011-03-04 11:00:00	IWM	ETF	82.61	82.67	82.27	82.2925	5648025.0
2011-03-04 12:00:00	IWM	ETF	82.3	82.31	81.84	81.91	6979773.0
2011-03-04 13:00:00	IWM	ETF	81.91	82.1	81.74	81.84	4586479.0
2011-03-04 14:00:00	IWM	ETF	81.83	82.0401	81.65	82.04	4386363.0
2011-03-04 15:00:00	IWM	ETF	82.05	82.48	81.89	82.44	11558508.0
2011-03-04 16:00:00	IWM	ETF	82.48	82.6	82.3867	82.58	1289760.0
2011-03-04 17:00:00	IWM	ETF	82.58	82.6	82.41	82.41	134063.0
2011-03-04 18:00:00	IWM	ETF	82.56	82.56	82.5	82.53	8300.0
2011-03-04 19:00:00	IWM	ETF	82.52	82.52	82.49	82.49	826.0
2011-03-04 05:00:00	DIA	ETF	122.65	122.65	122.65	122.65	100.0
2011-03-04 06:00:00	DIA	ETF	122.67	122.67	122.65	122.65	3500.0
2011-03-04 07:00:00	DIA	ETF	122.51	122.65	122.51	122.65	2125.0
2011-03-04 08:00:00	DIA	ETF	122.58	122.84	122.26	122.36	101156.0

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

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