PREVIEW / etf_1hour / 2010-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-16.parquet
  size:    158 KB
  rows:    4,894

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-16 04:00:00	SPY	ETF	108.11	108.11	107.76	107.8	2857.0
2010-08-16 05:00:00	SPY	ETF	107.86	108.06	107.72	108.0	1024.0
2010-08-16 06:00:00	SPY	ETF	107.91	108.07	107.88	107.95	15400.0
2010-08-16 07:00:00	SPY	ETF	107.91	107.98	107.65	107.79	355285.0
2010-08-16 08:00:00	SPY	ETF	107.81	108.55	107.61	107.89	2698693.0
2010-08-16 09:00:00	SPY	ETF	107.89	108.0	107.18	107.8	28358790.0
2010-08-16 10:00:00	SPY	ETF	107.8	108.49	107.66	108.33	26565022.0
2010-08-16 11:00:00	SPY	ETF	108.34	108.45	108.07	108.4	17053734.0
2010-08-16 12:00:00	SPY	ETF	108.4	108.61	108.34	108.47	11991621.0
2010-08-16 13:00:00	SPY	ETF	108.48	108.57	108.31	108.36	7625151.0
2010-08-16 14:00:00	SPY	ETF	108.36	108.46	107.88	107.93	17180431.0
2010-08-16 15:00:00	SPY	ETF	107.92	108.33	107.82	108.28	28810399.0
2010-08-16 16:00:00	SPY	ETF	108.27	108.4519	107.955	108.29	6449627.0
2010-08-16 17:00:00	SPY	ETF	108.31	108.38	108.3	108.36	85834.0
2010-08-16 18:00:00	SPY	ETF	108.33	108.36	108.26	108.29	161527.0
2010-08-16 19:00:00	SPY	ETF	108.29	108.29	108.07	108.11	180743.0
2010-08-16 04:00:00	QQQ	ETF	44.7	44.7	44.6	44.6	2000.0
2010-08-16 06:00:00	QQQ	ETF	44.65	44.67	44.65	44.66	50518.0
2010-08-16 07:00:00	QQQ	ETF	44.63	44.66	44.53	44.56	27120.0
2010-08-16 08:00:00	QQQ	ETF	44.59	44.72	44.51	44.61	240625.0
2010-08-16 09:00:00	QQQ	ETF	44.6	44.81	44.3	44.73	9954393.0
2010-08-16 10:00:00	QQQ	ETF	44.73	45.04	44.67	44.98	8414704.0
2010-08-16 11:00:00	QQQ	ETF	44.98	45.01	44.84	44.97	4051602.0
2010-08-16 12:00:00	QQQ	ETF	44.97	45.11	44.95	44.98	7146021.0
2010-08-16 13:00:00	QQQ	ETF	44.98	45.0102	44.88	44.91	3673444.0
2010-08-16 14:00:00	QQQ	ETF	44.92	44.96	44.66	44.679	4354610.0
2010-08-16 15:00:00	QQQ	ETF	44.6799	44.83	44.58	44.8	8058860.0
2010-08-16 16:00:00	QQQ	ETF	44.8	44.82	44.7002	44.81	4949541.0
2010-08-16 17:00:00	QQQ	ETF	44.82	44.84	44.8	44.8	12000.0
2010-08-16 18:00:00	QQQ	ETF	44.84	44.84	44.83	44.83	7385.0
2010-08-16 19:00:00	QQQ	ETF	44.82	44.82	44.73	44.75	78655.0
2010-08-16 04:00:00	IWM	ETF	61.0	61.0	60.71	60.71	200.0
2010-08-16 05:00:00	IWM	ETF	60.87	60.87	60.87	60.87	100.0
2010-08-16 06:00:00	IWM	ETF	60.84	60.94	60.81	60.91	4338.0
2010-08-16 07:00:00	IWM	ETF	60.82	60.82	60.58	60.68	14900.0
2010-08-16 08:00:00	IWM	ETF	61.38	61.38	60.54	60.725	134339.0
2010-08-16 09:00:00	IWM	ETF	60.73	61.2	60.38	61.01	9301347.0
2010-08-16 10:00:00	IWM	ETF	61.01	61.73	60.85	61.48	9727235.0
2010-08-16 11:00:00	IWM	ETF	61.48	61.53	61.14	61.44	3918837.0
2010-08-16 12:00:00	IWM	ETF	61.44	61.92	61.41	61.8	3949889.0
2010-08-16 13:00:00	IWM	ETF	61.8001	61.8899	61.56	61.61	1764078.0
2010-08-16 14:00:00	IWM	ETF	61.62	61.69	61.21	61.28	3443211.0
2010-08-16 15:00:00	IWM	ETF	61.27	61.55	61.02	61.54	9570406.0
2010-08-16 16:00:00	IWM	ETF	61.55	61.8295	60.9	61.61	6195841.0
2010-08-16 17:00:00	IWM	ETF	61.61	61.66	61.61	61.63	1600.0
2010-08-16 18:00:00	IWM	ETF	61.73	61.73	61.73	61.73	500.0
2010-08-16 19:00:00	IWM	ETF	61.62	61.62	61.52	61.52	2400.0
2010-08-16 06:00:00	DIA	ETF	103.0	103.0	102.95	102.95	500.0
2010-08-16 07:00:00	DIA	ETF	102.95	102.95	102.8	102.9	7700.0
2010-08-16 08:00:00	DIA	ETF	102.97	103.17	102.81	103.06	28500.0

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

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