PREVIEW / etf_1hour / 2010-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-14.parquet
  size:    165 KB
  rows:    5,007

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-14 04:00:00	SPY	ETF	112.53	112.53	112.4	112.4	900.0
2010-09-14 05:00:00	SPY	ETF	112.4	112.46	112.31	112.43	4964.0
2010-09-14 06:00:00	SPY	ETF	112.55	112.62	112.51	112.53	21900.0
2010-09-14 07:00:00	SPY	ETF	112.52	112.53	112.28	112.44	451925.0
2010-09-14 08:00:00	SPY	ETF	112.44	113.1	112.32	112.43	4331139.0
2010-09-14 09:00:00	SPY	ETF	112.43	112.6	112.08	112.34	22487334.0
2010-09-14 10:00:00	SPY	ETF	112.35	112.87	112.23	112.78	32349696.0
2010-09-14 11:00:00	SPY	ETF	112.78	113.24	112.75	113.2	30051096.0
2010-09-14 12:00:00	SPY	ETF	113.2	113.29	112.89	112.96	17030668.0
2010-09-14 13:00:00	SPY	ETF	112.95	113.04	112.62	112.765	16464997.0
2010-09-14 14:00:00	SPY	ETF	112.77	113.06	112.72	112.985	16966891.0
2010-09-14 15:00:00	SPY	ETF	112.99	113.22	112.63	112.65	45079265.0
2010-09-14 16:00:00	SPY	ETF	112.65	113.1425	112.325	112.43	13419382.0
2010-09-14 17:00:00	SPY	ETF	112.43	112.53	112.4	112.49	130381.0
2010-09-14 18:00:00	SPY	ETF	112.48	112.5	112.27	112.38	444935.0
2010-09-14 19:00:00	SPY	ETF	112.39	112.42	112.35	112.39	50890.0
2010-09-14 04:00:00	QQQ	ETF	47.16	47.16	47.16	47.16	7040.0
2010-09-14 05:00:00	QQQ	ETF	47.14	47.15	47.14	47.14	930.0
2010-09-14 06:00:00	QQQ	ETF	47.19	47.2	47.18	47.18	2696.0
2010-09-14 07:00:00	QQQ	ETF	47.11	47.11	47.06	47.11	26615.0
2010-09-14 08:00:00	QQQ	ETF	47.07	47.33	47.07	47.11	1367424.0
2010-09-14 09:00:00	QQQ	ETF	47.11	47.28	47.08	47.22	7063471.0
2010-09-14 10:00:00	QQQ	ETF	47.23	47.47	47.15	47.42	13230259.0
2010-09-14 11:00:00	QQQ	ETF	47.42	47.65	47.41	47.62	13724984.0
2010-09-14 12:00:00	QQQ	ETF	47.62	47.7	47.5	47.59	9513385.0
2010-09-14 13:00:00	QQQ	ETF	47.58	47.61	47.4	47.5	6898345.0
2010-09-14 14:00:00	QQQ	ETF	47.505	47.62	47.46	47.5899	9449264.0
2010-09-14 15:00:00	QQQ	ETF	47.58	47.65	47.43	47.45	10572455.0
2010-09-14 16:00:00	QQQ	ETF	47.44	47.5005	47.3	47.32	2310244.0
2010-09-14 17:00:00	QQQ	ETF	47.34	47.36	47.32	47.34	20708.0
2010-09-14 18:00:00	QQQ	ETF	47.34	47.36	47.27	47.34	41022.0
2010-09-14 19:00:00	QQQ	ETF	47.33	47.34	47.3	47.33	16800.0
2010-09-14 05:00:00	IWM	ETF	65.11	65.11	65.06	65.06	800.0
2010-09-14 06:00:00	IWM	ETF	65.23	65.23	65.23	65.23	300.0
2010-09-14 07:00:00	IWM	ETF	65.18	65.18	65.0	65.1	36250.0
2010-09-14 08:00:00	IWM	ETF	65.09	65.45	64.97	65.17	487116.0
2010-09-14 09:00:00	IWM	ETF	65.15	65.25	64.76	64.93	5327219.0
2010-09-14 10:00:00	IWM	ETF	64.94	65.33	64.83	65.22	10012163.0
2010-09-14 11:00:00	IWM	ETF	65.21	65.5	65.2	65.46	5452539.0
2010-09-14 12:00:00	IWM	ETF	65.46	65.62	65.22	65.25	5608820.0
2010-09-14 13:00:00	IWM	ETF	65.25	65.33	65.0	65.19	5083143.0
2010-09-14 14:00:00	IWM	ETF	65.1901	65.4	65.12	65.29	3400683.0
2010-09-14 15:00:00	IWM	ETF	65.3	65.415	64.99	65.005	9628398.0
2010-09-14 16:00:00	IWM	ETF	65.0	65.3363	64.92	64.96	5606025.0
2010-09-14 17:00:00	IWM	ETF	64.95	64.98	64.92	64.92	10940.0
2010-09-14 18:00:00	IWM	ETF	64.93	64.93	64.86	64.86	11323.0
2010-09-14 19:00:00	IWM	ETF	64.89	64.9	64.87	64.89	4600.0
2010-09-14 07:00:00	DIA	ETF	105.5	105.5	105.32	105.32	2410.0
2010-09-14 08:00:00	DIA	ETF	105.42	105.83	105.42	105.5	8200.0
2010-09-14 09:00:00	DIA	ETF	105.43	105.57	105.17	105.35	957787.0

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

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