PREVIEW / etf_1hour / 2010-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-08.parquet
  size:    160 KB
  rows:    4,890

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-08 04:00:00	SPY	ETF	109.6	109.6	109.4	109.47	14100.0
2010-09-08 05:00:00	SPY	ETF	109.52	109.52	109.25	109.37	5750.0
2010-09-08 06:00:00	SPY	ETF	109.44	110.01	109.4	109.96	75525.0
2010-09-08 07:00:00	SPY	ETF	109.93	110.17	109.88	109.98	710389.0
2010-09-08 08:00:00	SPY	ETF	109.15	110.22	109.15	109.95	2660181.0
2010-09-08 09:00:00	SPY	ETF	109.94	110.35	109.45	110.29	18732641.0
2010-09-08 10:00:00	SPY	ETF	110.29	110.68	110.26	110.518	23047482.0
2010-09-08 11:00:00	SPY	ETF	110.51	110.76	110.48	110.56	12326867.0
2010-09-08 12:00:00	SPY	ETF	110.57	110.85	110.55	110.74	11068794.0
2010-09-08 13:00:00	SPY	ETF	110.75	110.77	110.22	110.35	14954236.0
2010-09-08 14:00:00	SPY	ETF	110.34	110.64	110.1	110.49	21615830.0
2010-09-08 15:00:00	SPY	ETF	110.5	110.72	110.2	110.39	31320700.0
2010-09-08 16:00:00	SPY	ETF	110.4	110.655	109.895	110.53	10295775.0
2010-09-08 17:00:00	SPY	ETF	110.54	110.74	110.5	110.65	295630.0
2010-09-08 18:00:00	SPY	ETF	110.63	110.63	110.41	110.57	52487.0
2010-09-08 19:00:00	SPY	ETF	110.56	110.68	110.56	110.66	58891.0
2010-09-08 04:00:00	QQQ	ETF	45.67	45.67	45.67	45.67	200.0
2010-09-08 06:00:00	QQQ	ETF	45.89	45.9	45.87	45.87	3000.0
2010-09-08 07:00:00	QQQ	ETF	45.85	45.96	45.85	45.87	192702.0
2010-09-08 08:00:00	QQQ	ETF	45.88	45.99	45.83	45.87	1077454.0
2010-09-08 09:00:00	QQQ	ETF	45.87	46.08	45.81	46.04	9487100.0
2010-09-08 10:00:00	QQQ	ETF	46.05	46.24	46.02	46.17	12362847.0
2010-09-08 11:00:00	QQQ	ETF	46.16	46.3	46.16	46.24	7366770.0
2010-09-08 12:00:00	QQQ	ETF	46.24	46.45	46.23	46.39	6306575.0
2010-09-08 13:00:00	QQQ	ETF	46.39	46.3978	46.19	46.245	5865968.0
2010-09-08 14:00:00	QQQ	ETF	46.24	46.35	46.14	46.285	6787106.0
2010-09-08 15:00:00	QQQ	ETF	46.29	46.39	46.18	46.25	11842776.0
2010-09-08 16:00:00	QQQ	ETF	46.26	46.395	45.6869	46.23	2681241.0
2010-09-08 17:00:00	QQQ	ETF	46.23	46.34	46.23	46.33	111509.0
2010-09-08 18:00:00	QQQ	ETF	46.3	46.3	46.25	46.27	5308.0
2010-09-08 19:00:00	QQQ	ETF	46.28	46.33	46.27	46.27	3832.0
2010-09-08 05:00:00	IWM	ETF	62.88	62.88	62.88	62.88	200.0
2010-09-08 06:00:00	IWM	ETF	63.34	63.37	63.34	63.36	1400.0
2010-09-08 07:00:00	IWM	ETF	63.3	63.51	63.28	63.37	177965.0
2010-09-08 08:00:00	IWM	ETF	63.37	63.52	63.27	63.27	208805.0
2010-09-08 09:00:00	IWM	ETF	63.27	63.67	63.18	63.5801	4447732.0
2010-09-08 10:00:00	IWM	ETF	63.58	63.88	63.52	63.76	7583084.0
2010-09-08 11:00:00	IWM	ETF	63.76	63.995	63.66	63.6701	4805239.0
2010-09-08 12:00:00	IWM	ETF	63.67	63.89	63.64	63.76	4593246.0
2010-09-08 13:00:00	IWM	ETF	63.76	63.77	63.25	63.4	7620776.0
2010-09-08 14:00:00	IWM	ETF	63.4	63.63	63.23	63.49	3920213.0
2010-09-08 15:00:00	IWM	ETF	63.49	63.75	63.32	63.49	9915416.0
2010-09-08 16:00:00	IWM	ETF	63.49	63.85	63.0117	63.0117	5265253.0
2010-09-08 17:00:00	IWM	ETF	63.56	63.66	63.55	63.63	5700.0
2010-09-08 18:00:00	IWM	ETF	63.62	63.65	63.6	63.65	4800.0
2010-09-08 19:00:00	IWM	ETF	63.7	63.7	63.69	63.69	700.0
2010-09-08 07:00:00	DIA	ETF	103.97	103.97	103.9	103.9	10800.0
2010-09-08 08:00:00	DIA	ETF	103.85	103.99	103.76	103.78	16000.0
2010-09-08 09:00:00	DIA	ETF	103.75	104.1699	103.68	104.09	1316194.0
2010-09-08 10:00:00	DIA	ETF	104.09	104.3405	104.09	104.2	1417285.0

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

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