PREVIEW / etf_1hour / 2010-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-20.parquet
  size:    168 KB
  rows:    5,104

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-09-20 04:00:00	SPY	ETF	112.5	112.91	112.5	112.91	9404.0
2010-09-20 05:00:00	SPY	ETF	112.92	113.11	112.9	113.06	5200.0
2010-09-20 06:00:00	SPY	ETF	113.06	113.12	113.05	113.07	29000.0
2010-09-20 07:00:00	SPY	ETF	113.0	113.05	112.91	112.94	668359.0
2010-09-20 08:00:00	SPY	ETF	112.92	113.0773	112.74	112.78	2544999.0
2010-09-20 09:00:00	SPY	ETF	112.78	113.05	112.62	112.94	18455642.0
2010-09-20 10:00:00	SPY	ETF	112.94	113.77	112.84	113.73	42585151.0
2010-09-20 11:00:00	SPY	ETF	113.74	113.84	113.61	113.6504	19925056.0
2010-09-20 12:00:00	SPY	ETF	113.6504	113.73	113.45	113.68	14560479.0
2010-09-20 13:00:00	SPY	ETF	113.6786	113.79	113.53	113.73	10941256.0
2010-09-20 14:00:00	SPY	ETF	113.74	114.18	113.66	114.14	22512993.0
2010-09-20 15:00:00	SPY	ETF	114.14	114.46	114.07	114.22	50014748.0
2010-09-20 16:00:00	SPY	ETF	114.23	114.25	112.5215	114.05	20563979.0
2010-09-20 17:00:00	SPY	ETF	114.04	114.21	114.02	114.08	3170655.0
2010-09-20 18:00:00	SPY	ETF	114.07	114.23	114.04	114.06	93652.0
2010-09-20 19:00:00	SPY	ETF	114.09	114.15	114.04	114.1	176411.0
2010-09-20 04:00:00	QQQ	ETF	48.23	48.23	48.23	48.23	100.0
2010-09-20 05:00:00	QQQ	ETF	48.24	48.25	48.24	48.25	300.0
2010-09-20 06:00:00	QQQ	ETF	48.27	48.27	48.22	48.23	7000.0
2010-09-20 07:00:00	QQQ	ETF	48.22	48.25	48.19	48.21	65447.0
2010-09-20 08:00:00	QQQ	ETF	48.19	48.23	48.12	48.14	241185.0
2010-09-20 09:00:00	QQQ	ETF	48.14	48.32	48.11	48.26	9473610.0
2010-09-20 10:00:00	QQQ	ETF	48.26	48.6601	48.2	48.61	14645969.0
2010-09-20 11:00:00	QQQ	ETF	48.61	48.65	48.5	48.52	6776834.0
2010-09-20 12:00:00	QQQ	ETF	48.52	48.57	48.4105	48.53	7814613.0
2010-09-20 13:00:00	QQQ	ETF	48.53	48.62	48.46	48.6099	4982592.0
2010-09-20 14:00:00	QQQ	ETF	48.6	48.78	48.56	48.75	9017466.0
2010-09-20 15:00:00	QQQ	ETF	48.75	48.93	48.73	48.82	18398145.0
2010-09-20 16:00:00	QQQ	ETF	48.82	48.897	48.71	48.72	2636234.0
2010-09-20 17:00:00	QQQ	ETF	48.72	48.73	48.7	48.7	50313.0
2010-09-20 18:00:00	QQQ	ETF	48.71	48.74	48.71	48.74	6950.0
2010-09-20 19:00:00	QQQ	ETF	48.73	48.78	48.73	48.75	54843.0
2010-09-20 04:00:00	IWM	ETF	65.53	65.53	65.53	65.53	100.0
2010-09-20 06:00:00	IWM	ETF	65.67	65.67	65.67	65.67	3000.0
2010-09-20 07:00:00	IWM	ETF	65.6	65.63	65.55	65.58	15900.0
2010-09-20 08:00:00	IWM	ETF	65.51	65.58	65.33	65.35	1058765.0
2010-09-20 09:00:00	IWM	ETF	65.36	65.48	64.97	65.42	6993820.0
2010-09-20 10:00:00	IWM	ETF	65.41	66.65	65.27	66.61	14041237.0
2010-09-20 11:00:00	IWM	ETF	66.61	66.67	66.23	66.32	6076761.0
2010-09-20 12:00:00	IWM	ETF	66.32	66.44	66.1	66.41	4180162.0
2010-09-20 13:00:00	IWM	ETF	66.41	66.435	66.22	66.39	1816100.0
2010-09-20 14:00:00	IWM	ETF	66.39	66.8	66.32	66.67	6996538.0
2010-09-20 15:00:00	IWM	ETF	66.67	67.2	66.62	67.03	19382780.0
2010-09-20 16:00:00	IWM	ETF	67.04	67.07	65.2607	66.85	2786910.0
2010-09-20 17:00:00	IWM	ETF	66.85	66.89	66.82	66.87	26275.0
2010-09-20 18:00:00	IWM	ETF	66.88	66.93	66.85	66.93	2700.0
2010-09-20 19:00:00	IWM	ETF	66.9	66.91	66.88	66.88	1500.0
2010-09-20 07:00:00	DIA	ETF	106.46	106.5	106.43	106.5	3200.0
2010-09-20 08:00:00	DIA	ETF	106.44	106.53	106.3	106.3	12100.0
2010-09-20 09:00:00	DIA	ETF	106.31	106.53	106.2	106.48	558636.0

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

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