PREVIEW / etf_1hour / 2010-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-15.parquet
  size:    169 KB
  rows:    5,178

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-10-15 04:00:00	SPY	ETF	117.8	117.8	117.6	117.77	2400.0
2010-10-15 05:00:00	SPY	ETF	117.75	117.78	117.62	117.62	1500.0
2010-10-15 06:00:00	SPY	ETF	117.75	117.75	117.55	117.62	105810.0
2010-10-15 07:00:00	SPY	ETF	117.64	117.71	117.48	117.65	1088409.0
2010-10-15 08:00:00	SPY	ETF	117.65	118.44	117.49	118.05	7133261.0
2010-10-15 09:00:00	SPY	ETF	118.04	118.4	117.5	117.54	34215212.0
2010-10-15 10:00:00	SPY	ETF	117.55	117.75	116.76	117.28	51794820.0
2010-10-15 11:00:00	SPY	ETF	117.29	117.83	117.21	117.31	32587364.0
2010-10-15 12:00:00	SPY	ETF	117.31	117.7	117.1	117.475	24340133.0
2010-10-15 13:00:00	SPY	ETF	117.48	117.61	117.23	117.33	17590616.0
2010-10-15 14:00:00	SPY	ETF	117.32	117.72	117.1681	117.538	21129936.0
2010-10-15 15:00:00	SPY	ETF	117.53	117.79	117.3	117.73	37829821.0
2010-10-15 16:00:00	SPY	ETF	117.72	118.02	116.65	117.98	11722881.0
2010-10-15 17:00:00	SPY	ETF	117.98	117.98	117.88	117.91	182540.0
2010-10-15 18:00:00	SPY	ETF	117.91	117.93	117.72	117.88	124363.0
2010-10-15 19:00:00	SPY	ETF	117.89	117.93	117.79	117.85	54209.0
2010-10-15 04:00:00	QQQ	ETF	50.72	50.78	50.72	50.78	780.0
2010-10-15 05:00:00	QQQ	ETF	50.77	50.77	50.73	50.73	900.0
2010-10-15 06:00:00	QQQ	ETF	50.76	50.76	50.74	50.75	3600.0
2010-10-15 07:00:00	QQQ	ETF	50.73	50.75	50.64	50.74	677096.0
2010-10-15 08:00:00	QQQ	ETF	50.67	51.05	50.67	50.9	1873966.0
2010-10-15 09:00:00	QQQ	ETF	50.9	51.13	50.76	50.86	12489233.0
2010-10-15 10:00:00	QQQ	ETF	50.86	50.94	50.63	50.855	16779359.0
2010-10-15 11:00:00	QQQ	ETF	50.85	51.22	50.83	51.045	18028130.0
2010-10-15 12:00:00	QQQ	ETF	51.045	51.175	50.945	51.1001	8855446.0
2010-10-15 13:00:00	QQQ	ETF	51.11	51.21	51.065	51.12	6086934.0
2010-10-15 14:00:00	QQQ	ETF	51.11	51.28	51.04	51.235	6964039.0
2010-10-15 15:00:00	QQQ	ETF	51.24	51.5	51.13	51.5	25181530.0
2010-10-15 16:00:00	QQQ	ETF	51.5	51.59	51.46	51.55	2538301.0
2010-10-15 17:00:00	QQQ	ETF	51.55	51.57	51.5	51.55	56284.0
2010-10-15 18:00:00	QQQ	ETF	51.55	51.57	51.54	51.57	10825.0
2010-10-15 19:00:00	QQQ	ETF	51.58	51.59	51.56	51.56	20048.0
2010-10-15 07:00:00	IWM	ETF	70.72	70.86	70.71	70.86	592600.0
2010-10-15 08:00:00	IWM	ETF	70.73	71.34	70.73	71.03	1911249.0
2010-10-15 09:00:00	IWM	ETF	71.03	71.25	70.38	70.55	10009840.0
2010-10-15 10:00:00	IWM	ETF	70.55	70.78	69.89	70.36	18368018.0
2010-10-15 11:00:00	IWM	ETF	70.36	70.97	70.32	70.43	11775131.0
2010-10-15 12:00:00	IWM	ETF	70.44	70.61	70.18	70.43	5967159.0
2010-10-15 13:00:00	IWM	ETF	70.44	70.61	70.26	70.37	3882886.0
2010-10-15 14:00:00	IWM	ETF	70.36	70.57	70.2299	70.388	5345190.0
2010-10-15 15:00:00	IWM	ETF	70.38	70.53	70.21	70.31	7146488.0
2010-10-15 16:00:00	IWM	ETF	70.31	70.6882	70.1	70.51	3106135.0
2010-10-15 17:00:00	IWM	ETF	70.5	70.52	70.25	70.47	2360.0
2010-10-15 18:00:00	IWM	ETF	70.43	70.44	70.4	70.42	4100.0
2010-10-15 19:00:00	IWM	ETF	70.42	70.42	70.41	70.41	400.0
2010-10-15 07:00:00	DIA	ETF	110.93	111.01	110.9	111.01	15400.0
2010-10-15 08:00:00	DIA	ETF	111.02	111.6	111.02	111.22	106121.0
2010-10-15 09:00:00	DIA	ETF	111.27	111.47	110.72	110.75	1739883.0
2010-10-15 10:00:00	DIA	ETF	110.76	110.93	110.11	110.52	2403395.0
2010-10-15 11:00:00	DIA	ETF	110.52	110.86	110.32	110.41	907691.0

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

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