PREVIEW / etf_1hour / 2010-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-11.parquet
  size:    153 KB
  rows:    4,729

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-02-11 04:00:00	SPY	ETF	107.48	107.49	107.22	107.34	5800.0
2010-02-11 05:00:00	SPY	ETF	107.35	107.36	107.35	107.36	200.0
2010-02-11 06:00:00	SPY	ETF	107.15	107.49	106.82	107.24	132010.0
2010-02-11 07:00:00	SPY	ETF	107.34	107.4	106.94	107.25	731669.0
2010-02-11 08:00:00	SPY	ETF	107.23	107.47	106.95	107.07	6002456.0
2010-02-11 09:00:00	SPY	ETF	107.06	107.06	106.25	106.71	29116255.0
2010-02-11 10:00:00	SPY	ETF	106.71	107.17	106.46	106.64	34447920.0
2010-02-11 11:00:00	SPY	ETF	106.64	107.96	106.62	107.78	40260026.0
2010-02-11 12:00:00	SPY	ETF	107.78	108.02	107.71	107.81	18803601.0
2010-02-11 13:00:00	SPY	ETF	107.81	108.25	107.7	107.9905	29792390.0
2010-02-11 14:00:00	SPY	ETF	107.99	108.25	107.91	108.05	17739159.0
2010-02-11 15:00:00	SPY	ETF	108.06	108.18	107.82	108.09	27727364.0
2010-02-11 16:00:00	SPY	ETF	108.1	108.37	106.75	108.31	11289165.0
2010-02-11 17:00:00	SPY	ETF	108.31	108.43	107.0472	108.27	1267141.0
2010-02-11 18:00:00	SPY	ETF	108.27	108.29	108.14	108.17	86052.0
2010-02-11 19:00:00	SPY	ETF	108.18	108.23	108.06	108.09	157068.0
2010-02-11 06:00:00	QQQ	ETF	43.2	43.2	43.07	43.12	128356.0
2010-02-11 07:00:00	QQQ	ETF	43.12	43.19	43.04	43.16	434973.0
2010-02-11 08:00:00	QQQ	ETF	43.13	43.23	43.04	43.12	913058.0
2010-02-11 09:00:00	QQQ	ETF	43.11	43.11	42.76	42.87	8595040.0
2010-02-11 10:00:00	QQQ	ETF	42.8701	43.09	42.77	42.91	12143471.0
2010-02-11 11:00:00	QQQ	ETF	42.91	43.63	42.91	43.5901	19059617.0
2010-02-11 12:00:00	QQQ	ETF	43.6	43.75	43.5776	43.65	10472543.0
2010-02-11 13:00:00	QQQ	ETF	43.65	43.78	43.59	43.72	5859288.0
2010-02-11 14:00:00	QQQ	ETF	43.7199	43.79	43.63	43.6975	8402018.0
2010-02-11 15:00:00	QQQ	ETF	43.7	43.75	43.59	43.66	10207932.0
2010-02-11 16:00:00	QQQ	ETF	43.67	43.76	43.037	43.75	6981944.0
2010-02-11 17:00:00	QQQ	ETF	43.76	43.78	43.0369	43.73	4053095.0
2010-02-11 18:00:00	QQQ	ETF	43.74	43.75	43.71	43.73	25193.0
2010-02-11 19:00:00	QQQ	ETF	43.71	43.74	43.63	43.63	85057.0
2010-02-11 07:00:00	IWM	ETF	59.63	59.7	59.53	59.68	26845.0
2010-02-11 08:00:00	IWM	ETF	59.64	59.85	59.59	59.68	882768.0
2010-02-11 09:00:00	IWM	ETF	59.67	59.67	59.0	59.3	7062833.0
2010-02-11 10:00:00	IWM	ETF	59.3	59.63	59.13	59.3	7590943.0
2010-02-11 11:00:00	IWM	ETF	59.3	60.15	59.28	60.04	8145976.0
2010-02-11 12:00:00	IWM	ETF	60.04	60.24	60.035	60.14	3408744.0
2010-02-11 13:00:00	IWM	ETF	60.14	60.37	60.12	60.26	3074059.0
2010-02-11 14:00:00	IWM	ETF	60.27	60.5	60.15	60.41	5077483.0
2010-02-11 15:00:00	IWM	ETF	60.41	60.62	60.325	60.59	9453871.0
2010-02-11 16:00:00	IWM	ETF	60.59	60.79	59.25	60.67	2621603.0
2010-02-11 17:00:00	IWM	ETF	60.73	60.87	59.6096	60.7	2074298.0
2010-02-11 18:00:00	IWM	ETF	60.74	60.74	60.65	60.65	13923.0
2010-02-11 19:00:00	IWM	ETF	60.58	60.65	60.57	60.59	1300.0
2010-02-11 06:00:00	DIA	ETF	100.65	100.65	100.65	100.65	600.0
2010-02-11 07:00:00	DIA	ETF	100.68	100.68	100.6	100.6	200.0
2010-02-11 08:00:00	DIA	ETF	100.6	100.93	100.58	100.65	102180.0
2010-02-11 09:00:00	DIA	ETF	100.64	100.64	99.87	100.3	1635004.0
2010-02-11 10:00:00	DIA	ETF	100.31	100.73	100.11	100.27	1663367.0
2010-02-11 11:00:00	DIA	ETF	100.28	101.52	100.24	101.36	2102084.0
2010-02-11 12:00:00	DIA	ETF	101.37	101.56	101.29	101.37	643773.0

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

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