PREVIEW / etf_1hour / 2010-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-05.parquet
  size:    169 KB
  rows:    5,143

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-05-05 04:00:00	SPY	ETF	117.37	117.7	117.37	117.66	5300.0
2010-05-05 05:00:00	SPY	ETF	117.68	117.96	117.68	117.96	32700.0
2010-05-05 06:00:00	SPY	ETF	117.96	117.96	117.59	117.59	63000.0
2010-05-05 07:00:00	SPY	ETF	117.6	117.62	117.24	117.31	2534544.0
2010-05-05 08:00:00	SPY	ETF	117.32	118.0	116.61	116.67	7352349.0
2010-05-05 09:00:00	SPY	ETF	116.67	116.85	115.97	116.81	56913687.0
2010-05-05 10:00:00	SPY	ETF	116.8101	117.43	116.62	117.25	57882025.0
2010-05-05 11:00:00	SPY	ETF	117.25	117.78	116.79	117.68	35504810.0
2010-05-05 12:00:00	SPY	ETF	117.69	117.8	116.97	117.28	33308460.0
2010-05-05 13:00:00	SPY	ETF	117.28	117.47	116.29	117.15	21849208.0
2010-05-05 14:00:00	SPY	ETF	117.142	117.2	116.24	116.6	43017160.0
2010-05-05 15:00:00	SPY	ETF	116.59	116.92	116.35	116.83	49729003.0
2010-05-05 16:00:00	SPY	ETF	116.84	117.56	116.18	116.83	12907273.0
2010-05-05 17:00:00	SPY	ETF	116.87	116.97	116.8	116.94	272636.0
2010-05-05 18:00:00	SPY	ETF	116.95	117.13	116.82	117.1	118443.0
2010-05-05 19:00:00	SPY	ETF	117.1	117.18	117.02	117.13	61750.0
2010-05-05 05:00:00	QQQ	ETF	48.48	48.51	48.48	48.49	1100.0
2010-05-05 06:00:00	QQQ	ETF	48.45	48.45	48.41	48.41	300.0
2010-05-05 07:00:00	QQQ	ETF	48.37	48.4	48.28	48.3	27157.0
2010-05-05 08:00:00	QQQ	ETF	48.32	48.49	47.93	47.98	2034458.0
2010-05-05 09:00:00	QQQ	ETF	47.98	48.05	47.64	47.94	24801432.0
2010-05-05 10:00:00	QQQ	ETF	47.94	48.29	47.87	48.26	25071160.0
2010-05-05 11:00:00	QQQ	ETF	48.2601	48.5	48.04	48.46	10734020.0
2010-05-05 12:00:00	QQQ	ETF	48.46	48.49	48.1	48.24	15611941.0
2010-05-05 13:00:00	QQQ	ETF	48.24	48.38	48.15	48.23	9389047.0
2010-05-05 14:00:00	QQQ	ETF	48.24	48.27	47.9	48.07	14506247.0
2010-05-05 15:00:00	QQQ	ETF	48.07	48.21	47.97	48.19	17894936.0
2010-05-05 16:00:00	QQQ	ETF	48.2	48.47	48.05	48.23	2274504.0
2010-05-05 17:00:00	QQQ	ETF	48.22	48.24	48.16	48.21	99510.0
2010-05-05 18:00:00	QQQ	ETF	48.23	48.29	48.23	48.29	24583.0
2010-05-05 19:00:00	QQQ	ETF	48.29	48.31	48.26	48.3	58042.0
2010-05-05 05:00:00	IWM	ETF	71.29	71.29	71.29	71.29	100.0
2010-05-05 06:00:00	IWM	ETF	71.39	71.39	71.39	71.39	200.0
2010-05-05 07:00:00	IWM	ETF	71.11	71.18	70.93	70.98	437688.0
2010-05-05 08:00:00	IWM	ETF	71.0	71.39	70.36	70.39	1801171.0
2010-05-05 09:00:00	IWM	ETF	70.4	70.96	69.39	70.055	25610845.0
2010-05-05 10:00:00	IWM	ETF	70.05	70.57	69.94	70.44	16900402.0
2010-05-05 11:00:00	IWM	ETF	70.44	70.95	69.9954	70.86	12384472.0
2010-05-05 12:00:00	IWM	ETF	70.86	70.93	70.18	70.29	8888572.0
2010-05-05 13:00:00	IWM	ETF	70.3	70.63	70.09	70.42	8822745.0
2010-05-05 14:00:00	IWM	ETF	70.42	70.44	69.69	69.9081	10910274.0
2010-05-05 15:00:00	IWM	ETF	69.91	70.5674	69.73	69.91	15311191.0
2010-05-05 16:00:00	IWM	ETF	69.91	70.2432	69.85	70.03	5835437.0
2010-05-05 17:00:00	IWM	ETF	70.02	70.05	69.94	70.02	62114.0
2010-05-05 18:00:00	IWM	ETF	70.09	70.09	69.93	69.99	26773.0
2010-05-05 19:00:00	IWM	ETF	69.95	70.15	69.95	70.14	7700.0
2010-05-05 05:00:00	DIA	ETF	109.49	109.49	109.49	109.49	200.0
2010-05-05 07:00:00	DIA	ETF	109.22	109.22	109.12	109.12	500.0
2010-05-05 08:00:00	DIA	ETF	109.17	109.17	108.74	108.74	77890.0
2010-05-05 09:00:00	DIA	ETF	108.71	108.94	108.26	108.91	3362594.0

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

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