PREVIEW / etf_1hour / 2010-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-09.parquet
  size:    161 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-06-09 04:00:00	SPY	ETF	106.39	106.41	106.21	106.23	2750.0
2010-06-09 05:00:00	SPY	ETF	106.2	106.28	105.98	106.22	21600.0
2010-06-09 06:00:00	SPY	ETF	106.19	106.67	106.16	106.64	44750.0
2010-06-09 07:00:00	SPY	ETF	106.57	107.1	106.55	107.07	1455659.0
2010-06-09 08:00:00	SPY	ETF	107.07	107.27	105.9	107.1	7303668.0
2010-06-09 09:00:00	SPY	ETF	107.1	107.42	106.95	107.19	33788407.0
2010-06-09 10:00:00	SPY	ETF	107.19	107.55	106.83	107.541	36134073.0
2010-06-09 11:00:00	SPY	ETF	107.54	108.28	107.4601	108.01	31629319.0
2010-06-09 12:00:00	SPY	ETF	108.01	108.15	107.77	107.77	13958714.0
2010-06-09 13:00:00	SPY	ETF	107.7774	108.2	107.41	107.62	17778901.0
2010-06-09 14:00:00	SPY	ETF	107.6217	107.72	106.63	106.66	32648527.0
2010-06-09 15:00:00	SPY	ETF	106.65	106.9667	105.6	106.01	73216103.0
2010-06-09 16:00:00	SPY	ETF	106.02	108.2	105.91	105.99	10038529.0
2010-06-09 17:00:00	SPY	ETF	105.99	106.01	105.75	105.85	1378301.0
2010-06-09 18:00:00	SPY	ETF	105.8	106.0	105.71	105.94	174338.0
2010-06-09 19:00:00	SPY	ETF	105.98	106.01	105.8	106.0	94210.0
2010-06-09 04:00:00	QQQ	ETF	44.14	44.14	44.14	44.14	3100.0
2010-06-09 05:00:00	QQQ	ETF	43.94	43.94	43.94	43.94	200.0
2010-06-09 06:00:00	QQQ	ETF	44.03	44.15	44.03	44.15	3000.0
2010-06-09 07:00:00	QQQ	ETF	44.2	44.38	44.17	44.35	174789.0
2010-06-09 08:00:00	QQQ	ETF	44.36	44.54	44.19	44.44	4702610.0
2010-06-09 09:00:00	QQQ	ETF	44.44	44.56	44.19	44.4199	12195451.0
2010-06-09 10:00:00	QQQ	ETF	44.41	44.55	44.18	44.55	15038865.0
2010-06-09 11:00:00	QQQ	ETF	44.55	44.91	44.53	44.75	10762070.0
2010-06-09 12:00:00	QQQ	ETF	44.76	44.89	44.66	44.6699	5202199.0
2010-06-09 13:00:00	QQQ	ETF	44.67	44.73	44.48	44.58	8341200.0
2010-06-09 14:00:00	QQQ	ETF	44.58	44.62	44.15	44.16	9509389.0
2010-06-09 15:00:00	QQQ	ETF	44.16	44.26	43.69	43.83	25744157.0
2010-06-09 16:00:00	QQQ	ETF	43.83	44.54	43.81	43.85	4387865.0
2010-06-09 17:00:00	QQQ	ETF	43.83	44.2306	43.77	43.77	1057992.0
2010-06-09 18:00:00	QQQ	ETF	43.77	43.84	43.74	43.81	117664.0
2010-06-09 19:00:00	QQQ	ETF	43.8	43.84	43.74	43.82	24063.0
2010-06-09 05:00:00	IWM	ETF	61.38	61.38	61.38	61.38	100.0
2010-06-09 06:00:00	IWM	ETF	61.47	61.75	61.47	61.75	15500.0
2010-06-09 07:00:00	IWM	ETF	61.77	62.09	61.76	62.05	328038.0
2010-06-09 08:00:00	IWM	ETF	62.04	62.45	61.78	62.34	3953239.0
2010-06-09 09:00:00	IWM	ETF	62.33	62.73	62.18	62.42	17736610.0
2010-06-09 10:00:00	IWM	ETF	62.4281	62.65	62.0	62.65	13680320.0
2010-06-09 11:00:00	IWM	ETF	62.64	63.42	62.47	63.06	11976454.0
2010-06-09 12:00:00	IWM	ETF	63.05	63.22	62.78	62.79	4409806.0
2010-06-09 13:00:00	IWM	ETF	62.8	63.11	62.7	62.89	6447118.0
2010-06-09 14:00:00	IWM	ETF	62.891	62.97	62.17	62.19	10468274.0
2010-06-09 15:00:00	IWM	ETF	62.18	62.36	61.59	61.93	22494840.0
2010-06-09 16:00:00	IWM	ETF	61.93	63.0187	61.8702	61.96	6044730.0
2010-06-09 17:00:00	IWM	ETF	61.93	61.97	61.72	61.75	26746.0
2010-06-09 18:00:00	IWM	ETF	61.75	61.79	61.71	61.77	19240.0
2010-06-09 19:00:00	IWM	ETF	61.76	61.89	61.75	61.8	4476.0
2010-06-09 04:00:00	DIA	ETF	99.18	99.18	99.07	99.07	1000.0
2010-06-09 05:00:00	DIA	ETF	99.09	99.09	99.01	99.01	3700.0
2010-06-09 07:00:00	DIA	ETF	99.72	99.77	99.68	99.77	626.0

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

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