PREVIEW / etf_1hour / 2010-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-22.parquet
  size:    172 KB
  rows:    5,210

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-11-22 04:00:00	SPY	ETF	120.55	120.93	120.55	120.81	5300.0
2010-11-22 05:00:00	SPY	ETF	120.78	120.78	120.68	120.68	1900.0
2010-11-22 06:00:00	SPY	ETF	120.63	120.78	120.36	120.36	24892.0
2010-11-22 07:00:00	SPY	ETF	120.37	120.37	120.08	120.23	403930.0
2010-11-22 08:00:00	SPY	ETF	121.05	121.1	119.75	119.92	3835612.0
2010-11-22 09:00:00	SPY	ETF	119.92	120.24	119.54	120.1701	20141793.0
2010-11-22 10:00:00	SPY	ETF	120.17	120.23	119.42	119.52	28942743.0
2010-11-22 11:00:00	SPY	ETF	119.52	120.2	119.32	119.61	17274911.0
2010-11-22 12:00:00	SPY	ETF	119.61	119.62	118.77	119.04	30022125.0
2010-11-22 13:00:00	SPY	ETF	119.04	119.43	118.95	119.38	17248482.0
2010-11-22 14:00:00	SPY	ETF	119.39	119.92	119.33	119.88	20835306.0
2010-11-22 15:00:00	SPY	ETF	119.88	120.205	119.66	120.15	28825347.0
2010-11-22 16:00:00	SPY	ETF	120.16	120.33	118.965	120.17	9614328.0
2010-11-22 17:00:00	SPY	ETF	120.16	120.22	120.12	120.19	109025.0
2010-11-22 18:00:00	SPY	ETF	120.22	120.27	120.04	120.04	151021.0
2010-11-22 19:00:00	SPY	ETF	120.04	120.08	119.98	119.99	91396.0
2010-11-22 04:00:00	QQQ	ETF	52.75	52.79	52.75	52.78	530.0
2010-11-22 06:00:00	QQQ	ETF	52.7	52.7	52.62	52.62	26100.0
2010-11-22 07:00:00	QQQ	ETF	52.58	52.58	52.47	52.55	40464.0
2010-11-22 08:00:00	QQQ	ETF	52.53	52.53	52.27	52.35	2339494.0
2010-11-22 09:00:00	QQQ	ETF	52.34	52.84	52.21	52.82	10919200.0
2010-11-22 10:00:00	QQQ	ETF	52.83	52.88	52.41	52.495	9849668.0
2010-11-22 11:00:00	QQQ	ETF	52.495	52.62	52.38	52.61	4794353.0
2010-11-22 12:00:00	QQQ	ETF	52.6	52.605	52.17	52.26	10203291.0
2010-11-22 13:00:00	QQQ	ETF	52.26	52.48	52.2	52.45	5624194.0
2010-11-22 14:00:00	QQQ	ETF	52.45	52.7288	52.42	52.709	7568900.0
2010-11-22 15:00:00	QQQ	ETF	52.72	52.9001	52.63	52.9001	8584858.0
2010-11-22 16:00:00	QQQ	ETF	52.91	53.01	52.88	52.95	1847679.0
2010-11-22 17:00:00	QQQ	ETF	52.95	52.98	52.91	52.93	107308.0
2010-11-22 18:00:00	QQQ	ETF	52.95	52.98	52.91	52.91	66210.0
2010-11-22 19:00:00	QQQ	ETF	52.89	52.91	52.86	52.89	18959.0
2010-11-22 04:00:00	IWM	ETF	72.93	72.93	72.93	72.93	251.0
2010-11-22 07:00:00	IWM	ETF	72.63	72.71	72.47	72.51	279900.0
2010-11-22 08:00:00	IWM	ETF	73.2	73.2	72.22	72.3	461804.0
2010-11-22 09:00:00	IWM	ETF	72.3	72.74	72.07	72.69	4843733.0
2010-11-22 10:00:00	IWM	ETF	72.68	72.81	72.11	72.29	6305307.0
2010-11-22 11:00:00	IWM	ETF	72.29	72.38	72.15	72.32	3099842.0
2010-11-22 12:00:00	IWM	ETF	72.3176	72.33	71.74	71.91	6998558.0
2010-11-22 13:00:00	IWM	ETF	71.9122	72.46	71.8	72.37	4748113.0
2010-11-22 14:00:00	IWM	ETF	72.37	72.71	72.33	72.64	4418687.0
2010-11-22 15:00:00	IWM	ETF	72.64	72.99	72.57	72.82	8108542.0
2010-11-22 16:00:00	IWM	ETF	72.81	72.95	72.25	72.84	1587635.0
2010-11-22 17:00:00	IWM	ETF	72.83	72.95	72.82	72.95	10700.0
2010-11-22 18:00:00	IWM	ETF	72.95	72.95	72.79	72.79	2700.0
2010-11-22 19:00:00	IWM	ETF	72.78	73.0	72.71	72.71	6800.0
2010-11-22 07:00:00	DIA	ETF	112.07	112.07	112.07	112.07	500.0
2010-11-22 08:00:00	DIA	ETF	111.87	111.89	111.62	111.71	22700.0
2010-11-22 09:00:00	DIA	ETF	111.69	111.85	111.2301	111.8	1447455.0
2010-11-22 10:00:00	DIA	ETF	111.82	111.8469	111.01	111.18	1203916.0
2010-11-22 11:00:00	DIA	ETF	111.18	111.31	111.04	111.2101	671896.0

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

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