PREVIEW / etf_1hour / 2010-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-20.parquet
  size:    159 KB
  rows:    4,877

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-08-20 04:00:00	SPY	ETF	107.79	107.79	107.55	107.55	4600.0
2010-08-20 05:00:00	SPY	ETF	107.61	107.67	107.32	107.32	10330.0
2010-08-20 06:00:00	SPY	ETF	107.4	107.42	106.95	106.97	59617.0
2010-08-20 07:00:00	SPY	ETF	106.95	107.31	106.95	107.18	352653.0
2010-08-20 08:00:00	SPY	ETF	107.16	107.38	107.03	107.38	2711382.0
2010-08-20 09:00:00	SPY	ETF	107.38	107.69	107.0	107.28	30608425.0
2010-08-20 10:00:00	SPY	ETF	107.28	107.5	107.05	107.27	33045154.0
2010-08-20 11:00:00	SPY	ETF	107.26	107.9376	106.7499	106.8026	26456444.0
2010-08-20 12:00:00	SPY	ETF	106.81	107.1	106.8	107.08	12590155.0
2010-08-20 13:00:00	SPY	ETF	107.08	107.29	107.05	107.15	12678542.0
2010-08-20 14:00:00	SPY	ETF	107.15	107.71	107.14	107.53	24037191.0
2010-08-20 15:00:00	SPY	ETF	107.54	107.7	107.4	107.54	37112490.0
2010-08-20 16:00:00	SPY	ETF	107.54	108.42	106.885	107.63	26412791.0
2010-08-20 17:00:00	SPY	ETF	107.61	107.71	107.51	107.61	2420080.0
2010-08-20 18:00:00	SPY	ETF	107.62	108.0	107.52	107.62	142511.0
2010-08-20 19:00:00	SPY	ETF	107.64	107.7	107.61	107.7	15215.0
2010-08-20 05:00:00	QQQ	ETF	44.7	44.7	44.69	44.69	300.0
2010-08-20 06:00:00	QQQ	ETF	44.62	44.62	44.51	44.51	26538.0
2010-08-20 07:00:00	QQQ	ETF	44.53	44.69	44.53	44.65	59324.0
2010-08-20 08:00:00	QQQ	ETF	44.65	44.7	44.59	44.7	354348.0
2010-08-20 09:00:00	QQQ	ETF	44.7	44.89	44.61	44.8	8292898.0
2010-08-20 10:00:00	QQQ	ETF	44.8	44.95	44.64	44.73	16828554.0
2010-08-20 11:00:00	QQQ	ETF	44.73	44.77	44.54	44.56	5917235.0
2010-08-20 12:00:00	QQQ	ETF	44.5589	44.72	44.55	44.71	3240174.0
2010-08-20 13:00:00	QQQ	ETF	44.7105	44.82	44.7	44.77	4381245.0
2010-08-20 14:00:00	QQQ	ETF	44.7705	45.03	44.76	44.955	6510302.0
2010-08-20 15:00:00	QQQ	ETF	44.96	44.99	44.86	44.92	8735876.0
2010-08-20 16:00:00	QQQ	ETF	44.92	45.0	44.6902	44.92	4414127.0
2010-08-20 17:00:00	QQQ	ETF	44.92	44.96	44.8458	44.95	1013200.0
2010-08-20 18:00:00	QQQ	ETF	44.94	44.97	44.93	44.97	6690.0
2010-08-20 19:00:00	QQQ	ETF	44.95	44.97	44.93	44.94	17050.0
2010-08-20 07:00:00	IWM	ETF	60.53	60.68	60.51	60.6	16686.0
2010-08-20 08:00:00	IWM	ETF	60.6	60.8	60.53	60.8	224734.0
2010-08-20 09:00:00	IWM	ETF	60.81	61.02	60.3499	60.66	7057990.0
2010-08-20 10:00:00	IWM	ETF	60.66	60.77	60.42	60.53	7247503.0
2010-08-20 11:00:00	IWM	ETF	60.52	60.62	60.14	60.18	7484130.0
2010-08-20 12:00:00	IWM	ETF	60.18	60.49	60.17	60.46	3717007.0
2010-08-20 13:00:00	IWM	ETF	60.47	60.64	60.46	60.59	3420590.0
2010-08-20 14:00:00	IWM	ETF	60.59	61.08	60.4092	60.94	6382305.0
2010-08-20 15:00:00	IWM	ETF	60.94	61.19	60.8399	61.14	10617246.0
2010-08-20 16:00:00	IWM	ETF	61.14	62.12	61.09	61.19	5549762.0
2010-08-20 17:00:00	IWM	ETF	61.22	61.23	61.1164	61.23	10001902.0
2010-08-20 18:00:00	IWM	ETF	61.2	61.24	61.11	61.11	1100.0
2010-08-20 19:00:00	IWM	ETF	61.2	61.25	61.19	61.19	1100.0
2010-08-20 04:00:00	DIA	ETF	102.26	102.26	102.26	102.26	200.0
2010-08-20 06:00:00	DIA	ETF	102.29	102.29	101.93	101.93	34100.0
2010-08-20 07:00:00	DIA	ETF	101.91	102.19	101.91	102.12	13800.0
2010-08-20 08:00:00	DIA	ETF	102.14	102.29	102.01	102.27	67860.0
2010-08-20 09:00:00	DIA	ETF	102.27	102.48	101.76	102.009	1397781.0
2010-08-20 10:00:00	DIA	ETF	102.0001	102.15	101.73	101.94	1467670.0

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

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