PREVIEW / etf_1hour / 2010-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-30.parquet
  size:    163 KB
  rows:    5,015

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-06-30 04:00:00	SPY	ETF	104.65	104.66	104.42	104.47	48306.0
2010-06-30 05:00:00	SPY	ETF	104.55	104.88	104.29	104.88	39410.0
2010-06-30 06:00:00	SPY	ETF	104.89	104.92	104.63	104.78	368997.0
2010-06-30 07:00:00	SPY	ETF	104.77	104.8	104.63	104.64	760293.0
2010-06-30 08:00:00	SPY	ETF	104.65	104.72	103.9	104.03	5089185.0
2010-06-30 09:00:00	SPY	ETF	104.04	104.76	103.85	104.43	32793503.0
2010-06-30 10:00:00	SPY	ETF	104.44	104.67	104.15	104.21	41917121.0
2010-06-30 11:00:00	SPY	ETF	104.21	104.88	104.16	104.7	24922233.0
2010-06-30 12:00:00	SPY	ETF	104.7	104.79	104.35	104.5	17870103.0
2010-06-30 13:00:00	SPY	ETF	104.5	104.65	104.35	104.56	14974766.0
2010-06-30 14:00:00	SPY	ETF	104.55	104.69	104.07	104.25	31924051.0
2010-06-30 15:00:00	SPY	ETF	104.25	104.36	102.88	103.11	79506810.0
2010-06-30 16:00:00	SPY	ETF	103.1	104.87	102.84	103.02	28638526.0
2010-06-30 17:00:00	SPY	ETF	103.02	103.03	102.85	102.9	1452148.0
2010-06-30 18:00:00	SPY	ETF	102.9	102.96	102.82	102.87	363802.0
2010-06-30 19:00:00	SPY	ETF	102.88	103.14	102.88	103.13	460149.0
2010-06-30 04:00:00	QQQ	ETF	43.63	43.63	43.57	43.59	2200.0
2010-06-30 05:00:00	QQQ	ETF	43.58	43.71	43.5	43.67	1500.0
2010-06-30 06:00:00	QQQ	ETF	43.7	43.7	43.63	43.63	19100.0
2010-06-30 07:00:00	QQQ	ETF	43.64	43.67	43.6	43.63	151060.0
2010-06-30 08:00:00	QQQ	ETF	43.61	43.63	43.33	43.39	1061685.0
2010-06-30 09:00:00	QQQ	ETF	43.38	43.64	43.22	43.48	13471710.0
2010-06-30 10:00:00	QQQ	ETF	43.48	43.62	43.34	43.36	10875666.0
2010-06-30 11:00:00	QQQ	ETF	43.36	43.67	43.34	43.59	7377860.0
2010-06-30 12:00:00	QQQ	ETF	43.585	43.67	43.45	43.5301	5135972.0
2010-06-30 13:00:00	QQQ	ETF	43.54	43.58	43.4	43.455	8121260.0
2010-06-30 14:00:00	QQQ	ETF	43.45	43.51	43.21	43.31	13410335.0
2010-06-30 15:00:00	QQQ	ETF	43.3	43.35	42.64	42.74	30125360.0
2010-06-30 16:00:00	QQQ	ETF	42.74	43.2738	42.67	42.72	5121311.0
2010-06-30 17:00:00	QQQ	ETF	42.72	42.74	42.69	42.72	58095.0
2010-06-30 18:00:00	QQQ	ETF	42.71	42.72	42.63	42.68	148522.0
2010-06-30 19:00:00	QQQ	ETF	42.67	42.75	42.65	42.74	54762.0
2010-06-30 05:00:00	IWM	ETF	62.18	62.18	62.15	62.15	400.0
2010-06-30 06:00:00	IWM	ETF	62.3	62.31	62.15	62.31	3511.0
2010-06-30 07:00:00	IWM	ETF	62.22	62.28	62.18	62.18	112700.0
2010-06-30 08:00:00	IWM	ETF	62.2	62.24	61.0	61.85	1602567.0
2010-06-30 09:00:00	IWM	ETF	61.86	62.62	61.45	62.17	11216903.0
2010-06-30 10:00:00	IWM	ETF	62.16	62.39	61.92	62.1	11583768.0
2010-06-30 11:00:00	IWM	ETF	62.11	62.6	62.02	62.39	9033747.0
2010-06-30 12:00:00	IWM	ETF	62.39	62.47	61.99	62.19	5963823.0
2010-06-30 13:00:00	IWM	ETF	62.194	62.32	61.9	62.09	6260938.0
2010-06-30 14:00:00	IWM	ETF	62.095	62.23	61.69	61.8	8932729.0
2010-06-30 15:00:00	IWM	ETF	61.79	61.94	60.94	61.13	26432975.0
2010-06-30 16:00:00	IWM	ETF	61.13	62.05	60.94	60.99	6403055.0
2010-06-30 17:00:00	IWM	ETF	60.99	61.5214	60.95	60.95	541178.0
2010-06-30 18:00:00	IWM	ETF	61.04	61.04	60.93	60.93	10152.0
2010-06-30 19:00:00	IWM	ETF	60.99	61.2092	60.94	61.11	125420.0
2010-06-30 05:00:00	DIA	ETF	99.13	99.21	99.13	99.19	12550.0
2010-06-30 06:00:00	DIA	ETF	99.21	99.23	99.02	99.19	12850.0
2010-06-30 07:00:00	DIA	ETF	99.1	99.1	99.08	99.1	4080.0

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

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