PREVIEW / etf_1hour / 2010-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-28.parquet
  size:    153 KB
  rows:    4,757

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
2010-07-28 04:00:00	SPY	ETF	111.66	111.85	111.66	111.85	1300.0
2010-07-28 05:00:00	SPY	ETF	111.88	111.88	111.64	111.67	5382.0
2010-07-28 06:00:00	SPY	ETF	111.63	111.63	111.4	111.6	31462.0
2010-07-28 07:00:00	SPY	ETF	111.59	111.82	111.51	111.79	292603.0
2010-07-28 08:00:00	SPY	ETF	111.57	111.79	110.404	111.43	4669276.0
2010-07-28 09:00:00	SPY	ETF	111.44	111.66	111.16	111.4	19115975.0
2010-07-28 10:00:00	SPY	ETF	111.3983	111.51	110.87	111.2	26319189.0
2010-07-28 11:00:00	SPY	ETF	111.21	111.26	110.92	111.06	16152442.0
2010-07-28 12:00:00	SPY	ETF	111.06	111.39	110.99	111.38	12168803.0
2010-07-28 13:00:00	SPY	ETF	111.38	111.44	111.02	111.18	17427779.0
2010-07-28 14:00:00	SPY	ETF	111.18	111.31	110.75	110.82	20669862.0
2010-07-28 15:00:00	SPY	ETF	110.84	110.93	110.46	110.81	35311222.0
2010-07-28 16:00:00	SPY	ETF	110.8	111.555	110.7	110.77	10505454.0
2010-07-28 17:00:00	SPY	ETF	110.77	110.77	110.64	110.73	165534.0
2010-07-28 18:00:00	SPY	ETF	110.71	110.8	110.7	110.71	105043.0
2010-07-28 19:00:00	SPY	ETF	110.72	110.88	110.72	110.83	77068.0
2010-07-28 05:00:00	QQQ	ETF	46.56	46.57	46.56	46.57	11000.0
2010-07-28 06:00:00	QQQ	ETF	46.44	46.44	46.34	46.4	11035.0
2010-07-28 07:00:00	QQQ	ETF	46.42	46.53	46.4	46.53	77859.0
2010-07-28 08:00:00	QQQ	ETF	46.3597	46.54	46.26	46.35	1071139.0
2010-07-28 09:00:00	QQQ	ETF	46.35	46.58	46.32	46.5201	5798061.0
2010-07-28 10:00:00	QQQ	ETF	46.525	46.57	46.2	46.31	8539377.0
2010-07-28 11:00:00	QQQ	ETF	46.3	46.32	46.17	46.2101	5526680.0
2010-07-28 12:00:00	QQQ	ETF	46.22	46.31	46.19	46.3	3088804.0
2010-07-28 13:00:00	QQQ	ETF	46.3	46.32	46.07	46.11	4337262.0
2010-07-28 14:00:00	QQQ	ETF	46.11	46.18	46.0	46.02	7609069.0
2010-07-28 15:00:00	QQQ	ETF	46.02	46.07	45.88	46.05	10587817.0
2010-07-28 16:00:00	QQQ	ETF	46.05	46.4891	45.91	45.95	3550756.0
2010-07-28 17:00:00	QQQ	ETF	45.97	45.97	45.88	45.92	53977.0
2010-07-28 18:00:00	QQQ	ETF	45.93	45.95	45.93	45.94	20200.0
2010-07-28 19:00:00	QQQ	ETF	45.94	46.0	45.94	45.97	14954.0
2010-07-28 06:00:00	IWM	ETF	66.21	66.21	66.12	66.19	53600.0
2010-07-28 07:00:00	IWM	ETF	66.24	66.44	66.24	66.44	107700.0
2010-07-28 08:00:00	IWM	ETF	66.25	66.44	66.05	66.1	1480722.0
2010-07-28 09:00:00	IWM	ETF	66.1	66.43	65.95	66.1	6024315.0
2010-07-28 10:00:00	IWM	ETF	66.095	66.17	65.56	65.7	10098343.0
2010-07-28 11:00:00	IWM	ETF	65.69	65.75	65.36	65.47	4799162.0
2010-07-28 12:00:00	IWM	ETF	65.46	65.75	65.43	65.74	4356570.0
2010-07-28 13:00:00	IWM	ETF	65.75	65.81	65.48	65.59	4580467.0
2010-07-28 14:00:00	IWM	ETF	65.59	65.68	65.06	65.11	6897375.0
2010-07-28 15:00:00	IWM	ETF	65.11	65.17	64.78	65.14	11571155.0
2010-07-28 16:00:00	IWM	ETF	65.13	66.2101	64.9597	65.15	1643891.0
2010-07-28 17:00:00	IWM	ETF	65.12	65.17	65.06	65.12	204661.0
2010-07-28 18:00:00	IWM	ETF	65.1	65.1	65.1	65.1	100.0
2010-07-28 19:00:00	IWM	ETF	65.15	65.15	65.07	65.07	1100.0
2010-07-28 04:00:00	DIA	ETF	105.96	105.96	105.96	105.96	900.0
2010-07-28 07:00:00	DIA	ETF	105.58	105.58	105.48	105.55	6000.0
2010-07-28 08:00:00	DIA	ETF	105.59	105.64	105.14	105.27	301200.0
2010-07-28 09:00:00	DIA	ETF	105.28	105.55	105.09	105.305	854101.0
2010-07-28 10:00:00	DIA	ETF	105.31	105.4	105.03	105.32	1112805.0

> showing 50 of 4,757 rows — these rows as CSV

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