PREVIEW / etf_1hour / 2009-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-12.parquet
  size:    143 KB
  rows:    4,417

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
2009-10-12 04:00:00	SPY	ETF	107.7	107.9	107.7	107.9	5000.0
2009-10-12 05:00:00	SPY	ETF	107.93	107.98	107.83	107.9	17200.0
2009-10-12 06:00:00	SPY	ETF	107.92	107.95	107.85	107.95	64530.0
2009-10-12 07:00:00	SPY	ETF	107.94	108.13	107.94	107.98	431438.0
2009-10-12 08:00:00	SPY	ETF	107.97	107.97	107.76	107.81	1369570.0
2009-10-12 09:00:00	SPY	ETF	107.81	108.07	107.65	108.06	15457102.0
2009-10-12 10:00:00	SPY	ETF	108.06	108.09	107.82	108.02	17141245.0
2009-10-12 11:00:00	SPY	ETF	108.01	108.08	107.83	107.85	9233268.0
2009-10-12 12:00:00	SPY	ETF	107.84	107.98	107.82	107.95	7210868.0
2009-10-12 13:00:00	SPY	ETF	107.95	107.99	107.83	107.9425	7463746.0
2009-10-12 14:00:00	SPY	ETF	107.95	107.965	107.28	107.5	26995703.0
2009-10-12 15:00:00	SPY	ETF	107.5	107.74	107.47	107.74	24069340.0
2009-10-12 16:00:00	SPY	ETF	107.74	108.0	107.44	107.55	7519225.0
2009-10-12 17:00:00	SPY	ETF	107.55	107.7	107.54	107.61	326868.0
2009-10-12 18:00:00	SPY	ETF	107.61	107.61	107.56	107.6	28009.0
2009-10-12 19:00:00	SPY	ETF	107.6	107.6	107.56	107.59	92135.0
2009-10-12 04:00:00	QQQ	ETF	42.63	42.7	42.63	42.7	1098.0
2009-10-12 05:00:00	QQQ	ETF	42.71	42.74	42.71	42.74	3343.0
2009-10-12 06:00:00	QQQ	ETF	42.73	42.73	42.72	42.72	3700.0
2009-10-12 07:00:00	QQQ	ETF	42.74	42.78	42.73	42.75	229480.0
2009-10-12 08:00:00	QQQ	ETF	42.73	42.75	42.67	42.69	250541.0
2009-10-12 09:00:00	QQQ	ETF	42.69	42.84	42.6	42.8301	8377183.0
2009-10-12 10:00:00	QQQ	ETF	42.84	42.87	42.74	42.81	7372865.0
2009-10-12 11:00:00	QQQ	ETF	42.808	42.83	42.72	42.7301	3726045.0
2009-10-12 12:00:00	QQQ	ETF	42.73	42.735	42.63	42.68	4385706.0
2009-10-12 13:00:00	QQQ	ETF	42.67	42.7	42.63	42.68	2753717.0
2009-10-12 14:00:00	QQQ	ETF	42.68	42.69	42.28	42.4195	11864288.0
2009-10-12 15:00:00	QQQ	ETF	42.41	42.56	42.41	42.56	12238492.0
2009-10-12 16:00:00	QQQ	ETF	42.56	42.59	42.34	42.56	1102049.0
2009-10-12 17:00:00	QQQ	ETF	42.52	42.56	42.52	42.54	16870.0
2009-10-12 18:00:00	QQQ	ETF	42.54	42.55	42.52	42.54	17469.0
2009-10-12 19:00:00	QQQ	ETF	42.55	42.55	42.53	42.53	13800.0
2009-10-12 06:00:00	IWM	ETF	61.92	61.92	61.92	61.92	405.0
2009-10-12 07:00:00	IWM	ETF	62.04	62.04	61.95	61.97	114905.0
2009-10-12 08:00:00	IWM	ETF	61.96	62.0	61.8	61.85	156007.0
2009-10-12 09:00:00	IWM	ETF	61.83	61.985	61.68	61.985	4097324.0
2009-10-12 10:00:00	IWM	ETF	61.99	62.03	61.74	61.88	3513632.0
2009-10-12 11:00:00	IWM	ETF	61.87	61.91	61.77	61.79	1647076.0
2009-10-12 12:00:00	IWM	ETF	61.79	61.89	61.75	61.79	2359837.0
2009-10-12 13:00:00	IWM	ETF	61.79	61.85	61.7	61.78	1924015.0
2009-10-12 14:00:00	IWM	ETF	61.78	61.7899	61.14	61.33	7462621.0
2009-10-12 15:00:00	IWM	ETF	61.33	61.54	61.32	61.42	4855461.0
2009-10-12 16:00:00	IWM	ETF	61.42	61.45	61.29	61.34	493636.0
2009-10-12 17:00:00	IWM	ETF	61.33	61.4	61.33	61.35	3537.0
2009-10-12 18:00:00	IWM	ETF	61.36	61.36	61.36	61.36	600.0
2009-10-12 06:00:00	DIA	ETF	99.16	99.2	99.16	99.19	5923.0
2009-10-12 07:00:00	DIA	ETF	99.23	99.35	99.23	99.23	21060.0
2009-10-12 08:00:00	DIA	ETF	99.23	99.27	99.06	99.08	8572.0
2009-10-12 09:00:00	DIA	ETF	99.08	99.31	98.94	99.3	849218.0
2009-10-12 10:00:00	DIA	ETF	99.3	99.39	99.15	99.3695	1114387.0

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

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